Error Executing Database Query.
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 18
|
|
The error occurred in C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 1141
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 1122
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 616
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 396
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 1
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 1141
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 1122
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 616
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 396
Called from C:/home/angelusblock.com/wwwroot/returns/product_detail.cfm: line 1
|
1139 : LEFT OUTER JOIN relate_product_config_feature
1140 : ON relate_display_products.product_id = relate_product_config_feature.product_id
1141 : WHERE relate_display_products.product_id = #p_co.product_id#
1142 : LIMIT 1;
1143 : </cfquery>
|
|
sqlState |
42000 |
exceptions |
<small><i>not set</i></small> |
datasource |
angelus2 |
vendorErrorCode |
1064 |
sql |
SELECT
relate_display_products.display_id,
relate_display_products.product_id,
IFNULL(relate_product_wall.architecture_wall_id, 0) AS wall_id,
IFNULL(relate_product_texture.texture_id, 0) AS texture_id,
IFNULL(product_details.des_ftr, 0) AS des_ftr,
IFNULL(relate_product_config_feature.feature_id, 0) AS feature_id
FROM relate_display_products
LEFT OUTER JOIN relate_product_wall
ON relate_display_products.product_id = relate_product_wall.product_id
LEFT OUTER JOIN relate_product_texture
ON relate_display_products.product_id = relate_product_texture.product_id
LEFT OUTER JOIN product_details
ON relate_display_products.product_id = product_details.product_id
LEFT OUTER JOIN relate_product_config_feature
ON relate_display_products.product_id = relate_product_config_feature.product_id
WHERE relate_display_products.product_id =
LIMIT 1; |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.222.167.36 |
Referrer |
http://www.angelusblock.com/returns/product_detail.cfm?cr=2+&design_id=0&display_id=289&feature_id=0&pc=1&related=243&return_id=11&texture_id=6&use_id=0&wall_id=0 |
Date/Time |
16-Jul-24 11:10 AM |
|