search

daylightstudio / FUEL-CMS-Blog-Module

A blog module for FUEL CMS
19 stars 18 forks source link

Fix MySQL 5.7 sql_mode=only_full_group_by issue #29

Closed marcus-at-localhost closed 5 years ago

marcus-at-localhost commented 5 years ago

Error in query (1055): Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'temp.posts_count' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Add temp.posts_count to Group BY claus

As described here: https://forum.getfuelcms.com/discussion/comment/11073/#Comment_11073