its ok Alexandra Stagoy

On Monday, 13 October 2014, 14:00, "mediawiki-l-request@lists.wikimedia.org" mediawiki-l-request@lists.wikimedia.org wrote:

Send MediaWiki-l mailing list submissions to     mediawiki-l@lists.wikimedia.org

To subscribe or unsubscribe via the World Wide Web, visit     https://lists.wikimedia.org/mailman/listinfo/mediawiki-l or, via email, send a message with subject or body 'help' to     mediawiki-l-request@lists.wikimedia.org

You can reach the person managing the list at     mediawiki-l-owner@lists.wikimedia.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of MediaWiki-l digest..."

Today's Topics:

1. Wiki problems: spam + MySQL errors (Yves de Lyle)

----------------------------------------------------------------------

Message: 1 Date: Mon, 13 Oct 2014 21:36:44 +1100 From: Yves de Lyle yvesdelyle@gmail.com To: mediawiki-l@lists.wikimedia.org Subject: [MediaWiki-l] Wiki problems: spam + MySQL errors Message-ID:     CAF23HxWap_=2zr4fysmZpwKGABReCc91qiS6wEyoZ09wW9Xrzw@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1

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 MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

End of MediaWiki-l Digest, Vol 133, Issue 9 *******************************************