Hallo,
nach einem nicht ganz problemlosen Update von 3.5x auf 4.13 wird beim Versuch die Abonnenten des Verteilers des Newsletters zu bearbeiten diese Fehlermeldung im HTML der Site ausgegeben:
Code:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'
Im log steht:
Code:
[2023-05-23T13:18:13.587818+00:00] 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":"https://newsletter.duenkel-partner.de/contao?do=newsletter&id=14&ref=teOeAgwT&rt=f2e92ad541b7735b.78PwwOWp3MlJyfxj0NNQ1J_egPVFCzGOveQNt6v2h2I.l7CSso32lqw6irYsv-Zk5vCpzsdwU1b6-qJuh-KQ1xWWqbahitntkQ7kzA&table=tl_newsletter_recipients","method":"GET"} []
[2023-05-23T13:18:13.597767+00: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 'confirmed' in 'order clause'" at /home/Website/public_html/vendor/doctrine/dbal/src/Driver/API/MySQL/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 'confirmed' in 'order clause' at /home/Website/public_html/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 'confirmed' in 'order clause' at /home/website/public_html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause' at /home/website/public_html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:121)"} []
Die Website "schrotten" und das update erneut zu machen in der Hoffnung das dann was besser ist sehr schwierig weil mein Kunde bereits wieder mit dem System arbeitet ...
Hat jemand einen besseren Rat?
Hofft dtptiger
Lesezeichen