Previous Thread
Next Thread
Print Thread
Hop To
#252306 02/18/2013 10:44 PM
Joined: Jun 2006
Posts: 287
enthusiast
OP Offline
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 1:44 AM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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 5:43 AM
Joined: Jun 2006
Posts: 287
enthusiast
OP Offline
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 5:48 AM
Joined: Jun 2006
Posts: 287
enthusiast
OP Offline
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 9:49 AM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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 12:23 PM
Joined: Jun 2006
Posts: 287
enthusiast
OP Offline
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 12:44 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
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 5:45 AM
Joined: Jun 2006
Posts: 287
enthusiast
OP Offline
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
How to delete all PM's for one user
by Ruben - 02/27/2021 7:10 AM
Admin / User question /feedback
by Morgan - 02/25/2021 5:18 AM
Active links corrupts image links/urls
by Morgan - 02/24/2021 1:03 PM
Return to Page
by Abbott - 02/20/2021 9:57 AM
Importers folder?
by DaveZ - 02/18/2021 11:31 AM
Who's Online Now
4 members (Morgan, Gizmo, Ruben, 1 invisible), 50 guests, and 56 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5