| Author |
 Topic  |
|
CityFocusAdmin
Starting Member
2 Posts |
 Posted - 28 May 2001 : 13:56:05
|
I am receiving the same error as above when attempting to run the database setup. We are installing on a Win 2K IIS 5.0 Server, Access 2000 database with Access 2000 connection string (both absolute and relative path have been used). The FAQ mod setup worked without any problem.
The specific error is:
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.
Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | Syntax error in ALTER TABLE statement.
Table(s) updated
Any ideas on what I can do to resolve this issue? |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 May 2001 : 14:39:20
|
Looks like y'all haven't specified a database type.
You need to make sure you uncomment the strDBType = "access" line also.
Also, the .dbs format has changed a few times. It would be best to use the mod_dbsetup.asp file that comes in the .zip file for this MOD. |
|
|
|
CityFocusAdmin
Starting Member
2 Posts |
Posted - 28 May 2001 : 17:23:09
|
I wish it were that easy! The forums work very well already - with no database connectivity problems. The specified database in config.asp is access:
strDBType = "access"
The MOD file used is the one that came in the ZIP file for this MOD. The forum version is the most recent. And... I successfully installed a different MOD with its provided mod_dbsetup.asp file, which successfully made changes to the database.
WHAT AM I MISSING?!
Is there anything in the syntax of the table creation that could be changed to make it less apt to throw a SYNTAX ERROR? The database is ACCESS 2000 with the following connection:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\webdirectory\web\fpdb\forums.mdb;"
As I said though - the forums function without error other than this, so the configuration seems to be ok.
P.S. Thanks to everyone in these forums for being so helpful! |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 May 2001 : 18:11:17
|
As I stated above, the .dbs file format has change a couple of times.
Try the files in this file: http://kinser.121host.net/files/pmsetup.asp
There is a new version of mod_dbsetup.asp and a new version of privatemessages.dbs |
|
|
|
thirdwatch430
Starting Member
6 Posts |
Posted - 28 May 2001 : 20:13:22
|
Thanks!!! That worked 
|
|
|
|
skeletor
Starting Member
18 Posts |
Posted - 28 May 2001 : 21:40:34
|
Hi,
finally got private messages working...i think!
When I go into Preferences and click "Enable private massages" I get this error:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/pm_options.asp, line 56
Also, the wording of that question: "Forum private messages are currently turned OFF .
You may turn it ON below. By doing so you will no longer be able to receive private messages"
Is confusing....by turning *on* private messages you can't get private messages?
Any help is appreciated
|
|
|
|
LordZuave
Starting Member
25 Posts |
Posted - 29 May 2001 : 11:44:03
|
Hey Richard, this is a great mod, but i'm having some problems with it. when i read the messages they come out with the background blue, really hard to read and i have tried changing the values on the admin option of the color table to no aveil.
i tried the link to re-download but it is not working. can you please post the link.
If you have time, you can take a look a my page.
www.wzpr.tv/forum/default.asp
user test1
pass testing1
send urself a message and see if you can read it.
thanks
Nelson R.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 29 May 2001 : 12:15:15
|
| try changing lightgray to lightgrey |
|
|
|
LordZuave
Starting Member
25 Posts |
Posted - 29 May 2001 : 12:33:46
|
what a difference an a can make.
Hey Ricahrd, do you have an idea as to why the author column is so big and the message is on the right side.
thanks Richard
Edited by - lordzuave on 29 May 2001 12:53:07 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 29 May 2001 : 12:55:55
|
| I posted in your thread about Topics not being able to be read... |
|
|
|
fimi
Starting Member
Canada
39 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 June 2001 : 16:33:44
|
| you need to upload the file that ends with .dbs so you can setup the database. |
|
|
|
fimi
Starting Member
Canada
39 Posts |
Posted - 03 June 2001 : 16:39:45
|
quote:
you need to upload the file that ends with .dbs so you can setup the database.
_______________________________________________________________________________
YES I UPLOADED PrivateMessages.dbs AND snitz_forums_2000.mdb
I DON'T KNOW OTHER .dbs files that i can upload
|
|
|
|
fimi
Starting Member
Canada
39 Posts |
Posted - 03 June 2001 : 16:40:06
|
quote:
you need to upload the file that ends with .dbs so you can setup the database.
YES I UPLOADED PrivateMessages.dbs AND snitz_forums_2000.mdb
I DON'T KNOW OTHER .dbs files that i can upload
|
|
|
|
fimi
Starting Member
Canada
39 Posts |
Posted - 03 June 2001 : 16:51:27
|
help me please
|
|
|
|
Topic |
|
Topic Locked
