Es war wohl die Installation der Erweiterung »jrgregory/m17-sticky-backend-footer«, die offensichtlich (noch) nicht kompatibel mit Contao 5 ist.
Habe noch einmal angefangen und auch die alte DB gelöscht, damit sich keine Fehler fortpflanzen. :-)
Jetzt: PHP 8.1 sowie komplett neue und vollständige 5.1.0 mit News, Kalender, FAQ, Kommentare, Newsletter, Auflistung. Dazu von RockSolid AntiSpam, Columns, Custom Elements, Icon Picker, Slider und Theme Assistant – RockSolid-Versionen 1.6.0 (für Contao 5.0 – 5.1). Läuft im Backend ohne Probleme, aber das Frontend wird nicht angezeigt.
Code:
[2023-03-04T14:47:26.505579+01:00] request.INFO: Matched route "tl_page.2". {"route":"tl_page.2","route_parameters":{"_token_check":true,"_controller":"Contao\\FrontendIndex::renderPage","_scope":"frontend","_locale":"de","_format":"html","_canonical_route":"tl_page.2","parameters":"","pageModel":{"Contao\\PageModel":[]},"_route":"tl_page.2","_route_object":{"Contao\\CoreBundle\\Routing\\Page\\PageRoute":[]}},"request_uri":"https://artefact.immo-foto.info/aktuell","method":"GET"} []
Code:
[2023-03-04T14:47:26.595526+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND tl_form_field.invisible=0 AND tl_form_field.tstamp!=0 ORDER BY tl_form_...' at line 1" at /www/htdocs/w01819a3/foto-zille.de/artefact/contao5/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 86 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 1064): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND tl_form_field.invisible=0 AND tl_form_field.tstamp!=0 ORDER BY tl_form_...' at line 1 at /www/htdocs/w01819a3/foto-zille.de/artefact/contao5/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1064): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND tl_form_field.invisible=0 AND tl_form_field.tstamp!=0 ORDER BY tl_form_...' at line 1 at /www/htdocs/w01819a3/foto-zille.de/artefact/contao5/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (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 MariaDB server version for the right syntax to use near '? AND tl_form_field.invisible=0 AND tl_form_field.tstamp!=0 ORDER BY tl_form_...' at line 1 at /www/htdocs/w01819a3/foto-zille.de/artefact/contao5/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:70)"} []
Code:
[2023-03-04T14:47:26.624622+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"} []
Code:
[2023-03-04T14:47:26.624842+01:00] messenger.INFO: Received message Contao\CoreBundle\Messenger\Message\SearchIndexMessage {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage"} []
Code:
[2023-03-04T14:47:26.627007+01:00] messenger.INFO: Message Contao\CoreBundle\Messenger\Message\SearchIndexMessage handled by Contao\CoreBundle\Messenger\MessageHandler\SearchIndexMessageHandler::__invoke {"class":"Contao\\CoreBundle\\Messenger\\Message\\SearchIndexMessage","handler":"Contao\\CoreBundle\\Messenger\\MessageHandler\\SearchIndexMessageHandler::__invoke"} []
Syntaxfehler in der DB?! Was heißt das, wie kommt der dort hin und wie ist der zu reparieren?
Vielen Dank für eure Anregungen.