Fehler nach Update

**strich-sieben** · 31.05.2023, 12:24

Hallo, nach einem eigentlich erfolgreichen Update auf 4.13.24 wird das Frontend angezeigt, bekomme aber im Backend bei Änderungen Fehler angezeigt, beispielweise diesen:

An exception occourred while executing a query: SQLSTATE[23000]: Integrity contraint violation: 1048 Column 'imageURL" cannot be null

Die Datenbanküberprüfung im CM läuft ohne Probleme durch. Im Log steht:

Code:

Uncaught PHP Exception 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 /var/www/vhosts/xxxxxxxxxxxxx.de/con413/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 117 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1118): 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 /var/www/vhosts/fortuna-sport.de/con413/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1118): 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/vhosts/xxxxxx.de/con413/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (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/vhosts/xxxxxxxx.de/con413/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32)"} []

Wo könnte der Fehler liegen?

Grüße, Ben

**Spooky** · 31.05.2023, 12:28

"imageURL" ist kein reguläres Feld von Contao. Du musst herausfinden von welcher Extension das kommt.

Darüberhinaus solltest du den Debug-Modus nutzen und den Stack Trace des Fehlers posten.

**tschero** · 31.05.2023, 12:36

Moin,

verwendest Du ein externes Theme?

Grüße

**strich-sieben** · 31.05.2023, 12:38

Bei der Website ist das Theme TAO von Rocksolid im Einsatz.

**strich-sieben** · 31.05.2023, 12:41

STACK-Trace gibt folgendes aus:

Code:

ErrorException:
Warning: Undefined property: stdClass::$maintenanceMode

  at vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:766
  at Contao\Controller::getPageStatusIcon()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:1031)
  at Contao\Backend::addPageIcon()
     (vendor/contao/core-bundle/src/Resources/contao/dca/tl_page.php:1414)
  at tl_page->addIcon()
     (vendor/contao/core-bundle/src/Resources/contao/classes/DataContainer.php:1779)
  at Contao\DataContainer->generateRecordLabel()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4156)
  at Contao\DC_Table->generateTree()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:3785)
  at Contao\DC_Table->treeView()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:302)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/vhosts/xxxxxx.de/con413/web/index.php')
     (web/app.php:13)

**tschero** · 31.05.2023, 12:43

Zitat von strich-sieben

Bei der Website ist das Theme TAO von Rocksolid im Einsatz.

Ist das Theme auf aktuellem Stand?

**Spooky** · 31.05.2023, 12:46

Das ist ein anderer Fehler. Ist deine Datenbank am aktuellen Stand?

**strich-sieben** · 31.05.2023, 12:57

Die Überprüfung im Contao-Manager läuft immer fehlerfrei durch. Wenn ich allerdings per Install die Datenbank aktualisieren möchte, gibt Contao einen Fehler aus.

**Spooky** · 31.05.2023, 12:59

Zitat von strich-sieben

Wenn ich allerdings per Install die Datenbank aktualisieren möchte, gibt Contao einen Fehler aus.

Und welchen?

Nur so als generelles Feedback: anstatt alles aus dir herauszukitzeln wäre es besser, wenn du in Eigeninitiative gleich immer mehr Informationen - wie eben Fehlermeldungen und Stack Traces - preis gibst

**strich-sieben** · 31.05.2023, 13:31

Hallo Spooky,
da muss ich Dir recht geben, das wäre besser und einfacher.

Hier nun die Fehlermeldungen, die das Installtool bei der Aktualisierung der Datenbank ausgibt:

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()
     (vendor/doctrine/dbal/src/Connection.php:1935)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1878)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:1206)
  at Doctrine\DBAL\Connection->executeStatement()
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand()
     (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()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/vhosts/xxxxxx.de/con413/web/index.php')
     (web/app.php:13)

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()
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:38)
  at Doctrine\DBAL\Driver\PDO\Connection->exec()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec()
     (vendor/doctrine/dbal/src/Logging/Connection.php:50)
  at Doctrine\DBAL\Logging\Connection->exec()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:86)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec()
     (vendor/doctrine/dbal/src/Connection.php:1204)
  at Doctrine\DBAL\Connection->executeStatement()
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand()
     (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()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/vhosts/xxxxxxx.de/con413/web/index.php')
     (web/app.php:13)

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:32
  at PDO->exec()
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32)
  at Doctrine\DBAL\Driver\PDO\Connection->exec()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec()
     (vendor/doctrine/dbal/src/Logging/Connection.php:50)
  at Doctrine\DBAL\Logging\Connection->exec()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:86)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec()
     (vendor/doctrine/dbal/src/Connection.php:1204)
  at Doctrine\DBAL\Connection->executeStatement()
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand()
     (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()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/index.php:44)
  at require('/var/www/vhosts/xxxxx.de/con413/web/index.php')
     (web/app.php:13)

Reicht das oder soll ich die "logs" auch noch ausgeben? Dev oder Prod?

**Spooky** · 31.05.2023, 14:57

Deine Datenbank ist jedenfalls nicht aktuell. Bevor du dich um die anderen Probleme kümmern kannst, musst du sicherstellen, dass die Datenbank aktuell ist.

Welche Datenbankänderungen wollen ausgeführt werden im Install Tool?

**strich-sieben** · 31.05.2023, 16:02

Habe es geschafft, die Datenbank schrittweise zu aktualisieren.

So wie es jetzt aussieht, läuft die Website jetzt, sowohl im Front- als auch im Backend. Vielen Dank für die Hilfestellung, das Forum hat mir schon sehr oft geholfen und so kann ich schrittweise dazulernen.