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: MOD Implementation
 Can U help fix Poll Mod Syntax & Formatting Error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sybaritic_life
Starting Member

Canada
9 Posts

Posted - 02 February 2010 :  02:40:25  Show Profile
I'm hoping you can help me debug some errors. I'm not very familiar with VB. I have installed the Poll Mod with 3.4.07 (USERGROUP Mod was installed correctly previously.)

The first error is a formatting one--when I click on the pencil to edit a forum, the last column of the tables is black--I think I may have forgotten to close a tag somewhere...can anyone verify this and would you know which file I would need to edit (e.g., post.asp)?

The second error is more detrimental: It says,
ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/pgsa/forum/topic.asp, line 173

Thirdly, can you check whether I commented out the 2 extra Response.Write correctly? I intiailly received an error and when I commented out the 'Response.Write's then I got above error (second .

		if ((Cat_Status <> 0) and (Forum_Status <> 0) and (Topic_Status <> 0)) or (AdminAllowed = 1) then
		'######################### Poll Mod - Added 'pollLink' to line below ######################
			Response.Write	"                <a href=""post.asp?" & ArchiveLink & pollLink & "method=EditTopic&REPLY_ID=" & Topic_ID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderPencil,"Edit Topic","hspace=""0""") & "</a>" & vbNewLine
		'##########################################################################################
			'Response.Write	"                <a href=""post.asp?" & ArchiveLink & "method=EditTopic&REPLY_ID=" & Topic_ID & "&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderPencil,"Edit Topic","hspace=""0""") & "</a>" & vbNewLine
		end if
		'######################### Poll Mod - Added 'pollLink' to line below ######################
		'Response.Write	"                <a href=""JavaScript:openWindow('pop_delete.asp?" & ArchiveLink & "mode=Topic&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderDelete,"Delete Topic","") & "</a>" & vbNewLine & _
		Response.Write	"                <a href=""JavaScript:openWindow('pop_delete.asp?" & ArchiveLink & pollLink & "mode=Topic&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & "&CAT_ID=" & Cat_ID & "')"">" & getCurrentIcon(strIconFolderDelete,"Delete Topic","") & "</a>" & vbNewLine & _
		
				"                <a href=""post.asp?method=Topic&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconFolderNewTopic,"New Topic","") & "</a>" & vbNewLine
		if Topic_Status <= 1 and ArchiveView = "" then
			Response.Write	"                <a href=""post.asp?method=Reply&TOPIC_ID=" & Topic_ID & "&FORUM_ID=" & Forum_ID & """>" & getCurrentIcon(strIconReplyTopic,"Reply to Topic","") & "</a>" & vbNewLine
		end if
	end if 



Thanks for your help!

Edited by - sybaritic_life on 02 February 2010 09:16:46

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 02 February 2010 :  03:16:43  Show Profile  Visit HuwR's Homepage
check you have made all the right code changes, that error message always means you have referenced a field is not in your queery, check that you have added the correct fields to the SQL SELECT statement (it will come before the line that is indicated in the error
Go to Top of Page

sybaritic_life
Starting Member

Canada
9 Posts

Posted - 02 February 2010 :  09:48:41  Show Profile
ok, I fixed the formatting error--they were a result of not commenting out lines that were replaced in post.asp

The error on this page: http://www.psych.ryerson.ca/pgsa/forum/topic.asp?TOPIC_ID=4

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/pgsa/forum/topic.asp, line 173

was same type of error...I was just mindlessly pasting and forgetting to modify the code...
Thank you.

Edited by - sybaritic_life on 02 February 2010 10:12:53
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.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07