Manual talk:RemoveUnusedAccounts.php

From mediawiki.org
Latest comment: 10 years ago by 88.130.83.103 in topic doesnt work

doesnt work[edit]

MediaWiki 1.16.0 (r78352)
PHP 5.3.2-1ubuntu4.10 (apache2handler)
MySQL 5.1.41-3ubuntu12.8
php removeUnusedAccounts.php --delete
Remove unused accounts
Checking for unused user accounts...
...found 0.

I have hundreds of unused spambot user accounts. Igottheconch (talk) 05:24, 31 May 2013 (UTC)Reply

Hi there!
You should try an update to a current version of MediaWiki - 1.16 is no longer supported and has known security holes.
For me the script works as expected: Correct numbers and also deleting accounts works. Note that the script only considers those accounts, which never had any log entries. That means: Even if you deleted the only spam page, which was created by a user, this user will not be considered unused anymore; it is not enough to only remove the spam revisions, you actually have to delete them from the database completely (e.g. with the deleteArchivedRevisions.php script). --88.130.83.103 00:27, 15 August 2013 (UTC)Reply

Using Array to get user list[edit]

Just a note that using an array to get all users prior to deleting them is not a good method. I have over 300,000 spam users I am trying to remove and my server is a small (amazon ec2 micro) server. So PHP is eating all the cpu and mem. It would be better to do them in batches at least.