4.5 GA - SQL errors

**panoptech** · 2006-09-10, 10:54 PM

Have just completed vanilla install of 4.5 - all went fine - have gone to import accounts,contacts then opportunities via CSV all of which seemd to work correctly I now get the following when i look at any opportunity:

Error retrieving Opportunity list: Query Failed

SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.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 contacts.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(contacts.first_name,''),' ',IFNULL(contacts.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 contacts.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(contacts.first_name,''),' ',IFNULL(contacts.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 contacts.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 contacts.deleted=0 AND jt1.deleted=0 where ((meetings.status='Planned')) AN' at line 1

**kbrill** · 2006-09-10, 11:04 PM

I see that you say 'Have just completed vanilla install of 4.5' and I take that to mean that you have loaded NO modules. Also I take this to mean that this was a full install and not an upgrade. Am I right on both counts?

Your problem is a malformed select query which isn't happening on any of my 4.5GA installs. We need to dig a little deep and find out what the difference between my install and yours.

**panoptech** · 2006-09-11, 05:48 PM

Sorry for being vague:

you are correct this is a new clean install of the full 4.5 GA release - no modules loaded

running on Linux RH EN4 - PHP 4.3.9 - MYSQL 4.1.12

When i tried a test out of the box everything seemed to work correctly. The fault has only happened since i imported the CSV information (Generated by a 4.2.1B version that just wouldnt upgrade) Since we had only been using it for a week i thought i would export the infomration i needed and start again.

If you would like to view the live site PM me and ill give you the details.

Thanks in advance for your assistance

**kbrill** · 2006-09-11, 05:56 PM

Originally Posted by panoptech

Sorry for being vague:

you are correct this is a new clean install of the full 4.5 GA release - no modules loaded

running on Linux RH EN4 - PHP 4.3.9 - MYSQL 4.1.12

When i tried a test out of the box everything seemed to work correctly. The fault has only happened since i imported the CSV information (Generated by a 4.2.1B version that just wouldnt upgrade) Since we had only been using it for a week i thought i would export the infomration i needed and start again.

If you would like to view the live site PM me and ill give you the details.

Thanks in advance for your assistance

Can you set your log level to debug (in your log4php.properties file) and send me your sugarcrm.log (ken.brill (a t) gmail.com

**Markku** · 2006-09-11, 09:19 PM

The Compatibility Matrix in SugarOpenSource_ReleaseNotes_4.5.pdf states that MySQL 4.1.2 or higher is supported. As you are using MySQL 4.1.12 I started to wonder if MySQL version could play some role here?