We have over 45,000 Inactive Users Awaiting Email Confirmations in VB 4.2.2. We want to delete these users that have been inactive for 90 days with 0 posts.
The prune user group option lets you do 999 users at once but I have to sit there and click 999 users one by one to delete all at once. Or if we do a promotion, we are still limited to the 999 at a time.
I tried installing the "Users Clean UP" product Vitaly created on here but that seems to not be running on VB 4.2.2.
I always keep on top of these things you will just have to prune 999 at a time so start clicking maybe next time you will keep on top of things like this and not leave it for so long hope you learn from this
maybe next time you will keep on top of things like this
Can't see that as being overly helpful. :erm:
jazmos - if you don't have a function available to do this it would be easy to sort out using phpmyadmin. Just run a basic query to delete members in the unactivated usergroup.
ForceHSS - if you don't have a function available to do this it would be easy to sort out using phpmyadmin. Just run a basic query to delete members in the unactivated usergroup.
No, you will mess up the other tables if you do that, The user info is stored in many places.
01-05-2014, 06:32 PM
How do I Mass Delete over 45k Inactive Users?
Linear Mode
