Magento Coding Solutions

Database server does not support the InnoDB storage engine when i install magento


location : app\code\core\Mage\Install\Model\Installer\Db\Mysql4.php

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

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

No comments:

Post a Comment