WOMEN

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]Transaction (Process ID 170) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The error occurred in E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 313
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/category.cfm: line 80
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 313
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/category.cfm: line 80

311 : 		SELECT DISTINCT siz, max(size_order) as size_order
312 : 		FROM tb_size_entries
313 : 		WHERE upper(siz) IN ('#replace(this.overallSizeList,",","','","all")#') and upper(siz) <> 'NS' and upper(siz) <> 'N/S'
314 : 		GROUP BY siz
315 : 		ORDER BY max(size_order), siz

SQLSTATE	40001
DATASOURCE	celerantSQL
VENDORERRORCODE	1205
SQL	SELECT DISTINCT siz, max(size_order) as size_order FROM tb_size_entries WHERE upper(siz) IN ('0','2','4','6','8','10','12','14','16','18','1','3','11','10S','4S','6S','8S','2S','12S','16S','18S','20S','14S','20','6.5','7','7.5','8.5','9','9.5','10.5','11.5','13','5.5','5','4.5') and upper(siz) <> 'NS' and upper(siz) <> 'N/S' GROUP BY siz ORDER BY max(size_order), siz

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	3.141.35.69
Referrer	https://shopgeigers.com/women/browse/size/13,12,11,4,3,6_5/page/3
Date/Time	16-Dec-24 02:40 PM

Stack Trace

at cfsidenav2ecfm527733393._factor14(E:/websites/GeigersEcommerce/includes/sidenav.cfm:313) at cfsidenav2ecfm527733393._factor15(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfsidenav2ecfm527733393.runPage(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:80) at cfsidenav2ecfm527733393._factor14(E:/websites/GeigersEcommerce/includes/sidenav.cfm:313) at cfsidenav2ecfm527733393._factor15(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfsidenav2ecfm527733393.runPage(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:80)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 170) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	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.dda3.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:1485)
	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 cfsidenav2ecfm527733393._factor14(E:\websites\GeigersEcommerce\includes\sidenav.cfm:313)
	at cfsidenav2ecfm527733393._factor15(E:\websites\GeigersEcommerce\includes\sidenav.cfm:1)
	at cfsidenav2ecfm527733393.runPage(E:\websites\GeigersEcommerce\includes\sidenav.cfm:1)
	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:80)
	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)