Error Occurred While Processing Request 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

Error Executing Database Query.


Query Of Queries syntax error.
Encountered "<EOF>. Incorrect ORDER BY column reference [].
Only simple column reference, alias name, and integer column id are allowed.
Example: You can use alias to refer to a complex expression:
SELECT (a+b)/2 as x FROM T ORDER BY x
 
The error occurred in D:/Websites/TournamentBowl.com/wwwroot/cfc_folder/Standings_prep24F.cfc: line 564
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom_doc.cfm: line 81
Called from D:/Websites/TournamentBowl.com/wwwroot/cfc_folder/Standings_prep24F.cfc: line 564
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom_doc.cfm: line 81
 
562 :     <cfelseif listfind('3,4',qryEvent.id_event_formats) GT 0>
563 :     	ORDER BY status_priority desc, total_overall_points desc, total_overall_pins desc
564 :     <cfelse>
565 :     	ORDER BY status_priority desc, total_overall_pins desc
566 :     </cfif>
EXCEPTIONS   <small><i>not set</i></small>
SQL   SELECT * FROM qryTeams WHERE total_scratch_plus_carried > 0 ORDER BY status_priority desc,
Resources:

Browser   claudebot
Remote Address   3.145.191.169
Referrer  
Date/Time   18-Apr-24 10:05 AM
Stack Trace
at cfStandings_prep24F2ecfc1179843060$funcCFC_PREPARE_STANDINGS.runFunction(D:/Websites/TournamentBowl.com/wwwroot/cfc_folder/Standings_prep24F.cfc:564) at cfStandings_Custom_doc2ecfm309715491.runPage(D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom_doc.cfm:81) at cfStandings_prep24F2ecfc1179843060$funcCFC_PREPARE_STANDINGS.runFunction(D:/Websites/TournamentBowl.com/wwwroot/cfc_folder/Standings_prep24F.cfc:564) at cfStandings_Custom_doc2ecfm309715491.runPage(D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom_doc.cfm:81) 

java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br>
Encountered "<EOF>.
Incorrect ORDER BY column reference [].<br> Only simple column reference, alias name, and integer column id are allowed. <br><b>Example</b>: You can use alias to refer to a complex expression: <br><i>SELECT (a+b)/2 as x FROM T ORDER BY x</i>

	at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:600)
	at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:548)
	at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:143)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1623)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:430)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
	at cfStandings_prep24F2ecfc1179843060$funcCFC_PREPARE_STANDINGS.runFunction(D:\Websites\TournamentBowl.com\wwwroot\cfc_folder\Standings_prep24F.cfc:564)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:681)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4175)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4139)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472)
	at cfStandings_Custom_doc2ecfm309715491.runPage(D:\Websites\TournamentBowl.com\wwwroot\Open\Standings_Custom_doc.cfm:81)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:446)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)