How do I delete large batch of users (25000+)

9 years 9 months ago #246583 by JerryK132
I want to delete a large number of Joomla/CB users and list_limit= 100 is tedious. list_limit=ALL doesn't work as it times out. Can I change the time out, perhaps?

This looked interesting:
forum.joomla.org/viewtopic.php?t=598299
but it didn't seem to work. Also folder names were slightly different - poss a 3.2.x change

Any other suggestions welcomed.

Many thanks
Jerry

Please Log in to join the conversation.

9 years 9 months ago #246599 by krileon
Replied by krileon on topic How do I delete large batch of users (25000+)
You can't, you need to do it in smaller batches. There is too much cleanup PHP side for you to be able to delete that amount of users at once without crashing your site (timeout). I guess you could also delete them from Joomlas _users table then try running CB > Tools > Synchronize, but it'll probably timeout due to cleanup.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

9 years 9 months ago #246644 by JerryK132
Replied by JerryK132 on topic How do I delete large batch of users (25000+)
Thanks.
That's a shame. But what about extensions like JUserPrune (extensions.joomla.org/search?q=prune&q=juserprune) - we are considering testing that. Probably need to select criteria which will not take too long to execute.
Jerry

Please Log in to join the conversation.

9 years 9 months ago #246645 by beat

JerryK132 wrote: Thanks.
That's a shame. But what about extensions like JUserPrune (extensions.joomla.org/search?q=prune&q=juserprune) - we are considering testing that. Probably need to select criteria which will not take too long to execute.
Jerry


Yup, you could try that, and then try running CB > Tools > Synchronize, as Kyle suggested.

Of course backup first as usual when trying new things. ;)

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.206 seconds

Facebook Twitter LinkedIn