Database Error Upgrading 7.11.5 to 7.11.8

📦 Install & Upgrade Help
1

When upgrading 7.11.5 to 7.11.8 I get the following error:

Tue Sep  3 09:44:22 2019 [1820][1][FATAL] Error adding index:  Query Failed:CREATE INDEX idx_user_name ON users (user_name,is_group,status,last_name (30),first_name (30),id)::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '('.
Tue Sep  3 09:44:22 2019 [1820][1][FATAL] Exception handling in C:\ecmcrm\htdocs\sugarcrm\include\MVC\Controller\SugarController.php:400
Tue Sep  3 09:44:22 2019 [1820][1][FATAL] Exception in Controller: Datenbank Fehler. Bitte sehen Sie in der Datei suitecrm.log nach.
Tue Sep  3 09:44:22 2019 [1820][1][FATAL] backtrace:
#0 C:\ecmcrm\htdocs\sugarcrm\include\database\DBManager.php(353): sugar_die('Datenbank Fehle...')
#1 C:\ecmcrm\htdocs\sugarcrm\include\database\DBManager.php(328): DBManager->registerError('Error adding in...', 'Error adding in...', true)
#2 C:\ecmcrm\htdocs\sugarcrm\include\database\SqlsrvManager.php(235): DBManager->checkError('Error adding in...', true)
#3 C:\ecmcrm\htdocs\sugarcrm\include\database\DBManager.php(1173): SqlsrvManager->query('CREATE INDEX id...', true, 'Error adding in...')
#4 C:\ecmcrm\htdocs\sugarcrm\include\database\DBManager.php(1224): DBManager->addIndexes('users', Array, true)
#5 C:\ecmcrm\htdocs\sugarcrm\include\database\DBManager.php(1017): DBManager->modifyIndexes('users', Array, true)
#6 C:\ecmcrm\htdocs\sugarcrm\include\database\DBManager.php(764): DBManager->repairTableParams('users', Array, Array, true, NULL)
#7 C:\ecmcrm\htdocs\sugarcrm\modules\UpgradeWizard\end.php(86): DBManager->repairTable(Object(Group), true)
#8 C:\ecmcrm\htdocs\sugarcrm\modules\UpgradeWizard\index.php(296): require('C:\\ecmcrm\\htdoc...')
#9 C:\ecmcrm\htdocs\sugarcrm\include\MVC\View\SugarView.php(834): include_once('C:\\ecmcrm\\htdoc...')
#10 C:\ecmcrm\htdocs\sugarcrm\include\MVC\View\views\view.classic.php(72): SugarView->includeClassicFile('modules/Groups/...')
#11 C:\ecmcrm\htdocs\sugarcrm\include\MVC\View\SugarView.php(226): ViewClassic->display()
#12 C:\ecmcrm\htdocs\sugarcrm\include\MVC\Controller\SugarController.php(435): SugarView->process()
#13 C:\ecmcrm\htdocs\sugarcrm\include\MVC\Controller\SugarController.php(375): SugarController->processView()
#14 C:\ecmcrm\htdocs\sugarcrm\include\MVC\SugarApplication.php(113): SugarController->execute()
#15 C:\ecmcrm\htdocs\sugarcrm\index.php(52): SugarApplication->execute()
#16 {main}

The error is in “last_name(30)” and “first_name(30)”. Where does that come from and how can I fix this?

Running on: Windows 2012R2, Apache 2.4, PHP 7.3.6, SQL Server 2014

2

This is known issue with MS SQL, see this thread, I believe it has a work-around

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/27042-upgrade-packate-7-10-x-to-7-10-19-db-error-create-index-last-name-30-fails

It seems all you need to do is run a Quick Repair and Rebuild

3

Yep, that is what I did, too (remove the “(30)” from the index descriptions in the *vardef.php"). But I’d prefer a solution that does not come up with a “Database error” during the update.