Search Function

  • Reply
  • Print
ProgMetalMan's avatar
Search Function

When I attempt to do any search, I get a "connecting..." message for a few minutes (Firefox 17) and then I get the following error page (using the search "French" as a meaningless example):

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
The request has exceeded the allowable time limit Tag: CFQUERY
 
The error occurred in E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc: line 151
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm: line 36
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm: line 1
149 : 							SELECT intForumID
150 : 							FROM tblForumUserGroupCategoryAccess
151 : 							WHERE intGroupID = #arguments.ForumGroupID# AND bitRead = 1 )
152 : 				END
153 : 		

Resources:

 

Browser   Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20100101 Firefox/17.0
Remote Address   *PM if needed*
Referrer   http://originaltrilogy.com/forum/forum.cfm/Star-Wars-Preservations-and-Other-Fan-Projects/forum/17/
Date/Time   09-Jan-13 10:20 PM
Stack Trace
at cfForumSearch2ecfc561348969$funcFORUMSEARCHRESULTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc:151) at cfsearch2dresults2ecfm1414989553._factor2(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:36) at cfsearch2dresults2ecfm1414989553.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:1)

coldfusion.runtime.RequestTimedOutException: The request has exceeded the allowable time limit Tag: CFQUERY
	at coldfusion.sql.Executive.getRowSet(Executive.java:446)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1252)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cfForumSearch2ecfc561348969$funcFORUMSEARCHRESULTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc:151)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358)
	at cfsearch2dresults2ecfm1414989553._factor2(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:36)
	at cfsearch2dresults2ecfm1414989553.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Last edited on January 10, 2013 at 4:22 AM by ProgMetalMan
bkev's avatar
RE: Search Function

When the search function is working it's pretty awful anyway. I'd recommend just using google.

ProgMetalMan's avatar
RE: Search Function

Why not just embed Google then?

Davnes007's avatar
RE: Search Function

Google?

Star Wars Episode XXX: Erica Strikes Back

Davnes007 LogoCanadian Flag

If you want Nice....go to France.

Jay's avatar
RE: Search Function

I disabled search. As everyone knows, it's terrible anyway. Just use Google for now.

Jay Sylvester
originaltrilogy.com

The things you pwn end up pwning you.

DuracellEnergizer's avatar
RE: Search Function

The Googles do nothing!

God doesn't think in terms of black or white - or even shades of gray - but in big, bright, bold hues of blue and orange.

Members reading this topic: None