phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

Could not update user group table

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 ')' at line 3

UPDATE phpbb_users SET user_colour = '#BF4000' WHERE user_id IN ()

Line : 714
File : groupcp.php

Код: Выделить всё

if ( !empty($members) )
						{
						$sql = "DELETE FROM " . USER_GROUP_TABLE . " 
							WHERE user_id IN ($sql_in) 
								AND group_id = $group_id";
								$sql_update_users = "UPDATE "  . USERS_TABLE . " 
							SET user_colour = '' 
							WHERE user_id IN ($sql_in) AND user_colour = '" . var_escape($group_info['group_colour']) . "'";
						if ( !$db->sql_query($sql_update_users) )
						{
							message_die(GENERAL_ERROR, 'Could not delete user colour', '', __LINE__, __FILE__, $sql);
						}						
						
						}
						else if ( !empty($default_group) )
						{
							$sql = "UPDATE " . USERS_TABLE . " 
								SET user_colour = '" . var_escape($group_info['group_colour']) . "' 
								WHERE user_id IN ($sql_in_default_group)";
						}

					}

					if ( !$db->sql_query($sql) )
					{
строка #714				message_die(GENERAL_ERROR, 'Could not update user group table', '', __LINE__, __FILE__, $sql);
					}

					//
					// Email users when they are approved
					//
					if ( isset($HTTP_POST_VARS['approve']) )
					{
						if ( !($result = $db->sql_query($sql_select)) )
						{
							message_die(GENERAL_ERROR, 'Could not get user email information', '', __LINE__, __FILE__, $sql);
						}

Код: Выделить всё

for($i = 0; $i < count($default_group); $i++)
					{
						$sql_in_default_group .= ( ( $sql_in_default_group != '' ) ? ', ' : '' ) . intval($default_group[$i]);
					}