Modify

Opened 7 years ago

Closed 7 years ago

#1439 closed defect (fixed)

Report execution failed: near "as": syntax error

Reported by: natea@… Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

When I try to access any of the reports on the Management screen, the following error occurs: "Report execution failed: near "as": syntax error"

Attachments (0)

Change History (6)

comment:1 Changed 7 years ago by bobbysmith007

Please provide the following information:
Trac version,
Database Backend and Version

Thanks,
Russ

comment:2 Changed 7 years ago by natea

Trac 0.10.3 and SQLlite - still waiting to hear on the version.

comment:3 Changed 7 years ago by natea

the database version is sqlite 2, but the person who did the upgrade did not enabled reports for the trac instance, so he suspects that maybe this is the problem that he did the trac upgrade without the reports component enabled.

comment:4 Changed 7 years ago by natea

It appears that the ReportModule (trac.ticket.report) is already
enabled on the Trac instance, and when running the Trac upgrade it says, "Database is up to date, no upgrade necessary."

comment:5 Changed 7 years ago by gontanonext@…

I had the same problem, it was solved by upgrading sqlite from v2 to v3, and converting trac.db accordingly. Hope that helps.

comment:6 Changed 7 years ago by bobbysmith007

  • Resolution set to fixed
  • Status changed from new to closed

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

If you are using sqlite it must be a version ≥ 3.2.3. Hope this helps. sorry I couldn't respond faster, I have been out of town and away from the intarwebs. Feel free to reopen this ticket, if that does not fix it.

Russ

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.