View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0008699 | mantisbt | db postgresql | public | 2007-12-30 22:06 | 2014-05-16 15:02 |
Reporter | ylong | Assigned To | grangeway | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
OS | Windows | OS Version | XP | ||
Product Version | 1.1.0 | ||||
Target Version | 1.2.0a2 | Fixed in Version | 1.2.0a2 | ||
Summary | 0008699: Get Time Tracking Information return a SQL query error | ||||
Description | The mantis is installed with: When I open following to test the time tracking function, A SQL query error "syntax error at or near "sum_time_tracking"" is returned. If I modify the SQL and add "as" after "SUM(time_tracking)", the query can be executed without error. | ||||
Steps To Reproduce |
Database query failed. Error received from database was #-1: ERROR: syntax error at or near "sum_time_tracking" | ||||
Tags | No tags attached. | ||||
Hello, I've just commited a fix to SVN trunk that should resolve this issue. Paul |
|
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 |
|