When Saving a meeting, I receive a mysql error message as follows

[Harbeston]

I must have put this following message in the wrong place the first time, so I am trying it here.

Not sure what happened in the bug section of sugarforge, The email said resolution was Customer Input and gave me a link to a sugarcrm web site that required a login.

I am using Centos v4.2 Linux(Redhat EL 4.2 based). This includes php v4.3.9, mysql v4.1.12, and apache v2.0.52.

Hope this info helps!

Regards

Error retrieving Meeting list: Query Failed: SELECT users.id , ' ' m_accept_status_fields , ' ' meeting_id , users.first_name , users.last_name , as name, users.user_name , users.email1 , users.phone_work , users.created_by , 'users' panel_name FROM users INNER JOIN meetings_users ON (users.id=meetings_users.user_id AND meetings_users.meeting_id='892fae74-621a-9382-e024-440f4a8addeb') where ( meetings_users.deleted=0 AND users.deleted=0) AND users.deleted=0 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 'as name, users.user_name , users.email1 , users.phone_work , users.created_by ,' at line 1

[Harbeston]

I found the fix for this! it is to modify config.php, setting the variable db_type to 'mysql'

I discovered this in an older thread, I was just not focusing my search of the forums well enough!

Thanks all,


Jay