Database Import Constraint Fail – Magento 1.9 Solution

databasemagento-1.9MySQL

I've got a working Magento website hosted on a development server but I've decided to take a local copy to make it easier to work on.

I've downloaded the source files and imported the database. All looks to be working perfectly, I can see all of my products and I can't see any problems – but during this import, I noticed this error:

My.Name@NETWORK c:\xampp\htdocs\website
# mysql -u root database < database.sql
ERROR 1452 (23000) at line 415010: Cannot add or update a child row: a foreign key constraint fails (`database`.`#sql-be4_32`, CONSTRAINT `FK_CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE )

Will this error have stopped certain data from being imported. Everything at the moment looks fine and ideally I would like to continue and ignore the error – but I don't want it to bite me in days/weeks to come!

Best Answer

You are trying to add a record into catalog_eav_attribute, but you do not have a corresponding record in eav_attribute that matches on attribute_id

If you are also inserting bulk data into eav_attribute, I would recommend doing that first, and then the data would be in the table before the foreign key on catalog_eav_attribute needed to reference it.

This article discusses how you can use:

SET FOREIGN_KEY_CHECKS = 0; --Do your update here SET FOREIGN_KEY_CHECKS = 1;

If you cannot change the order that you are inserting data. You just have to make sure your data follows the Foreign Keys once everything has been inserted into the database, before you can re-enable the FOREIGN_KEY_CHECKS

Source: https://stackoverflow.com/a/8306636

Related Solutions

Magento 1.9 – Fix Reindex Error

Well I think your issue is due to the products which are creating hindrance in the Index process.

You have to run the below queries for re-indexing to work:

delete FROM `catalog_product_entity_datetime` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_decimal` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_gallery` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_group_price` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_int` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_media_gallery` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_text` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_tier_price` where entity_id not in (select entity_id from catalog_product_entity);
delete FROM `catalog_product_entity_varchar` where entity_id not in (select entity_id from catalog_product_entity);
#originals with formatting fixed:
delete from `catalog_category_product` WHERE product_id not in(select entity_id from catalog_product_entity);
delete from `catalog_category_product` WHERE category_id not in(select entity_id from catalog_category_entity); 
delete from `catalog_product_website` WHERE product_id not in(select entity_id from catalog_product_entity); 
delete from `catalog_product_index_eav_idx` WHERE entity_id not in(select entity_id from catalog_product_entity); 
delete from `catalog_product_index_eav` WHERE entity_id not in(select entity_id from catalog_product_entity); 
delete from `catalog_product_link` WHERE product_id not in(select entity_id from catalog_product_entity); 
delete from `catalog_product_relation` WHERE parent_id not in(select entity_id from catalog_product_entity);

Hope this helps you out

Magento – Integrity constraint error referring to quote_item table while adding product to cart

I ran into the same problem when i tried to change data on quote items with the checkout_cart_product_add_after event. This event is fired after every product add, but before the cart is saved. Check the Magento\Checkout\Controller\Cart\Add line 108-113 for reference. So if you want to save the quote item on a new session there is no quote yet and there is no quote_id to reference to.

In my case, i just left the $item->save(); out, because it will be saved afterwards automatically.

Best Answer

Related Solutions

Magento 1.9 – Fix Reindex Error

Magento – Integrity constraint error referring to quote_item table while adding product to cart

Related Topic