Modify

Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#1480 closed defect (fixed)

Syntax errors in management reports when run from manageent page.

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

Description

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 8 years ago by anonymous

  • Resolution set to fixed
  • Status changed from new to closed

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

comment:2 Changed 8 years ago by bobbysmith007

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.

Add Comment

Modify Ticket

Action
as closed The owner will remain bobbysmith007.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.