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