Mass Prune Users more than 40,000

[beerguy]

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.

[beerguy]

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]

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]

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]

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.)

[beerguy]

Thanks for the reply. I've asked our host to look into this and either he can't find the correct log file or he isn't seeing anything in the logs. Do you know the path to the log file that he should be checking?

[Lynne]

Hosts put their error_logs in different places, so I don't know where your host has put it.

[zeropaid]

This is the error I got in my logs.


PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0, referer: http://www.xxx.com

[tbworld]

Originally Posted by zeropaid

This is the error I got in my logs.

PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0, referer: http://www.xxx.com

http://www.php.net/manual/en/info.co...max-input-vars

Set this value in your "php.ini" file. Obviously set the value greater than 1000. But, do not get carried away with the number.
max_input_vars = 1500;

You may have to see your server host as "lynne" suggested, if you cannot change your php.ini file.

[zeropaid]

Set this value in your "php.ini" file.

Don't do that. Set it in your .htaccess file and remove once you are done. Adjusting this number is a security risk.

php_value max_input_vars 3000
php_value suhosin.get.max_vars 3000
php_value suhosin.post.max_vars 3000
php_value suhosin.request.max_vars 3000