Milaegers

Ornaments

1 - 18 of 18 Items

Sort By NEWEST

ITEMS PER PAGE 20

all Filters

Products Collections Jim Shore Ornaments Clear All filters

Filter 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.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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:246) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) 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.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java: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	190
RAW_TRACE	at cfsidenav2ecfm48817863._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
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	190
RAW_TRACE	at cfsidenav2ecfm48817863._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

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

Type

java.sql.SQLException

SQLState

HY000

Sql

SELECT DISTINCT CASE WHEN isNull(a.siz_alias,'') != '' then a.siz_alias else a.siz end 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 ( ) AND upper(a.siz) NOT IN ('NO_SIZE','N/A') AND upper(a.siz_alias) NOT IN ('NO_SIZE','N/A') GROUP BY a.siz,a.siz_alias 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._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:246) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) 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.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java: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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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) ... 66 more

Suppressed

array[empty]

TagContext

array

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

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
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	190
RAW_TRACE	at cfsidenav2ecfm48817863._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
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	190
RAW_TRACE	at cfsidenav2ecfm48817863._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
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	190
RAW_TRACE	at cfsidenav2ecfm48817863._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190)
TEMPLATE	C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
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.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java: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._factor24(C:\websites\stratusecommerce\includes\sidenav.cfm:190) at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cfcategory2ecfm1745707752._factor8(C:\websites\stratusecommerce\category.cfm:246) at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2) at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) 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:5088) at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) 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) ... 39 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:1642) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) 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) ... 66 more

Suppressed

array[empty]

TagContext

array

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

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

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

struct
COLUMN	0
ID	CF_CATEGORY
LINE	2
RAW_TRACE	at cfcategory2ecfm1745707752._factor9(C:\websites\stratusecommerce\category.cfm:2)
TEMPLATE	C:\websites\stratusecommerce\category.cfm
TYPE	CFML

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

struct
COLUMN	0
ID	CFINCLUDE
LINE	243
RAW_TRACE	at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
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

Ornaments

Categories

Sub-Categories

Brand