A Database Error Occurred

Error Number: 1055

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'inatour_all_hotels.r.slug' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT coalesce(r.nama, 'Unknown') as nama, `r`.`slug`, count(l.region) as jml FROM `listing` `l` LEFT JOIN `region` `r` ON `l`.`region`=`r`.`id` WHERE `l`.`idPropinsi` = 2 GROUP BY `r`.`nama` LIMIT 65

Filename: models/Front_model.php

Line Number: 115