{"id":155,"date":"2023-09-04T15:25:32","date_gmt":"2023-09-04T13:25:32","guid":{"rendered":"https:\/\/tech.slettene.com\/?p=155"},"modified":"2023-09-04T15:25:32","modified_gmt":"2023-09-04T13:25:32","slug":"rette-feil-i-wordpress-urler-etter-migrering","status":"publish","type":"post","link":"https:\/\/tech.slettene.com\/?p=155","title":{"rendered":"Rette feil i WordPress-urler etter migrering"},"content":{"rendered":"\n<p>Ved migrering av WordPress-siter kan det skje at enkelte URL-er endres til f.eks intern adresse eller adresse med internt portnummer. Dette kan rettes rett i databasen. Husk \u00e5 eksponere databasen i Docker f\u00f8rst. F\u00f8lgende SQL oppdaterer alle URL-er.<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>UPDATE wp_options SET option_value = replace(option_value, '&#91;GammelURL]', '&#91;NyURL]') WHERE option_name = 'home' OR option_name = 'siteurl';\nUPDATE wp_posts SET post_content = replace(post_content, '&#91;GammelURL]', '&#91;NyURL]');\nUPDATE wp_postmeta SET meta_value = replace(meta_value,'&#91;GammelURL]','&#91;NyURL]');\nUPDATE wp_usermeta SET meta_value = replace(meta_value, '&#91;GammelURL]','&#91;NyURL]');\nUPDATE wp_links SET link_url = replace(link_url, '&#91;GammelURL]','&#91;NyURL]');\nUPDATE wp_comments SET comment_content = replace(comment_content , '&#91;GammelURL]','&#91;NyURL]');<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ved migrering av WordPress-siter kan det skje at enkelte URL-er endres til f.eks intern adresse eller adresse med internt portnummer. Dette kan rettes rett i databasen. Husk \u00e5 eksponere databasen i Docker f\u00f8rst. F\u00f8lgende SQL oppdaterer alle URL-er.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,3],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-docker","category-wordpress"],"_links":{"self":[{"href":"https:\/\/tech.slettene.com\/index.php?rest_route=\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech.slettene.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.slettene.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.slettene.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.slettene.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=155"}],"version-history":[{"count":1,"href":"https:\/\/tech.slettene.com\/index.php?rest_route=\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":156,"href":"https:\/\/tech.slettene.com\/index.php?rest_route=\/wp\/v2\/posts\/155\/revisions\/156"}],"wp:attachment":[{"href":"https:\/\/tech.slettene.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.slettene.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.slettene.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}