A Database Error Occurred

Error Number: 1055

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

SELECT `a`.`archive_id`, `a`.`title`, `a`.`year`, `b`.`file_name`, `b`.`file_type` FROM (`m_archives` a) LEFT JOIN `m_files` b ON `a`.`archive_id` = `b`.`archive_id` WHERE `a`.`is_published` = 1 AND `b`.`is_published` = 1 AND `b`.`is_private` = 0 AND `b`.`file_type` = 'img' GROUP BY `a`.`archive_id` ORDER BY `a`.`created_at` DESC LIMIT 9

Filename: models/archive_model.php

Line Number: 62