Opened 17 years ago

Closed 17 years ago

Last modified 17 years ago

#1480 closed defect (fixed)

Syntax errors in management reports when run from manageent page.

Reported by: stevemccusker@… Owned by: Russ Tyndall
Priority: high Component: TimingAndEstimationPlugin
Severity: blocker Keywords:
Cc: stevemccusker@… Trac Release: 0.10


I am using Trac 0.10.4 on Windows XP Pro,and also Trac 0.10dev on Win 2000 Pro and get the same error on each. Both are using Python 2.3.5 and SQLite 3.2.7.

The reported error in the resulting report page is:

Report execution failed: near "as": syntax error

By manually editing the report to change occurences of 'as' to 'AS' one by one until the error message changed from 'as' to 'AS' I deduced that the line of the report which was causing the error was:

CAST(EstimatedHours.value as REAL) as Estimated_work,

I tried copying the SQL of the report into Notepad and manually replacing the dynamic parameters with the values shown in the trac.log file and then submitting the SQL query directly to SQLite.

The database changes the plugin made look OK and when I fill in some data using Trac ticket entry, the manually modified SQL gives sensible looking results when run directly in SQLite.

All the management reports result in the same error message though I have not tracked it down to see if it is in the same place in each (the trial and error process was quite time-consuming).

I have given this a severity of 'blocker' because we cannot use the time and estimating with it as it is. I have also given it a priority of high as I have a client who is keen to get Trac up and running with the time recording and estimating.

Thanks in advance.

Attachments (0)

Change History (2)

comment:1 Changed 17 years ago by anonymous

Resolution: fixed
Status: newclosed

I have upgraded to SQLite version 3.3.10 and PySQLite version 2(2.3.3) and the reports work now.

comment:2 Changed 17 years ago by Russ Tyndall

hmmmm... I have only seen that error in sqlite < 3.2.3 glad you got it fixed :), someone else has been having this same problem. I use linux so possibly this is a difference in the sqlite binaries across windows and linux.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Russ Tyndall.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.