Fehler nach Update MySQL 8

[tblumrich]

Hallo!

Siehe auch Forum: https://community.contao.org/de/showthread.php?76187-MySQL-8-0-15-SQL-Error-bei-Abfrage&p=512678&viewfull=1#post512678

Nachdem mein Hoster (Webgo) auf MYSQL 8 gestellt hat, folgt beim Aufruf z.B. einer Produktkategorie:
[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)"} []

Contao ist 4.4.41, Isotope im Moment 2.5.16

Viele Grüße
Thomas

[tblumrich]

Bin gerade (zurecht) darauf hingewiesen worden erstmal ein Update auf die neuesten Versionen zu machen.
Leider besteht das Problem aber auch unter Contao 4.4.44 und Isoptope 2.6.3

[aschempp]

see contao/contao#727

[Toflar]

You might need to adjust DC_ProductData though...

[fritzmg]

Isotope also uses queries like

$objCart = static::findOneBy(
    array('member=?', 'store_id=?'),
    array(\FrontendUser::getInstance()->id, $storeId)
);

Not sure if Contao's query builder also escapes those field names via Doctrine automatically?