Mar 13, 2014
85 Views

[Magento] Sửa Lỗi Database server does not support InnoDB storage engine.

Written by

Go To 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

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

 

Article Tags:
·
Article Categories:
Code/Web
    http://linholiver.com

    https://linholiver.com/diary/about/