• Resolved phoebe46

    (@phoebe46)


    Hi,

    I have encountered several entries in my website’s error.log file that appear to be associated with the Shield Security plugin.

    Specifically, I am seeing entries similar to the following:

    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM wp3l_options made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Core\Databases\Common\TableReadyCache->save, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT ips.ip, bs.*
    						FROM wp3l_icwp_wpsf_botsignal as bs
    						INNER JOIN wp3l_icwp_wpsf_ips as ips
    							ON ips.id = bs.ip_ref 
    							AND ips.ip=INET6_ATON('46.139.124.41')
    						ORDER BY bs.updated_at DESC
    						LIMIT 1; made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-pre_plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\{closure}, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->fireEventForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->updateSignalField, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->retrieve, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\DB\BotSignal\LoadBotSignalRecords->loadRecord, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\DB\BotSignal\LoadBotSignalRecords->selectRaw, FernleafSystems\Wordpress\Services\Core\Db->selectRow
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT * FROM wp3l_icwp_wpsf_ips WHERE ip = INET6_ATON('46.139.124.41') ORDER BY created_at DESC
    LIMIT 1
    OFFSET 0 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-pre_plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\{closure}, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->fireEventForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->updateSignalField, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->retrieve, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\IPs\IPRecords->loadIP, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Select->first, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->queryWithResult, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->query, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Select->execQuerySql, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Select->querySelect, FernleafSystems\Wordpress\Services\Core\Db->selectCustom
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT IGNORE INTO wp3l_icwp_wpsf_ips (ip,created_at) VALUES (INET6_ATON('46.139.124.41'), 1687010724) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-pre_plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\{closure}, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->fireEventForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->updateSignalField, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->retrieve, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\IPs\IPRecords->loadIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\IPs\IPRecords->addIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\IPs\Ops\Insert->insert, FernleafSystems\Wordpress\Services\Core\Db->doSql
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT * FROM wp3l_icwp_wpsf_ips WHERE ip = INET6_ATON('46.139.124.41') ORDER BY created_at DESC
    LIMIT 1
    OFFSET 0 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-pre_plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\{closure}, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->fireEventForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->updateSignalField, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->retrieve, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\IPs\IPRecords->loadIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\IPs\IPRecords->loadIP, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Select->first, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->queryWithResult, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->query, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Select->execQuerySql, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Select->querySelect, FernleafSystems\Wordpress\Services\Core\Db->selectCustom
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT  INTO wp3l_icwp_wpsf_botsignal (created_at,updated_at,notbot_at,frontpage_at,loginpage_at,bt404_at,btfake_at,btcheese_at,btloginfail_at,btua_at,btxml_at,btlogininvalid_at,btinvalidscript_at,btauthorfishing_at,cooldown_at,humanspam_at,markspam_at,unmarkspam_at,captchapass_at,captchafail_at,auth_at,firewall_at,ratelimit_at,offense_at,blocked_at,unblocked_at,bypass_at,snsent_at) VALUES ('1687010724','1687010724','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-pre_plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\{closure}, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->fireEventForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->updateSignalField, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->retrieve, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->store, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Insert->insert, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->query, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Insert->execQuerySql, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->execQuerySql, FernleafSystems\Wordpress\Services\Core\Db->doSql
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT  INTO wp3l_icwp_wpsf_botsignal (created_at,updated_at,notbot_at,frontpage_at,loginpage_at,bt404_at,btfake_at,btcheese_at,btloginfail_at,btua_at,btxml_at,btlogininvalid_at,btinvalidscript_at,btauthorfishing_at,cooldown_at,humanspam_at,markspam_at,unmarkspam_at,captchapass_at,captchafail_at,auth_at,firewall_at,ratelimit_at,offense_at,blocked_at,unblocked_at,bypass_at,snsent_at) VALUES ('1687010724','1687010724','0','1687010724','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-pre_plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsController->FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\{closure}, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotEventListener->fireEventForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->updateSignalField, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\Bots\BotSignalsRecord->store, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Insert->insert, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->query, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\Insert->execQuerySql, FernleafSystems\Wordpress\Plugin\Core\Databases\Base\BaseQuery->execQuerySql, FernleafSystems\Wordpress\Services\Core\Db->doSql
    [17-Jun-2023 14:05:24 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM wp3l_options made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->onWpShutdown, do_action('icwp-wpsf-plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\ModCon->onPluginShutdown, FernleafSystems\Wordpress\Plugin\Shield\Modules\Base\ModCon->saveModOptions, FernleafSystems\Wordpress\Plugin\Shield\Modules\Plugin\ModCon->doPrePluginOptionsSave, FernleafSystems\Wordpress\Plugin\Shield\Modules\Plugin\ModCon->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option

    I am reaching out with two main questions:

    How can I resolve this issue?
    Is the IP blocking function operating properly?

    I appreciate your time and look forward to your assistance in this matter.

    Best regards,
    Timi

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Paul

    (@paultgoodchild)

    This iis actually a common problem and is caused believe it or not, by another plugin in your site. Whatever is happening, the other plugin is leaving your mysql db connection in an invalid state. Then, when Shield comes along and tries to use the default WordPress database connection it discovers and error and so the logs say that Shield has a problem.

    Caching plugins are a usual culprit, so first try disabling it if you’re using it. If that doesn’t fix the errors please try disabling another plugin for a day or so, and see if you get the error. If you do, try another plugin. You’ll need to keep testing until you find the other plugin that’s breaking your WordPress db connection.

    Thread Starter phoebe46

    (@phoebe46)

    Ok, thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Shield plugin related entries in error.log’ is closed to new replies.