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

# Запрос номер 1: SET names utf8 (0.0003 msec ) /var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/lib/db.php (line 241)

# Запрос номер 2: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0027 msec ) /var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/lib/mg.php (line 987)

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.0006 msec ) /var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/lib/mg.php (line 994)

Ошибка в 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 = '6' 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 'nxqupyga_glavsnab.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/nxqupyga/data/www/glavstroy-snab.online/mg-core/models/product.php (line 1231)

/var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/controllers/product.php (line 57)

/var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/lib/moguta.php (line 60)

/var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/mg-start.php (line 64)

/var/www/nxqupyga/data/www/glavstroy-snab.online/mg-core/index-start.php (line 126)

/var/www/nxqupyga/data/www/glavstroy-snab.online/index.php (line 6)