Hi All,
Sorry if this is the wrong place for this. But I've inherited admin of a wiki, Cunnan http://cunnan.lochac.sca.org/wiki/Main_Page, and it has some problems with Spammers. I've setup ConfirmEdit's Question-base CAPTCHA, AntiSpoof and AbuseFilter to deal with them. However, I can not get AbuseFilter working with the wiki going blank on submitting of an edit, so it is un-implemented. I have read the Extension page, but it does not explain what is going on. Everytime I have attempted to Test a simple filter the function has returned a 'Database Error'.
====================================== A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "AbuseFilterViewTestBatch::doTest". Database returned error "1054: Unknown column 'RC_EXTERNAL' in 'where clause' (localhost)". ========================================
And now when I try to mysqldump a backup I get ....... mysqldump: Couldn't execute 'show create table `temp`': View 'cunnan.temp' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
Or with a purgingOldText.php I get .... Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 27687, 27751, 27752, 27757, 27817, 27821, 27816, 27818, 27829, 27828, 27843, 27' at line 1 (localhost)
So I suspect there is a database error, but I don't know where to find it.
Cheers, Jamie