[問題] 註冊出現錯誤 (已搞定)
發表於 : 2003-05-07 23:41
拍謝~~請教..我看不懂這是哪出錯\r
註冊時出現下列錯誤
我的論壇
*****************
拍謝~~已搞定
會員暱稱這個MOD未裝好\r
這部分未改到~紅字
註冊時出現下列錯誤
代碼: 選擇全部
Could not insert data into users table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_from_flag, 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, user_gender, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (22, '123', 1052322037, '202cb962ac59075b964b07152d234b70', 'mmcmmc@pchome.com.tw', '', '', '', '', 'blank.gif', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 0, 1, 8, 'D M d, Y g:i a', 'chinese_traditional_taiwan', '', 1, '0', 0, 1,'999999','', 0, '8dc78f')
Line : 597
File : /home2/rueichio/public_html/phpBB~plus/includes/usercp_register.php
*****************
拍謝~~已搞定
會員暱稱這個MOD未裝好\r
這部分未改到~紅字
代碼: 選擇全部
$sql = "INSERT INTO " . USERS_TABLE . " (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,[color=red] user_nickname[/color], user_style, user_level, user_allow_pm, user_active, user_actkey)