Wrong archive display after Wordpress import

[gimmel]

While working on the template for bestatterweblog.de I found a mysterious bug in the archive view.
The years 1999 to 2006 are listed, but there are no entries in this period. The entries were imported from a wordpress installation, that may be the reason, but I don't now how to fix that.

[garvinhicking]

Hi!

s9y always shows the archives from NOW up until the date of your first entry. It seems that one of your older entries must be posted in October 1999 - can you check the serendipity_entries DB table, sort it by the "timestamp" column and see which one is the first entry? That's your oldest one, and it might be that it is a draft entry, that's why it's not displayed but counted in the archive view?

Regards,
Garvin

[gimmel]

I have no access to the actual database. But I have an import of the original (old) wordpress db. Guess what? All drafts got a timestamp of November 1999. The timestamp of the drafts in wordpress was 0000-00-00 00:00:00. Funny.

You're a genius…

Thanks, Garvin!