WordPress doesn’t show all posts in database

Are you sure those aren’t pages, drafts, trashed, revisions or attachments? To make sure that those aren’t such, run the following in

  • phpMyAdmin (Query tab – field “SQL query on database [database name]:”)
  • Adminer
  • In the terminal
  • …

and see how many results you get:

select * from wp_posts where post_status="publish"

Related Posts:

  1. What is this JavaScript “require”?
  2. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  3. Can I have multiple primary keys in a single table?
  4. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  5. get_results using wpdb
  6. How can I make a WordPress database portable and url independent?
  7. wpdb->insert multiple record at once
  8. How to migrate a HTTPS WordPress installation to localhost?
  9. How to monitor server for error establishing a database connection
  10. How to create bulk page and content? [closed]
  11. Default WordPress settings API data sanitization
  12. Fatal error: Call to undefined function dbDelta()
  13. Connect to remote database using Localhost install
  14. remove missing image attachments
  15. Transient RSS feeds in wp_options not removed automatically?
  16. Best way to move live site local
  17. The revisions table in my database is at 70% capacity and growing. What should I do?
  18. WordPress for a very large website
  19. How to ensure data consistency in WordPress
  20. Database location in WordPress
  21. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  22. WP_list_table bulk_action get edit and delete
  23. How to display data from custom table in wordpress database?
  24. How to intercept update_option() before it saves data?
  25. Change SQL get_results to search for posts with custom term in custom taxonomy
  26. wpdb query on custom table not working [closed]
  27. How to diagnose and keep in check encoding issues?
  28. Add search Value to wp_list_table pagination
  29. stdObject stored in database. How does one convert it to usable format?
  30. I have a table I created, how do I make a form for a user to filter the data?
  31. How to fix unchanged URLs in Database after running serialized search and replace script?
  32. wp_redirection_404 table has grown to 7GB
  33. Does WordPress ever need multiple databases?
  34. Why are no posts showing despite my apparently correct DB restoration?
  35. Cannot update custom database table row
  36. Adding new row to wp_post table
  37. Show last modified date of database
  38. How to interact with another wordpress install on same database?
  39. What generates these very slow postmeta queries? [closed]
  40. How to migrate a website based on a custom database to wordpress?
  41. Saving into post_excerpt or post_content
  42. Maintain user profile data in a non-WordPress database
  43. How to scan barcode and store data into a database [closed]
  44. Fetching values from database for select box
  45. Setup private content for specific users with daily updates [closed]
  46. fastest replacement DB
  47. Connection refused on locahost after importing database?
  48. When to use custom DB tables or add_option?
  49. Have working sql query… trying to adjust it to use $wpdb
  50. Best host for running large mem and processor intensive WordPress sites?
  51. creating new field on mysql
  52. Does WordPress store the username as a primary key in the database?
  53. Strange characters added to the database
  54. WSOD 3.9.1 – Tried Everything so far
  55. Database Update Required – Update from command-line
  56. Sending posts from Python to WordPress
  57. Problem migrating to localhost
  58. SQL query to set posts in bulk based on the post content
  59. Automate WordPress website setup with prefilled data
  60. Custom search query by category id
  61. How do you render posts from outside wordpress?
  62. Website displays old version of page
  63. Image link issues after importing a database backup to my local web server
  64. multiple wordpress installs w/shared user database but separate content databases
  65. Second ezSQL initialization for MSSQL
  66. Fetch a single row from a custom table for to a given ID
  67. Database create or redirect
  68. Updating seperate database when post attachment is changed
  69. add featured image dialog box disappear
  70. Database structure cheatsheet
  71. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  72. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  73. How to get a list of articles related to a particular category from my other WordPress website?
  74. /wp-admin not accessible after migrating to local host (no plugin issue)
  75. set_transient fails if the value has more than 60.000 characters
  76. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  77. error establishing database connection (WAMP + filezilla)
  78. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  79. How do I update a WordPress wp_postmeta meta_value that contains many options
  80. How can I get $wpdb to show MySQL warnings?
  81. About wp database hooks (error establishing connection)
  82. Auto populate form fields based on serial input or pull listings from other websites?
  83. How to extract some part of WordPress full source code
  84. Create Tables in WordPress
  85. Error establishing a database connection for some files
  86. Hash user emails in database?
  87. WordPress Failed to Login (DB Error)
  88. Weird characters in title if it contain “ ”
  89. Share WordPress Database
  90. DB access blocked when initializing WP externally
  91. Saving data to database and exporting to excel
  92. Site does not work right, pages not showing up, even for root admin
  93. ERROR: “Table Prefix” must not be empty
  94. How do you build a database-centric site in WP?
  95. One information repeated on multiple locations on one site [closed]
  96. WordPress: Interact with Database Query Data and Login
  97. Showing Error(TAble already exist)
  98. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  99. Cant Connect to Database
  100. WordPress database connection failed, while mysql client is working [closed]