Aktualisierung Datenbank von 4.13.4 auf 4.13.5 schlägt fehl.

**Arachnophilia** · 04.06.2022, 12:57

Hallo Zusammen

ich brauche wieder einmal Hilfe von Euch, weil mir der nachstehende Fehler wieder einmal nichts sagt.
Ich habe die bestehende Installation von Contao 4.13.4 auf die Version 4.13.5 aktualisiert.
Bei der Aktualisierung der Datenbank wird folgender Eintrag in der Log erzeugt.
Ich habe bei solchen Fehlern immer die Sorge, dass bei der Aktualisierung die Installation zerschossen wird.

Allerdings verstehe ich aber auch nicht, dass des öfteren bei Updates Probleme bei der Aktualisierung der Datenbank auftreten.

LG Arachnophilia

Code:

[2022-06-04T13:41:09.935980+02:00] 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.bg-wdf.de/contao/install","method":"POST"} []
[2022-06-04T13:41:10.589507+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3'" at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C499/contao/cms/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1253): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3' at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C499/contao/cms/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1253): SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3' at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C499/contao/cms/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3' at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C499/contao/cms/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

**Spooky** · 04.06.2022, 14:13

Nutze den Debug-Modus und poste den Stack Trace.

**Arachnophilia** · 04.06.2022, 15:44

Moin Spooky

Das ist der Stack Trace

Code:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1814)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1749)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1163)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('49f574f1de27f20bca5d2dd2ec73d135')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Teil2

Code:

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:40)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Logging/Connection.php:53)
  at Doctrine\DBAL\Logging\Connection->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Connection.php:1161)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('49f574f1de27f20bca5d2dd2ec73d135')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Teil3

Code:

PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3'

  at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34
  at PDO->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Logging/Connection.php:53)
  at Doctrine\DBAL\Logging\Connection->exec('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/doctrine/dbal/src/Connection.php:1161)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('49f574f1de27f20bca5d2dd2ec73d135')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Inhalt meiner config.yml

Code:

doctrine:
    dbal:
        connections:
            default:
                default_table_options:
                    charset: utf8
                    collate: utf8_unicode_ci
                options:
                    1002: "SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode, ',TRADITIONAL'))"
contao:
  security:
    two_factor:
      enforce_backend: true

**Spooky** · 04.06.2022, 16:10

Entferne alle doctrine settings.

**Arachnophilia** · 07.06.2022, 08:03

Moin Spooky

Vielen Dank für den Hinweis.

Die Aktualisierung hat jetzt funktioniert. Allerdings auch nicht auf Anhieb.
Die Einräge

Code:

doctrine:
    dbal:
        connections:
            default:
                default_table_options:
                    charset: utf8
                    collate: utf8_unicode_ci
                options:
                    1002: "SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode, ',TRADITIONAL'))"

habe ich herausgenommen und danach den Cache neu aufbauen lassen.

Das Update der Datenbank wurde trotzdem durch Fehler abgebrochen.
Die Auflistung der Aktualisierung war in drei "Abschnitte" gegliedert.
Ich habe dann mit dem letzten Abschnitt angefangen und mich nach oben "gearbeitet".
Das hat dann ohne Fehlermeldungen funktioniert.

Die Einträge von doctrine nehme ich jetzt auch nicht mehr in die config.yml rein.

**cyborgxxl** · 19.12.2022, 08:37

Ich habe nun ein ähnliches Problem nach dem Update auf Contao v4.13.14.

Im Contao Manager wir mir folgendes angezeigt: Datenbank-Migrationen Datenbank-Problem gefunden.

Klicke ich dort drauf öffnet sich der Installer und ich sehe unter anderem folgendes:
ALTER TABLE tl_trusted_device CHANGE device_family device_family VARCHAR(255) DEFAULT NULL
ALTER TABLE tl_trusted_device CHANGE os_family os_family VARCHAR(255) DEFAULT NULL
ALTER TABLE tl_trusted_device CHANGE ua_family ua_family VARCHAR(255) DEFAULT NULL
ALTER TABLE tl_trusted_device CHANGE userClass userClass VARCHAR(255) DEFAULT NULL

Wenn ich hier dann auf "Datenbank aktualisieren klicke, erhalte ich mit eingeschaltetem Debug Modus folgenden Fehler:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1

Im Contao Log steht dann folgendes: 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.pt-tp.at/contao/install","method":"POST"} []
[2022-12-19T09:22:11.813718+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1" at /usr/www/users/fhosting/pt-tp.at/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 86 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(c ode: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /usr/www/users/fhosting/pt-tp.at/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /usr/www/users/fhosting/pt-tp.at/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows rows VARCHAR(8) DEFAULT '2rwh' NOT NULL' at line 1 at /usr/www/users/fhosting/pt-tp.at/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:31)"} []

Hat jemand eine Idee woran das liegen könnte? Ich habe mittlerweile 3 Installationen wo dies auftritt, lustigerweise ist das aber nicht bei allen Installationen so.

**Spooky** · 19.12.2022, 08:48

Lösche die server_version aus deiner parameters.yml

**cyborgxxl** · 19.12.2022, 09:36

Zitat von Spooky

Lösche die server_version aus deiner parameters.yml

Danke, ich hatte da noch ein "database_version: 5.7.38-1" stehen, das ich scheinbar übersehen habe. Diesen Eintrag habe ich gelöscht. Das hat das Problem behomen.

**aitana** · 12.01.2023, 13:56

Hallo zusammen

Ich habe ein ähnliches Problem. Nach einem Update auf die Version 4.13.14 kann ich die Datenbank nicht erneuern.
Die Datenbank-Überprüfung ergab, dass offenbar nur das Schema betroffen ist. Via Installtool erscheinen allerdings Tabellenänderungen. Klick auf Datenbank aktualisieren ergibt eine Fehlermeldung.

config.yml

HTML-Code:

contao:
    image:
        imagine_options:
            jpeg_quality: 80

parameters.yml

HTML-Code:

parameters:
    (...) (database_version steht nicht drin.)
contao:
    url_suffix: ''

Im Moment ist PHP 7.4 eingestellt.

Backend:
Bei Klick auf Seite bearbeiten kommt folgende Fehlermeldung:
Argument 1 passed to Contao\CoreBundle\EventListener\DataContainer\Disa bleCanonicalFieldsListener::__invoke() must be of the type string, null given, called in /home/xxx/www/vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php on line 1960

Das Tiny-Textfeld unter Artikel erscheint ebenfalls nicht mehr..
Die diversen Caches habe ich alle gelöscht und die Packete aktualisiert.
Ausser einer Erweiterung sollten alle Kompatibel sein mit Contao 4.13. Die eine verdächtige Erweiterung (heimrichhannot/dlh_googlemaps) habe ich testeshalber deinstalliert, was nichts gebracht hat.

Stack Traces:

1

HTML-Code:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: 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 vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1907)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1850)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1172)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('2377d3e675d4636834477c2aabbcb006')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)
  at require('/home/xxx/www/web/index.php')
     (web/app.php:13)

2

HTML-Code:

Doctrine\DBAL\Driver\PDO\Exception:
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 vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:37)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Logging/Connection.php:50)
  at Doctrine\DBAL\Logging\Connection->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Connection.php:1170)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('2377d3e675d4636834477c2aabbcb006')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)
  at require('/home/xxx/www/web/index.php')
     (web/app.php:13)

3

HTML-Code:

PDOException:
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 vendor/doctrine/dbal/src/Driver/PDO/Connection.php:31
  at PDO->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:31)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Logging/Connection.php:50)
  at Doctrine\DBAL\Logging\Connection->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/doctrine/dbal/src/Connection.php:1170)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('2377d3e675d4636834477c2aabbcb006')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)
  at require('/home/xxx/www/web/index.php')
     (web/app.php:13)

Zuoberst steht:
HTTP 500 Internal Server Error
An exception occurred while executing a query: 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.

**christian** · 13.01.2023, 09:40

Hallo zusammen,

es scheint sich leider noch nicht ganz rumgesprochen zu haben, aber ich habe schon seit längerer Zeit keine Gelegenheit mehr, die Googlemaps-Erweiterung zu pflegen. Daher fürchte ich, sie "stirbt" spätestens bei einer Umstellung auf PHP 8. Mit 4.13 habe ich auch schon nicht mehr getestet.

Auf dem letzten Camp in Potsdam gab es auch Besprechungen dazu, die Erweiterung dlh_googlemaps ggf. von jemand anderem weiterentwickeln zu lassen. Nur hat sich daraus leider (bisher) nichts ergeben. Also: Falls jemand Lust hat, kann das gerne übernommen werden. Sprecht mich an, was die Konditionen angeht.

Grüße,

Christian