All Products

74 ITEMS

24 / 48 / 72 / 96 / ALL Per Page

PAGE 2of 2

Boulder Gear Kids Nestor Bib Alternate View

Boulder Gear Kids Nestor Bib $105.00 sale: $73.99

Boulder Gear Kids Nestor Bib Our Price: $105.00

Boulder Gear Kids Nestor Bib Our Price: $105.00

Chaco Women's Mega Z/Cloud Sandal VIBINBW

Chaco Women's Mega Z/Cloud Sandal $105.00 sale: $52.99

Hestra Women's Boda Mitt Our Price: $170.00

Hestra Women's Boda Mitt Our Price: $170.00

Keen Women's Versacore Speed Shoe ALLOY/REEF

Keen Women's Versacore Speed Shoe Alternate View

Keen Women's Versacore Speed Shoe $130.00 sale: $64.99

Nidecker Micron Kids' Snowboard Boots 2025 BLACK

Nidecker Micron Kids' Snowboard Boots 2025 Alternate View

Nidecker Micron Kids ' Snowboard Boots 2025 $199.95 sale: $139.99

Nidecker Sierra Snowboard Boots 2025 BLACK

Nidecker Sierra Snowboard Boots 2025 Alternate View

Nidecker Sierra Snowboard Boots 2025 $239.95 sale: $167.99

Hestra Army Leather Heli Ski 3-Finger Glove BLACK

Hestra Army Leather Heli Ski 3-Finger Glove Alternate View

Hestra Army Leather Heli Ski 3- Finger Glove Our Price: $185.00

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]SHUTDOWN is in progress.

The error occurred in E:/websites/GeigersEcommerce/functions/itemdetails.cfc: line 728
Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 150
Called from E:/websites/GeigersEcommerce/category.cfm: line 120
Called from E:/websites/GeigersEcommerce/functions/itemdetails.cfc: line 728
Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 150
Called from E:/websites/GeigersEcommerce/category.cfm: line 120

726 : 
727 : 		GROUP BY b.attr1
728 : 		ORDER BY CASE WHEN max(b.attr1_entry_id) = #val(arguments.attr1)# THEN 1 ELSE 2 END
729 : 		
730 : 		</cfquery>

SQLSTATE	HY000
DATASOURCE	celerantSQL
VENDORERRORCODE	6005
SQL	SELECT b.attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) WHERE a.style_id= (param 1) and b.attr1 <> 'N/A' AND isNull(a.sell_web,'Y') <> 'N' GROUP BY b.attr1 ORDER BY CASE WHEN max(b.attr1_entry_id) = 0 THEN 1 ELSE 2 END

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	216.73.216.248
Referrer
Date/Time	05-Oct-26 02:00 AM

Stack Trace

at cfitemdetails2ecfc639694310$funcGETCOLORS.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:728) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:150) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:120) at cfitemdetails2ecfc639694310$funcGETCOLORS.runFunction(E:/websites/GeigersEcommerce/functions/itemdetails.cfc:728) at cfthumbnails2ecfm435612791.runPage(E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm:150) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:120)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]SHUTDOWN is in progress.
	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.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfitemdetails2ecfc639694310$funcGETCOLORS.runFunction(E:\websites\GeigersEcommerce\functions\itemdetails.cfc:728)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489)
	at cfthumbnails2ecfm435612791.runPage(E:\websites\GeigersEcommerce\includes\views\thumbnails.cfm:150)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfcategory2ecfm908738381.runPage(E:\websites\GeigersEcommerce\category.cfm:120)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)