{"id":1338,"date":"2020-04-20T10:34:00","date_gmt":"2020-04-20T08:34:00","guid":{"rendered":"https:\/\/digitalia.culturanuova.net\/blog\/?p=1338"},"modified":"2020-05-10T06:57:14","modified_gmt":"2020-05-10T04:57:14","slug":"how-to-avoid-1265-error-changing-value","status":"publish","type":"post","link":"https:\/\/digitalia.culturanuova.net\/blog\/?p=1338","title":{"rendered":"how to avoid #1265 error changing a value in a table structure"},"content":{"rendered":"<p>That is avoiding &#8220;data truncated&#8221; error. You must avoid to replace a value <i>in use.<\/i><br \/>\nThe right way, if a given value is <i>already applied<\/i> to some items, is<\/p>\n<ol>\n<li>to <i>add<\/i> the new value (supposed similar to the old) to the table structure<\/li>\n<li>search for all the items with old value<\/li>\n<li><a href=\"https:\/\/localhost\/web\/public_html\/mondodigitale\/wordpress\/?p=1336\">replace<\/a> in each item the old value with the new one<\/li>\n<li>delete the old value in the table structure<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>That is avoiding &#8220;data truncated&#8221; error. You must avoid to replace a value in use. The right way, if a given value is already applied to some items, is to add the new value (supposed similar to the old) to the table structure search for all the items with old value replace in each item &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/digitalia.culturanuova.net\/blog\/?p=1338\" class=\"more-link\">Leggi tutto<span class=\"screen-reader-text\"> &#8220;how to avoid #1265 error changing a value in a table structure&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565],"tags":[11,14,15],"class_list":["post-1338","post","type-post","status-publish","format-standard","hentry","category-office","tag-mysql","tag-table","tag-values"],"_links":{"self":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1338"}],"version-history":[{"count":4,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1338\/revisions"}],"predecessor-version":[{"id":1913,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1338\/revisions\/1913"}],"wp:attachment":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}