View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0026132 | mantisbt | time tracking | public | 2019-09-12 14:21 | 2019-12-09 04:32 |
Reporter | ShadowKatmandu | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Target Version | 2.23.0 | Fixed in Version | 2.23.0 | ||
Summary | 0026132: Application Error 401 when clicking Time Tracking at the bottom of a bug notes page | ||||
Description | There is a bug in core/bugnote_api.php which causes a database query error. The existing code: $t_query = 'SELECT u.id AS user_id, username, realname, SUM(time_tracking) AS sum_time_tracking causes this problem. Adding ", u.id" after "u.realname" corrects the problem. $t_query = 'SELECT u.id AS user_id, username, realname, SUM(time_tracking) AS sum_time_tracking | ||||
Additional Information | APPLICATION ERROR 0000401 Database query failed. Error received from database was #-1: ERROR: column "u.id" must appear in the GROUP BY clause or be used in an aggregate function Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section. | ||||
Tags | No tags attached. | ||||
MantisBT: master c57ccb2b 2019-09-12 14:38 Details Diff |
Add missing column from group by clause This causes an error when retrieving time tracking information on View Issue Details page, on MySQL when ONLY_FULL_GROUP_BY is enabled (default since 5.7). Fixes 0026132 |
Affected Issues 0026132 |
|
mod - core/bugnote_api.php | Diff File |