2022-03-11 01:09:48: Error occurred while updating SpamFireWall local base

Hello @avfadagio

Please, press the button “Synchronize with cloud” in the plugin settings (Plugins-> Anti-Spam by CleanTalk -> Settings).

After 15 minutes refresh the page.

Please, tell us if this helps or not.

That did not seem to help. Same error message.

Didn’t work for me either.

This was in the debug log. I don’t know if this helps you at all or means anything.

ArrayObject Object
(
    [storage:ArrayObject:private] => Array
        (
            [02:46:19_ACTION__FUNCTION_] => Array
(
    [0] => Failed.
Query: ALTER TABLE <code>aJG0fk_cleantalk_sfw_logs</code>
ADD COLUMN <code>id</code> VARCHAR(40) NOT NULL FIRST,
ADD COLUMN <code>status</code> ENUM('PASS_SFW','DENY_SFW','PASS_SFW_BY_WHITELIST','PASS_SFW_BY_COOKIE','DENY_ANTIBOT','DENY_ANTICRAWLER') NOT NULL AFTER <code>ip</code>,
DROP PRIMARY KEY,
ADD PRIMARY KEY (<code>id</code>);
Error: Duplicate entry '' for key 'PRIMARY'
)

            [03:21:24_ACTION__FUNCTION_] => Array
(
    [0] => Failed.
Query: ALTER TABLE <code>aJG0fk_cleantalk_sfw_logs</code>
CHANGE <code>status</code> <code>status</code> ENUM('PASS_SFW','DENY_SFW','PASS_SFW_BY_WHITELIST','PASS_SFW_BY_COOKIE','DENY_ANTICRAWLER','DENY_ANTIFLOOD') NOT NULL AFTER <code>ip</code>;
Error: Unknown column 'status' in 'aJG0fk_cleantalk_sfw_logs'
)

            [04:37:18_ACTION__FUNCTION_] => Array
(
    [0] => Failed.
Query: ALTER TABLE <code>aJG0fk_cleantalk_sfw_logs</code>
CHANGE <code>status</code> <code>status</code> ENUM('PASS_SFW','DENY_SFW','PASS_SFW__BY_WHITELIST','PASS_SFW__BY_COOKIE','DENY_ANTICRAWLER','PASS_ANTICRAWLER','DENY_ANTIFLOOD','PASS_ANTIFLOOD') NOT NULL AFTER <code>ip</code>;
Error: Unknown column 'status' in 'aJG0fk_cleantalk_sfw_logs'
)

        )

)

I just checked this morning and the error is now gone. So it looks ok again. Any idea what happened to cause it in the first place?

Thanks for your support!

I have created the task for the development team. We will look at this closer and contact you with results.

Please, wait.

Sounds good. Thanks again for your great support!

Hello @avfadagio

It looks like the debug data appeared due to the plugin update from the old version of the plugin.

If the debug data is still appearing, please reactivate the plugin with the “Complete deactivation” option enabled:
1. Enter the Antispam by Cleantalk plugin settings. (WordPress Dashboard -> Settings -> Anti-Spam by Cleantalk -> Advanced settings)
2. Check the last settings “Complete deactivation” and save changes.
3. Deactivate the plugin on the “Plugins” page in WordPress Dashboard.
4. Then activate it.
5. Enter your access key in the plugin’s settings.

Thank you.

Thanks. The debug messages are gone. Everything looks good!

Hello @avfadagio.
Thank you for letting us know.