magento index manager 报错，不能index的终极解决方案

乱起八糟设置一顿，回头发现index manager不能index了，

解决办法：

1

Make sure, that the var/locks folder is writable

Make sure, that the var/locks folder is writable

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. ) - See more at: http://www.expertwebadvisor.com/cannot-initialize-the-indexer-process-in-index-management-in-magento/#sthash.QP9RRE9C.dpuf

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. ) - See more at: http://www.expertwebadvisor.com/cannot-initialize-the-indexer-process-in-index-management-in-magento/#sthash.QP9RRE9C.dpuf

var/locks确认是可写的

2

清空var/locks文件夹下面的所有文件，重新index 试试，如果还是不可以的话，执行第三部

3

执行前，先备份数据库

执行代码为：

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 cpop INNER JOIN catalog_product_option AS cpo ON cpo.option_id = cpop.option_id WHERE cpo.type = 'checkbox' OR cpo.type = 'radio' OR cpo.type = 'drop_down'; DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp INNER JOIN catalog_product_option_type_value AS cpotv ON cpotv.option_type_id = cpotp.option_type_id INNER JOIN catalog_product_option AS cpo ON cpotv.option_id = cpo.option_id WHERE cpo.type <> 'checkbox' AND cpo.type <> 'radio' AND cpo.type <> 'drop_down'

然后执行index 试试，如果还是不可以，执行第四步

4

使用官方工具修复表：

修复之后，然后index就可以了。