{"id":4646,"date":"2013-02-27T14:59:10","date_gmt":"2013-02-27T17:59:10","guid":{"rendered":"https:\/\/king.host\/blog\/?p=4646"},"modified":"2024-06-04T10:11:28","modified_gmt":"2024-06-04T13:11:28","slug":"instalacao-do-magento-com-mysql-5-6-1","status":"publish","type":"post","link":"https:\/\/king.host\/blog\/tutoriais\/instalacao-do-magento-com-mysql-5-6-1\/","title":{"rendered":"Instala\u00e7\u00e3o do Magento com MySQL 5.6.1+"},"content":{"rendered":"

Colaborador: Luciano Marques | Analista de Redes<\/em><\/p>\n

A partir da vers\u00e3o 5.6.1 do MySQL, a vari\u00e1vel\u00a0have_innodb<\/em>\u00a0<\/strong>foi descontinuada (+info<\/a>). O \u00fanico problema \u00e9 que o Magento usava esta vari\u00e1vel para validar as configura\u00e7\u00f5es de banco de dados. Por este motivo, ao realizar uma nova instala\u00e7\u00e3o, o Magento acabava sempre exibindo a mensagem de erro:
\n<\/strong><\/p>\n

Database server does not support the InnoDB storage engine.<\/strong><\/p><\/blockquote>\n

Existem 2 alternativas para esta quest\u00e3o, uma delas \u00e9 comentar a fun\u00e7\u00e3o\u00a0supportEngine.<\/em><\/strong>\u00a0A outra \u00e9 fazer com que seja verificada de outra maneira se o servidor de banco de dados MySQL possui ou n\u00e3o o suporte a engine\u00a0InnoDB<\/strong>\u00a0ativo.<\/p>\n

A partir da vers\u00e3o\u00a01.6.0.0<\/strong>\u00a0do Magento, abra o seguinte arquivo:
\napp\/code\/core\/Mage\/Install\/Model\/Installer\/Db\/Mysql4.php<\/strong><\/p>\n

Pr\u00f3ximo a linha 59, procure pela fun\u00e7\u00e3o\u00a0supportEngine\u00a0<\/strong>e substitua isto:<\/p>\n

\n\n\n\n
\n
<\/div>\n<\/td>\n
\n
\n
public function supportEngine()<\/div>\n
\u00a0\u00a0\u00a0\u00a0{<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$variables\u00a0\u00a0= $this->_getConnection()<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0->fetchPairs(‘SHOW VARIABLES’);<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return (!isset($variables[‘have_innodb’]) || $variables[‘have_innodb’] != ‘YES’) ? false : true;<\/div>\n
\u00a0\u00a0\u00a0\u00a0}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n

Por isto:<\/p>\n

\n\n\n\n
\n
<\/div>\n<\/td>\n
\n
\n
public function supportEngine()<\/div>\n
\u00a0\u00a0\u00a0\u00a0{<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$engine\u00a0\u00a0= $this->_getConnection()<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0->fetchOne(‘SELECT Support FROM INFORMATION_SCHEMA.ENGINES WHERE Engine LIKE “innodb”‘);<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return (!isset($engine) || ($engine != ‘DEFAULT’ && $engine != ‘YES’)) ? false : true;<\/div>\n
\u00a0\u00a0\u00a0\u00a0}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n
Tamb\u00e9m disponibilizamos um zip contendo o arquivo modificado, basta descompactar no diret\u00f3rio raiz de instala\u00e7\u00e3o do Magento:\u00a0Clique aqui para fazer o download do ZIP contendo a corre\u00e7\u00e3o<\/a>.<\/div>\n","protected":false},"excerpt":{"rendered":"

A partir da vers\u00e3o 5.6.1 do MySQL, a vari\u00e1vel have_innodb foi descontinuada (+info), o \u00fanico problema \u00e9 que o Magento usava esta vari\u00e1vel para validar as configura\u00e7\u00f5es de banco de dados. Por este motivo, ao realizar uma nova instala\u00e7\u00e3o, o Magento acabava sempre exibindo a mensagem de erro:
\nDatabase server does not support the InnoDB storage engine.<\/p>\n","protected":false},"author":52,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[156],"tags":[],"class_list":["post-4646","post","type-post","status-publish","format-standard","hentry","category-tutoriais"],"_links":{"self":[{"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/posts\/4646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/comments?post=4646"}],"version-history":[{"count":1,"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/posts\/4646\/revisions"}],"predecessor-version":[{"id":38387,"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/posts\/4646\/revisions\/38387"}],"wp:attachment":[{"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/media?parent=4646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/categories?post=4646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/king.host\/blog\/wp-json\/wp\/v2\/tags?post=4646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}