All management reports fail: Report execution failed: near "as": syntax error

[robin@…]

Hi,

Just installed this plugin - it looks pretty cool.

However, we're running into a problem with reports. All reports fail with this error:

Report execution failed: near "as": syntax error

Any idea what's wrong?

This is plugin v0.3.7, with trac 0.10.3.

Thanks,

R.

[Russ Tyndall]

My guess is that you need to upgrade sqlite to a version > 3.2.3.

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

Hope this helps, Russ

[anonymous]

It certainly does.

I'm running FC4 on this box, which has sqlite 3.1.x.

I found this source of a FC4 SRPMS:

​ftp://ftp.funet.fi/pub/mirrors/ftp.redhat.com/pub/fedora/linux/core/test/4.92/source/SRPMS/

I grabbed sqlite-3.3.3-1.2.src.rpm and python-sqlite-1.1.7-1.2.src.rpm.

I rebuilt sqlite, and installed sqlite-3.3.3 and sqlite-devel-3.3.3, then rebuilt python-sqlite and installed it.

All working fine now.

Thanks,

R.