Hallo,
nach dem Setzen eines Filters in der Übersicht der Inhaltselemente in einem Artikel ist ein Fehler aufgetreten. Leider ist es nun nicht mehr möglich diesen auszuschalten/zurückzusetzen, denn bei jedem Aufruf einer Artikelansicht wird der Filter angewendet und die Fehlermeldung erscheint.
Gibt es eine Möglichkeit Filter global zurückzusetzen?
Fehlermeldung im BE:
Code:
Was ist das Problem?
An exception occurred while executing 'SELECT COUNT(*) AS count FROM tl_content WHERE pid='59' AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( LOWER(CAST(`text_cms` AS CHAR)) , '#', '#'), '<', '<'), '>', '>'), '<', '<'), '>', '>'), '(', '('), ')', ')'), '\', '\\'), '=', '='), '&', '&') REGEXP LOWER('Blutwurst') AND (ptable='tl_article' OR ptable='')': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_cms' in 'where clause'
prod-2021-05-31.log:
Code:
[2021-05-31 15:01:43] 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://www.xxx.de/contao?do=article&id=90&ref=0LA0_Qu5&rt=pJuc-8nGNqkwK-QDMkBnPsuc6uO-WpzhKHPLaAtsEDY&table=tl_content","method":"GET"} []
[2021-05-31 15:01:43] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT COUNT(*) AS count FROM tl_content WHERE pid='90' AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( LOWER(CAST(`text_cms` AS CHAR)) , '#', '#'), '<', '<'), '>', '>'), '<', '<'), '>', '>'), '(', '('), ')', ')'), '\', '\\'), '=', '='), '&', '&') REGEXP LOWER('Blutwurst') AND (ptable='tl_article' OR ptable='')': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_cms' in 'where clause'" at /www/htdocs/XXX/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT COUNT(*) AS count FROM tl_content WHERE pid='90' AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( LOWER(CAST(`text_cms` AS CHAR)) , '#', '#'), '<', '<'), '>', '>'), '<', '<'), '>', '>'), '(', '('), ')', ')'), '\', '\\\\'), '=', '='), '&', '&') REGEXP LOWER('Blutwurst') AND (ptable='tl_article' OR ptable='')':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_cms' in 'where clause' at /www/htdocs/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_cms' in 'where clause' at /www/htdocs/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_cms' in 'where clause' at /www/htdocs/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132)"} []
Contao 4.9.14/CM 1.4.4/PHP 7.4
Danke für einen Tipp!
Lesezeichen