Database failure. Please refer to suitecrm.log for details.
After SuiteCRM-7.11.2 fresh install get Database failure
The process of fresh installation of SuiteCRM-7.11.2 goes well. After the installation I go to the host name URL and get
Database failure. Please refer to suitecrm.log for details.
suitecrm.log
[spoiler]Wed Mar 6 12:18:56 2019 [11658][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:18:56 2019 [11658][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:18:56 2019 [11658][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:18:56 2019 [11658][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘11f2bf33-19a6-dd5f-239c-5c7fbaf18628’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:19:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:19:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:19:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:19:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘d37c1569-540a-acca-0e95-5c7fba673661’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:20:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:20:02 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:20:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:20:02 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘79bd14e3-135a-ad09-5313-5c7fba229b5d’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:21:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:21:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:21:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:21:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘e4487c06-6c1a-1fe3-8f05-5c7fbb9aa7da’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:22:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:22:02 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:22:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:22:02 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘39923684-73dd-10fb-312d-5c7fbb6d7fbd’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:23:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:23:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:23:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:23:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘8b34d820-6cae-26e0-a74d-5c7fbb7b6a6a’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:24:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:24:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:24:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:24:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘d2d8fecd-a44d-88d3-b0b2-5c7fbbb7a8a6’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:25:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:25:02 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:25:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:25:02 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘3f21bf7e-4e88-d9d2-602c-5c7fbcbf2b75’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:26:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:26:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:26:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:26:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘9fe252e8-bb5f-3904-1c5b-5c7fbcd4b299’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:27:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:27:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:27:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:27:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘e18b802c-27d1-febc-501d-5c7fbce52f53’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:28:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:28:02 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:28:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:28:02 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘3ea4b7c0-5b1e-71cf-056c-5c7fbcf56bec’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:29:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:29:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:29:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:29:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘88d32352-51aa-5719-8e19-5c7fbda1fe56’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:30:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:30:02 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:30:02 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:30:02 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘26546659-c581-82cd-65e6-5c7fbdec2eb2’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:31:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:31:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:31:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:31:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘8b1d9b4a-1660-228a-6de2-5c7fbd8e2c1d’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:32:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:32:01 2019 [3][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist
Wed Mar 6 12:32:01 2019 [3][-none-][FATAL] Mysqli_query failed.
Wed Mar 6 12:32:01 2019 [3][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘dd0187e4-d6b5-fa4f-f2cc-5c7fbd25f629’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crmfitme_SuiteCRM.outbound_email’ doesn’t exist[/spoiler]
error_log
[06-Mar-2019 12:16:01 UTC] PHP Fatal error: Uncaught Exception: SuiteCRM is not installed. Entry point needs an installed SuiteCRM, please install first. in /home/crmfitmedia/public_html/include/entryPoint.php:59
Stack trace:
#0 /home/crmfitmedia/public_html/cron.php(48): require_once()
#1 {main}
thrown in /home/crmfitmedia/public_html/include/entryPoint.php on line 59
[06-Mar-2019 12:17:01 UTC] PHP Fatal error: Uncaught Exception: SuiteCRM is not installed. Entry point needs an installed SuiteCRM, please install first. in /home/crmfitmedia/public_html/include/entryPoint.php:59
Stack trace:
#0 /home/crmfitmedia/public_html/cron.php(48): require_once()
#1 {main}
thrown in /home/crmfitmedia/public_html/include/entryPoint.php on line 59
[06-Mar-2019 12:18:01 UTC] PHP Fatal error: Uncaught Exception: SuiteCRM is not installed. Entry point needs an installed SuiteCRM, please install first. in /home/crmfitmedia/public_html/include/entryPoint.php:59
Stack trace:
#0 /home/crmfitmedia/public_html/index.php(47): require_once()
#1 {main}
thrown in /home/crmfitmedia/public_html/include/entryPoint.php on line 59
[06-Mar-2019 12:18:42 UTC] PHP Fatal error: Allowed memory size of 44040192 bytes exhausted (tried to allocate 12288 bytes) in /home/crmfitmedia/public_html/vendor/ezyang/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 73
[06-Mar-2019 12:18:56 UTC] PHP Fatal error: Uncaught Exception: Database failure. Please refer to suitecrm.log for details. in /home/crmfitmedia/public_html/include/utils.php:1777
Stack trace:
#0 /home/crmfitmedia/public_html/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /home/crmfitmedia/public_html/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)
#2 /home/crmfitmedia/public_html/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)
#3 /home/crmfitmedia/public_html/include/OutboundEmail/OutboundEmail.php(537): MysqliManager->query('INSERT INTO out...', true)
#4 /home/crmfitmedia/public_html/include/OutboundEmail/OutboundEmail.php(426): OutboundEmail->save()
#5 /home/crmfitmedia/public_html/modules/Administration/Administration.php(163): OutboundEmail->getSystemMailerSettings()
#6 /home/crmfitmedia/public_html/include/entryPoint.php(198): Administration->retrieveSettings()
#7 /home/crmfitmedia/public_html/index.php(47): require_ in /home/crmfitmedia/public_html/include/utils.php on line 1777
I’ve searched forum but not found the solution for this.
Good advice would be very appreciated.