A zero displaying in the Archives

  • Hi,

    on my site https://tcal.net/ in the archives down the bottom left – a little 0 is appearing below the various months links that goes to the January 2005 posts. Anyone any suggestions whats causing it? I can’t find anything obvious in the index.php or in the archive options.

    Any help really appreciated,

    dave.

Viewing 7 replies - 16 through 22 (of 22 total)
  • Thread Starter tcal

    (@tcal)

    I have looked through the dates as above, but i have 1000+ posts in my db so it’s pretty hard to spot the problem ones.

    Even just from January (pretty sure thats when the problem appeared, jan 2005) I have about 200 or so posts to look at and just cant find anything obviously wrong like a 1969 date. I also never ported over posts from another cms or anything like that.

    Any chance you can rack your brains Jerry and think about what it might have been that fixed it?

    I know it’s a small thing, but I’m on the verge of a relaunch for the site with a brand new layout and all sorts of features etc. and I’d like to get this little niggle out of the way if at all possible.

    You know something did come to mind.

    In the wp_posts, along with those 1969 posts, some dates in the “post_date” field that read 0000-00-00 00:00:00. I’m guessing this was what caused the problem. Try sorting “post_date” by ascending order to see if it helps.

    Also, for me, the “0” link didn’t just link to January 2005. It always just linked to the current month.

    I’m really sorry I can’t be more specific. I never was good with computers.

    i had this kind of problem too, i suspect one of your post was not specifically have any dates on it? after i changed my post with a specific date, the zero in the archive is gone. give it a try?

    Thread Starter tcal

    (@tcal)

    Success! I used phpmyadmin to search the entire database for anything with 0000-00-00 00:00:00 in it. And indeed, one item in wp-posts had a date: 0000-00-00 00:00:00 1969-12-31 23:59:59

    Deleted that, and the 0 is gone. Thanks a million to everyone who helped, I know this was a small thing but it was bugging the hell out of me and now it’s fixed. ??

    Glad to hear it’s finally resolved.

    Had two posts with this problem and this solution worked for me, so thanks to everyone for the help.

    I thought I’d post my solution to this issue in case it helps anyone.

    I am a phpmyadmin novice…so I was stupid and dropped some stuff and screwed the whole works up. So I deleted WP install and the DB and tried a new install. I noticed the problem was still there.

    The new install, as was the prior one, was from a Fantastico automated install. So I deleted my new install and DB, started over, and this time I did the install myself.

    I don’t know why installing from Fantastico caused issues, but when I did a manual install myself, it was completely clean. So, just a caveat for people installing from Fantastico.

Viewing 7 replies - 16 through 22 (of 22 total)
  • The topic ‘A zero displaying in the Archives’ is closed to new replies.