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	new	high	WikiStatsPlugin	normal		SQL specific syntax	Martin Scharrer Ryan J Ollos	0.11