Changes between Initial Version and Version 9 of Ticket #3874
- Timestamp:
- Mar 2, 2012, 1:22:29 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #3874
- Property Cc Ryan J Ollos added
- Property Keywords SQL specific syntax added
- Property Owner changed from RottenChester to Ryan J Ollos
-
Ticket #3874 – Description
initial v9 1 1 By using trac 0.11.1 and WikiStatsPlugin I'm getting the error when using the Stats macro: 2 no such function: IF 2 {{{ 3 no such function: IF 4 }}} 3 5 4 6 I think it's from the SQL query in stats.py line 56-67: 5 SUM(IF(version = 1, 1, 0)) as pages_created, 6 SUM(IF(version = 1, 0, 1)) as pages_edited, 7 {{{ 8 SUM(IF(version = 1, 1, 0)) as pages_created, 9 SUM(IF(version = 1, 0, 1)) as pages_edited, 10 }}} 7 11 8 12 I tried to simple remove this two lines, then I get the error: 9 no such column: pages_created 10 11 13 {{{ 14 no such column: pages_created 15 }}}