Update von 4.4 auf 4.9 / Row size too large

[conter]

Hallo zusammen,

ich habe ein Problem nach dem Update von 4.4.55 auf 4.9.21.

Es sind zwar alle Erweiterungen im Manager auf dem aktuellen Stand (siehe Contao-Manager.png)

Das Installtool meldet aber "es ist ein Fehler aufgetreten".

var/logs gibt folgendes aus:

[2021-10-18 11:56:20] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC':  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline." at /var/www/clients/client3/web363/web/v1/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_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC':\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /var/www/clients/client3/web363/web/v1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /var/www/clients/client3/web363/web/v1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /var/www/clients/client3/web363/web/v1/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:137)"} []

Hat jemand eine Idee, wie ich dass beheben kann?

Wie finde ich raus im Backend oder in phpmyadmin, um welche columns es geht?


Viele Grüße,
conter

[conter]

Hallo zusammen,

habe es jetzt so lösen können:

https://community.contao.org/de/show...l=1#post526062


Beim Install bei diesen Eintrag:

ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC

das Häkchen rausnehmen und dann nach und nach die DB aktualisieren, ganz zuletzt dann auch bei ENGINE.


Viele Grüße,
conter

[Spooky]

Poste bitte mal deine composer.json, evt. könnte man hier im Core etwas anpassen.

[conter]

Hier die composer.json

{
    "name": "contao/managed-edition",
    "type": "project",
    "description": "Contao Open Source CMS",
    "license": "LGPL-3.0+",
    "authors": [
        {
            "name": "Leo Feyer",
            "homepage": "https://github.com/leofeyer"
        }
    ],
    "require": {
        "php": "^5.6|^7.0",
        "codefog/contao-mobile_menu": "^2.6",
        "contao/calendar-bundle": "4.9.*",
        "contao/comments-bundle": "4.9.*",
        "contao/conflicts": "*@dev",
        "contao/faq-bundle": "4.9.*",
        "contao/listing-bundle": "4.9.*",
        "contao/manager-bundle": "4.9.*",
        "contao/news-bundle": "4.9.*",
        "contao/newsletter-bundle": "4.9.*",
        "derhaeuptling/contao-mega-menu": "^1.0",
        "madeyourday/contao-rocksolid-custom-elements": "^2.3",
        "madeyourday/contao-rocksolid-slider": "^2.1",
        "terminal42/contao-conditionalformfields": "^2.3",
        "terminal42/contao-mp_forms": "^3.0",
        "terminal42/notification_center": "^1.6"
    },
    "conflict": {
        "contao/core-bundle": "<4.4.1"
    },
    "config": {
        "component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ],
        "post-update-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ]
    }
}