Hi,
I have upgraded my SuiteCRM version from 7.6.4 to 7.10.7.
After CRM upgarde, when I send email to any account email or contact email, I found “Root User<>” in place of from name and from email in received email.
Please suggest how to resolve this.
Thanks in advance,
Harendra
This bug is fixed on 7.10.8 which came out… today!
Hi pgr,
Thanks for your suggestion.
Now I am trying to upgrade my SuiteCRM to 7.10.9 it is showing error “Database failure. Please refer to suitecrm.log for details.” in upgrade wizard.
upgradeWizard.log updated with below error during this process :
Mon, 24 Sep 2018 11:05:08 +0000 [UpgradeWizard] - setting session variables…
Mon, 24 Sep 2018 11:05:08 +0000 [UpgradeWizard] - -----------------------------------------------------------------------------
Mon, 24 Sep 2018 11:05:08 +0000 [UpgradeWizard] - Upgrade started. At start.php
Mon, 24 Sep 2018 11:05:08 +0000 [UpgradeWizard] - at unlinkUWTempFiles()
Mon, 24 Sep 2018 11:05:08 +0000 [UpgradeWizard] - finished!
Mon, 24 Sep 2018 11:05:08 +0000 [UpgradeWizard] - resetting $_SESSION
Mon, 24 Sep 2018 11:05:12 +0000 [UpgradeWizard] - setting session variables…
Mon, 24 Sep 2018 11:05:12 +0000 [UpgradeWizard] - [At systemCheck.php]
Mon, 24 Sep 2018 11:05:12 +0000 [UpgradeWizard] - Starting file permission check…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Finished file permission check.
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Starting database permissions check…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking CREATE TABLE permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot CREATE TABLE!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking INSERT INTO permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot INSERT INTO!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot UPDATE TABLE!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking SELECT permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot SELECT!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking DELETE FROM permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot DELETE FROM!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot ADD COLUMN!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot CHANGE COLUMN!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot DROP COLUMN!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Checking DROP TABLE permissions…
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - cannot DROP TABLE!
Mon, 24 Sep 2018 11:06:34 +0000 [UpgradeWizard] - Finished database permissions check.
suitecrm.log was updated by below errors during the process :
Mon Sep 24 11:04:24 2018 [27344][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Mysqli_query failed.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Exception handling in /home/shirtwor/public_html/suite/include/MVC/Controller/SugarController.php:402
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Sep 24 11:06:34 2018 [27456][1][FATAL] backtrace:
#0 /home/shirtwor/public_html/suite/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/shirtwor/public_html/suite/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 /home/shirtwor/public_html/suite/include/database/MysqliManager.php(177): DBManager->checkError(’ Query Failed: …’, true)
#3 /home/shirtwor/public_html/suite/data/SugarBean.php(5519): MysqliManager->query(‘SELECT id FROM …’, true)
#4 /home/shirtwor/public_html/suite/modules/Administration/UpgradeHistory.php(171): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 /home/shirtwor/public_html/suite/modules/Administration/UpgradeHistory.php(167): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 /home/shirtwor/public_html/suite/modules/UpgradeWizard/index.php(312): UpgradeHistory->getAll()
#7 /home/shirtwor/public_html/suite/include/MVC/View/SugarView.php(840): include_once(’/home/shirtwor/…’)
#8 /home/shirtwor/public_html/suite/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile(’/home/shirtwor/…’)
#9 /home/shirtwor/public_html/suite/include/MVC/View/SugarView.php(207): ViewClassic->display()
#10 /home/shirtwor/public_html/suite/include/MVC/Controller/SugarController.php(432): SugarView->process()
#11 /home/shirtwor/public_html/suite/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/shirtwor/public_html/suite/include/MVC/SugarApplication.php(109): SugarController->execute()
#13 /home/shirtwor/public_html/suite/index.php(54): SugarApplication->execute()
#14 {main}
SuiteCRM was upgrading till existing version smoothly.
Please suggest how to resolve this.
Thanks,
Harendra
Answered here:
Let’s keep the discussion going in that other thread, to avoid duplicating things. Thanks.