Change post category in the database

  • desmondo

    (@desmondo)


    15 years, 10 months ago

    Hi all,

    Due to my categories not showing up in the latest version of wordpress, I need to change them in the database. Field names appear to have changed, so I can’t figure out how I change the category of a post.

    I’ve tried opening up the individual post in wp_posts > post_content and changing the number of the post from 0 to 20. This doesn’t seem to change anything and looking at older posts this value is always 0.

    Is there a way of changing the category of an individual post in the database?

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • moshu

    (@moshu)

    15 years, 10 months ago

    You can change anything in the database – but that’s probably not the best approach. And it is dangerous to mess with it if you do’nt know what are you doing.

    Looking at your other posts it seems your upgrade was NOT successful. My advice: don’t try to treat the ‘symptoms’, treat the cause! In other words: repeat the upgrade and make it work. Then you don’t need obscure workarounds…

    Thread Starter desmondo

    (@desmondo)

    15 years, 10 months ago

    Thanks Moshu, I think you’re right.

    I’ve deleted everything, created a new database and I’m adding the content in manually again.

    The only problem is, I still can’t add HTML links to my posts still, even if I start from a clean install without moderations. I can save a post fine, until I add the HTML link, then it redirects me back to my homepage and doesn’t save the post.

    I also have tried to add the categories back in manually and it won’t let me add a sub category with the same name as another. Maybe that’s why my categories weren’t showing up when I updgraded. Seems a bit odd that this feature was removed; why wouldn’t you be able to have a sub category with the same name?

    Thanks again.

    Thread Starter desmondo

    (@desmondo)

    15 years, 10 months ago

    Just an update, I’ve gone back to version 2.3, as I really need to be able to use the same category name more than once.

    For the most part, it’s working now. The only issue I still have is I can’t add links to posts. I am sure I’ve seen this before, but no idea where the fix is as I can’t find that information.

    If anyone knows, could you please point me in the direction!

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Change post category in the database’ is closed to new replies.