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

# Запрос номер 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.0007 msec ) /var/www/www.freshfrost.ru/mg-core/lib/mg.php (line 0)

Ошибка в SQL запросе: SELECT p.id, CONCAT(c.parent_url,c.url) as category_url, pupd.name AS frost, c.unit as category_unit, p.unit as product_unit, c.weight_unit as category_weightUnit, p.weight_unit as product_weightUnit, p.url as product_url, p.*, pv.product_id as variant_exist, rate, (p.price_course + p.price_course * (IFNULL(rate,0))) as `price_course`, IF(variantsExists > 0, varcount, IF (p.`count` < 0, 1000000, p.`count`)) AS `count_sort`, p.currency_iso FROM `mg_product` AS p LEFT JOIN `mg_category` AS c ON c.id = p.cat_id LEFT JOIN `mg_product_user_property_data` AS pupd ON p.id = pupd.product_id LEFT JOIN `mg_product_variant` AS pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, pv.count)) AS varcount, COUNT(pv.`id`) as variantsExists FROM `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE ((p.cat_id IN ('4502') or FIND_IN_SET(4502,p.`inside_cat`))) AND p.activity = 1 AND ((SELECT SUM(ABS(count)) FROM mg_product_on_storage WHERE product_id = p.id) != 0) AND pupd.prop_id = 25 GROUP BY p.id ORDER BY `sort` ASC, p.`id` ASC LIMIT 0, 20
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ffnew.pupd.name' 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/lib/navigator.php (line 75)

/var/www/www.freshfrost.ru/mg-core/models/catalog.php (line 254)

/var/www/www.freshfrost.ru/mg-core/controllers/catalog.php (line 176)

/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)