Previous Thread
Next Thread
Print Thread
Hop To
#252306 02/18/2013 11:44 PM
Joined: Jun 2006
Posts: 287
enthusiast
enthusiast
Joined: Jun 2006
Posts: 287
Some time ago I had created a couple of new user groups that I later abandoned. I did some house cleaning and removed the two groups. One of them I forgot to add the entire group back to the "users" group and those users have no assigned user group resulting in no permissions. They cannot view the forums.

I have no way of knowing which people these were.

If I search and select all members in the User's group and reassign them to the "Users" group, will that action simply add the ones that are not checked or will it also create duplicates of the users already assigned to that group?

Hope that made sense.

I need to fix this as I am getting random e-mails from members that cannot view my forums.


Ford diesel master technician by day...
Webmaster by night! cool
FordDoctorsDTS.com running UBB Threads 7.5.4.2p2
FordDoctor #252307 02/19/2013 2:44 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
if it's a small amount of users?

SQL Query
SELECT USER_ID
from ubbt_USERS 
WHERE USER_ID NOT IN 
 ( SELECT USER_ID FROM ubbt_USER_GROUPS )

would return the orphans

FordDoctor #252308 02/19/2013 6:43 AM
Joined: Jun 2006
Posts: 287
enthusiast
enthusiast
Joined: Jun 2006
Posts: 287
I guestimate no more than 200 users.


Ford diesel master technician by day...
Webmaster by night! cool
FordDoctorsDTS.com running UBB Threads 7.5.4.2p2
FordDoctor #252309 02/19/2013 6:48 AM
Joined: Jun 2006
Posts: 287
enthusiast
enthusiast
Joined: Jun 2006
Posts: 287
I ran the Query from the control panel and in about a second it returned a list of around 100 or so user numbers. For now I guess we can assume all is well?

Thanx Sir Dude. smile


Ford diesel master technician by day...
Webmaster by night! cool
FordDoctorsDTS.com running UBB Threads 7.5.4.2p2
FordDoctor #252310 02/19/2013 10:49 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
well.. not really

my query just identified that you have 100 or so orphaned users.

that was why i asked the question.

next is to add those users to group 4

FordDoctor #252311 02/19/2013 1:23 PM
Joined: Jun 2006
Posts: 287
enthusiast
enthusiast
Joined: Jun 2006
Posts: 287
Okay, thanx for that tid-bit of information. Next question is, is there a query that will do this quickly or should I sit here changing them all one at a time?


Ford diesel master technician by day...
Webmaster by night! cool
FordDoctorsDTS.com running UBB Threads 7.5.4.2p2
FordDoctor #252312 02/19/2013 1:44 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
yah, i need to think of the update query a bit.. am busy, but the idea is to add user_id, user_group (4) for all users that are orphans..

i might post it here later tonite...

i just didn't want to power thru an off the cuff query, since it's an UPDATE one at that laugh

FordDoctor #252332 02/21/2013 6:45 AM
Joined: Jun 2006
Posts: 287
enthusiast
enthusiast
Joined: Jun 2006
Posts: 287
Okay, I straightened them all out manually one at a time. At least I was able to identify them with your help!


Ford diesel master technician by day...
Webmaster by night! cool
FordDoctorsDTS.com running UBB Threads 7.5.4.2p2

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)