參考連結:http://phpbb-tw.net/phpbb/viewtopic.php?t=20786
使用版本:phpBB 2.0.21 utf-8版
網站位置:http://low.uto.tw
狀況描述:
為了裝水怪,我安裝了心靈捕手大大的CashMod223a+AttachMod243_for_phpBB2020
(雖然是給phpBB2.0.20的,可是令我驚訝的還是直接覆蓋成功)
在大略檢查過無誤後,我就直接開始安裝水怪(也是心靈捕手大大的版本-watermonster_103)
這兩天夙夜匪懈的爬文研究、不斷嘗試後,最後還是有幾個問題無法解決...
1.其中在安裝SQL.sql時,我以連線校對:latin1_general_ci,文字編碼檔案:latin1,更新檔SQL.sql轉碼成utf-8的情況下匯入
結果硬是有以下這些動作無法載入
代碼: 選擇全部
# INSERT INTO phpbb_rpg_items VALUES("3", "圖書禮券", "購買魔法圖書一本<font color=red><b>(暫時停止供應)</b></font>", "0", "0", "0", "", "請輸入東立漫畫名稱集數<br />(一至二個工作天,找不到書名集數,不受理)", "", "200000", "0", "0", "0", "0", "1", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0");
# INSERT INTO phpbb_rpg_map VALUES("11", "10", "0", "0", "10000", "1.50", "0", "黑北路最後一號");
# INSERT INTO phpbb_rpg_map VALUES("115", "10", "19", "0", "10000", "1.50", "0", "暗南路最後一號");
# INSERT INTO phpbb_rpg_map VALUES("119", "0", "21", "0", "150000", "3.20", "0", "灌水大(王)道1號");
# INSERT INTO phpbb_rpg_map VALUES("120", "1", "21", "0", "400000", "3.00", "0", "灌水大(王)道2號");
# INSERT INTO phpbb_rpg_map VALUES("121", "2", "21", "0", "200000", "4.00", "0", "灌水大(王)道3號");
# INSERT INTO phpbb_rpg_map VALUES("122", "3", "21", "0", "240000", "3.60", "0", "灌水大(王)道4號");
# INSERT INTO phpbb_rpg_map VALUES("123", "4", "21", "0", "300000", "4.80", "0", "灌水大(王)道5號");
# INSERT INTO phpbb_rpg_map VALUES("124", "5", "21", "0", "400000", "3.20", "0", "灌水大(王)道6號");
# INSERT INTO phpbb_rpg_map VALUES("125", "6", "21", "0", "500000", "4.80", "0", "灌水大(王)道7號");
# INSERT INTO phpbb_rpg_map VALUES("126", "7", "21", "0", "300000", "3.20", "0", "灌水大(王)道8號");
# INSERT INTO phpbb_rpg_map VALUES("127", "8", "21", "0", "240000", "3.60", "0", "灌水大(王)道9號");
# INSERT INTO phpbb_rpg_map VALUES("128", "9", "21", "0", "200000", "3.20", "0", "灌水大(王)道10號");
# INSERT INTO phpbb_rpg_map VALUES("129", "10", "21", "0", "400000", "3.00", "0", "灌水大(王)道11號");
# INSERT INTO phpbb_rpg_map VALUES("130", "11", "21", "0", "150000", "3.00", "0", "灌水大(王)道12號");
# INSERT INTO phpbb_rpg_setting VALUES("2", "0", "上次清除記錄時間");代碼: 選擇全部
#1406 - Data too long for column 'item_addition1' at row 1我也嘗試過把剩餘這些逐個匯入
但第一個就碰上問題
代碼: 選擇全部
錯誤
SQL 語法:
INSERT INTO phpbb_rpg_items
VALUES (
"3", "圖書禮券", "購買魔法圖書一本<font color=red><b>(暫時停止供應)</b></font>", "0", "0", "0", "", "請輸入東立漫畫名稱集數<br />(一至二個工作天,找不到書名集數,不受理)", "", "200000", "0", "0", "0", "0", "1", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0"
);
MySQL 傳回:
#1136 - Column count doesn't match value count at row 12.裝完這些外掛後,我發現首頁的"最後更新"那部份無法隨著人家發表新文章而跟著更新了
除非我去後台手動重整對應資料
(我不知是在安裝CashMod223a+AttachMod243_for_phpBB2020後就有此問題還是裝完水怪後才有)
很顯然我沒有動到index.php...是哪裡出問題了呢?
3.這問題可能很笨...在心靈捕手大大的水怪包裡的"補充說明_2"還有"rpg_eol_msg"都有提到一個動作:
#
#-----[ 在此行下行, 加上 ]------------------------------
#
恕我笨~"~ 可是在.tpl檔裡面雜亂無章的代碼下,
我完全不知道這句話該如何實行
哪裡才是"此行的下行"?
補充:
在安裝"CashMod223a+AttachMod243_for_phpBB2020"和"watermonster 1.0.3"前,
只有安裝過"郵件強制大五碼發送"和"註冊15秒等待"
或許還會有更多問題在後面等著我...可是安裝到這我已經敗了= ="
麻煩各位大大救救我吧XD

