无法索引问题(Cannot initialize the indexer process

在处理商品时往往操作人员不会注意提示,一般情况会有两个提示一是Index Management再就是cache缓存提示(Cannot initialize the indexer process) ,magetno有一点不好,不能索引出现个提示就不知道怎么去操作了,尝试了几种方式还是不是,整整36小时过去了,但结果不负有心人终于找到方式

在用ssh 命令索引时发现

Product Flat Data index process unknown error:
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sprayfoa_store`.<result 2 when explaining filename '#sql-66c_ab044'>, CONSTRAINT `FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity`)' in /home/sprayfoa/public_html/store/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:

........
最后的处理方式

found a way to fix my own problem.  
Using phpMyAdmin locate the catalog_product_flat_1 table in your Magento database. Then Empty (Truncate) that table, then using the indexer.php script in the shell directory in the root of your Magento install, reindex the Catalog Search Index through SSH.
The command should look like this once you are in the 'shell' directory php indexer.php --reindex catalogsearch_fulltext
发表评论
Magento2 技术支持 上门服务

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