Magento install complains about missing InnoDB when it is available

Question

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

Just to confirm, have just created the following test table: +---------------+--------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------------+--------------------------------------------------------------------------------------------------------------+ | mystoragetest | CREATE TABLE `mystoragetest` ( `tester` int(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +---------------+----- — Giles Williams, Mar 15 '13 at 23:05

score 134 · Accepted Answer · edited Nov 30 '17 at 07:17

134

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');
}

edited Nov 30 '17 at 07:17

Siarhey Uchukhlebau

834
14
18

answered Mar 15 '13 at 23:10

Michael Benjamin

2,895
1
16
18

Nice one, spent the last hour trying to figure this out – Daniel West May 06 '13 at 19:23
1

bad idea to edit core code, check answer below: http://stackoverflow.com/a/16870033/299774 – Greg Jun 25 '13 at 10:54
This change is part of the master branch at magento2, so I don't think it's going to be an issue! https://github.com/magento/magento2 – Dennis Jul 05 '13 at 13:20
Thank you so much! I fought this fore a few hours! – Jpepper Aug 19 '13 at 16:31
what if it doesn't help with the magento 1.9.2.0 as the code update mentioned here is already fixed in this version – Ashwani Shukla Jan 21 '16 at 12:17

Rokko_11 · Answer 2 · 2013-08-27T18:47:05.880

Or don't do a core-hack! You should override the Installer-Model softly before Installation:

Paste this in your app/code/local/Company/InstallBugfix/etc/config.xml:

<?xml version="1.0"?>
<config>
    <modules>
        <Company_InstallBugfix>
            <version>0.1.0</version>
        </Company_InstallBugfix>
    </modules>
    <global>
        <models>
            <installbugfix>
                <class>Company_InstallBugfix_Model</class>
            </installbugfix>
            <install>
                <rewrite>
                    <installer_db_mysql4>Company_InstallBugfix_Model_Installer_Db_Mysql4</installer_db_mysql4>
                </rewrite>
            </install>
        </models>
    </global>
</config>

And following in app/code/local/Company/InstallBugfix/Model/Installer/Db/Mysql4.php:

<?php
class Company_InstallBugfix_Model_Installer_Db_Mysql4 extends Mage_Install_Model_Installer_Db_Mysql4
{
    /**
     * Check InnoDB support
     *
     * @return bool
     */
    public function supportEngine()
    {
        $supportsEngine = parent::supportEngine();
        if ($supportsEngine) {
            return true;
        }
        $variables = $this
                     ->_getConnection()
                     ->fetchPairs('SHOW ENGINES');
        return (isset($variables['InnoDB']) && $variables['InnoDB'] != 'NO');
    }
}

And enable the extension. The advantage is, that the old validation is still correct, if the mysql-version is older.

Re "Don't do a core hack" ~ True ... however, the core dev team should be responsible for backporting compat... — Edward J Beckett, Jul 13 '15 at 01:13

score 5 · Answer 3 · edited Jun 20 '20 at 09:12

ver 1.9.1.0 downloader.php

Putting this up for anyone thats using the downloader.php currently bundled in the 1.9.1.0 installer.

If you're happy that your MySQL Database does support InnoDB (It's the DEFAULT) in later versions. You can safely edit the file to remove the check and all the download to take place.

    /**
     * Check availabe InnoDB on database.
     *
     * @return Magento_Downloader_Validator
     */
    protected function _checkDbInnoDb()
    {
        if (!$this->_connection) {
            return $this;
        }
        $this->addMessage('Database server supports InnoDB storage engine');
        return $this;
    }

score 0 · Answer 4 · answered Sep 30 '13 at 06:19

0

Bug was fixed in Magento CE 1.8, so just use the lines above for CE \leq 1.7

answered Sep 30 '13 at 06:19

Rokko_11

837
2
10
24

Given it's just the `protected function _checkDbInnoDb()` function that still throws this error in `downloader.php` If you're confident your Database does support InnoDB - You can safely comment out the check. – Luke Jul 26 '17 at 00:22

score -1 · Answer 5 · edited Jun 06 '15 at 11:25

-1

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

edited Jun 06 '15 at 11:25

Xaver Kapeller

49,491
11
98
86

answered Apr 29 '15 at 13:14

anthony

1
1

score -1 · Answer 6 · answered May 30 '16 at 20:43

I was having the same issue and the only way it worked was when I changed Line 59 of the file app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php from:

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'] != 'YES');
    }

And I didn't find it anywhere so if you are struggling I guarantee this will solve it.

Magento · Answer 7 · 2015-06-06T11:47:54.580

-2

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['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true; 
*/
    return 1;
}

edited Jun 06 '15 at 11:47

answered Jun 06 '15 at 06:55

Magento

109
2

1

why do you bother to change the `fecthPairs` line if you are returning **true** anyway just after? – OSdave Jun 06 '15 at 09:59
This is a bad idea, maybe even dangerous. You're suggesting we pretend InnoDB is always enabled, rather than actually checking. – Doug McLean Feb 04 '16 at 10:15

Magento install complains about missing InnoDB when it is available

7 Answers7

ver 1.9.1.0 downloader.php

Linked