WordPress’ ALL post count info on its dashboard does not match phpMyAdmin’s ALL post count!

It all comes down to this.
http://core.trac.wordpress.org/ticket/11889

Behind the scenes, WordPress does generate a place-holder post for your next one! And for that special post, it sets the post_status to a special one, ‘auto-draft’. Basically, the culprit is the post generated by WordPress without your knowledge.

Once you know this fact, it is easy to understand why there is a disconnect. WordPress admin screen’s ALL count info is based on ALL posts except this special one. WordPress’s SQL’s WHERE excludes the post whose post_status=’auto-draft’.

Whereas, phpMyAdmin’s SQL’s WHERE needless to say, totally lacks this condition, and hence we end up with the -1 disconnect between the two ALL post counts, causing guys like me the WTH situation.

So under the hood, the cause of the disconnect is this…

select count(*) from `wp_posts`

vs

select count(*) from `wp_posts` where `post_status` <> 'auto-draft'

Related Posts:

  1. How to Arrange Posts by Size in the WordPress Dashboard?
  2. Develop Admin Panel Page
  3. How to view a post from the wordpress admin screen
  4. How to add an admin notice upon post save/update
  5. How To Disable (or Remove) “All Posts, Published, and Trash” in Dashboard Posts
  6. Change label of title field for posts in the backend
  7. Exclude drafts in all() view of edit.php
  8. List latest posts in WP-Admin
  9. Open WordPress ‘Add New Post’ admin page with parameters set via $_GET
  10. using slug instead of ID in admin edit post url
  11. Categories box not showing on post edit pages
  12. Include Sticky Post in Page Posts Count?
  13. Make “Post published. View post” Open in a New Tab
  14. How to get new post URL?
  15. How to remove bulk edit options
  16. Get all posts by post_author
  17. Add confirmation popup on “Move to Trash”
  18. Embed WordPress Admin in an iframe
  19. Can’t publish, edit or delete posts since Gutenberg update
  20. Send email to user that his post has been rejected
  21. Add filter-by-tag in the all posts admin console page
  22. Remove some articles from the list in WPAdmin for a user
  23. How to place HTML below the title of the (custom) post overview
  24. How do I allow users to follow a post and then allow admins to email all users who have followed that post?
  25. Custom Theme Want To Remove One Category From All Displays
  26. Invalid post type when click “Filter” or “Apply” button in WordPress admin Post list [closed]
  27. How to change the title url on the edit post screen?
  28. Change Order of Admin Posts Depending on Meta
  29. Diplay comment date on WP_Post_Comments_List_Table
  30. Change default Posts page
  31. I am unable to publish/update post
  32. Disable inline_edit() on edit.php
  33. After database migration, posts not showing up in dashboard
  34. Display Meta Values in Custom Filter – Admin Custom Posts
  35. Lost draft under all posts and drafts
  36. Simultaneous admin updates causes custom fields to not update
  37. Hook in to add new post link wp admin?
  38. remove post and categories/tags count from right now dashboard widget
  39. plugin to post from admin to flickr [closed]
  40. Retrieve only posts from a specific user in wp-admin/edit.php
  41. Adding an Archive button to posts page for administrators
  42. How show categories in admin and get that selected to show posts in index
  43. Change post-slug using wordpress API? Change permalink of a post using php / jquery?
  44. How do you change the comment count in the back end posts list, to reflect unapproved comments, rather than all comments?
  45. Fast publishing in wordpress
  46. Which file do I need to edit the All Posts page in the admin area?
  47. How do you search for a post or page with a certain url on the WordPress admin panel?
  48. How to get the old WordPress Draft Editor view back with the Word count?
  49. Change the color of the Password Protected Post titles
  50. Bolding several words at once
  51. Sort All Posts by Category Name in the Admin Panel?
  52. List latest posts with least comments in WP-Admin
  53. Lightbox on wordpress post page
  54. Some blog posts containing source code fail to save draft or publish
  55. I want to add another search box on posts page in dashboard
  56. Edit post & page option does not display on latest wordpress
  57. Cannot create new posts or upload images using media manager
  58. user_has_cap filter allows “edit_others_posts” but not is not allowing updating/publishing
  59. ‘QTags.addButton: arg2 distorts the button rather than just shows
  60. Custom Fields – How to get the list of a specific active widget each time it rendered
  61. My page shows some other content in WP
  62. the wp_post_update isn’t working all the time
  63. Redirect old Posts URL to new URL
  64. Post count doesn’t match number of posts shown in list in admin
  65. link to edit a post has empty target
  66. Remove status ‘archived’ from the default post and page view
  67. Strange behaviour in WordPress admin
  68. How to show WP admin edit page within template page/post?
  69. WordPress Screen Options, Help, Visual editor, Status, Visibility, Revisions, Published on and any toggled indicator don’t work for posts
  70. Many buttons not functioning in WordPress dashboard (as admin)
  71. Redirecting to “All Posts” after post publish or update
  72. Very weird behaviour after removing WP pages
  73. How to display post excerpt beside post list inside Post of Dashboard
  74. Set featured image on creating new post
  75. Blank page after changing number of post displayed in wp-admin
  76. How to sort posts in admin by name
  77. Get from the dashboard the ID of the current post being edited
  78. Hide Admin posts & pages in Dashboard
  79. Is it possible to display QUICK EDIT as default for all posts in wp-admin/edit.php page?
  80. How can I filter the post of a CPT by taxonomy Term in admin meta-box dropdown?
  81. issue in wordpress auto delete post and redirect to another 1
  82. How to enable comments meta box for other author posts?
  83. Admin is showing all posts on page 1
  84. Post preview in iframe without saving the post
  85. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  86. How to change the publishing date of each posts?
  87. Error establishing a database connection
  88. Creating / Editing a post from within site template
  89. How to get override the WP Admin Syndication feed limit for a custom feed?
  90. Post thumbnail is not shown in wp-admin
  91. find view post hyperlink in PHP wordpress admin file
  92. Creating a new Sortable Column in WordPress Admin
  93. Enqueue CSS on custom posts’ backend area
  94. What does WordPress mean by they have full rights to content [closed]
  95. Add News Feed to bespoke website, only to one page on whole site
  96. Post Format Status [closed]
  97. Allow User Can See His Post on his dashboard
  98. Display posts with id equal to relationship value
  99. WordPress shows a count of published items on the site, but the items are not appearing when you click on the “published” link
  100. I cannot see the pagination in /wp-admin posts page