Report execution failed: near "as": syntax error

[Nate Aune]

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

[Russ Tyndall]

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

Thanks,
Russ

[Nate Aune]

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

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

[Nate Aune]

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

[gontanonext@…]

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

[Russ Tyndall]

According to ​http://trac-hacks.org/wiki/TimingAndEstimationPlugin#SupportedVersions:

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.

Russ