Fatal error: Uncaught Exception: Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'tch_tch.catpd.level' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br />Error No: 1055<br />SELECT pd.product_id FROM oc_product pd LEFT JOIN oc_product p ON (p.product_id IN (5273)) LEFT JOIN oc_product_to_category ptc ON (ptc.product_id = p.product_id) LEFT JOIN oc_product_to_category ptcd ON (ptcd.product_id = pd.product_id) LEFT JOIN oc_category cat ON (cat.category_id = ptc.category_id) LEFT JOIN oc_category catd ON (catd.category_id = ptcd.category_id) LEFT JOIN oc_category_path catpd ON (catpd.category_id = ptcd.category_id) WHERE catd.category_id = cat.category_id GROUP BY pd.product_id ORDER BY catpd.level DESC LIMIT 8 in /sites/tent-chehol.com/system/library/db/mysqli.php:43
Stack trace:
#0 /sites/tent-chehol.com/system/library/db.php(63): DB\MySQLi->query('SELECT pd.produ...', Array)
#1 /sites/tent-cheho in /sites/tent-chehol.com/system/library/db/mysqli.php on line 43