PDA

View Full Version : Prune users


sonic83
05-19-2017, 06:35 AM
Hello friends, I want to prune users of my forum but they are more than 10,000 and gives error. From what I read in vbulletin this happens when there are too many. They all have the same registration date so I can not make smaller groups and delete them.

I've thought about deleting them from the database, emptying tables that allude to users, except the admin row.

My question is, apart from the table "USER", are there more tables that I must also empty to avoid incompatibilities?

Thank you

snakes1100
05-19-2017, 07:41 AM
Raise max_input_vars in php.ini to accommodate pruning that many users, may want to raise max_execution_time as well while doing that many at once.

Paul M
05-19-2017, 10:13 AM
Dont go deleting records from the database, the chance you may break something isnt worth it.

Use a query to move blocks of them to a usergroup thats empty, and then prune them properly.

sonic83
05-21-2017, 10:10 AM
thank you sirs