Opened 10 years ago

Closed 10 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


I have Trac with Postgresql and i get this error.

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

I have fixed it changing all SELECT clauses in adding as

 SELECT as author, COUNT( ) as commits

Attachments (0)

Change History (1)

comment:1 Changed 10 years ago by dagomez

Resolution: fixed
Status: newclosed

Hi fsanchog, thank you for the fix!

Modify Ticket

Change Properties
Set your email in Preferences
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.