Ich habe heute nach folgender Anleitung von 4.4 auf 4.9 geupdatet. Nachdem ich im Installtool auf Datenbank aktualisieren geklickt hatte, sprang mir eine Fehlerseite entgegen. Auch nach erneutem Einloggen ins Install-Tool erscheint die Fehlerseite. Dort wird auf die Logdateien verwiesen. In der Log steht folgendes...
Code:
[2021-08-22 01:58:06] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://www.pezcraft.com/contao/install","method":"GET"} []
[2021-08-22 01:58:06] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE UNIQUE INDEX pid_email ON tl_newsletter_recipients (pid, email)': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes" at /home/.sites/423/site2251841/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE UNIQUE INDEX pid_email ON tl_newsletter_recipients (pid, email)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/423/site2251841/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/423/site2251841/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/423/site2251841/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132)"} []
Hier meine composer.json
Code:
{
"name": "contao/managed-edition",
"type": "project",
"description": "Contao Open Source CMS",
"license": "LGPL-3.0-or-later",
"authors": [
{
"name": "Leo Feyer",
"homepage": "https://github.com/leofeyer"
}
],
"require": {
"php": "^5.6 || ^7.0",
"contao/calendar-bundle": "4.9.*",
"contao/comments-bundle": "4.9.*",
"contao/conflicts": "*@dev",
"contao/faq-bundle": "4.9.*",
"contao/listing-bundle": "4.9.*",
"contao/manager-bundle": "4.9.*",
"contao/news-bundle": "4.9.*",
"contao/newsletter-bundle": "4.9.*",
"madeyourday/contao-rocksolid-columns": "^2.0",
"madeyourday/contao-rocksolid-custom-elements": "^2.2",
"madeyourday/contao-rocksolid-icon-picker": "^2.0",
"madeyourday/contao-rocksolid-slider": "^2.0"
},
"conflict": {
"contao/core-bundle": "<4.4.8"
},
"config": {
"component-dir": "assets"
},
"extra": {
"branch-alias": {
"dev-4.4": "4.4.x-dev"
}
},
"scripts": {
"post-install-cmd": [
"Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
],
"post-update-cmd": [
"Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
]
}
}
Ich weiß nicht, ob ihr die composer.lock braucht. Jedenfalls besteht sie aus über 12.000 Zeilen. Meine PHP Version ist 7.4. Ich hoffe, mir kann jemand helfen, damit ich wieder ins Install-Tool rein kann.
Lesezeichen