Modify

Opened 7 years ago

Closed 7 years ago

#2651 closed defect (fixed)

Select syntax causes error without sqlite

Reported by: fsanchog@… Owned by: dagomez
Priority: normal Component: StractisticsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

I have Trac with Postgresql and i get this error.

Trac[__init__] ERROR: syntax error at or near "author"
LINE 2:         SELECT r.author author, COUNT( r.author ) commits 

I have fixed it changing all SELECT clauses in stractistics.py adding as

 SELECT r.author as author, COUNT( r.author ) as commits

Attachments (0)

Change History (1)

comment:1 Changed 7 years ago by dagomez

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

Hi fsanchog, thank you for the fix!

Add Comment

Modify Ticket

Action
as closed The owner will remain dagomez.
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.