Database failure. Please refer to suitecrm.log for details.

šŸ’¬ General Discussion
1

Upgraded from 7.10.7 to 7.10.9

Displaying a lead we get:

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.

Please help.

Cheers
David Younger

2

Sorry about this.

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.

3

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.

4

Yes, this is fixed in the latest versions, can you upgrade?

As always, make sure you have proper backups before upgrading, just for precaution.

5

Hi @pgr,

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?

Best regards,
Filip

6

SOLVED IT!!

When custom module in work, then this file does not exist but its values are stored in:
custom/Extension/MODULE/Ext/Layoutdef/FILENAME.php

This FILENAME in my case was one connected with calls, so it contained calls in name.

2 Likes