Hi All,
Tried running the upgrade from 7.10.4 to 7.10.5 last night as keen to see if it fixed an email problem we were having. Everything appeared to run fine, and I was able to login after completion (having cleared browser cache to be sure). When I go to an account however and click on contact name the box that comes up is messed up in terms of layout, with a warning at the end saying “Database failure, Please refer to suitecrm.log for details.” This same warning also shows if I go into a contact record, with the top part of the record looking fine down as far as the tabs for All, Sales, Marketing, Support etc… the tabs are there and then nothing below them except a line of text with the same “Database Failure,…” warning.
I had the host reset the permissions thinking this might help, but it doesn’t seem to have solved anything. I have also done the usual repair and rebuild (in fact have run most of the options under repair) but to no avail.
In term of the suitecrm.log, the relevant entries around that time are:
Mon May 21 21:37:32 2018 [FATAL] Mysqli_query failed.
Mon May 21 21:37:32 2018 [FATAL] Error running count query for Contact List: Query Failed: ( SELECT count() c 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='---**-***********’ AND fp_events_contacts_c.deleted=0
where fp_events.deleted=0 ): MySQL error 1054: Unknown column ‘contacts.id’ in ‘on clause’
Mon May 21 21:37:32 2018 [FATAL] Exception handling in //********//include/MVC/Controller/SugarController.php:402
Mon May 21 21:37:32 2018 [FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon May 21 21:37:32 2018 [FATAL] backtrace:
#0 ////include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 ////include/database/DBManager.php(328): DBManager->registerError(‘Error running c…’, ‘Error running c…’, true)
#2 ////include/database/MysqliManager.php(177): DBManager->checkError(‘Error running c…’, true)
#3 ////data/SugarBean.php(1510): MysqliManager->query(’( SELECT count(…’, true, ‘Error running c…’)
#4 ////data/SugarBean.php(1260): SugarBean->_get_num_rows_in_query(’( SELECT count(…’, false)
#5 ////data/SugarBean.php(1018): SugarBean->process_union_list_query(Object(Contact), ‘(SELECT fp_even…’, ‘’, -1, 10, ‘’, Object(aSubPanel), ‘( SELECT count(…’, Array)
#6 ////include/ListView/ListView.php(1101): SugarBean::get_union_related_list(Object(Contact), ‘fp_events.id as…’, ‘asc’, ‘’, ‘’, -1, 10, ‘’, Object(aSubPanel))
#7 ////include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Contact), Object(aSubPanel), ‘fp_events_conta…’)
#8 ////include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview(‘Contacts’, Object(Contact), Object(aSubPanel))
#9 ////include/SubPanel/SubPanelTiles.php(366): SubPanel->ProcessSubPanelListView(‘include/SubPane…’, Array)
#10 ////include/MVC/View/SugarView.php(1193): SubPanelTiles->display()
#11 ////include/MVC/View/SugarView.php(235): SugarView->_displaySubPanels()
#12 ////include/MVC/Controller/SugarController.php(432): SugarView->process()
#13 ////include/MVC/Controller/SugarController.php(375): SugarController->processView()
#14 ////include/MVC/SugarApplication.php(109): SugarController->execute()
#15 ////index.php(52): SugarApplication->execute()
#16 {main}
Unfortunately I am not a developer so a bit lost with this, and am hoping somebody can make a suggestion or two beyond what has already been tried.
I do have a backup but only wanted to use that as a last resort really.
Thanks a lot.
Andy