A Database Error Occurred

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c1new2hot.u.country' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT u.country, u.countryCode, u.region, u.regionCode, u.city, u.cityid FROM users u WHERE u.accStatus='active' AND u.userType<>'consumer' AND u.userType<>'employee' AND u.countryCode='CA' GROUP BY u.cityId ORDER BY u.city LIMIT 0,9999999999