CustomerCentrix

Applied this one to fix some bugs, and I think that there seems to be no end to the problems with Sugar. The update applied without any difficulty, but I am seeing SQL errors and missing data. I hate to give up on this, but this seems to be a bug ridden exercise trying to get Sugar working consistently.

At the bottom of a newly imported contact:

Error running count query for Contact List: Query Failed:( SELECT count(*) FROM meetings INNER JOIN meetings_contacts ON (meetings.id=meetings_contacts.meeting_id AND meetings_contacts.contact_id='f0561b7c-19f8-8b2a-7c1a-4349cc074b86') where ( meetings_contacts.deleted=0 AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) FROM tasks where ( tasks.contact_id= 'f0561b7c-19f8-8b2a-7c1a-4349cc074b86' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) FROM calls INNER JOIN calls_contacts ON (calls.id=calls_contacts.call_id AND calls_contacts.contact_id='f0561b7c-19f8-8b2a-7c1a-4349cc074b86') where ( calls_contacts.deleted=0 AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 )::MySQL error 1064: You have an error in your SQL syntax near '( SELECT count(*) FROM meetings INNER JOIN meetings_contacts ON (meetings.id=me' at line 1