Mass Deletion of Users Awaiting Moderation

[JessicaRae]

I have over 6,000 users in the Users Awaiting Moderation. 99.9% of these are spammers. I just got tired of deleting them all the time. Now after so many have accumulated I can't delete them. When I try to delete them all I get this: [an error occurred while processing this directive]

I've tried pruning them as well, get the same error. Is there any way I can delete them??

[ForceHSS]

Prune smaller amounts at a time

[Simon Lloyd]

Do it phpmyadmin with this
delete FROM `user` WHERE `usergroupid` = "3"

Dont forget to change user for the way you have it in your tables so if your table prefix is vb_ then it should read vb_user, as always make a back up of the table before running it just in case.