Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mycampus_holaa.c.cart_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `c`.*, `ser1`.`city`, `ser1`.`service_name`, `ser2`.`type_name`, `ser3`.`sub_type_name`, `ser2`.`servicetype_image`, `p`.`price`, `p`.`doe_price`, `ser3`.`parent` FROM (`ho_cart` c) JOIN `ho_service` ser1 ON `ser1`.`service_id`=`c`.`service_id` JOIN `ho_service_type_price` p ON `p`.`price_id`=`c`.`s_price_id` JOIN `ho_service_type` ser2 ON `ser2`.`service_type_id`=`c`.`s_type_id` JOIN `ho_service_sub_type` ser3 ON `ser3`.`subtype_id`=`c`.`s_subtype_id` WHERE `c`.`status` = '0' AND (FIND_IN_SET(1,ser1.city) AND (c.customer_id='' OR c.customer_id='')) GROUP BY `c`.`s_price_id` ORDER BY `ser3`.`parent` asc
Filename: /home/mycampus/public_html/holaa/models/admin/service_model.php
Line Number: 678