Magento: Category Flat Data reindex时General error: 1005错误解决

在magento进行Category Flat Data索引有呾,并出现如下错误内容:
‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[HY000]: General error: 1005 Can’t create table ‘xxx catalog_category_flat_store_1.frm’ (errno: 150)’ in xxx/lib/Zend/Db/Statement/Pdo.php:234

解决方法:
在phpMyAdmin中运行如下:
ALTER TABLE catalog_category_entity ENGINE=INNODB
ALTER TABLE core_store ENGINE=INNODB

标签