upgrade 5.86 - 5.93 encounter errors

[Patrick]

It's an ESPOCRM system since 4.25, which works great all day long.

It's running 5.85, and I'm trying to upgrade through command line, unfortunately, it prompts me with errors.

[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_target_list","parameters":{" type":"manyMany","entity":"TargetList","relationNa me":"contactTargetList","
key":"id","foreignKey":"id","midKeys":["contactId","targetListId"],"foreign":"contacts","additionalColumns":{"optedO ut":{"type":"bool"}}}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_meeting","parameters":{"type ":"manyMany","entity":"Meeting","relationName":"co ntactMeeting","key":"id",
"foreignKey":"id","midKeys":["contactId","meetingId"],"foreign":"contacts","additionalColumns":{"status ":{"type":"varchar","len":"36","default":"None"}}} } []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_opportunity","parameters":{" type":"manyMany","entity":"Opportunity","relationN ame":"contactOpportunity"
,"key":"id","foreignKey":"id","midKeys":["contactId","opportunityId"],"foreign":"contacts","additionalColumns":{"role": {"type":"varchar","len":50}}}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Document {"tableName":"document_lead","parameters":{"type": "manyMany","entity":"Lead","relationName":"documen tLead","key":"id","forei
gnKey":"id","midKeys":["documentId","leadId"],"foreign":"documents"}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Document {"tableName":"document_opportunity","parameters":{ "type":"manyMany","entity":"Opportunity","relation Name":"documentOpportuni
ty","key":"id","foreignKey":"id","midKeys":["documentId","opportunityId"],"foreign":"documents"}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for KnowledgeBaseArticle {"tableName":"knowledge_base_article_knowledge_bas e_category","parameters":{"type":"manyMany","entit y":"Knowledg
eBaseCategory","relationName":"knowledgeBaseArticl eKnowledgeBaseCategory","key":"id","foreignKey":"i d","midKeys":["knowledgeBaseArticleId","knowledgeBaseCategor yId"],"foreign":"articles"}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Lead {"tableName":"lead_target_list","parameters":{"typ e":"manyMany","entity":"TargetList","relationName" :"leadTargetList","key":"id"
,"foreignKey":"id","midKeys":["leadId","targetListId"],"foreign":"leads","additionalColumns":{"optedOut" :{"type":"bool"}}}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Lead {"tableName":"lead_meeting","parameters":{"type":" manyMany","entity":"Meeting","relationName":"leadM eeting","key":"id","foreignK
ey":"id","midKeys":["leadId","meetingId"],"foreign":"leads","additionalColumns":{"status":{ "type":"varchar","len":"36","default":"None"}} }} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for MassEmail {"tableName":"mass_email_target_list_excluding","p arameters":{"type":"manyMany","entity":"TargetList ","relationName":"massE
mailTargetListExcluding","key":"id","foreignKey":" id","midKeys":["massEmailId","targetListId"],"foreign":"massEmailsExcluding"}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for MassEmail {"tableName":"mass_email_target_list","parameters" :{"type":"manyMany","entity":"TargetList","relatio nName":"massEmailTarget
List","key":"id","foreignKey":"id","midKeys":["massEmailId","targetListId"],"foreign":"massEmails"}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for TargetList {"tableName":"report_target_list","parameters":{"t ype":"manyMany","entity":"Report","relationName":" reportTargetList","key
":"id","foreignKey":"id","midKeys":["targetListId","reportId"],"foreign":"syncTargetLists"}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: prepareManyMany invoked for Product {"tableName":"entity_team","parameters":{"type":"m anyMany","entity":"Team","relationName":"EntityTea m","midKeys":["entityId",
"teamId"],"conditions":{"entityType":"Product"},"additional Columns":{"entityType":{"type":"varchar","len":100 }}}} []
[2020-08-10 07:20:16] Espo.DEBUG: DBAL: Table [entity_team] exists. [] []
[2020-08-10 07:20:16] Espo.DEBUG: Schema\Converter - End: building schema [] []
[2020-08-10 07:20:16] Espo.INFO: SCHEMA, Execute Query: CREATE TABLE `layout_record` (`id` VARCHAR(24) NOT NULL COLLATE utf8_unicode_ci, `name` VARCHAR(255) DEFAULT NULL COLLATE utf8mb4_unicode_ci, `de
leted` TINYINT(1) DEFAULT '0' COLLATE utf8mb4_unicode_ci, `data` MEDIUMTEXT DEFAULT NULL COLLATE utf8mb4_unicode_ci, `layout_set_id` VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, INDEX `IDX_NAME_LA
YOUT_SET_ID` (`name`, `layout_set_id`), INDEX `IDX_LAYOUT_SET` (`layout_set_id`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB [] []
[2020-08-10 07:20:17] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. in /var/www/EspoCRM-4.2.5
/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /var/www/EspoCRM-4.2.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query() #1 /var/www/EspoCRM-4.2.5/appl
ication/Espo/Core/Utils/Database/Schema/Schema.php(202): Doctrine\DBAL\Connection->executeQuery() #2 /var/www/EspoCRM-4.2.5/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Sc
hema->rebuild() #3 /var/www/EspoCRM-4.2.5/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase() #4 /var/www/EspoCRM-4.2.5/application/Espo/Core/Console/Commands/Rebuild.ph
p(36): Espo\Core\DataManager->rebuild() #5 /var/www/EspoCRM-4.2.5/application/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\Rebuild->run() #6 /var/www/EspoCRM-4.2.5/application/E
spo/Core/Application.php(225): Espo\Core\Console\CommandManager->run() #7 /var/www/EspoCRM-4.2.5/command.php(39): Espo\Core\Application->runCommand() #8 {main} Next Doctrine\DBAL\DBALException: An exc
eption occurred while executing 'CREATE TABLE `layout_record` (`id` VARCHAR(24) NOT NULL COLLATE utf8_unicode_ci, `name` VARCHAR(255) DEFAULT NULL COLLATE utf8mb4_unicode_ci, `deleted` TINYINT(1) DEFAU
LT '0' COLLATE utf8mb4_unicode_ci, `data` MEDIUMTEXT DEFAULT NULL COLLATE utf8mb4_unicode_ci, `layout_set_id` VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, INDEX `IDX_NAME_LAYOUT_SET_ID` (`name`, `
layout_set_id`), INDEX `IDX_LAYOUT_SET` (`layout_set_id`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB': SQLSTATE[HY000]: General error: 1709 Index colu
mn size too large. The maximum column size is 767 bytes. in /var/www/EspoCRM-4.2.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /var/www/EspoCRM-4.2.5/vendor/doctrine/dba
l/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query() #1 /var/www/EspoCRM-4.2.5/application/Espo/Core/Utils/Database/Schema/Schema.php(202): Doctrine\DBAL\C
onnection->executeQuery() #2 /var/www/EspoCRM-4.2.5/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild() #3 /var/www/EspoCRM-4.2.5/application/Espo/Core/DataMana
ger.php(62): Espo\Core\DataManager->rebuildDatabase() #4 /var/www/EspoCRM-4.2.5/application/Espo/Core/Console/Commands/Rebuild.php(36): Espo\Core\DataManager->rebuild() #5 /var/www/EspoCRM-4.2.5/applic
ation/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\Rebuild->run() #6 /var/www/EspoCRM-4.2.5/application/Espo/Core/Application.php(225): Espo\Core\Console\CommandManager->run() #
7 /var/www/EspoCRM-4.2.5/command.php(39): Espo\Core\Application->runCommand() #8 {main} [] []
[2020-08-10 07:20:17] Espo.ERROR: Uncaught Exception Espo\Core\Exceptions\Error: "Error while rebuilding database. See log file for details." at /var/www/EspoCRM-4.2.5/application/Espo/Core/DataManager
.php line 104 {"exception":"[object] (Espo\\Core\\Exceptions\\Error(code: 500): Error while rebuilding database. See log file for details. at /var/www/EspoCRM-4.2.5/application/Espo/Core/DataManager.ph
p:104)"} []

Any help would be appreciated.

[item]

Hello,
version of your database and default collation ?

maybe here the solution : https://forum.espocrm.com/forum/inst...-after-upgrade

[emillod]

Patrick do you still have this problem?