CustomerCentrix

I wasn't planning to spend any time with SugarCRM today, except that a couple of tasks came to mind that I thought I would save for later (on something other than a sticky note). Navigating from the Sugar home page to a Project Tasks gave me this error:

Error running count query for ProjectTask List: Query Failed:( SELECT count(*) FROM meetings where ( meetings.parent_id= '4e3532e4-9710-cfcc-9993-430122451097' AND meetings.parent_type='ProjectTask' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) FROM calls where ( calls.parent_id= '4e3532e4-9710-cfcc-9993-430122451097' AND calls.parent_type='ProjectTask' 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 where ( meetings.parent_id= '4e3532e4-9710-cfcc' at line 1

Formatting this a little to make it easier to read the SQL gives me:

( SELECT count(*)
FROM meetings where
( meetings.parent_id= '4e3532e4-9710-cfcc-9993-430122451097' AND meetings.parent_type='ProjectTask' AND meetings.deleted=0 AND (meetings.status='Planned'))
AND meetings.deleted=0 )
UNION ALL
( SELECT count(*)
FROM calls where
( calls.parent_id= '4e3532e4-9710-cfcc-9993-430122451097' AND calls.parent_type='ProjectTask' AND calls.deleted=0 AND (calls.status='Planned'))
AND calls.deleted=0 )

I'm not familiar with the tables or structure of the db but don't see anything obviously wrong with this. I'll run it against the db to see if I get the same error - yes, same error. Isolate the first query to make sure that line 1 is referring to first part of the union and get same error as expected. On a hunch, remove what looks like redundant parenthesis at beginning and end and error is gone. Query working, but implications are not too great. It appears that the query building mechanisms are not working as expected, which could represent an error due to version differences in MySQL (and we are running an older version than the Sugar requirements specify). Or in simpler terms, the code and db structure could be working fine, but we don't have the right database version. Our version is 3.23.58-16.FC2.1 and the specified requirements are MySQL version 4.0.x or 4.1.x (best 4.0.23). So, my choice is to start debugging, try upgrading MySQL (with several other applications running fine on same server) or ignore it for now. It appears that Sugar is still functional, so I will move on to something else. I am inclined to jump in to debugging or upgrading, but the wiser choice is to move on to more important things that were planned for today.