參考連結:http://phpbb-tw.net/phpbb/viewtopic.php?t=20786
使用版本:phpBB 2.0.21
網站位置:http://club.nfu.edu.tw/~nfucosplay/
狀況描述:
當我想要新增盜賊使用的手套的時候我用直接輸入會出現
要是用檔案輸入的話會出現SQL 語法:
INSERT INTO cos_rpg_items
VALUES (
"664", "練習用偷東西手套", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0"
)
我匯入/執行的文件是錯誤
這可能是您找到了 SQL 分析程式的一些程式錯誤,請細心查看您的語法,檢查一下引號是正確及沒有遺漏,其他可能出錯的原因可能來自您上載檔案時在引號外的地方使用了二進制碼。您可以嘗試在 MySQL 命令列介面執行該語法。如 MySQL 伺服器發出錯誤信息,這可能幫助您去找出問題所在。如您仍然未能解決問題,或在分析程式出現錯誤,但在命令列模式能正常執行,請將該句出現錯誤的 SQL 語法抽出,並將以下的"剪取"部份一同提交到臭虫區:
----開始 剪取----
eNqNjs9Og0AQxu/7FHNojCaw7q50i+uJkLWSUECW1mPjH7QktKVAtfV51EMPxnjvK/gKJp58DKk9
0QOaTDLzzcz3m5Fh6IcCbAo2A1d6AowOGCZQ3kEqqiYrhOyBEtBybgQUszS7zIs4x2lyhbNRpt0D
w0ccGCHtQ2JWUZWCMUEppPH4GOQigxbqLdW5K6CNCWYM9VUIvtLA6kov0mAgqzMXyQQcCRwTFPQs
UVE5NvQsNVBwFmxWNF9tABRzcJPJfIFcy+sKeByVD/q8vNVN9HvC8ZQMoypFPlxPi2Ge3Q2TMh4X
MLDcvlT7e7P5tDzh3NgWGmzzevz++fzxtl6dvnw/fb326tO6ojuyXdekLs0m1A7JJIQ0wkjzJ5wZ
zXbMdhvkzwb9r+XgBxLnst4=
----結束 剪取----
----開始 原始資料----
ERROR: C1 C2 LEN: 47 48 167
STR: ?
CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 5.0.22
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.6.4-pl4
PHP VER,OS: 5.1.6 Linux
LANG: zhtw-utf-8
SQL: INSERT INTO cos_rpg_items VALUES("664", "?m?ߥΰ??F?褢?M", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0")
----結束 原始資料----
請問有哪裡改錯嗎?不然怎麼匯不進資料庫...INSERT INTO cos_rpg_items VALUES("664", "練習用偷東西手套", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("665", "偷東西手套", "", "1", "20", "0", "8", "", "", "25000", "0", "0", "1", "1625", "0", "0.4", "0.0", "0.0", "0.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("666", "滑滑的手套", "", "1", "25", "0", "8", "", "", "30000", "0", "0", "1", "1626", "0", "0.6", "0.0", "0.0", "0.0", "0.5", "0.0");
INSERT INTO cos_rpg_items VALUES("667", "粗布手套", "", "1", "32", "0", "8", "", "", "100000", "0", "0", "1", "1627", "0", "1.0", "0.0", "0.0", "0.0", "1.0", "0.0");
INSERT INTO cos_rpg_items VALUES("668", "騎機車用防風手套", "", "1", "30", "0", "8", "", "", "80000", "0", "0", "1", "1628", "0", "1.2", "0.0", "0.0", "1.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("669", "不起眼的手套", "", "1", "35", "0", "8", "", "", "100000", "0", "0", "1", "1629", "0", "1.6", "0.0", "0.0", "2.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("670", "手術用手套", "", "1", "40", "0", "8", "", "", "250000", "0", "0", "1", "1630", "0", "2.0", "0.0", "0.0", "2.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("671", "看不見的手套", "", "1", "45", "0", "8", "", "", "400000", "0", "0", "1", "1631", "0", "2.6", "0.0", "0.0", "3.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("672", "被抓到的手套", "", "1", "50", "0", "8", "", "", "800000", "0", "0", "1", "1632", "0", "3.2", "0.0", "0.0", "3.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("673", "這不是手套", "", "1", "55", "0", "8", "", "", "1000000", "0", "0", "1", "1633", "0", "4.0", "0.0", "0.0", "4.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("674", "偷了就走手套", "", "1", "60", "0", "8", "", "", "4000000", "0", "0", "1", "1634", "0", "5.0", "0.0", "0.0", "4.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("675", "保證偷不到手套", "", "1", "100", "0", "8", "", "", "10000000", "0", "0", "1", "1635", "0", "6.0", "0.0", "0.0", "5.0", "0.0", "0.0");
還有就是我要是想要增加新職業的話就會變成這樣
17 蠢系Lv9 攻擊+23.0 速度+22.0 30000
18 蠢系Lv9 攻擊+23.0 速度+22.0 30000
就是同樣的東西會變成兩行...
我只是匯入
而已,本來是只有蠢系會這樣,但是後來重新匯入時連笙美系都會變成兩行...INSERT INTO cos_rpg_position VALUES("85", "蠢系Lv1", "10", "0", "2000", "7.0", "0.0", "0.0", "6.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("86", "蠢系Lv2", "10", "1", "3000", "9.0", "0.0", "0.0", "8.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("87", "蠢系Lv3", "10", "2", "4500", "11.0", "0.0", "0.0", "10.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("88", "蠢系Lv4", "10", "3", "6000", "13.0", "0.0", "0.0", "12.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("89", "蠢系Lv5", "10", "4", "8000", "15.0", "0.0", "0.0", "14.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("90", "蠢系Lv6", "10", "5", "11000", "17.0", "0.0", "0.0", "16.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("91", "蠢系Lv7", "10", "6", "15000", "19.0", "0.0", "0.0", "18.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("92", "蠢系Lv8", "10", "7", "20000", "21.0", "0.0", "0.0", "20.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("93", "蠢系Lv9", "10", "8", "30000", "23.0", "0.0", "0.0", "22.0", "0.0", "0.0");