Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hk4_db.organisation.country' 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 `organisation`.`country_id` AS `country_code`, `organisation`.`country` AS `country_name`, `city`.`slug` AS `city_slug`, `city`.`name` AS `city_name` FROM `organisation_department_specialty` LEFT JOIN `organisation` ON organisation.id=organisation_department_specialty.org_id LEFT JOIN `city` ON organisation.city_id=city.id WHERE `specialty_id` LIKE '%ms0064%' GROUP BY `organisation`.`country_id`, `organisation`.`city_id` ORDER BY `organisation`.`country_id`, `city`.`name`

Error Info: Array
(
    [0] => 42000
    [1] => 1055
    [2] => Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hk4_db.organisation.country' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
$_GET = [
    'lang' => 'en',
    'slug' => 'general-surgery',
];