Gelöst: Install meldet Fehler bei Update DB
Hallo,
Contao 4.9.29 mit Theme Constructeur, php Version 7.4.x
Beim Update folgender Tabellenänderungen
ALTER TABLE tl_search CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_search CHANGE title title TEXT DEFAULT NULL
erfolgt ein Abbruch der DB Aktualisierung. Im Logfile steht folgender Eintrag ...
[2022-05-20 18:48:23] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_ro ute":"contao_install","_scope":"backend","_token_c heck":true,"_controller":"Contao\\InstallationBund le\\Controller\\InstallationController::installAct ion"},"request_uri":"https://www.marcher-wirtschaftskreis.de/contao/install","method":"POST"} []
[2022-05-20 18:48:23] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_search CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL COLLATE `ascii_bin`': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes" at /homepages/36/d153470734/htdocs/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_search CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL COLLATE `ascii_bin`':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /homepages/36/d153470734/htdocs/cms/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 /homepages/36/d153470734/htdocs/cms/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 /homepages/36/d153470734/htdocs/cms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)"} []
Die config.yml beinhaltet ...
doctrine:
dbal:
connections:
default:
options:
1002: "SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode, ',TRADITIONAL'))"
default_table_options:
charset: utf8
collate: utf8_unicode_ci
engine: MyISAM
contao:
prepend_locale: true
Woran kann das Problem liegen?