| Author |
 Topic  |
|
|
BroadChannel
Starting Member
USA
30 Posts |
 Posted - 12 April 2005 : 21:15:47
|
I have Snitz Forums 2000 Version 3.4.05.
I had a working AVATAR MOD 1.3 for some time.
I just added Poll Mod Version: 2.0.7
When I view my Topics... topic.asp returns this message beneath my Forums header:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/Forums/topic.asp, line 141
Line 141 reads: Member_Avatar = rsTopic("M_AVATAR_URL")
Any ideas what caused this?
Everything else in the POLLS works perfectly except when I try to view a new topic anywhere in the Forums, regardless of what Topic it is.
I don't know if the polls were the culprit - I checked and recheck the code changes - not the problem.
I may have inadvertantly deleted an avatar .gif file directly from my avatar folder... but then I cleared the avatar DB and reloaded the avatar MOD with no change.
My avatars display correctly when reviewed in the list, if thats any help.
Thanks |
Edited by - BroadChannel on 12 April 2005 21:26:59 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 13 April 2005 : 06:29:07
|
Sounds like you over wrote the topic SELECT statement when applying the poll mod and M_AVATAR_URL is no longer being retrieved from the MEMBERS table. Go back to the readme for the avatar mod and make the required changes to the relavant SQL statement making sure not to overwrite it this time.
|
 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.” |
 |
|
|
BroadChannel
Starting Member
USA
30 Posts |
Posted - 13 April 2005 : 19:16:16
|
Well, actually what I did overwrite (which may be what you were saying) was in topic.asp.
The Poll Mod stated to overwrite the original code, around line 140, with:
'############################### Poll Mod ##################################
' Added T.T_ISPOLL, T.T_POLLSTATUS and F.F_POLLS in SQL Statment below.
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO" & _
", M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY" & _
", T.T_DATE, T.T_SUBJECT, T.T_AUTHOR, T.TOPIC_ID, T.T_STATUS, T.T_ISPOLL, T.T_POLLSTATUS, T.T_LAST_EDIT" & _
", T.T_LAST_EDITBY, T.T_LAST_POST, T.T_SIG, T.T_REPLIES" & _
", C.CAT_STATUS, C.CAT_ID, C.CAT_NAME, C.CAT_SUBSCRIPTION, C.CAT_MODERATION" & _
", F.F_STATUS, F.F_POLLS, F.FORUM_ID, F.F_SUBSCRIPTION, F.F_SUBJECT, F.F_MODERATION, T.T_MESSAGE"
'###########################################################################
Not looking ... I overwrote the M.M_AVATAR_URL (from the avatar mod) after M.M_COUNTRY
If that makes any sense.
Well I put back ,M.M_AVATAR_URL" and presto!
Thanks for the direction. |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 14 April 2005 : 06:14:35
|
You're welcome 
Always be careful when mod instructions tell you to overwrite/replace something in your code; oftentimes the mod author will be working from the assumption that you have no other mods installed already.
|
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.” |
|
|
| |
Topic |
|
|
|
Topic Locked
