Good Afternoon Folks,
I’m back with another question. I am now deep into deployment and have started seeing mysqli query failures in the SuiteCRM log. I’m not certain where to start with attempting to track this issue down. If possible, could someone take a look at the error below and let me know what you think? Thanks in advance for all your help!
Wed Aug 15 09:41:59 2018 [5316][005d00000062dzgAAA][FATAL] Mysqli_query failed.
Wed Aug 15 09:41:59 2018 [5316][005d00000062dzgAAA][FATAL] Query Failed: SELECT tasks.assigned_user_id AS ‘Assigned_to0’, tasks:leads_cstm.client_id_c AS ‘Client_ID1’, COUNT(tasks.name) AS ‘Subject2’ FROM tasks LEFT JOIN leads tasks:leads ON tasks.parent_id=tasks:leads.id AND tasks:leads.deleted=0
AND tasks.parent_type = ‘Leads’
AND ( leads.assigned_user_id =‘005d00000062dzgAAA’ or EXISTS (SELECT 1
FROM securitygroups secg
INNER JOIN securitygroups_users secu
ON secg.id = secu.securitygroup_id
AND secu.deleted = 0
AND secu.user_id = ‘005d00000062dzgAAA’
INNER JOIN securitygroups_records secr
ON secg.id = secr.securitygroup_id
AND secr.deleted = 0
AND secr.module = ‘Leads’
WHERE secr.record_id = tasks:leads.id
AND secg.deleted = 0) ) LEFT JOIN leads_cstm tasks:leads_cstm ON tasks:leads.id = tasks:leads_cstm.id_c LEFT JOIN tasks_cstm tasks_cstm ON tasks.id = tasks_cstm.id_c WHERE ( tasks_cstm.activity_date_c_task_c BETWEEN “2018-08-13 00:00:00” AND “2018-08-20 00:00:00” ) AND tasks.deleted = 0 AND ( tasks.assigned_user_id =‘005d00000062dzgAAA’ or EXISTS (SELECT 1
FROM securitygroups secg
INNER JOIN securitygroups_users secu
ON secg.id = secu.securitygroup_id
AND secu.deleted = 0
AND secu.user_id = ‘005d00000062dzgAAA’
INNER JOIN securitygroups_records secr
ON secg.id = secr.securitygroup_id
AND secr.deleted = 0
AND secr.module = ‘Tasks’
WHERE secr.record_id = tasks.id
AND secg.deleted = 0) ) GROUP BY tasks.assigned_user_id, tasks:leads_cstm.client_id_c LIMIT 0,50: MySQL error 1054: Unknown column ‘leads.assigned_user_id’ in ‘on clause’