Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Issue when updating products. SQL error
 
seikenn
Jr. Member
 
Total Posts:  5
Joined:  2008-12-16
 

I am getting this error when i attempt to edit products in my catalog. I can add product with no issue but once they are in i can not edit them.

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`candcdb01/catalog_category_product_index`, CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_CATEGORY_ENTITY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DEL)

I am using version 1.1.8 on *nix set up

Thanks for the help in advance

 
Magento Community Magento Community
Magento Community
Magento Community
 
Cutekidmax
Jr. Member
 
Total Posts:  1
Joined:  2009-01-09
 

Same error message here. I can’t go back in and edit a product.

Help!!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top