Nach dem Update von 3.2 auf 4.7 funktioniert zwar das Backend (fast) einwandfrei, beim Aufruf des Frontends erhalte ich aber folgende Fehlermeldung:
Code:
[2019-05-09 15:10:54] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_route":"contao_backend","_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction"},"request_uri":"http://www.xxx.de/contao?do=pageimages&id=2&ref=iARmpqpC&rt=j3KSYDRf72NS01VEyNczckdLA4Xd65-xeautNzzrZcI&table=tl_pageimages_items","method":"HEAD"} []
[2019-05-09 15:10:54] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_route":"contao_backend","_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction"},"request_uri":"http://www.xxx.de/contao?do=pageimages&id=2&ref=iARmpqpC&rt=j3KSYDRf72NS01VEyNczckdLA4Xd65-xeautNzzrZcI&table=tl_pageimages_items","method":"GET"} []
[2019-05-09 15:10:54] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing 'SELECT title FROM tl_page WHERE id=': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" at /mnt/web012/c0/71/xxxxxx/htdocs/_contao_4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 99 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT title FROM tl_page WHERE id=':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /mnt/web012/c0/71/xxxxxx/htdocs/_contao_4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:99, Doctrine\\DBAL\\Driver\\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 MySQL server version for the right syntax to use near '' at line 1 at /mnt/web012/c0/71/xxxxxx/htdocs/_contao_4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, 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 MySQL server version for the right syntax to use near '' at line 1 at /mnt/web012/c0/71/xxxxxx/htdocs/_contao_4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} []
Die Seite ist bei Strato gehostet (PowerWeb Basic). Ich habe zuerst Version 4.7 mit Hilfe des ContaoManagers installiert, dann [page_images] manuell auf den Server kopiert und die install-Routine zum Aktualisieren der Datenbank aufgerufen. Anschließend die 4.7er Datenbank geleert, die 'alte' 3.2er Datenbank importiert und noch einmal install.php aufgerufen. Anschließend habe ich den Prod-Cache geleert: einmal per FTP, später noch einmal per ContaoManager.
Wie schon geschrieben: das Backend läuft fast fehlerfrei, nur beim Aufruf eines Inhaltselements im Modul 'Seitenbilder' wird folgende Fehlermeldung ausgespuckt:
Code:
[2019-05-09 15:25:22] request.INFO: Matched route "tl_page.20". {"route":"tl_page.20","route_parameters":{"_token_check":true,"_controller":"Contao\\FrontendIndex::renderPage","_scope":"frontend","_locale":"de","pageModel":"[object] (Contao\\PageModel: {})","parameters":"","_route":"tl_page.20"},"request_uri":"http://www.xxx.de/startseite.html","method":"HEAD"} []
[2019-05-09 15:25:22] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2019-05-09 15:25:22] request.INFO: Matched route "tl_page.20". {"route":"tl_page.20","route_parameters":{"_token_check":true,"_controller":"Contao\\FrontendIndex::renderPage","_scope":"frontend","_locale":"de","pageModel":"[object] (Contao\\PageModel: {})","parameters":"","_route":"tl_page.20"},"request_uri":"http://www.xxx.de/startseite.html","method":"GET"} []
[2019-05-09 15:25:22] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2019-05-09 15:25:23] request.CRITICAL: Uncaught PHP Exception Exception: "Could not find template "a:2:{i:0;s:0:"";i:1;s:0:"";}"" at /mnt/web012/c0/71/5807671/xxxxxx/_contao_4/vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateLoader.php line 155 {"exception":"[object] (Exception(code: 0): Could not find template \"a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}\" at /mnt/web012/c0/71/xxxxxx/htdocs/_contao_4/vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateLoader.php:155)"} []
SSH-Zugang habe ich leider keinen.
Lesezeichen