| Author |
 Topic  |
|
nsenff
Starting Member
4 Posts |
 Posted - 06 May 2001 : 21:34:00
|
When I try to run the dbs file I get the following error msg
2147217900 | Syntax error in field definition.
AND
-2147217900 | Syntax error in ALTER TABLE statement.
any idea whats up?
Edited by - nsenff on 07 May 2001 00:06:21 |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 07 May 2001 : 02:12:25
|
are you using the mod_dbsetup.asp file that came with this MOD?
Are you using the strConnString in config.asp that is labeled for use with Access97 or Access2000.
If you're using the one labeled for Access97, try on of the ones labeled for Access2000.
Even if you are using an Access97 database, you can use the strConnString labeled for use with Access2000. |
|
|
|
jburris
Starting Member
40 Posts |
Posted - 07 May 2001 : 16:29:44
|
When I try and send a msg I get this error msg where the submit button should be:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'fYN'
/forums/inc_functions.asp, line 128
the forum is at http://www.wayward4.com/forums
I ran the mod setup asp file and it created its stuff without a problem I'm using the access 2k connection string but the db is still access 97 is this a problem I think i read in ur readme that it was not.
pls help I would love to add this to my board.
Edited by - jburris on 08 May 2001 13:50:01 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 May 2001 : 19:14:24
|
I just registered on your forum and was able to send a Private Message with no problems.
One thing I noticed is when I went to the Preferences screen, the top 2 options didn't have either of the selections selected.
You might look at your database and make sure that the 2 data fields that were added to the FORUM_MEMBERS table have default values set. It doesn't look like they do. |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 08 May 2001 : 22:15:33
|
I had this SAME EXACT error and found that the Signature checkbox was causing the problem, I simply removed the checkbox/signature feature and the problem disappeared. Funny thing is that I had no problem on localhost, but when I uploaded it to my server, error came up consistently.
Dayve |
|
|
|
jburris
Starting Member
40 Posts |
Posted - 09 May 2001 : 09:54:31
|
yeah after reading this thread I did what dayve said he had to do to get it working and it does work.. any idea why we had to cut that line out of the code to get it going?
|
|
|
|
Ribkick
Junior Member
USA
296 Posts |
|
|
fido
Starting Member
30 Posts |
Posted - 17 May 2001 : 13:40:22
|
Have all the "Minor Fixes" posted throughout this 7 page thread been integrated into the download? I'm wanting to download and try it out, but it sounds like quite a bit of "fixing up" is necessary after you install it....
Fido@littlewhitedog.com
http://www.littlewhitedog.com/forum/
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 May 2001 : 17:27:24
|
| You should be able to use it as is. |
|
|
|
fido
Starting Member
30 Posts |
Posted - 17 May 2001 : 20:07:58
|
quote:
You should be able to use it as is.
Thank you sir! I took the plunge and everything worked perfect! I have one more question. I would like to have the ability to use the "Multiple Recipients" feature... if I add that mod on top of this mod will it break this one?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 May 2001 : 20:19:38
|
| No, it shouldn't break this, it's an Add-On to this MOD. |
|
|
|
thirdwatch430
Starting Member
6 Posts |
Posted - 27 May 2001 : 09:07:12
|
When I try to use this mod I get an error on the default page saying there is no Forum_PM
I ran the mod setup and got a syntax error when it tries to setup Forum_PM ... please help!!!!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 15:55:05
|
| We need to know the exact error you received to be able to help you. |
|
|
|
thirdwatch430
Starting Member
6 Posts |
Posted - 27 May 2001 : 19:53:53
|
Here is the exact error in the mod_dbsetup.asp page...
Creating table(s)...
CREATE TABLE FORUM_PM( , 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 DEFAULT 0, M_MAIL varchar (50) NULL , M_OUTBOX byte NULL DEFAULT 1)
-2147217900 | Syntax error in field definition.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 May 2001 : 13:55:59
|
| In your config.asp make sure you are using the strConnString that is labeled for use with Access 2000. The one that is labeled for use with Access 97 does not support using DEFAULT in the SQL statements. |
|
|
|
Topic |
|
Topic Locked
