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`
See more details on Auto Add Promo Items page
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