Thread:Project:Support desk/New Users Assigned Bad ID's

MediaWiki: 1.17.1 PHP: 5.2.17 (cgi-fcgi) MySQL: 5.1.61-community-log

Like many wikis, my wiki was hit by a huge amount of spammers before we were able to come up with a solution to stop them. We were getting upwards to twenty spam signups a day each employing different proxy IP's. We blocked them all, deleted the spam pages, and then deleted the spammer accounts.

The problem is that we've got new users who aren't spammers, signing up and the system assigns them bad user ID's associated with those spammers we blocked and deleted earlier. This means that the spammer blocks are now being applied to the new users because of the bad ID's.

The only way I've found to fix it for now is to go into the user database and change the bad ID's to a new number. This clears all the blocks on the new user. Yet, it seems that every new account that signs up has been assigned a bad user ID. For example: the bad user ID's in my database seem to be around the 1040's. Yet, when I reassigned one user to 1100, the issues are cleared. However, each new user seems to be assigned in the 1040's instead of up in the higher good numbers. Is there a way to get the database to assign ID's above a certain number, say 1100 and so on? Or is there a way we can clear those bad ID's so that if one of them is assigned to a new user they won't be affected by anything previously associated with the ID?