Просмотр кода страницы Webasyst - mysql ошибка Expression 1 of ORDER BY clause is not in SELECT list, references column which is not in SELECT list; this is incompatible with DISTINCT

[[Файл:B_1.gif |link=https://bit.ly/3tbFsd6| Доступная цена]]

=== Webasyst - mysql ошибка Expression 1 of ORDER BY clause is not in SELECT list, references column which is not in SELECT list; this is incompatible with DISTINCT ===


Ошибка на сайте на движке '''Webasyst''' после обновления mysql до 5.7.x:
 Query Error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'site.sp1.sort' which is not in SELECT list; this is incompatible with DISTINCT
 Query: SELECT DISTINCT p.*,p.id FROM shop_product p JOIN shop_set_products sp1 ON p.id = sp1.product_id WHERE (p.count > 0 || p.count IS NULL) AND p.status = 1 AND sp1.set_id = 'verh' ORDER BY sp1.sort ASC LIMIT 10

означает, что включен strict mode  для MySQL. Решение - это отключить strict mode для mysql 5.7:
*https://iphwiki.net/wiki/MySQL_-_как_отключить_strict_mode_-_строгий_режим