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 |
|