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.
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}