{"id":2347,"date":"2011-10-22T14:10:59","date_gmt":"2011-10-22T14:10:59","guid":{"rendered":"http:\/\/spinor.info\/weblog\/?p=2347"},"modified":"2011-10-22T14:11:19","modified_gmt":"2011-10-22T14:11:19","slug":"wordpress-problem","status":"publish","type":"post","link":"https:\/\/spinor.info\/weblog\/?p=2347","title":{"rendered":"WordPress problem"},"content":{"rendered":"<p>I&#8217;ve been using WordPress for this blog for the last several years. Lately, I noticed a problem: every new post I add appears in the &#8220;Uncategorized&#8221; post category, and it is impossible to remove a post from a category.<\/p>\n<p>I&#8217;m sure the good folks at WordPress will fix this problem soon, but until then, here are the SQL statements I need to remove all posts from the &#8220;Uncategorized&#8221; category:<\/p>\n<pre> DELETE vttoth_term_relationships FROM vttoth_term_relationships, vttoth_posts\r\n  WHERE term_taxonomy_id=1 AND object_id=ID AND post_type='post';\r\n UPDATE vttoth_term_taxonomy SET count=0 WHERE term_taxonomy_id=1;<\/pre>\n<p>My WordPress database is called &#8216;vttoth&#8217;; for a WordPress database that uses a different name, the above instructions must be altered accordingly.<\/p>\n<p>&nbsp;<\/p>\n<fb:like href='https:\/\/spinor.info\/weblog\/?p=2347' send='false' layout='button_count' show_faces='true' width='450' height='65' action='like' colorscheme='light' font='lucida grande'><\/fb:like>","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been using WordPress for this blog for the last several years. Lately, I noticed a problem: every new post I add appears in the &#8220;Uncategorized&#8221; post category, and it is impossible to remove a post from a category. I&#8217;m sure the good folks at WordPress will fix this problem soon, but until then, here <a href='https:\/\/spinor.info\/weblog\/?p=2347' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,6],"tags":[],"class_list":["post-2347","post","type-post","status-publish","format-standard","hentry","category-computers","category-internet","category-11-id","category-6-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=\/wp\/v2\/posts\/2347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2347"}],"version-history":[{"count":2,"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=\/wp\/v2\/posts\/2347\/revisions"}],"predecessor-version":[{"id":2349,"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=\/wp\/v2\/posts\/2347\/revisions\/2349"}],"wp:attachment":[{"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spinor.info\/weblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}