第 1 頁 (共 1 頁)
[問題]SQL出錯
發表於 : 2004-02-16 00:13
由 Pok
●架設主機作業系統：Linux
●您的上網方式：HGC VDSL (
http://www.hgcbroadband.com/ )
●您安裝的程式：Apache + php + MySql
●您的 phpBB2 版本：phpBB 2.0.6
●您的 domain(網域名稱) ：Anomic-World
●您的 phpBB2 連結網址：
http://www.anomic-world.com/phpBB2/
●錯誤代碼：
代碼: 選擇全部
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 ''3', user_actkey = '', user_gender = '1' WHERE user_id = 3'
●錯誤狀態：不能更改個人資料及不能註冊
發表於 : 2004-02-16 06:03
由 ethan
能補一下完整的訊息嗎?
包含完整 sql 命令，及哪個檔案，第幾行等等
比較能獲到完整的幫助，這邊只能看出來
''3', user_actkey = '', user_gender = '1'
紅色部份多了一個單引號，刪掉一個試試
發表於 : 2004-02-16 06:45
由 Mac
還有這邊
代碼: 選擇全部
WHERE user_id = 3'
應該是\r
代碼: 選擇全部
WHERE user_id = '3'
~Mac
發表於 : 2004-02-16 17:58
由 Pok
代碼: 選擇全部
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 ''3', user_actkey = '', user_gender = '1' WHERE user_id = 3'
UPDATE phpbb_users SET user_email = 'Pok@i-Stealth.Com', user_icq = '282325322', user_website = 'http://pok.i-stealth.com', user_occ = '', user_from = 'i-Stealth.Com', user_interests = '', user_sig = '「人生優如一本書。愚蠢的人將它草草翻過，聰明的人卻會將它細細閱\\讀。為甚麼呢﹖因為聰明的人知道，只能讀一次。」',user_nickname = '', user_sig_bbcode_uid = 'd0335212f3', user_viewemail = 1, 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 = 0, user_popup_pm = 1, user_timezone = 8, user_dateformat = 'D M d, Y g:i a', user_lang = 'chinese_traditional_taiwan', user_style = 13, user_active = 1, user_nqlm_enable = 1, user_nqlm_level = 3, '3', user_actkey = '', user_gender = '1' WHERE user_id = 3
Line : 484
File : /home/anomic/public_html/phpBB2/includes/usercp_register.php
請問應該怎樣修改??
''3', user_actkey = '', user_gender = '1'
WHERE user_id = '3'
發表於 : 2004-02-16 23:45
由 Pok
''3', user_actkey = '', user_gender = '1'
我找不到這一個應在哪裡修改..
發表於 : 2004-02-17 04:22
由 ethan
果然還是要有完整訊息...... 我跟 Mac 都猜錯了
代碼: 選擇全部
user_nqlm_level = 3, [color=#ff0044]這裡少了東西[/color]'3', user_actkey = ''
你直接搜尋這些字串是找不到的
應該要看你的 includes/usercp_register.php 第 484 行的部份
發表於 : 2004-02-17 19:22
由 Pok
ethan 寫:果然還是要有完整訊息...... 我跟 Mac 都猜錯了
代碼: 選擇全部
user_nqlm_level = 3, [color=#ff0044]這裡少了東西[/color]'3', user_actkey = ''
你直接搜尋這些字串是找不到的
應該要看你的 includes/usercp_register.php 第 484 行的部份
代碼: 選擇全部
user_nqlm_enable = $nqlm_enable, user_nqlm_level = '" . str_replace("\'", "''", $nqlm_level) . "', user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . ", user_gender = '$gender'
我也是找不到哪裡有錯= =||
發表於 : 2004-02-17 19:31
由 messagebox
開DEBUG
將錯誤的SQL貼出來~~~
發表於 : 2004-02-17 19:52
由 Pok
代碼: 選擇全部
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 '3' at line 2
UPDATE phpbb_users SET user_email = 'Pok@i-Stealth.Com', user_icq = '282325322', user_website = 'http://pok.i-stealth.com', user_occ = '', user_from = 'i-Stealth.Com', user_interests = '', user_sig = '「人生優如一本書。愚蠢的人將它草草翻過，聰明的人卻會將它細細閱\\讀。為甚麼呢﹖因為聰明的人知道，只能讀一次。」',user_nickname = '', user_sig_bbcode_uid = '96f7e97687', user_viewemail = 1, 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 = 0, user_popup_pm = 1, user_timezone = 8, user_dateformat = 'D M d, Y g:i a', user_lang = 'chinese_traditional_taiwan', user_style = 13, user_active = 1,user_nqlm_enable = 1, user_nqlm_level = '3', user_actkey = ', user_gender = 1 WHERE user_id = '3
Line : 484
File : /home/anomic/public_html/phpBB2/includes/usercp_register.php
發表於 : 2004-02-17 19:59
由 messagebox
WHERE user_id = '3
看了半天~~~只找到這邊有錯誤~~
發表於 : 2004-02-17 21:15
由 Pok
哦~~已經解決了
謝謝各位的幫忙!!
