| Joomla! http://forum.joomla.org/ |
|
| Mass delete members? I have 8,000+ members and I need to delete them all. http://forum.joomla.org/viewtopic.php?f=32&t=107333 |
Page 1 of 1 |
| Author: | ComposerRyan [ Tue Oct 24, 2006 2:05 am ] |
| Post subject: | 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. |
|
| Author: | Tonie [ Tue Oct 24, 2006 7:48 am ] |
| Post subject: | 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 |
|
| Author: | pe7er [ Tue Oct 24, 2006 7:51 am ] |
| Post subject: | 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 |
|
| Author: | ComposerRyan [ Tue Oct 24, 2006 7:59 am ] |
| Post subject: | Re: Mass delete members? I have 8,000+ members and I need to delete them all. |
Sorry Peter for bumping my topic... Quote: 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 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...) Is there a mass delete users script that I could use? |
|
| Author: | Websmurf [ Tue Oct 24, 2006 8:05 am ] |
| Post subject: | 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 |
|
| Author: | pe7er [ Tue Oct 24, 2006 9:56 am ] |
| Post subject: | Re: Mass delete members? I have 8,000+ members and I need to delete them all. |
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 Thanks for sharing that trick! |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|