My b2evolution Version: 1.8.x
For some unexplained reason one of my posts (#624) and the accompanying comments got deleted from my database. I was able to recreate the post itself and after making a test duplicate (#626) I was able to successfully run a query to put the post back into the database with its proper 624 number.
Or so I thought.
Even though I can see the post in PhpMyAdmin, and I can edit fields when I browse evo_posts, it will not show up on my blog. I've made it draft, I've made it published. I've stopped and restarted mysqld and Apache, all without success.
Any ideas??
Did you add a corresponding entry to your evo_postcats table? It'll be post_ID and cat_ID(s) with one line per category. Oh and those might not be the official names of the fields, but the thought's close enough to run with. I hope...