A Zero In The Archives, Revisited

  • Shari

    (@shari)


    18 years, 8 months 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.

Viewing 1 replies (of 1 total)
  • Thread Starter Shari

    (@shari)

    18 years, 7 months 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.

Viewing 1 replies (of 1 total)
  • The topic ‘A Zero In The Archives, Revisited’ is closed to new replies.