Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
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 Previous Topic Topic Next Topic  

Reloadmaster
Starting Member

32 Posts

Posted - 13 July 2001 :  15:34:58  Show Profile  Visit Reloadmaster's Homepage  Send Reloadmaster an ICQ Message
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  Show Profile
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]
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07