Could not insert term into the database

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:

  1. Is There a Difference Between Taxonomies and Categories?
  2. Check if a post is in any child category of a parent category
  3. How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
  4. get_categories for custom post type with a specific custom taxonomy attached
  5. Control term order on a per-post basis
  6. How can I add the featured image functionality to a custom taxonomy?
  7. Share one taxonomy across multiple blogs in 3.0 [duplicate]
  8. wp_update_nav_menu_item() to insert categories
  9. Admin Panel – Disable Moving Selected Terms To Top of Metabox
  10. How to make custom taxonomy check boxes like ‘Categories’
  11. Create terms when registering taxonomy?
  12. How to create non-unique sub-category slugs?
  13. How to get next previous category in same taxonomy?
  14. Display only deepest category on a single post?
  15. How to add HTML5 ‘required’ attribute to wp_dropdown_categories() without JavaScripts?
  16. Wrap a chosen category name with div
  17. Does WordPress Offer a Way to Find All of the Categories that Don’t Have Children?
  18. wp_list_categories, Add class to all list items with children
  19. Display empty taxonomy terms with get_terms()
  20. Connecting WordPress gallery to custom categories (taxonomy)
  21. What’s the difference between “parent” and “category_parent” in a WP_Term object?
  22. Update taxonomy value of post type in query
  23. How to query posts from specific authors and categories using WP_query?
  24. How to get the depth of a category’s subcategories
  25. New categories are now going to 404s
  26. Add custom taxonomy under the category title
  27. Best way to programmatically link to multiple categories (union/intersection) [closed]
  28. “Reversable” and “Re-useable” Subcategories (or other taxonomic structure)
  29. Get multidimensional array that reflects category hierarchy
  30. List Terms in Category
  31. How to get category URL with the slug?
  32. Taxonomy filter all children
  33. Display Slug instead of Name
  34. Force a user’s posts category
  35. Search Posts / Pages with multiple options?
  36. ACF: Display category name using taxonomy field
  37. Show Available Taxonomy List with Current Category
  38. Exclude a category from the_category in the single post page
  39. Taxonomy name repeating when showing 2 posts from each category
  40. Why does the argument list_only do on Walker_Category_Checklist::start_el?
  41. New Categories Not Shown In the Post Edit Page
  42. Shortcodes not working in category or tag description
  43. Filtering multiple categories via the URL
  44. Display specific categories by ID
  45. Display Posts Loop for each parent and for each Child
  46. How can I edit the ‘Most Used’ tab in the categories meta-box to show another custom taxonomy?
  47. Why don’t posts show up in my categories on the frontend?
  48. Flat category URLs but retaining hierarchy?
  49. Drop posts from categories in MySql
  50. Customize category page for different custom taxonomies
  51. Get posts under a category with SQL
  52. How many categories can WordPress handle before performance suffers?
  53. Custom taxonomy template for categories
  54. Targeting Parent Category Pages
  55. Wacky taxonomy in wordpress
  56. Question on using custom structures for categories
  57. Display sibling categories on category page
  58. How to modify the output of wp_terms_checklist when used within the built-in category metabox on edit posts?
  59. Some categories missing on wp-admin/edit-tags.php?taxonomy=category
  60. List just subcategory and products of active category page in Woocommerce
  61. Eliminate word from $term->name
  62. WP 4.7 in_category change?
  63. Illegal string offset ‘taxonomy’ in
  64. How to schedule categories?
  65. Let user select their own category
  66. Copy post taxonomy?
  67. Setting selected term_id with wp_dropdown_categories?
  68. creating categories programmatically
  69. Combining these queries? (Same taxonomy term + same category as post)
  70. sidebar troubles, taxonomy trouble
  71. Category post count is not correct
  72. Disable Category Taxonomy
  73. WordPress Default Category and Custom Taxonomy Selected Attribute not Working After Searched in wp_dropdown_categories Array
  74. How can i change sort category view starting from child then parent, not alphabetically
  75. Filtering posts in category by tag URL
  76. Bulk assign posts to a category using SQL (MySQL)
  77. Image Upload Custom Form Field for Category and Custom Taxonomy
  78. outputting taxonomy hierarchy
  79. Confused about category.php template – not working
  80. Filter custom taxonomy posts via AJAX
  81. Why use hierarchical taxonomies instead of many custom taxonomies?
  82. How get all media from a posts category by db?
  83. How to Manage and link certain custom taxonomy?
  84. Display Taxonomies in loop with template args
  85. Grouping parent categories into sections
  86. get_adjacent_post_link excluded_terms ignored
  87. Match two taxonomies to display a specific content
  88. Taxonomy for custom post type not found
  89. Category base 404 – fix
  90. Display only the latest post
  91. Return selected categories only in custom page meta box?
  92. Assign a category by user and customize the edit-tags.php?taxonomy=category page
  93. get IDs from links categories
  94. Multiple Parent Category URLs
  95. Chained drop-down menu for custom taxonomy using chained.js
  96. Display only one level subcategory in wordpress
  97. Converting Categories (with ACF fields) to custom taxonomies
  98. Woocommerce custom taxonomy order
  99. Hook action when create new category [duplicate]
  100. Taxonomy term RestApi data 10 rows limitions

Leave a Comment