Mass delete members? I have 8,000+ members and I need to delete them all.
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
-
- Joomla! Enthusiast
- Posts: 171
- Joined: Mon Oct 09, 2006 10:34 pm
- Location: USA (Indiana)
- Contact:
Mass delete members? I have 8,000+ members and I need to delete them all.
Hello, I imported over 8,000 members from my SMF bridge over to Joomla, but I realized that I did not want to do that. I want them to merge over to Joomla GRADUALLY as they login over time, because the mass member sync function provided by SMF caused problems with membergroups, etc. Most of the users are over 2 years old anyway and a result of spam too.
So, I want to start fresh and simply delete ALL 8,000 members but I don't see a mass delete button. The only way I see to do it is to use the user manage and delete them 50 at a time...which would take, uh, FOREVER.
So, I want to start fresh and simply delete ALL 8,000 members but I don't see a mass delete button. The only way I see to do it is to use the user manage and delete them 50 at a time...which would take, uh, FOREVER.
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: Mass delete members? I have 8,000+ members and I need to delete them all.
These are the tables with user information in it. You would need to do mass removes with a sql command without deleting admin and other accounts you like. http://forum.joomla.org/index.php/topic ... l#msg74944
- pe7er
- Joomla! Master
- Posts: 24984
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: Mass delete members? I have 8,000+ members and I need to delete them all.
Do not *bump* your threads, please see the forum rules: http://forum.joomla.org/index.php/topic,65.0.html
If you have phpMyAdmin access to your database, you can empty some tables:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map
are all used by Joomla for managing the users...
I do not have the SMF tables at hand that contain the SMF user info
If you have phpMyAdmin access to your database, you can empty some tables:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map
are all used by Joomla for managing the users...
I do not have the SMF tables at hand that contain the SMF user info
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
-
- Joomla! Enthusiast
- Posts: 171
- Joined: Mon Oct 09, 2006 10:34 pm
- Location: USA (Indiana)
- Contact:
Re: Mass delete members? I have 8,000+ members and I need to delete them all.
Sorry Peter for bumping my topic...
Is there a mass delete users script that I could use?
Okay, if I just empty out these tables though, it would also empty out my admin account too, right? (I have NO experience with MYSQL whatsoever...)If you have phpMyAdmin access to your database, you can empty some tables:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map
are all used by Joomla for managing the users...
I do not have the SMF tables at hand that contain the SMF user info
Is there a mass delete users script that I could use?
- Websmurf
- Joomla! Hero
- Posts: 2230
- Joined: Fri Aug 19, 2005 2:23 pm
- Location: The Netherlands
- Contact:
Re: Mass delete members? I have 8,000+ members and I need to delete them all.
Also, a neat trick, open up your usermanager and change the url:
from:
administrator/index2.php?option=com_users&task=view
to:
administrator/index2.php?option=com_users&task=view&limit=1000
Then you can use the regular delete function
from:
administrator/index2.php?option=com_users&task=view
to:
administrator/index2.php?option=com_users&task=view&limit=1000
Then you can use the regular delete function
Adam van Dongen - Developer
- Blocklist, ODT Indexer, EasyFAQ, Easy Guestbook, Easy Gallery, YaNC & Redirect -
http://www.joomla-addons.org - http://www.bandhosting.nl
- Blocklist, ODT Indexer, EasyFAQ, Easy Guestbook, Easy Gallery, YaNC & Redirect -
http://www.joomla-addons.org - http://www.bandhosting.nl
- pe7er
- Joomla! Master
- Posts: 24984
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: Mass delete members? I have 8,000+ members and I need to delete them all.
Thanks for sharing that trick!Websmurf wrote: Also, a neat trick, open up your usermanager and change the url:
to:
administrator/index2.php?option=com_users&task=view&limit=1000
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
-
- Joomla! Guru
- Posts: 552
- Joined: Sat Nov 11, 2006 5:03 am
- Contact:
Re: Mass delete members? I have 8,000+ members and I need t
Old trick... works flawlessly in a new bottle (J 1.7)
Thanks a lot Websmurf
Thanks a lot Websmurf
Ashwin K. Date - Follow @coolbung @tekdinet @techjoomla @jugpune
Joomla! Extensions & Training - www.techjoomla.com
Joomla! Extensions & Training - www.techjoomla.com
-
- Joomla! Enthusiast
- Posts: 210
- Joined: Wed Jan 06, 2010 2:19 pm
Re: Mass delete members? I have 8,000+ members and I need t
By using this trick to remove registered users can i be sure that it will not remove my admin rights?
-
- Joomla! Guru
- Posts: 552
- Joined: Sat Nov 11, 2006 5:03 am
- Contact:
Re: Mass delete members? I have 8,000+ members and I need t
Yes. Joomla will not delete your own user.
To make it simpler you can set the filter to see only the Registered users and delete them so the Admin does not get selected.
To make it simpler you can set the filter to see only the Registered users and delete them so the Admin does not get selected.
Ashwin K. Date - Follow @coolbung @tekdinet @techjoomla @jugpune
Joomla! Extensions & Training - www.techjoomla.com
Joomla! Extensions & Training - www.techjoomla.com
-
- Joomla! Enthusiast
- Posts: 210
- Joined: Wed Jan 06, 2010 2:19 pm
Re: Mass delete members? I have 8,000+ members and I need t
Hi coolbung. The list of registered users is now showing and have selected all but they won't delete. Is there another trick to this?
Regards
Regards
-
- Joomla! Guru
- Posts: 552
- Joined: Sat Nov 11, 2006 5:03 am
- Contact:
Re: Mass delete members? I have 8,000+ members and I need t
what happens when you try to delete ? If you get a white page, try to reduce the limit and try again.
Ashwin K. Date - Follow @coolbung @tekdinet @techjoomla @jugpune
Joomla! Extensions & Training - www.techjoomla.com
Joomla! Extensions & Training - www.techjoomla.com
-
- Joomla! Enthusiast
- Posts: 210
- Joined: Wed Jan 06, 2010 2:19 pm
Re: Mass delete members? I have 8,000+ members and I need t
Hi coolbung, it seems I was being a bit too ambitious. I reduced the limit and they all deleted ok.
Regards
Regards