Search
×
Log in or create an account
If you have an account with us, please log in.

You have no items in your shopping cart.

Frequently Asked Questions

How can we help you?

banner image

When I add to cart the product that triggers adding a free promotional product, the error occurs.

See more details on Auto Add Promo Items page
User Guide

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
User Guide
Rate the answer?

Total rating: 3.8

If you didn’t find the answer on your question, please, ask here:

Back to top