Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column \'afrlibya_afrlibya.e.path\' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=SELECT c.*, e.path AS photo_path, e.name AS photo_name FROM jos_categories AS c \n LEFT JOIN jos_easygallery AS e ON c.id = e.cid AND e.default = 1 \n WHERE section = \'com_easygallery\' \n AND parent_id = 0 AND published = 1 AND access <= 0 \n GROUP BY c.id \n ORDER BY ordering