Upgrade form 5.7.11 to 5.8.5

[Lupre]

Hi all,

We have a problem upgrading from version 5.7.11 to 5.8.5.

We have tried the upgrade like CLI and web interface.

Maria DB 10.3
PHP 7.3.20

Here are the errors when upgrading via CLI

2020-08-06 11:17:01] Espo.WARNING: Cron is not run because it's disabled with 'cronDisabled' param. [] []
[2020-08-06 11:17:13] Espo.INFO: Installation process [5f2be6b8350ad51df]: Start "init" step. [] []
[2020-08-06 11:17:14] Espo.INFO: SCHEMA, Execute Query: ALTER TABLE `contact` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci [] []
[2020-08-06 11:17:14] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs in /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('ALTER TABLE `co...') #1 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Utils/Database/Schema/Schema.php(202): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `co...') #2 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Actions/Base.php(728): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Actions/Base/Install.php(108): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepInit(Array) #7 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'Init', Array) #8 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/Commands/UpgradeStep.php(60): Espo\Core\Upgrades\Base->runInstallStep('Init', Array) #9 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/Commands/UpgradeStep.php(49): Espo\Core\Console\Commands\UpgradeStep->runUpgradeStep('Init', Array) #10 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\UpgradeStep->run(Array, Array, Array) #11 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Application.php(225): Espo\Core\Console\CommandManager->run('UpgradeStep') #12 /var/www/vhosts/kom-an.de/crm.kom-an.de/command.php(39): Espo\Core\Application->runCommand('upgrade-step') #13 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'ALTER TABLE `contact` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci': SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs in /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'ALTER TABLE `co...', Array) #1 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Utils/Database/Schema/Schema.php(202): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `co...') #2 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Actions/Base.php(728): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Actions/Base/Install.php(108): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepInit(Array) #7 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'Init', Array) #8 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/Commands/UpgradeStep.php(60): Espo\Core\Upgrades\Base->runInstallStep('Init', Array) #9 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/Commands/UpgradeStep.php(49): Espo\Core\Console\Commands\UpgradeStep->runUpgradeStep('Init', Array) #10 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\UpgradeStep->run(Array, Array, Array) #11 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Application.php(225): Espo\Core\Console\CommandManager->run('UpgradeStep') #12 /var/www/vhosts/kom-an.de/crm.kom-an.de/command.php(39): Espo\Core\Application->runCommand('upgrade-step') #13 {main} [] []
[2020-08-06 11:17:14] Espo.INFO: SCHEMA, Execute Query: ALTER TABLE `lead` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci [] []
[2020-08-06 11:17:14] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs in /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('ALTER TABLE `le...') #1 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Utils/Database/Schema/Schema.php(202): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `le...') #2 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Actions/Base.php(728): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Actions/Base/Install.php(108): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepInit(Array) #7 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'Init', Array) #8 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/Commands/UpgradeStep.php(60): Espo\Core\Upgrades\Base->runInstallStep('Init', Array) #9 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/Commands/UpgradeStep.php(49): Espo\Core\Console\Commands\UpgradeStep->runUpgradeStep('Init', Array) #10 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\UpgradeStep->run(Array, Array, Array) #11 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Application.php(225): Espo\Core\Console\CommandManager->run('UpgradeStep') #12 /var/www/vhosts/kom-an.de/crm.kom-an.de/command.php(39): Espo\Core\Application->runCommand('upgrade-step') #13 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'ALTER TABLE `lead` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci': SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs in /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /var/www/vhosts/kom-an.de/crm.kom-an.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'ALTER TABLE `le...', Array) #1 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/Utils/Database/Schema/Schema.php(202): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `le...') #2 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/kom-an.de/crm.kom-an.de/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/kom-an.de/crm.kom-
[2020-08-06 11:17:15] Espo.ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2020-08-06 11:17:15] Espo.ERROR: Upgrade Error: Error: Rebuild is failed. Fix all errors before upgrade. [] []

This is only an extract of the error code. Because it's twice as long, I can't post this one

Can anyone tell me what the problem is?

regards
Lutz

[tarasm]

It seems like it's the problem of Maria DB 10.3, https://mariadb.com/kb/en/troublesho...s-with-innodb/

[Lupre]

That's great, thanks for the info. But it would be great to do a database update, because new versions of espoCRM only work with newer databases, if espoCRM fixes these problems via a script or something like that. Because that has nothing to do with an automatic update.

Not everyone is a SQL specialist

It's really annoying

Greetings
Lutz

[tarasm]

In 99% cases upgrade process goes smoothly. Only in some cases can be some issues and it's related to different software version. This is only a small fee for using the self-hosted version

[Lupre]

Late but not too late

Sorry Tarasm, do you want an open source that can be self-hosted or do you want hosting on your end? Without the many users who host themselves and also struggle with problems, espoCRM would not be where it is today. So your answer is not very smart.

It doesn't make a good impression to treat bugs like that, it doesn't build trust. After all, we regularly buy modules and use espoCRM in a professional environment and can expect more from espo employees.

regards