Öffnen der News nicht mehr möglich // Column not found: 1054 Unknown column 'sorting'

Hallo,

vielleicht kann mir jemand einen Tipp geben, woran das liegt. Ich bekomme folgende Fehlermeldung, wenn ich eine News öffnen möchte.

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sorting' in 'order clause'


Hat jemand eine Idee? Ich habe denselben Fehler, wenn ich diese News probehalber deinstalliert habe:

codefog/contao-news_categories
imi/news4ward
imi/news4ward_categories
imi/news4ward_related
imi/news4ward_tags

Alles andere läuft. Datenbank Schema, alles auf dem aktuellen Stand etc.

LOG Auszug:

Code:

---

[2023-07-27T08:07:50.011199+02: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://contao.uwg-siegen.de/contao?do=news&id=3&ref=XzVuZTBa&rt=97481.RC4H48e4j1H3pV23-C8ypPI3e2QLYehZQ75ZndNZ5K8.KGxkm_SO2yKxzS6CyRt78rNTCw5RFpoyNM90zKYQyZcxfTOzldnjC6TuKg&table=tl_news","method":"GET"} []
[2023-07-27T08:07:50.036237+02: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 'sorting' in 'order clause'" at /html/contao/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 'sorting' in 'order clause' at /html/contao/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 'sorting' in 'order clause' at /html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sorting' in 'order clause' at /html/contao/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:121)"} []

---

Würde mich sehr freuen, wenn mich jemand auf den Pfad der Weisheit tragen würde =)

Liebe Grüße,
Carino

Nutze den Debug-Modus und poste den Stack Trace.

Das wäre dieser:

Code:

---

Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sorting' in 'order clause'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
    (vendor/doctrine/dbal/src/Connection.php:1935)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
    (vendor/doctrine/dbal/src/Connection.php:1878)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'SELECT * FROM tl_news WHERE pid=? ORDER BY sorting, date DESC, id', array('1'), array())
    (vendor/doctrine/dbal/src/Connection.php:1103)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_news WHERE pid=? ORDER BY sorting, date DESC, id', array('1'), array())
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array('1'))
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute(array('1'))
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4572)
  at Contao\DC_Table->parentView()
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:313)
  at Contao\DC_Table->showAll()
    (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule('news', null)
    (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
    (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
    (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
    (vendor/symfony/http-kernel/HttpKernel.php:75)
  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))
    (web/index.php:44)

---

Hattest du vielleicht mal https://extensions.contao.org/?pages...o-news-sorting installiert? Lösche deine Backend Session Daten (rechts oben in deinem Profil).

Uff, das ist krass. Bist glatt als Glaskugelexperte eingestellt! Ja hatte ich installiert und das Backend Session löschen hat geholfen. Klasse!

Vielen Dank!!