A Database Error Occurred

Error Number: 1055

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

SELECT `product_tbl`.*, `product_by_user`.*, `user_registration`.*, `city`.`city_id`, `city`.`city_name` FROM `product_tbl` JOIN `product_by_user` ON `product_by_user`.`product_By_User_Id`=`product_tbl`.`p_user_Id` JOIN `user_registration` ON `user_registration`.`user_Id`=`product_by_user`.`user_Id` JOIN `city` ON `city`.`city_id`=`user_registration`.`user_City` WHERE `p_cat_Id` = '6' AND `p_subcat_Id` = '162' AND `user_registration`.`live_status` = 1 AND `product_by_user`.`catalog_status` = 0 AND `product_by_user`.`status_Flag` = 'Accepted' GROUP BY `product_by_user`.`product_By_User_url` ORDER BY `p_user_Id` ASC

Filename: models/Common_model.php

Line Number: 235