wbTeamPro Feature Request & Bug Tracker
All Projects | wbTeamPro | wbTimeLog
Dashboard | Features | Bugs | | My View | View Issues | Change Log | Roadmap | My Account
  
wbTeamPro and wbTimeLog are actively being developed and supported.

We are working to update our tracker, changelogs, and documentation to convey this appropriately.
Thank you for your patience as we manage this period of growth.

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
Reporterguest 
Assigned Towebuddha 
PrioritynormalSeverityminorReproducibilitysometimes
StatusPlannedResolutionopen 
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
(0010332)
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 => 3.20.2.0

Dashboard | Features | Bugs | | My View | View Issues | Change Log | Roadmap | My Account
  

Copyright © 2000 - 2025 MantisBT Team
Powered by Mantis Bugtracker