wbTeamPro Feature Request & Bug Tracker

View Issue Details Jump to Notes ]
1 Vote
Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0010985wbTeamPro[All Projects] Bugspublic2017-06-13 09:152018-02-09 12:57
Assigned Towebuddha 
PlatformOSOS Version
Product Version 
Target VersionApplied to Version3.20.2.0 
Summary0010985: MySQL 5.7.5+ compatability with ONLY_FULL_GROUP_BY
DescriptionNeed 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
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
webuddha (administrator)
2018-02-09 12:57

We released a patch, but we have a plans to modernize the queries.

- Issue History
Date Modified Username Field Change
2017-06-13 09:15 guest New Issue
2017-06-13 09:15 guest
2018-02-09 12:57 webuddha Note Added: 0010332
2018-02-09 12:57 webuddha Assigned To => webuddha
2018-02-09 12:57 webuddha Status New => Planned
2018-02-09 12:57 webuddha Applied to Version =>

Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker