Modify

Opened 7 years ago

Closed 7 years ago

Last modified 7 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

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.

Attachments (0)

Change History (5)

comment:1 Changed 7 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,

Russ

comment:2 Changed 7 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 7 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,

Russ

comment:4 Changed 7 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 7 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

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from bobbysmith007. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.