| Author |
 Topic  |
|
|
Thomas
Starting Member
Belgium
20 Posts |
 Posted - 27 October 2003 : 15:00:51
|
I've added most of the private messages mod to a forum, but I'm having some trouble with the last file (POP_PROFILE.ASP). The readme clearly states I should add some code behind line 148. Despite this, I've located this code near line 311.
Anyway, I've tried to add the code behind the code in line 311 as described in the readme. Now, when I try to open a member's profile, I receive the following error:
<paste>
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/pop_profile.asp, line 322
</paste>
What am I supposed to do?
A copy of my pop_profile.asp file can be found @ http://users.pandora.be/fox/pop_profile.txt |
Edited by - Thomas on 28 October 2003 09:13:15 |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 28 October 2003 : 08:33:15
|
| Are you 100% that link works or have i just got a slow connection all of a sudden? |
Steve
Drogheda, Ireland @ www.droghedatown.com |
 |
|
|
Thomas
Starting Member
Belgium
20 Posts |
Posted - 28 October 2003 : 09:11:34
|
| Yeah, my ISP squeezed my line (traffic was too high this month). I've uploaded it to another location. |
|
|
|
Thomas
Starting Member
Belgium
20 Posts |
Posted - 28 October 2003 : 09:29:15
|
Appears I'm also receiving errors when users reply to a topic. Creating new topics isn't a problem however.
<paste>
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/inc_func_common.asp, line 640
</paste>
I think there is something wrong with the data type conversion?
A copy of this file can be found @ http://users.pandora.be/fox/inc_func_common.txt
Any help is absolutely appreciated!
Thomas |
Edited by - Thomas on 28 October 2003 09:32:55 |
|
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 29 October 2003 : 08:20:41
|
| What other modifications are you using, if any? |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
|
Thomas
Starting Member
Belgium
20 Posts |
Posted - 29 October 2003 : 08:49:32
|
I'm already running the basis statistic MOD, the email all users MOD and the new events calender MOD.
I doubt (a bit) that these MOD's have anything to do with the error (correct me if I'm wrong). I think the error is caused by the Private Messages MOD. I've put the original topic.asp back on the server. Result: reply’s are readable again.
I'll investigate this further.  |
Edited by - Thomas on 29 October 2003 08:52:54 |
|
|
|
Thomas
Starting Member
Belgium
20 Posts |
Posted - 30 October 2003 : 10:34:21
|
Replies are unreadable when I edit topic.asp line 311.
I'm supposed to change line 311:
<paste>
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO"
</paste>
to:
<paste>
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_PMRECEIVE"
</paste>
Any ideas?
Beano_ie: Do you think it's still necessary to compare my pop_profile.asp with yours? |
Edited by - Thomas on 30 October 2003 10:44:54 |
|
|
|
Thomas
Starting Member
Belgium
20 Posts |
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
Thomas
Starting Member
Belgium
20 Posts |
Posted - 16 November 2003 : 11:59:17
|
Yes, that's it... the forum is running! Thanks!
Weird I didn't see it myself.
 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
jonnyglobal
Starting Member
20 Posts |
Posted - 09 February 2004 : 14:10:20
|
Masterao,
I actually have my values correctly numbered in topic.asp and I am still getting the error that was at the beginning of this thread for pop_profile.asp:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/atheism/pop_profile.asp, line 320
I get this when I click on anyone's nick to see the profile. However, if I am logged in and click 'profile' to see my own profile it is fine. I am not having the issue with topic replies, that was taken care of when I renumbered the values in topic.asp.
Any ideas why my pop_profile would be throwing this error. The line of code indicated in the error reads as such:
If strDBNTUserName <> "" and Trim(rs("M_PMRECEIVE")) = "1" and strPMStatus = "1" Then
strContacts = strContacts + 1
Response.Write " <tr>" & vbNewLine & _
" <td bgColor=""" & strPopUpTableColor & """ align=""right"" nowrap><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>PM User: </font></b></td>" & vbNewLine & _
" <td bgColor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & getCurrentIcon(strIconPmprivatemessage,"Send " & chkString(rs("M_NAME"),"display") & " a Private Message","align=""absmiddle"" hspace=""0""") & " <a href=""privatesend.asp?method=Topic&mname=" & chkString(rs("M_NAME"),"display") & """>" & chkString(rs("M_NAME"),"display") & "</a> </font></td>" & vbNewLine & _
" </tr>" & vbNewLine
end if
Any ideas? Everything other than the links to individual's profiles is working fine.
|
Edited by - jonnyglobal on 09 February 2004 14:10:51 |
|
|
|
jonnyglobal
Starting Member
20 Posts |
Posted - 09 February 2004 : 14:17:11
|
NEVERMIND. I found a typo on my part where the SQL command string is put together.
I am fine now.
Regards,
Jonathan |
|
|
| |
Topic |
|
Topic Locked
