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 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.