[問題] cash mod2.2.3a安裝sql問題

[choppy]

今天剛把phpbb2.0.17更新到2.0.19.
把cash mod223a的所有檔案上載,當執行sql_insatll.php的時侯便出現下面的error了.
我在phpmyadmin 手動執行也是一樣.


================================================

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)
);
+++ Successfull

CREATE TABLE phpbb_cash_events (
event_name varchar(32) NOT NULL default ' ',
event_data varchar(255) NOT NULL default ' ',
PRIMARY KEY (event_name)
);
+++ Successfull

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)
);
+++ Successfull

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)
);
+++ Successfull

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)
);
+++ Successfull

[心靈捕手]

我猜想:
您之前已經執行過 sql_insatll.php

建議您:
忽略這些錯誤訊息;
或者, 先刪除所有新建立的資料表, 和已經存在資料表 phpbb_config 的欄位後,
再重新執行一次 sql_insatll.php

ps.
移動到 '官方外掛討論' 版面.