I installed Mass Delete but I get an error

(SQL query hidden)

from within function "Article::doDeleteArticle". Database returned error "1054: Unknown column 'ar_page_id' in 'field list'

--- On Tue, 11/23/10, 2007@gmaskfx.com 2007@gmaskfx.com wrote:

From: 2007@gmaskfx.com 2007@gmaskfx.com Subject: Re: [Mediawiki-l] deleting an account and rollingback all edits and new pages... To: mediawiki-l@lists.wikimedia.org, WJhonson@aol.com Date: Tuesday, November 23, 2010, 1:12 PM I just upgraded to 1.16.0

--- On Tue, 11/23/10, WJhonson@aol.com WJhonson@aol.com wrote:

From: WJhonson@aol.com WJhonson@aol.com Subject: Re: [Mediawiki-l] deleting an account and rollingback all edits and new pages... To: 2007@gmaskfx.com, mediawiki-l@lists.wikimedia.org Date: Tuesday, November 23, 2010, 10:58 AM

In a message dated 11/23/2010 8:19:16 AM Pacific Standard Time, 2007@gmaskfx.com writes:

My wiki was vandalized recently and there is a huge amount of edits and new pages that I need to remove. Is there a way to do this without doing them all at once?

What is your MediaWiki version _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Well I'm glad to see that media wiki has added some significant additions for combating spam and vandalism unfortunately I can't find very many useful examples.

If found this one "count("http://", added_links) > 3"

Unfortunately it only matches more than three unique urls and what I've noticed is that spammers usually repeat the same url many times so I want to block any edit that repeats more than once.

I'd also like to block any user that edits more than X number of pages a minute.

On Wed, 24 Nov 2010, Tech Geek wrote:

Can't you restore the mediawiki database to the date just before the vandalization happened? I guess this assumes that any legitimate edits that were made during the period when the vandalization took place will get lost too.

Based on my own brief experience with MediaWiki, in which I had thought I had secured the wiki against non-user edits (entirely my mistake), I'd say that this is a needed feature.

Because, yes, there are bots out there that like nothing better than to deface wikis. Perhaps it is a misguided attempt to boost search engine rankings. Or maybe they're just sent on their way by sociopathic kids who maybe have a little bit of talent but no constructive way to express it and no hope of achieving it. I don't know. And frankly, for our purposes here, I don't care because whatever the real underlying problem here is, we aren't solving it today.

MediaWiki's attitude towards any attempt to secure a wiki is that this is contrary to the philosophy of a wiki, that if you want security, you're probably using the wrong software. This reposes a lot of trust in denizens of what for years we've been calling the "big bad Internet," what for years we've been constructing packet filters to protect ourselves from, what for years we've been trying to filter spam from, what for years we've been trying not to be fooled into phishing attacks on, etc.

I'm not a sociologist, but I'm guessing that even if the twerps who deface wikis weren't born that way, even if broader society didn't make them that way, the Internet has. In short, MediaWiki's philosophy towards security is, in the world as we now find it or have made it, naive.

And we need a way to repair the damage. Because without that, I can't even conceive of opening up my site (either the Drupal CMS or the wiki) to anonymous edits or to uninvited user registrations. Much as I'd like to.

On Wed, 24 Nov 2010, Benjamin Lees wrote:

As far as I know, there isn't any mass-revert extension, but there are some scripts and bots floating around that can do it client-side. Off-hand, I remember http://en.wikipedia.org/wiki/User:Splarka/ajaxmassrollback.js and it still seems to work.

Good to know, but there's no documentation. How does one use it?

On Wed, Nov 24, 2010 at 3:44 PM, David Benfell benfell@parts-unknown.org wrote:

...

In short, MediaWiki's philosophy towards security is, in the world as we now find it or have made it, naive.

Never attribute to philosophy that which is adequately explained by laziness. :)

Good point.