Previous Thread
Next Thread
Print Thread
Hop To
Joined: Feb 2004
Posts: 138
T
member
member
T Offline
Joined: Feb 2004
Posts: 138
All,
Starting today when I add a new member (can log in as them and can navigate the posts) but I can't reply. The only link I see is to notify.
When I try to find that user with member management, I can't locate them.

What's going on?

Travis

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
They are a member that isn't assigned a group..

If you know their member number.. run the following query

SQL Query
INSERT INTO ubbt_USER_GROUPS (USER_ID,GROUP_ID)
VALUES (xxx,4)

where xxx is their user number smile

also, make sure you go to your admin cpanel and make sure that there is a default group that users get assigned to when they sign up wink [pending bug..]

Joined: Feb 2004
Posts: 138
T
member
member
T Offline
Joined: Feb 2004
Posts: 138
Shouldnt they at least show up in the Control Panel?

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
nope.. because the queries rely on a join with the groups table.. since they aren't in a group, the query fails to 'find' them wink

i would also call this a bug/feature too.. laugh

Joined: Feb 2004
Posts: 138
T
member
member
T Offline
Joined: Feb 2004
Posts: 138
So then for the love of god how do I make everyone a member of the users group that isn't already a member without doing it one at a time by choosing each successiven memebr number and doing it manually?

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
SQL Query
INSERT ubbt_USER_GROUPS(

SELECT ubbt_USERS.USER_ID, 4
FROM ubbt_USERS
WHERE ubbt_USERS.USER_ID NOT
IN (

SELECT ubbt_USER_GROUPS.USER_ID
FROM ubbt_USER_GROUPS
)
AND ubbt_USERS.USER_ID <>1
)

assume you have mysql 4.1 or greater and your table prefix is ubbt_

Joined: Jan 2005
Posts: 7
P
stranger
stranger
P Offline
Joined: Jan 2005
Posts: 7
I'm having the same exact problem after upgrading to 7.3 a week ago. Thanks, sirdude, for the SQL queries. New members are supposed to be put into the Users group by default, as that preference is set in the control panel, but that's not happening. They show up in the User List, but cannot be found by searching from in the control panel. Help!

Also, one user, even after applying sirdude's queries, is still unable to do anything but view, even though she is assigned to the User group. ??

Joined: Jan 2005
Posts: 7
P
stranger
stranger
P Offline
Joined: Jan 2005
Posts: 7
I'm not sure why, but it's working just fine today. New Users show up in the correct group, and everyone is able to make new topics.

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
well, if you ran that query, it would have fixed your current members..

and if you had your cpanel set to put them into a group upon registering, it should work from that point on..

[sidenote] why do we have a pull-down for 'using UBBCode' when that's the only option ? :shrug: [/sidenote]

Joined: Jan 2005
Posts: 7
P
stranger
stranger
P Offline
Joined: Jan 2005
Posts: 7
Thanks for the reply, Sirdude. Yeah, I figured that your query would fix previous new members left out of the default group, and that the control panel setting would determine new joiners thereafter. The weird thing is that the control panel said that it would put new members into the default group all along and I never switched it. Odd, but glad it's working now. :-)

Joined: Jun 2006
Posts: 693
Addict
Addict
Joined: Jun 2006
Posts: 693
I just ran that and it affected **482** members!! Does this mean 482 people have been unable to use our forums since we upgraded? We have been getting odd complaints from users but were never able to track it down to something specific.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
0 members (), 1,073 guests, and 180 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)