Database failure. Please refer to suitecrm.log for details.
Snippet from Sugarcrm.log:
AND jt1.deleted=0 where ( calls.parent_id = ā282b2804-a1b0-3df5-d10f-5bb647e599f9ā
AND calls.parent_type = āLeadsā AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) 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ā
e[0me[30me[41mThu Oct 4 17:38:35 2018 [1952][2ae93823-265c-b624-e45c-5448a1eaf563][FATAL] Exception handling in C:\Bitnami\suitecrm\apps\suitecrm\htdocs\include\MVC\Controller\SugarController.php:400
e[0me[30me[41mThu Oct 4 17:38:35 2018 [1952][2ae93823-265c-b624-e45c-5448a1eaf563][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
This ādate_startā error is a known issue, and it is already fixed in GitHub on āhotfixā branch, will be coming out quite soon in 7.10.10 (I canāt promise a set date yet, but⦠soon).
If youāre in a hurry you can search GitHub for the fix, maybe itās easy to apply manually.
We are encountering the database failure in 7.10.11. Is there any fix available? We receive this error when trying to assign a ticket to a different user. Thank you.
I have Suite version 7.10.22. and only recently started to seeing this error on 2 custom modules.
This modules donāt have subpaneldef.php so I created one, but no luck.
I have seen in one of the posts that maybe database version is problem, but I can not change that.
Do you have any other solution?