I have a plugin that expects there to be a default “uncategorized” category with ID=1. I’ve inadvertantly deleted the uncategorized category. Is it possible to recreate the category as ID=1?
When I look at a default WP install, I see that the table “wp_terms” has uncategorized as the first record with id 1. It also appears that the “wp_term_relationships” and “wp_term_taxonomy” tables are in play in this regard.
How would one go about recreating this category?
You need 3 steps:
1.Creating a term in wp_terms with ID is 1
2.Insert a term_taxanomy into wp_term_taxonomy with term_id is 1, and taxonomy must be category
3.Insert a term_relationships into wp_term_relationships with object_id is 1 and term_taxonomy_id is 1
Run below code in PHPMYADMIN to re-create this category!
Could your plugin not use
get_option('default_category'), which returns the ID of the default category?It’s an auto incrementing integer, so you can’t using WP. But you can edit the term id and its taxonomy id from the database directly.
Either recreate it directly in the database by copying another one in and editing it, OR, why not check in your plugin files? Just do a file search for the id=1 thing and see what you come up with, and then change that to your new default id #. I always find it’s easier to edit plugin and php files than mucking around in the database.