My old entries exist, but do not show up in the archives??

  • Resolved rhondalicious

    (@rhondalicious)


    18 years, 2 months ago

    I recently reinstalled my WP blog – it was running until September of ’06 with no problems, and today I reinstalled it and imported the entries I had made in my LiveJournal in the time since then and now.

    I can see my new entries, the ones I imported, just fine. They show up in the archives drop down, and everything.

    All my entries from April 06 and earlier are accessible if you type in the URL for them, and the earlier months pages are also accessible only by typing in the URL.

    If you go to my site ( https://blog.rhondalicious.com ) and click on the Archive drop down menu in the sidebar, you will see as far back as May 2006. There’s no way to navigate earlier than that – but if you type in the URL, you can see as far back as https://blog.rhondalicious.com/?m=200107 July of 2001…

    The same goes for my categories – if you click into a category, you see what entries are there only since May of 2006.

    Can anyone help me figure out how to rescue my blog and get the entries back where they belong?

    Edit: Also, my old pages that I created are gone – the admin doesn’t see any pages created, and clicking on my old page links don’t bring anything up. That’s not as important, though.

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

  • Actually I’m not getting any posts for early 2006 nor at the link you give for 2001. Comes up with the standard “Sorry, no posts matched your criteria.” error.

    edit: I checked 200512, 200601, 200602, 200603, 200604, and 200107

    Thread Starter rhondalicious

    (@rhondalicious)

    Hmmmm.

    Very weird.

    Is it possible that somehow they are all marked private? And if so, how could I get them back?

    EDIT: That has to be it – I decided to go into the admin section to Manage Posts, and they are all in there…

    That’s really weird.

    Anyone know an SQL query I could run that would make them all public again?

    SECOND EDIT: For the sake of those searching in the future,

    UPDATE posts SET post_status = 'publish'

    worked fine for me (where posts is the name of my table – yours might be different).

    Assuming your $table_prefix in wp_config.php is ‘wp_’:

    UPDATE wp_posts SET post_status='publish' WHERE post_status='private';

    Before beginning please backup your database!

    Thread Starter rhondalicious

    (@rhondalicious)

    Thanks so much ^_^ Luckily, I’ve got backups up the wazzoo. I’m paranoid, ever since the day I accidentally deleted like, 6 months worth of posts.

    rhondalicious,

    Your code up above would have changed everything in your wp_posts table including turning Pages (post_status =’static’) into Posts. You might have to use phpMyAdmin to change any pages that got turned into post back to post_status=’static’.

    Or restore your backup and try:
    UPDATE wp_posts SET post_status='publish' WHERE post_status='private';

    Since posts is your Post table that means you have a blank value for $table_prefix in wp-config.php.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.remarpro.com Admin

    Also, that query would have broken any attachments you may have had.

    Seriously, don’t do things to the database like that. ??

    Ummm. I’m confused. I don’t see any difference between either query MichaelH posted….

    vkaryl

    Oops, sorry I wasn’t clear, the code rhondalicious used would have caused the problem–there was no difference in what I posted.

    Ah. Thanks, I didn’t even notice the code in her post…. what happens when I try to think when I’m sick.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘My old entries exist, but do not show up in the archives??’ is closed to new replies.