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 <[email protected]> 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 > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
