Been hit by spam - how to delete 500 users awaiting account approval?

Cujo

Member
I currently have 527 members awaiting account approval (I have my board setup so new accounts have to be approved manually, fortunately!). These registrations happened in the last few days. It takes a long time to load the page that lists all of these users awaiting approval, and when I try to delete their accounts from that page, I get a security error, so I can not delete anything from that page.

What are my alternatives?
 
...and when I try to delete their accounts from that page, I get a security error, so I can not delete anything from that page.

Sounds like a server thing. If you are running suhosin (hardened PHP) then the form might be exceeding limits and getting truncated. That's just a guess. You can contact your host about that.

Here is all spam info:

http://xenforo.com/community/resources/dealing-with-forum-spam.980/

This might be an alternative for you:

5) Here is a query to mass ban all users who registered between two dates:

http://xenforo.com/community/thread...d-accounts-by-certain-date.35697/#post-405829
 
After I ban the accounts, is there a way to mass delete them? Let's say all IP's get banned, can I then delete the accounts somehow but keep the IP's banned?
 
This might be an alternative for you:

So I ran the query and 1000 spam accounts were banned. However, these accounts are still awaiting approval, and when I open the approval page that tries to list a 1000 accounts, the page crashes (after a while of 100% CPU activity). Will these accounts be removed from the approval page after the site runs its automated cron jobs, or is by board basically f'ed right now?
 
So I ran the query and 1000 spam accounts were banned. However, these accounts are still awaiting approval, and when I open the approval page that tries to list a 1000 accounts, the page crashes (after a while of 100% CPU activity). Will these accounts be removed from the approval page after the site runs its automated cron jobs, or is by board basically f'ed right now?

Thanks for the report. I just updated this post with an additional query to remove those users from the moderation queue:

http://xenforo.com/community/thread...d-accounts-by-certain-date.35697/#post-405829
 
Top Bottom