magento 1.8 产品索引更新报错问题修复

最新推荐文章于 2022-10-22 15:11:58 发布

木子耗2009

最新推荐文章于 2022-10-22 15:11:58 发布

阅读量321

点赞数

分类专栏：死磕Magento

本文链接：https://blog.csdn.net/u011628250/article/details/80354100

版权

当在Magento 1.8中遇到产品索引更新时遇到错误，可以添加$e->getMessage()来查看具体错误信息。错误显示为SQL约束违反问题，涉及到外键约束。解决方案是执行特定的SQL查询来解决这个问题。

摘要由CSDN通过智能技术生成

把更新失败的索引，加$e->getMessage() ,看看具体报什么错误

exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`your_database_name`.`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 CASCADE)’ in . ..\lib\Zend\Db\Statement\Pdo.php:228

Here is the solution.

You can execute these queries:

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 (