Yesterday I had the first and only WordPress crisis ever since I installed it several years ago. When I tried to update an old post, the post would just revert to it’s previous state, losing the text that I’d added. I tried all kinds of things with plugins and cache etc., none of which solved it. Then last night, my front page said ‘You’re looking for something that isn’t there’, and displayed no data. This morning, I clicked on a link to a post, and it was ‘not found’.
I then decided to follow one of the hundreds of bits of advice I’d seen yesterday while searching for an answer. It seemed the most drastic, so I didn’t take it then, but today I effectively had no site any more, so I thought I might as well. I wish I could remember whose advice it was to thank them, but I can’t, but whoever you are, thank you.
The trick is this – obviously, it’s only relevant if you have a site hosted on a server that uses CPanel, but that covers a lot of people:
1. Log in to the place where your site is hosted, and go to your CPanel
2. Select SQL databases
3. Go to the bit that says ‘Repair database’ (I missed out the ‘check database’ step, though I guess I could have done that)
4. Select the database(s) that relate to your WP installation (they’ll have WP in the name probably)
5. Click ‘repair’
I did this, it took 2 seconds, and everything’s now back to normal. I don’t really want to know why, i”m just glad it worked.
3 thought on “Missing wordpress posts? Can’t update old pages? Try this”
[…] I usually consider myself pretty adept at solving WordPress related issues but this one was stumping me so I did what all developers do when they are in a tight spot and I googled it. Most posts turned up were completely unrelated, but one article suggested that the issue may be symptomatic of a corrupted table. […]
Can be a bit of a tricky one, I used SuperTasker to find a wordpress pro, told them my problem and they turned it around in a couple of hours. Might be worth a go for you too.
Hi Sarah, thanks very much for the tip about SuperTasker – at the moment everything’s working OK, but it sounds like the place to go if something like this happens again.