Report execution failed: near "as": syntax error

[akhavr]

After trunk installation, all reports fail with

Report execution failed: near "as": syntax error

I set this to blocker since w/o reporting this very needed plugin is not quite useful.

[Russ Tyndall]

Can you give me any more help?

• What version of the plugin, trac, and database backend are you running?
• What database backend are you using?
• Is this all the reports or a specific report?

Many other people are successfully running this plugin, so I have to assume this is something specific to your setup. It looks like possibly the backend you are using does not support column aliasing with the 'as' syntax.

Thanks for the help,

Russ

[anonymous]

Configuration:

• trac 0.10
• timingandestimationplugin/trunk (from distribution zip file)
• standart sqllite backend
• python-module-pysqlite-1.0
• sqlite-2.8.16

There only couple plugins installed, so it cannot be an interference with others.

This happens with all reports.

[Russ Tyndall]

Per the Supported Versions section of the documentation. Sqlite 3.2.3 or greater is neccessary to use this plugin.

I believe the postgres backend is also fully functional at this point, if that is a better route for you.

Hope this helps,

Russ

[Russ Tyndall]

also I think you might need pysqlite2, but I am not so sure about the version of that neccessary

[quinn]

I have exactly the same problem: our server uses sqlite-2.8.16. We're running RHEL 4 and are dependent on using the versions of packages that are available via the redhat channel (because we choose to let them manage security patches and compatibilities).

Too bad!