I have both fixes applied (PR 5932 and 5953) and Iām having this error when opening a contact from one certain user (only from this user specifically)
Tue Jul 3 15:51:49 2018 [18121][c3220439-aa5f-610f-b529-5b0c3ed61049][FATAL] Mysqli_query failed.
Tue Jul 3 15:51:49 2018 [18121][c3220439-aa5f-610f-b529-5b0c3ed61049][FATAL] Error retrieving Contact list: Query Failed: (SELECT tasks.id , tasks.contact_id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , ' ' contact_name_owner , ' ' 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.created_by , 'tasks' panel_name, NULL recurring_source, NULL date_due FROM tasks LEFT JOIN contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN users jt1 ON tasks.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN contacts tasks_rel ON tasks.contact_id=tasks_rel.id AND tasks_rel.deleted=0
where ( tasks.contact_id='99e191db-5b95-4bdb-8590-31d2fa62d33e' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0) UNION ALL ( SELECT tasks.id , tasks.contact_id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , ' ' contact_name_owner , ' ' 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.created_by , 'tasks_parent' panel_name, NULL recurring_source, NULL date_due FROM tasks LEFT JOIN contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN users jt1 ON tasks.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN contacts tasks_parent_rel ON tasks.parent_id=tasks_parent_rel.id AND tasks_parent_rel.deleted=0
AND tasks.parent_type = 'Contacts'
where ( tasks.parent_id='99e191db-5b95-4bdb-8590-31d2fa62d33e' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT meetings.id , ' ' contact_id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , NULL date_start, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, meetings.created_by , 'meetings' panel_name, meetings.recurring_source , NULL date_due FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN meetings_contacts ON meetings.id=meetings_contacts.meeting_id AND meetings_contacts.contact_id='99e191db-5b95-4bdb-8590-31d2fa62d33e' AND meetings_contacts.deleted=0
where ((meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT calls.id , ' ' contact_id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_name_owner , ' ' contact_name_mod , NULL date_start, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.created_by , 'calls' panel_name, calls.recurring_source , calls.date_due FROM calls LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN calls_contacts ON calls.id=calls_contacts.call_id AND calls_contacts.contact_id='99e191db-5b95-4bdb-8590-31d2fa62d33e' AND calls_contacts.deleted=0
where ((calls.status != 'Held' AND calls.status != 'Not Held')) AND calls.deleted=0 ) ORDER BY date_start desc LIMIT 0,10: MySQL error 1054: Unknown column 'calls.date_due' in 'field list'
Tue Jul 3 15:51:49 2018 [18121][c3220439-aa5f-610f-b529-5b0c3ed61049][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:402
Tue Jul 3 15:51:49 2018 [18121][c3220439-aa5f-610f-b529-5b0c3ed61049][FATAL] Exception in Controller: Error de base de datos. Por favor, consulte SuiteCRM error .log para mƔs detalles.
Tue Jul 3 15:51:49 2018 [18121][c3220439-aa5f-610f-b529-5b0c3ed61049][FATAL] backtrace:
#0 /var/www/html/suitecrm/include/database/DBManager.php(353): sugar_die('Error de base d...')
#1 /var/www/html/suitecrm/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/html/suitecrm/include/database/MysqliManager.php(177): DBManager->checkError('Error retrievin...', true)
#3 /var/www/html/suitecrm/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT tasks.i...', true, 'Error retrievin...')
#4 /var/www/html/suitecrm/data/SugarBean.php(1291): MysqlManager->limitQuery('(SELECT tasks.i...', 0, 10, true, 'Error retrievin...')
#5 /var/www/html/suitecrm/data/SugarBean.php(1018): SugarBean->process_union_list_query(Object(Contact), '(SELECT tasks.i...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/html/suitecrm/include/ListView/ListView.php(1101): SugarBean::get_union_related_list(Object(Contact), 'date_start desc', 'desc', '', '', -1, 10, '', Object(aSubPanel))
#7 /var/www/html/suitecrm/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Contact), Object(aSubPanel), 'activities_CELL')
#8 /var/www/html/suitecrm/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Contacts', Object(Contact), Object(aSubPanel))
#9 /var/www/html/suitecrm/include/SubPanel/SubPanelTiles.php(366): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/html/suitecrm/include/MVC/View/SugarView.php(1186): SubPanelTiles->display()
#11 /var/www/html/suitecrm/include/MVC/View/SugarView.php(235): SugarView->_displaySubPanels()
#12 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(432): SugarView->process()
#13 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/html/suitecrm/include/MVC/SugarApplication.php(109): SugarController->execute()
#15 /var/www/html/suitecrm/index.php(52): SugarApplication->execute()
#16 {main}