Error getting user list for group

TAd · Posted: Sat Oct 13, 2007 11:54 pm

Anyone have any ideas what the problem is? Using RN 2.10.01 and phpBB for nuke 2.0.22

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 nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = '3' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username

Line : 801
File : groupcp.php

URL was as mysite.com/modules.php?name=Forums&file=groupcp

I can replicate it by attempting to select the Moderator group. The Admin group works perfectly.

Dump of bbgroup:

Code:

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 13, 2007 at 08:38 AM
-- Server version: 4.1.22
-- PHP Version: 4.4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mydatabase`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_bbgroups`
--

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=5 ;

--
-- Dumping data for table `nuke_bbgroups`
--

INSERT INTO `nuke_bbgroups` VALUES(1, 1, 'Anonymous', 'Personal User', 0, 1);
INSERT INTO `nuke_bbgroups` VALUES(3, 2, 'Moderators', 'Moderators of this Forum', 5, 0);
INSERT INTO `nuke_bbgroups` VALUES(4, 0, 'Authors', 'Members who contribute articles, news, and or reviews.', 2, 0);

And one more:

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

Anyone have this issue, any ideas?

Gremmie · Posted: Sun Oct 14, 2007 12:32 am

Does your Moderators group have a group moderator user?

evaders99 · Posted: Sun Oct 14, 2007 12:46 am

My guess is a combination of missing user 'personal groups' - Run the fixgroup script
And no user ID of #5 in the users table (set to the moderators group erroneously during the default table install)

TAd · Posted: Sun Oct 14, 2007 12:12 pm

Gremmie, that is a cute Avatar Smile

and yes, I am the group moderator. But there are no users set to moderator.

Evaders, I see lots of oddities in the numbers [assigned] as well. When a user is deleted, are the numbers associated with that user removed, or does the count continue on?

I ran the script per your advise (downloaded from Nuke Fixes here

Only registered users can see links on this board!
Get registered or login to the forums!

) and the result that came back was:

Users:
Anonymous User has no user group, adding user group 5
name1 User has no user group, adding user group 6
name2 User has no user group, adding user group 7
name3 User has no user group, adding user group 8
name4 User has no user group, adding user group 9
name5 User has no user group, adding user group 10
name6 User has no user group, adding user group 11
name7 User has no user group, adding user group 12
name8 User has no user group, adding user group 13
name9 User has no user group, adding user group 14
name10 User has no user group, adding user group 15
name11 User has no user group, adding user group 16
name12 User has no user group, adding user group 17
(note I change the user name for posting)

And upon trying:

Quote:

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 nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = '3' AND u.user_id = ug.user_id AND ug.user_pending = '0' AND ug.user_id <> ORDER BY u.username

Line : 801
File : groupcp.php

With only a dozen or so users, will removing them and starting from scratch fix this, or will the problem continue?

On a side note, I was able to (within Forums Administration) add a second group called Moderators, so now two groups are there with the same name Smile

.

TAd · Posted: Sun Oct 14, 2007 12:25 pm

With Gremmie's comment, I decided lets try to add a new user, and then change the user_id to 5 (which was missing in the database scheme) and so I added TAd, then altered in phpMyAdmin the user_id from 16 to 5. Then went to the Forum Administration and selected the moderators and it came up Smile

Everything seems to be in order now, thank you for the helpful tips and advice Smile