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 | |||||
|
|
|||||
|
|
||||