|
BJORN
Junior Member
149 Posts |
 Posted - 05 May 2002 : 07:42:40
|
Hi there,
I'am trying to install the Email Validation Mod but get the following error using the dbs file.
Email Validation Mod
Adding Column M_KEY...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_KEY text(16) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_KEY' already exists in table 'FORUM_MEMBERS'.
Adding Column M_NEWEMAIL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_NEWEMAIL text(50) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_NEWEMAIL' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STREMAILVAL','0')
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] 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.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_MEMBERS_PENDING( MEMBER_ID int IDENTITY (1, 1) NOT NULL , M_STATUS smallint NULL DEFAULT 0, M_NAME varchar(75) NULL , M_USERNAME varchar(150) NULL , M_PASSWORD varchar(25) NULL , M_EMAIL varchar(50) NULL , M_COUNTRY varchar(50) NULL , M_HOMEPAGE varchar(50) NULL , M_SIG varchar(255) NULL , M_DEFAULT_VIEW int NULL DEFAULT 1, M_LEVEL smallint NULL DEFAULT 1, M_AIM varchar(150) NULL , M_ICQ varchar(150) NULL , M_YAHOO varchar(150) NULL , M_POSTS int NULL DEFAULT 0, M_DATE varchar(50) NULL , M_LASTHEREDATE varchar(50) NULL , M_LASTPOSTDATE varchar(50) NULL , M_TITLE varchar(50) NULL , M_SUBSCRIPTION smallint NULL DEFAULT 0, M_HIDE_EMAIL smallint NULL DEFAULT 0, M_RECEIVE_EMAIL smallint NULL DEFAULT 0, M_LAST_IP varchar(50) NULL DEFAULT '000.000.000.000', M_IP varchar(50) NULL DEFAULT '000.000.000.000', M_FIRSTNAME varchar(100) NULL , M_LASTNAME varchar(100) NULL , M_OCCUPATION varchar(255) NULL , M_SEX varchar(50) NULL , M_AGE varchar(10) NULL , M_HOBBIES memo NULL , M_LNEWS memo NULL , M_QUOTE memo NULL , M_BIO memo NULL , M_MARSTATUS varchar(100) NULL , M_LINK1 varchar(255) NULL , M_LINK2 varchar(255) NULL , M_CITY varchar(100) NULL , M_STATE varchar(100) NULL , M_PHOTO_URL varchar(255) NULL , M_KEY varchar(16) NULL , M_NEWEMAIL varchar(50) NULL )
Table already exists
--------------------------------------------------------------------------------
Unable to remove dbs file
Permission denied
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums
-----------
This is the config.asp connection to db and the DB is 2000 format:
strDBType = "access"
'## Make sure to uncomment one of the strConnString lines!
strConnString = "hekkenbeta"
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
-----------
Can someone help me out, because the tables are not in the db but email password mod is still on, (how to uninstall this if neccesary) ?
Bjorn | Hekkenberg.nl
URL:
http://www.hekkenberg.nl |
|
Topic Locked
