Checking in to one of my clients sites today, something strange is going on with the posts, pages and anything in the wp_posts table.
When I delete a page it then shows the list of pages in the admin with 'no pages found'. It still shows the number of pages created in brackets at the top, but none of them appear in the list. Posts also disappear at the same time. The dashboard appears to be half there - the entire right hand column disappears. The site was using WP 3.1 when this started happening - I tried upgrading to see if it fixed the issue, but it's still occurring when pages are deleted. The first few times it appeared to fix itself after a while, but I really need it to not do this at all!
After a bit of research I took a look at the database in phpMyAdmin - none of the tables appear to have crashed, but I repaired and optimised the wp_posts table and the others anyway. All the posts etc appear to be intact in the database - it's just not getting through to the site. I checked to see if the host had the minimum requirements for WP 3.2 - all fine.
I deactivated all of my plugins, but that doesn't appear to have helped at all either. All the plugins are up to date.
I can't find anyone with this problem who didn't manage to fix it by repairing the database - any other ideas?