Troubles about insering a POST with a SQL query, post_status

Why are you using direct SQL query instead of wp_insert_post()?

I see that you seem to be using non-standard database object. It is hard to guess what goes wrong if you are doing something considerably different from native mechanics.

Related Posts:

  1. simple wp_insert_post example
  2. Retrieving and Storing Images Linked from Other Domains on Local Server?
  3. WP_Query with the “offset” argument
  4. Stopping People Viewing Draft Posts
  5. The function can not create a table on MariaDB server
  6. I want to print a message in post ” After one month from publish date”
  7. WordPress : using AJAX to get posts & Sidebar Content to an external application
  8. Specific colours for wordpress author ids
  9. insert post fails after multiple postings
  10. Add commentmeta custom field to every published comment with SQL
  11. Pre_Get_Posts order DESC not registering
  12. Custom WordPress SQL Query 4 posts per custom taxonomy
  13. Special Query: Title, Terms, Content – %LIKE%
  14. Has the table name in SQL for WordPress changed from WP_posts to WPCS_post?
  15. Running Gutenberg React in Development Mode
  16. Is there a blank theme framework compatible with WP 3.0? [closed]
  17. Plugin SVN & update API – how are plugins identified?
  18. Check for and enforce unique value in user-entered custom meta field in WP Admin
  19. Custom Search Query
  20. How do I unlock a post programmatically?
  21. Export WordPress Posts and Meta Information in CSV format
  22. Removing fields from the Media Uploader/Gallery
  23. Managing Images for a WordPress Blog: Picasa or Flickr?
  24. When using the block.getSaveElement hook can you output different markup based on whether or not you are in the edit view or the live page view?
  25. How wp_ajax_nopriv since WordPress 3.1
  26. Set user loggin status?
  27. redirect product-category to a custom page
  28. Remove All, Published and Trashed Post Views in Custom Post Type
  29. custom headers for static home page and posts page
  30. How to redirect WooCommerce shop URL?
  31. Best way to implement a thumbnail-based gallery in WordPress?
  32. Why is my mod_rewrite not working?
  33. Show posts on a page based on a category and tag(s)
  34. Any tools for quickly grabbing comments / comment count?
  35. Custom WP_Query with no posts to output
  36. How to remove buttons from the WP Editor on the edit post page in the admin area
  37. Adding Page Attributes and Page Templates to Custom Post Type WP 4.7.3
  38. WordPress Locale Switching on Accept-Language Header
  39. syntax highlighting for theme-editor.php?
  40. How do I call in a category title on a category page in a child theme?
  41. Include custom JS without child theme
  42. Prepopulating a specific page template with HTML/CSS
  43. WordPress media uploader – upload tabs not hiding
  44. how to convert Html block to dynamic widget?
  45. Custom Log In Screen – Disable password recovery [duplicate]
  46. orderby in query_posts
  47. How to get every custom taxonomy names and urls?
  48. How to include my own css in post
  49. Problem with theme activatation
  50. How to customize feed?
  51. Two description meta tags All in One SEO WordPress [closed]
  52. Is there a way to by-pass the pagination function on one custom template?
  53. Create page as a file in my theme?
  54. Search URL parameters query [duplicate]
  55. Change Successful password reset message
  56. Changing the the_author_posts_link() hover title
  57. Migrate posts from category and sub-category via SQL
  58. register_post_type permalink
  59. How do I hide an article element so only logged out users see it
  60. How to display page ids as page slug names?
  61. How to add custom ‘layout’ buttons to wordpress editor?
  62. How to request container_class from wp_nav_menu
  63. Replace a ‘Title’ tag with a Custom Field
  64. Fatal error Call to a member function insert() on a non-object [closed]
  65. change top banner content on specific page
  66. Is “get_template_part” hierarchy possible?
  67. How To Use Custom Tax of a Post Type
  68. Custom Register Link on Backend Form
  69. Global theme customization multisite
  70. How to style bootstrap container in WordPress?
  71. Redirect to custom post if custom archive page has just one result?
  72. Change login cookie expiration time?
  73. Is it possible to make a custom post that adds multiple pages?
  74. Post filter with multiple checkbox taxonomy terms
  75. Limit posts per page depending on the size of a div?
  76. Getting error in sql query
  77. Altered Media Library URLs
  78. generate a static copy of the website footer html
  79. Multi-site customization
  80. Admin menu disable new/delete page
  81. Show different pages on site depending on user choice
  82. Is there a way to limit multi upload in media upload box?
  83. Custom URL Structure for posts with subcategories
  84. How to loop through 1 CPT with 2 Taxonomies
  85. Pulling posts into static site (wordpress as subdirectory)
  86. Call a duplicate registration form with other url
  87. 404 for some custom taxonomy not ALL taxonomy
  88. How to support extra color options for shortcodes?
  89. retrieve theme custom settings
  90. WP Customizer – what types of fields is it capable of supporting?
  91. Add default content to post (for specific category)
  92. pull custom fields values from wp-database in a nested foreach loop
  93. Display one post randomly from category on home page
  94. How to make a template for a specific post of a custom post type?
  95. Pass query param to custom page
  96. Custom CSS File wont work on second Page
  97. How to create a shortcode with HTML code in it and custom parameters/
  98. Post’s arent displaying
  99. responsive screen not working [closed]
  100. Custom Menu (only showing direct cildren) ACF not showing