#927150 spamassassin: awl sql file is missing field, causing error message on each INSERT

Package:
spamassassin
Source:
spamassassin
Submitter:
Michael Krieger
Date:
2026-06-29 16:01:01 UTC
Severity:
normal
#927150#5
Date:
2019-04-15 15:40:45 UTC
From:
To:
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.
#927150#14
Date:
2026-06-29 15:32:12 UTC
From:
To:
close 927150 3.4.3~rc6-1
thanks

This was closed ages ago.