Posts not displayed, but still in database

  • Resolved sseeger

    (@sseeger)


    11 years, 9 months ago

    Hello!

    I looked at my WP site this morning, and noticed that all posts after 2012-09-27 are missing! This is both from the view in the main site as well as in the Admin/Posts page.

    I have looked in the database at the wp_posts table, and I see all the posts I expect to. And yet they do not show up on the site – not even in the Trash on the Posts page.

    Help!

    I am reasonably certain that I am pointing at the correct database – I have checked wp-config.php, and it is pointing to the correct place. Also, if you look on the Admin / Comments / Spam page, there are spam comments from the present, dating back to before this problem showed up. (None of them point to any of the missing posts.)

    Background: This is hosted @ DreamHost, and they automatically update it for me. I was worried that something hadn’t gone right, so I downloaded the latest from www.remarpro.com and unpacked it on top of the current installation – nothing changed.

    I have disabled all my plugins, but it did not fix the problem.

    Anything else I should check? Any ideas?

    Thanks,
    Seth

Viewing 4 replies - 1 through 4 (of 4 total)

  • Have you tried repairing your database?

    Thread Starter sseeger

    (@sseeger)

    I used wp-dbmanager to repair tables, with no improvement.

    I’m now getting confused at what I’m looking at in the database, since each revision is listed as a row. Is there a SQL query I can run to see a list of unique pages?

    SELECT * FROM wp_posts WHERE post_type = "post" AND post_status = "publish"

    Should show you a list of published Posts.

    Thread Starter sseeger

    (@sseeger)

    Esmi – thank you for your help.

    I don’t know where they went, but all posts after a certain date disappeared! Back to my backups.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Posts not displayed, but still in database’ is closed to new replies.