• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

#1
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?
 

Jake Bunce

XenForo moderator
Staff member
#3
...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
 
#6
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?
 

Jake Bunce

XenForo moderator
Staff member
#7
There is no mass prune feature for user accounts. You can delete them one-by-one in the Admin CP.

I do not recommend deleting spammers. Just ban them.
 

Jake Bunce

XenForo moderator
Staff member
#10
Personally, I don't want them in my database, or my user list. So they get deleted.
Banned users are hidden on the forum. They are not shown in the member list.

Just wondering, is this because you want to keep the registered email address in the banned list?
It's because they will just re-register under the same name. Different bots behave differently though.
 
#12
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?
 

Jake Bunce

XenForo moderator
Staff member
#13
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