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

# Запрос номер 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 ('4518','4520','4519','4521','4524','4523','4522','4510','4514','4541','4511','4512','4513','4515','4516','4517','4525','4526','4527','4528','4529','4530','4531','4532','4533','4534','4535','4487','4500','4559','4503','4502','4501','4499','4498','4497','4496','4495','4494','4493','4492','4491','4490','4489','4488','4504','4560','4505','4506','4507','4508','4509','0') or FIND_IN_SET(0,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)