[問題]關於會員暱稱(for 2.0.4)的安裝問題？
發表於 : 2004-04-09 15:28
由 knightt
小弟照這篇
[外掛][版面整理]會員暱稱(for 2.0.4)
安裝後，在會員新增暱稱時，按下送出後，得到下面的回應
代碼: 選擇全部
Could not update users 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 ' user_timezone = 8, user_dateformat = 'D M d, Y g:i a', user_la
UPDATE fuhbic_users SET user_email = 'knightt@pchome.com.tw', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_nickname = '彼得兔', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = , user_timezone = 8, user_dateformat = 'D M d, Y g:i a', user_lang = 'chinese_traditional_taiwan', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 3
Line : 470
File : c:\appserv\www\bbs\includes\usercp_register.php
小弟有針對usercp_register.php這個檔案
再重新作了一次安裝，不過還是不行
還請各位前輩協助，感謝
/bow
發表於 : 2004-04-09 18:03
由 動機不明
把 470 那行再加上他的上下三行都貼出來看看 (467 ~ 473)
還有請把你的 phpBB 版本也說明一下...
發表於 : 2004-04-10 12:00
由 knightt
先感謝動機前輩的幫忙
knightt 寫:小弟的版本是：
windows 2000+SP4
AppServ Open Project - 2.1.0 for Windows
php的版本是竹貓出的書附的
Powered by phpBB 2.0.6 © 2001, 2002 phpBB Group
另因為小弟是裝在公司內部的區網，所以沒辦法讓各位前輩連進來，
先行抱歉
再來以下是usercp_register.php的464~474行
代碼: 選擇全部
$sql = "UPDATE " . USERS_TABLE . "
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_nickname = '" . str_replace("\'", "''", $nickname) . "', 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 = $popuppm, 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 . "
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}
if ( !$user_active )
{
再麻煩前輩了，感謝
/bow
發表於 : 2004-04-10 12:22
由 動機不明
我....我看的眼花撩亂 ^^|||
只能說你大概是這裡錯了吧..錯在哪裡不曉得....要不要還原回去後重試一遍?
$sql = "UPDATE " . USERS_TABLE . "
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_nickname = '" . str_replace("\'", "''", $nickname) . "', 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 = $popuppm, 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 . "
WHERE user_id = $user_id";