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

Hi,

give some informations to your system and versions of i-mscp and Plugins.

Greets
Chris

@gerusu

What was your previous SpamAssassin plugin version?

@Nuxwin,

is it sufficient to delete the entries in imscp_spamassassin.userpref where username is $GLOBAL?

Greets
Chris

@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.

@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.

Quote from gerusu

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