Database server does not support InnoDB storage engine

[danjesch]

Hi,

i know this seems to be a well known bug, but i cant find a solution for Ver 1.9.X . I ran the magento checker, https://www.plusvitalis.de/shop/magento-check.php everything is fine. Hoster says its a problem of the installer script, the variable "have_innodb" doesnt exist anymore in mysql 5.6.1. Do you have a new installer script or a solution how i can fix this? i got the installer from official magento website.  thanks a lot

daniel

[danjesch]

Hello,

has anyone a solution for that? 

Thanks

Daniel

[Pronto]

Check out this page:

http://stackoverflow.com/questions/15443448/magento-install-complains-about-missing-innodb-when-it-i...

[ptomter]

@danjesch did you find a solution to your problem or did you use one of the solutions in the  link provided by @Pronto ? Looking farward to hear if this problem was solved and how.

[pinogrigio]

I'm having the same problem and the solution posted above doesn't work for me. Running out of ideas now.

[TutorialMagento]

Hello, you can fix this error by:

Open Mysql4.php file located in app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php and find:

 

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

Then replace with 

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

I did this for my Magento website and the error is gone. << Snipped >>