SQL error for "Projects" subpanel

[sjobeck]

Running SugarCRM 4.5 build 1124 on CentOS 4.4 & mySQL 5.x on a RAID5 array on a brand new ProLiant DL380. I dont know if this broke when we upgraded version of mySQL or at some other point but it has been at least a month that this has been plaguing us. There are actually many places inside Sugar where this error occurs, I am using the example of the Projects section. When trying to view a Project, its tasks do not show on the bottom of the page as expected.

The error is below

Thanks so very much to any one who can lend a hand.

Cheers.

Jason Sjobeck
JID sjobeck@jabber.org





Error retrieving Project list: Query Failed: ( SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , meetings.assigned_user_id , 'meetings' panel_name FROM meetings AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id= '9ce8df57-c671-e321-c997-44e912661d55' AND meetings.parent_type='Project' AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , calls.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , calls.assigned_user_id , 'calls' panel_name FROM calls AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id= '9ce8df57-c671-e321-c997-44e912661d55' AND calls.parent_type='Project' AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.name , ' ' status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name , notes.contact_id , jt0.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, notes.date_modified , ' ' assigned_user_name , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.filename , notes.created_by , 'notes' panel_name FROM notes LEFT JOIN contacts jt0 ON jt0.id= notes.contact_id AND jt0.deleted=0 AND jt0.deleted=0 where ( notes.parent_id= '9ce8df57-c671-e321-c997-44e912661d55' AND notes.parent_type='Project' AND notes.deleted=0) AND notes.deleted=0 ) UNION ALL ( SELECT emails.id , emails.name , emails.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , emails.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , emails.assigned_user_id , 'emails' panel_name FROM emails AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= emails.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where emails.deleted=0 ) ORDER BY date_modified desc LIMIT 0,10::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= meetings.assigned_user_i' at line 1