Hallo,
nach dem Update von Contao 3.5.x auf 4.9.x generiert die Newslist folgende Fehlermeldung im Log:
[2020-09-14 11:30:11] request.INFO: Matched route "tl_page.1688". {"route":"tl_page.1688","route_parameters":{"_t oke n_check":true,"_controller":"Contao\\FrontendIndex ::renderPage","_scope":"frontend","_locale":"de"," pageModel":"[object] (Contao\\PageModel: {})","parameters":"","_route":"tl_page.1688"},"re q uest_uri":"https://domain.de/start/","method":"GET"} []
[2020-09-14 11:30:11] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2020-09-14 11:30:12] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT * FROM tl_news_archive WHERE id IN(1) AND manualSorting=1': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'" at /usr/www/users/web/Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 64 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameExcept ion(code: 0): An exception occurred while executing 'SELECT * FROM tl_news_archive WHERE id IN(1) AND manualSorting=1':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /usr/www/users/web/Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:64, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /usr/www/users/web/Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:91, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /usr/www/users/.../Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:86)"} []
Wie kann ich das Problem beheben? Hat jemand eine Idee bzw. den selben Fall schon mal gehabt?
Danke+ Viele Grüße
nach dem Update von Contao 3.5.x auf 4.9.x generiert die Newslist folgende Fehlermeldung im Log:
[2020-09-14 11:30:11] request.INFO: Matched route "tl_page.1688". {"route":"tl_page.1688","route_parameters":{"_t oke n_check":true,"_controller":"Contao\\FrontendIndex ::renderPage","_scope":"frontend","_locale":"de"," pageModel":"[object] (Contao\\PageModel: {})","parameters":"","_route":"tl_page.1688"},"re q uest_uri":"https://domain.de/start/","method":"GET"} []
[2020-09-14 11:30:11] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2020-09-14 11:30:12] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT * FROM tl_news_archive WHERE id IN(1) AND manualSorting=1': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'" at /usr/www/users/web/Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 64 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameExcept ion(code: 0): An exception occurred while executing 'SELECT * FROM tl_news_archive WHERE id IN(1) AND manualSorting=1':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /usr/www/users/web/Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:64, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /usr/www/users/web/Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:91, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /usr/www/users/.../Webseite/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:86)"} []
Wie kann ich das Problem beheben? Hat jemand eine Idee bzw. den selben Fall schon mal gehabt?
Danke+ Viele Grüße
Kommentar