Hallo,
ich habe mittels der Contao Update-Funktion eine 3.2.1-Installation auf 3.5.38 gehoben. Lief alles problemlos durch - Seite fuktioniert.
Dann Update auf 4.6:
CM aufgerufen, Contao mit notwendigen Erweiterungen installiert, DB, Files und Templates kopiert und dann das Installtool aufgerufen. Beim DB-Update ist dann immer die Installtool-Fehlermeldung aufgepoppt. Nachdem ich das DB-Update Schritt für Schritt durchgegangen bin, sind die folgenden Schritte übriggeblieben (siehe Screenshot). Alle verursachen einen Fehler (siehe Fehlerprotokoll). Etwas absurd, dass für "path" in tl_files , "email" in tl_member und "email" in tl_user ein DROP und auch ein CREATE steht. Ich nehme an dies ist das Problem... Doch wie lösen????
c4update1.jpg
Fehlermeldung im Protokoll aus app/var:
Code:[2019-01-03 10:25:35] 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://xxx/contao/install","method":"POST"} [] [2019-01-03 10:25:35] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE INDEX path ON tl_files (path(191))': SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path'" at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE INDEX path ON tl_files (path(191))':\n\nSQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} [] [2019-01-03 10:25:40] 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://xxx/contao/install","method":"POST"} [] [2019-01-03 10:25:40] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE INDEX email ON tl_member (email(191))': SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'email'" at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE INDEX email ON tl_member (email(191))':\n\nSQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'email' at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'email' at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'email' at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} [] [2019-01-03 10:25:44] 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://xxx/contao/install","method":"POST"} [] [2019-01-03 10:25:44] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE UNIQUE INDEX url ON tl_search (url)': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes" at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE UNIQUE INDEX url ON tl_search (url)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /www/htdocs/xxx/contao4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []
Lesezeichen