FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Hidden/Lost Users?
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Hidden/Lost Users? [message #6554] Wed, 16 October 2002 14:45 Go to next message
smike is currently offline  smike   Germany
Messages: 182
Registered: April 2002
Location: Munich/Germany
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
I noticed that some users were "lost" by FUDForum.
Take a look at my group-manager. You can see some holes.

http://fud.prohost.org/forum/index.php?t=getfile&id=415

I have to admit that I don't know, whether these users have confirmed their account. But if they hadn't, the Forum should delete their accounts completely.

Thanks, Mike
Re: Hidden/Lost Users? [message #6558 is a reply to message #6554] Wed, 16 October 2002 17:06 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Which forum version is this?

FUDforum Core Developer
Re: Hidden/Lost Users? [message #6561 is a reply to message #6558] Wed, 16 October 2002 18:21 Go to previous messageGo to next message
smike is currently offline  smike   Germany
Messages: 182
Registered: April 2002
Location: Munich/Germany
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Sorry, I forgot.

It appears on 2.3.1 and also on 2.3.2.
Re: Hidden/Lost Users? [message #6564 is a reply to message #6561] Wed, 16 October 2002 19:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I have a suspicion on what could be the cause of those 'invisible' users, but to confirm the problem I'll need a little bit of help on your behalf.
Please run the MySQL query below and reply with the output.
SELECT fud21_group_members.user_id,fud21_users.id
FROM fud21_group_members
LEFT JOIN fud21_users ON fud21_group_members.user_id=fud21_users.id
WHERE fud21_group_members.user_id NOT IN(2147483647,0);


P.S. If you SQL table prefix is not fud21_, then replace fud21_ with the prefix you use.


FUDforum Core Developer
Re: Hidden/Lost Users? [message #6602 is a reply to message #6564] Fri, 18 October 2002 01:36 Go to previous messageGo to next message
smike is currently offline  smike   Germany
Messages: 182
Registered: April 2002
Location: Munich/Germany
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
I received a long list which I attached at this posting.

Contains the file what you expected to see?

Thanks, Mike
Re: Hidden/Lost Users? [message #6612 is a reply to message #6602] Fri, 18 October 2002 09:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Yup, there indeed was a bug which caused the user removal script to 'forget' to remove users from group_members. Hence the 'invisible' users, I've already corrected this bug in the CVS.

To resolve your problem run a query to delete all of those invisible users from group_memebers table. Given the SQL dump that you've shown, those users are the ones will a 'NULL' in the 2nd column.


FUDforum Core Developer
Re: Hidden/Lost Users? [message #6661 is a reply to message #6612] Mon, 21 October 2002 07:49 Go to previous messageGo to next message
smike is currently offline  smike   Germany
Messages: 182
Registered: April 2002
Location: Munich/Germany
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
prottoss schrieb am Fre, 18 Oktober 2002 15:59

To resolve your problem run a query to delete all of those invisible users from group_memebers table.
Perhaps you can help me another time with this query?

Thanks, Mike
Re: Hidden/Lost Users? [message #6662 is a reply to message #6661] Mon, 21 October 2002 08:03 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Well, create a PHP script that would connect to MySQL and run the same query as the one I've shown before.
The have PHP loop through the result set and if the value of the 2nd column is NULL delete that entry from group_members table.


FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Forum deleted - Permissions still there
Next Topic: "re" in different languages
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 11 04:40:32 EST 2017

Total time taken to generate the page: 0.00780 seconds