New posts defaulting to ‘0’ primary key

This is only my best guess. I can’t see a definitive answer with the information provided.

The primary key for wp_posts should be set to ID. The primary key is giving the error. Since ID is not defined in the query, it is likely that the AUTO_INCREMENT value has been set to 0, or is no longer incrementing.

I would look into your database and find the AUTO_INCREMENT value. I bet it’s set to 0 for some reason.

Take a backup of your database before making any changes to the database.

If the AUTO_INCREMENT value is set to 0, you want to set it to a value that hasn’t yet been reached. Go to wp_posts and find the highest value ID and set it to one more than that (or a few more than that, just to be safe).

For example, if the highest value ID in wp_posts is 1000:

ALTER TABLE wp_posts AUTO_INCREMENT = 1001;

If this is not the issue, ensure that the PRIMARY_KEY for the table is set to ID.

Related Posts:

  1. removing inline styles from wp-caption div
  2. Different post sort order within different categories
  3. How to export posts with featured image
  4. How are terms connected with posts in database?
  5. Is there any way of copy/pasting, duplicating, or auto-generating posts for fast testing?
  6. JSON not valid after json_encode posts
  7. Post Admin – Filter by posts without tags
  8. Exclude category on blog list page
  9. Post & edit a post from front end along with upload, dropdown, and other inputs
  10. How can I group posts by date on frontpage?
  11. Text after more tag in posts
  12. Hide parts of the post content on the home page
  13. Get the post_id of a new post
  14. Do I use custom post type or something else?
  15. How To Add Perfect Apostrophe And Quotation Mark In WordPress Posts?
  16. Send email to user that his post has been rejected
  17. How can I highlight syntax like it appears on stackoverflow?
  18. Custom post type permalinks breaking due to 3.1 bug fix
  19. wp_insert_post let users post to without login…broke
  20. ‘Invalid post type’ error when importing from one site to another
  21. Export posts manually selected by end user (not logged in)
  22. Add Category name to Post Title (h1)
  23. Blogroll – Different layout for first post
  24. How to delete old posts’ edits to save space?
  25. Locked/Unlocked in title
  26. How to permanently delete a post meta entry?
  27. When trashing a post, also trash related comments
  28. Loop through all product posts?
  29. Image Insert into posts and pages not working after 3.2.1 update
  30. How to add Tags Filter in wordpress admin dashboard
  31. How to display featured image without it appearing in post?
  32. allow new users to post an article before they sign up [closed]
  33. Make Post Editor Select Number of Columns To 1 By Default
  34. WordPress blog or WordPress website
  35. Find attached images for one post type
  36. Adding the_date inside tags around the_content
  37. Mixing Tweets with Posts
  38. List blocks created by a specific block plugin
  39. Problem with permalink routing?
  40. Ajax post filters not working
  41. How to sort posts inside categories
  42. Making a custom Pagination for multi page blog post
  43. List authors with the last post title and order by last post date
  44. How to order posts by meta_value and title
  45. WordPress is replacing double minus signs in Post Title, how to disable it?
  46. How do I do a page break?
  47. What do these phpMyAdmin errors mean on my WordPress databaes?
  48. Thumbnail Image to go in the post aswell
  49. using is_paged for hiding image on posts
  50. Wrap every month posts in div
  51. Is there a query string for edit.php to show all posts that have no custom taxonomy terms?
  52. static landing page leading to author specific pages w/ “live” content
  53. Display Posts with template on a Page
  54. wp_posts table extremely large
  55. Filter Hook for post table (not columns)
  56. Queries take 120+ seconds on my large WordPress site
  57. Do one have to wait after pressing “update” on a post edit page?
  58. Link to date_query results in WordPress
  59. Add post tags to previously created custom post type
  60. Change layout of post depending on category
  61. Insert specific information to a posts of a predefined category
  62. Problem with quotes
  63. Add Input Field in Simple Model Contact Form (smcf) plugin [closed]
  64. Anyone know a php snippet for showing the first 200 characters of the most recent post?
  65. Am getting duplicate data from get_posts()
  66. How to display the post categories for each post inside the loop with custom format?
  67. Allow / show post comments in category pages
  68. Display default matabox of posts(add category) wordpress
  69. How to get tags when using publish_post
  70. Filter post by users creation date
  71. WordPress Sticky Post Count “Fix” Breaking Pagecount by 72 pages!
  72. Function is printing twice – any suggestions?
  73. How do you change the permalink for posts for a single category?
  74. Pagination Not Working With Custom Post Type Category
  75. Recent Post Issue
  76. how to create a category with wp_insert_post and post_category
  77. post thumbnails error
  78. Disaply products from category
  79. Multisite Issue on Subdomain’s article pages
  80. Extracting the permalink from a post instance
  81. How to add a block to a category page?
  82. Add another feature image box
  83. Post not showing in the front page
  84. If user has 1 post then dont let him create new one [closed]
  85. Wp_query loop is not working as it should
  86. Blank page after changing number of post displayed in wp-admin
  87. Show all posts from the tags without having to set all of them
  88. Is there a global page/post/product/anything ID?
  89. Auto populate custom fields by post date
  90. Query post by meta key of another table
  91. Correcting the content width when sidebar is inactive?
  92. How to show only Post titles on category pages
  93. Show Post number of specific Category
  94. Thumbnail With Next/Prev Links Not Showing Next Post?
  95. Sort Posts Alphabetically by Multiple Categories [duplicate]
  96. Trying to display stick or featured post on homepage
  97. Single post page from static home not working
  98. How can I allow users (subscribers) to download selected posts into a single PDF? (RESOLVED)
  99. How to change text (date) in post base on the day
  100. How do you order posts by type then term_id and then by date?
error code: 523