Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rogovmobil.article.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
The SQL being executed was: SELECT `article`.* FROM `article` LEFT JOIN `article_tag` ON `article`.`id` = `article_tag`.`article_id` LEFT JOIN `tag` ON `article_tag`.`tag_id` = `tag`.`id` WHERE (`approve`=1) AND (`tag`.`tag`='%D0%A1%D0%B5%D1%80%D0%B2%D0%B8%D1%81') GROUP BY `article`.`name` ORDER BY `date_pub` DESC LIMIT 5

Error Info: Array
(
    [0] => 42000
    [1] => 1055
    [2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rogovmobil.article.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
$_GET = [
    'tag' => '%D0%A1%D0%B5%D1%80%D0%B2%D0%B8%D1%81',
];