logo Sign In

Search Function

Author
Time
 (Edited)

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)
Author
Time

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

A Goon in a Gaggle of 'em

Author
Time

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

Forum Administrator

MTFBWY…A