[RESOLVED] How i can delete User?
I have a question,i want deleted some spamers from my MediaWiki. I konw that i must go in the database and delete the user from there.
My question,where i must go exactly to delete the Users ? I see many tables,but not no who the rigt table.
Hope somebody can help me :-)
Sorry for my english,not my native language
Best Wishes, ~Comppro
I have the same problem like Seriana, How to merge 7900 Spam accounts? There must be a solution directly working on the database, it is unfeasable to do that over a WikiPage. Regards, Markus
If you want to do that in the database, the easy way is to go to the table "user" and to delete all the users, which you do no longer want. You can do that, but this is relational data. Meaning: MediaWiki does not only use it for the usernames, but also associates posts and other stuff with these table rows. If you just remove them without checking, if they are still used anywhere else, you will break your wiki.
A rather clean solution, which I found very usable, is Extension:User_Merge_and_Delete. It takes care for those references automatically. This drastically reduces the risk of screwing up your wiki.
I'm with the others on looking for a solution on how to delete several hundred spam accounts on my wiki. the User_Merge_and_Delete is simply not capable of tackling this in a method that is worthwhile or plausible. I would also greatly appreciate attempting to lock-out certain functions, or find a better User Registration to stop this spamming or at least diminish it.
-Keith (hoosierhackerhouse.com; a Shadowrun Gaming Wiki)
If these accounts are only there and never got used, you can use the maintenance script removeUnusedAccounts.php to remove these accounts. If you find better ways, let us know, however, others also were not successful as you can see from the missing feedback in this very thread. You can delete the user records from the DB directly; fast and simple. But don't complain when it breaks your wiki.
If you have a list of known good accounts, you can use Extension:BlockandNuke and Extension:UserMerge to merge spam accounts into the user Spammer. BlockandNuke will also ban the IP addresses from editing.
I've been using this on my personal spam-bait wiki and have blocked over 10,000 IP addresses in the last month.
I installed mediawiki on one of my domains, to 'practice' the wikimarkup language and possibly use it for my 'linux howto's' sub-domain linux.landisreed. I didn't get to it right away and was unaware, due to the lack of detailed install and configure docs that are, like mozilla not up to date. Anyways, i noticed huge CPU usage and looked at phpMyAdmin, my db, search Users, using 10,000 records per page starting at zero and apparently have around 80,0000 user accounts as there are 8 pages (10,000 records per page, nope: 71,718 actually, minus me and my admin user from setup)... this is a lot to deal with. In Mediawiki > Special Pages > User List it seems that most 'people' have entered some sort of text (Spam they are advertising) so 'empty entries' script doesn't seem to be the answer... I think I'm going to attack this from the Backup db > Delete Users other than my Admin and my 'personal' accounts and see what that does form me.. I'll let you know what happens.
- note... funny, before looking at phpmyadmin, i started blocking users, one article at a time, but.... after 10 (Not knowing just how many there were), i thought I'd look into a 'better' or at least quicker way... doesn't appear to be one... I'd of thought, with how long mediawiki has been around and how many sites us it, there'd be a way... 'freeware', eh..
Well, i used git in ssh to clone and 'install' on my server. added functions to LocalSettings.php, logged in a 'SysOp' (original user from setup), navigated to http://linux.landisreed.com/wiki/Special:UserMerge and got the following error: [4d78a706] 2014-01-30 10:25:16: Fatal exception of type MWException Thought that 'install' went too smoothly.. lol : ( NEXT... i'm looking at other options, instead of wasting time figuring this error out.
> i thought I'd look into a 'better' or at least quicker way... doesn't appear to be one...
That is wrong. There are faster ways. E.g. if you have a list of known good accounts, you can use Extension:BlockandNuke and Extension:UserMerge to merge spam accounts into the user Spammer. BlockandNuke will also ban the IP addresses from editing.
thank you, but... in the 2, almost 3 weeks my wiki sat idle before i got back to it after install (wish install config page warned to secure site), i was lucky enough to get almost 80,000 'spam' users, each with a page or two or 6... i didn't see any good way to deal with that..
So, I exported the known good page, created a new db and 'updated' my mediawiki install and imported or recreated from *.mediawiki (text files) the pages. This worked out ok, because i learned a bunch since the install 3 weeks ago.. like Namespace.. nice.
Anyways, thanks again, Landis.