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

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

Add Comment


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

 
Note: See TracTickets for help on using tickets.