4

I had an issue that bots/spammers have created hundreds of users on our mediawiki page.

They are not harmful, since a user needs to be confirmed before it can edit, and neither have been.

I have now installed a captcha to stop that - http://www.mediawiki.org/wiki/Extension:ConfirmEdit

How can I clean this huge list of users? *it spans over more than a day

enter image description here

Saariko
  • 867

2 Answers2

2

You can try using the following extension called UserMerge: http://www.mediawiki.org/wiki/Extension:UserMerge

With UserMerge can merge the offending accounts into one and then delete the remaining account. I don't know if UserMerge will allow you to merge en mass; if not it may not be an ideal solution.

You can also use Nuke to mass delete pages created by an offending account: http://www.mediawiki.org/wiki/Extension:Nuke

Also a similar post on StackOverflow gives instructions on how to use SQL to neutralize an account: https://stackoverflow.com/questions/10706451/mediawiki-mass-user-delete-merge-block

Best of luck! I have had the same problem on my Mediawiki install.

Community
  • 1
Gedalya
  • 945
0

I was unable to find a solution for the mass user delete so this is what I did in the end:

Deleted all pages added by spammers using: http://www.mediawiki.org/wiki/Extension:Nuke

then log into mysql:

 mysql -h localhost -u user -p passwrd db_name

and there:

 DELETE FROM db_name WHERE NOT user_name='Admin'

It may leave some inconsitencies but so far it seems to work fine.

Adam Husár
  • 1