竹貓星球

?input type="submit" class="newsbutton" value="Go" name="avatargallery" />

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_actkey = '', user_avatar = 'onion/01.jpg', user_avatar_type = 3 WHERE' at line 2

UPDATE phpbb_users SET user_email = 'jacktu@accord-express.com', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_allow_mass_pm = 2, user_popup_pm = 1, user_timezone = 8, user_dateformat = 'D M d, Y g:i a', user_lang = 'chinese_traditional_taiwan', user_style = 12, user_active = 1, user_nqlm_enable = 0, user_nqlm_level = , user_actkey = '', user_avatar = 'onion/01.jpg', user_avatar_type = 3 WHERE user_id = 771

Line : 541
File : usercp_register.php

jacktu 寫:已搜尋過"系統相簿"但是好像找不到我的問題！
我把圖片上傳到images/avatars/gallery/onion這個資料夾中，點選系統相簿後，有發現onion這個選項，也有圖片，但是問題有兩個：

第一個問題是「選擇種類」處後面有一些代碼出現

?input type="submit" class="newsbutton" value="Go" name="avatargallery" />

雖然不影響圖片顯示，但正常也應該不會出現，不知該如何去掉呢？

第二個問題則是「選擇頭像」後，回到個人資料處的頭像控制面板的確有看到頭像出現，但是當按下「送出」後，卻出現了

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_actkey = '', user_avatar = 'onion/01.jpg', user_avatar_type = 3 WHERE' at line 2

UPDATE phpbb_users SET user_email = 'jacktu@accord-express.com', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_allow_mass_pm = 2, user_popup_pm = 1, user_timezone = 8, user_dateformat = 'D M d, Y g:i a', user_lang = 'chinese_traditional_taiwan', user_style = 12, user_active = 1, user_nqlm_enable = 0, user_nqlm_level = , user_actkey = '', user_avatar = 'onion/01.jpg', user_avatar_type = 3 WHERE user_id = 771

Line : 541
File : usercp_register.php

而圖片也無法顯示，這段讓我不知道錯誤到底是出在那裡，而又要如何修改，希望有人能夠給我一個方向，謝謝！

user_nqlm_enable = 0, user_nqlm_level = 

jacktu 寫:感謝心靈補手，05年剛學phpbb時常在貴論壇爬文，收獲不少！

1.曾經裝過預設頭像、及一個可以在註冊時填寫額外我想增加項目的mod(正確mod名稱已經忘了)、大量pm、搜尋時只搜尋標題..因大部分均為一年前增改，故有些已經忘記了，真不好意思！

2.
http://jacktu119.myweb.hinet.net/usercp_register.rar

3.
帳號：fpr01
密碼：123456

麻煩了，昨天測試了一個晚上還是找不出原因呢！