I am using Magento 2 website. I got the error like following when redirecting to checkout/cart page.
Once deleted all the products in cart and tried to add all the products again and its seems to be no error there.
May I know, what can be issue. I can't track the issue.
{"0":"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
stateofh_magento2
.quote_shipping_rate
, CONSTRAINTQUOTE_SHIPPING_RATE_ADDRESS_ID_QUOTE_ADDRESS_ADDRESS_ID
FOREIGN KEY (address_id
) REFERENCESquote_address
(address_id
) ON DELETE C), query was: INSERT INTOquote_shipping_rate
(address_id
,carrier
,carrier_title
,code
,method
,method_description
,price
,method_title
) VALUES (?, ?, ?, ?, ?, ?, ?, ?)","1":"#0 /chroot/home/stateofh/hockeylodge.com/html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array)\n#1 /chroot/home/stateofh/hockeylodge.com/html/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303):