MySQL error 1054: Unknown column 'date_start' in 'order clause'

deekerman commented

2026-02-20 16:03:30 -05:00

Owner

Originally created by @torben-wolf on GitHub (Sep 14, 2018).

Originally assigned to: @Dillon-Brown on GitHub.

After Update to version 7.10.8, subpanels of opportunites do not show up.

Issue

MySQL error 1054: Unknown column 'date_start' in 'order clause'
Subpanels do not show up in opportunites and other depening modules

Actual Behavior

Error leading to suitecrm.log, Subpanels not showing up.

Context

The problem oocurs to every use, so we need an urgent fix.

Your Environment

SuiteCRM Version used: 7.10.8
Browser name and version (All Browers, 64 Bit)
Environment name and version (MySQL, PHP 7): MySql, PHP 7
Operating System and version (e.g Ubuntu 16.04): Debian 9

Log

Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Mysqli_query failed.
Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Error retrieving Opportunity list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , meetings.recurring_source , meetings.created_by , 'meetings' panel_name 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 opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'Opportunities'
where ( meetings.parent_id='15bdb3f4-2462-b612-7201-552e6da3aac5' AND (meetings.status !='Held' AND meetings.status !='Not Held') AND ( meetings.assigned_user_id ='1253f9fc-513b-f0fe-2691-57298771c6a9' 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 = '1253f9fc-513b-f0fe-2691-57298771c6a9'
INNER JOIN securitygroups_records secr
ON secg.id = secr.securitygroup_id
AND secr.deleted = 0
AND secr.module = 'Meetings'
WHERE secr.record_id = meetings.id
AND secg.deleted = 0) ) ) AND meetings.deleted=0) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , tasks.contact_id , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , NULL recurring_source, tasks.created_by , 'tasks' panel_name 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 opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'Opportunities'
where ( tasks.parent_id='15bdb3f4-2462-b612-7201-552e6da3aac5' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , calls.recurring_source , calls.created_by , 'calls' panel_name FROM calls LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'Opportunities'
where ( calls.parent_id='15bdb3f4-2462-b612-7201-552e6da3aac5' AND (calls.status != 'Held' AND calls.status != 'Not Held')) AND calls.deleted=0 ) ORDER BY date_start desc LIMIT 0,11: MySQL error 1054: Unknown column 'date_start' in 'order clause'
Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Exception handling in /var/www/comsyscrm/include/MVC/Controller/SugarController.php:400
Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Exception in Controller: Datenbank Fehler. Bitte sehen Sie in der Datei suitecrm.log nach.
Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] backtrace:

Originally created by @torben-wolf on GitHub (Sep 14, 2018). Originally assigned to: @Dillon-Brown on GitHub. After Update to version 7.10.8, subpanels of opportunites do not show up. #### Issue MySQL error 1054: Unknown column 'date_start' in 'order clause' Subpanels do not show up in opportunites and other depening modules #### Actual Behavior Error leading to suitecrm.log, Subpanels not showing up. #### Context The problem oocurs to every use, so we need an urgent fix. #### Your Environment * SuiteCRM Version used: 7.10.8 * Browser name and version (All Browers, 64 Bit) * Environment name and version (MySQL, PHP 7): MySql, PHP 7 * Operating System and version (e.g Ubuntu 16.04): Debian 9 #### Log Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Mysqli_query failed. Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Error retrieving Opportunity list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , meetings.recurring_source , meetings.created_by , 'meetings' panel_name 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 opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0 AND meetings.parent_type = 'Opportunities' where ( meetings.parent_id='15bdb3f4-2462-b612-7201-552e6da3aac5' AND (meetings.status !='Held' AND meetings.status !='Not Held') AND ( meetings.assigned_user_id ='1253f9fc-513b-f0fe-2691-57298771c6a9' 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 = '1253f9fc-513b-f0fe-2691-57298771c6a9' INNER JOIN securitygroups_records secr ON secg.id = secr.securitygroup_id AND secr.deleted = 0 AND secr.module = 'Meetings' WHERE secr.record_id = meetings.id AND secg.deleted = 0) ) ) AND meetings.deleted=0) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , tasks.contact_id , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , NULL recurring_source, tasks.created_by , 'tasks' panel_name 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 opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0 AND tasks.parent_type = 'Opportunities' where ( tasks.parent_id='15bdb3f4-2462-b612-7201-552e6da3aac5' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , calls.recurring_source , calls.created_by , 'calls' panel_name FROM calls LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0 AND calls.parent_type = 'Opportunities' where ( calls.parent_id='15bdb3f4-2462-b612-7201-552e6da3aac5' AND (calls.status != 'Held' AND calls.status != 'Not Held')) AND calls.deleted=0 ) ORDER BY date_start desc LIMIT 0,11: MySQL error 1054: Unknown column 'date_start' in 'order clause' Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Exception handling in /var/www/comsyscrm/include/MVC/Controller/SugarController.php:400 Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] Exception in Controller: Datenbank Fehler. Bitte sehen Sie in der Datei suitecrm.log nach. Fri Sep 14 12:15:52 2018 [21765][1253f9fc-513b-f0fe-2691-57298771c6a9][FATAL] backtrace:

deekerman

2026-02-20 16:03:30 -05:00

closed this issue
added the
Type: Bug

Status:Fix Proposed

Priority:Important
labels

deekerman commented

2026-02-20 16:03:31 -05:00

Author

Owner

@ghost commented on GitHub (Sep 17, 2018):

Same problem here - different logs.

[FATAL] Query Failed: SELECT calls.id , calls.parent_id , calls.assigned_user_id , calls.recurring_source , calls.status , calls.direction , calls.name , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name, jtl0.contact_id contact_id, calls.parent_type , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.date_entered , calls.date_modified , calls.created_by FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0

LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where ((parent_name like 'UTM UNITRLA MEDICAL SPA%')) AND calls.deleted=0 ORDER BY calls.direction ASC LIMIT 0,101: MySQL error 1054: Unknown column 'parent_name' in 'where clause'
Mon Sep 17 09:25:38 2018 [23979][724cf882-e542-01af-a036-57553a6d68ee][FATAL] "parent_type" is not set
Mon Sep 17 09:25:54 2018 [23002][724cf882-e542-01af-a036-57553a6d68ee][FATAL] Mysqli_query failed.
Mon Sep 17 09:25:54 2018 [23002][724cf882-e542-01af-a036-57553a6d68ee][FATAL] Query Failed: SELECT calls.id , calls.parent_id , calls.assigned_user_id , calls.recurring_source , calls.status , calls.direction , calls.name , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name, jtl0.contact_id contact_id, calls.parent_type , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.date_entered , calls.date_modified , calls.created_by FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0

LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where ((parent_name like 'UTM UNITRLA MEDICAL SPA%')) AND calls.deleted=0 ORDER BY calls.direction ASC LIMIT 0,101: MySQL error 1054: Unknown column 'parent_name' in 'where clause'
Mon Sep 17 09:25:54 2018 [24021][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set
Mon Sep 17 09:26:00 2018 [23979][724cf882-e542-01af-a036-57553a6d68ee][FATAL] "parent_type" is not set

@ghost commented on GitHub (Sep 17, 2018): Same problem here - different logs. [FATAL] Query Failed: SELECT calls.id , calls.parent_id , calls.assigned_user_id , calls.recurring_source , calls.status , calls.direction , calls.name , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name, jtl0.contact_id contact_id, calls.parent_type , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.date_entered , calls.date_modified , calls.created_by FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0 LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0 AND jt1.deleted=0 where ((parent_name like 'UTM UNITRLA MEDICAL SPA%')) AND calls.deleted=0 ORDER BY calls.direction ASC LIMIT 0,101: MySQL error 1054: Unknown column 'parent_name' in 'where clause' Mon Sep 17 09:25:38 2018 [23979][724cf882-e542-01af-a036-57553a6d68ee][FATAL] "parent_type" is not set Mon Sep 17 09:25:54 2018 [23002][724cf882-e542-01af-a036-57553a6d68ee][FATAL] Mysqli_query failed. Mon Sep 17 09:25:54 2018 [23002][724cf882-e542-01af-a036-57553a6d68ee][FATAL] Query Failed: SELECT calls.id , calls.parent_id , calls.assigned_user_id , calls.recurring_source , calls.status , calls.direction , calls.name , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name, jtl0.contact_id contact_id, calls.parent_type , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.date_entered , calls.date_modified , calls.created_by FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0 LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0 AND jt1.deleted=0 where ((parent_name like 'UTM UNITRLA MEDICAL SPA%')) AND calls.deleted=0 ORDER BY calls.direction ASC LIMIT 0,101: MySQL error 1054: Unknown column 'parent_name' in 'where clause' Mon Sep 17 09:25:54 2018 [24021][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set Mon Sep 17 09:26:00 2018 [23979][724cf882-e542-01af-a036-57553a6d68ee][FATAL] "parent_type" is not set

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@ghost commented on GitHub (Sep 17, 2018):

In my case interesting is the fact that the problem is only with "open" opportunites ( which state is different than closed with failure and success ). I tried all the repair options, all the CHMOD are correct did restart apache, etc. no result.

@ghost commented on GitHub (Sep 17, 2018): In my case interesting is the fact that the problem is only with "open" opportunites ( which state is different than closed with failure and success ). I tried all the repair options, all the CHMOD are correct did restart apache, etc. no result.

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@goltra commented on GitHub (Sep 17, 2018):

I have same problem

@goltra commented on GitHub (Sep 17, 2018): I have same problem

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@Dillon-Brown commented on GitHub (Sep 17, 2018):

Hi guys, I've fixed this here: #6319. Is anyone able to confirm this works for them? thanks. @torben-wolf @AdminPL @goltra

@Dillon-Brown commented on GitHub (Sep 17, 2018): Hi guys, I've fixed this here: #6319. Is anyone able to confirm this works for them? thanks. @torben-wolf @AdminPL @goltra

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@ghost commented on GitHub (Sep 17, 2018):

Doesn't work for me. I made qucik rebuild and reset of whole system after changes. Still get error.

Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Mysqli_query failed.
Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Error retrieving Opportunity list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , meetings.recurring_source , meetings.created_by , 'meetings' panel_name 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 opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'Opportunities'
where ( meetings.parent_id='2a742c76-48fa-e888-16e4-58527bfe4376' AND (meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , tasks.contact_id , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , NULL recurring_source, tasks.created_by , 'tasks' panel_name FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c 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 opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'Opportunities'
where ( tasks.parent_id='2a742c76-48fa-e888-16e4-58527bfe4376' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , calls.recurring_source , calls.created_by , 'calls' panel_name FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'Opportunities'
where ( calls.parent_id='2a742c76-48fa-e888-16e4-58527bfe4376' AND (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 'date_start' in 'order clause'
Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400
Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM.
Mon Sep 17 14:38:28 2018 [2863][1][FATAL] backtrace:
#0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...')
#1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...')
#4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT meeting...', 0, 10, true, 'Error retrievin...')
#5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Opportunity), '(SELECT meeting...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Opportunity), 'date_start desc', 'desc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Opportunity), Object(aSubPanel), 'activities_CELL')
#8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Opportunities', Object(Opportunity), Object(aSubPanel))
#9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute()
#16 {main}

@ghost commented on GitHub (Sep 17, 2018): Doesn't work for me. I made qucik rebuild and reset of whole system after changes. Still get error. Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Mysqli_query failed. Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Error retrieving Opportunity list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , meetings.recurring_source , meetings.created_by , 'meetings' panel_name 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 opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0 AND meetings.parent_type = 'Opportunities' where ( meetings.parent_id='2a742c76-48fa-e888-16e4-58527bfe4376' AND (meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , tasks.contact_id , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , NULL recurring_source, tasks.created_by , 'tasks' panel_name FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c 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 opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0 AND tasks.parent_type = 'Opportunities' where ( tasks.parent_id='2a742c76-48fa-e888-16e4-58527bfe4376' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , calls.recurring_source , calls.created_by , 'calls' panel_name FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0 AND calls.parent_type = 'Opportunities' where ( calls.parent_id='2a742c76-48fa-e888-16e4-58527bfe4376' AND (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 'date_start' in 'order clause' Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400 Mon Sep 17 14:38:28 2018 [2863][1][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM. Mon Sep 17 14:38:28 2018 [2863][1][FATAL] backtrace: #0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...') #1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true) #2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true) #3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...') #4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT meeting...', 0, 10, true, 'Error retrievin...') #5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Opportunity), '(SELECT meeting...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array) #6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Opportunity), 'date_start desc', 'desc', '', 0, -1, 10, '', Object(aSubPanel)) #7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Opportunity), Object(aSubPanel), 'activities_CELL') #8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Opportunities', Object(Opportunity), Object(aSubPanel)) #9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array) #10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display() #11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels() #12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process() #13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView() #14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute() #15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute() #16 {main}

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@ghost commented on GitHub (Sep 17, 2018):

After Updateing module builder

Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Mysqli_query failed.
Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Error retrieving Opportunity list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , meetings.recurring_source , meetings.created_by , 'meetings' panel_name 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 opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0
AND meetings.parent_type = 'Opportunities'
where ( meetings.parent_id='67352da2-7aa8-50b4-ec41-5b9a448492c9' AND (meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , tasks.contact_id , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , NULL recurring_source, tasks.created_by , 'tasks' panel_name FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c 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 opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = 'Opportunities'
where ( tasks.parent_id='67352da2-7aa8-50b4-ec41-5b9a448492c9' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , calls.recurring_source , calls.created_by , 'calls' panel_name FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0
AND calls.parent_type = 'Opportunities'
where ( calls.parent_id='67352da2-7aa8-50b4-ec41-5b9a448492c9' AND (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 'date_start' in 'order clause'
Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400
Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM.
Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] backtrace:
#0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...')
#1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true)
#2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true)
#3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...')
#4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT meeting...', 0, 10, true, 'Error retrievin...')
#5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Opportunity), '(SELECT meeting...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Opportunity), 'date_start desc', 'desc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Opportunity), Object(aSubPanel), 'activities_CELL')
#8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Opportunities', Object(Opportunity), Object(aSubPanel))
#9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)
#10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute()
#16 {main}

@ghost commented on GitHub (Sep 17, 2018): After Updateing module builder Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Mysqli_query failed. Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Error retrieving Opportunity list: Query Failed: (SELECT meetings.id , meetings.assigned_user_id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , meetings.recurring_source , meetings.created_by , 'meetings' panel_name 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 opportunities meetings_rel ON meetings.parent_id=meetings_rel.id AND meetings_rel.deleted=0 AND meetings.parent_type = 'Opportunities' where ( meetings.parent_id='67352da2-7aa8-50b4-ec41-5b9a448492c9' AND (meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0) UNION ALL ( SELECT tasks.id , tasks.assigned_user_id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) contact_name , tasks.contact_id , NULL date_due, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , NULL recurring_source, tasks.created_by , 'tasks' panel_name FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c 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 opportunities tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0 AND tasks.parent_type = 'Opportunities' where ( tasks.parent_id='67352da2-7aa8-50b4-ec41-5b9a448492c9' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.assigned_user_id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_end as date_due , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' contact_name_owner , ' ' contact_name_mod , calls.recurring_source , calls.created_by , 'calls' panel_name FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN opportunities calls_rel ON calls.parent_id=calls_rel.id AND calls_rel.deleted=0 AND calls.parent_type = 'Opportunities' where ( calls.parent_id='67352da2-7aa8-50b4-ec41-5b9a448492c9' AND (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 'date_start' in 'order clause' Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception handling in /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php:400 Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] Exception in Controller: Awaria bazy danych. Szczegóły zapisano w logu SuiteCRM. Mon Sep 17 14:52:18 2018 [3507][68d92b56-f55c-b8ac-d3e1-583be9227722][FATAL] backtrace: #0 /var/www/crm.fortecait.pl/include/database/DBManager.php(353): sugar_die('Awaria bazy dan...') #1 /var/www/crm.fortecait.pl/include/database/DBManager.php(328): DBManager->registerError('Error retrievin...', 'Error retrievin...', true) #2 /var/www/crm.fortecait.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error retrievin...', true) #3 /var/www/crm.fortecait.pl/include/database/MysqlManager.php(285): MysqliManager->query('(SELECT meeting...', true, 'Error retrievin...') #4 /var/www/crm.fortecait.pl/data/SugarBean.php(1284): MysqlManager->limitQuery('(SELECT meeting...', 0, 10, true, 'Error retrievin...') #5 /var/www/crm.fortecait.pl/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(Opportunity), '(SELECT meeting...', 0, 10, 10, '', Object(aSubPanel), '( SELECT count(...', Array) #6 /var/www/crm.fortecait.pl/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(Opportunity), 'date_start desc', 'desc', '', 0, -1, 10, '', Object(aSubPanel)) #7 /var/www/crm.fortecait.pl/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Opportunity), Object(aSubPanel), 'activities_CELL') #8 /var/www/crm.fortecait.pl/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Opportunities', Object(Opportunity), Object(aSubPanel)) #9 /var/www/crm.fortecait.pl/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array) #10 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(1167): SubPanelTiles->display() #11 /var/www/crm.fortecait.pl/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels() #12 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(435): SugarView->process() #13 /var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView() #14 /var/www/crm.fortecait.pl/include/MVC/SugarApplication.php(113): SugarController->execute() #15 /var/www/crm.fortecait.pl/index.php(52): SugarApplication->execute() #16 {main}

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@Dillon-Brown commented on GitHub (Sep 17, 2018):

Hi @AdminPL, just to confirm, have you tried logging out and back in again?

@Dillon-Brown commented on GitHub (Sep 17, 2018): Hi @AdminPL, just to confirm, have you tried logging out and back in again?

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@ghost commented on GitHub (Sep 17, 2018):

@Dillon-Brown Yes, also restart of VM

@ghost commented on GitHub (Sep 17, 2018): @Dillon-Brown Yes, also restart of VM

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@Dillon-Brown commented on GitHub (Sep 17, 2018):

@AdminPL Thanks for the assistance so far, unfortunately i'm still struggling to replicate this on my end but if you had the time would you be able to run a grep command for the date_start? something like this would be perfect:

grep -r --include=\*.php 'date_start' > output.txt

@Dillon-Brown commented on GitHub (Sep 17, 2018): @AdminPL Thanks for the assistance so far, unfortunately i'm still struggling to replicate this on my end but if you had the time would you be able to run a grep command for the date_start? something like this would be perfect: ``` grep -r --include=\*.php 'date_start' > output.txt ```

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@Dillon-Brown commented on GitHub (Sep 17, 2018):

@AdminPL Merging the fix proposed PR for now but we'll keep looking into it until you get it resolved.

@Dillon-Brown commented on GitHub (Sep 17, 2018): @AdminPL Merging the fix proposed PR for now but we'll keep looking into it until you get it resolved.

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@torben-wolf commented on GitHub (Sep 17, 2018):

Hey Dillon,

just updated to 7.10.9. Seems to be fixed. I'll check with my team tomorrow.

Thank you for the fast fix so far.

Best Torben

@torben-wolf commented on GitHub (Sep 17, 2018): Hey Dillon, just updated to 7.10.9. Seems to be fixed. I'll check with my team tomorrow. Thank you for the fast fix so far. Best Torben

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@ghost commented on GitHub (Sep 18, 2018):

@Dillon-Brown I reversed changes and install patch 7.10.9 on production and it works!
Thanks !

@ghost commented on GitHub (Sep 18, 2018): @Dillon-Brown I reversed changes and install patch 7.10.9 on production and it works! Thanks !

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@torben-wolf commented on GitHub (Sep 18, 2018):

Hey @Dillon-Brown, fixed works for this problem. Thank you

@torben-wolf commented on GitHub (Sep 18, 2018): Hey @Dillon-Brown, fixed works for this problem. Thank you

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@frikhayessine commented on GitHub (Sep 18, 2018):

@Dillon-Brown how to solve this issue for custom modules? I have the same problem with custom modules that contains activities

@frikhayessine commented on GitHub (Sep 18, 2018): @Dillon-Brown how to solve this issue for custom modules? I have the same problem with custom modules that contains activities

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@bunglex commented on GitHub (Sep 27, 2018):

This error occurred after upgrading from 7.10.7>7.10.8 and also 7.10.7>7.10.9.

#6309 fixed the problem for me, however i only needed to change accounts, contacts,leads and prospects. Other modules already had date_due.

Many thanks

@bunglex commented on GitHub (Sep 27, 2018): This error occurred after upgrading from 7.10.7>7.10.8 and also 7.10.7>7.10.9. #6309 fixed the problem for me, however i only needed to change accounts, contacts,leads and prospects. Other modules already had date_due. Many thanks

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@kikobar commented on GitHub (Nov 13, 2018):

I found this error still happens with Leads.
I had to fix the file /modules/Leads/metadata/subpaneldefs.php to make it work.

@kikobar commented on GitHub (Nov 13, 2018): I found this error still happens with Leads. I had to fix the file /modules/Leads/metadata/subpaneldefs.php to make it work.

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@pgorod commented on GitHub (Nov 14, 2018):

@kikobar I think there was a problem with the 7.10.10 upgrade script that caused the fix not to be applied in some cases... so it seems that the fix works, but wasn't properly rolled out to everybody that upgraded to 7.10.10. The next version will fix this.

@pgorod commented on GitHub (Nov 14, 2018): @kikobar I think there was a problem with the 7.10.10 upgrade script that caused the fix not to be applied in some cases... so it seems that the fix works, but wasn't properly rolled out to everybody that upgraded to 7.10.10. The next version will fix this.

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@Esteban200589 commented on GitHub (Sep 1, 2021):

this problem persists in patch 7.10.32

@Esteban200589 commented on GitHub (Sep 1, 2021): this problem persists in patch 7.10.32

deekerman commented

2026-02-20 16:03:32 -05:00

Author

Owner

@adriangibanelbtactic commented on GitHub (Sep 23, 2024):

@Dillon-Brown how to solve this issue for custom modules? I have the same problem with custom modules that contains activities

Just in case it's useful for someone that updates from an old version of Suitecrm with custom modules. This is what worked for us:

In these files:

custom/Extension/modules/AOS_Contracts/Ext/Layoutdefs/aos_contracts_activities_1_calls_AOS_Contracts.php
custom/Extension/modules/btc_bMail/Ext/Layoutdefs/btc_bmail_activities_calls_btc_bMail.php
custom/Extension/modules/btc_Certificado_SSL/Ext/Layoutdefs/btc_certificado_ssl_activities_calls_btc_Certificado_SSL.php
custom/Extension/modules/btc_Hosting/Ext/Layoutdefs/btc_hosting_activities_calls_btc_Hosting.php
custom/Extension/modules/btc_IP/Ext/Layoutdefs/btc_ip_activities_calls_btc_IP.php
custom/Extension/modules/btc_Maquinas_virtuales/Ext/Layoutdefs/btc_maquinas_virtuales_activities_calls_btc_Maquinas_virtuales.php
custom/Extension/modules/btc_Servidores/Ext/Layoutdefs/btc_servidores_activities_calls_btc_Servidores.php

we had to replace: 'sort_by' => 'date_start', to: 'sort_by' => 'date_due', and then run the Quick Build and Repair option.

@adriangibanelbtactic commented on GitHub (Sep 23, 2024): > @Dillon-Brown how to solve this issue for custom modules? I have the same problem with custom modules that contains activities Just in case it's useful for someone that updates from an old version of Suitecrm with custom modules. This is what worked for us: In these files: ``` custom/Extension/modules/AOS_Contracts/Ext/Layoutdefs/aos_contracts_activities_1_calls_AOS_Contracts.php custom/Extension/modules/btc_bMail/Ext/Layoutdefs/btc_bmail_activities_calls_btc_bMail.php custom/Extension/modules/btc_Certificado_SSL/Ext/Layoutdefs/btc_certificado_ssl_activities_calls_btc_Certificado_SSL.php custom/Extension/modules/btc_Hosting/Ext/Layoutdefs/btc_hosting_activities_calls_btc_Hosting.php custom/Extension/modules/btc_IP/Ext/Layoutdefs/btc_ip_activities_calls_btc_IP.php custom/Extension/modules/btc_Maquinas_virtuales/Ext/Layoutdefs/btc_maquinas_virtuales_activities_calls_btc_Maquinas_virtuales.php custom/Extension/modules/btc_Servidores/Ext/Layoutdefs/btc_servidores_activities_calls_btc_Servidores.php ``` we had to replace: `'sort_by' => 'date_start',` to: `'sort_by' => 'date_due',` and then run the Quick Build and Repair option.

Rows
Columns

MySQL error 1054: Unknown column 'date_start' in 'order clause' #3299

Issue

Actual Behavior

Context

Your Environment

Log