Skip to content

Instantly share code, notes, and snippets.

@markshust
Last active December 23, 2015 04:39
Show Gist options
  • Save markshust/6581521 to your computer and use it in GitHub Desktop.
Save markshust/6581521 to your computer and use it in GitHub Desktop.
Magento - MySQL 5.6 InnoDB fix
diff --git a/app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php b/app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php
index bc482b5..ebd5875 100644
--- a/app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php
+++ b/app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php
@@ -59,7 +59,7 @@ class Mage_Install_Model_Installer_Db_Mysql4 extends Mage_Install_Model_Installe
public function supportEngine()
{
$variables = $this->_getConnection()
- ->fetchPairs('SHOW VARIABLES');
- return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;
+ ->fetchPairs('SHOW ENGINES');
+ return (isset($variables['InnoDB']) && $variables['InnoDB'] != 'NO');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment