wbTeamPro Feature Request & Bug Tracker - wbTeamPro
View Issue Details
0010985wbTeamPro[All Projects] Bugspublic2017-06-13 09:152018-02-09 12:57
0010985: MySQL 5.7.5+ compatability with ONLY_FULL_GROUP_BY
Need to test and refactor some of the queries that use GROUP BY statements to work with the ONLY_FULL_GROUP_BY flag enabled by default in MySQL 5.7.5 and higher.

This error thrown from query performed in admin controller.

errmsg: Expression 0000001 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mymkas.tbladminlog.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
No tags attached.
Issue History
2017-06-13 09:15guestNew Issue
2017-06-13 09:15guest
2018-02-09 12:57webuddhaNote Added: 0010332
2018-02-09 12:57webuddhaAssigned To => webuddha
2018-02-09 12:57webuddhaStatusNew => Planned
2018-02-09 12:57webuddhaApplied to Version =>

2018-02-09 12:57   
We released a patch, but we have a plans to modernize the queries.