[問題]裝了虛擬貨幣之後....
版主: 版主管理群
[問題]....
錯誤啦!
我執行SQL_INSTALL.PHP時出現這個
[php]<?php
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_disable',0);
+++ Error: Duplicate entry 'cash_disable' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_display_after_posts',1);
+++ Error: Duplicate entry 'cash_display_after_posts' for key 1
INSERT INTO phpbb2_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 phpbb2_config (config_name, config_value) VALUES ('cash_disable_spam_num',10);
+++ Error: Duplicate entry 'cash_disable_spam_num' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_disable_spam_time',24);
+++ Error: Duplicate entry 'cash_disable_spam_time' for key 1
INSERT INTO phpbb2_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 phpbb2_config (config_name, config_value) VALUES ('cash_installed','yes');
+++ Error: Duplicate entry 'cash_installed' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_version','2.2.1');
+++ Error: Duplicate entry 'cash_version' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('points_name','Points');
+++ Error: Duplicate entry 'points_name' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_adminnavbar','1');
+++ Error: Duplicate entry 'cash_adminnavbar' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_adminbig','0');
+++ Error: Duplicate entry 'cash_adminbig' for key 1
\r
CREATE TABLE phpbb2_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 'phpbb2_cash' already exists
CREATE TABLE phpbb2_cash_events (
event_name varchar(32) NOT NULL default ' ',
event_data varchar(255) NOT NULL default ' ',
PRIMARY KEY (event_name)
);
+++ Error: Table 'phpbb2_cash_events' already exists
CREATE TABLE phpbb2_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 'phpbb2_cash_exchange' already exists
CREATE TABLE phpbb2_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 'phpbb2_cash_groups' already exists
CREATE TABLE phpbb2_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 'phpbb2_cash_log' already exists
?>[/php]
我執行SQL_INSTALL.PHP時出現這個
[php]<?php
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_disable',0);
+++ Error: Duplicate entry 'cash_disable' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_display_after_posts',1);
+++ Error: Duplicate entry 'cash_display_after_posts' for key 1
INSERT INTO phpbb2_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 phpbb2_config (config_name, config_value) VALUES ('cash_disable_spam_num',10);
+++ Error: Duplicate entry 'cash_disable_spam_num' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_disable_spam_time',24);
+++ Error: Duplicate entry 'cash_disable_spam_time' for key 1
INSERT INTO phpbb2_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 phpbb2_config (config_name, config_value) VALUES ('cash_installed','yes');
+++ Error: Duplicate entry 'cash_installed' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_version','2.2.1');
+++ Error: Duplicate entry 'cash_version' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('points_name','Points');
+++ Error: Duplicate entry 'points_name' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_adminnavbar','1');
+++ Error: Duplicate entry 'cash_adminnavbar' for key 1
INSERT INTO phpbb2_config (config_name, config_value) VALUES ('cash_adminbig','0');
+++ Error: Duplicate entry 'cash_adminbig' for key 1
\r
CREATE TABLE phpbb2_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 'phpbb2_cash' already exists
CREATE TABLE phpbb2_cash_events (
event_name varchar(32) NOT NULL default ' ',
event_data varchar(255) NOT NULL default ' ',
PRIMARY KEY (event_name)
);
+++ Error: Table 'phpbb2_cash_events' already exists
CREATE TABLE phpbb2_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 'phpbb2_cash_exchange' already exists
CREATE TABLE phpbb2_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 'phpbb2_cash_groups' already exists
CREATE TABLE phpbb2_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 'phpbb2_cash_log' already exists
?>[/php]
Re: [問題]......
You can add神幻 寫:.....可是ALTER TABLE phpbb_users ADD user_money int(11) unsigned NOT NULL default '0';
這個語法不是本身就已經包含了對phpbb_users新增user_money的命令了嗎?
那為什麼還會...
代碼: 選擇全部
ALTER TABLE phpbb_users ADD user_money int(11) unsigned NOT NULL default '0';
try try