Opened 11 years ago

Closed 11 years ago

#1439 closed defect (fixed)

Report execution failed: near "as": syntax error

Reported by: Nate Aune Owned by: Russ Tyndall
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10


When I try to access any of the reports on the Management screen, the following error occurs: "Report execution failed: near "as": syntax error"

Attachments (0)

Change History (6)

comment:1 Changed 11 years ago by Russ Tyndall

Please provide the following information: Trac version, Database Backend and Version


comment:2 Changed 11 years ago by Nate Aune

Trac 0.10.3 and SQLlite - still waiting to hear on the version.

comment:3 Changed 11 years ago by Nate Aune

the database version is sqlite 2, but the person who did the upgrade did not enabled reports for the trac instance, so he suspects that maybe this is the problem that he did the trac upgrade without the reports component enabled.

comment:4 Changed 11 years ago by Nate Aune

It appears that the ReportModule ( is already enabled on the Trac instance, and when running the Trac upgrade it says, "Database is up to date, no upgrade necessary."

comment:5 Changed 11 years ago by gontanonext@…

I had the same problem, it was solved by upgrading sqlite from v2 to v3, and converting trac.db accordingly. Hope that helps.

comment:6 Changed 11 years ago by Russ Tyndall

Resolution: fixed
Status: newclosed

According to

If you are using sqlite it must be a version ≥ 3.2.3. Hope this helps. sorry I couldn't respond faster, I have been out of town and away from the intarwebs. Feel free to reopen this ticket, if that does not fix it.


Modify Ticket

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

Add Comment

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

Note: See TracTickets for help on using tickets.