Скачать прайс Скачать прайс

Ошибка загрузки модуля

Ошибка при загрузке модуля 'Товары': Неизвестная ошибка №1055 (Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'newpms.GoodLink.Order' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by) (Возможный последний запрос: SELECT GoodLinkSet.*, GoodLink.IdItemLinked, goods.id, goods.name, goods.photo FROM GoodLinkSet LEFT JOIN GoodLink ON (GoodLink.IdLinkSet = GoodLinkSet.IdLinkSet) LEFT JOIN goods ON (GoodLink.IdItemLinked = goods.id) WHERE GoodLinkSet.IdItemSet='4564' GROUP BY IdLinkSet, IdItemLinked ORDER BY GoodLinkSet.NameItemSet ASC, GoodLink.`Order` ASC, goods.name ASC )