Code:
An exception occurred while executing 'SELECT tl_iso_product.*, 'de' AS language, tl_iso_product.images AS images_fallback, c.sorting FROM tl_iso_product LEFT OUTER JOIN tl_iso_product_category c ON tl_iso_product.id=c.pid WHERE tl_iso_product.language='' AND tl_iso_product.published='1' AND (tl_iso_product.start='' OR tl_iso_product.start<'1528388340') AND (tl_iso_product.stop='' OR tl_iso_product.stop>'1528388400') AND c.page_id IN (42,7,8,11,16,3,4,5,6,9,10,19,24,43,52,53,54,55,12 ,13,27,15,17,20,21,26,37,38,39,40,41,50,49,23,30,2 9,31,32,33,34,35,1) GROUP BY tl_iso_product.id': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #33 of SELECT list is not in GROUP BY clause and contains nonaggregated column '*******_contao_4.c.sorting' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
In der Datenbank ist unter language nichts eingetragen
Lesezeichen