ATTN Kuroneko: BoU usergroup bug

[J-M v2.5.5]

Whenever I check out the BoU usergroup to add someone or to ask myself "Why do people always choose different aliases in-game and in the forums?", I see this:


There's some mystery non-existant user in my group. Whenever I try to delete this person, I am informed that "The requested user does not exist."

mind = blown

I'm not sure if this is a problem because (as far as I can tell) nothing bad is happening, but I just figured I'd throw it out here anyway.
Are there other usergroup leaders who have similar issues?

 

[Thothie]

I don't see that in any of the groups I've control over, but it maybe that the user was deleted, thus leaving an invalid reference in the usergroup data.

 

[Echo717]

I have this as well, I always presumed it was a spy

 

[zeus9860]

It's a spy sappin your guild usergroup! Or maybe it's a birthday gift from someone xD

 

[Kuroneko]

Well, I took a look at both groups and don't see any missing entries or other erroneous items. If you could give me a full list of who you see, I may be able to figure out who it is by process of elimination

 

[J-M v2.5.5]

Here's the full list.
There's 40 people in BoU, myself included, and the list shows 41 people, myself included. That's because one guildmember has two forum accounts and I forgot which one he uses:

 

[Kuroneko]

Checked that list against the one I see, no omissions or excess entries. On a hunch, I did a database query for all users in the group and got the expected 41 results. I have no idea what causes you to see an extra blank entry. =\

 

[Echo717]

19 members, 2 without forum accounts

 

[J-M v2.5.5]

Checked that list against the one I see, no omissions or excess entries. On a hunch, I did a database query for all users in the group and got the expected 41 results. I have no idea what causes you to see an extra blank entry. =\

Oh well. Right now, I have no reason to believe that there's an actual problem, so I guess it's no big deal.

 

[cartman-2000]

This is phpbb's query to query members from the db, if it doesn't come back with an extra record with that, then it might be some bug with how php or mysql works on this server. I don't get anything like this on my own forums.

For querying BoU members(not the leaders.).

SELECT u.user_id, u.username, u.username_clean, u.user_colour, u.user_regdate, u.user_posts, u.group_id, ug.group_leader, ug.user_pending
FROM phpbb_users u, phpbb_user_group ug
WHERE ug.group_id =892
AND u.user_id = ug.user_id
AND ug.group_leader =0
ORDER BY ug.user_pending DESC , u.username_clean
LIMIT 25

 

[Kuroneko]

This is phpbb's query to query members from the db, if it doesn't come back with an extra record with that, then it might be some bug with how php or mysql works on this server. I don't get anything like this on my own forums.

For querying BoU members(not the leaders.).

SELECT u.user_id, u.username, u.username_clean, u.user_colour, u.user_regdate, u.user_posts, u.group_id, ug.group_leader, ug.user_pending
FROM phpbb_users u, phpbb_user_group ug
WHERE ug.group_id =892
AND u.user_id = ug.user_id
AND ug.group_leader =0
ORDER BY ug.user_pending DESC , u.username_clean
LIMIT 25

I already checked the query and the database, there are no extra records. I also looked at the same pages they looked at, and don't see extra records. It doesn't make a whole lot of sense