OK. There where multiple issues here;
wp_terms, wp_termmeta and wp_term_taxonomy all had their ID’s set not to AUTO_INCREMENT.
Changing these and removing the 0 values from each table seems to have resolved this – very odd though.
Big thanks to @N00b for helping!
Related Posts:
- Is There a Difference Between Taxonomies and Categories?
- Check if a post is in any child category of a parent category
- How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
- get_categories for custom post type with a specific custom taxonomy attached
- Control term order on a per-post basis
- How can I add the featured image functionality to a custom taxonomy?
- Share one taxonomy across multiple blogs in 3.0 [duplicate]
- wp_update_nav_menu_item() to insert categories
- Admin Panel – Disable Moving Selected Terms To Top of Metabox
- How to make custom taxonomy check boxes like ‘Categories’
- Create terms when registering taxonomy?
- How to create non-unique sub-category slugs?
- How to get next previous category in same taxonomy?
- Display only deepest category on a single post?
- How to add HTML5 ‘required’ attribute to wp_dropdown_categories() without JavaScripts?
- Wrap a chosen category name with div
- Does WordPress Offer a Way to Find All of the Categories that Don’t Have Children?
- wp_list_categories, Add class to all list items with children
- Display empty taxonomy terms with get_terms()
- Connecting WordPress gallery to custom categories (taxonomy)
- What’s the difference between “parent” and “category_parent” in a WP_Term object?
- Update taxonomy value of post type in query
- How to query posts from specific authors and categories using WP_query?
- How to get the depth of a category’s subcategories
- New categories are now going to 404s
- Add custom taxonomy under the category title
- Best way to programmatically link to multiple categories (union/intersection) [closed]
- “Reversable” and “Re-useable” Subcategories (or other taxonomic structure)
- Get multidimensional array that reflects category hierarchy
- List Terms in Category
- How to get category URL with the slug?
- Taxonomy filter all children
- Display Slug instead of Name
- Force a user’s posts category
- Search Posts / Pages with multiple options?
- ACF: Display category name using taxonomy field
- Show Available Taxonomy List with Current Category
- Exclude a category from the_category in the single post page
- Taxonomy name repeating when showing 2 posts from each category
- Why does the argument list_only do on Walker_Category_Checklist::start_el?
- New Categories Not Shown In the Post Edit Page
- Shortcodes not working in category or tag description
- Filtering multiple categories via the URL
- Display specific categories by ID
- Display Posts Loop for each parent and for each Child
- How can I edit the ‘Most Used’ tab in the categories meta-box to show another custom taxonomy?
- Why don’t posts show up in my categories on the frontend?
- Flat category URLs but retaining hierarchy?
- Drop posts from categories in MySql
- Customize category page for different custom taxonomies
- Get posts under a category with SQL
- How many categories can WordPress handle before performance suffers?
- Custom taxonomy template for categories
- Targeting Parent Category Pages
- Wacky taxonomy in wordpress
- Question on using custom structures for categories
- Display sibling categories on category page
- How to modify the output of wp_terms_checklist when used within the built-in category metabox on edit posts?
- Some categories missing on wp-admin/edit-tags.php?taxonomy=category
- List just subcategory and products of active category page in Woocommerce
- Eliminate word from $term->name
- WP 4.7 in_category change?
- Illegal string offset ‘taxonomy’ in
- How to schedule categories?
- Let user select their own category
- Copy post taxonomy?
- Setting selected term_id with wp_dropdown_categories?
- creating categories programmatically
- Combining these queries? (Same taxonomy term + same category as post)
- sidebar troubles, taxonomy trouble
- Category post count is not correct
- Disable Category Taxonomy
- WordPress Default Category and Custom Taxonomy Selected Attribute not Working After Searched in wp_dropdown_categories Array
- How can i change sort category view starting from child then parent, not alphabetically
- Filtering posts in category by tag URL
- Bulk assign posts to a category using SQL (MySQL)
- Image Upload Custom Form Field for Category and Custom Taxonomy
- outputting taxonomy hierarchy
- Confused about category.php template – not working
- Filter custom taxonomy posts via AJAX
- Why use hierarchical taxonomies instead of many custom taxonomies?
- How get all media from a posts category by db?
- How to Manage and link certain custom taxonomy?
- Display Taxonomies in loop with template args
- Grouping parent categories into sections
- get_adjacent_post_link excluded_terms ignored
- Match two taxonomies to display a specific content
- Taxonomy for custom post type not found
- Category base 404 – fix
- Display only the latest post
- Return selected categories only in custom page meta box?
- Assign a category by user and customize the edit-tags.php?taxonomy=category page
- get IDs from links categories
- Multiple Parent Category URLs
- Chained drop-down menu for custom taxonomy using chained.js
- Display only one level subcategory in wordpress
- Converting Categories (with ACF fields) to custom taxonomies
- Woocommerce custom taxonomy order
- Hook action when create new category [duplicate]
- Taxonomy term RestApi data 10 rows limitions