Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
members list on multisite
Avatar
Lee H
Coastal New England (USA)
Member
Free Members
sp_UserOfflineSmall Offline
Jul 29, 2011 - 6:42 pm

Look at you go!

Lee is not a member of any groups other then Members (has slightly more than 2 posts). I only have one special user group "Private" for the mods and the Admin. Those in the Private group have access to the super secret, bitch about users section.

Sorry I didn't notice the bug back in 4.4.0. I've never enabled the SP profiles or userlists before as I already had a solution coded. Although that will likely change since it will be easier to make seamless with the rest of the site now.

Just keep letting me know how to help. I'm willing to mod files on my end if pointed in the right direction.

Or... a bit later when my day gets more in control I can set up ftp and whatever else needed to get you in my dev server so you can see (and edit)  what you're battling. Just let me know if that seems reasonable.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 29, 2011 - 6:44 pm

Andy is working the query now... but if Lee is really part of the members usergroup, not sure its the same issue... was thinking the use case was member of no usergroups... but shall see...

Avatar
Lee H
Coastal New England (USA)
Member
Free Members
sp_UserOfflineSmall Offline
Jul 29, 2011 - 6:59 pm

Yep, Members is the only usergroup Lee is in. I just checked every method I know and still only came up with the one group.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 29, 2011 - 8:36 pm

a better answer would have been NO usergroups... Wink

which is what the fix in work is for...

Avatar
Lee H
Coastal New England (USA)
Member
Free Members
sp_UserOfflineSmall Offline
Jul 29, 2011 - 10:08 pm

LOL I could of lied if that would make you happy!

I was browsing the database for clues and comparing the serialized data in wp_sfmembers, column memberships for "Lee" with other regular members (that don't show in the Admin group) and couldn't see any difference at all.

But here's Lee's memberships for the heck of it anyway:

a:1:{i:0;a:4:{s:12:"usergroup_id";s:1:"2";s:14:"usergroup_name";s:7:"Members";s:14:"usergroup_desc";s:52:"Default Usergroup for registered users of the forum.";s:14:"usergroup_join";s:1:"0";}}

HTH

Avatar
Lee H
Coastal New England (USA)
Member
Free Members
sp_UserOfflineSmall Offline
Jul 29, 2011 - 10:39 pm

Hold the bus!

in table wp_sfmemberships, Lee (user_id 40) is listed twice. The first for usergroup_id 2 which is the Members group.

and the very last entry....   usergroup_id 0!

WTF?

I can't see Lee as Admin anywhere in the SP backend. And I'm certain I've never made Lee Admin because EP Admin is all business and Lee is my personality.

Logging in as Lee I can't do anything special. Not even access to the private forum.

I don't get it. [Image Can Not Be Found]

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2011 - 12:07 am

usergroup id 0?? no such thing... there is no usergroup for admins...

is this in your live database too? could be from long ago when there was usergroups issues... but a id of 0, might cause the same problem...

Avatar
Lee H
Coastal New England (USA)
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2011 - 1:41 am

Lee's not in usergroup 0 in the live database. Nor is anyone else. I also checked another dev server I have and no usergroup 0. I don't know. Both mentioned dev server databases are based off of the live one.

I sort of have a theory though.

My dev servers are clones of the live server. Or started off that way.  Even the domains are the same. I can log into the live server, and toggle right into one of the dev servers and my browser doesn't even know the difference. My point is if I was logged into the live server. And logged into another username, then switched users... the live servers cookie will work on my dev servers and I could continue browsing on the dev server as the new username without skipping a beat.

I'm thinking it might of bit me in the butt. I may of left this dev server as one user, and came back another user and I was messing with settings, the data might of gotten corrupt.

Confused yet? LOL

Best I can come up with. Whatever the case, I'm terribly embarrassed and will feel horrible if I discover I've sent you and Andy off on a ghost hunt.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 30, 2011 - 4:19 am

Confused? Totally 🙂
The good news is that your original data is NOT bad so that is something.
But it's not a waste of time - far from it - as it has helped uncover one of those situations that some user somewhere at some time would have discovered and would have had us scratching our heads over for days!

andy-signature.png
YELLOW
SWORDFISH
Avatar
Lee H
Coastal New England (USA)
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2011 - 10:10 am

Yellow Swordfish said:

Confused? Totally 🙂

Honest answer, I can respect that! [Image Can Not Be Found]

For the record, I deleted the row in the db and all is well. I wanted to hold off deleting it until you guys gave me some kind of input.

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625