Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 private message error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rorenijan
Starting Member

Sweden
3 Posts

Posted - 14 November 2005 :  11:50:04  Show Profile  Visit Rorenijan's Homepage
Hello!
Yesterday I installed the private message MOD, and it worked! But today I noticed that all the aswers that were writen in the forums was changed to a singel code like this: http://www.sei-kai.com/topic.asp?TOPIC_ID=40

And in the end this error message is diplayed:

Microsoft VBScript runtime error '800a0006'

Overflow: 'cLng'

/inc_func_secure.asp, line 46

At line 46 this message is diplayed:

strSql = strSql & " WHERE MEMBER_ID = " & cLng(fUser_Number)

What should I do to make it work again?
Thanks for all your answers! / Rorenijan

http://www.sei-kai.com

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 14 November 2005 :  12:32:05  Show Profile
Double check the changes you made to topic.asp against the readme,paying close attention to the numbering of the reply array items.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Rorenijan
Starting Member

Sweden
3 Posts

Posted - 14 November 2005 :  13:00:28  Show Profile  Visit Rorenijan's Homepage
Is this what I should check?


rM_NAME = 0
rM_RECEIVE_EMAIL = 1
rM_AIM = 2
rM_ICQ = 3
rM_MSN = 4
rM_YAHOO = 5
rM_PM = 6
rM_TITLE = 7
rMEMBER_ID = 8
rM_HOMEPAGE = 9
rM_LEVEL = 10
rM_POSTS = 11
rM_COUNTRY = 12
rREPLY_ID = 13
rFORUM_ID = 14
rR_AUTHOR = 15
rTOPIC_ID = 16
rR_MESSAGE = 17
rR_LAST_EDIT = 18
rR_LAST_EDITBY = 19
rR_SIG = 20
rR_STATUS = 21
rR_DATE = 22
if CanShowSignature = 1 then
rM_SIG = 23
end if

I checked everything and it seems ok, I can't find anything wrong!
First I rM_YAHOO = 6 and rM_PM = 6 but then I changed it but still nothing happend.

Anything else I can do?

edit: I installed the avatar mod before I installed the pm mod.

http://www.sei-kai.com

Edited by - Rorenijan on 14 November 2005 15:31:52
Go to Top of Page

imweazel
Starting Member

49 Posts

Posted - 14 November 2005 :  15:49:39  Show Profile
I believe what you need to check is your SQL statement against the numbered arrayed fields so that the correct information is put into the correct array field. Taken from my topic.asp the eighth sql column is m.m_pmreceive matches with the array field rM_PM = 7, since the array starts at zero instead of 1. Similarly, check your sql statement so that the information being passed to rMEMBER_ID = 8 is in fact the ninth column of sql statement.

If I'm completely off base here, I'm sure someone more knowledgeable will correct me.

Dave


'## Forum_SQL
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_SKYPE, M.M_YAHOO, M.M_PMRECEIVE"
strSql = strSql & ", M.M_TITLE, M.MEMBER_ID, M.M_HOMEPAGE, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY, M.M_AVATAR_URL, M.M_DATE"
strSql = strSql & ", R.REPLY_ID, R.FORUM_ID, R.R_AUTHOR, R.TOPIC_ID, R.R_MESSAGE, R.R_LAST_EDIT"
strSql = strSql & ", R.R_LAST_EDITBY, R.R_SIG, R.R_STATUS, R.R_DATE"
if CanShowSignature = 1 then
strSql = strSql & ", M.M_SIG"
end if


rM_NAME = 0
rM_RECEIVE_EMAIL = 1
rM_AIM = 2
rM_ICQ = 3
rM_MSN = 4
rM_SKYPE = 5
rM_YAHOO = 6
rM_PM = 7
rM_TITLE = 8
rMEMBER_ID = 9
rM_HOMEPAGE = 10
rM_LEVEL = 11
rM_POSTS = 12
rM_COUNTRY = 13
rM_Avatar = 14
rM_Date = 15
rREPLY_ID = 16
rFORUM_ID = 17
rR_AUTHOR = 18
rTOPIC_ID = 19
rR_MESSAGE = 20
rR_LAST_EDIT = 21
rR_LAST_EDITBY = 22
rR_SIG = 23
rR_STATUS = 24
rR_DATE = 25
if CanShowSignature = 1 then
rM_SIG = 26
end if
Go to Top of Page

Rorenijan
Starting Member

Sweden
3 Posts

Posted - 15 November 2005 :  14:40:12  Show Profile  Visit Rorenijan's Homepage
I checked that too, but it seem to be alright too ;/

http://www.sei-kai.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07