Fehler beim DB-Update ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE
Hallo,
ich habe beim Update einer Kundenseite von 4.4.x auf 4.9.4 im Installtool einen DB-Fehler bei
ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
Im Logfile steht dann
Zitat:
[2020-07-16 08:35:56] 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":"http://tablo2020.hvj.de/contao/install","method":"POST"} []
[2020-07-16 08:35:57] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci': SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs" at /usr/www/users/hvjade/hvj4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci':\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/www/users/hvjade/hvj4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/www/users/hvjade/hvj4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/www/users/hvjade/hvj4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []
Führe ich den Fehler direkt in MySQL Admin aus kommt die Meldung kürzer ist aber wohl identisch
Zitat:
#1118 - Zeilenlänge zu groß. Die maximale Zeilenlänge für den verwendeten Tabellentyp (ohne BLOB-Felder) beträgt 65535. Einige Felder müssen in BLOB oder TEXT umgewandelt werden
MySQL 5.7.30-1
Der Hoster ist ein your-server bei Hetzner
Die WebSite an sich läuft auf 4.9.4. Zumindest sehe ich auf die Schnelle keinen Fehler ;)
Hat da jemand eine Idee dazu wie man das lösen kann?