Modify

Opened 9 years ago

Closed 9 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 9 years ago by dagomez

Resolution: fixed
Status: newclosed

Hi fsanchog, thank you for the fix!

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain dagomez.
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.