Magento 1.6.2 不会重新索引产品平面数据
我无法再让 magento 正确地重新索引，因为它指出重新索引过程存在问题。我已使用 SSH 访问来尝试手动重新索引数据。使用 SSH 访问时我看到错误，但不确定如何解决下面的错误日志。
'pdoexception' with message 'SQLSTATE [23000] : Intergrity constraints violation; 1452 cannot add or update a child row: a foreign key constraint fails ....... <result 2 when explaing filename '#sql-c45_91e313'>, CONSTRAINT 'FK_MAGE_MAGE_CAT_PRD_FLAT_1_ENTT_ID_MAGE_CAT_PRD_ENTT_ENTT_ID' FOREIGN KEY ('entity_id') REFERENCES 'mage_ca)' in home/.../public_html/lib/Zend/Db/Statement/Pdo.php:228
任何帮助将不胜感激
I can no longer get magento to reindex correctly as it states there was a problem with the reindexing process. I have used SSH access to try and manually reindex the data. Using SSH access i see the error but unsure as to how to resolve the error log is below.
'pdoexception' with message 'SQLSTATE [23000] : Intergrity constraints violation; 1452 cannot add or update a child row: a foreign key constraint fails ....... <result 2 when explaing filename '#sql-c45_91e313'>, CONSTRAINT 'FK_MAGE_MAGE_CAT_PRD_FLAT_1_ENTT_ID_MAGE_CAT_PRD_ENTT_ENTT_ID' FOREIGN KEY ('entity_id') REFERENCES 'mage_ca)' in home/.../public_html/lib/Zend/Db/Statement/Pdo.php:228
Any help would be appreciated
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您是否尝试过禁用 Flat_catalog_category 和 Flat_catlaog_product，然后截断 Catalog_product_flat 表。请务必在截断之前通过执行
SET FOREIGN_KEY_CHECKS = 0;禁用外键约束检查。一旦这样做，您应该能够通过 ssh 手动重新索引。
此问题的详细记录解决方案如下： http://binarythoughts21 .blogspot.in/2013/12/reindexing-problems-in-magento.html
Have you tried disabling Flat_catalog_category and Flat_catlaog_product and then truncating the catalog_product_flat tables.Be sure to disable foreign key constraints checks by doing
SET FOREIGN_KEY_CHECKS = 0;before truncating.Once doing that you should be able to manually reindex via ssh .
A well documented solution for this issue is here : http://binarythoughts21.blogspot.in/2013/12/reindexing-problems-in-magento.html
尝试删除所有产品平面。它们将由索引器重新创建。
Try delete all product flat tables. They will be recreated by indexer.