View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0008699mantisbtdb postgresqlpublic2007-12-30 22:062014-05-16 15:02
Reporterylong Assigned Tograngeway  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
OSWindowsOS VersionXP 
Product Version1.1.0 
Target Version1.2.0a2Fixed in Version1.2.0a2 
Summary0008699: Get Time Tracking Information return a SQL query error
Description

The mantis is installed with:
Database: PostgreSQL 8.2.5
Web Server: 2.0.61
PHP: 5.2.5

When I open following to test the time tracking function,
http://127.0.0.1/mantus/billing_page.php

A SQL query error "syntax error at or near "sum_time_tracking"" is returned.
I try to run the SQL in pgAdmin, The tool return the same error message.

If I modify the SQL and add "as" after "SUM(time_tracking)", the query can be executed without error.

Steps To Reproduce
  1. Click the "Billing" link near "Jump to #Issue"
  2. Click button "Get Time Tracking Information"
  3. Got error page:
    APPLICATION ERROR 0000401

Database query failed. Error received from database was #-1: ERROR: syntax error at or near "sum_time_tracking"
LINE 1: ... username, summary, bn.bug_id, SUM(time_tracking) sum_time_t...
^ for the query: SELECT username, summary, bn.bug_id, SUM(time_tracking) sum_time_tracking
FROM mantis_user_table u, mantis_bugnote_table bn, mantis_bug_table b
WHERE u.id = bn.reporter_id AND bn.time_tracking != 0 AND bn.bug_id = b.id
AND bn.date_submitted >= '2007-12-18 00:00:00' AND bn.date_submitted <= '2007-12-30 23:59:59'
GROUP BY bn.bug_id, u.id, u.username, b.summary
ORDER BY bn.bug_id

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
parent of 0009176 closedvboctor Port 0008699: Get Time Tracking Information return a SQL query error 

Activities

grangeway

grangeway

2008-05-03 18:55

reporter   ~0017751

Hello,

I've just commited a fix to SVN trunk that should resolve this issue.

Paul
grangeway

grangeway

2014-05-16 15:02

reporter   ~0040552

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
Paul