id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
3874	Error: no such function: IF	anonymous	rjollos	By using trac 0.11.1 and WikiStatsPlugin I'm getting the error when using the Stats macro:\r\n{{{\r\nno such function: IF\r\n}}}\r\n\r\nI think it's from the SQL query in stats.py line 56-67:\r\n{{{\r\nSUM(IF(version = 1, 1, 0)) as pages_created,\r\nSUM(IF(version = 1, 0, 1)) as pages_edited,\r\n}}}\r\n\r\nI tried to simple remove this two lines, then I get the error:\r\n{{{\r\nno such column: pages_created\r\n}}}\r\n	defect	closed	high	WikiStatsPlugin	normal	wontfix	SQL specific syntax	martin@scharrer-online.de, rjollos	0.11