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

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

木子耗2009

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

阅读量363

点赞数

CC 4.0 BY-SA版权

分类专栏：死磕Magento

本文链接：https://blog.youkuaiyun.com/u011628250/article/details/80354100

死磕Magento 专栏收录该内容

40 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

把更新失败的索引，加$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 (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);


After that you need to re-index data again. The issue should disappear.

如果是关于 Index product prices 这个错误的请关注下这个表格 catalog_product_entity_group_price

索引出错，多半是迁移网站的时候，清空产品的相关表的时候 不够彻底 或者遗漏一些数据未清！！
如果 Product Flat Data 无法更新 请执行SQLdelete FROM `catalog_product_flat_1` where entity_id not in (select entity_id from catalog_product_entity);