Free 30-Day Trial

No Credit Card Required

Clarizen Tags

on-demand project management Web 2.0 Design partners Agile Enterprise 2.0 offshore project collaboration online project management Collaboration SaaS roadmap project management

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY n.created DESC limit 5' at line 5 query: SELECT distinct n.nid, n.created, n.title, l.comment_count as totalcount FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid ,term_node tn,term_data td WHERE n.nid =tn.nid and tn.tid = td.tid and n.type = 'forum' AND n.status = 1 and td.tid ) ORDER BY n.created DESC limit 5 in /var/www/clarizen-final51/sec/includes/database.mysql.inc on line 172.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY totalcount DESC limit 5' at line 5 query: SELECT distinct n.nid, n.title, l.comment_count as totalcount FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid ,term_node tn,term_data td WHERE n.nid =tn.nid and tn.tid = td.tid and n.type = 'forum' AND n.status = 1 and td.tid ) ORDER BY totalcount DESC limit 5 in /var/www/clarizen-final51/sec/includes/database.mysql.inc on line 172.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY v.value DESC limit 5' at line 5 query: SELECT distinct n.nid, n.title, l.comment_count ,v.value FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN votingapi_cache v ON n.nid = v.content_id ,term_node tn,term_data td WHERE n.nid =tn.nid and tn.tid = td.tid and v.function='count' and n.type = 'forum' AND n.status = 1 and td.tid ) ORDER BY v.value DESC limit 5 in /var/www/clarizen-final51/sec/includes/database.mysql.inc on line 172.

Notifications from Clarizen

Posted by admin in Misc.
May 10th, 2007

1 Comments

points

I recieved a mail from clarizen reporting warnings and issues that need to be resolved in my projects...
Stuff like ...
Planning component Internal Beta2 in project Stanton is past due date
Task Image crop due on 4/24/2007 5:00:00 PM has no resources assigned
Task create ccks due on 4/19/2007 5:00:00 PM has resource assigned without license
etc...

I think the mail should be a bit more customized explaining each of the warning and sorted first by Project and then by the type of problems encountered.

There should also be a small text in the beginning explaining the process...
I enjoy the project and it's useful to me I think the mail reports are great - the information simply needs to be delivered with a bit more structure and context
just my 2cents
Lior

Tagged as: