An exception occurred while executing
Code:
SELECT
tl_iso_product.*,
'en' AS language,
IF(tl_iso_product.pid>0,
parent.type,
tl_iso_product.type) AS type,
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
LEFT OUTER JOIN tl_iso_product parent ON tl_iso_product.pid=parent.id
WHERE
tl_iso_product.language=''
AND tl_iso_product.id='3'
GROUP BY tl_iso_product.id LIMIT 0,1
: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #35 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'database_se.c.sorting' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Lesezeichen