2023 SFAC
Standings for SFAC
RESULTS:

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.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY date, time asc' at line 4
 
The error occurred in D:/Websites/TournamentBowl.com/wwwroot/Open/standings_view_include.cfm: line 7
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm: line 143
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm: line 1
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/standings_view_include.cfm: line 7
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm: line 143
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm: line 1
5 : SELECT *, DATE_FORMAT(CONCAT(date,' ',time),'%a %c/%e %l:%i %p') AS squaddisplayvalue
6 : FROM squads
7 : WHERE id_tournament = #qryEvent.id_tournament#
8 : ORDER BY date, time asc
9 : </cfquery>

SQLSTATE   42000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   tournamentmanager
VENDORERRORCODE   1064
SQL   SELECT *, DATE_FORMAT(CONCAT(date,' ',time),'%a %c/%e %l:%i %p') AS squaddisplayvalue FROM squads WHERE id_tournament = ORDER BY date, time asc
Resources:

Browser   claudebot
Remote Address   3.235.75.229
Referrer  
Date/Time   28-Mar-24 09:52 AM
Stack Trace
at cfstandings_view_include2ecfm1382436959.runPage(D:/Websites/TournamentBowl.com/wwwroot/Open/standings_view_include.cfm:7) at cfStandings_Custom2ecfm1697320506._factor11(D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm:143) at cfStandings_Custom2ecfm1697320506.runPage(D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm:1) at cfstandings_view_include2ecfm1382436959.runPage(D:/Websites/TournamentBowl.com/wwwroot/Open/standings_view_include.cfm:7) at cfStandings_Custom2ecfm1697320506._factor11(D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm:143) at cfStandings_Custom2ecfm1697320506.runPage(D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom.cfm:1)

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY date, time asc' at line 4
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1613)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1355)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1285)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	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_view_include2ecfm1382436959.runPage(D:\Websites\TournamentBowl.com\wwwroot\Open\standings_view_include.cfm:7)
	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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211)
	at cfStandings_Custom2ecfm1697320506._factor11(D:\Websites\TournamentBowl.com\wwwroot\Open\Standings_Custom.cfm:143)
	at cfStandings_Custom2ecfm1697320506.runPage(D:\Websites\TournamentBowl.com\wwwroot\Open\Standings_Custom.cfm:1)
	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)