| Author |
 Topic  |
|
|
Rorenijan
Starting Member
Sweden
3 Posts |
 Posted - 14 November 2005 : 11:50:04
|
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
|
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.” |
 |
|
|
Rorenijan
Starting Member
Sweden
3 Posts |
Posted - 14 November 2005 : 13:00:28
|
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 |
|
|
|
imweazel
Starting Member
49 Posts |
Posted - 14 November 2005 : 15:49:39
|
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
|
|
|
|
Rorenijan
Starting Member
Sweden
3 Posts |
Posted - 15 November 2005 : 14:40:12
|
I checked that too, but it seem to be alright too ;/
|
http://www.sei-kai.com |
|
|
| |
Topic |
|
|
|
Topic Locked
