問題描述

在安裝過程中，Magento 產生以下錯誤:

數據庫服務器不支持 InnoDB 存儲引擎.

我已經修復了 Magento 的所有依賴項，并在命令行上使用 SHOW ENGINES 對 MySQL 進行了雙重檢查，并且肯定有 InnoDB 可用(也是默認存儲引擎).

這不是訪問 MySQL 配置的問題，其他人在安裝時可能已經看到.

注意:這是在 Mac Pro 上運行的(對我正在開發的域名進行了簡單的主機 DNS 重寫).

文件第59行app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

替換:

公共函數 supportEngine(){$variables = $this->_getConnection()-> fetchPairs('顯示變量');return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ?假:真；}

這樣:

公共函數 supportEngine(){$variables = $this->_getConnection()-> fetchPairs('顯示引擎');返回 (isset($variables['InnoDB']) && $variables['InnoDB'] != 'NO');}

During installation, Magento produces the following error:

Database server does not support the InnoDB storage engine.

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).

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

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

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

Replace:

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

with this:

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

這篇關于Magento 安裝抱怨 InnoDB 可用時丟失的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！