[MediaWiki-l] MediaWiki-l Digest, Vol 133, Issue 9

Alexandra Stagoy alexandra.stagoy at yahoo.com
Mon Oct 13 17:09:47 UTC 2014

its ok Alexandra Stagoy 

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

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

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

You can reach the person managing the list at
    mediawiki-l-owner at 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 at gmail.com>
To: mediawiki-l at lists.wikimedia.org
Subject: [MediaWiki-l] Wiki problems: spam + MySQL errors
    <CAF23HxWap_=2zr4fysmZpwKGABReCc91qiS6wEyoZ09wW9Xrzw at 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.



MediaWiki-l mailing list
MediaWiki-l at lists.wikimedia.org

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


More information about the MediaWiki-l mailing list