After update to suitecrm 7.10.8 I cannot load the subpannels in the cases and get this message “Database failure. Please refer to suitecrm.log for details.”
Some cases load well other give the message above
Can somebody help?
Thanks in advance!
Mirko
What does the SuiteCRM log say? It’s most likely Gona provide a FATAL level log so keep an eye for that.
Thanks
can it be this? Sat Sep 15 08:55:07 2018 [3793389][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set
No, that error is a known issue, it is fixed in 7.10.8, and I believe it is just a message in the logs, without any effect.
In Admin /System Settings you can increase your log level (I suggest WARNING) to see more messages. Pay special attention to the ones coming at the moment when you try to show the screen and it fails.
This is what I practically get out of the log, everything was working fine before the update, strange thing is I can se some subpannels at some cases but a lot of cases refuse to show the subpannels.
Sat Sep 15 13:27:07 2018 [543819][1][FATAL] Exception handling in /x/x/x/x.x/x/suite/include/MVC/Controller/SugarController.php:400
Sat Sep 15 13:27:07 2018 [543819][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Sat Sep 15 13:27:07 2018 [543819][1][FATAL] backtrace:
#0 /x/x/x/x.x/x/suite/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /x/x/x/x.x/x/suite/include/database/DBManager.php(328): DBManager->registerError(‘Error retrievin…’, ‘Error retrievin…’, true)
#2 /x/x/x/x.x/x/suite/include/database/MysqliManager.php(179): DBManager->checkError(‘Error retrievin…’, true)
#3 /x/x/x/x.x/x/suite/include/database/MysqlManager.php(285): MysqliManager->query(’(SELECT meeting…’, true, ‘Error retrievin…’)
#4 /x/x/x/x.x/x/suite/data/SugarBean.php(1284): MysqlManager->limitQuery(’(SELECT meeting…’, 0, 20, true, ‘Error retrievin…’)
#5 /x/x/x/x.x/x/suite/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(aCase), ‘(SELECT meeting…’, 0, 20, 20, ‘’, Object(aSubPanel), ‘( SELECT count(…’, Array)
#6 /x/x/x/x.x/public_html/suite/include/ListView/ListView.php(1132): SugarBean::get_union_related_list(Object(aCase), ‘date_start desc’, ‘desc’, ‘’, 0, -1, 20, ‘’, Object(aSubPanel))
#7 /x/x/x/x.x/x/suite/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(aCase), Object(aSubPanel), ‘activities_CELL’)
#8 /x/xxx/x/x.x/x/suite/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview(‘Cases’, Object(aCase), Object(aSubPanel))
#9 /x/xxxx/x/xxx.x/x/suite/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView(‘include/SubPane…’, Array)
#10 /x/xxxxxxx/x/xxxxx.x/x/suite/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()
#11 /x/xxx/x/xxx.x/x/suite/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()
#12 /x/xxxx/x/xxx.x/x/suite/include/MVC/Controller/SugarController.php(435): SugarView->process()
#13 /x/xxxx/x/xxx.x/x/suite/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /x/xxx/x/xxx.x/x/suite/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /x/xxx/x/xxx.x/x/suite/index.php(52): SugarApplication->execute()
#16 {main}
Sat Sep 15 13:27:16 2018 [547824][1][FATAL] log call at: modules/Administration/index.tpl:53 - MY_FRAME is not set
I’ve been searching for a workaround and I’ve found something quite strange but interesting in relation with the bug, the cases are used in the agenda and use a status dropdownbox to enshure the case was planned/not done or done. I found out that if the dropbox was set in done or not done the subpannels came back unther the cases profiles.
Maybe a stupid question (if those exist) but is there been a change in coding or so now that that dropbox is bugging?
hope for a fix!
greetings!
Mirko
Data Type: DropDown
Field Name: status
Display Label:
Status:
System Label:
LBL_STATUS
Help Text:
Comment Text:
Meeting status (ex: Planned, Held, Not held)
Drop Down List:
Default Value: PlannedHeldNot Held
@mirkococco can you please check your PHP log at the time when suitecrm.log shows that database failure? Or any other FATAL/ERROR messages there.
It’s normally called php_errors.log but might depend on your web server and configuration. Thanks.
About your description of the Dropdown: is this a custom Dropdown done by you, or is it something that comes be default?
I got the same problem - when you go to opportunites you can’t see related records so CRM is preety much usless right now.
[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
I’ll try to get a look at the pho log, about the dropdown it is something that came by default LBL_STATUS, The subpannels work now as long I don’t use the planned choice but the not held or held instead
Please do check that log, and when you come back to post, also tell us your version of PHP please. Thanks!
php version is 7.2, I’m not that high technical… where do I find the php log? sorry for the may be a stupid question
No, that’s not a stupid question. it’s perfectly ok to ask that. 
It depends on your operating system and Web server. So the best way to find it is to Google that question, specifying web server name and version.
Sometimes you have to first turn on that logging, and only then the log file is created.
For example, on Ubuntu / Apache / PH 7.x you can set it up in /etc/php7/apache2/php.ini the directive is called error_log.
It is quite useful for SuiteCRM installations to be able to track this log. Often that’s where the answers are.
Similar Problem for me on alle opportunities:
Opened a bug here: https://github.com/salesagility/SuiteCRM/issues/6309#issuecomment-421914571
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:
In php log:
[Mon Sep 17 08:39:05.506738 2018] [php7:warn] [pid 26313] [client 188.147.37.73:4267] PHP Warning: count(): Parameter must be an array or an object that implements Countable /var/www/crm.fortecait.pl/cache/smarty/templates_c/%%8C^8C3^8C367BA2%%SubPanelDynamic.tpl.php on line 67, referer: https://crm.fortecait.pl/index.php?module=Opportunities&action=DetailView&record=8cb2c97b-b95c-7506-81f9-5b8d0626504d
Hi everyone, we are currently working on a fix.
https://github.com/salesagility/SuiteCRM/pull/6319
I know someone yous are on the thread over there and we are working together to resolve this asap.
It would be great if you haven’t joined in the conversation to provide feedback if this fix does or does not work for you. Thanks!