magento 索引处理reindex catalog_category_product error

magento 因升级导致索引问题
Next Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mup2`.`catalog_category_product_index`, CONSTRAINT `FK_CAT_CTGR_PRD_IDX_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE) in D:\xampp\htdocs\m170\lib\Zend\Db\Statement\Pdo.php:234


索引处理reindex catalog_category_product error 最终找到了问题
DELETE FROM `catalog_category_product` WHERE category_id not in (select entity_id from catalog_category_entity)

发表评论
Magento2 技术支持 上门服务

工作时间
周一至周六
9:00-18:00
相关咨询电话
15360669780
侨海科技