Всего выполнено запросов: 17 шт. за 0.0074 сек. Закрыть


Ошибка в SQL запросе: SELECT i.id, i.title, i.tags, i.image_url, i.date_active_from, i.description, i.activity, c.title as cat_name, CONCAT_WS( "/", c.url, i.url ) path FROM `mg_blog_items` i LEFT JOIN `mg_blog_item2category` i2c ON i.id = i2c.item_id LEFT JOIN `mg_blog_categories` c ON i2c.category_id = c.id WHERE i.activity = 1 AND i.date_active_from <= NOW() AND (i.date_active_to = '0000-00-00' OR IFNULL(i.date_active_to, NOW()) >= NOW()) AND `tags` like '%гибдд%' GROUP BY i.id ORDER BY i.date_active_from DESC
Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'autovladik_1.c.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/navigator.php (line 99)


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/navigator.php (line 50)


/home/autovladik/web/autovladik.ru/public_html/mg-plugins/blog/index.php (line 291)


/home/autovladik/web/autovladik.ru/public_html/mg-plugins/blog/index.php (line 419)


/home/autovladik/web/autovladik.ru/public_html/mg-plugins/blog/index.php (line 556)


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/eventhook.php (line 82)


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/pm.php (line 186)


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/mg.php (line 326)


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/mg.php (line 560)


/home/autovladik/web/autovladik.ru/public_html/mg-core/lib/moguta.php (line 66)


/home/autovladik/web/autovladik.ru/public_html/mg-core/mg-start.php (line 53)


/home/autovladik/web/autovladik.ru/public_html/index.php (line 93)