Database Failure problem after upgrade from 7.10.4 to 7.10.5

[pgr]

Yes, that looks normal.

You can increase some timeouts llmits in php.ini

memory_limit
max_upload_size
max_execution_time

[SuiteConvert]

Hot Fix https://github.com/salesagility/SuiteCRM/pull/5932

Worked for me all submenus with DB errors are all working now!

You guys rock!

[vincegar72]

Hotfix also worked for me ! Thanks guys Thumb up !

[Andyg]

perfect thanks for confirming that @pgr

[christianlocal]

Hello, should I apply the fix to the file or can I download the complete file and install as normal? thanks

[pgr]

Since it’s very simple I would just apply it manually…

[eac]

I replaced the whole file of data/link2.php, Did a repair and still contacts and projects show no subpanels. Accounts show subpanels.
I then swapped the file out for a backup of the system file and still nothing. Any further thoughts?

Tue May 29 07:58:25 2018 [22320][62e5fe32-37fa-1550-5c85-4e57c5a34982][FATAL] Mysqli_query failed.
Tue May 29 07:58:25 2018 [22320][62e5fe32-37fa-1550-5c85-4e57c5a34982][FATAL] Error retrieving Contact list: Query Failed: (SELECT fp_events.id , fp_events.name , fp_events.date_modified , fp_events.assigned_user_id , ‘fp_events_contacts’ panel_name FROM fp_events INNER JOIN fp_events_contacts_c ON contacts.id=fp_events_contacts_c.fp_events_contactscontacts_idb AND fp_events_contacts_c.fp_events_contactsfp_events_ida=‘6b20ec69-8885-813f-d19c-5b04600c0b53’ AND fp_events_contacts_c.deleted=0

where fp_events.deleted=0) ORDER BY fp_events.id asc LIMIT 0,11: MySQL error 1054: Unknown column ‘contacts.id’ in ‘on clause’
Tue May 29 07:58:25 2018 [22320][62e5fe32-37fa-1550-5c85-4e57c5a34982][FATAL] Exception handling in /home/aceac103/public_html/crm.logan-tech.us/include/MVC/Controller/SugarController.php:402
Tue May 29 07:58:25 2018 [22320][62e5fe32-37fa-1550-5c85-4e57c5a34982][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tue May 29 07:58:25 2018 [22320][62e5fe32-37fa-1550-5c85-4e57c5a34982][FATAL] backtrace:
#0 /home/aceac103/public_html/crm.logan-tech.us/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/aceac103/public_html/crm.logan-tech.us/include/database/DBManager.php(328): DBManager->registerError(‘Error retrievin…’, ‘Error retrievin…’, true)
#2 /home/aceac103/public_html/crm.logan-tech.us/include/database/MysqliManager.php(177): DBManager->checkError(‘Error retrievin…’, true)
#3 /home/aceac103/public_html/crm.logan-tech.us/include/database/MysqlManager.php(281): MysqliManager->query(’(SELECT fp_even…’, true, ‘Error retrievin…’)
#4 /home/aceac103/public_html/crm.logan-tech.us/data/SugarBean.php(1291): MysqlManager->limitQuery(’(SELECT fp_even…’, 0, 11, true, ‘Error retrievin…’)
#5 /home/aceac103/public_html/crm.logan-tech.us/data/SugarBean.php(1018): SugarBean->process_union_list_query(Object(Contact), ‘(SELECT fp_even…’, 0, 11, 11, ‘’, Object(aSubPanel), ‘( SELECT count(…’, Array)
#6 /home/aceac103/public_html/crm.logan-tech.us/include/ListView/ListView.php(1101): SugarBean::get_union_related_list(Object(Contact), ‘fp_events.id as…’, ‘asc’, ‘’, 0, -1, 10, ‘’, Object(aSubPanel))
#7 /home/aceac103/public_html/crm.logan-tech.us/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Contact), Object(aSubPanel), ‘fp_events_conta…’)
#8 /home/aceac103/public_html/crm.logan-tech.us/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview(‘Contacts’, Object(Contact), Object(aSubPanel))
#9 /home/aceac103/public_html/crm.logan-tech.us/include/SubPanel/SubPanelTiles.php(366): SubPanel->ProcessSubPanelListView(‘include/SubPane…’, Array)
#10 /home/aceac103/public_html/crm.logan-tech.us/include/MVC/View/SugarView.php(1193): SubPanelTiles->display()
#11 /home/aceac103/public_html/crm.logan-tech.us/include/MVC/View/SugarView.php(235): SugarView->_displaySubPanels()
#12 /home/aceac103/public_html/crm.logan-tech.us/include/MVC/Controller/SugarController.php(432): SugarView->process()
#13 /home/aceac103/public_html/crm.logan-tech.us/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 /home/aceac103/public_html/crm.logan-tech.us/include/MVC/SugarApplication.php(109): SugarController->execute()
#15 /home/aceac103/public_html/crm.logan-tech.us/index.php(52): SugarApplication->execute()
#16 {main}

[eac]

Ignore last post fixed. Thanks

[pgr]

@eac I’m sure if you get the fix right it should work for you, it’s been working for everyone else. Just add those two parenthesis manually.

[Andyg]

I was going to suggest clearing the browser cache maybe, but looks like you have sorted it already.

Andy

[Eddard]

https://github.com/PedroErnst/SuiteCRM/commit/2b3839c08511a65056d91c246d6aff5af96964e7#diff-8d01ca067f1bcc78f40e5067f8b18c5d

this Worked for me! thanks!!! @pgr

[XavMP]

Didn’t worked for me, link2.php file allready had the correct ().
I’m still having the errors.

Version 7.11.4
Sugar Version 6.5.25 (Build 344)