{"id":144,"date":"2021-03-04T21:38:50","date_gmt":"2021-03-04T19:38:50","guid":{"rendered":"https:\/\/shvek.com\/?p=144"},"modified":"2021-03-04T21:38:50","modified_gmt":"2021-03-04T19:38:50","slug":"mariadb-upgrade-from-5-5-to-10-5-breaks-sites-with-sql-error-column-no-default-value","status":"publish","type":"post","link":"https:\/\/shvek.com\/?p=144","title":{"rendered":"MariaDB Upgrade from 5.5 to 10.5 breaks Sites with SQL error &#8211; Column No Default Value."},"content":{"rendered":"\n<p>Added the below to my.ini<\/p>\n\n\n\n<p>sql-mode=&#8221;NO_ENGINE_SUBSTITUTION&#8221;<\/p>\n\n\n\n<p>Source of fix: <a href=\"https:\/\/www.farbeyondcode.com\/Solution-for-MariaDB-Field--xxx--doesn-t-have-a-default-value-5-2720.html\">https:\/\/www.farbeyondcode.com\/Solution-for-MariaDB-Field&#8211;xxx&#8211;doesn-t-have-a-default-value-5-2720.html<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Added the below to my.ini sql-mode=&#8221;NO_ENGINE_SUBSTITUTION&#8221; Source of fix: https:\/\/www.farbeyondcode.com\/Solution-for-MariaDB-Field&#8211;xxx&#8211;doesn-t-have-a-default-value-5-2720.html<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-144","post","type-post","status-publish","format-standard","hentry","category-technical"],"_links":{"self":[{"href":"https:\/\/shvek.com\/index.php?rest_route=\/wp\/v2\/posts\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shvek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shvek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shvek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shvek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=144"}],"version-history":[{"count":1,"href":"https:\/\/shvek.com\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions"}],"predecessor-version":[{"id":145,"href":"https:\/\/shvek.com\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions\/145"}],"wp:attachment":[{"href":"https:\/\/shvek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shvek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shvek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}