1

I have around 140 post in database but wordpress admin page shows just 50 post. How could I let wordpress shows all the posts in database?

Thanks

  • 1
    3x the posts in the DB could mean that you also got trashed posts, attachments, etc. – kaiser May 30 '11 at 18:26
3

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'
  • 1
    Thanks Alex you are right. How could I manage those hidden posts? – Feras Odeh May 30 '11 at 19:09
  • You can install Wp Optimize, a plugin that deletes everything you don't need anymore and optimizes your database. – Alex Dumitru May 30 '11 at 20:12
0

The post row in database is much more broad than what post is in admin interface. Extra posts are not something hidden, there are merely instances of things that aren't of post post type and are not displayed as such (or at all in some cases).

You don't really need to manage those, WP does that nicely on its own. The one exclusion would probably be post revisions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.