| Author |
 Topic  |
|
|
guyb
Starting Member
USA
20 Posts |
 Posted - 19 May 2003 : 00:21:49
|
I got this message when trying to update the database for Active Users 4.0 (Active Users 40_17.zip). I already have a Poll MOD installed.
The Active Users MOD seems to work well, but it also seems to be interfering with new users registering.
I'll admit to not being too database-friendly, since I'm a Mac guy. Any help would be appreciated.
e-mail is guyb@motodrive.com.
Active Users 4.0 for Snitz 3.4 compatable
Dropping Table..
Table does not exist
Dropping Table..
Table dropped succesfully
Creating table(s)...
CREATE TABLE FORUM_ACTIVE_USERS( MEMBER_ID int NULL , AU_IP varchar(40) NULL , AU_LOGINTIME varchar(100) NULL , AU_LASTACTIVETIME varchar(100) NULL , AU_LASTPAGE varchar(250) NULL , AU_QUERYSTRING text NULL , AU_USER_AGENT text NULL )
Table created succesfully
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
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AUHIDE varchar(1) NULL
Column already exists
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. |
Edited by - guyb on 19 May 2003 00:26:09 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 19 May 2003 : 04:40:59
|
The errors you mention are normal if one tries to update the database multiple times. If you did try to update the database multiple times, you might have some duplicate info in the forum_config_new table. What database are you using?
Do you know the error msg that new users get when they try to register to your forum? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
 |
|
|
hellind
Junior Member
Singapore
123 Posts |
Posted - 23 May 2003 : 14:42:28
|
I am also getting the same error.
--->
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.
<-----
I was using 3.3.03 Davio_Package_Forum, uprgaded to 3.4.03 Snitz. Then installed Daviod_Poll_Mod. All is working error-less. Then I installs this mod, upgrade and this error. |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 23 May 2003 : 15:48:55
|
Check the database and see if you have all the necessary entries in the config_new table, and make sure that you don't have multiple entries.
As it may be, the error you recieved was because of some hiccup when you ran the dbs-file. If so then you are set to continue adding the mod. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
hellind
Junior Member
Singapore
123 Posts |
Posted - 23 May 2003 : 16:08:13
|
I am not sure but it seems it tries to insert twice the following table 'strAURecordDate'
It gives error the second time.
I checked the db and it has only only instance of the field 'strAURecordDate'.
So presume everything is working. |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 23 May 2003 : 16:12:10
|
| If that is the case, hellind, you don't have to worry about that error. Continue add the mod and if you recieve any further problems, let me know and I'll help you. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
| |
Topic |
|
|
|
Topic Locked
