Error -> Updating the database
Verfasst: 17.10.2005 21:08
Nach der Datei-Installation von Absent User MOD Version:1.1.7 habe ich folgende Befehle in der SQL Datenbank ausgeführt, danach habe ich die Install-Datei im Browser aufgerufen:
ALTER TABLE phpbb_users ADD user_absence TINYINT ( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_absence_mode MEDIUMINT ( 8 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_absence_text TEXT NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('users_allow_absence', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_able_sent_absent', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('absent_button', 1);
Folgendes wurde mir nach der Browser Installation angezeigt:
Updating the database
ALTER TABLE phpbb_users ADD user_absence TINYINT ( 1 ) DEFAULT '0' NOT NULL+++ Error: Duplicate column name 'user_absence'
ALTER TABLE phpbb_users ADD user_absence_mode MEDIUMINT ( 8 ) DEFAULT '0' NOT NULL+++ Error: Duplicate column name 'user_absence_mode'
ALTER TABLE phpbb_users ADD user_absence_text TEXT NOT NULL+++ Error: Duplicate column name 'user_absence_text'
INSERT INTO phpbb_config (config_name, config_value) VALUES ('users_allow_absence', 0)+++ Error: Duplicate entry 'users_allow_absence' for key 1
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_able_sent_absent', 0)+++ Error: Duplicate entry 'mod_able_sent_absent' for key 1
INSERT INTO phpbb_config (config_name, config_value) VALUES ('absent_button', 1)+++ Error: Duplicate entry 'absent_button' for key 1
Weiß jemand was das genau bedeutet?
Grüsse
ALTER TABLE phpbb_users ADD user_absence TINYINT ( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_absence_mode MEDIUMINT ( 8 ) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_absence_text TEXT NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('users_allow_absence', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_able_sent_absent', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('absent_button', 1);
Folgendes wurde mir nach der Browser Installation angezeigt:
Updating the database
ALTER TABLE phpbb_users ADD user_absence TINYINT ( 1 ) DEFAULT '0' NOT NULL+++ Error: Duplicate column name 'user_absence'
ALTER TABLE phpbb_users ADD user_absence_mode MEDIUMINT ( 8 ) DEFAULT '0' NOT NULL+++ Error: Duplicate column name 'user_absence_mode'
ALTER TABLE phpbb_users ADD user_absence_text TEXT NOT NULL+++ Error: Duplicate column name 'user_absence_text'
INSERT INTO phpbb_config (config_name, config_value) VALUES ('users_allow_absence', 0)+++ Error: Duplicate entry 'users_allow_absence' for key 1
INSERT INTO phpbb_config (config_name, config_value) VALUES ('mod_able_sent_absent', 0)+++ Error: Duplicate entry 'mod_able_sent_absent' for key 1
INSERT INTO phpbb_config (config_name, config_value) VALUES ('absent_button', 1)+++ Error: Duplicate entry 'absent_button' for key 1
Weiß jemand was das genau bedeutet?
Grüsse