Jetzt bin ich bei einer anderen Installation, habe ein ganz ähnliches Problem mit dem Update: diesmal ist das die Meldung:
Code:
[2022-07-06 15:54:38] 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://rws-salem.de/contao/install","method":"POST"} []
[2022-07-06 15:54:38] 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 /[...contao-inst-pfad...]/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 /[...contao-inst-pfad...]/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 /[...contao-inst-pfad...]/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 /[...contao-inst-pfad...]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)"} []
… und es ist diese Tabellen betroffen:
Code:
ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Das System war vorher 4.9.27 und das Update ist inzwischen 4.9.31. Update ist sauber durchgelaufen.