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 [email protected]|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

  • Delta04 it seems you have to alter your DB - execute this query in the db (cli, phpmyadmin or whatever) - if you have default names it should be this:


    Code
    1. ALTER TABLE `imscp_spamassassin`.`awl` ADD `last_hit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP


    Tell here if it's ok now.

  • Looks like it is working. At least I don't see that error anymore.

    Thannks!


    PS: I really hope that imscp is not a dead project event that looks like it. Maybe it is going to be forked somehow and continue as a different name, like it was ispcp...