[問題] CashMod223a

[gini630]

問題外掛：CashMod223a
參考連結：http://phpbb-tw.net/phpbb/viewtopic.php?t=40304
使用版本： phpBB 2.0.20
網站位置：http://gini.no-ip.org/phpBB2/index.php
狀況描述
問題1:後台點選Cash Admin 為什麼是顯示Parse error: parse error in c:\appserv\www\phpbb2\language\lang_chinese_traditional_taiwan\lang_cash.php on line 27

問題2:
各位大大小弟用phpbb2.0.20 big5版~安裝了CashMod223a後在要登入論壇時顯示以下這些~請問該如何解決呢??安裝沒成功?@@

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable',0);
+++ Error: Duplicate entry 'cash_disable' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_display_after_posts',1);
+++ Error: Duplicate entry 'cash_display_after_posts' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');
+++ Error: Duplicate entry 'cash_post_message' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_num',10);
+++ Error: Duplicate entry 'cash_disable_spam_num' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_time',24);
+++ Error: Duplicate entry 'cash_disable_spam_time' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post');
+++ Error: Duplicate entry 'cash_disable_spam_message' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_installed','yes');
+++ Error: Duplicate entry 'cash_installed' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_version','2.2.3');
+++ Error: Duplicate entry 'cash_version' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_name','Points');
+++ Error: Duplicate entry 'points_name' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminnavbar','1');
+++ Error: Duplicate entry 'cash_adminnavbar' for key 1

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminbig','0');
+++ Error: Duplicate entry 'cash_adminbig' for key 1

CREATE TABLE phpbb_cash (
cash_id smallint(6) NOT NULL auto_increment,
cash_order smallint(6) NOT NULL default '0',
cash_settings smallint(4) NOT NULL default '3313',
cash_dbfield varchar(64) NOT NULL default 'user_cash',
cash_name varchar(64) NOT NULL default 'cash',
cash_default int(11) NOT NULL default '0',
cash_decimals tinyint(2) NOT NULL default '0',
cash_imageurl varchar(255) NOT NULL default ' ',
cash_exchange int(11) NOT NULL default '1',
cash_perpost int(11) NOT NULL default '25',
cash_postbonus int(11) NOT NULL default '2',
cash_perreply int(11) NOT NULL default '25',
cash_maxearn int(11) NOT NULL default '75',
cash_perpm int(11) NOT NULL default '0',
cash_perchar int(11) NOT NULL default '20',
cash_allowance tinyint(1) NOT NULL default '0',
cash_allowanceamount int(11) NOT NULL default '0',
cash_allowancetime tinyint(2) NOT NULL default '2',
cash_allowancenext int(11) NOT NULL default '0',
cash_forumlist varchar(255) NOT NULL default ' ',
PRIMARY KEY (cash_id)
);
+++ Error: Table 'phpbb_cash' already exists

CREATE TABLE phpbb_cash_events (
event_name varchar(32) NOT NULL default ' ',
event_data varchar(255) NOT NULL default ' ',
PRIMARY KEY (event_name)
);
+++ Error: Table 'phpbb_cash_events' already exists

CREATE TABLE phpbb_cash_exchange (
ex_cash_id1 int(11) NOT NULL default '0',
ex_cash_id2 int(11) NOT NULL default '0',
ex_cash_enabled int(1) NOT NULL default '0',
PRIMARY KEY (ex_cash_id1,ex_cash_id2)
);
+++ Error: Table 'phpbb_cash_exchange' already exists

CREATE TABLE phpbb_cash_groups (
group_id mediumint(6) NOT NULL default '0',
group_type tinyint(2) NOT NULL default '0',
cash_id smallint(6) NOT NULL default '0',
cash_perpost int(11) NOT NULL default '0',
cash_postbonus int(11) NOT NULL default '0',
cash_perreply int(11) NOT NULL default '0',
cash_perchar int(11) NOT NULL default '0',
cash_maxearn int(11) NOT NULL default '0',
cash_perpm int(11) NOT NULL default '0',
cash_allowance tinyint(1) NOT NULL default '0',
cash_allowanceamount int(11) NOT NULL default '0',
cash_allowancetime tinyint(2) NOT NULL default '2',
cash_allowancenext int(11) NOT NULL default '0',
PRIMARY KEY (group_id,group_type,cash_id)
);
+++ Error: Table 'phpbb_cash_groups' already exists

CREATE TABLE phpbb_cash_log (
log_id int(11) NOT NULL auto_increment,
log_time int(11) NOT NULL default '0',
log_type smallint(6) NOT NULL default '0',
log_action varchar(255) NOT NULL default ' ',
log_text varchar(255) NOT NULL default ' ',
PRIMARY KEY (log_id)
);
+++ Error: Table 'phpbb_cash_log' already exists

[心靈捕手]

建議您:
1. 檢視新風格的相關檔案, 是否已經上傳或修改完整?
2. 不需要重複執行資料庫的更新檔 (sql_install.php)
3. 請參考 (熟讀) 這個主題.
http://phpbb-tw.net/phpbb/viewtopic.php?t=22832

[gini630]

心靈補手大大首先感謝您的回覆~小弟有熟讀新手安裝mod那篇~後來也是出現上述問題~修改方面小弟慢慢一步步修改並參考2.0.19跟虛擬銀行的壓縮包比對
應該是沒錯才對@@

sql語法我是修改完檔案在去新增sql語法~新增完後就把sql_install.php檔安裝上

php根目錄~之後連上http://gini.no-ip.org/phpbb2/sql_install.php
會跳去會員登入的畫面~打帳號登入後就會出現上述問題~但是只會出現一次~
後來測試虛擬貨幣發覺沒問題說@@~真怪qq

[心靈捕手]

sql語法我是修改完檔案在去新增sql語法~新增完後就把sql_install.php檔安裝上

php根目錄~之後連上http://gini.no-ip.org/phpbb2/sql_install.php
會跳去會員登入的畫面~打帳號登入後就會出現上述問題~但是只會出現一次~
後來測試虛擬貨幣發覺沒問題說@@~真怪qq

既然都已經 '新增sql語法' 了,
何必還要去 '把sql_install.php檔安裝' 呢?
而之所以 '會跳去會員登入的畫面', 是因為執行 sql_install.php
必須要有系統管理員權限.

建議您:
可以移除 sql_install.php 了!

[gini630]

新增sql語法後就不必執行sql_install.php檔了嗎??另外小弟很感謝您的回答~在此跟您說聲謝謝大大^^

[問題狂]

新增sql語法後就不必執行sql_install.php檔了嗎?

是的,因為執行sql_install.php時就會自動新增sql進你的資料庫
所以不必兩個都做,要不然就等於重複做相同的步驟所以會產生錯誤訊息
不過正常的順序是執行sql_install.php在刪除就可以了~
不過其實手動去新增sql語法也可行,但是比較麻煩