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, 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

Magento Forum

Reindex problem with product attribute index
Total Posts:  34
Joined:  2009-07-12

Hi there,

I am searching for this problem for the whole day now since I am not really willing to make a new post.
But it may also help some other guys who also may have this problem.
I found basically the same problem here:
But none of the suggestions fixed my problem.

This is what I did:
Updated the Database from to without a problem. Rebuilt the indexes via SSH and the attribute index failed with the message:

Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento`.`catalog_product_index_eav`, CONSTRAINT `FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCAD)\’

Then I tried to fix this with the database repair tool which fixed a few constraints and I thought this problem might be solved. But it wasn\’t.

Now I read about some SQL statements for category index errors and thought I would be able to transfer those to the attribute index but I didn\’t - the hints came from here:

When trying to rebuild the constraints in SQL with ALTER TABLE and ADD CONSTRAINTS etc… phpmyadmin gives the error that it can\’t write some table…

If I am telling magento not to show products with no stock, the index rebuilt works. But I would need to show products which are not in stock also wink.

I don\’t really know what to do in this case… and I would be very pleased if anyone could help…
All the best,

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