Home All Products
struct
EVENTNAME onRequest
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource koalaSQL
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT DISTINCT typ, count(distinct style_id) as itemCount FROM web_all_products WHERE ltrim(rtrim(dept))='Soccer Plus' and upper(typ)<>'EMPTY' and style_id IN () GROUP BY typ
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 87 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource koalaSQL
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT DISTINCT typ, count(distinct style_id) as itemCount FROM web_all_products WHERE ltrim(rtrim(dept))='Soccer Plus' and upper(typ)<>'EMPTY' and style_id IN () GROUP BY typ
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 87 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:550) 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:96) 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: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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203) at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 40 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.dda4.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:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 87 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 131
RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 46
RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DEPARTMENTS
LINE 1
RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1)
TEMPLATE E:\websites\includes_rp\departments.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 203
RAW_TRACE at cfsidenav2ecfm1602545999._factor46(E:\websites\includes_rp\sidenav.cfm:203)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999._factor51(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_SIDENAV
LINE 1
RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1)
TEMPLATE E:\websites\includes_rp\sidenav.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 34
RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34)
TEMPLATE E:\websites\includes\views\landingPage.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 75
RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75)
TEMPLATE E:\websites\defaultWebsite_rp\category.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 133
RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:133)
TEMPLATE E:\websites\defaultWebsite_rp\application.cfc
TYPE CFML
Type Database
name onRequest