new install MySQL error rPath installer

[amattke]

Sugar 4.2.1a w/OS installed from rPath installer.

Whenever Sugar tries to write or read from the database I'm getting a large error reguarding bad SQL syntax.
I assume the rPath installer is built to setup a working copy of SugarCRM OpenSource?

Error retrieving Account list: Query Failed SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , jt1.user_name assigned_user_name, meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings AND jt0.deleted=0 AND jt1.deleted=0 where ((meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, tasks.date_due as date_start , jt1.user_name assigned_user_name, tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks AND jt0.deleted=0 AND jt1.deleted=0 where ((tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , jt1.user_name assigned_user_name, calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls AND jt0.deleted=0 AND jt1.deleted=0 where ((calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start 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 jt0.deleted=0 AND jt1.deleted=0 where ((meetings.status='Planned')) AND mee' at line 1


If anyone has suggestions or ideas, please let me know. I am looking at Sugar OpenSource to demo it against some other CRM software.

[nathanbthomas]

amatttke,

This is an error in the /etc/cron.d/sugarcrm entry; it says 'root' instead of 'apache'. It causes the /usr/share/sugarcrm/cache/modules directory to be owned by root. If you simply edit the cron.d to change 'root' to 'apache' and the delete the modules directory, then the next time it needs the modules directory it will recreate it with the correct permisions and the system should work.

This issue is addressed here as well:

http://www.sugarforge.org/forum/foru...9&forum_id=681

This has been fixed in the 4.2.1b appliance. Unfortunately, the separate bug listed here makes that upgrade process a little more difficult than usual:

http://www.sugarforge.org/forum/foru...1&forum_id=681

I have added test cases for both of these to the release process