While viewing any of the data in SuagarCRM which is stored in the database, it could be a problem that at the footer of the application you can get the error message which says
Error running count query for Email List: Query Failed:( SELECT
count(*) FROM contacts INNER JOIN emails_contacts ON
(contacts.id=emails_contacts.contact_id AND
emails_contacts.email_id='53f160c0-6933-3322-4b53-43f16edeef5c') where
( emails_contacts.deleted=0 AND contacts.deleted=0) AND
contacts.deleted=0 )::MySQL error 1064: You have an error in your SQL
syntax near '( SELECT count(*) FROM contacts INNER JOIN emails_contacts
ON (contacts.id=emai' at line 1Actaully this error message comes if the version of MySQL is below 4.0.x. Upgrade your MySQL with the version 4.0.x to get rid of this error message.
The reason for this error is that the MySQL version below 4.0.x is not able to run the query INNER JOIN.
Posted by Moses Paik 
