Usergroup debug problem
-----
| Author | Message | |
|---|---|---|
|
Presents |
||
| Fri Dec 29, 2006 10:41 pm Post subject: Usergroup debug problem | ||
|
Well, a while ago I deleted this user through the Admin Toolkit by Starfoxtj.
The thing is, he used to be the moderator of a usergroup. Now I can't access the usergroup to even delete it. I allowed him to make a new account and he made it with the same username, so I can't delete the username from the ACP, though I don't even think that would help. I get this error whenever I try to access the usergroup : Code: Could not obtain user info for moderator list
DEBUG MODE SELECT user_id, username FROM phpbb_users WHERE user_id = 105 Line : 119 File : admin_groups.php And for the groupcp debug error : Code: 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.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM phpbb_users u, phpbb_user_group ug WHERE ug.group_id = 115 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username Line : 786 File : groupcp.php Yep, that's about it. I just need to delete the usergroup from the database, or change it to a new moderator, which I've no clue how to do. Thanks for reading. EDIT : Ahh, I found the query to change the group moderator through phpmyadmin. Close this thread please, and sorry for the inconvienence. However, this is a bug that some people might be interested in knowing about. 
|
||
|
jackie |
||
| Wed Jan 17, 2007 12:43 pm Post subject: | ||
|
I also had the same issue a few months back.
I'm glad you got it sorted now though. 
|
||
Page 1 of 1