Unable to upgrade from 7.10.14

tkdfilipe · 28 March 2019 15:29

Playing for the first times with SuiteCRM and after installing it though Softaculous i tried to update it with Upgrade Wizard. Then i got this error:

and in the log this shows:

Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Exception handling in /home/brilhopr/public_html/suitecrm/include/MVC/Controller/SugarController.php:400
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Mar 28 15:11:44 2019 [11292][1][FATAL] backtrace:
#0 /home/brilhopr/public_html/suitecrm/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/brilhopr/public_html/suitecrm/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ‘MySQL error 200…’, true)
#2 /home/brilhopr/public_html/suitecrm/include/database/MysqliManager.php(179): DBManager->checkError(’ Query Failed: …’, true)
#3 /home/brilhopr/public_html/suitecrm/data/SugarBean.php(5505): MysqliManager->query(‘SELECT id FROM …’, true)
#4 /home/brilhopr/public_html/suitecrm/modules/Administration/UpgradeHistory.php(175): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 /home/brilhopr/public_html/suitecrm/modules/Administration/UpgradeHistory.php(170): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 /home/brilhopr/public_html/suitecrm/modules/UpgradeWizard/index.php(311): UpgradeHistory->getAll()
#7 /home/brilhopr/public_html/suitecrm/include/MVC/View/SugarView.php(818): include_once(’/home/brilhopr/…’)
#8 /home/brilhopr/public_html/suitecrm/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile(‘modules/Upgrade…’)
#9 /home/brilhopr/public_html/suitecrm/include/MVC/View/SugarView.php(211): ViewClassic->display()
#10 /home/brilhopr/public_html/suitecrm/include/MVC/Controller/SugarController.php(435): SugarView->process()
#11 /home/brilhopr/public_html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/brilhopr/public_html/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()
#13 /home/brilhopr/public_html/suitecrm/index.php(52): SugarApplication->execute()
#14 {main}
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Exception handling in /home/brilhopr/public_html/suitecrm/include/MVC/Controller/SugarController.php:400
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Mar 28 15:14:37 2019 [13266][1][FATAL] backtrace:
#0 /home/brilhopr/public_html/suitecrm/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/brilhopr/public_html/suitecrm/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ‘MySQL error 200…’, true)
#2 /home/brilhopr/public_html/suitecrm/include/database/MysqliManager.php(179): DBManager->checkError(’ Query Failed: …’, true)
#3 /home/brilhopr/public_html/suitecrm/data/SugarBean.php(5505): MysqliManager->query(‘SELECT id FROM …’, true)
#4 /home/brilhopr/public_html/suitecrm/modules/Administration/UpgradeHistory.php(175): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 /home/brilhopr/public_html/suitecrm/modules/Administration/UpgradeHistory.php(170): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 /home/brilhopr/public_html/suitecrm/modules/UpgradeWizard/index.php(311): UpgradeHistory->getAll()
#7 /home/brilhopr/public_html/suitecrm/include/MVC/View/SugarView.php(818): include_once(’/home/brilhopr/…’)
#8 /home/brilhopr/public_html/suitecrm/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile(‘modules/Upgrade…’)
#9 /home/brilhopr/public_html/suitecrm/include/MVC/View/SugarView.php(211): ViewClassic->display()
#10 /home/brilhopr/public_html/suitecrm/include/MVC/Controller/SugarController.php(435): SugarView->process()
#11 /home/brilhopr/public_html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/brilhopr/public_html/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()
#13 /home/brilhopr/public_html/suitecrm/index.php(52): SugarApplication->execute()
#14 {main}
Thu Mar 28 15:14:37 2019 [13269][-none-][FATAL] Mysqli_query failed.
Thu Mar 28 15:14:37 2019 [13269][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away

Any idea what’s going on and what should i do?

Will · 29 March 2019 15:34

It’s pretty clear from this log that your MySQL service is experiencing issues. I’d contact your host. It’s not an issue with the upgrade script from this log excerpt.