[問題]gender修改問題(已解決)

文章由 **yuchihchi** » 2005-12-26 02:08

gender_1.2.6em
我發現到就是在改下面成式碼\r

#-----[ FIND ]------------------------------------------------ 
# 
$sql = "UPDATE " . USERS_TABLE . "
SET

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
# 
$avatar_sql . "

# 
#-----[ IN-LINE AFTER, ADD ]---------------------------------- 
# 
, user_gender = '$gender'

#

這是我改的

代碼: 選擇全部

SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . ", user_gender = '$gender'
                                WHERE user_id = $user_id";
                        if ( !($result = $db->sql_query($sql)) )
                        {

可是就在我在改為男性或女性時出下以下錯誤

代碼: 選擇全部

Could not update users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_gender' in 'field list'

UPDATE phpbb_users SET user_email = 'yudi@yudi.no-ip.org', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 0, user_dateformat = 'd M Y h:i a', user_lang = 'chinese_traditional_taiwan', user_style = 1, user_active = 1, user_actkey = '', user_gender = '1' WHERE user_id = 2

Line : 523
File : usercp_register.php

文章由 **yuchihchi** » 2005-12-26 02:15

剛重新點選文章..才知道忘了執行

代碼: 選擇全部

#
#-----[ ADD SQL ]------------------------------------------
#
# or run the included db_update.php file as admin
#
ALTER TABLE phpbb_users ADD user_gender TINYINT not null DEFAULT "0"