Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#1087 closed defect (invalid)

Report execution failed: near "as": syntax error

Reported by: akhavr Owned by: bobbysmith007
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 10 years ago by bobbysmith007

  • Priority changed from normal to high
  • Severity changed from blocker to 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,


comment:2 Changed 10 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 10 years ago by bobbysmith007

  • Resolution set to invalid
  • Status changed from new to 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,


comment:4 Changed 10 years ago by bobbysmith007

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

comment:5 Changed 10 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!

Add Comment

Modify Ticket

as closed The owner will remain bobbysmith007.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.