Snitz Forums 2000 - Private Messege fault

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Private Messege fault

New Topic

Topic Locked

Printer Friendly

Author

Topic

Reloadmaster
Starting Member

32 Posts

Posted - 13 July 2001 : 15:34:58

This is the errors:

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;text;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;byte;NULL;1 NOT NULL )
-2147217900 | Syntax error in field definition.

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

Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | Syntax error in ALTER TABLE statement.
Table(s) updated

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

Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | Syntax error in ALTER TABLE statement.
Table(s) updated

I love this forum!!!

<---««« That's me!

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 13 July 2001 : 16:09:19

looks like you are using a newer version of mod_dbsetup.asp than they one that came with the Private Messages MOD.

Open up the privatemessages.dbs file that you are using and replace everything in that file with the following:

Private Messages Mod (Default)
[CREATE]
PM
M_ID
M_SUBJECT#varchar (50)#NULL#
M_FROM#int#NULL#
M_TO#int#NULL#
M_SENT#varchar (50)#NULL#
M_MESSAGE#text#NULL#
M_PMCOUNT#varchar (50)#NULL#
M_READ#int#NULL#0
M_MAIL#varchar (50)#NULL#
M_OUTBOX#smallint#NULL#1
[END]
[ALTER]
MEMBERS
ADD#M_PMEMAIL#int#NULL#0
[END]
[ALTER]
MEMBERS
ADD#M_PMRECEIVE#int#NULL#1
[END]

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.3 seconds.