Re: [CSCMail-Users] Billenium Bug

[Steven K. <st...@re...>]

Gavin Brown wrote:

> I've been doing a bit of investigation and I think (although I'm not sure) that CSCMail might have a bug. It would probably apply to Pronto too. The short explanation is:
>
> CSCMail's got the Billenium Bug!
>
> It seems that all mail in any folder with a date after the Billenium (when the UNIX epoch became 1000000000, or Sun Sep 9 01:46:39 2001) is listed *before* all mail before that date. I guess that the first digit is stripped off to fit the database column, so that a mail message with a date of 1001939646 becomes 001939646. This is obviously < 999999999, and so is sorted above it.

save_message() uses date_to_localdate() to convert the "string representation" of a date found in the message header to UNIX epoch time.  date_to_localdate() uses the &UnixDate() routine of Date::Manip.  I have tested Date::Manip, and it "does the right thing"

Message sorting is handled by using a "hidden" column in the GtkCList widget that contains the UNIX Epoch time value.  It is this column (which is not displayed) that is actually getting sorted when you click the "Date" column.

If you want to see this column, simply comment out line 4760 in cscmail.  This will allow you to verify that the proper number has been inserted into the table.  Please do this for me so we can troubleshoot this bug.  It is intirely possible that Gtk+ does the truncation you discribe in it's sort routine...

Let me know what you find out, also are others seeing this problem?

-Count Zero