Updated WordPress and lost random posts

1) post a link to your site

2) what do you mean disappeared? Are they under posts->all posts on the dashboard? What happens if you try to get to them from the front end?

1) nelsonscolumnlondon.com

2) They’re not under any category of post, published or otherwise. Links I had posted on social channels to said posts lead to the home page. I can’t even find a cached version anywhere. It’s as if they never existed – but they must be somewhere, surely?

PS – thanks for responding.

It’s as if WordPress cut out posts between October 2015 and February 2016. Recent posts and older posts are all present and accounted for.

hmmm….

Do you have access to phpmyadmin? find the database and check the two tables “wp_posts” and “wp_postmeta”. At the bottom, where it says “with checked”, select “check tables”. I’m wondering of the post tables might be corrupt.

Do you have access to phpmyadmin? find the database and check the two tables “wp_posts” and “wp_postmeta”. At the bottom, where it says “with checked”, select “check tables”. I’m wondering of the post tables might be corrupt.

I will download it now and try that, thank you!

I’m sorry, nothing is making sense. I’ve downloaded phpMyAdmin but it’s a zip file, what do I do with it from here?

Meanwhile, I have logged into my webhost cloud panel (can’t get into any sort of cpanel, annoyingly, only cloud) and have found some back-up data files. Does anyone know how I restore these? Nothing it clear to me.

phpmyadmin would be on your host someplace in the control panel. Check with your hosting support. Don’t go restoring stuff when you don’t understand what the original issue is.

OK Sterndata – finally got there. Have found wp_posts and wp_postmeta but can’t see the check options you mentioned… Feel like I’m close though!

like this:

https://dl.dropboxusercontent.com/1/view/5l2ni9floi1qo1b/Apps/Shutter/Selection_01_2016_05_21_13%3A51%3A26.png

Hmmmm. See, this is all I get….

https://dl.dropbox.com/s/cyw4s20nzusrtzd/agro.JPG?dl=1

You have to check the tables first for the dropdown to become active.

Thanks, OK, but the weird thing is, looking at phpMyAdmin, the only posts showing there are Nov 2013 and earlier. Why would it not be showing any newer posts, esp as most of the newer ones are still on the site (it’s just the batch between Nov 2015 and March 2016 that are missing.)

Appreciate your help so far. Feel like I am getting closer!

PS – Whenever I have managed to restore an old database (via both cpanel and manually through myPHPAdmin) it seems to work until I log into my site again and get this:

Database Update Required
WordPress has been updated! Before we send you on your way, we have to update your database to the newest version.

Which reverts me back to the present issue. ??

As for the missing posts, I now have a feeling these were lost after switching webhosts. I switched in October but the nameservers weren’t changed until March. So posts that went up in that time are the ones that are missing. It seems the most logical cause. Still have to work out how to get them back.

All resolved. Spoke to my web host support and we worked out that somehow, a few files were left behind when I switched web hosts. Thanks all for your advice.