In case when you add to cart the product that triggers adding a free promotional item, the following error occures:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or
update a child row: a foreign key constraint fails
(`zadmin_winetalk`.`sales_flat_quote_item_option`, CONSTRAINT
`FK_5F20E478CA64B6891EA8A9D6C2735739` FOREIGN KEY (`item_id`)
REFERENCES `sales_flat_quote_item` (`item_id`) ON DELETE CASCADE ON U)
there is a conflict with a 3-d party extension that works with shopping carts.
Solution:
Data Base request:
ALTER TABLE `sales_flat_quote_item_option` DROP FOREIGN KEY `FK_5F20E478CA64B6891EA8A9D6C2735739`
Didn’t you find the answer to your question? We are always happy to help you out.
We use cookies to help improve our services, make personal offers, and enhance your experience. If you do not accept optional cookies below, your experience may be affected. If you want to know more, please read the Cookie Policy
Please select and accept your Cookies Group
| Cookie Name | Cookie Provider | Cookie Description | Cookie Lifetime | Cookie Type |
|---|---|---|---|---|
Login and Registration Form