|
bcooper
Starting Member
34 Posts |
 Posted - 20 June 2001 : 13:21:28
|
When I run the forum administration mod on the 3.3beta, i get this error:
Creating table(s)...
CREATE TABLE FORUM_A_TOPICS( TOPIC_ID#INT#NULL# int IDENTITY (1, 1) NOT NULL , CAT_ID int NULL , T_STATUS int NULL , FORUM_ID int NULL , T_MAIL int NULL , T_SUBJECT text (50) NULL , T_MESSAGE memo NULL , T_AUTHOR int NULL , T_REPLIES int NULL , T_VIEW_COUNT int NULL , T_LAST_POST varchar(20) NULL , T_DATE varchar(20) NULL , T_LAST_POSTER int NULL , T_IP varchar(20) NULL , T_LAST_POST_AUTHOR int NULL )
-2147217900 | Syntax error in field definition.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_A_REPLY( CAT_ID#INT#NULL# int IDENTITY (1, 1) NOT NULL , FORUM_ID int NULL , TOPIC_ID int NULL , REPLY_ID int NULL , R_AUTHOR int NULL , R_MESSAGE memo NULL , R_DATE varchar(20) NULL , R_IP varchar(20) NULL , R_MAIL int NULL )
-2147217900 | Syntax error in field definition.
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_FORUM DROP COLUMN L_ARCHIVE
-2147217900 | There is no field named 'L_ARCHIVE' in table 'FORUM_FORUM'.
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_L_ARCHIVE text(20) NULL
Column added successfully
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_ARCHIVE_SCHED int NULL DEFAULT 30
Column added successfully
Populating Current Records with new Default value
UPDATE FORUM_FORUM SET F_ARCHIVE_SCHED=30
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_L_DELETE text(20) NULL
Column added successfully
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_DELETE_SCHED int NULL DEFAULT 365
Column added successfully
Populating Current Records with new Default value
UPDATE FORUM_FORUM SET F_DELETE_SCHED=365
Table(s) updated
any reasons why?any help would be appreciated
|
|
Topic Locked
