| Author |
 Topic  |
|
|
HarlekinWF
New Member
Germany
77 Posts |
 Posted - 26 April 2002 : 14:54:25
|
have problems with
Private Messages MOD for Snitz Forums 2000 v3.3.03
http://kinser.121hosts.net/link-it/default.asp?catid=1&cattitle=NewMODSforv3.3.03
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_PM'. Make sure it exists and that its name is spelled correctly.
/privatemess.asp, line 54
the mod was icluded in the forum mit inc. mods.
when i try to install agin the mod
this messages comes:
Private Messages Mod (Default)
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) NOT NULL , M_SUBJECT text (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT text (50) NULL , M_MESSAGE memo NULL , M_PMCOUNT text (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL text (50) NULL , M_OUTBOX smallint NULL DEFAULT 1)
Table already exists
--------------------------------------------------------------------------------
Adding Column M_PMEMAIL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMEMAIL int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
--------------------------------------------------------------------------------
Adding Column M_PMRECEIVE...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMRECEIVE int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 26 April 2002 : 15:40:53
|
| which strConnString are you using in your config.asp file? |
 |
|
|
HarlekinWF
New Member
Germany
77 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 26 April 2002 : 17:08:22
|
The private Messages MOD should have come with 2 dbs files.
When you goto MOD Setup try choosing this one in the dropdown box instead:
Private Messages Mod for Access97 Connectstring |
|
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 26 April 2002 : 17:30:55
|
same :
Private Messages Mod for Access97 Connectstring
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) NOT NULL , M_SUBJECT text (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT text (50) NULL , M_MESSAGE memo NULL , M_PMCOUNT text (50) NULL , M_READ int NULL , M_MAIL text (50) NULL , M_OUTBOX smallint NULL )
Table already exists
--------------------------------------------------------------------------------
Adding Column M_PMEMAIL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMEMAIL int NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_PMEMAIL' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
Adding Column M_PMRECEIVE...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMRECEIVE int NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_PMRECEIVE' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 26 April 2002 : 17:42:22
|
| That just means that those items are already in the database, you shouldn't need to run the setup again. Do you still get the error that the FORUM_PM table doesn't exist? |
|
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 26 April 2002 : 18:34:06
|
yes, still error
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_PM'. Make sure it exists and that its name is spelled correctly.
/privatemess.asp, line 54
and i have also this problem (think its sticky topic)
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/forum.asp, line 253
u can watch errors in forum in link
must the FORUM_PM be entered in database?
i downloaded it and watch but only
FORUM_A_REPLY
FORUM_A_TOPICS
...
FORUM_TOPICS
FORUM_TOTALS
cu
Harlekin
http://forum.killers-in-action.com
mIRC
server : QuakeNet - Random german server
channel: #killers-in-action
Edited by - HarlekinWF on 26 April 2002 18:39:57
Edited by - HarlekinWF on 26 April 2002 18:50:21 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 27 April 2002 : 08:08:47
|
no change
Private Messages Mod for Access97 Connectstring
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , M_SUBJECT text (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT text (50) NULL , M_MESSAGE memo NULL , M_PMCOUNT text (50) NULL , M_READ int NULL , M_MAIL text (50) NULL , M_OUTBOX smallint NULL )
Table already exists
--------------------------------------------------------------------------------
Adding Column M_PMEMAIL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMEMAIL int NULL
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMEMAIL int NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_PMEMAIL' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
Adding Column M_PMRECEIVE...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMRECEIVE int NULL
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMRECEIVE int NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_PMRECEIVE' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
cu
Harlekin
http://forum.killers-in-action.com
mIRC
server : QuakeNet - Random german server
channel: #killers-in-action
Edited by - HarlekinWF on 27 April 2002 09:05:58 |
|
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 27 April 2002 : 12:26:15
|
i fixed it...
i edit the database and add the lines in which where missing.
that was the problem..
cu
Harlekin
http://forum.killers-in-action.com
mIRC
server : QuakeNet - Random german server
channel: #killers-in-action |
|
|
| |
Topic |
|
Topic Locked
