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
 New Member PM Mod
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Azaniah
Senior Member

United Kingdom
1004 Posts

Posted - 12 May 2001 :  19:01:37  Show Profile  Visit Azaniah's Homepage
Quick question,

Did the setup for this ever get fixed? I noticed that when I installed I got the following...

-2147217900 | Table 'FORUM_USERFILES' already exists.
-2147217900 | Table 'FORUM_MODS' already exists.
-2147217887 | Field 'M_ALLOWDOWNLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217887 | Field 'M_ALLOWUPLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.

However it does work. I have checked that the M_VALUE is of type Memo to allow more than 255 characters. All seems fine. So I'm not sure if anything could be potentially wrong.

Any pointers would be great

Thanks Az


-------
Eagles fly!, but weasels don't get sucked into jet engines.

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 12 May 2001 :  19:18:34  Show Profile  Visit HuwR's Homepage
what appears to be your problem, these errors are telling you you all ready have the tables it is trying to create, the syntax error in the alter statement is potentially because you are using the access 97 drivers.

Go to Top of Page

Azaniah
Senior Member

United Kingdom
1004 Posts

Posted - 12 May 2001 :  19:24:20  Show Profile  Visit Azaniah's Homepage
Hmm that's my problem. I don't know if anything is wrong. All appears to be ok. I'm definately using the Access 2000 drivers (run into that one before ).

It was the syntax errors that have thrown me.

I'll work on the assumption that all is ok, till it falls over :)

Thanks for the respone tho'

Az.

-------
Eagles fly!, but weasels don't get sucked into jet engines.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 12 May 2001 :  19:27:50  Show Profile  Visit HuwR's Homepage
if you sent me the setup file you used, I can tell you what is causing the syntax error and what it may affect

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 12 May 2001 :  19:49:00  Show Profile  Visit HuwR's Homepage
it looks ok, all the errors are related, as long as it send a PM when someone registers, and allows you to change the admin stuff, then you should be ok. If not just shout


Go to Top of Page

Azaniah
Senior Member

United Kingdom
1004 Posts

Posted - 12 May 2001 :  20:06:45  Show Profile  Visit Azaniah's Homepage
Okies,

Thanks.

I disovered the reason for my no entries in outbox too I think.

The field FORUM_PM.M_OUTBOX was set as yes/no. Defaulting to a value of -1. In pm_view.asp it's looking for a value of 1. So I changed the field to be Number and defaulted the value to 1. It appears to work.

Not sure if it's the "right" way to fix it. But I'm learning all the time

Thanks Again

Az.

-------
Eagles fly!, but weasels don't get sucked into jet engines.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 May 2001 :  04:15:05  Show Profile  Visit HuwR's Homepage
yes, that's ok the forum should never use Yes/No fields , don't knoew why that one is, must be an older copy maybe

Go to Top of Page

Azaniah
Senior Member

United Kingdom
1004 Posts

Posted - 14 May 2001 :  10:18:53  Show Profile  Visit Azaniah's Homepage
D'oh!

How obvious?? (shakes head - man I'm stooopid).

You would think that when you setup Send New Member PM - you would realise you have to send the PM from an existing member, and not some fictious person that doesn't exist in the DB.

Oh well - we live and learn.


Az



-------
Eagles fly!, but weasels don't get sucked into jet engines.
Go to Top of Page

trakfast11
Starting Member

32 Posts

Posted - 13 June 2001 :  02:04:33  Show Profile
quote:
I disovered the reason for my no entries in outbox too I think.

The field FORUM_PM.M_OUTBOX was set as yes/no. Defaulting to a value of -1. In pm_view.asp it's looking for a value of 1. So I changed the field to be Number and defaulted the value to 1. It appears to work.

Not sure if it's the "right" way to fix it. But I'm learning all the time

Thanks Again

Quick question... what file did you have to edit this in? I'm having ame problems of not being able to see messages sent to new members in the outbox. Thanks

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.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07