php - Magento 语法错误或访问冲突 1286 未知表引擎 'InnoDB'

Question

我的 Magento 在线商店刚刚遇到问题。服务器:托管服务器 Strato

错误日志在这里:

    a:4:{i:0;s:85:"SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB'";i:1;s:2165:"#0 htdocs/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 htdocs/magento/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 htdocs/magento/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 htdocs/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 htdocs/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 htdocs/magento/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 htdocs/magento/lib/Varien/Data/Collection/Db.php(730): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 htdocs/magento/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 htdocs/magento/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 htdocs/magento/app/code/core/Mage/Core/Model/Resource/Store/Collection.php(174): Varien_Data_Collection_Db->load(false, false)
#10 htdocs/magento/lib/Varien/Data/Collection.php(752): Mage_Core_Model_Resource_Store_Collection->load()
#11 htdocs/magento/app/code/core/Mage/Core/Model/App.php(624): Varien_Data_Collection->count()
#12 htdocs/magento/app/code/core/Mage/Core/Model/App.php(466): Mage_Core_Model_App->_initStores()
#13 htdocs/magento/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Model_App->_initCurrentStore('', 'store')
#14 htdocs/magento/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#15 htdocs/magento/index.php(107): Mage::run()
#16 {main}";s:3:"url";s:17:"/en/buy-sell.html";s:11:"script_name";s:10:"/index.php";}

我不知道这个问题的问题和解决方案在哪里。前端白色/后端错误...

Answer 1

**** 在尝试之前先检查一下 ****

首先需要更换日志文件

问题，完全停止mysql:

/etc/init.d/mysql stop

然后移动文件

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak

在那个问题之后启动mysql备份

/etc/init.d/mysql start

InnoDB 默认启用，如果您的 InnoDB 日志文件损坏，MySQL 会自动禁用它。当您删除它们时，它们会重新创建，从而允许 InnoDB 重新启动。

试一试。