Magento安装抱怨InnoDB可用时丢失 [英] Magento install complains about missing InnoDB when it is available

问题描述

在安装过程中，Magento产生以下错误:

During installation, Magento produces the following error:

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

Database server does not support the InnoDB storage engine.

我已经修复了Magento的所有依赖关系，并使用SHOW ENGINES在命令行上使用MySQL进行了仔细检查，并且肯定有InnoDB可用(也是默认的存储引擎).

I've fixed all the dependancies for Magento, and double checked with MySQL on the command line using SHOW ENGINES and definitely have InnoDB available (also the default storage engine).

这不是其他人在安装时可能会看到的有关访问MySQL配置的问题.

This isn't an issue about access to MySQL config which others might have seen on their install.

注意:这是在Mac Pro上运行的(对我要开发的域名使用简单的主机DNS重写).

Note: This is running on a Mac Pro (with a simple hosts DNS rewrite for the domain name I am developing for).

推荐答案

文件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');
}

这篇关于Magento安装抱怨InnoDB可用时丢失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！