Error in Projects

[devpp]

OS Windows Windows 2003
Sugar Open Source 5.0.0b
Web Server IIS 6
PHP 4.4.7
MySQL 5.0

I get this error when accessing a project in project list

Error running count query for Project List: Query Failed SELECT count(*) c FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id= '1f18eec1-3ebf-f158-5728-47de728cb38a' AND meetings.parent_type='Project' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( taskscontacts.parent_id= '1f18eec1-3ebf-f158-5728-47de728cb38a' AND taskscontacts.parent_type='Project' AND taskscontacts.deleted=0 AND (taskscontacts.status='Not Started' OR taskscontacts.status='In Progress' OR taskscontacts.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id= '1f18eec1-3ebf-f158-5728-47de728cb38a' AND calls.parent_type='Project' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 )::MySQL error 1064: 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 'AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.as

Any help would be great

Thanks

[jfuller70]

we are getting the same error. are you using a default install or and added modules?