1 頁 (共 1 頁)

無法新增會員

發表於 : 2006-10-16 13:21
chenyilun
●架設主機作業系統:Linux RedHat 9.0
●您的上網方式:ADSL
●您安裝的程式:l
Libxml2 2.5.11 + Apache 2.0.50+ php 5.0.1 + MySql 4.0.18 +phpMyAdmin 2.5.6
●您的 phpBB2 版本:phpBB 2.0.21。
shunshin.gscc.net.tw
原先安裝於windows xp ,現在改用linux.
phpbb2是直接用usb copy,MySQL 用備份回復,現無法新增會員,刪除會員會成功但有錯誤訊息.

代碼: 選擇全部

Could not insert data into 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 '', 'dc82dc95, '', '', '', '', '', 'CYL4433', 'SHUNSHIN', 'ENGIN

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_birthday, user_regip, user_icq, user_website, user_occ, user_from, user_interests,user_real_name, user_company, user_designation, user_country, user_company_address, user_company_logo, user_com_add_bbcode_uid, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_skype, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_selected_logo, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (3, 'CYL4433', 1160969138, '63541c8db0fa478a33118b2b15c2633b', 'chen.yilun@msa.hinet.net', 05191964', 'dc82dc95, '', '', '', '', '', 'CYL4433', 'SHUNSHIN', 'ENGINEER', '', 'TAIPEI', '', '2b5acf8b46', '', '', '', 0, 0, '', '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 8, '', 'D M d, Y g:i a', 'chinese_traditional_taiwan', 1, 0, 1, 1, '')

Line : 840
File : usercp_register.php

發表於 : 2006-10-16 18:32
心靈捕手
建議您:
檢視 includes/usercp_register.php 的修改;
或者, 將其壓縮後, 貼出下載連結.

發表於 : 2006-10-26 12:10
chenyilun
對不起!已解決,XP路徑phpBB2--Linux路徑phpbb2,改完就ok.
謝謝!

Re: 無法新增會員

發表於 : 2006-10-30 22:35
心靈捕手
chenyilun 寫:●架設主機作業系統:Linux RedHat 9.0
●您的上網方式:ADSL
●您安裝的程式:l
Libxml2 2.5.11 + Apache 2.0.50+ php 5.0.1 + MySql 4.0.18 +phpMyAdmin 2.5.6
●您的 phpBB2 版本:phpBB 2.0.21。
shunshin.gscc.net.tw
原先安裝於windows xp ,現在改用linux.
phpbb2是直接用usb copy,MySQL 用備份回復,現無法新增會員,刪除會員會成功但有錯誤訊息.

代碼: 選擇全部

Could not insert data into 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 '', 'dc82dc95, '', '', '', '', '', 'CYL4433', 'SHUNSHIN', 'ENGIN

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_birthday, user_regip, user_icq, user_website, user_occ, user_from, user_interests,user_real_name, user_company, user_designation, user_country, user_company_address, user_company_logo, user_com_add_bbcode_uid, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_skype, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_selected_logo, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (3, 'CYL4433', 1160969138, '63541c8db0fa478a33118b2b15c2633b', 'chen.yilun@msa.hinet.net', 05191964', 'dc82dc95, '', '', '', '', '', 'CYL4433', 'SHUNSHIN', 'ENGINEER', '', 'TAIPEI', '', '2b5acf8b46', '', '', '', 0, 0, '', '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 8, '', 'D M d, Y g:i a', 'chinese_traditional_taiwan', 1, 0, 1, 1, '')

Line : 840
File : usercp_register.php
只是 '路徑' 問題嗎? :-?

我猜想:
應該是您新增外掛時, 新增語法錯誤吧!
user_regip -> 'dc82dc95
正解不該是 'dc82dc95' 嗎?