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

**Carino** · 27.07.2023, 10:12

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

**Spooky** · 27.07.2023, 10:15

Nutze den Debug-Modus und poste den Stack Trace.

**Carino** · 27.07.2023, 10:18

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)

**Spooky** · 27.07.2023, 10:26

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

**Carino** · 27.07.2023, 10:29

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

Vielen Dank!!