JoshSweeney

WordPress Lost My Post and then I Got it Back

About a week about I wrote a small post ( SugarCRM Atlanta Meetup – Tips, Tricks and Tools ) as a follow up to a local Meetup that I attend and assist in organizing. After writing it I had to run out the door so I saved publishing until I could double check for spelling and other errors.  Once I returned, I published the post and didn’t log back in for a few days.

A few days had past and logging in showed that there were a few plugin updates and one Worpress update. Using one of my favorite features “automatic upgrade” I made a few clicks and the job was complete. Shortly after I checked to see how Google was doing with parsing my latest sitemap I realized that there was 1 404 error where a page could not be found. It was my latest post. I proceeded back to my blog admin section and it was completely gone. I am still not sure if it was the WordPress upgrade, a plugin upgrade or bug, or just user error.

The next step was to get it back. No matter how small the post, nobody likes to spend time disseminating information to have it disappear.

Step 1 to getting it back was to see if it still existed. I  logged into the database and searched through the posts table until I found the post. Luckily it was still there.

For step two I logged the id of the latest revision of that post and then opened the edit view on an existing post. After that I substituted my ID in the URL. This didn’t give me the edit view as expected but a revision view showing the latest revision and all past revisions. Since I didn’t see a way to post that revision or save it in some way I simply created a new post on another tab and did a copy and paste.

Now my post is available for the world to see. Hopefully you don’ t ever loose a post, but if you do, here is how to get it back.

Tags: missing post, SugarCRM, wordpress