Image

$0.00
Out of stock

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
 
The error occurred in C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 936
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 926
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 1
Called from C:/home/renegadestores.com/wwwroot/router.cfm: line 16
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 936
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 926
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 1
Called from C:/home/renegadestores.com/wwwroot/router.cfm: line 16
934 : 		left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1
935 : 		left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90
936 : 		where s.web_product='Y' and s.style_id in(#product.STYLE_ID#)
937 : 		and (b90.QOH > 0 OR b.QOH > 0)
938 : 		group by s.style_id

SQLSTATE   HY000
DATASOURCE   renegadecumdedicated
VENDORERRORCODE   102
SQL    Select CASE when MIN(b90.PRICE) > 0 then MIN(b90.PRICE) else MIN(b.PRICE) END AS MIN_PRICE, CASE when MAX(b90.PRICE) > 0 then MAX(b90.PRICE) else MAX(b.PRICE) END AS MAX_PRICE, CASE when MAX(b90.PRICE) > 0 then MAX(b90.PRICE) else MAX(b.PRICE) END AS PRICE from tb_styles s with(nolock) left join tb_skus sk with(nolock) on sk.style_id = s.style_id left join tb_sku_lookups sl with (nolock) on (sl.sku_id=sk.SKU_ID and len(sl.lookup) > 10) left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1 left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90 where s.web_product='Y' and s.style_id in() and (b90.QOH > 0 OR b.QOH > 0) group by s.style_id
Resources:

Browser   claudebot
Remote Address   3.235.46.191
Referrer  
Date/Time   28-Mar-24 08:28 AM
Stack Trace
at cffooter2ecfm204508901._factor15(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:936) at cffooter2ecfm204508901._factor18(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:926) at cffooter2ecfm204508901.runPage(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:1) at cfrouter2ecfm1479502796.runPage(C:/home/renegadestores.com/wwwroot/router.cfm:16) at cffooter2ecfm204508901._factor15(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:936) at cffooter2ecfm204508901._factor18(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:926) at cffooter2ecfm204508901.runPage(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:1) at cfrouter2ecfm1479502796.runPage(C:/home/renegadestores.com/wwwroot/router.cfm:16)

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.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cffooter2ecfm204508901._factor15(C:\home\renegadestores.com\wwwroot\includes\footer.cfm:936)
	at cffooter2ecfm204508901._factor18(C:\home\renegadestores.com\wwwroot\includes\footer.cfm:926)
	at cffooter2ecfm204508901.runPage(C:\home\renegadestores.com\wwwroot\includes\footer.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 cfrouter2ecfm1479502796.runPage(C:\home\renegadestores.com\wwwroot\router.cfm:16)
	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.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	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:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	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:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	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:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)