Note: The changelog on the website and within dbmail-1.2.2.tgz seems to be empty/blank.
----- Original Message ----- From: "Ilja Booij" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 05, 2004 10:04 AM Subject: Re: SV: [Dbmail] Fix for wrong internal date Done :) The changes are in CVS (in both 1.2 and 2.0) and I've made a DBMail 1.2.2 release, which can be found on www.dbmail.org, using the fix. Bret, thanks for finding the problem so quickly. Ilja On 30 Dec 2003, at 21:41, Mikael Syska wrote: > Will the team behind DBMail make a patch to the 1.2 source??? > > -----Oprindelig meddelelse----- > Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne > af > Bret Baptist > Sendt: 30. december 2003 16:00 > Til: [email protected] > Emne: [Dbmail] Fix for wrong internal date > > This code uses the next year of this current week if the last week of > the > year: > strftime(timestr, sizeof(timestr), "%G-%m-%d %H:%M:%S", &tm); > > > This code will always use the current year: > strftime(timestr, sizeof(timestr), "%Y-%m-%d %H:%M:%S", &tm); > > You need to go through the dbmail sources and change all strftime > lines to > look like above, with a %Y, instead of a %G. > > > Command to fix mysql entries. > > // It subtracts 1 year from the date in the internal_date column of the > messages table > > UPDATE messages SET internal_date = DATE_SUB(internal_date, INTERVAL 1 > YEAR) > > WHERE internal_date > now(); > > > -- > Bret Baptist > Systems and Technical Support Specialist > [EMAIL PROTECTED] > Internet Exposure, Inc. > http://www.iexposure.com > > (612)676-1946 x17 > Web Development-Web Marketing-ISP Services > ------------------------------------------ > > > Today is the tomorrow you worried about yesterday. > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- IC&S Stadhouderslaan 57 3583 JD Utrecht telnr. 030-6355730 faxnr. 030-6355731 PGP-key: http://www.ic-s.nl/keys/ilja.txt _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
