Author |
Topic  |
infinity
New Member

New Zealand
90 Posts |
Posted - 22 November 2000 : 23:37:18
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> You wouldn't happen to be using MS SQL would you?
The Outbox is more like a Sent Items box I believe. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hi Richard, Thanks for the help. No, not using SQL. Whole thing on Access.
And the outbox... My first thought was that it must be a sent type box, but nothing I send comes up in there... SO does anyone else reading this who has PM installed get any life out of the Outbox??
Regards, Infinity
Life is but a dream... and that dream is Here and Now. Therefore, Be here Now. |
 |
|
jessica
New Member

USA
58 Posts |
Posted - 27 November 2000 : 07:33:06
|
This is a really nice mod if I can just get it working... I believe I have narrowed it down to the members.asp file. I am getting different errors when trying to login and view topics.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getNewMemberNumber'
/forum/topic.asp, line 62
Line 62 referrs to:
<!--#INCLUDE FILE="inc_footer_short.asp" --> <% Response.End case else '## Do Nothing - Continue end select 62 ->>>> Member_ID = getNewMemberNumber() if (strAuthType = "nt") then set my_Conn = Server.CreateObject("ADODB.Connection") my_Conn.Open strConnString call NTauthenticate() if (ChkAccountReg() = "1") then call NTUser() end if end if
Any help would be wonderful, Thanks
<font size=1><font color=green>Edited by Richard to fix the Display of this page</font id=green></font id=size1>
Edited by - Richard Kinser on 24 January 2001 04:49:50 |
 |
|
jessica
New Member

USA
58 Posts |
Posted - 27 November 2000 : 08:44:02
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> This is a really nice mod if I can just get it working... I believe I have narrowed it down to the members.asp file. I am getting different errors when trying to login and view topics. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Ok, I believe I have fixed this one... (I am still not sure what I have done, but No errors.)
The next question is, I am logged in, but it says I am not. Gosh if I remember correctly this problem was in the whos_online mod.... hmmmm. I don't remember how I fixed that. Well suggestions would be nice, but I will let everyone know where I stand... (OR you can check it out at http://www.webzonecomplete.com (If you sign up and want to be deleted just let me know. But then again you REALLY don't have to go)
Thanks,
|
 |
|
jessica
New Member

USA
58 Posts |
Posted - 27 November 2000 : 09:00:01
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Ok, I believe I have fixed this one... (I am still not sure what I have done, but No errors.)
The next question is, I am logged in, but it says I am not. Gosh if I remember correctly this problem was in the whos_online mod.... hmmmm. I don't remember how I fixed that. Well suggestions would be nice, but I will let everyone know where I stand... (OR you can check it out at http://www.webzonecomplete.com <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Well the Who's Online login has been found and fixed... Although no the PM is not showing me logged in, I am going to re-read this thread and see if I am missing something. Thank every one for this great mod.
|
 |
|
bugzy
Junior Member
 
USA
147 Posts |
Posted - 28 November 2000 : 13:05:54
|
hey jessica
i read through the topic again .. and i cant find the whos.zip file anymore but its on the board somewhere
ill post it up for you to download on my site
http://www.azian.com/stuff/whos.zip
|
 |
|
seven
Senior Member
   
USA
1037 Posts |
Posted - 28 November 2000 : 21:08:40
|
the private message mod works great, except the message text doesn't display. It does get added to the database, and when I hit reply it'll show me the message. IS there an error in the privateread.asp file? |
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 28 November 2000 : 22:38:18
|
airilm, are you using an SQL database? |
 |
|
seven
Senior Member
   
USA
1037 Posts |
Posted - 28 November 2000 : 22:43:06
|
Richard.. yes SQL 7 |
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 28 November 2000 : 23:23:21
|
MS SQL seems to very picky about the order in the SELECT statements.
<b>On line #74 of privateread.asp</b>
<b>Change this:</b>
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " <font color=red>& strTablePrefix & "PM.M_MESSAGE, "</font id=red> & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM "</font id=code></pre id=code></font id=size1>
<b>To This:</b>
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM, " <font color=red>& strTablePrefix & "PM.M_MESSAGE "</font id=red></font id=code></pre id=code></font id=size1>
|
 |
|
Frodoger
Starting Member
Germany
42 Posts |
Posted - 29 November 2000 : 08:14:48
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> where have you uesed the include privatemess.asp ?
'Resistance is futile' <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
1. i have dl the 3sr2. 2. i have build the db on sql server 3. have dl the pm_mod.zip and save it to the forum dir 4. i run the pmdbsetup.asp 5. i changed my default.asp like this:
<pre id=code><font face=courier size=2 id=code> <% else blnHiddenForums = true end if ' ChkDisplayForum() rsForum.MoveNext loop end if rs.MoveNext loop end if %> <!--#include file="privatemess.asp"--> <% if strShowStatistics = "1" then WriteStatistics end if %> </table> </td> </tr> <tr> <td> <table width="100%"> <tr> <td> <font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"> <img alt="New Posts" src="icon_folder_new.gif" width=8 height=9> Contains new posts since last visit.<br> <img alt="Old Posts" src="icon_folder.gif" width=8 height=9> No new posts since the last visit.<br> </font> </td> </tr> </table> </td> </tr> </table>
<% set rs = nothing set rsForum = nothing %> <!--#INCLUDE FILE="inc_footer.asp" --> <% sub PostingOptions() if (mlev = 4) or (lcase(strNoCookies) = "1") then %> <font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"> </font id=code></pre id=code>
6. and this: <pre id=code><font face=courier size=2 id=code> '## Harpswell, ME 04079 '################################################################################# %> <!--#INCLUDE FILE="config.asp" --> <!--#include file="privatemess.asp"--> <!--#INCLUDE FILE="inc_functions.asp" --> <!--#INCLUDE FILE="inc_top.asp" --> <% </font id=code></pre id=code>
Edited by - Frodoger on 29 November 2000 08:16:03 <font size=1><font color=green>Edited by Richard to fix the Display of this page</font id=green></font id=size1>
Edited by - Richard Kinser on 24 January 2001 04:51:27 |
 |
|
seven
Senior Member
   
USA
1037 Posts |
Posted - 29 November 2000 : 19:17:09
|
Thank you so much Richard. You are now my official hero. I can stop pulling my hair out now. Thanks for all your help.
Is there a web site that has compiled all these nifty upgrades into one short concise format. It takes some skill to be able to paste all these rev's together and read through all the different changes. It would be nice to go to one site (or locked forum) for the final product.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> MS SQL seems to very picky about the order in the SELECT statements.
<b>On line #74 of privateread.asp</b>
<b>Change this:</b>
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " <font color=red>& strTablePrefix & "PM.M_MESSAGE, "</font id=red> & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM "</font id=code></pre id=code></font id=size1>
<b>To This:</b>
<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM, " <font color=red>& strTablePrefix & "PM.M_MESSAGE "</font id=red></font id=code></pre id=code></font id=size1>
<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 - 29 November 2000 : 20:13:39
|
Frodoger,
remove the line highlighted in <font color=red>red</font id=red>.
<pre id=code><font face=courier size=2 id=code><font size=1>'## Harpswell, ME 04079 '################################################################################# %> <!--#INCLUDE FILE="config.asp" --> <font color=red><!--#include file="privatemess.asp"--></font id=red> <!--#INCLUDE FILE="inc_functions.asp" --> <!--#INCLUDE FILE="inc_top.asp" --> <%</font id=size1></font id=code></pre id=code>
Edited by - Richard Kinser on 24 January 2001 04:51:50 |
 |
|
Nam
Starting Member
36 Posts |
Posted - 04 December 2000 : 23:58:17
|
I'm confused ????????????
So many files out there, which one should I download? Richard, you gave 4 links on page 2 about members2, forumcosd, private... on page 3, you also gave pm_mod.zip, so which one should I download? I already have whoisonline working, I really like private message function on my page. Thanks
|
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
|
Nam
Starting Member
36 Posts |
Posted - 05 December 2000 : 00:55:12
|
I got this error while running private message setup file pmdbsetup.asp:
<b>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 )
ADODB.Connection.1 error '80004005'
Syntax error in CREATE TABLE statement.
/forum/pmdbsetup.asp, line 62 </b> please help
|
 |
|
Topic  |
|