Ergebnis 1 bis 6 von 6

Thema: Update auf 5.2.x- Datenbank Migration fehlgeschlagen

  1. #1
    Contao-Nutzer
    Registriert seit
    13.03.2025.
    Beiträge
    2

    Standard Update auf 5.2.x- Datenbank Migration fehlgeschlagen

    Ein Hallo in die Runde,

    zunächst ich bin kein Progammierer und ich habe mich breit schlagen lassen einen gemeinnützigen Verein bei Ihrer Website zu helfen. Sie hatten vor ca. 4 Jahren für viel Geld für den Verein eine Webseite erstellen lassen. Diese ist mit Contao erstellt. Ich persönlich pflege eigentlich nur zwei Wordpress Webseiten und hatte mit Contao bisher nichts am Hut=Contao DAU.

    Die Webseite des Vereins wurde 4 Jahre nicht gewartet und hatte eine komplett veraltete PHP Version (7.x).
    Also habe ich erstmal den CM aufgesetzt und alles gleichmäig upgedatet. Etliche Stunden später bin ich bei PHP Version 8.1.31 und Contao 5.2.10 (API-Version 2) angekommen.

    Allerdings hat die Migration der Datenbank nicht funktioniert:

    Hier die Fehlermeldung aus den CM:
    Contao\NewsBundle\Migration\FeedMigration

    Ich habe den Cash gelöscht und versucht den Installer zu starten. Leider ohne Erfolg. Hier das Protokoll des Installers aus var/logs:

    Code:
    [2025-03-13T01:47:21.036822+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T01:47:21.391522+01:00] contao.cron.INFO: Purged the expired double opt-in tokens [] {"contao":{"Contao\\CoreBundle\\Monolog\\ContaoContext":"{"func":"Contao\\\\CoreBundle\\\\Cron\\\\PurgeOptInTokensCron::__invoke","action":"CRON","username":"N\\/A","browser":"N\\/A","uri":null,"pageId":null}"}}
    [2025-03-13T01:47:21.403556+01:00] app.ERROR: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_preview_link' doesn't exist in /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33 Stack trace: #0 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(33): PDO->exec() #1 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Connection.php(1216): Doctrine\DBAL\Driver\PDO\Connection->exec() #2 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/PurgePreviewLinksCron.php(33): Doctrine\DBAL\Connection->executeStatement() #3 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/CronJob.php(43): Contao\CoreBundle\Cron\PurgePreviewLinksCron->__invoke() #4 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(195): Contao\CoreBundle\Cron\CronJob->__invoke() #5 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(180): Contao\CoreBundle\Cron\Cron->executeCrons() #6 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(95): Contao\CoreBundle\Cron\Cron->doRun() #7 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/EventListener/CommandSchedulerListener.php(40): Contao\CoreBundle\Cron\Cron->run() #8 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(260): Contao\CoreBundle\EventListener\CommandSchedulerListener->__invoke() #9 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}() #10 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #11 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/HttpKernel.php(115): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #12 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/HttpKernel.php(142): Symfony\Component\HttpKernel\HttpKernel->terminate() #13 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php(84): Symfony\Component\HttpKernel\HttpKernel->terminateWithException() #14 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/error-handler/ErrorHandler.php(538): Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure}() #15 [internal function]: Symfony\Component\ErrorHandler\ErrorHandler->handleException() #16 {main}  Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_preview_link' doesn't exist in /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24 Stack trace: #0 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(39): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Connection.php(1216): Doctrine\DBAL\Driver\PDO\Connection->exec() #2 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/PurgePreviewLinksCron.php(33): Doctrine\DBAL\Connection->executeStatement() #3 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/CronJob.php(43): Contao\CoreBundle\Cron\PurgePreviewLinksCron->__invoke() #4 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(195): Contao\CoreBundle\Cron\CronJob->__invoke() #5 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(180): Contao\CoreBundle\Cron\Cron->executeCrons() #6 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(95): Contao\CoreBundle\Cron\Cron->doRun() #7 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/EventListener/CommandSchedulerListener.php(40): Contao\CoreBundle\Cron\Cron->run() #8 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(260): Contao\CoreBundle\EventListener\CommandSchedulerListener->__invoke() #9 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}() #10 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #11 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/HttpKernel.php(115): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #12 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/HttpKernel.php(142): Symfony\Component\HttpKernel\HttpKernel->terminate() #13 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php(84): Symfony\Component\HttpKernel\HttpKernel->terminateWithException() #14 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/error-handler/ErrorHandler.php(538): Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure}() #15 [internal function]: Symfony\Component\ErrorHandler\ErrorHandler->handleException() #16 {main}  Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_preview_link' doesn't exist in /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49 Stack trace: #0 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Connection.php(1976): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Connection.php(1918): Doctrine\DBAL\Connection->handleDriverException() #2 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Connection.php(1218): Doctrine\DBAL\Connection->convertExceptionDuringQuery() #3 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/PurgePreviewLinksCron.php(33): Doctrine\DBAL\Connection->executeStatement() #4 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/CronJob.php(43): Contao\CoreBundle\Cron\PurgePreviewLinksCron->__invoke() #5 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(195): Contao\CoreBundle\Cron\CronJob->__invoke() #6 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(180): Contao\CoreBundle\Cron\Cron->executeCrons() #7 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Cron/Cron.php(95): Contao\CoreBundle\Cron\Cron->doRun() #8 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/EventListener/CommandSchedulerListener.php(40): Contao\CoreBundle\Cron\Cron->run() #9 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(260): Contao\CoreBundle\EventListener\CommandSchedulerListener->__invoke() #10 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}() #11 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners() #12 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/HttpKernel.php(115): Symfony\Component\EventDispatcher\EventDispatcher->dispatch() #13 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/HttpKernel.php(142): Symfony\Component\HttpKernel\HttpKernel->terminate() #14 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php(84): Symfony\Component\HttpKernel\HttpKernel->terminateWithException() #15 /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/error-handler/ErrorHandler.php(538): Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure}() #16 [internal function]: Symfony\Component\ErrorHandler\ErrorHandler->handleException() #17 {main} [] []
    [2025-03-13T01:47:21.412316+01:00] contao.cron.INFO: Purged the temp folder [] {"contao":{"Contao\\CoreBundle\\Monolog\\ContaoContext":"{"func":"Contao\\\\CoreBundle\\\\Cron\\\\PurgeTempFolderCron::__invoke","action":"CRON","username":"N\\/A","browser":"N\\/A","uri":null,"pageId":null}"}}
    [2025-03-13T03:58:38.310714+01:00] request.INFO: Matched route "contao_core_robotstxt__invoke". {"route":"contao_core_robotstxt__invoke","route_parameters":{"_route":"contao_core_robotstxt__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\RobotsTxtController"},"request_uri":"https://www.kirche-kletzen.org/robots.txt","method":"GET"} []
    [2025-03-13T03:58:38.696483+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T03:58:39.051181+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T03:58:39.054043+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T04:30:49.569687+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T04:30:49.891692+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T04:30:49.893395+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T04:34:12.871100+01:00] request.INFO: Matched route "contao_core_robotstxt__invoke". {"route":"contao_core_robotstxt__invoke","route_parameters":{"_route":"contao_core_robotstxt__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\RobotsTxtController"},"request_uri":"https://www.kirche-kletzen.org/robots.txt","method":"GET"} []
    [2025-03-13T04:34:13.128490+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T04:34:13.387227+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T04:34:13.389357+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T04:47:15.965896+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T04:47:16.330225+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T04:47:16.332081+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T07:11:05.059662+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T07:11:05.442004+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T07:11:05.443886+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T07:42:22.755225+01:00] request.INFO: Matched route "contao_core_robotstxt__invoke". {"route":"contao_core_robotstxt__invoke","route_parameters":{"_route":"contao_core_robotstxt__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\RobotsTxtController"},"request_uri":"https://www.kirche-kletzen.org/robots.txt","method":"GET"} []
    [2025-03-13T07:42:22.966329+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T07:42:23.181781+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T07:42:23.183721+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T07:42:24.728715+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T07:42:24.977036+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T07:42:24.981783+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:00:14.232139+01:00] request.INFO: Matched route "contao_core_favicon__invoke". {"route":"contao_core_favicon__invoke","route_parameters":{"_route":"contao_core_favicon__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\FaviconController"},"request_uri":"https://kirche-kletzen.org/favicon.ico","method":"GET"} []
    [2025-03-13T08:00:14.510675+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T08:00:14.774121+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:00:14.776143+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:16:25.130114+01:00] request.INFO: Matched route "contao_core_robotstxt__invoke". {"route":"contao_core_robotstxt__invoke","route_parameters":{"_route":"contao_core_robotstxt__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\RobotsTxtController"},"request_uri":"https://kirche-kletzen.org/robots.txt","method":"GET"} []
    [2025-03-13T08:16:25.349454+01:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Contao\CoreBundle\Routing\Page\PageRoute::getUrlPrefix(): Return value must be of type string, null returned" at PageRoute.php line 106 {"exception":"[object] (TypeError(code: 0): Contao\\CoreBundle\\Routing\\Page\\PageRoute::getUrlPrefix(): Return value must be of type string, null returned at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/contao/core-bundle/src/Routing/Page/PageRoute.php:106)"} []
    [2025-03-13T08:16:25.583075+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:16:25.585029+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:26:08.169894+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list'" at ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []
    [2025-03-13T08:26:08.552681+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:26:08.554791+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:26:08.576443+01:00] request.CRITICAL: Uncaught PHP Exception Symfony\Component\Messenger\Exception\HandlerFailedException: "Handling "Contao\CoreBundle\Messenger\Message\SearchIndexMessage" failed: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist" at HandleMessageMiddleware.php line 124 {"exception":"[object] (Symfony\\Component\\Messenger\\Exception\\HandlerFailedException(code: 1146): Handling "Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage" failed: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124)\n[previous 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 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []
    [2025-03-13T08:26:08.641677+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:26:08.641880+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:59:56.027888+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list'" at ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []
    [2025-03-13T08:59:56.490839+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:59:56.492808+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:59:56.519862+01:00] request.CRITICAL: Uncaught PHP Exception Symfony\Component\Messenger\Exception\HandlerFailedException: "Handling "Contao\CoreBundle\Messenger\Message\SearchIndexMessage" failed: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist" at HandleMessageMiddleware.php line 124 {"exception":"[object] (Symfony\\Component\\Messenger\\Exception\\HandlerFailedException(code: 1146): Handling "Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage" failed: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124)\n[previous 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 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []
    [2025-03-13T08:59:56.559104+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:59:56.559245+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:59:58.642211+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list'" at ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'urlPrefix' in 'field list' at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []
    [2025-03-13T08:59:58.708304+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:59:58.708579+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    [2025-03-13T08:59:58.713050+01:00] request.CRITICAL: Uncaught PHP Exception Symfony\Component\Messenger\Exception\HandlerFailedException: "Handling "Contao\CoreBundle\Messenger\Message\SearchIndexMessage" failed: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist" at HandleMessageMiddleware.php line 124 {"exception":"[object] (Symfony\\Component\\Messenger\\Exception\\HandlerFailedException(code: 1146): Handling "Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage" failed: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124)\n[previous 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 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs3909321.tl_search_term' doesn't exist at /mnt/web005/b3/87/511504287/htdocs/Update2025/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} []
    [2025-03-13T08:59:58.756499+01:00] messenger.INFO: Sending message Contao\CoreBundle\Messenger\Message\SearchIndexMessage with contao_prio_low sender using Contao\CoreBundle\Messenger\Transport\AutoFallbackTransport {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","alias":"contao_prio_low","sender":"Contao\\CoreBundle\\Messenger\\Transport\\AutoFallbackTransport"} []
    [2025-03-13T08:59:58.756664+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
    Was mir Sorgen bereitet, wenn ich den CM starte fehlen alle Pakete und das Theme
    Kann das daran liegen, dass ich für 5.2 ein neues Verzeichnis erstellt habe?

    Habt ihr Ideen? Oder soll ich lieber die Sicherheitskopie aufsetzten und versuchen den Urzustand herzustellen.

    Lieben Dank, Katrin
    Geändert von xchs (13.03.2025 um 20:56 Uhr)

  2. #2
    Alter Contao-Hase
    Registriert seit
    24.02.2021.
    Beiträge
    1.490
    Partner-ID
    11715
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Zitat Zitat von Kafibu Beitrag anzeigen
    Die Webseite des Vereins wurde 4 Jahre nicht gewartet und hatte eine komplett veraltete PHP Version (7.x).
    Also habe ich erstmal den CM aufgesetzt und alles gleichmäig upgedatet. Etliche Stunden später bin ich bei PHP Version 8.1.31 und Contao 5.2.10 (API-Version 2) angekommen.
    5.2 hat sein Lebensende erreicht (und hat somit vermutlich ein paar Bugs). Du solltest zunächst auf Contao 5.3 aktualisieren.
    PHP 8.1 hat auch sein Lebensende erreicht, du solltest mindestens auf PHP 8.2, besser aber auf 8.3 (oder 8.4) aktualisieren.

  3. #3
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    37.197
    Partner-ID
    10107

    Standard

    Das heißt du warst vorher auf Contao 4?
    » sponsor me via GitHub or Revolut

  4. #4
    Contao-Nutzer
    Registriert seit
    13.03.2025.
    Beiträge
    2

    Standard

    Die ursprüngliche Version von 2019 war Contao 4.9.20, dann hatte ich ein Update -> alles war noch super. Website lief. Den 5'er Sprung hat es nicht mitgemacht. Nichts geht vor oder zurück. Auch nicht 5.3 das wäre toll, dann hätte der Verein etwas Ruhe. Aber egal welche PHP- Version ich verwende. Ich scheitere an der Datenmigration. Ich kann nicht nachvollziehen, was der Contao Manager mit Datenbank Änderung meint.

    Ich habe jetzt die PHP 8.2 versucht , die Contao Mangerversion ist aktualisiert auf bei 1.9.4. aber der Zustand bleibt leider gleich.

    Am Wochenende möchte ich gerne weiter machen, ggfs. den alten Stand aufsetzten und von vorn bis 4.13 und dann den 5er Sprung spare ich mir vorerst.
    Angehängte Grafiken Angehängte Grafiken
    Geändert von Kafibu (13.03.2025 um 16:00 Uhr)

  5. #5
    Community-Moderatorin & Contao-Urgestein Avatar von mlweb
    Registriert seit
    10.07.2011.
    Beiträge
    7.438
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Solche Versionssprünge (Majorversion) sollte man m.E. immer in einer Parallelinstallation machen. Da sind in der Regel Nacharbeiten erforderlich, die den Livebetrieb einer Seite nur unnötig beeinträchtigen.
    Ich habe Dir mit meinen Hinweisen geholfen und Du möchtest Dich bedanken?
    Unterstütze bitte das Contao-Projekt (Button Links)
    Weitere Spendenmöglichkeiten
    ------------------------------------------------------------------------------------------------------
    Contao-Dokumentation: Contao-Handbuch und Contao-Entwickler-Doku
    Contao-Online-Video-Kurse: Contao Academy
    Funktionalität erweitern: Contao-Erweiterungen

    Für Dinge die man mit html5 und css3 lösen kann, braucht man kein javascript.




  6. #6
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    37.197
    Partner-ID
    10107

    Standard

    Zitat Zitat von Kafibu Beitrag anzeigen
    Die ursprüngliche Version von 2019 war Contao 4.9.20, dann hatte ich ein Update
    Zuerst auf 4.13.53?
    » sponsor me via GitHub or Revolut

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •