Opened 13 years ago

Last modified 9 years ago

#3874 closed defect

Error: no such function: IF — at Initial Version

Reported by: anonymous Owned by: RottenChester
Priority: high Component: WikiStatsPlugin
Severity: normal Keywords: SQL specific syntax
Cc: Martin Scharrer, Ryan J Ollos Trac Release: 0.11

Description

By using trac 0.11.1 and WikiStatsPlugin I'm getting the error when using the Stats macro:

no such function: IF

I think it's from the SQL query in stats.py line 56-67:

SUM(IF(version = 1, 1, 0)) as pages_created, SUM(IF(version = 1, 0, 1)) as pages_edited,

I tried to simple remove this two lines, then I get the error:

no such column: pages_created

Change History (0)

Note: See TracTickets for help on using tickets.