A Database Error Occurred

Error Number: 1055

Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'abhaf_bilingual.img_file.file_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT media_id, title, media.date as mdate, descrp, img_file.file_name AS image_file_name, pdf_file.file_name AS pdf_file_name,detail_link FROM media LEFT JOIN file_gallery img_file ON img_file.type_id=media.media_id AND img_file.type=4 AND img_file.image_type=0 LEFT JOIN file_gallery pdf_file ON pdf_file.type_id=media.media_id AND pdf_file.type=4 AND pdf_file.image_type=1 WHERE media.status=1 and media.language_id = 1 GROUP BY media.media_id ORDER BY media.date DESC

Filename: models/Media_model.php

Line Number: 12