Plugin::SpamAssassin::_setSpamassassinUserprefs: Error while executing statement: Duplicate entry '$GLOBAL-use_pyzor-0' for key 'user_pref'

  • Hi,


    I try to install SpamAssassin plugin and receive the following error:


    Plugin::SpamAssassin::_setSpamassassinUserprefs: Error while executing statement: Duplicate entry '$GLOBAL-use_pyzor-0' for key 'user_pref'
    :(

  • SO debian jessie
    i-mscp 1.2.9 updated according to information from the errata
    roundcubeplugins 1.2.1 (latest)
    spamassassin 1.0.2 (latest)

  • @gerusu


    What was your previous SpamAssassin plugin version?

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @Backdraft007


    Don't know. I must look at the SpamAssassin plugin installer because here, something is wrong.


    Give me somes minutes to investigate, fix and release a new version.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @gerusu


    Did you restored your previous SpamAssassin plugin configuration file? Could you post it here? (the old if you have a backup and the current one).


    Thanks.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • Hi all,


    Sorry for the late response; I left home and now I'm at the office.
    No, I have not restored the previous SpamAssassin plugin configuration file. This setup is more for tests, but I am prepare to upgrade installations of production servers. So...
    The old Spamassassin plugin was installed before the appearance of the i-masp version 1.2.3.


    Thanks,
    George

    Edited once, last by gerusu ().

  • Any idea how can I solve this problem?


    Thanks!

  • The old Spamassassin plugin was installed before the appearance of the i-mscp version 1.2.3.


    In errata file, it is clearly stated that you must delete all plugin before upgrade and install the last version available once the upgrade is done...


    How to solve (hard way)


    Delete the SpamAssassin plugin related data:

    • The imscp_spamassassin database
    • The row related to the SpamAssassin plugin in the imscp.plugin database table
    • The /var/www/imscp/gui/plugins/SpamAssassin folder

    Once done go to the plugin management interface and then:

    • Update the plugin list
    • Upload the last version available of the SpamAssassin plugin
    • Install it

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206