View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007912 | mantisbt | db mssql | public | 2007-04-22 12:54 | 2018-07-20 02:15 |
Reporter | rzg | Assigned To | grangeway | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Fixed in Version | 1.1.0a4 | ||||
Summary | 0007912: Time tracking doesn't work- SQL syntax error | ||||
Description | When you click "Get time tracking information" on any bug, you get this error. It is because the statement generated in bugnote_api.php around line 473 is not valid SQL. (This was part of my bug report on 0004428 ): Time tracking Database query failed. Error received from database was 0008120: Column 'u.username' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. for the query: SELECT username, SUM(time_tracking) sum_time_tracking 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. | ||||
The query looks fine to me. Anyone knows what is wrong with this query? |
|
See http://dev.mysql.com/doc/refman/4.1/en/group-by-hidden-fields.html
so GROUP BY u.id |
|
What he said. If that query works, it is a mysql-ism that doesn't extend to other DBMSes. |
|
sorry - test bugnote1 |
|
sorry - test bugnote2 |
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|