id summary reporter owner description type status priority component severity resolution keywords cc release 3874 Error: no such function: IF anonymous Ryan J Ollos "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 }}} " defect closed high WikiStatsPlugin normal wontfix SQL specific syntax Martin Scharrer Ryan J Ollos 0.11