I recently upgraded my blog from WP 2.0.9 to 2.3.2. I ran the upgrade on a local machine first to test things and I discovered that all of my pages were turned into posts. After some research I learned about the new database structure and how the post_type of a page now had to be set to "page".
Thinking I was smart, I ran a SQL update query before the upgrade that set the post_type for all of my pages to "page" (posts where post_status = 'static'). The upgrade seemed to run fine, and my pages retained their page designation, while their post_status was set to "publish". And they do in fact get treated as pages when my blog is viewed normally.
But here's the really weird part: They don't show up at all in the "Manage Pages" admin screen. The only way I can get them to show up is to enter a search term, and then the pages that match will show up. But if I try to filter by the pages authored by me (I'm the only user in addition to Admin and I have admin permissions) then no records are returned.
I'm about to lose it... I have reviewed the records using PHPMyAdmin and I just can't see any reason they should not show up. What am I missing here?