samtheman

Stupidity at its finest. It is simple and common sense to backup before performing any modification to your website. On its plugin, there are multiple warnings that only blind person can miss those.

You are trying to blame developer for own stupidity. I’m totally on Jordy’s side. The media cleaner is genius creation that solves WordPress biggest flaw.

Hello @amagsumov,

Thanks for getting back to me.

I followed the exact steps you have written. However in the plugin page the following debug is displayed:

CLEANTALK_AJAX_USE_BUFFER NOT_DEFINED
CLEANTALK_AJAX_USE_FOOTER_HEADER NOT_DEFINED
CLEANTALK_ACCESS_KEY NOT_DEFINED
CLEANTALK_CHECK_COMMENTS_NUMBER NOT_DEFINED
CLEANTALK_CHECK_MESSAGES_NUMBER NOT_DEFINED
CLEANTALK_PLUGIN_DIR /var/www/freeyork.org/htdocs/wp-content/plugins/cleantalk-spam-protect/
WP_ALLOW_MULTISITE NOT_DEFINED
Debug log:
ArrayObject Object
(
    [storage:ArrayObject:private] => Array
        (
            [13:26:19_ACTION__FUNCTION_] => Array
(
    [0] => Failed.
Query: ALTER TABLE <code>nd_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 'nd_cleantalk_sfw_logs.PRIMARY'
)

            [20:48:06_ACTION__FUNCTION_] => Array
(
    [0] => Failed.
Query: ALTER TABLE <code>nd_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 'nd_cleantalk_sfw_logs'
)

            [09:56:56_ACTION__FUNCTION_] => Array
(
    [0] => Failed.
Query: ALTER TABLE <code>nd_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 'nd_cleantalk_sfw_logs'
)

        )

)