WordPress.org

Ready to get started?Download WordPress

Forums

A Zero In The Archives, Revisited (2 posts)

  1. Shari
    Member
    Posted 8 years ago #

    I'm having the same problem as was mentioned in this thread: http://wordpress.org/support/topic/21270#post-122411 and don't know how to fix it.

    I did a search within my database for posts with the date string: 0000-00-00 00:00:00, and found 212(!!) posts with this string in the "post_date_gmt" field in the table "wp_posts". I believe this is what is causing the "0" (which links to the current month's archives) in my Archives list.

    I don't know if this helps, but a couple of weeks ago, my host had some problems and when they came back up, I noticed the GMT time they had was completely wrong (almost a full day ahead). Contacted them, they fixed it, but it might have messed with my posts in that one field. Possibly?

    How can I fix this? Would simply upgrading to the newest WP version fix it? I have WP 1.5.1.3. Or should I not upgrade until I fix this problem?

    I know it seems like such a small thing, but it's driving me insane. Thanks in advance for your help.

  2. Shari
    Member
    Posted 8 years ago #

    I did the upgrade to WP 1.5.2 with no problems. I also implemented the Clean Archives 1.5 plug-in, which is awesome, but doesn't fix the zero in the archives problem. I didn't expect it to, though. I am hoping someone can tell me how to fix this problem, even if it's bad news, i.e., I have to go through each one of those fields and edit the date/time string.

    Thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic