| Author |
 Topic  |
|
|
WillClark22
Starting Member
USA
3 Posts |
 Posted - 19 December 2002 : 00:15:30
|
Hello all ... this is my first post here regarding this cool Snitz Forum software. Hopefully someone here can assist me with an issue which has been frustrating me.
I just recently added the MOD: Avatar Mod for 3.4 (Original Author: Richard Kinser, adapted by Hamlin.) and have added the capability of avatars on my site. I love this added feature to my site, but the issue that I am encountering is as follows:
If I disable the display avatar in profile in my admin settings, all is fine. However, if I enable display avatar in profile, I get the following error whenever I try to click on a profile:
***** START *****
ADODB.Fields error '800a0cc1'
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
/forum/pop_profile.asp, line 308
***** END *****
Has anyone else experienced this error, or can anyone give any advice on how to resolve it? Thanks a bunch! 
(BTW - I am running the newest version of Snitz 3.4.03)
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 19 December 2002 : 03:04:24
|
| Read my Link 2 .. specifically what is on Line 308 |
 |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 19 December 2002 : 08:10:45
|
hi~ WillClark22,
according the readme.htm of Avatar Mod, i think your line.308 should be this one..
if IsNull(rs("M_AVATAR_URL")) or rs("M_AVATAR_URL") = "" or rs("M_AVATAR_URL") = " " or rs("M_AVATAR_URL") = "noavatar.gif" then
and the error message usually just mean it can't find what the recordset refer... rs("M_AVATAR_URL")
so... according the readme.htm again.. i guess you maybe missing the one line code insert in line.188
POP_PROFILE.ASP
Look for this code around line 188
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_HOMEPAGE"
Add the following code under the line strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_PHOTO_URL"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_AVATAR_URL"
anyway, i think it's easy to solve this problem. if you open the readme.htm and check your pop_profile.asp code modification again.  |
|
|
|
WillClark22
Starting Member
USA
3 Posts |
Posted - 19 December 2002 : 22:31:40
|
DoraMoon & Laser,
Thank you both for replying to my post!
DoraMoon - you were correct regarding the line of code that I omitted while I was implementing the MOD. Thank you so much for your help ... the avatar enabled profile link now is functional and no longer generates the error message. I am very grateful! |
|
|
| |
Topic |
|
Topic Locked
