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

-- 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);

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