| Author |
 Topic  |
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
 Posted - 12 May 2001 : 19:01:37
|
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
|
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.
|
 |
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 12 May 2001 : 19:24:20
|
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. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 12 May 2001 : 19:27:50
|
if you sent me the setup file you used, I can tell you what is causing the syntax error and what it may affect
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 12 May 2001 : 19:49:00
|
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
|
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 12 May 2001 : 20:06:45
|
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. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 May 2001 : 04:15:05
|
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
|
|
|
|
Azaniah
Senior Member
United Kingdom
1004 Posts |
Posted - 14 May 2001 : 10:18:53
|
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. |
|
|
|
trakfast11
Starting Member
32 Posts |
Posted - 13 June 2001 : 02:04:33
|
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
|
|
|
| |
Topic |
|
Topic Locked
