{"id":70237,"date":"2016-05-02T13:46:10","date_gmt":"2016-05-02T17:46:10","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=70237"},"modified":"2016-07-12T03:45:01","modified_gmt":"2016-07-12T07:45:01","slug":"magento-troubleshooter-how-to-deal-with-database-server-does-not-support-innodb-error","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/magento-troubleshooter-how-to-deal-with-database-server-does-not-support-innodb-error.html","title":{"rendered":"Magento Troubleshooter. How to deal with &#8220;Database server does not support InnoDB storage engine&#8221; error message"},"content":{"rendered":"<div class=\"video-container\">\r\n    <iframe src=\"https:\/\/www.youtube.com\/embed\/MGRGeDvIMns\"><\/iframe>\r\n<\/div>\r\n\r\n<p>This tutorial will show you how to detail with <strong>&#8216;Database server does not support the InnoDB storage engine&#8217;<\/strong> error message while installing Magento engine.<\/p>\r\n\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1-300x153.png\" alt=\"Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1\" width=\"300\" height=\"153\" class=\"alignnone size-medium wp-image-70238\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1-300x153.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1-150x76.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1-1024x522.png 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1.png 1173w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<p>Such issue is caused by a wrong MySQL version on the server. Usually, the issue occurs while installing <strong>Magento 1.7<\/strong> on the server with <strong>MySQL 5.6<\/strong>. <\/p>\r\n<p>With the solution below, this will no longer be a problem.<\/p>\r\n<ol>\r\n\t<li><p>Access your server using any <strong>ftp<\/strong> software or <strong>FileManager<\/strong> provided by your Host.<\/p><\/li>\r\n\t<li><p>Open <strong>&#8216;app\/code\/core\/Mage\/Install\/Model\/Installer\/Db\/Mysql4.php&#8217;<\/strong> file with any <strong>PHP\/Text<\/strong> editor:<\/p>\r\n\t<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2-300x175.png\" alt=\"Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2\" width=\"300\" height=\"175\" class=\"alignnone size-medium wp-image-70239\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2-300x175.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2-150x87.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2.png 775w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n\t<li>\r\n\t\t<p><strong>Replace<\/strong> the following part of the code:<\/p>\r\n\t\t<pre class=\"brush:php\">public function supportEngine()\r\n\t\t\t{\r\n\t\t\t$variables  = $this-&gt;_getConnection()\r\n\t\t\t-&gt;fetchPairs('SHOW VARIABLES');\r\n\t\t\treturn (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;\r\n\t\t}<\/pre>\r\n\t\t<p>with the code below: <\/p>\r\n\t\t<pre class=\"brush:php\">public function supportEngine()\r\n\t\t\t{\r\n\t\t\t$variables  = $this-&gt;_getConnection()\r\n\t\t\t-&gt;fetchPairs('SHOW ENGINES');\r\n\t\t\treturn (isset($variables['InnoDB']) &amp;&amp; $variables['InnoDB'] != 'NO');\r\n\t\t}<\/pre>\r\n\t<\/li>\r\n\t<li><p><strong>Save<\/strong> the file and <strong>refresh<\/strong> your website. <\/p><\/li>\r\n\t<li>\r\n\t\t<p>You can now start new Magento engine installation:<\/p>\r\n\t\t<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3-300x96.png\" alt=\"Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3\" width=\"300\" height=\"96\" class=\"alignnone size-medium wp-image-70240\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3-300x96.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3-150x48.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3-1024x327.png 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/05\/Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3.png 1137w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t<\/li>\r\n<\/ol>\r\n\r\n<p>An alternative solution for the issue would be contacting your hosting provider and asking to <strong>downgrade MySQL<\/strong> version on the server (if such option is available for your <strong>Hosting Plan<\/strong>). <\/p>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=MGRGeDvIMns?width=1280&amp;height=720\" rel=\"prettyPhoto\">Magento Troubleshooter. How to deal with &#8220;Database server does not support InnoDB storage engine message&#8221; error message<\/a>","protected":false},"excerpt":{"rendered":"<p>This tutorial will show you how to detail with <strong>&#8216;Database server does not support the InnoDB storage engine&#8217;<\/strong> error message while installing Magento engine.<\/p>\n","protected":false},"author":37,"featured_media":70244,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[729],"tags":[691,2407,785],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/70237"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=70237"}],"version-history":[{"count":0,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/70237\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/70244"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=70237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=70237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=70237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}