Syntax errors in management reports when run from manageent page.

[stevemccusker@…]

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.

[anonymous]

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

[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.