- If for some reason you delete a user account which was a group moderator you will find clicking the usegroups link and trying to view the groups information will give you an error. The error will look something like this,
"Why can we not just change the the group moderator via the Admin control panel?" I hear you ask. The missing group moderator will also cause an error in the group management when trying to manage the group in question, it will look something similar to this,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 = 16 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username
Line : 786
File : groupcp.phpCould not obtain user info for moderator list
DEBUG MODE
SELECT user_id, username FROM phpbb_users WHERE user_id = 6
Line : 119
File : admin_groups.php
The errors you get will vary slightly as you will probably have different user_id and group_id to the ones in the quotes above, they are just examples of what you will get. - If you have phpmyadmin installed on you host you will be able to manage the database directly and fix this problem. Following is the instructions on how to do this.
- step 1:
highlight the correct database on the left hand side.
- step 2:
click on the phpbb_groups database table.
- step 3:
click on browse.
- step 4:
find the group in question that you would like to modify, and click on the pencil in that line.
- step 5:
enter the appropriate user number in the group_moderator box.
click go, and your all set!!!
- step 1:
- Of course for these instructions to be of any use you need a new user_id to use. To get this you simply need to go the the member list. Find the user name of the user you wish to make the new group moderator and click the user name. This will take you to the users profile page where you can get their user_id out of the URI in the browsers address bar. Their user_id will be the number after the u= for example,
Alternatively you can get to a users profile page by clicking the profile button on any of their posts on the forum.
Knowledge Base
Replacing a deleted group moderator using phpmyadmin
Article ID: 25
Written By: slice1
Written On: Fri Apr 27, 2007 7:47 am
Description: this will show you how to change the group moderator for a group which has had its group moderator deleted.
Article ID: 25
Written By: slice1
Written On: Fri Apr 27, 2007 7:47 am
Description: this will show you how to change the group moderator for a group which has had its group moderator deleted.
- link to this article on phpbb.com: Select All
[kb=replacing-a-deleted-group-moderator-using-phpmyadmin]Replacing a deleted group moderator using phpmyadmin[/kb]
- link to this article on your own board: Select All
[url=http://www.phpbb.com/kb/article/replacing-a-deleted-group-moderator-using-phpmyadmin/]Knowledge Base - Replacing a deleted group moderator using phpmyadmin[/url]
Overview