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.
Lesezeichen