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: dbmail@dbmail.org
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
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
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
