Всем привет!
Делал свой отчет для Opencart 2.3, сейчас хотел потестить его на Opencart 3 и словил ошибку SQL.
Запрос
SELECT descr.`name` as Velo_Name, Orders.`model` as Model, SUM(Orders.`quantity`) as Sum_Quantity, SUM(Orders.`price`) as Sum_Price FROM `oc_order_product` as Orders, `oc_product` AS prod, `oc_product_description` as descr WHERE (Orders.product_id = prod.product_id) AND (prod.product_id=descr.product_id) AND (descr.`language_id` = 1) GROUP BY Orders.`model` ORDER BY SUM(Orders.`price`) DESC
Код ошибки
#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opencart3.descr.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Вроде английским владею, а что делать не знаю
И почему-то на версии 2.3 все работало, а на 3 версии нет.