Mass Prune Users more than 40,000

[zylstra]

How can I delete more than 100,000 users? When I try to delete more than a couple 10s of thousands with the default admincp feature my browser hangs.

[kpmedia]

You can directly query the database.

However, some of this depends on your server settings. Posting a request for 100,000 may exceed the server limits for PHP or MySQL. So perhaps query (prune) in smaller groupings?

[Lynne]

No, don't directly query the database unless you know exactly what you are doing. Deleting users effects more than just the user table.

You are going to have to delete the users in batches of 10K or so.

[beerguy]

I'm in the same boat. However I can't seem to delete more than 1,000 at a time. Is there a setting somewhere that limits the number of deletions at one time?

[Lynne]

It's a limit due to your server configuration, not vbulletin.

[beerguy]

Thanks for the reply. That's actually good news because it means I can change it :-)

Any idea where that setting is? Thanks in advance for the help.

[Lynne]

When you try to remove too many users, an error should show up in your error_logs (if you don't know where they are, ask your host) and that will tell you what the exact server issue is.

[beerguy]

Unfortunately when we try to delete anything over 1,000 nothing happens. There is no error in the log file. The web page says Invalid Entry and then returns back to the Prune/Delete page.

Any idea on where the setting is to increase the number? If it's a config file can you point us in the direction of where the file resides?

Thanks.

[Lynne]

I honestly do not know the setting. I know that on my server, I can easily delete batches of 5,000. I think I even did 10,000 a few times.

[Max Taxable]

Are these spam accounts being deleted?