tl_comments

**Birden** · 06.05.2022, 11:24

Nach dem Update von 4.13.3 auf 4.13.4 läßt sich das Install-Tool nicht mehr aufrufen. Im Log steht:

Code:

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://domain.de/contao/install","method":"GET"} []
 request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0C9847s.tl_comments' doesn't exist" at /www/htdocs/w02us34a/domain/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 51 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 1146): An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0C9847s.tl_comments' doesn't exist at /www/htdocs/w02us34a/domain/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:51)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0C9847s.tl_comments' doesn't exist at /www/htdocs/w02us34a/domain/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0C9847s.tl_comments' doesn't exist at /www/htdocs/w02us34a/domain/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:72)"} []

Da fehlt wohl tl_comments in der DB. Keine Ahnung wie ich das behebe, ist mir auch nicht klar für was diese ist

**Spooky** · 07.05.2022, 23:19

Nutze den Debug-Modus und poste den Stack Trace.

**Birden** · 08.05.2022, 05:50

Code:

Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd0C9847s.tl_comments' doesn't exist

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:51
  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), 'SELECT id, `comment` FROM tl_comments WHERE `comment` REGEXP \' rel="lightbox(\\\\[([^\\\\]]+)\\\\])?"\'', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1055)
  at Doctrine\DBAL\Connection->executeQuery('SELECT id, `comment` FROM tl_comments WHERE `comment` REGEXP \' rel="lightbox(\\\\[([^\\\\]]+)\\\\])?"\'', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:866)
  at Doctrine\DBAL\Connection->fetchAllKeyValue('SELECT id, `comment` FROM tl_comments WHERE `comment` REGEXP \' rel="lightbox(\\\\[([^\\\\]]+)\\\\])?"\'')
     (vendor/contao/core-bundle/src/Migration/Version413/RelLightboxMigration.php:66)
  at Contao\CoreBundle\Migration\Version413\RelLightboxMigration->run()
     (vendor/contao/core-bundle/src/Migration/MigrationCollection.php:58)
  at Contao\CoreBundle\Migration\MigrationCollection->run()
     (vendor/contao/installation-bundle/src/InstallTool.php:427)
  at Contao\InstallationBundle\InstallTool->runMigrations()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:361)
  at Contao\InstallationBundle\Controller\InstallationController->runDatabaseUpdates()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:96)
  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))
     (public/index.php:44)

Es läuft auf:
PHP8.1
MariaDB 10.5.15