竹貓星球

各位大大，偶今天裝POINT SYSTEM，裝完一切都OK就是不能註冊叻，會有錯誤訊息－－

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 ''0', user_gender, user_level, user_allow_pm, user_active, user_

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, '0', user_gender, user_level, user_allow_pm, user_active, user_actkey) VALUES (3, '论坛测试技术支持', 1054693457, '4c93008615c2d041e33ebac605d14b5b', 'xianxian78@msn.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'chinese_simplified', 2, 0, 1, 1, '')

不解？ 查詢過以往舊帖，未有答案，，希望大大解答，謝謝！！！

這邊多了一個 0, 刪掉試試看

~Mac

Mac 寫:

代碼: 選擇全部

style, '0', user_gender

這邊多了一個 0, 刪掉試試看

~Mac

請問大大在那裏刪除啊？歐的數據庫裏靣沒有“0”這個FIELD啊～～

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, '0', user_gender, user_level, user_allow_pm

你都沒仔細看喔~
依mac的方法試試吧，記得不是只去掉0而是去掉 , '0' <==

你在哪一頁有問題, 就去找找問題