Hi!
Got a problem with database. Everywhere in crm got this message “Database failure. Please refer to suitecrm.log for details.”
Even after backing up database, problem still occurs.
Quick Repair and Rebuild:
Clearing Vardefs from cache...done
Clearing language files from cache...done
Clearing Template files from cache...done
Clearing JS files from cache...done
Clearing Vardefs from cache...done
Clearing JS Language files from cache...done
Clearing language files from cache...done
Clearing SuiteCRM Dashlet files from cache...done
Clearing SuiteCRM Feed Cache...done
Clearing Smarty templates from cache...done
Clearing Theme Cache...done
Clearing XML files from cache...done
Clearing Unified Search Cache...done
Clearing External API Cache File...done
Rebuilding Extensions...
Rebuilding Include...
Rebuilding Language...en_us
Rebuilding ActionViewMap...
Rebuilding ActionFileMap...
Rebuilding ActionReMap...
Rebuilding Administration...
Rebuilding EntryPointRegistry...
Rebuilding Extensions...
Rebuilding FileAccessControlMap...
Rebuilding Layoutdefs...
Rebuilding GlobalLinks...
Rebuilding LogicHooks...
Rebuilding Menus...
Rebuilding Include...
Rebuilding ScheduledTasks...
Rebuilding UserPage...
Rebuilding Utils...
Rebuilding Vardefs...
Rebuilding JSGroupings...
Rebuilding Actions...
Rebuilding DC Actions...
Rebuilding RelationshipsDatabase failure. Please refer to suitecrm.log for details.
Suitecrm.log:
Mon Oct 14 15:48:00 2019 [12711][1][FATAL] Mysqli_query failed.
Mon Oct 14 15:48:00 2019 [12711][1][FATAL] Error inserting into table: job_queue: Query Failed: INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
VALUES ('1','6a056df4-cd26-87b2-a584-5da47c68bcd5','Process Workflow Tasks',0,'2019-10-14 13:48:00','2019-10-14 13:48:00','584e3118-781e-a87b-4054-5d87a84070ea','2019-10-14 13:48:00','queued','queued','function::processAOW_Workflow',0,0,''): MySQL error 1142: INSERT command denied to user 'db100043145'@'193.218.152.105' for table 'job_queue'
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Mysqli_query failed.
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Error updating table: email_addresses: Query Failed: UPDATE email_addresses
SET `email_address`='miloscwobrazie@gmail.com',`email_address_caps`='MILOSCWOBRAZIE@GMAIL.COM',`invalid_email`=0,`opt_out`=0,`confirm_opt_in`='confirmed-opt-in',`confirm_opt_in_date`=NULL,`confirm_opt_in_sent_date`=NULL,`confirm_opt_in_fail_date`=NULL,`confirm_opt_in_token`=NULL,`date_created`='2019-09-20 15:28:00',`date_modified`='2019-10-14 13:48:07'
WHERE email_addresses.id = '419fa91b-6312-5ccc-9f49-5d84f0104ac1' AND deleted=0: MySQL error 1142: UPDATE command denied to user 'db100043145'@'193.218.152.105' for table 'email_addresses'
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Exception handling in /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php:400
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Oct 14 15:48:07 2019 [12410][1][FATAL] backtrace:
#0 /www/crm.toto-foto.pl/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /www/crm.toto-foto.pl/include/database/DBManager.php(328): DBManager->registerError('Error updating ...', 'Error updating ...', true)
#2 /www/crm.toto-foto.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error updating ...', true)
#3 /www/crm.toto-foto.pl/include/database/DBManager.php(600): MysqliManager->query('UPDATE email_ad...', true, 'Error updating ...')
#4 /www/crm.toto-foto.pl/data/SugarBean.php(2409): DBManager->update(Object(EmailAddress))
#5 /www/crm.toto-foto.pl/include/SugarEmailAddress/SugarEmailAddress.php(2032): SugarBean->save()
#6 /www/crm.toto-foto.pl/include/SugarObjects/templates/basic/Basic.php(106): SugarEmailAddress->setConfirmedOptInState('confirmed-opt-i...')
#7 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(644): Basic->getEmailAddressFromEmailField('email1')
#8 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(531): EmailUI->getEmailAddressConfirmOptInTick(Object(Lead), 'email1')
#9 /www/crm.toto-foto.pl/modules/Users/User.php(1909): EmailUI->populateComposeViewFields(Object(Lead))
#10 /www/crm.toto-foto.pl/include/SugarObjects/templates/person/Person.php(261): User->getEmailLink('email1', Object(Lead), '', '', 'ListView')
#11 /www/crm.toto-foto.pl/modules/Leads/Lead.php(317): Person->get_list_view_data()
#12 /www/crm.toto-foto.pl/include/ListView/ListViewData.php(456): Lead->get_list_view_data(Array)
#13 /www/crm.toto-foto.pl/include/ListView/ListViewDisplay.php(183): ListViewData->getListViewData(Object(Lead), '(leads.assigned...', 0, '5', Array, Array, 'id', true, NULL)
#14 /www/crm.toto-foto.pl/include/Dashlets/DashletGeneric.php(488): ListViewDisplay->setup(Object(Lead), 'include/Dashlet...', '(leads.assigned...', Array, 0, '5', Array, 'id', NULL)
#15 /www/crm.toto-foto.pl/modules/Home/index.php(244): DashletGeneric->process(Array)
#16 /www/crm.toto-foto.pl/modules/Home/views/view.list.php(54): include('/www/crm.toto-f...')
#17 /www/crm.toto-foto.pl/include/MVC/View/SugarView.php(226): HomeViewList->display()
#18 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#19 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#20 /www/crm.toto-foto.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#21 /www/crm.toto-foto.pl/index.php(52): SugarApplication->execute()
#22 {main}
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Mysqli_query failed.
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Error updating table: email_addresses: Query Failed: UPDATE email_addresses
SET `email_address`='miloscwobrazie@gmail.com',`email_address_caps`='MILOSCWOBRAZIE@GMAIL.COM',`invalid_email`=0,`opt_out`=0,`confirm_opt_in`='confirmed-opt-in',`confirm_opt_in_date`=NULL,`confirm_opt_in_sent_date`=NULL,`confirm_opt_in_fail_date`=NULL,`confirm_opt_in_token`=NULL,`date_created`='2019-09-20 15:28:00',`date_modified`='2019-10-14 13:48:10'
WHERE email_addresses.id = '419fa91b-6312-5ccc-9f49-5d84f0104ac1' AND deleted=0: MySQL error 1142: UPDATE command denied to user 'db100043145'@'193.218.152.105' for table 'email_addresses'
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Exception handling in /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php:400
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Oct 14 15:48:10 2019 [12410][1][FATAL] backtrace:
#0 /www/crm.toto-foto.pl/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /www/crm.toto-foto.pl/include/database/DBManager.php(328): DBManager->registerError('Error updating ...', 'Error updating ...', true)
#2 /www/crm.toto-foto.pl/include/database/MysqliManager.php(179): DBManager->checkError('Error updating ...', true)
#3 /www/crm.toto-foto.pl/include/database/DBManager.php(600): MysqliManager->query('UPDATE email_ad...', true, 'Error updating ...')
#4 /www/crm.toto-foto.pl/data/SugarBean.php(2409): DBManager->update(Object(EmailAddress))
#5 /www/crm.toto-foto.pl/include/SugarEmailAddress/SugarEmailAddress.php(2032): SugarBean->save()
#6 /www/crm.toto-foto.pl/include/SugarObjects/templates/basic/Basic.php(106): SugarEmailAddress->setConfirmedOptInState('confirmed-opt-i...')
#7 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(644): Basic->getEmailAddressFromEmailField('email1')
#8 /www/crm.toto-foto.pl/modules/Emails/EmailUI.php(531): EmailUI->getEmailAddressConfirmOptInTick(Object(Lead), 'email1')
#9 /www/crm.toto-foto.pl/modules/Users/User.php(1909): EmailUI->populateComposeViewFields(Object(Lead))
#10 /www/crm.toto-foto.pl/include/SugarObjects/templates/person/Person.php(261): User->getEmailLink('email1', Object(Lead), '', '', 'ListView')
#11 /www/crm.toto-foto.pl/modules/Leads/Lead.php(317): Person->get_list_view_data()
#12 /www/crm.toto-foto.pl/include/ListView/ListViewData.php(456): Lead->get_list_view_data(Array)
#13 /www/crm.toto-foto.pl/include/ListView/ListViewDisplay.php(183): ListViewData->getListViewData(Object(Lead), '(leads.assigned...', 0, '5', Array, Array, 'id', true, NULL)
#14 /www/crm.toto-foto.pl/include/Dashlets/DashletGeneric.php(488): ListViewDisplay->setup(Object(Lead), 'include/Dashlet...', '(leads.assigned...', Array, 0, '5', Array, 'id', NULL)
#15 /www/crm.toto-foto.pl/modules/Home/index.php(244): DashletGeneric->process(Array)
#16 /www/crm.toto-foto.pl/modules/Home/views/view.list.php(54): include('/www/crm.toto-f...')
#17 /www/crm.toto-foto.pl/include/MVC/View/SugarView.php(226): HomeViewList->display()
#18 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(435): SugarView->process()
#19 /www/crm.toto-foto.pl/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#20 /www/crm.toto-foto.pl/include/MVC/SugarApplication.php(113): SugarController->execute()
#21 /www/crm.toto-foto.pl/index.php(52): SugarApplication->execute()
#22 {main}