Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mycampus_holaa.coupon_rules.rule_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT * FROM (`coupon_rules`) JOIN `coupon_type` ON `coupon_rules`.`coupon_type_id`=`coupon_type`.`coupon_type_id` JOIN `coupon_details` ON `coupon_details`.`coupon_id`=`coupon_rules`.`coupon_id` WHERE `coupon_details`.`enabled` = 'yes' AND `coupon_details`.`publicity_type` = 'HOLAA WEBSITE' AND (FIND_IN_SET(1,coupon_rules.city_id) OR (coupon_rules.city_id=0)) GROUP BY `coupon_type`.`coupon_type_name`
Filename: /home/mycampus/public_html/holaa/models/coupon_model.php
Line Number: 142