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:
- How to display non-hierarchical taxonomy as terms with checkboxes?
- Control term order on a per-post basis
- Can a Child Category Have More than One Parent?
- Combine two taxonomies in a hierarchical tree
- Weird behaviour when adding terms/term_taxonomies programmatically
- How can I select a primary category?
- How to Override default update_count_callback for category
- Does WordPress Offer a Way to Find All of the Categories that Don’t Have Children?
- Add custom taxonomy terms to WordPress menu dynamically & append #slug to url
- Getting WordPress custom taxonomy/category?
- Return category slug / title from category ID
- How to get the number of child categories a specific parent category has?
- Get term by slug in Gutenberg
- Update taxonomy value of post type in query
- How to get the depth of a category’s subcategories
- How can I convert some categories to a custom taxonomy?
- Any way to assign Post Categories and Tags to Links?
- Display name of the last child category
- Best way to programmatically link to multiple categories (union/intersection) [closed]
- Want to hide some categories from the categories meta box in the post editor for the two specific user roles
- How to export/import categories and keep their IDs?
- How to use wp_category_checklist()?
- Get all sub-categories of a parent category
- Can I use get_adjacent_post for specific categories?
- How to view WordPress’ default category IDs?
- Random taxonomy category list
- Taxonomy filter all children
- Change existing taxonomy settings when using custom taxonomy
- How to get the id from the custom category?
- Show Available Taxonomy List with Current Category
- category filter doesn’t work in WPML
- How to filter out Categories for specific post types on WordPress Admin?
- Exclude a category from the_category in the single post page
- How can i insert term in a specific language of Polylang?
- Why does the argument list_only do on Walker_Category_Checklist::start_el?
- Filtering *out* a taxonomy from the admin post list
- category image taxonomy
- How to “group” (categorize) the Pages together?
- Is There a Difference Between Taxonomies and Categories?
- How can I edit the ‘Most Used’ tab in the categories meta-box to show another custom taxonomy?
- Custom taxonomy/category order
- 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
- Custom taxonomy template for categories
- Wacky taxonomy in wordpress
- Display custom taxonomy attached to the post on post single page
- Question on using custom structures for categories
- Admin: Navigation Menus do not show empty categories/taxonomies in the list’s search tab
- 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
- Echo text using is_tag
- List just subcategory and products of active category page in Woocommerce
- WP 4.7 in_category change?
- Get posts of a custom post type from category from taxonomy?
- Illegal string offset ‘taxonomy’ in
- Change categories count to include media attachments
- How to get selected taxonomy or category ID if using custom walker?
- Let user select their own category
- Setting selected term_id with wp_dropdown_categories?
- creating categories programmatically
- sidebar troubles, taxonomy trouble
- Displaying posts of given category
- Category post count is not correct
- WordPress Default Category and Custom Taxonomy Selected Attribute not Working After Searched in wp_dropdown_categories Array
- Show subChild categories
- How can i change sort category view starting from child then parent, not alphabetically
- WordPress 5.4 and higher: Filter posts by category 1 AND category 2 in API requests
- Filtering posts in category by tag URL
- WordPress Portofolio Conditional Templating – functions php
- Get WooCommerce product category list in functions.php
- 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
- Category base 404 – fix
- Display only the latest post
- Return selected categories only in custom page meta box?
- list taxonomy based on taxonomy
- 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
- Hook action when create new category [duplicate]
- Taxonomy term RestApi data 10 rows limitions
- Add custom fields to Woocommerce Category Page
- How to make /category/ URL load properly instead of 404 error?
- How to get parent and child sub category (Taxonomy) order to display