| Author |
 Topic  |
|
|
maimai
Starting Member
8 Posts |
 Posted - 02 February 2004 : 01:24:33
|
After adding Private Messages Mod, I got this error.
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/myglobe_new/forum/inc_func_common.asp, line 662
This error displays when i go in one of the topics. I tried to edit topic.asp and edit this line, removing the additional ', M.M_PMRECEIVE'.. it works when i remove this. Note that there are 2 sql statement for this i'm refferring to the second statement.
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_PMRECEIVE" & _
Any help would be HIGHLY APPRECIATED!
Here is my topic.asp code http://aopdev01.asiaonline.net.ph/topic.txt .
|
Edited by - maimai on 02 February 2004 01:27:12 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 02 February 2004 : 07:59:34
|
Locate the following, starting on line 512 in your topic.asp:
rM_NAME = 0
rM_RECEIVE_EMAIL = 1
rM_AIM = 2
rM_ICQ = 3
rM_MSN = 4
rM_YAHOO = 5
rM_PM = 6
rM_TITLE = 6
rMEMBER_ID = 7
...and so on
You need to increase the numbers marked red (and the rest of the numbers in that block of code in topic.asp), starting with 7 and ending with 23 for rM_SIG. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
 |
|
|
maimai
Starting Member
8 Posts |
Posted - 03 February 2004 : 04:03:37
|
It works! This step is not included in the readme file. Big thanks to you Jan!
|
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 03 February 2004 : 07:59:39
|
It isn't explicitly mentioned that one must increase the numbers after after adding rM_PM = 6, that is true.
You're welcome.  |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
jonnyglobal
Starting Member
20 Posts |
Posted - 07 February 2004 : 14:47:41
|
There is a problem with this solution. I was getting the same error, but when I incremented my values, rM_sig ended up to be 24. With rm_Sig = 24 you get a run-time rM_sig out of range error.
I ended up having to ditch one of the variables that just happened not to be used elsewhere - rM_avatar as such:
rM_YAHOO = 5
rM_PM = 6
rM_TITLE = 7
rMEMBER_ID = 8
rM_HOMEPAGE = 9
rM_LEVEL = 10
rM_POSTS = 11
rM_COUNTRY = 12
'rM_Avatar = 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
This allowed my PM to work and not to get the run time error.
My only concern is when will the rM_Avatar perameter be needed and will it screw me later? I don't use avatars on my site now, but it is just a matter of time before I get to that install.
Anyone else run into this?
Regards,
Jonathan
|
Edited by - jonnyglobal on 07 February 2004 14:52:19 |
|
|
|
jonnyglobal
Starting Member
20 Posts |
Posted - 07 February 2004 : 14:50:18
|
| >sorry, double post< |
Edited by - jonnyglobal on 07 February 2004 14:51:22 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 07 February 2004 : 20:24:33
|
| Are you using the avatar mod? If not, then 'rM_Avatar shouldn't be here. If you are using it, then 'rM_Avatar should be 13, and rREPLY_ID should be 14, and so on. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
| |
Topic |
|
Topic Locked
