Всего выполнено запросов: 15 шт. за 0.0035 сек. Развернуть Закрыть

# Запрос номер 1: SET names utf8 (0.0001 msec ) /var/www/www.freshfrost.ru/mg-core/lib/db.php (line 241)

# Запрос номер 2: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0002 msec ) /var/www/www.freshfrost.ru/mg-core/lib/mg.php (line 0)

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.0006 msec ) /var/www/www.freshfrost.ru/mg-core/lib/mg.php (line 0)

Ошибка в SQL запросе: SELECT pup.prop_id, pup.type_view, prop.* FROM `mg_product_user_property_data` as pup LEFT JOIN `mg_property` as prop ON pup.prop_id = prop.id LEFT JOIN `mg_category_user_property` as cup ON cup.property_id = prop.id WHERE prop.`type` = 'assortmentCheckBox' AND cup.category_id = '4503' AND pup.`prop_id` NOT IN ('0') GROUP BY pup.`prop_id` ORDER BY `sort` DESC;
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ffnew.pup.type_view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

/var/www/www.freshfrost.ru/mg-core/models/product.php (line 1227)

/var/www/www.freshfrost.ru/mg-core/controllers/product.php (line 57)

/var/www/www.freshfrost.ru/mg-core/lib/moguta.php (line 0)

/var/www/www.freshfrost.ru/mg-core/mg-start.php (line 64)

/var/www/www.freshfrost.ru/mg-core/index-start.php (line 126)

/var/www/www.freshfrost.ru/index.php (line 7)