| Author |
 Topic  |
|
Adul
Starting Member
37 Posts |
 Posted - 14 August 2001 : 18:35:36
|
I got it working with version 3.3 now. I am going through the code slowly reorganizing it has I go and cleaning some stuff out. I am going to try and see if I can get the ignore feature working.
|
 |
|
|
TheMarkel
Starting Member
USA
14 Posts |
Posted - 15 August 2001 : 00:08:33
|
I'm running 3.3.02 and my pmcount isn't returning anything except 0.
Does anyone else notice this same problem? Nothing seems to register as a new message.
Any help would be appreciated.
PlanetMarkel Forums
'move every 'sig.''
--markel |
|
|
|
dG
Starting Member
6 Posts |
Posted - 15 August 2001 : 18:06:21
|
Ok, I'm having real trouble with this thing.
Could anybody possibly give me a detailed step-by-step guide as to setting it up? It would be greatly appriciated.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 August 2001 : 19:01:29
|
dG,
Can you post the URL to your forum? |
|
|
|
asp_storm
Average Member
USA
787 Posts |
Posted - 18 August 2001 : 13:24:14
|
i got this error when i ran mod_dbsetup.asp
quote:
Private Messages Mod (Default)
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , M_SUBJECT text (50) 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 byte NULL DEFAULT 1)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding Column...
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...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMRECEIVE int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
¦_____________Creator___Of___________¦
[------------Newschoolskiing.com------------]
|
|
|
|
FeDe
New Member
62 Posts |
Posted - 19 August 2001 : 00:22:18
|
it's always showing this message!! please help!!
Microsoft JET Database Engine error '80040e37'
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 50
|
|
|
|
thephantomnl
New Member
Netherlands
66 Posts |
Posted - 19 August 2001 : 11:56:37
|
quote:
I just found a error on my PM Mod... If you turn on to see both in and out boxes at the end of the outbox I get this error.
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/pm_view.asp, line 0
I do have the popup PM mod installed.
quote:
You have an out going PM to a member that has been deleted from your member table.
That will give you the EOF/BOF error.
isn't there a way that if the user wil be deleted the pm' s of the user also wil be deleted?? we have been testing on our forum and if you delete a member then you must edit the database with access 
|
|
|
|
zull
New Member
Malaysia
50 Posts |
Posted - 19 August 2001 : 22:50:35
|
i'm using the latest v3.3,
where do i paste the line <!--#include file="privatemess.asp"--> in the default.asp so that it will appear on top of the forum table *the one that contains Forum, topic, posts, last post and moderator(s)*
thanx in advance...
reversed | back&forth&beyond |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 August 2001 : 09:18:14
|
| zull, try it on line #140 of default.asp |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 August 2001 : 09:19:54
|
| asp_newbie, you are getting that error because you are using one of the strConnString lines in your config.asp that is labeled for use with Access97. Switch to one that is labeled for use with Access2000. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 August 2001 : 09:20:46
|
FeDe,
Sounds like you haven't run the setup for the Database yet, or it didn't complete successfully. |
|
|
|
zull
New Member
Malaysia
50 Posts |
Posted - 21 August 2001 : 02:12:58
|
quote:
zull, try it on line #140 of default.asp
doesn't work richard...
reversed | back&forth&beyond
Edited by - zull on 21 August 2001 02:18:02
Edited by - zull on 21 August 2001 02:31:48 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 21 August 2001 : 20:53:32
|
I believed I did it all correctly, however it didn't work.
I posted the error. No table field. I posted the error when creating the tables. i also posted the config.asp line (because i know you would be saying not to use the access 97 string, richard  which i didn't)
So what do you think the problem is?
Microsoft JET Database Engine error '80040e37'
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.
/forum/pm_view.asp, line 120
*****************************************************************
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) NOT NULL , M_SUBJECT;varchar (50);NULL; NOT NULL , M_FROM;int;NULL; NOT NULL , M_TO;int;NULL; NOT NULL , M_SENT;varchar (50);NULL; NOT NULL , M_MESSAGE;text;NULL; NOT NULL , M_PMCOUNT;varchar (50);NULL; NOT NULL , M_READ;int;NULL;0 NOT NULL , M_MAIL;varchar (50);NULL; NOT NULL , M_OUTBOX;byte;NULL;1 NOT NULL )
-2147217900 | Syntax error in field definition.
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
Dropping Column...
ALTER TABLE FORUM_MEMBERS
-2147217900 | Syntax error in ALTER TABLE statement.
Table(s) updated
*******************************************************************************
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/cgi-bin/2000.mdb") '## MS Access 2000 using virtual path
********************
We all have photographic memories, some just don't have film.
URL added: http://realmslore.dingojunction.com/forum/ -home page
http://realmslore.dingojunction.com/forum/pm_view.asp - error page
Edited by - snaayk on 21 August 2001 20:56:02 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 August 2001 : 20:57:17
|
snaayk,
Could you give me FTP access to your forum? I can login and fix the problem... |
|
|
|
Topic |
|
Topic Locked
