InnoDB工作正常，仍显示“数据库服务器不支持InnoDB存储引擎消息". [英] InnoDB working, still showing "Database server does not support InnoDB storage engine message"

问题描述

我正在尝试使用WAMP在本地服务器上安装Magento. InnoDB设置为默认引擎，但仍显示以下消息:

I'm trying to install Magento on a local server using WAMP. InnoDB is set as the default engine but it still shows me the message:

数据库服务器不支持InnoDB存储引擎.

Database server does not support InnoDB storage engine.

我真的不知道该怎么办.有人可以帮忙吗?

I really don't know what to do. Can someone help?

推荐答案

转到文件app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

Go To Line 59 of the file app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

替换:

public function supportEngine()
{
    $variables  = $this->_getConnection()
        ->fetchPairs('SHOW VARIABLES');
    return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;
}

与此:

public function supportEngine()
{
    $variables  = $this->_getConnection()
        ->fetchPairs('SHOW ENGINES');
    return (isset($variables['InnoDB']) && $variables['InnoDB'] != 'NO');
}

这篇关于InnoDB工作正常，仍显示“数据库服务器不支持InnoDB存储引擎消息".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！