wbTeamPro Feature Request & Bug Tracker - wbTeamPro | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0010985 | wbTeamPro | [All Projects] Bugs | public | 2017-06-13 09:15 | 2018-02-09 12:57 |
Reporter | guest | ||||
Assigned To | webuddha | ||||
Priority | normal | Severity | minor | Reproducibility | sometimes |
Status | Planned | Resolution | open | ||
Platform | OS | OS Version | |||
Product Version | |||||
Target Version | Applied to Version | 3.20.2.0 | |||
Summary | 0010985: MySQL 5.7.5+ compatability with ONLY_FULL_GROUP_BY | ||||
Description | 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 | ||||
Steps To Reproduce | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
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 |
Notes | |||||
|
|||||
|
|