Error in group management

[Blisk]

I think this error is becaus of Verify mod, but can not tell for soure.
When I try to see a group where user are automatically added after verifying, I can not, i get this error.

Code: Alles auswählen

Error getting user list for group

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY u.username' at line 7

SELECT u.username, u.*, ug.user_pending FROM phpbb_users u, phpbb_user_group ug WHERE ug.group_id = 148 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username

Line : 917
File : groupcp.php

When I try to see this group in ACP (group permission) I get this error, don't know what is wrong?

Code: Alles auswählen

Could not obtain user info for moderator list

DEBUG MODE

SELECT user_id, username FROM phpbb_users WHERE user_id = 108

Line : 126
File : admin_groups.php

This happend only for this group, other groups works ok.

[oxpus]

Maybe the user 108 will not exist?!

[Blisk]

Yes user 108 is missing, it was deleted I suppose.
But that shouldn't happend when user is deleted?
What to do?

[oxpus]

Install the DB Maintenance MOD to check the user group tables.

[Blisk]

uh thanks, I have that installed but didn't use it.
Now it works.
Great!

your' still the best