Cannot initialize the indexer process in Index Management In Magento
来源:互联网 发布:联想电脑淘宝旗舰店 编辑:程序博客网 时间:2024/05/31 15:18
Some times when you are trying to Reindex the product data through the Magento Admin Panel it displays the Error “Cannot initialize the indexer process.”. I have done more Research on it and on the basis of the Reasearch I have founded some solution regarding this. You can get rid of this problem by using the solutions given below:
Step 1. Make sure, that the var/locks folder is writable
Step 2. Delete all the .locks file from the var/locks and then try to reindex the data again if it works then it is OK otherwise follow the steps below
Step 3. Run the following MySQL Queries through the PHPMyadmin (Before running these commands take backup of database before running the SQL query. )
ALTER TABLE catalog_category_entity ENGINE=INNODB;ALTER TABLE core_store ENGINE=INNODB;DELETE FROM catalog_category_product_index;DELETE cpop.* FROM catalog_product_option_price AS cpopINNER JOIN catalog_product_option AS cpoON cpo.option_id = cpop.option_idWHEREcpo.type = 'checkbox' ORcpo.type = 'radio' ORcpo.type = 'drop_down';DELETE cpotp.* FROM catalog_product_option_type_price AS cpotpINNER JOIN catalog_product_option_type_value AS cpotvON cpotv.option_type_id = cpotp.option_type_idINNER JOIN catalog_product_option AS cpoON cpotv.option_id = cpo.option_idWHEREcpo.type <> 'checkbox' ANDcpo.type <> 'radio' ANDcpo.type <> 'drop_down'
Now try to reindex the data from the Magento admin Panel. If it is reindexed all the data successfully then it is Ok otherwise repairing the database. For repairing the database you can download the repairing tool from HERE
Hope this will help to someone.
- Cannot initialize the indexer process in Index Management In Magento
- magento - Cannot initialize the indexer process
- magento的Cannot initialize the indexer process解决方法
- magento 出现“ Cannot initialize the indexer process ”错误的解决方法
- magento无法索引 Cannot initialize the indexer process
- Maganto错误-Cannot initialize the indexer process的解决方法
- Maganto错误-Cannot initialize the indexer process的解决方法
- Maganto错误-Cannot initialize the indexer process的解决方法
- Category Flat Data - Can’t initialize indexer process magento
- Process management in Linux
- the Indexer(索引器) in C#
- Process Order API In Order Management
- Multiparameter Indexer in C#
- 【原】Cannot find entry file index.ios.js [index.android.js] in any of the roots
- understanding in the memory management in C#
- Somethings about the Process in the Linux
- Emerging Methods, Technologies and Process Management in Software Engineering
- The RealPlayer install process in Ubuntu
- 设计模式之六大原则——依赖倒置原则(DIP)
- LNMP(linux+nginx+mysql+php)服务器环境配置
- Asp.net页面中调用soapheader进行验证的操作步骤
- java对cookie的操作
- 关于编码
- Cannot initialize the indexer process in Index Management In Magento
- 设计模式之六大原则——接口隔离原则(ISP)
- Fragment的生命周期
- 树——二叉树的前续遍历(非递归)
- java.lang.RuntimeException: Unable to stop activity {com.borqs.musicdemo/com.borqs.musicdemo.MainAct
- PAT1017. Queueing at Bank
- 分布式数据库DDB introduce
- 一个神奇的网站
- 在Android下使用jni