wp_insert_post always returns 0 on one site, extensive testing done, can’t get to the bottom

I have a feeling it has to do with the one database, but I don’t see
any errors that would indicate so.

Yes, and apparently the structure of the WordPress posts table (wp_040skcp8g2_posts) in the problematic site is corrupted.

More specifically, indexes such as the primary key are missing, so you need to add them back ASAP:

  • See line 26 at https://pastebin.com/CGGv5q4N which is [Key] => and should instead be [Key] => PRI and on line 28, it should be [Extra] => auto_increment.

  • Try running SHOW INDEXES FROM wp_040skcp8g2_posts via phpMyAdmin and you’d notice the table indexes are missing.

And I don’t know how come the indexes are gone, but I would scan the site for possible security loopholes and then ensure that WordPress core, plugins and themes are up-to-date. I might also change my WordPress/cPanel/FTP/SSH/etc. passwords.

As you can see there are no visible errors, and it looks like the post
should have been assigned a post ID, because it’s in the DB, but it’s
always post ID 0.

The post ID field was supposed to be the primary key with the value being auto-incremented for every INSERT operation, but as I said above, the primary key is missing and the ID field is also no longer auto-incremented and therefore, the post ID always a 0, i.e. zero.

So you really need to fix the table structure and ensure the other (WordPress) tables have a good structure as well.

And for example, to add the primary key, you could do ALTER TABLE wp_040skcp8g2_posts MODIFY ID bigint(20) unsigned NOT NULL auto_increment, ADD PRIMARY KEY (ID).

However, if you need further assistance with that (adding back or fixing the indexes), try asking on https://dba.stackexchange.com/, or Stack Overflow? 🙂

Related Posts:

  1. Faster way to wp_insert_post & add_post_meta in bulk
  2. wordpress sanitize array?
  3. Is there a downside of using wp_defer_term_counting?
  4. wp_insert_post extremely slow on big table, direct query very fast
  5. wp_insert_post add meta_input
  6. tax_input not working wp_insert_post
  7. See error message from wp_insert_post function?
  8. Adding post thumbnail in programatically inserted post
  9. can’t edit post_modified in wp_insert_post (bug?)
  10. wp_insert_post incorrectly escapes HTML comments when they include tags
  11. What is considered the post’s creation date for wp_insert_post?
  12. Insert new term during new post creation
  13. wp_insert_post creates multiple pages
  14. wp_insert_post() getting slower the more posts
  15. How to allow data:image attribute in src tag during post insert?
  16. tax_input argument for wp_insert_post()
  17. How can I stop wp_update_post messing up HTML example code?
  18. How to insert custom function into wp_insert_post
  19. wp_insert_post does not write my post_name
  20. Is there a way to fire other functions from wp_insert_post
  21. Programmatically add terms to custom post types
  22. Organizing uploaded media with wp_insert_post() and wp_handle_upload according to time parameter
  23. wp_insert_post not returning post ID? [closed]
  24. wp_insert_post to schedule a post – but nothing happens?
  25. post_date_gmt and post_date [duplicate]
  26. Get data from wp_editor()
  27. wp_insert post doesn’t work
  28. Replace string with post_name on sidebar
  29. Visual Editor – Colorize Shortcodes
  30. Efficient way to save a lot of meta data
  31. How to update post parent?
  32. Contact Form 7 to featured image
  33. Conditionally set post_content in wp_insert_post
  34. How to use wp_insert_post to update meta box?
  35. wp_insert_post -> post_content not showing
  36. wp_insert_post bulk import 500 server error
  37. after wp_insert_post need to get the post id
  38. Could not get post ID from wp_insert_post()
  39. Creating New Page with WP_INSERT_POST Issue
  40. wp_insert_post is not creating revision in database
  41. Inserting post, thumnail and custom fields with wp_insert_post
  42. add_menu_page Callback Function: Skip page content?
  43. using wp_insert_post inside of custom meta box
  44. wp_insert_post or wp_set_post_terms do not save taxonomy, but wp_set_post_terms does
  45. Making sure wp term relationships records are unique
  46. update_post_meta, xml parser
  47. wp_insert_post if page doesn’t exist under current page
  48. Check if post is added manually or through wp_insert_post()
  49. keep wp_insert_post from adding duplicates
  50. Add file while inserting post
  51. Combining wp_insert_post() and update_post_meta()
  52. Programmatically create a post once a day
  53. wp_insert_post custom type and custom taxonomies
  54. Where to call wp_insert_user() and wp_insert_post() from?
  55. wp_insert_post at same time as saving post results in 502 Bad Gateway
  56. Add action to create new post after wp_insert_post fires? Think it’s creating an infitnite loop
  57. wp_insert_post alternatives for faster process
  58. WP-CLI –meta-input error: Warning: Invalid argument supplied for foreach()
  59. tax_input in wp_insert_post partly not working
  60. Issue with wp_insert_post() when post_content contains links?
  61. $user_id = wp_insert_user( $userdata ) Not working no errors
  62. $wpdb->insert() does not insert fields
  63. Insert multiple posts as parent of the first
  64. oEmbded with wp_insert_post() [embedly]
  65. wp_insert_post Only creates draft
  66. wp_insert_post removes information when updating
  67. Bug in wp_insert_post script and form, probably something simple I am not seeing
  68. Setting Post Date Returning “Notice: A non well formed numeric value encountered”
  69. Custom terms inserting as single string with commas, not separated
  70. wp_insert_post creating duplicate post with Safari
  71. Inserting post_id into guid before wp_insert_post
  72. “transition_post_status” action creating two post with wp_insert_post
  73. wp_insert_post fails at return statement (nothing is returned to the caller, the error displayed is: The Link You Followed Has Expired)
  74. XML FOLDER – wp_insert_post – how to assign XML variables to post
  75. Cannot insert HTML content even removing kses filters
  76. get_page_by_title() not working as expected
  77. Insert Multiple Posts from JSON Results
  78. How can I automatically add a post with Latin characters?
  79. 500 error after wp_insert_post
  80. insert category from form in a post
  81. How to insert post from external php file?
  82. How to Create Content Remotely
  83. Get original post ID after wp_insert_post
  84. Update post_meta post_name with the post ID from wp_insert_post after user register
  85. Bulk insert posts is really slow and skips entries
  86. Insert post programmatically and decide to tweet or not to tweet
  87. Changing wp_insert_post() location
  88. wp_insert_post questions
  89. wp_insert_post does not insert string with apostrophes correctly
  90. Automatically add another subpost of the same parent when a subpost is saved
  91. Setting a featured image while creating the post
  92. Issues with post_content when using wp_insert_post
  93. foreach $FILES create post how to
  94. I need to dynamic insert post containing javascript from my other website?
  95. wp_insert_post and title not utf8 inserts with empty title?
  96. wp_insert_post memory consumption
  97. wordpress apply filters and is singular()
  98. Cant get front end form to post to wordpress
  99. The reverse of wp_insert_post
  100. Set post_parent from URL params in post-new.php