[問題]SQL出錯

[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'

●錯誤狀態：不能更改個人資料及不能註冊

[ethan]

能補一下完整的訊息嗎?
包含完整 sql 命令，及哪個檔案，第幾行等等
比較能獲到完整的幫助，這邊只能看出來
''3', user_actkey = '', user_gender = '1'
紅色部份多了一個單引號，刪掉一個試試

[Mac]

還有這邊

代碼: 選擇全部

WHERE user_id = 3'

應該是\r

代碼: 選擇全部

WHERE user_id = '3'

~Mac

[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'

[Pok]

''3', user_actkey = '', user_gender = '1'

我找不到這一個應在哪裡修改..

[ethan]

果然還是要有完整訊息...... 我跟 Mac 都猜錯了

代碼: 選擇全部

user_nqlm_level = 3, [color=#ff0044]這裡少了東西[/color]'3', user_actkey = ''

你直接搜尋這些字串是找不到的
應該要看你的 includes/usercp_register.php 第 484 行的部份

[Pok]

果然還是要有完整訊息...... 我跟 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'

我也是找不到哪裡有錯= =||

[messagebox]

開DEBUG
將錯誤的SQL貼出來~~~

[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

[messagebox]

WHERE user_id = '3
看了半天~~~只找到這邊有錯誤~~

[Pok]

哦~~已經解決了

謝謝各位的幫忙!!