Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 171) 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/functions/itemdetails.cfc: line 656
Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 81
Called from E:/websites/GeigersEcommerce/category.cfm: line 116
Called from E:/websites/GeigersEcommerce/functions/itemdetails.cfc: line 656
Called from E:/websites/GeigersEcommerce/includes/views/thumbnails.cfm: line 81
Called from E:/websites/GeigersEcommerce/category.cfm: line 116
|
654 : <cfif application.ALLOW_SHOW_OUT_OF_STOCK IS "NO" and not showOutOfStockSizes> AND e.qoh > 0</cfif>
655 : <cfif isDefined("arguments.attr1") and len(arguments.ATTR1) AND arguments.ATTR1 neq "NULL"> AND a.attr1_entry_id = #val(arguments.attr1)#</cfif>
656 : <cfif isDefined("arguments.attr2") and len(arguments.ATTR2) AND arguments.ATTR2 neq "NULL"> AND a.attr2_entry_id = #val(arguments.attr2)#</cfif>
657 :
658 : GROUP BY b.siz
|
|
SQLSTATE |
40001 |
DATASOURCE |
celerantSQL |
VENDORERRORCODE |
1205 |
SQL |
SELECT distinct(b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh+e.qc) as qoh
FROM tb_skus a
LEFT JOIN tb_size_entries b on (b.scale_entry_id = a.scale_entry_id)
LEFT JOIN tb_sku_buckets e on (e.sku_id = a.sku_id)
WHERE a.style_id = (param 1) and b.siz <> 'N/A'
GROUP BY b.siz
ORDER BY max(a.scale_entry_id)
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.137.220.241 |
Referrer |
https://shopgeigers.com/all-products/browse/size/m,xlt,ys,10,xl,18s,ss,8,as,0,sm,130,4s |
Date/Time |
02-Aug-24 02:41 PM |
|