{"id":4553,"date":"2019-01-29T21:42:06","date_gmt":"2019-01-29T21:42:06","guid":{"rendered":"http:\/\/www.deuzebranaweb.com.br\/?p=4553"},"modified":"2019-01-29T21:42:06","modified_gmt":"2019-01-29T21:42:06","slug":"erro-a-pos-migracao-de-centos-6-para-centos-7","status":"publish","type":"post","link":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/2019\/01\/29\/erro-a-pos-migracao-de-centos-6-para-centos-7\/","title":{"rendered":"Erro a p\u00f3s migra\u00e7\u00e3o de Centos 6 para Centos 7."},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Incompat\u00edvel com sql_mode = only_full_group_by [Fix]<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">erro = This is incompatible with sql_mode=only_full_group_by cpanel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">solu\u00e7\u00e3o:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Hospedagem Compartilhada<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Se voc\u00ea estiver em uma hospedagem compartilhada, n\u00e3o poder\u00e1 alterar o&nbsp;<code>sql_mode<\/code>n\u00edvel de ambiente.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"remove-only-full-group-by-in-my-cnf-file\">Remover&nbsp;&nbsp;<code>ONLY_FULL_GROUP_BY<\/code>&nbsp;no&nbsp;<code>my.cnf<\/code>arquivo<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se voc\u00ea tiver acesso ao arquivo de configura\u00e7\u00e3o do MySQL&nbsp;<code>my.cnf<\/code>, abra o arquivo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># vim \/etc\/mysql\/my.cnf<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">e adicione a linha abaixo ao final do arquivo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[mysqld]  \n sql_mode = \"STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Reinicie o servi\u00e7o MySQL:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># systemctrl restart mysql<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Desativar ONLY_FULL_GROUP BY<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Isso desativar\u00e1 o ONLY_FULL_GROUP_BY para TODOS os usu\u00e1rios do sistema.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"remove-only-full-group-by-in-whm-cpanel\">Remover&nbsp;&nbsp;<code>ONLY_FULL_GROUP_BY<\/code>em WHM \/ cPanel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se o seu dom\u00ednio estiver em um cPanel (Hospedagem Compartilhada), voc\u00ea precisa entrar em contato com o seu provedor de hospedagem para atualizar o mesmo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Se voc\u00ea tem acesso a WHM, em seguida, acessar&nbsp;<code>PHPMyAdmin&nbsp;<\/code>sob&nbsp;<code>SQL Services<\/code>a partir WHM como mostrado abaixo:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/techglimpse.com\/wp-content\/uploads\/2018\/10\/whm-phpmyadmin-access.jpg\" alt=\"whm acesso phpmyadmin\" class=\"wp-image-41090\"\/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Clique no&nbsp;<code>Variables&nbsp;<\/code>menu e procure por<code>SQL_MODE<\/code><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/techglimpse.com\/wp-content\/uploads\/2018\/10\/phpmyadmin-sql_mode.jpg\" alt=\"SQl_MODE no phpmyadmin\" class=\"wp-image-41091\"\/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Clique no bot\u00e3o de edi\u00e7\u00e3o e troque de remover&nbsp;<code>ONLY_FULL_GROUP_BY<\/code>.&nbsp;Uma vez editado, clique em&nbsp;&nbsp;<code>save<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/techglimpse.com\/ncompatible-with-sql_modeonly_full_group_by\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Incompat\u00edvel com sql_mode = only_full_group_by [Fix] erro = This is incompatible with sql_mode=only_full_group_by cpanel solu\u00e7\u00e3o: Hospedagem Compartilhada Se voc\u00ea estiver em uma hospedagem compartilhada, n\u00e3o poder\u00e1 alterar o&nbsp;sql_moden\u00edvel de ambiente. Remover&nbsp;&nbsp;ONLY_FULL_GROUP_BY&nbsp;no&nbsp;my.cnfarquivo Se voc\u00ea tiver acesso ao arquivo de configura\u00e7\u00e3o do MySQL&nbsp;my.cnf, abra o arquivo: #&#8230;<\/p>\n","protected":false},"author":2,"featured_media":4554,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_angie_page":false,"page_builder":"","footnotes":""},"categories":[13,19],"tags":[],"class_list":["post-4553","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-msql","category-whmcapenel"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=4553"}],"version-history":[{"count":0,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4553\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/media\/4554"}],"wp:attachment":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}