Missing Posts

I went to load up one of my WP blogs today and every page I try ot hit is throwing a 404 error.

The index/home page, pages & posts I KNOW are marked as published and are dated in the past (ie. not scheduled)

I looked in my DB tables and everything seems in order, I see all my posts & revisions in there. When I load up the admin and go to the posts page I see this:

* All (25) |
* Published (4) |
* Drafts (21)

Search Posts:

No posts found

No matter if I’m on the ‘all’, ‘published’ or ‘draft’ page it says there are no posts found.

What’s super weird is that on the admin dashboard I see the drafts, and I can click in to edit the individual drafts, but when I save or preview them they continue to not appear in the ‘posts’ listing page and throws a 404 error (respectively.)

The site is running WP 3.0.1 – I even downloaded a fresh copy and uploaded that over my existing files – did not fix
I disabled ALL my plugins and cleared my cache – did not fix.

I checked other WP installs that are on the same database and they are working fine, same with other installs on the same server but using a different database. It’s just this one blog.

I backed up my database and exported my posts (the export tool shows ALL the posts without a problem)

Fortunately I was planning to shut down that project (it gets under 10 views/day because I haven’t publicized it) so I’m not in a dire situation but this might be a bug.

Anyone else ever have this happen? It’s so weird! I searched but didn’t find any relevant topics or bugs like this.

I can provide additional data if anyone thinks they might have a solution or want clarification about what I’ve been rambling about!