又一个问题纠缠了洒家好几天,今天终于找到解决办法,顿时如拨云见日。
问题描述:
就是magrnto刷新index的时候 出现Cannot initialize the indexer process.
用SSH刷新的时候会报错:
这样就导致了一个问题,站内搜索功能没法用:
还有可能出现一些其他的问题,你说悲催不悲催?
查看数据库,却是是有个很屌丝的表无法创建,不懂程序的你,伤不起啊~~~
废话不多说,直接说解决办法:
在数据库中运行一下代码:
ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;
ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;
然后删除 var/locks文件夹下的所有文件,
然后再去刷新吧:
[~/public_html/shell]# php indexer.php reindexall
Product Attributes index was rebuilt successfully
Product Prices index was rebuilt successfully
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index was rebuilt successfully
Category Products index was rebuilt successfully
Catalog Search Index index was rebuilt successfully
Stock Status index was rebuilt successfully
Tag Aggregation Data index was rebuilt successfully
不行你找哥,哥来给你弄,哈哈