adding activity to lead results in SQl error

[AgencyPJA]

Just upgrade to 6.0 CE and have found what may be a bug - view a lead record and then "Create Task" (from the Activities section). The Task is created (it appears in the "My Tasks" dashlet) but reloading the Lead record results in an SQL written where the Activities panel should be.

Is anybody else experiencing this and, if so, have an ideas how to repair?

[eggsurplus]

What is the SQL error?

[AgencyPJA]

Sorry for the delayed response... here's an example of the error that appears at the bottom of a leads record:

Error retrieving Lead list: Query Failed:SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, meetings.assigned_user_id , 'meetings' panel_name FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN meetings_leads ON (meetings.id=meetings_leads.meeting_id AND meetings_leads.lead_id= 'd262813b-6b10-3821-0bce-4c3cefde130c') where ( meetings_leads.deleted=0 AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 UNION ALL ( SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, meetings.assigned_user_id , 'oldmeetings' panel_name FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id = 'd262813b-6b10-3821-0bce-4c3cefde130c' AND meetings.parent_type = 'Leads' AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) AND (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.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= 'd262813b-6b10-3821-0bce-4c3cefde130c' AND tasks.parent_type='Leads' AND tasks.deleted=0 AND (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 , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.assigned_user_id , 'calls' panel_name FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN calls_leads ON (calls.id=calls_leads.call_id AND calls_leads.lead_id= 'd262813b-6b10-3821-0bce-4c3cefde130c') where ( calls_leads.deleted=0 AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.assigned_user_id , 'oldcalls' panel_name FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id = 'd262813b-6b10-3821-0bce-4c3cefde130c' AND calls.parent_type = 'Leads' AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) AND (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 ') UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(co' at line 6

[AgencyPJA]

Any ideas on how to tackle this?