Opened 10 years ago

Closed 10 years ago

#1439 closed defect (fixed)

Report execution failed: near "as": syntax error

Reported by: natea Owned by: bobbysmith007
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 10 years ago by bobbysmith007

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


comment:2 Changed 10 years ago by natea

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

comment:3 Changed 10 years ago by natea

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 10 years ago by natea

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 10 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 10 years ago by bobbysmith007

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

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.


Add Comment

Modify Ticket

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

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

Note: See TracTickets for help on using tickets.