disappearing posts

  • I wrote a post earlier tonight and noticed a mistake so I clicked on the “edit this” link on the post, edited it and saved it. I noticed later (maybe a couple of hours later) that the edit didn’t appear on my blog, so I clicked “edit this” again and went to fix the mistake (thinking maybe I’d hallucinated the part where I fixed it before), but when I looked at the post in the edit screen, the fix was there. I clicked “save and continue editing” just to look and see if the edit would appear in the post, and it did, so, satisfied, I saved the post. When WP returned me to my blog, everything was gone. All that was left in the text column was “Sorry, no posts matched your criteria.” I went back to the dashboard and clicked the Manage tab, and it said I had no posts.

    I have a recent comments plugin in one of my sidebars, and when I click on one of them, it will take me to the post and the comments, so things still appear to be there, but they’re invisible and I can’t get to them.

    Any suggestions?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jamelah

    (@jamelah)

    Further information:

    My site: https://www.jamelah.net

    I use Yahoo webhosting and it is set to automatically install updates, yet everything says I am running version 2.0.2. I am still able to get into category archives (though the “Everything” category where I put all my posts is missing). I was able to get to posts via the latest comments in the sidebar, but currently I am getting the following error:

    WordPress database error: [Got error 127 from storage engine]
    SELECT COUNT(DISTINCT ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2008-07-20 16:03:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment”

    It appears twice above my blog header, once in the text column, and in the sidebar where links to latest posts and latest comments used to appear.

    Thread Starter jamelah

    (@jamelah)

    Actually, looking again, the errors are different.

    Above the header:

    WordPress database error: [Got error 127 from storage engine]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2008-07-20 16:03:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

    WordPress database error: [Got error 127 from storage engine]
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2008-07-20 12:03:53’ AND post_date != ‘0000-00-00 00:00:00’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

    In the text column:

    WordPress database error: [Got error 127 from storage engine]
    SELECT COUNT(DISTINCT ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2008-07-20 16:03:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment”

    Where links to the latest posts should be:

    WordPress database error: [Got error 127 from storage engine]
    SELECT * FROM wp_posts WHERE post_date < ‘2008-07-20 12:03:54’ AND post_status = ‘publish’ ORDER BY post_date DESC LIMIT 6

    Where links to latest comments should be:

    WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)]
    SELECT ID, comment_ID, comment_content, comment_author, post_title FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = ‘publish’ OR post_status = ‘static’) AND post_password =” AND comment_approved = ‘1’ ORDER BY comment_ID DESC LIMIT 12

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘disappearing posts’ is closed to new replies.