Gary wrote: > Mark wrote:
>> A release candidate for amavisd-new-2.4.2 is available at: >> http://www.ijs.si/software/amavisd/amavisd-new-2.4.2-rc2.tar.gz >> Changes since -rc1: >> - further README.sql updates regarding data type TIMESTAMP in MySQL; >> - when recipient notifications for bad headers is enabled, and a message >> is spam with bad headers, recipient would receive an empty notification >> message (because message contents category is spam and recipient >> notification template for spam is empty); now a general recipient >> notification is sent in this case, and additional check added to ensure >> that empty notifications would not be send even if explicitly configured >> to be empty; >> - ignore $timestamp_fmt_mysql if SQL database driver (DBD) is not 'mysql'; >> - MySQL workaround: changed default clause in $sql_clause{'upd_msg'} to: >> UPDATE msgs SET time_iso=time_iso, ... >> just in case one forgets to use "DEFAULT 0" on "time_iso TIMESTAMP"; >> Mark > Mark, will this also set $timestamp_fmt_mysql = 1; if SQL database > driver (DBD) *is* 'mysql' ? > If not, then as I have said off list, I believe there is a potential > for loss of data under a particular circumstance we have discussed. > If $timestamp_fmt_mysql is false, data to the msgs.time_iso field will be > written in a form such as '20060615T041046Z'. MySQL will not know what > to do with this, so it will write '0000-00-00 00:00:00' to the > msgs.time_iso field. Note that it will write '20060615T041046Z' if the field was created as char(16) and $timestamp_fmt_mysql is false. My statements only apply to those who optionally created the time_iso field as TIMESTAMP NOT NULL and have failed to set $timestamp_fmt_mysql to true. > With this, a command like the previously recommended: > DELETE FROM msgs WHERE time_iso < now() - interval 7 day; > will delete all newly added records after the upgrade. Gary V _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
