Opened 16 years ago
Last modified 12 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
Note: See
TracTickets for help on using
tickets.