|
funinbc
Junior Member
245 Posts |
 Posted - 26 December 2002 : 15:48:13
|
I have upgraded my forum from 3.3.0x and had active users installed
After the upgrade I added a few mods and tested everything thing ok.
I have started to install Active Users 4.0 on the latest release of snitz.
I up-loaded all the files as instructed and went to update the data base and I get the following errors
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AUHIDE varchar(1) NULL
Column already exists
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
Column altered successfully
next error was :
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANON','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANONOVERRIDE','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPALLOW','4')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPCOLLAPSE','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUALLOW','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUREFRESH','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUIP','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUUA','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAULOCAL','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUTIMEOUT','7')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAURecord','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAURecordDate','11111111111111')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAURecordDate','11111111111111')
-2147467259 | The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
Am I ok to carry on with the mod or do I have to fix the database or somthing
|
|
Topic Locked
