Hallo!
Ich hab hier das gleiche(?) Problem nachdem Webgo die SQL Version auf 8 angehoben hat.
Beim Aufruf einer Produktkategorie bei mir, sagt var/log:
Code:
[2019-10-16 14:18:55] request.INFO: Matched route "contao_frontend". {"route":"contao_frontend","route_parameters":{"_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_scope":"frontend","alias":"weihnachten","_route":"contao_frontend"},"request_uri":"http://mwi.blucoempchen.de/weihnachten.html","method":"GET"} []
[2019-10-16 14:18:55] security.INFO: Attempting SimplePreAuthentication. {"key":"frontend","authenticator":"Contao\\CoreBundle\\Security\\ContaoAuthenticator"} []
[2019-10-16 14:18:55] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT tl_iso_productcache.* FROM tl_iso_productcache WHERE uniqid='aee94be06359771409191ba319145017' AND (keywords='' OR keywords='') AND (expires>1571228335 OR expires=0) AND groups='' LIMIT 0,1':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups='' LIMIT 0,1' at line 1 at /home/www/mwi/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:99, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups='' LIMIT 0,1' at line 1 at /home/www/mwi/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups='' LIMIT 0,1' at line 1 at /home/www/mwi/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} []
Was kann man da tun?