Update wizard stuck

📦 Install & Upgrade Help
1

Update wizard stuck not sure what to do, this is the database error.

Mon Oct 28 15:19:12 2019 [4521][eef414a8-7cae-6bc0-cb3c-58b0751658d2][FATAL] Mysqli_query failed.
Mon Oct 28 15:19:12 2019 [4521][eef414a8-7cae-6bc0-cb3c-58b0751658d2][FATAL] Query Failed: ALTER TABLE users modify COLUMN first_name varchar(255) NULL , modify COLUMN last_name varchar(255) NULL : MySQL error 1071: Specified key was too long; max key length is 1000 bytes
Mon Oct 28 15:19:12 2019 [4521][eef414a8-7cae-6bc0-cb3c-58b0751658d2][FATAL] Exception handling in /home/stopdelivery/public_html/SuiteCRM/include/MVC/Controller/SugarController.php:400
Mon Oct 28 15:19:12 2019 [4521][eef414a8-7cae-6bc0-cb3c-58b0751658d2][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Oct 28 15:19:12 2019 [4521][eef414a8-7cae-6bc0-cb3c-58b0751658d2][FATAL] backtrace:
#0 /home/stopdelivery/public_html/SuiteCRM/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/stopdelivery/public_html/SuiteCRM/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, ‘Error with MySQ…’)
#2 /home/stopdelivery/public_html/SuiteCRM/include/database/MysqliManager.php(179): DBManager->checkError(’ Query Failed: …’, ‘Error with MySQ…’)
#3 /home/stopdelivery/public_html/SuiteCRM/include/database/MysqlManager.php(616): MysqliManager->query(‘ALTER TABLE use…’, ‘Error with MySQ…’)
#4 /home/stopdelivery/public_html/SuiteCRM/include/database/DBManager.php(764): MysqlManager->repairTableParams(‘users’, Array, Array, true, NULL)
#5 /home/stopdelivery/public_html/SuiteCRM/modules/UpgradeWizard/end.php(86): DBManager->repairTable(Object(Group), true)
#6 /home/stopdelivery/public_html/SuiteCRM/modules/UpgradeWizard/index.php(296): require(’/home/stopdeliv…’)
#7 /home/stopdelivery/public_html/SuiteCRM/include/MVC/View/SugarView.php(834): include_once(’/home/stopdeliv…’)
#8 /home/stopdelivery/public_html/SuiteCRM/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile(‘modules/Groups/…’)
#9 /home/stopdelivery/public_html/SuiteCRM/include/MVC/View/SugarView.php(226): ViewClassic->display()
#10 /home/stopdelivery/public_html/SuiteCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#11 /home/stopdelivery/public_html/SuiteCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/stopdelivery/public_html/SuiteCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#13 /home/stopdelivery/public_html/SuiteCRM/index.php(52): SugarApplication->execute()
#14 {main}

2

It helps if you tell us which version you’re upgrading from, and which version you’re upgrading to.

This is a known issue in some upgrades, you’ll find many threads with this problem and solutions.

3

Stuck on 7.11.7
not sure what thread fixes the problem

4

Ok, sorry, let me elaborate. This is the distinctive part of your logs:

Please start by trying to apply these simple changes:

Then delete the entire directory called cache/upgrades/temp, if it exists, and try the upgrade again. Thanks.