This class is offered at the following Dates/Times:

Please Choose a Date & Time

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.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'GROUP'.
 
The error occurred in C:/websites/defaultWebsite/rangemanagement/classdetail.cfm: line 82
80 : 				LEFT JOIN 
81 : 				(SELECT BB.CLASS_SESSION_ID, COUNT(*) AS CUSTOMER_COUNT FROM TB_CLASSES AA INNER JOIN TB_CLASS_SESSION BB ON (BB.CLASS_ID = AA.CLASS_ID) INNER JOIN TB_CUST_SESSION CC ON (CC.CLASS_SESSION_ID = BB.CLASS_SESSION_ID) WHERE AA.STYLE_ID = #getclass.style_id#  GROUP BY BB.CLASS_SESSION_ID) D ON (D.CLASS_SESSION_ID = B.CLASS_SESSION_ID)
82 : 				WHERE A.STYLE_ID= #getclass.style_id# and a.IS_ACTIVE='Y' and B.START_DATETIME >= getdate()
83 : 				order by START_DATETIME asc
84 : 			</cfquery>

SQLSTATE   HY000
DATASOURCE   koalasql
VENDORERRORCODE   156
SQL    SELECT B.CLASS_SESSION_ID, A.CLASS_NAME, C.RESOURCE_NAME, B.START_DATETIME, B.END_DATETIME, A.IS_ACTIVE, ISNULL(D.CUSTOMER_COUNT,0) AS CUSTOMER_COUNT, A.MAX_CAPACITY FROM TB_CLASSES A LEFT JOIN TB_CLASS_SESSION B ON(A.CLASS_ID=B.CLASS_ID) LEFT JOIN TB_CLASS_RESOURCE C ON(C.CLASS_RESOURCE_ID=B.CLASS_RESOURCE_ID) LEFT JOIN (SELECT BB.CLASS_SESSION_ID, COUNT(*) AS CUSTOMER_COUNT FROM TB_CLASSES AA INNER JOIN TB_CLASS_SESSION BB ON (BB.CLASS_ID = AA.CLASS_ID) INNER JOIN TB_CUST_SESSION CC ON (CC.CLASS_SESSION_ID = BB.CLASS_SESSION_ID) WHERE AA.STYLE_ID = GROUP BY BB.CLASS_SESSION_ID) D ON (D.CLASS_SESSION_ID = B.CLASS_SESSION_ID) WHERE A.STYLE_ID= and a.IS_ACTIVE='Y' and B.START_DATETIME >= getdate() order by START_DATETIME asc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.163.42.154
Referrer  
Date/Time   16-Dec-18 07:59 AM
Stack Trace
at cfclassdetail2ecfm1803539560.runPage(C:/websites/defaultWebsite/rangemanagement/classdetail.cfm:82) at cfclassdetail2ecfm1803539560.runPage(C:/websites/defaultWebsite/rangemanagement/classdetail.cfm:82)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'GROUP'.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfclassdetail2ecfm1803539560.runPage(C:\websites\defaultWebsite\rangemanagement\classdetail.cfm:82)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)