|
Joined: Feb 2004
Posts: 138
member
|
member
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
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 INSERT INTO ubbt_USER_GROUPS (USER_ID,GROUP_ID)
VALUES (xxx,4) where xxx is their user number 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 [pending bug..]
|
|
|
|
Joined: Feb 2004
Posts: 138
member
|
member
Joined: Feb 2004
Posts: 138 |
Shouldnt they at least show up in the Control Panel?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
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 i would also call this a bug/feature too..
|
|
|
|
Joined: Feb 2004
Posts: 138
member
|
member
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
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
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
stranger
|
stranger
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
stranger
|
stranger
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
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
stranger
|
stranger
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.
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
1,073
guests, and
180
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|