|
kovan
Junior Member
134 Posts |
 Posted - 08 April 2001 : 20:22:52
|
these are the errors i got
Huw's Forum DB Changes
Creating table(s)...
CREATE TABLE FORUM_SMILE_CAT( CAT_ID int IDENTITY (1, 1) NOT NULL , CAT_NAME;varchar (40);NULL; NOT NULL , [CREATE] NOT NULL , SMILES NOT NULL , ID NOT NULL , SMILE_URL;varchar (40);; NOT NULL , SMILE_CODE;varchar (10);; NOT NULL , SMILE_NAME;varchar (20);; NOT NULL , CAT_ID;int;;1 NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'CAT_NAME' must include a data type.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_USERFILES( F_FILEID int IDENTITY (1, 1) NOT NULL , MEMBER_ID;int;; NOT NULL , F_FILENAME;varchar (255);; NOT NULL , F_FILESIZE;int;NULL; NOT NULL , F_REPLY_ID;int;NULL; NOT NULL , F_TOPIC_ID;int;NULL; NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'MEMBER_ID' must include a data type.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_EMAIL_CONFIG( M_TYPE;varchar (15);NULL; NOT NULL , M_SUBJECT;varchar (100);NULL; NOT NULL , M_MESSAGE;memo;NULL; NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'M_TYPE' must include a data type.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) NOT NULL , M_SUBJECT;varchar (50);NULL; NOT NULL , M_FROM;int;NULL; NOT NULL , M_TO;int;NULL; NOT NULL , M_SENT;varchar (50);NULL; NOT NULL , M_MESSAGE;memo;NULL; NOT NULL , M_PMCOUNT;varchar (50);NULL; NOT NULL , M_READ;int;NULL;0 NOT NULL , M_MAIL;varchar (50);NULL; NOT NULL , M_OUTBOX;smallint;NULL; NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'M_SUBJECT' must include a data type.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_USERFIELDS( USR_FIELD_ID int IDENTITY (1, 1) NOT NULL , USR_LABEL;varchar (40);NULL; NOT NULL , USR_FIELDTYPE;varchar (1);NULL; NOT NULL , USR_SHORTNAME;varchar (10);NOT NULL; NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'USR_LABEL' must include a data type.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_MEMBERFIELDS( MEMBER_ID;int;NOT NULL; NOT NULL , USR_FIELD_ID;smallint;NOT NULL NOT NULL , USR_VALUE;varchar (50);NULL NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'MEMBER_ID' must include a data type.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ONLINE( UserID;varchar (100);; NOT NULL , UserIP;varchar (40);; NOT NULL , LastChecked;varchar (100);; NOT NULL , DateCreated;varchar (100);; NOT NULL , CheckedIn;varchar (100);; NOT NULL , M_BROWSE;varchar (255);; NOT NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The definition for column 'UserID' must include a data type.
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_MEMBERS'.
Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_MEMBERS'.
Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_MEMBERS'.
Table(s) updated
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_FORUM
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_FORUM'.
Dropping Column...
ALTER TABLE FORUM_FORUM
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_FORUM'.
Dropping Column...
ALTER TABLE FORUM_FORUM
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_FORUM'.
Table(s) updated
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_CONFIG
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_CONFIG'.
Table(s) updated
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_CATEGORY
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_CATEGORY'.
Table(s) updated
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
INSERT INTO FORUM_MODS
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_MODS'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
INSERT INTO FORUM_SMILES
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FORUM_SMILES'.
--------------------------------------------------------------------------------
Updating Forum Values..
UPDATE FORUM_FORUM SET F_HIDDEN;1;F_PRIVATEFORUMS IN (5,6,8) = WHERE
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ';'.
--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
Snitz Forums
|
|
Topic Locked
