A Database Error Occurred

Error Number: 1055

Expression #48 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'indiasan_indiasanta_new.tbl_coupan_category.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select * from tbl_coupan,company,company_categories,tbl_coupan_category,tbl_coupan_amount where tbl_coupan.status='1' and tbl_coupan.min_purchase_amount IS NULL and tbl_coupan.offer_for!='florista' and tbl_coupan.company=company.id AND company.cat_id=company_categories.id AND company.id=tbl_coupan_category.company_id AND tbl_coupan.pk_coupanid=tbl_coupan_amount.coupan_id group by tbl_coupan.pk_coupanid

Filename: helpers/searchhelp_helper.php

Line Number: 100