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
 After poll mod: no results in search		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pknaz
Junior Member

USA
117 Posts
Posted - 13 February 2003 :  12:32:09  Show Profile  Visit pknaz's Homepage  Send pknaz an AOL message  Send pknaz an ICQ Message  Send pknaz a Yahoo! Message
I've searched this forum for possible answers to my problem, but haven't been able to find any. I've searched for "search.asp", "search", "search results". If you can think of any other terms I should search for I’d be appreciative. Here is my problem:
When performing a search on my forums I never receive any results. There isn't an error message so it’s hard for me to troubleshoot what the problem might be. My forums are on a local intranet, so I regret that I can't give anyone access to them.

I’ve recently found that if I search for an article (a, the, or…) that I’ll receive the following error:

Microsoft VBScript runtime error '800a000d' 
Type mismatch: '[string: "ICE 2!"]' 

/search.asp, line 542

I'm not sure where its getting the string "ICE 2!" from.
Here is an excerpt from my search.asp file between lines 540 and 560

if currTopic <> Topic_ID then
					Response.Write	"              <tr>" & vbNewline
					if Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status <> 0 then 
						' DEM --> Added if statement to display topic status properly
						if Topic_Status = 2 then
							UnApprovedFound = "Y"
							Response.Write	"                <td bgcolor=""" & strForumCellColor & """ align=""center""><a href=""topic.asp?TOPIC_ID=" & Topic_ID & SearchLink & """>" & getCurrentIcon(strIconFolderUnmoderated,"Topic UnModerated","hspace=""0""") & "</a></td>" & vbNewline
						elseif Topic_Status = 3 then
							HeldFound = "Y"
							Response.Write	"                <td bgcolor=""" & strForumCellColor & """ align=""center""><a href=""topic.asp?TOPIC_ID=" & Topic_ID & SearchLink & """>" & getCurrentIcon(strIconFolderHold,"Topic Held","hspace=""0""") & "</a></td>" & vbNewline
						else
							Response.Write	"                <td bgcolor=""" & strForumCellColor & """ align=""center""><a href=""topic.asp?TOPIC_ID=" & Topic_ID & SearchLink & """>" & ChkIsNew(Topic_LastPost) & "</a></td>" & vbNewline
						end if
					else 
						if Cat_Status = 0 then 
							strAltText = "Category Locked"
						elseif Forum_Status = 0 then 
							strAltText = "Forum Locked"
						else
							strAltText = "Topic Locked"
						end if 
						Response.Write	"                <td bgcolor=""" & strForumCellColor & """ align=""center""><a href=""topic.asp?TOPIC_ID=" & Topic_ID & SearchLink & """>" & getCurrentIcon(strIconFolderLocked,strAltText,"hspace=""0""") & "</a></td>" & vbNewline
					end if

[edit]
my version is 3.4.03, I'm using SQL server 2k, NT authentication.
[/edit]

Any help that i recieve would be greatly appreciated.
Thanks!
Edited by - ruirib on 13 February 2003 13:07:06

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 13 February 2003 :  12:59:20  Show Profile  Send ruirib a Yahoo! Message
Have any mods installed? Post a link to a text version of your search.asp.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

pknaz
Junior Member

USA
117 Posts
Posted - 13 February 2003 :  13:06:04  Show Profile  Visit pknaz's Homepage  Send pknaz an AOL message  Send pknaz an ICQ Message  Send pknaz a Yahoo! Message
Sorry, i made a typo on the version, i've fixed it.
I have several mods installed, only one that required alterations to the search.asp file, and that was the POLL mod.
here is a txt version of my search.asp
http://www.trevecca.edu/search.txt
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 13 February 2003 :  13:19:14  Show Profile
When you install mods, the code you add must look the same way as it is in the file you are copying it from.

Change lines 241 - 244 from this:
'################ Poll Mod ######################
	strSql = strSql & ", T.T_ISPOLL"
'#################################################
	strSql = strSql & ", T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST"
to this:
'################ Poll Mod ######################
	strSql = strSql & ", T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST, T.T_ISPOLL"
'#################################################
Support Snitz Forums
Go to Top of Page

pknaz
Junior Member

USA
117 Posts
Posted - 13 February 2003 :  13:30:55  Show Profile  Visit pknaz's Homepage  Send pknaz an AOL message  Send pknaz an ICQ Message  Send pknaz a Yahoo! Message
Thanks Davio, Really stupid mistake on my part. Its working now.
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 13 February 2003 :  22:34:03  Show Profile
No problem. Glad to have helped.
Support Snitz Forums
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.39 seconds. Powered By: Snitz Forums 2000 Version 3.4.07