竹貓星球

代碼: 選擇全部

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 'user_reply = user_reply - 1 WHERE user_id = 2' at line 3

UPDATE phpbb_users SET user_reply = user_reply + 1 WHERE user_id = 2

Line : 296
File : c:\appserv\www\phpbb2\modcp.php

代碼: 選擇全部

if( !$userdata['session_logged_in'] ) 
{ 
   header('Location: ' . append_sid("login.$phpEx?redirect=reply_install.$phpEx", true)); 
} 
if( $userdata['user_level'] != ADMIN ) 
{ 
   message_die(GENERAL_MESSAGE, $lang['Not_Authorised']); 
} 
  
$sql = "ALTER TABLE ".USERS_TABLE." ADD `user_reply` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_posts`"; 

if ( !$db->sql_query($sql) ) 
{ 
   message_die(GENERAL_MESSAGE, [color=red]'Error adding field to the tablefont'[/color]); 
} 
else 
{ 
   $text = 'Field has installed successfully' . '<br>'; 
}