problem with plugin - Error in logfile - spamd: SQL error: Unknown column last_hit

  • hi Guys


    I have a little problem with the spamassassin plugin. I have had the problem for several days that my mysql-db dies. I also get the following error message for some time. the DB problem may depend on the spamd problem. in logfile mail.info i found many of this logentrys:

    Code
    1. Apr 28 17:06:12 web22 spamd[10586]: auto-whitelist: sql-based get_addr_entry mailer-daemon@mail.xxxxx.de|none: SQL error: Unknown column 'last_hit' in 'order clause'


    I looked for something and found a post from Nuxwin that is a bit older but could fix the problem

    https://youtrack.i-mscp.net/issue/IP-1808


    now my problem: how can I get the updated spamassassin plugin in version 2.1 that I found here? To me it looks like it hasn't been released yet.

    https://github.com/i-MSCP/plug…16/incubator/SpamAssassin

    regards, Frank

    Support Infos: I-MSCP Version: 1.5.3 / Distro: Debian Stretch / PHP: 7.1.33 - FPM / I-MSCP Plugins: Let´s Encrypt 3.5.0 / and many others

  • thanks, that fixed the problem

    Support Infos: I-MSCP Version: 1.5.3 / Distro: Debian Stretch / PHP: 7.1.33 - FPM / I-MSCP Plugins: Let´s Encrypt 3.5.0 / and many others