Hubert's Family Outfitters

Filter Products

Brand

Birkenstock (21)
Bogs (1)
Dansko (19)
Keen (1)
New Balance (1)
Skechers (2)
Spring Step (1)

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.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) 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:5083) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) 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:5083) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) 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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLException

DataSource

koalasql

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.

ErrorCode

HY000

Exceptions

array

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

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

Sql

SELECT DISTINCT a.siz as filter_item , max(a.size_order) as theOrder , count(DISTINCT b.style_id) as itemCount FROM tb_size_entries a INNER JOIN tb_skus b WITH (NOLOCK) ON (a.scale_entry_id = b.scale_entry_id) WHERE 1=2 OR b.style_id IN ( ) GROUP BY a.siz ORDER BY max(a.size_order)

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) 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:5083) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) 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:5083) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569) 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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) ... 61 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
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

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLException

DataSource

koalasql

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.

ErrorCode

HY000

Exceptions

array

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

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

Sql

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
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:569) 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:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) 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:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) 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:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) 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:5083) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) 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:5083) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 37 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) ... 61 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	209
RAW_TRACE	at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:209)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	158
RAW_TRACE	at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:158)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	226
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:226)
TEMPLATE	C:\websites\stratusecommerce\application.cfc
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4478
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.execute(\|SQLServer\|6.0.0.1282\|:4478)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

Type

Database

name

onRequest