Updateversuch von 4.9.29 auf 4.9.30, Aktualisierung der Datenbank schlägt fehl
Ein Updateversuch von 4.9.29 auf 4.9.30 via Contao-Manager führt im Install-Tool zu einem Fehler, im Log steht:
Code:
[2022-06-08 15:53:31] 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.domain.de/contao/install","method":"POST"} []
[2022-06-08 15:53:32] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'playerColor' at row 1" at /www/htdocs/w0.../.../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_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`':\n\nSQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'playerColor' at row 1 at /www/htdocs/w0.../.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'playerColor' at row 1 at /www/htdocs/w0.../.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'playerColor' at row 1 at /www/htdocs/w0.../.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)"} []
In der config.yml steht:
Code:
doctrine:
dbal:
connections:
default:
options:
1002: "SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode, ',TRADITIONAL'))"
PHP 7.4, keine Erweiterungen installiert. Meine Onlinerecherche hat mir bisher keine Erkenntnisse geliefert; kennt das jemand; wo sollte ich mit der Suche ansetzen? Mit einem Downgrade via Contao-Manager funktioniert wieder alles :confused:
