Did you recently upgrade? Maybe someone forgot to run
maintenance/update.php? It looks like you're missing a column in the
AbuseFilter table. The first thing I would try is running update.php from
the command line. You'll find it in the maintenance directory of your wiki.
If that fails, it could still provide more insight into what's wrong.
----
Justin Folvarcik
On Mon, Oct 13, 2014 at 6:36 AM, Yves de Lyle <yvesdelyle(a)gmail.com> wrote:
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
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l