This error appears at the bottom of the page when you click on an existing lead to view its details.
Error retrieving Lead list: Query FailedSELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings where ( meetings.parent_id= 'be11dfc1-bbb2-1f19-b2b5-43ddf7c4d12d' AND meetings.parent_type='Leads' AND meetings.deleted=0 AND (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.contact_id , jt0.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , tasks.parent_id , tasks.parent_type , tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 AND jt0.deleted=0 where ( tasks.parent_id= 'be11dfc1-bbb2-1f19-b2b5-43ddf7c4d12d' 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 , calls.parent_id , calls.parent_type , calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls where ( calls.parent_id= 'be11dfc1-bbb2-1f19-b2b5-43ddf7c4d12d' AND calls.parent_type='Leads' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start asc::MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'


LinkBack URL
About LinkBacks
SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings where ( meetings.parent_id= 'be11dfc1-bbb2-1f19-b2b5-43ddf7c4d12d' AND meetings.parent_type='Leads' AND meetings.deleted=0 AND (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.contact_id , jt0.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , tasks.parent_id , tasks.parent_type , tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 AND jt0.deleted=0 where ( tasks.parent_id= 'be11dfc1-bbb2-1f19-b2b5-43ddf7c4d12d' 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 , calls.parent_id , calls.parent_type , calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls where ( calls.parent_id= 'be11dfc1-bbb2-1f19-b2b5-43ddf7c4d12d' AND calls.parent_type='Leads' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start asc::MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'




Reply With Quote
Bookmarks