Cleantalk errors generated in nginx error log

  • Resolved samtheman

    (@freeyorker)


    4 years, 3 months ago

    Hi Folks,

    After a recent update to WordPress 5.5 we started seeing the series in Nginx error log: 

    @'			status = 'DENY_SFW',

			all_entries = 1,

			blocked_entries = 1,

			entries_timestamp = '1597238205'

		ON DUPLICATE KEY

		UPDATE

			status = 'DENY_SFW',

			all_entries = all_entries + 1,

			blocked_entries = blocked_entries + 1,

			entries_timestamp = '1597238205' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/website.com/wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cleantalk.php'), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->update_log, Cleantalk\ApbctWP\DB->execute" while reading response header from upstream, client: 178.63.87.197, server: website.com, request: "GET /creative-2/the-fishy-art-of-anne-catherine-becker-echivard HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php74-fpm-website.com.sock:", host: "website.com"
2020/08/12 13:19:18 [error] 8494#8494: *1672392 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'id' in 'field list' for query INSERT INTO nd_cleantalk_sfw_logs

		SET

			id = '7ded5431b1143b3de4b7597be322d5ba',

			ip = '46.229.168.140',

			status = 'DENY_SFW',

			all_entries = 1,

			blocked_entries = 1,

			entries_timestamp = '1597238358'

		ON DUPLICATE KEY

		UPDATE

			status = 'DENY_SFW',

			all_entries = all_entries + 1,

			blocked_entries = blocked_entries + 1,

			entries_timestamp = '1597238358' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/website.com/wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cleantalk.php'), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->update_log, Cleantalk\ApbctWP\DB->execute" while reading response header from upstream, client: 46.229.168.140, server: website.com, request: "GET /art/elegant-fish-paintings-express-artists-vision-of-the-world/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php74-fpm-website.com.sock:", host: "website.com"
2020/08/12 13:19:46 [error] 8494#8494: *1672432 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'id' in 'field list' for query INSERT INTO nd_cleantalk_sfw_logs

		SET

			id = '75892c86ec3272b7fa79e0f2c375a9f5',

			ip = '46.229.168.144',

			status = 'DENY_SFW',

			all_entries = 1,

			blocked_entries = 1,

			entries_timestamp = '1597238386'

		ON DUPLICATE KEY

		UPDATE

			status = 'DENY_SFW',

			all_entries = all_entries + 1,

			blocked_entries = blocked_entries + 1,

			entries_timestamp = '1597238386' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/website.com/wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cleantalk.php'), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->update_log, Cleantalk\ApbctWP\DB->execute" while reading response header from upstream, client: 46.229.168.144, server: website.com, request: "GET /movies/behind-scene-images-famous-movies%20target= HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php74-fpm-website.com.sock:", host: "website.com"
2020/08/12 13:19:55 [error] 8494#8494: *1672451 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'id' in 'field list' for query INSERT INTO nd_cleantalk_sfw_logs

		SET

			id = 'bd50b7b511562aaa8ef552a31e5de0d0',

			ip = '46.229.168.146',

			status = 'DENY_SFW',

			all_entries = 1,

			blocked_entries = 1,

			entries_timestamp = '1597238395'

		ON DUPLICATE KEY

		UPDATE

			status = 'DENY_SFW',

			all_entries = all_entries + 1,

			blocked_entries = blocked_entries + 1,

			entries_timestamp = '1597238395' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/website.com/wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cleantalk.php'), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->update_log, Cleantalk\ApbctWP\DB->execute" while reading response header from upstream, client: 46.229.168.146, server: website.com, request: "GET /art/grasslands-repair-installation-of-10000-plants-for-australias-venice-architecture-biennale-pavilion/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php74-fpm-website.com.sock:", host: "website.com"
2020/08/12 13:20:01 [error] 8494#8494: *1672455 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'id' in 'field list' for query INSERT INTO nd_cleantalk_sfw_logs

		SET

			id = '76a87389583a30924b4b8fb5375fc33c',

			ip = '46.229.168.162',

			status = 'DENY_SFW',

			all_entries = 1,

			blocked_entries = 1,

			entries_timestamp = '1597238401'

		ON DUPLICATE KEY

		UPDATE

			status = 'DENY_SFW',

			all_entries = all_entries + 1,

			blocked_entries = blocked_entries + 1,

			entries_timestamp = '1597238401' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/website.com/wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cleantalk.php'), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->update_log, Cleantalk\ApbctWP\DB->execute" while reading response header from upstream, client: 46.229.168.162, server: website.com, request: "GET /entity/katharina-barth/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php74-fpm-website.com.sock:", host: "website.com"
2020/08/12 13:20:17 [error] 8492#8492: *1672475 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'id' in 'field list' for query INSERT INTO nd_cleantalk_sfw_logs

		SET

			id = 'd421b8d5f9700061a955ebdfc995ea89',

			ip = '46.229.168.161',

			status = 'DENY_SFW',

			all_entries = 1,

			blocked_entries = 1,

			entries_timestamp = '1597238417'

		ON DUPLICATE KEY

		UPDATE

			status = 'DENY_SFW',

			all_entries = all_entries + 1,

			blocked_entries = blocked_entries + 1,

			entries_timestamp = '1597238417' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('/var/www/website.com/wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cl

    Could you please help me to solve this issue?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support amagsumov

    (@amagsumov)

    Hello, @freeyorker

    Thank you for your request.

    We’ve fixed the issue. Please, install the DEV version of the anti-spam plugin.

    Download link: https://github.com/CleanTalk/wordpress-antispam/releases/download/dev-version/cleantalk-spam-protect.zip

    Here is an instruction:

    1. Go to WordPress Administrator Panel —> Plugins.
    2. Find the plugin “Spam Protection by CleanTalk” —> Deactivate.
    3. After the automatic page refresh find the plugin again “Spam Protection by CleanTalk” —> Delete. Confirm “Yes, delete these files”.
    5. Go to Plugins —> Add New —> Upload Plugin.
    4. Download the plugin archive from the link above.
    6. Choose the downloaded archive and press “Install Now”.
    7. Clear web-browser’s cache.

    Did it help?

    Thread Starter samtheman

    (@freeyorker)

    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'
)

        )

)
    Plugin Support amagsumov

    (@amagsumov)

    1. Enter to the Anti-Spam by Cleantalk plugin settings: (Wordrpess Dashboard -> Settings -> Antispam 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.

    Do the errors persist?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cleantalk errors generated in nginx error log’ is closed to new replies.