Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 Topic Problem again (one more quick question Rich)		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  04:31:05  Show Profile  Visit MisterVB's Homepage
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/topic.asp, line 370



I get that error when i reply to a topic.

This is from line 370 - 373

TxtSub = rs("T_SUBJECT")
strAuthor = rs("T_AUTHOR")
strName = rs("M_NAME")
%>



Edited by - MisterVB on 17 April 2001 05:48:03

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:12:32  Show Profile  Visit MisterVB's Homepage
heres my topic and post files... maybe theres errors elsewhere. I'm hoping this can be fixed cause i finally have my forum setup to where i like it.

http://mistervb.121host.net/Topic.txt

http://mistervb.121host.net/Post.txt
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 17 April 2001 :  05:13:29  Show Profile
in your other problem removing:

strName = rs("M_NAME")

fixed it. Have you tried that?


Where did you get these files from that you are having so many problems with?
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:16:03  Show Profile  Visit MisterVB's Homepage
Well Problems started occuring after I installed a good amount of mods... Before that there were no errors.
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:17:15  Show Profile  Visit MisterVB's Homepage
you mean when i was having the error editing a topic? yes removing that fixed it.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 17 April 2001 :  05:22:45  Show Profile
you can delete these 3 lines, not sure why they are there, but they shouldn't be.


TxtSub = rs("T_SUBJECT")
strAuthor = rs("T_AUTHOR")
strName = rs("M_NAME")


You can probably delete the line above those 3 lines also:


set rs = my_Conn.Execute (strSql)


I don't see that code in a stock version of Topic.asp and it probably wouldn't be added by a mod either.
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:24:33  Show Profile  Visit MisterVB's Homepage
*lol* So far this week the only thing that cheered me up and that is keeping me calm today is finding out i'm going to be a daddy. lol
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 17 April 2001 :  05:29:36  Show Profile  Visit HuwR's Homepage
congratulations,

the lines you quote are from post.asp not topic.asp
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 17 April 2001 :  05:31:05  Show Profile
but, they are actually in the topic.txt file linked to above. Somehow they snuck into topic.asp.
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:31:48  Show Profile  Visit MisterVB's Homepage
Thanks... I had copied those three lines from topic.asp.. I guess I placed them in topic.asp by a screw up.
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:34:07  Show Profile  Visit MisterVB's Homepage
Can you go here and try to figure out why this topic posts like this? my colors are set to show the alternate cells the same as the original.

http://mistervb.121host.net/Forum/topic.asp?TOPIC_ID=11&FORUM_ID=19&CAT_ID=2&Topic_Title=test&Forum_Title=Misc%2E Topics
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:41:01  Show Profile  Visit MisterVB's Homepage
Nevermind i remembered i deleted

if intI = 0 then
CColor = strAltForumCellColor
else
CColor = strForumCellColor
end if


Thank you guys for your help.
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  05:44:17  Show Profile  Visit MisterVB's Homepage
Been meaning to talk to you Rich I had a problem with adding the avatar... Theres a section in topic.asp where i am suppose to locate this line twice:
<br>
<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rs("M_COUNTRY") %></small></font>
<br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rs("M_POSTS") %> Posts</small></font></td>


And replace it with your lines but i can only locate it once because the poll mod and a few others altered lines... Is this the reason my Avatar doesn't show up in a reply to a message?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 17 April 2001 :  05:55:10  Show Profile
All you have to replace is that <br> that is by itself.

In topic.asp, just a few lines down from where you just deleted that code find this:


        <br><% = getStar_Level(rs("M_LEVEL"), rs("M_POSTS")) %>
<%				end if %>
        <br>


just replace the <br> with the code that it says to in the instructions for the Avatar MOD.
Go to Top of Page

MisterVB
Junior Member

274 Posts
Posted - 17 April 2001 :  06:15:12  Show Profile  Visit MisterVB's Homepage
I'm lost now. lol

if you peek in my topic.txt you can see where i added that to the br (mental error when i posted to change the whole thing, I actually only changed the <br> line.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.43 seconds. Powered By: Snitz Forums 2000 Version 3.4.07