|
|
|
|
|
|
| Re: Hidden/Lost Users? [message #6564 is a reply to message #6561] |
Wed, 16 October 2002 23:24   |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 #6612 is a reply to message #6602] |
Fri, 18 October 2002 13:59 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 #6662 is a reply to message #6661] |
Mon, 21 October 2002 12:03 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]