magento index manager 报错,不能index的终极解决方案
来源:互联网 发布:软件项目建议书模板 编辑:程序博客网 时间:2024/05/17 08:43
乱起八糟设置一顿,回头发现index manager不能index了,
解决办法:
1
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 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
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就可以了。
- magento index manager 报错,不能index的终极解决方案
- 报错:非法操作index
- eclipse创建maven工程的时候index.jsp报错解决方案
- magento 通过命令行index的方法
- magento index.php 404
- CI框架如何删除URL中index.php的终极解决方案
- CI框架如何删除URL中index.php的终极解决方案
- Magento Index Management建立索引速度慢解决方案
- mac下xampp+thinkphp运行htdocs文件夹下所建项目index.php报错的解决方案
- 在onfancy index 价格时候报错的处理
- PHP Undefined index报错的修复方法
- Maven项目下的index.jsp文件报错
- Magento怎么去掉index.php
- PHP http://localhost:63342/untitled1/index.php/Home URL格式访问不到报404 的解决方案
- PHP http://localhost:63342/untitled1/index.php/Home URL格式访问不到报404 的解决方案
- mysql不能使用index的问题
- PHP Notice: Undefined index: ... 问题的解决方案
- Notice: Undefined index: ... 问题的解决方案
- hbase常去学习网站
- 浅谈JDBC
- 指令周期 机器周期 状态周期 振荡时钟周期(时钟周期)
- Hadoop调度类图
- 关于quartus II 13.1 的USB-Blaster和ModelSim-Altera 10.1d的问题
- magento index manager 报错,不能index的终极解决方案
- 7 Android 日期与时间控件
- 刚子扯谈:广告向东 客户向西
- ExpandableListView实例
- bash多行注释
- RMQ的ST算法学习小记 Poj 3264 Balanced Lineup
- 你的SQL2000有一天突然启动不了了,总找不到原因
- unicode与UTF8
- 浏览器的工作原理:新式网络浏览器幕后揭秘{转}