quote:

---

Adding Column...
ALTER TABLE FORUM_GUESTBOOK ADD COLUMN G_VARFIELD1 VARCHAR (100) NULL
-2147217887 | Field 'G_VARFIELD1' already exists in table 'FORUM_GUESTBOOK'.
Adding Column...
ALTER TABLE FORUM_GUESTBOOK ADD COLUMN G_VARFIELD2 VARCHAR (100) NULL
-2147217887 | Field 'G_VARFIELD2' already exists in table 'FORUM_GUESTBOOK'.
Adding Column...
ALTER TABLE FORUM_GUESTBOOK ADD COLUMN G_VARFIELD3 VARCHAR (100) NULL
-2147217887 | Field 'G_VARFIELD3' already exists in table 'FORUM_GUESTBOOK'.
Table(s) updated

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int IDENTITY (1, 1) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL , G_V1_SWITCH INT NOT NULL , G_V2_SWITCH INT NOT NULL , G_V3_SWITCH INT NOT NULL )
-2147217900 | Table 'FORUM_GB_OPTIONS' already exists.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_VARFIELD1, G_VARFIELD2, G_VARFIELD3) VALUES (0, 0, 0, 'ab', 'ab', 'ab')
-2147217900 | The INSERT INTO statement contains the following unknown field name: 'G_VARFIELD2'. Make sure you have typed the name correctly, and try the operation again.


that's the error I got. What's wrong? I'm not confuse with the first 3 but the forth one is a definite error. I ran it twice, that's why I got that "already exist" message.

---

quote:

---

Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , G_NAME#VARCHAR (50)#NOT NULL# NOT NULL , G_EMAIL#VARCHAR (100)#NOT NULL# NOT NULL , G_WEBSITE#VARCHAR (100)#NULL# NOT NULL , G_ICQ#VARCHAR (30)#NULL# NOT NULL , G_MESSAGE#memo#NOT NULL# NOT NULL , G_DATE#VARCHAR (50)#NOT NULL# NOT NULL , G_VARFIELD1#VARCHAR (100)#NULL# NOT NULL , G_VARFIELD2#VARCHAR (100)#NULL# NOT NULL , G_VARFIELD3#VARCHAR (100)#NULL# NOT NULL )
-2147217900 | Syntax error in field definition.
CREATE TABLE FORUM_GB_OPTIONS( G_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , G_VARFIELD1#VARCHAR (100)#NULL# NOT NULL , G_VARFILED2#VARCHAR (100)#NULL# NOT NULL , G_VARFIELD3#VARCHAR (100)#NULL# NOT NULL , G_V1_SWITCH#INT#NOT NULL# NOT NULL , G_V2_SWITCH#INT#NOT NULL# NOT NULL , G_V3_SWITCH#INT#NOT NULL# NOT NULL , G_V3_SWITCH#INT#NOT NULL# NOT NULL , G_V3_SWITCH#INT#NOT NULL# NOT NULL , G_V3_SWITCH#INT#NOT NULL# NOT NULL )
-2147217900 | Syntax error in field definition.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_GB_OPTIONS
-2147217900 | Syntax error in INSERT INTO statement.

--------------------------------------------------------------------------------

I get this error when I run the mod_dbsetup.asp. Any idea whats causing this? I'm using Version 3.1 SR4

---