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