A Database Error Occurred

Error Number: 1055

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'eshellde_architecture.news.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT YEAR(STR_TO_DATE(date, '%Y-%m-%d')) as year FROM news GROUP BY(year) ORDER BY(date) DESC

Filename: /home2/eshellde/public_html/models/newsmodel.php

Line Number: 45