Modify ↓

Opened 17 years ago

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

Resolution: → fixed
Status: new → closed

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. Next status will be 'reopened'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.