Support » Plugin: Shield Security: Protection with Smarter Automation » WordPress database error Commands out of sync

  • hello
    This error has come error_log file

    [17-Jul-2019 08:25:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROMwp_optionsmade by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action('icwp-wpsf-plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_FeatureHandler_Base->action_doFeatureShutdown, ICWP_WPSF_FeatureHandler_Base->savePluginOptions, ICWP_WPSF_FeatureHandler_Plugin->doPrePluginOptionsSave, ICWP_WPSF_FeatureHandler_Plugin->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option

    Please how it will be resolved
    Thank you

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author One Dollar Plugin

    (@onedollarplugin)

    Could you provide a list of all other plugins running on your site, please?

    From our researching into this, it seems that this error occurs when mysql query data is left in an inconsistent state – this is likely due to another plugin running a query and not “finishing” it off, or clearing it correctly. This isn’t necessarily the fault of the Shield plugin, but our plugin is facing the error because another plugin hasn’t done the necessary work to let our plugin do what it needs to do. If we can get a list of your plugins, we can try replicating it.

    Alternatively, you can try disabling any other security plugins on your site and see if that clears it up.

    Thank you for reply
    Yes, List all my plugins
    http://txt.do/1108e
    I just use shield security plugin

    Other error

    [17-Jul-2019 06:36:14 UTC] PHP Fatal error:  Class 'FernleafSystems\Wordpress\Services\Core\Rest' not found in /home/***/public_html/wp-content/plugins/wp-rocket/inc/functions/admin.php on line 2
    [17-Jul-2019 07:31:45 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM <code>wp_options</code> made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action('icwp-wpsf-plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_FeatureHandler_Base->action_doFeatureShutdown, ICWP_WPSF_FeatureHandler_Base->savePluginOptions, ICWP_WPSF_FeatureHandler_Plugin->doPrePluginOptionsSave, ICWP_WPSF_FeatureHandler_Plugin->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option
    [17-Jul-2019 07:37:46 UTC] PHP Fatal error:  Class 'FernleafSystems\Wordpress\Services\Core\Rest' not found in /home/***/public_html/wp-content/plugins/yith-woocommerce-recover-abandoned-cart-premium/includes/class-yith-wc-abandoned-cart-email.php on line 77
    [17-Jul-2019 08:25:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM <code>wp_options</code> made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action('icwp-wpsf-plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_FeatureHandler_Base->action_doFeatureShutdown, ICWP_WPSF_FeatureHandler_Base->savePluginOptions, ICWP_WPSF_FeatureHandler_Plugin->doPrePluginOptionsSave, ICWP_WPSF_FeatureHandler_Plugin->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option
    [17-Jul-2019 08:36:51 UTC] PHP Fatal error:  Class 'FernleafSystems\Wordpress\Services\Core\Rest' not found in /home/***/public_html/wp-content/plugins/wp-simple-firewall/src/processors/loginprotect_base.php on line 402
    [17-Jul-2019 10:14:30 UTC] PHP Fatal error:  Class 'ICWP_WPSF_DataProcessor' not found in /home/***/public_html/wp-content/plugins/wp-simple-firewall/src/features/traffic.php on line 12
    [17-Jul-2019 10:32:22 UTC] PHP Fatal error:  Class 'FernleafSystems\Wordpress\Services\Core\Rest' not found in /home/***/public_html/wp-content/plugins/woocommerce-memberships/vendor/skyverge/wc-plugin-framework/woocommerce/api/abstract-sv-wc-api-json-request.php on line 40
    [17-Jul-2019 10:39:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM <code>wp_options</code> made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action('icwp-wpsf-plugin_shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_FeatureHandler_Base->action_doFeatureShutdown, ICWP_WPSF_FeatureHandler_Base->savePluginOptions, ICWP_WPSF_FeatureHandler_Plugin->doPrePluginOptionsSave, ICWP_WPSF_FeatureHandler_Plugin->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option
    • This reply was modified 3 months, 4 weeks ago by  moein.
    Plugin Author One Dollar Plugin

    (@onedollarplugin)

    Are you using the latest version of Shield? You may want to reinstall – you have errors occurring that just shouldn’t be happening if the plugin is installed correctly.

    Also, can you find the earliest date the DB SQL error started? If so, can you find out which plugin you either updated or installed on that day?

    Yes, I’ll reinstall
    There was a strange problem now, My themes file was deleted

    I deleted the text of the error_log file by mistake
    How to find the earliest date the DB SQL error started?

    Hello
    After reinstalling, my problem is still there

    [17-Jul-2019 19:44:42 UTC] PHP Fatal error: Class 'FernleafSystems\Wordpress\Services\Core\Rest' not found in /home/***/public_html/wp-content/plugins/wp-simple-firewall/src/processors/hackprotect_scan_apc.php on line 129
    [18-Jul-2019 03:21:48 UTC] PHP Fatal error: Class ‘FernleafSystems\Wordpress\Services\Core\Rest’ not found in /home/***/public_html/wp-content/plugins/Ultimate_VC_Addons/modules/ultimate_icon_timeline.php on line 939
    [18-Jul-2019 03:22:05 UTC] PHP Fatal error: Class ‘FernleafSystems\Wordpress\Services\Core\Rest’ not found in /home/***/public_html/wp-content/plugins/Ultimate_VC_Addons/params/Ultimate_BoxShadow.php on line 158
    [18-Jul-2019 04:06:46 UTC] PHP Fatal error: Class ‘FernleafSystems\Wordpress\Services\Core\Rest’ not found in /home/***/public_html/wp-content/themes/***/framework/main.php on line 514
    [18-Jul-2019 04:10:20 UTC] PHP Fatal error: Class ‘FernleafSystems\Wordpress\Services\Core\Rest’ not found in /home/***/public_html/wp-content/plugins/wp-rocket/inc/functions/posts.php on line 103
    [18-Jul-2019 07:01:50 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action(‘icwp-wpsf-plugin_shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_FeatureHandler_Base->action_doFeatureShutdown, ICWP_WPSF_FeatureHandler_Base->savePluginOptions, ICWP_WPSF_FeatureHandler_Plugin->doPrePluginOptionsSave, ICWP_WPSF_FeatureHandler_Plugin->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option
    [18-Jul-2019 07:17:29 UTC] PHP Fatal error: Class ‘FernleafSystems\Wordpress\Services\Core\Rest’ not found in /home/***/public_html/wp-content/themes/***/framework/widgets/video-widget.php on line 3
    [18-Jul-2019 08:49:31 UTC] خطای Commands out of sync; you can’t run this command now در پایگاه‌داده وردپرس برای دستور UPDATE wp_options SET option_value = ‘1505213140’ WHERE option_name = ‘icwp_wpsf_install_date’ ساخته شده توسط shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action(‘icwp-wpsf-plugin_shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_FeatureHandler_Base->action_doFeatureShutdown, ICWP_WPSF_FeatureHandler_Base->savePluginOptions, ICWP_WPSF_FeatureHandler_Plugin->doPrePluginOptionsSave, ICWP_WPSF_FeatureHandler_Plugin->storeRealInstallDate, FernleafSystems\Wordpress\Services\Core\General->updateOption, update_option
    [18-Jul-2019 08:49:31 UTC] خطای Commands out of sync; you can’t run this command now در پایگاه‌داده وردپرس برای دستور SELECT * FROM wp_icwp_wpsf_sessions WHERE session_id = ‘532f76ffa0119023aad750bc165ce311’ AND deleted_at=0 ORDER BY last_activity_at DESC ساخته شده توسط shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action(‘icwp-wpsf-plugin_shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Processor_Sessions->onModuleShutdown, ICWP_WPSF_FeatureHandler_BaseWpsf->hasSession, ICWP_WPSF_FeatureHandler_BaseWpsf->getSession, ICWP_WPSF_Processor_Sessions->getCurrentSession, ICWP_WPSF_Processor_Sessions->loadCurrentSession, ICWP_WPSF_Processor_Sessions->queryGetSession, FernleafSystems\Wordpress\Plugin\Shield\Databases\Session\Select->retrieveUserSession, FernleafSystems\Wordpress\Plugin\Shield\Databases\Session\Select->selectForUserSession, FernleafSystems\Wordpress\Plugin\Shield\Databases\Base\Select->query, FernleafSystems\Wordpress\Plugin\Shield\Databases\Base\Select->querySelect, FernleafSystems\Wordpress\Services\Core\Db->selectCustom
    [18-Jul-2019 08:49:31 UTC] خطای Commands out of sync; you can’t run this command now در پایگاه‌داده وردپرس برای دستور SELECT * FROM wp_icwp_wpsf_statistics WHERE deleted_at=0 ORDER BY created_at DESC ساخته شده توسط shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Plugin_Controller->onWpShutdown, do_action(‘icwp-wpsf-plugin_shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ICWP_WPSF_Processor_Statistics_Tally->onModuleShutdown, ICWP_WPSF_BaseDbProcessor->onModuleShutdown, ICWP_WPSF_Processor_Statistics_Tally->cleanupDatabase, ICWP_WPSF_Processor_Statistics_Tally->consolidateDuplicateKeys, FernleafSystems\Wordpress\Plugin\Shield\Databases\Base\Select->all, FernleafSystems\Wordpress\Plugin\Shield\Databases\Base\Select->query, FernleafSystems\Wordpress\Plugin\Shield\Databases\Base\Select->querySelect, FernleafSystems\Wordpress\Services\Core\Db->selectCustom
    [18-Jul-2019 10:29:26 UTC] PHP Fatal error: Class ‘FernleafSystems\Wordpress\Services\Core\Rest’ not found in /home/***/public_html/wp-content/plugins/wordpress-seo-premium/inc/options/class-wpseo-options.php on line 380`

    I checked out the plugins and disabled one by one
    This problem occurs after activating shield plugin
    There was no problem two days ago
    I installed the wp rocket plugin two days ago

    Please guide me
    Thank you

    • This reply was modified 3 months, 3 weeks ago by  moein.
    • This reply was modified 3 months, 3 weeks ago by  moein.

    Hello
    I think Shield plugin is incompatible with the wp rocket plugin
    Because after deactiving the wp rocket, another error was not displayed

    I hadn’t looked in an error log in a while, but I’m getting this intermittently on some of my sites too. The only commonality is that the ones I’ve found exist on the same server.

    I deleted the plugin and all settings, re-installed, and the errors have continued.

    Plugin Author One Dollar Plugin

    (@onedollarplugin)

    We were never able to narrow down the culprit of this – we believe a plugin was leaving WordPress database object in an inconsistent state as it wasn’t clearing out the previous result.

    What you’ll need to try is:

    • identify common plugins on your sites that experience this error
    • test a site by disabling 1 of these plugins and see if the error persists
    • repeat this on each suspect plugin until you can find a plugin that stops the error happening..
    • if you can (1) disable a plugin and the error disappears, and then (2) reenable the plugin and the error returns, you’ve found the problem plugin.

    We’ve made a change to our plugin for the next release such that it’ll attempt its own database queries before other plugins so that another plugin can’t leave it in an inconsistent state. The problem stems from the fact that a plugin leaves a mess, then we try to use the WP DB object and it throws up this warning.

    Hopefully you can find the problem plugin (and if it’s started recently, it’s probably a recently updated plugin). Let us know when you find a potential candidate.

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.