search

salesagility / SuiteCRM

SuiteCRM - Open source CRM for the world
https://www.suitecrm.com
GNU Affero General Public License v3.0
4.44k stars 2.08k forks source link

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

Closed torben-wolf closed 6 years ago

torben-wolf commented 6 years ago

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

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:

ghost commented 6 years ago

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 6 years ago

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.

goltra commented 6 years ago

I have same problem

Dillon-Brown commented 6 years ago

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

ghost commented 6 years ago

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 6 years ago

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}

Dillon-Brown commented 6 years ago

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

ghost commented 6 years ago

@Dillon-Brown Yes, also restart of VM

Dillon-Brown commented 6 years ago

@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 6 years ago

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

torben-wolf commented 6 years ago

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

ghost commented 6 years ago

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

torben-wolf commented 6 years ago

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

frikhayessine commented 6 years ago

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

bunglex commented 6 years ago

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

kikobar commented 5 years ago

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

pgorod commented 5 years ago

@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.

Esteban200589 commented 3 years ago

this problem persists in patch 7.10.32

adriangibanelbtactic commented 2 weeks ago

@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.