FIX for “Database server does not support the InnoDB storage engine” in Magento

Copy the file:
app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

Past it here(notice the only difference is core and local directory, if you don’t have the directory, just create it):
app/code/local/Mage/Install/Model/Installer/Db/Mysql4.php

Open the file you just pasted, go to line around 60, 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');
    }

Search within Codexpedia

Custom Search

Search the entire web

Custom Search