Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#1087 closed defect (invalid)

Report execution failed: near "as": syntax error

Reported by: akhavr Owned by: Russ Tyndall
Priority: high Component: TimingAndEstimationPlugin
Severity: major Keywords:
Cc: Trac Release: 0.10


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.

Attachments (0)

Change History (5)

comment:1 Changed 11 years ago by Russ Tyndall

Priority: normalhigh
Severity: blockermajor

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,


comment:2 Changed 11 years ago by anonymous


  • 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
Status: newclosed

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,


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

Too bad!

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Russ Tyndall.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.