Package: spamassassin
Version: 3.4.2-1
Severity: normal
Dear Maintainer,
The last_hit timestamp is missing on the the awl table (similar to the txref
table) since 3.4.1
last_hit timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
This should be updated in /usr/share/doc/spamassassin/sql for both
postgresql/mysql.
An upgrade note should also be raised to alter the schema on upgrades (or if it
doesn't exist)
See:
https://svn.apache.org/viewvc?view=revision&revision=1844485
for patches.
-- System Information:
Debian Release: buster/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.19.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8),
LANGUAGE=en_CA:en (charmap=UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages spamassassin depends on:
ii adduser 3.118
ii curl 7.64.0-2
ii init-system-helpers 1.56+nmu1
pn libarchive-tar-perl <none>
ii libhtml-parser-perl 3.72-3+b3
ii libhttp-date-perl 6.02-1
ii libmail-dkim-perl 0.54-1
ii libnet-dns-perl 1.19-1
ii libnetaddr-ip-perl 4.079+dfsg-1+b3
ii libsocket6-perl 0.29-1+b1
ii libsys-hostname-long-perl 1.5-1
ii lsb-base 10.2019031300
ii perl 5.28.1-6
Versions of packages spamassassin recommends:
ii gnupg 2.2.12-1
ii libio-socket-inet6-perl 2.72-2
ii libmail-spf-perl 2.9.0-4
pn libsys-syslog-perl <none>
ii sa-compile 3.4.2-1
ii spamc 3.4.2-1
Versions of packages spamassassin suggests:
pn libcompress-zlib-perl <none>
ii libdbi-perl 1.642-1+b1
pn libencode-detect-perl <none>
ii libgeo-ip-perl 1.51-1+b1
ii libio-socket-ssl-perl 2.060-3
ii libnet-patricia-perl 1.22-1+b5
ii pyzor 1:1.0.0-3
ii razor 1:2.85-4.2+b5
-- Configuration Files:
/etc/default/spamassassin changed [not included]
/etc/spamassassin/init.pre changed [not included]
/etc/spamassassin/local.cf changed [not included]
/etc/spamassassin/v310.pre changed [not included]
/etc/spamassassin/v341.pre changed [not included]
/etc/spamassassin/v342.pre changed [not included]
-- no debconf information
