Opened 11 years ago

Closed 11 years ago

Report execution failed: near "as": syntax error

Reported by: Owned by: akhavr Russ Tyndall high TimingAndEstimationPlugin major 0.10

Description

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.

comment:1 Changed 11 years ago by Russ Tyndall

Priority: normal → high blocker → major

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

comment:2 Changed 11 years ago by 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.

comment:3 Changed 11 years ago by Russ Tyndall

Resolution: → invalid new → closed

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

comment:4 Changed 11 years ago by Russ Tyndall

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

comment:5 Changed 11 years ago by 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).