vBulletin Mods

The Official vBulletin Modifications Site

Mass Prune Users more than 40,000
by zylstra
05 Oct 2012 23:22

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 14 Oct 2012 22:01

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 15 Oct 2012 15:48

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 08 Dec 2012 16:29

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 08 Dec 2012 17:16

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

beerguy 08 Dec 2012 17:21

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 09 Dec 2012 00:28

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 14 Dec 2012 16:38

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?


Lynne 14 Dec 2012 17:28

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 14 Dec 2012 17:32

Are these spam accounts being deleted?

beerguy 21 Dec 2012 16:26

They are people in "Users Awaiting Email Confirmation" status. There are about 250,000 and for some reason our system is a hard limit at 1,000 at a time. Our sysadmin can't find any setting anywhere that lets us change this. I can't fathom deleting them 1,000 at a time :-(


beerguy 10 Apr 2013 18:59

Bumping this thread as we still haven't figured out where to change the setting that controls how many users we can delete at a time.

Thanks in advance for any help that you can provide.

kh99 10 Apr 2013 20:34

When you go to Prune/Move users, you select the usergroup and other fields, then hit "Find". Does the error happen then, or do you get to the next page with the Delete/Move radio buttons?

beerguy 10 Apr 2013 20:47

Hi. I can do the search and it will return the list of users that meet the criteria. In our case all I'm trying to find are people in the "Users Awaiting Confirmation" group. I add to the search "has not logged on for x days" to narrow down the number of results. I get the results list just fine. Depending on the number of days I enter I can get anywhere from a few to 100,000 results. If I then click the delete button at the bottom and have even 1,001 records selected it errors out. If I select the number of days just right I can get the results to come back with less than 1,000 records and it successfully deletes them so I know it works. It's just limited to 1,000 at a time and we have over 200k records.

Any help would be appreciated.

Lynne 10 Apr 2013 23:17

Take a look at your error_logs when you try to delete more than 1000 users and see what the php error is. That is the php variable you will need to modify to be able to remove move than 1000 users at a time. (It isn't a vBulletin variable, it is a server variable you need to modify - probably need to ask your host to modify, that is.)

All times are GMT. The time now is 19:17.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.