Migrating to a new webserver and based on the documentation not showing there would be any issues, I installed MySQL 8.0.23 But now I am getting an error in admin, manage products because one of the select statements uses 'groups' which is now a restricted keyword. Anyone know of a simple solution to have MySQL run in some sort of a compatible mode?
SELECT COUNT(DISTINCT pf.feature_id) FROM cscart_product_features AS pf LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' WHERE 1 AND pf.feature_type != 'G' AND pf.feature_id NOT IN (0, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 17, 22, 24)