| Author |
 Topic  |
|
jwilkens
New Member
65 Posts |
 Posted - 27 October 2000 : 15:56:50
|
Thanks!
|
 |
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 28 October 2000 : 18:05:50
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Oh, the rsName mismatch only seems to happen when you reply to a message.Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'rsName'
/forums/privatesend_info.asp, line 278
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Here you go. Try this
http://www.thepercussionist.com/adf/privatesend_info.txt
Scott LeMieux
I am redoing everything to get up to date! Found one more problem with this.
In FORUM_PM M_OUTBOX needs to be set to BYTE default = 1.
Edited by - slemieux on 28 October 2000 18:15:25 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 October 2000 : 18:20:20
|
Scott,
In the privatesend_info.asp,
<pre id=code><font face=courier size=2 id=code><!--#INCLUDE FILE="inc_mail.asp" --></font id=code></pre id=code>
needs to be moved above the <b>end if</b> |
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 28 October 2000 : 18:30:53
|
Thanks!!
It's fixed in the above link <img src=icon_smile.gif border=0 align=middle>
Scott LeMieux |
|
|
|
gmcm
Starting Member
South Africa
34 Posts |
Posted - 11 November 2000 : 11:56:37
|
Wowa....... this is alll fantastic....but for somebody who has just unstalled the latest Forum...and added MOD Commander....
where would you START !!
This thread has so many changes that it is totally confusing. So lets recap - newbie's like me
Step1.... install great Snitz forum
Step 2.... ???? download?????
Step 3..... Run.add.delete ????
Please bro's - i need this mod...I just switched my old and very very very used Ultraboard 1.62 OFF to go on this, and i want to stay with this
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
gmcm
Starting Member
South Africa
34 Posts |
Posted - 11 November 2000 : 13:56:17
|
thanks for the speedy response
i ran the dbsetup file and get this
CREATE TABLE FORUM_PM (M_ID integer IDENTITY (1, 1) NOT NULL , M_SUBJECT nvarchar (50) NULL , M_FROM integer NULL , M_TO integer NULL , M_SENT nvarchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT nvarchar (50) NULL , M_READ integer NULL DEFAULT 0 , M_MAIL nvarchar (50) NULL , M_OUTBOX smallint NULL )
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
/forums/pmdbsetup.asp, line 62
My server is an IIS box in the states using a DNSless connection Access97
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 November 2000 : 18:51:24
|
| Do you have the latest JET drivers on that PC? If so, change your connection string in <b>config.asp</b> to the one for Access 2000. |
|
|
|
gmcm
Starting Member
South Africa
34 Posts |
Posted - 11 November 2000 : 21:04:55
|
Hi Richard
OK i tried the Jet 4 drivers....no go...also tried converting the dbase to Access 2000 and still no go
Guess that particular machine is still running old versions of FP extensions, i have asked them to upgrade it but after 3 months have given up
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Do you have the latest JET drivers on that PC? If so, change your connection string in <b>config.asp</b> to the one for Access 2000.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 November 2000 : 21:23:40
|
You can manually add the fields to the database. Just use the values in the pmdbsetup.asp as a guide.
Or I can add the fields for you.
You can e-mail at: richard_kinser@yahoo.com
I only have access to Access97 right now, so the database will have to be access97.
Or, you can download this file: http://www1.domaindlx.com/dssdbs/files/beta.zip
and use the <b>snitz_forums_2000.mdb</b> file out of it. It already has the database fields in it.
Edited by - Richard Kinser on 11 November 2000 21:27:33 |
|
|
|
Frodoger
Starting Member
Germany
42 Posts |
Posted - 17 November 2000 : 11:56:37
|
i have updated my forum whith the pm_mod.zip and i get the following error message when i open the default.asp:
Microsoft VBScript runtime error '800a01a8'
Object required: 'my_Conn'
/forum2/privatemess.asp, line 50
i have a sql 7 db, and the creating of the new table works very fine.
what can i do to fix the error ?
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> or v3sr2 download this file:
http://www.thepercussionist.com/adf/private.zip
and this file:
http://209.35.253.8/snitz/forumcode.zip
and this file:
http://www1.domaindlx.com/dssdbs/files/members2.zip
and possibly this file:
http://www.thepercussionist.com/adf/whosonline.zip
All of the modifications that I made were to make it compatible with v3.1 and newer.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
the only one i downloaded is the pm_mod.zip because the forumcode.zip is only for version 3. The lines that must be modified for this zip does not exist in the actual version of the snitz forum.
i think the pivate.zip is an old version of the pm_mod.zip. Or isn't it ?
Edited by - Frodoger on 17 November 2000 12:06:27
Edited by - Frodoger on 17 November 2000 12:07:29 |
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 17 November 2000 : 12:06:13
|
where have you uesed the include privatemess.asp ?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
infinity
New Member
New Zealand
90 Posts |
Posted - 22 November 2000 : 22:41:20
|
Hi there.
Will try posting this here...
I have the PM mod installed... and it works fine in most regards as far as my testing has currently covered... except one thing.
If I reply to a message the message is posted okay (as in the person gets it) but this error comes up after sending it...
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'rsName'
/privatesend_info.asp, line 278
Line 278 is:
277- if strEmail = "1" then
278- if rsName("M_PMEMAIL") = "1" then
279- DoReplyEmail Request.Form("sendto")
280- end if
I checked the DB to make sure M_PMEMAIL exists and it does. Its value for all users (only 4 of us) is "0".
Any ideas why this has happened?
Thanks,
Infinity <img src=icon_smile.gif border=0 align=middle>
Life is but a dream... and that dream is Here and Now. Therefore, Be here Now. |
|
|
|
infinity
New Member
New Zealand
90 Posts |
Posted - 22 November 2000 : 22:44:14
|
Also, a quick question..
What is the outbox for? If all msg's go out instantly then when does anything ever end up in the outbox?
Thanks a lot,
Infinity
Life is but a dream... and that dream is Here and Now. Therefore, Be here Now. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 November 2000 : 23:00:02
|
You wouldn't happen to be using MS SQL would you?
The Outbox is more like a Sent Items box I believe. |
|
|
|
Topic |
|
Topic Locked
