Display More
Reporter Michael Rhyner (mikerhyner) Created Nov 14, 2018 11:16:07 PM Updated Nov 14, 2018 11:16:21 PM Priority Normal Type Bug State Submitted Assignee Laurent Declercq (nuxwin) Subsystem SpamAssassin plugin Affected versions 1.5.1 Milestone 1.6.0 Severity No severity It seems that update from spamassassin 3.4.0 to 3.4.2 (coming from debian upstream) needs a database schema upgrade. Every database query on awl table will fail with following error msg in mail.log after the upgrade:
spamd[23783]: auto-whitelist: sql-based get_addr_entry [email protected]|none: SQL error: Unknown column 'last_hit' in 'order clause'
As found on spamassassin svn repo [1], a schema change of awl table within imscp_spamassassin database seems to be neccessary:
ALTER TABLEawl
CHANGElast_update
last_hit
timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
Attention: With current debian version 3.4.2-0+deb8u1 which I'm using, as they have backported only parts of 3.4.3, not the whole new structure of awl table should be used / changed to, as spamassassin code will still use field 'count' instead of new 'msgcount' !
So I think plugin should be adapted for supporting spamassassin 3.4.x...
[1] https://svn.apache.org/viewvc/…ew=markup&pathrev=1844485