its ok Alexandra Stagoy
On Monday, 13 October 2014, 14:00,
"mediawiki-l-request(a)lists.wikimedia.org"
<mediawiki-l-request(a)lists.wikimedia.org> wrote:
Send MediaWiki-l mailing list submissions to
mediawiki-l(a)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(a)lists.wikimedia.org
You can reach the person managing the list at
mediawiki-l-owner(a)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(a)gmail.com>
To: mediawiki-l(a)lists.wikimedia.org
Subject: [MediaWiki-l] Wiki problems: spam + MySQL errors
Message-ID:
<CAF23HxWap_=2zr4fysmZpwKGABReCc91qiS6wEyoZ09wW9Xrzw(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
End of MediaWiki-l Digest, Vol 133, Issue 9
*******************************************