Tell me more ×
WordPress Answers is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

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

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

2 Answers

up vote 3 down vote accepted

Are you sure those aren't pages, drafts, trashed, revisions or attachments ? run this in PHPMYAdmin and see how many results you get select * from wp_posts where post_status='publish'

share|improve this answer
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
@Feras please pick this as an accepted answer if it helped you. – Alex Dumitru May 31 '11 at 3:49
up vote 0 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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