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


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

Resolution: fixed
Status: newclosed

Hi fsanchog, thank you for the fix!

Modify Ticket

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.