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.

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…

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.

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!

Yellow Swordfish said:

Confused? Totally 🙂

Honest answer, I can respect that!

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.

cool. thanks. please let us know if it or another comes back… shouldnt happen, but ya never know 😉