{"id":212,"date":"2007-10-25T20:47:14","date_gmt":"2007-10-26T04:47:14","guid":{"rendered":"http:\/\/www.evardsson.com\/blog\/2007\/10\/25\/wordpress-update-headaches-resolved-2\/"},"modified":"2007-11-02T21:37:24","modified_gmt":"2007-11-03T05:37:24","slug":"wordpress-update-headaches-resolved-2","status":"publish","type":"post","link":"https:\/\/www.evardsson.com\/blog\/2007\/10\/25\/wordpress-update-headaches-resolved-2\/","title":{"rendered":"WordPress Update headaches &#8211; resolved???"},"content":{"rendered":"<p>I had a few headaches updating to <a href=\"http:\/\/wordpress.org\/\">WordPress 2.3<\/a>. Not surprising since the category related tables were removed to make room for native tagging, and I have been relying on the Category Tagging plug-in. Ah well, after some hand sql work I was able to populate the tags to match the categories.<\/p>\n<p>Now it can only get better, right? I have moved to using subversion to pull the latest stable release, so that takes a big chunk of time out of the equation, and now my tagging will happen at the time of posting, rather than being a pseudo-tag solution pulled from post categories. Or will it? I wonder if the tags tab in <a href=\"http:\/\/www.scribefire.com\/\">ScribeFire<\/a> will do the trick?<\/p>\n<p>We shall see.<\/p>\n<p>The 3.0 version of the Google Sitemap generator seems to not be working, however, but I may have b0rked something there myself, and I will try again later.<\/p>\n<p>Oh, and those sql statements?<\/p>\n<p>If I remember correctly (I didn&#8217;t keep notes like I should have):<\/p>\n<p>INSERT INTO wp_term_taxonomy (term_id, taxonomy, count) SELECT term_id, &#8216;post_tag&#8217;, count FROM wp_term_taxonomy WHERE taxonomy=&#8217;category&#8217;;<\/p>\n<p>INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT rel.object_id, tax.term_taxonomy_id FROM wp_term_relationships AS rel, wp_term_taxonomy AS tax, wp_term_taxonomy AS ttx WHERE rel.term_taxonomy_id=ttx.term_taxonomy_id AND ttx.term_id = tax.term_id AND tax.taxonomy=&#8217;post_tag&#8217;;<\/p>\n<p>I could have brought the descriptions across from the categories, too, but I didn&#8217;t think about it until just now.<\/p>\n<p>Edit: I found the issue with the site-map generator. It required a tweak to the memory limits in my php.ini :\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I had a few headaches updating to WordPress 2.3. Not surprising since the category related tables were removed to make room for native tagging, and I have been relying on the Category Tagging plug-in. Ah &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[59,60],"tags":[196,197],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-subversion","category-wordpress","tag-subversion","tag-wordpress"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pxT7i-3q","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":0,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}