Upgrade 7.11 Problem

Hello All,

I have a problem when upgrade 7.10 to 7.11,

" Database failure. Please refer to suitecrm.log for details. "

Logs are ;

Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Mysqli_query failed.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Exception handling in /home/isodoort/public_html/crm/include/MVC/Controller/SugarController.php:400
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] Exception in Controller: Veritabanı sorunu. Ayrıntılı bilgi almak için sugarcrm.log dosyasına bakın.
Fri Jan 18 07:01:44 2019 [9028][1][FATAL] backtrace:
#0 ***/crm/include/database/DBManager.php(353): sugar_die(‘Veritaban\xC4\xB1 sor…’)
#1 ***/crm/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 ***/crm/include/database/MysqliManager.php(179): DBManager->checkError(’ Query Failed: …’, true)
#3 ***/crm/data/SugarBean.php(5501): MysqliManager->query(‘SELECT id FROM …’, true)
#4 ***/crm/modules/Administration/UpgradeHistory.php(175): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 ***/crm/modules/Administration/UpgradeHistory.php(170): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 ***/crm/modules/UpgradeWizard/index.php(311): UpgradeHistory->getAll()
#7 ***/crm/include/MVC/View/SugarView.php(818): include_once(’/home/isodoort/…’)
#8 ***/crm/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile(’/home/isodoort/…’)
#9 ***/crm/include/MVC/View/SugarView.php(211): ViewClassic->display()
#10 /crm/include/MVC/Controller/SugarController.php(435): SugarView->process()
#11
/crm/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 ***/crm/include/MVC/SugarApplication.php(113): SugarController->execute()
#13 ***/crm/index.php(52): SugarApplication->execute()
#14 {main}

how can i solve ?
Could you help me ?

“MYSQL server has gone away” is your database process crashing, it really shoudln’t happen.

Since it mentions permissions, check that your database user has enough privileges to change database structure (not just data).

If that’s not it, then the first couple of articles here will give you a (long!) list of other things to check:

https://www.google.com/search?q=MYSQL+server+has+gone+away