Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 05 Oct 2012, 23:22
zylstra zylstra is offline
 
Join Date: Aug 2004
Mass Prune Users more than 40,000

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.

Last edited by zylstra; 05 Oct 2012 at 23:32.
Reply With Quote
  #2  
Old 14 Oct 2012, 22:01
kpmedia's Avatar
kpmedia kpmedia is offline
 
Join Date: Jan 2008
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?
__________________
FAQ: What are some HostGator alternatives? And who is EIG?
FAQ: What are the best web hosts and why?
And to all the vB plugin authors ... Thanks for making this a great app!
Reply With Quote
  #3  
Old 15 Oct 2012, 15:48
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #4  
Old 08 Dec 2012, 16:29
beerguy beerguy is offline
 
Join Date: Oct 2002
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?
Reply With Quote
  #5  
Old 08 Dec 2012, 17:16
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
It's a limit due to your server configuration, not vbulletin.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 08 Dec 2012, 17:21
beerguy beerguy is offline
 
Join Date: Oct 2002
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.
Reply With Quote
  #7  
Old 09 Dec 2012, 00:28
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #8  
Old 14 Dec 2012, 16:38
beerguy beerguy is offline
 
Join Date: Oct 2002
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.
Reply With Quote
  #9  
Old 14 Dec 2012, 17:28
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #10  
Old 14 Dec 2012, 17:32
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Are these spam accounts being deleted?
Reply With Quote
  #11  
Old 21 Dec 2012, 16:26
beerguy beerguy is offline
 
Join Date: Oct 2002
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 :-(

Thanks.
Reply With Quote
  #12  
Old 10 Apr 2013, 18:59
beerguy beerguy is offline
 
Join Date: Oct 2002
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.
Reply With Quote
  #13  
Old 10 Apr 2013, 20:34
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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?
Reply With Quote
  #14  
Old 10 Apr 2013, 20:47
beerguy beerguy is offline
 
Join Date: Oct 2002
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.
Reply With Quote
  #15  
Old 10 Apr 2013, 23:17
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.)
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:25.

Layout Options | Width: Wide Color: