The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 7 posts ] 
Author Message
PostPosted: Tue Oct 24, 2006 2:05 am 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Mon Oct 09, 2006 10:34 pm
Posts: 171
Location: USA (Indiana)
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.


Top
 Profile  
 
PostPosted: Tue Oct 24, 2006 7:48 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16546
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

_________________
Joomla forum global moderator.

Have fun


Top
 Profile  
 
PostPosted: Tue Oct 24, 2006 7:51 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 8:55 pm
Posts: 20027
Location: Nijmegen, The Netherlands
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

_________________
Kind Regards,
Peter Martin, Global Moderator - Community Leadership Team
http://www.db8.nl - Joomla specialist, Nijmegen, Nederland
Joomla 2.5 multilanguage in 10 steps: http://www.db8.nl/en/joomla-presentatio ... ge-website


Top
 Profile  
 
PostPosted: Tue Oct 24, 2006 7:59 am 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Mon Oct 09, 2006 10:34 pm
Posts: 171
Location: USA (Indiana)
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?


Top
 Profile  
 
PostPosted: Tue Oct 24, 2006 8:05 am 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Fri Aug 19, 2005 2:23 pm
Posts: 2230
Location: The Netherlands
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

_________________
Adam van Dongen - Developer

- Blocklist, ODT Indexer, EasyFAQ, Easy Guestbook, Easy Gallery, YaNC & Redirect -
http://www.joomla-addons.org - http://www.bandhosting.nl


Top
 Profile  
 
PostPosted: Tue Oct 24, 2006 9:56 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 8:55 pm
Posts: 20027
Location: Nijmegen, The Netherlands
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!

_________________
Kind Regards,
Peter Martin, Global Moderator - Community Leadership Team
http://www.db8.nl - Joomla specialist, Nijmegen, Nederland
Joomla 2.5 multilanguage in 10 steps: http://www.db8.nl/en/joomla-presentatio ... ge-website


Top
 Profile  
 
PostPosted: Thu Mar 22, 2012 6:04 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Sat Nov 11, 2006 5:03 am
Posts: 548
Old trick... works flawlessly in a new bottle (J 1.7)

Thanks a lot Websmurf

_________________
Ashwin K. Date - Follow @coolbung @tekdinet @techjoomla @jugpune
Joomla! Extensions & Training - www.techjoomla.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 



Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group