phpBB.de

Code: Alles auswählen

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 = 19 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

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
groupcp.php

#
#-----[ FIND ]------------------------------------------
#
	$group_moderator = $db->sql_fetchrow($result);
	
#
#-----[ AFTER, ADD ]------------------------------------------
#
  // Check if there is an existent group moderator set
  // if not, set the main admin as group moderator
  if ( empty($group_moderator['user_id']) )
  {
    $sql = "UPDATE " . GROUPS_TABLE . "
            SET group_moderator = 2
            WHERE group_id = $group_id";
    if ( !$db->sql_query($sql))
    {
      message_die(GENERAL_ERROR, 'Error setting main admin as moderator for group', '', __LINE__, __FILE__, $sql);
    }
    // Now that this is done we need to gain the
    // info about the main admin
	 $sql = "SELECT username, user_id, comm_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm
		       FROM " . USERS_TABLE . "
		       WHERE user_id = 2";
	 if ( !($result = $db->sql_query($sql)) )
	 {
		  message_die(GENERAL_ERROR, 'Error getting moderator info for group', '', __LINE__, __FILE__, $sql);
	 }
	 $group_moderator = $db->sql_fetchrow($result);
  }

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM