Remove ‘uncategorized’ from posts also assinged to other categories

  • I have about 1200 posts in the ‘uncategorized’ category. About half of those (maybe less, but too many to do by hand), are also assigned to other categories as well.

    I’d like to remove ‘uncategorized’ from any post that has any other category assigned to it. I’m not above doing it via sql–I looked around for a plugin first, and haven’t had much luck.

    Then again, it’s very likely I’m missing something. Anybody have any suggestions?

    Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi

    Take a look at this Batch Category plugin
    https://robm.me.uk/projects/plugins/wordpress/batch-categories#toc-download

    Once you get them all removed from uncategorized, this plugin deUncategorize
    will auto-remove the check in uncategorized for any new post to which you assign a different category
    https://cinnamonthoughts.org/wordpress/deuncategorize/

    Thread Starter crazybilly

    (@crazybilly)

    Great–thanks. I’ll take a look and let you know how it goes.

    Hi,

    you can not delete uncategorized category from wordpress but you need to rename that and apply posts to that category.

    [signature moderated Please read the Forum Rules]

    Thread Starter crazybilly

    (@crazybilly)

    Hmmm…unforunately, batch categories doesn’t seem to work on 2.7.

    What happens if I deleted the ‘uncategorized’ category?

    Thread Starter crazybilly

    (@crazybilly)

    Doh…obviously, I should have refreshed before I posted ;).

    So, I can’t delete the category, but I CAN rename it. Hmm…

    I could manage to do this, but I had to use SQL (“delete”). YOU MUST BE VERY CAREFUL WHEN USING THIS COMMAND. DON’T FORGET TO BACKUP YOU WP DATABASE!

    There are two tables where WP stores the relationships of categories to posts. These are “wp_term_relationships” and “wp_term_taxonomy”. You can find the ID of the “uncategorized” (probably “1”) in the table “wp_terms”. Then you need only a “delete from ‘wp_term_relationships’ where ‘term_taxonomy_id’=ID_YOU_FOUND” and than “delete from ‘wp_term_taxonomy’ where ‘term_taxonomy_id’=ID_YOU_FOUND”.

    This done the job for me.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Remove ‘uncategorized’ from posts also assinged to other categories’ is closed to new replies.