Joined: Oct 26, 2005 Posts: 131 Location: Maryland
Posted: Sun Oct 28, 2007 8:22 pm Post subject: Admin_Groups.php error
ok, the second issue with the 8.1 release from here that i found and i hope this isnt a re-post and if it is i apologize.
then i wanted to add something to Moderators groups that is default group in forum (Group Admin -->Management, selected group moderators and clicked on look up group) and this is what i got.
Code:
Could not obtain user info for moderator list
DEBUG MODE
SELECT user_id, username FROM nuke_users WHERE user_id = 5
Line : 119
File : admin_groups.php
So i needed to adjust the user_id to the correct number, which with my install was 2 so the easiest way to fix it for me was to drop the bbgroups table and re-add it as follows.
Code:
CREATE TABLE `nuke_bbgroups` (
`group_id` mediumint( 8 ) NOT NULL AUTO_INCREMENT ,
`group_type` tinyint( 4 ) NOT NULL default '1',
`group_name` varchar( 40 ) NOT NULL default '',
`group_description` varchar( 255 ) NOT NULL default '',
`group_moderator` mediumint( 8 ) NOT NULL default '0',
`group_single_user` tinyint( 1 ) NOT NULL default '1',
PRIMARY KEY ( `group_id` ) ,
KEY `group_single_user` ( `group_single_user` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4;# MySQL returned an empty result set (i.e. zero rows).
--
-- Dumping data for table `nuke_bbgroups`
--
INSERT INTO `nuke_bbgroups`
VALUES ( 1, 1, 'Anonymous', 'Personal User', 0, 1 ) ;# Affected rows: 1
INSERT INTO `nuke_bbgroups`
VALUES ( 3, 2, 'Moderators', 'Moderators of this Forum', 1, 0 ) ;# Affected rows: 1
I hope this helps someone other then myself. _________________ When you try and fail it hurts but when you try and quit you die.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Forum FAQ
Search
Usergroups
Profile
Log in
