MySQL Error!
------------------------

The Error returned was:
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'vm_main_main.d_1_post.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Error Number:
1055

SELECT DATE_FORMAT(date,'%b %Y') AS m_date, COUNT(*) AS cnt FROM d_1_post GROUP BY m_date ORDER BY date desc