Errors in the log

  • pit24

    (@pit24)


    7 years, 4 months ago

    <-Error.log->

    Tell me why these errors occur, and how can they be corrected?
    Thank you for your time.
    ===========================
    Server Environment:
    Operating System: Linux
    Software: LiteSpeed
    MySQL version: MariaDB Server v5.7.24
    PHP Version: 7.2.13
    WordPress: 5.0.3
    ==========================
    WordPress database error Commands out of sync; you can’t run this command now for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM wp_wfblocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks, QM_DB->query
    ===
    WordPress database error Commands out of sync; you can’t run this command now for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM wp_wfblocks7 WHERE type IN (3) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::countryBlocks, wfBlock::allBlocks, QM_DB->query
    ===
    WordPress database error Commands out of sync; you can’t run this command now for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM wp_wfblocks7 WHERE type IN (1, 8, 9, 2, 5, 6) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::ipBlocks, wfBlock::allBlocks, QM_DB->query
    ===
    WordPress database error Commands out of sync; you can’t run this command now for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM wp_wfblocks7 WHERE type IN (7) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksControllewpr::synchronizeConfigSettings, wfBlock::lockouts, wfBlock::allBlocks, QM_DB->query

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter pit24

    (@pit24)

    7 years, 4 months ago

    Strange that developers ignore my problems
    Is it very difficult for developers? you can not correct such errors?

    wfdave

    (@wfdave)

    7 years, 4 months ago

    Hi @pit24,

    Can you try checking the table and repairing if necessary?

    1. Run CHECK TABLE wp_wfblocks7;
    2. If the Msg_text is not OK run REPAIR TABLE wp_wfblocks7;

    If that doesn’t work, please let me know all the plugins you have installed.

    We register a shutdown function that will sometimes run in order to synchronize the block list. However, if another plugin uses that shutdown function as well, multiple queries to the database might be prepared, causing the above error.

    Dave

    Thread Starter pit24

    (@pit24)

    7 years, 4 months ago

    Hello Dave.

    Checked the table, status -ОК
    I tried to reinstall the plugin with the removal of all tables – the error has not changed

    What other tips will you have?

    wfdave

    (@wfdave)

    7 years, 4 months ago

    Hi again,

    I think another plugin is also running a query at the same time Wordfence is.

    Can you let me know of all the plugins you have installed?

    Dave

    Thread Starter pit24

    (@pit24)

    7 years, 4 months ago

    Hello,
    == Active Plugins ==
    – Advanced Database Cleaner
    – Astra Pro
    – Classic Editor
    – Cookie Notice
    – Custom Taxonomy Order
    – Elementor
    – Elementor Pro
    – Facebook for WooCommerce
    – TablePress
    – TinyMCE Advanced
    – UpdraftPlus – Backup/Restore
    – WooCommerce
    – WooCommerce Multilingual
    – Wordfence Security
    – WP All Import – WooCommerce Add-On Pro
    – WP All Import – Yoast WordPress SEO Add-On
    – WP All Import Pro
    – WPML All Import
    – WPML Multilingual CMS
    – WPML String Translation
    – WPML Translation Management
    – YITH WooCommerce Request A Quote
    – Yoast SEO Premium

    • This reply was modified 7 years, 4 months ago by pit24.
    Thread Starter pit24

    (@pit24)

    7 years, 4 months ago

    Hello Dave,
    I have a chance to get an answer from you?

    wfdave

    (@wfdave)

    7 years, 4 months ago

    Hi again,

    We are noticing reports of customers with a similar issue. Please bear with us while we investigate the issue at hand.

    I believe this is due to a plugin conflict, so I’ll be testing each and every plugin to see if I can reproduce the error you see.

    Some of these plugins however are premium, so I won’t have access to them.

    Can you try disabling some of the plugins and seeing if this causing the errors to go away?

    Dave

    Thread Starter pit24

    (@pit24)

    7 years, 4 months ago

    Hello Dave,
    The error is not permanent, and I noticed that Wardenfense error always occurs with other errors.

    ===These errors constantly arise:===

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘_wpml_transient__wpml_st_mo_scan_in_progress’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_MO_Scan_Hooks->import_mo_files, WPML_ST_MO_Queue->is_locked, WPML_Transient->get, get_option

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_wpml_transient__wpml_st_mo_scan_in_progress’, ‘a:2:{s:5:\”value\”;i:1;s:10:\”expiration\”;i:1548117300;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_MO_Scan_Hooks->import_mo_files, WPML_ST_MO_Queue->lock, WPML_Transient->set, update_option, add_option

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT autoload FROM wp_options WHERE option_name = ‘_wpml_transient__wpml_st_mo_scan_in_progress’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_MO_Scan_Hooks->import_mo_files, WPML_ST_MO_Queue->unlock, WPML_Transient->delete, delete_option

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_woocommerce_sessions (session_key, session_value, session_expiry) VALUES (‘975a4e80853759dbac3b08a7bcdd6cac’, ‘a:9:{s:15:\”client_currency\”;s:3:\”USD\”;s:24:\”client_currency_language\”;s:2:\”en\”;s:4:\”cart\”;s:6:\”a:0:{}\”;s:11:\”cart_totals\”;s:367:\”a:15:{s:8:\”subtotal\”;i:0;s:12:\”subtotal_tax\”;i:0;s:14:\”shipping_total\”;i:0;s:12:\”shipping_tax\”;i:0;s:14:\”shipping_taxes\”;a:0:{}s:14:\”discount_total\”;i:0;s:12:\”discount_tax\”;i:0;s:19:\”cart_contents_total\”;i:0;s:17:\”cart_contents_tax\”;i:0;s:19:\”cart_contents_taxes\”;a:0:{}s:9:\”fee_total\”;i:0;s:7:\”fee_tax\”;i:0;s:9:\”fee_taxes\”;a:0:{}s:5:\”total\”;i:0;s:9:\”total_tax\”;i:0;}\”;s:15:\”applied_coupons\”;s:6:\”a:0:{}\”;s:22:\”coupon_discount_totals\”;s:6:\”a:0:{}\”;s:26:\”coupon_discount_tax_totals\”;s:6:\”a:0:{}\”;s:21:\”removed_cart_contents\”;s:6:\”a:0:{}\”;s:8:\”customer\”;s:687:\”a:26:{s:2:\”id\”;s:1:\”0\”;s:13:\”date_modified\”;s:0:\”\”;s:8:\”postcode\”;s:0:\”\”;s:4:\”city\”;s:0:\”\”;s:9:\”address_1\”;s:0:\”\”;s:7:\”address\”;s:0:\”\”;s:9:\”address_2\”;s:0:\”\”;s:5:\”state\”;s:0:\”\”;s:7:\”country\”;s:2:\”GB\”;s:17:\”shipping_postcode\”;s:0:\”\”;s:13:\”shipping_city\”;s:0:\”\”;s:18:\”shipping_address_1\”;s:0:\”\”;s:16:\”shipping_address\”;s:0:\”\”;s:18:\”shipping_address_2\”;s:0:\”\”;s:14:\”shipping_state\”;s:0:\”\”;s:16:\”shipping_country\”;s:2:\”GB\”;s:13:\”is_vat_exempt\”;s:0:\”\”;s:19:\”calculated_shipping\”;s:0:\”\”;s:10:\”first_name\”;s:0:\”\”;s:9:\”last_name\”;s:0:\”\”;s:7:\”company\”;s:0:\”\”;s:5:\”phone\”;s:0:\”\”;s:5:\”email\”;s:0:\”\”;s:19:\”shipping_first_name\”;s:0:\”\”;s:18:\”shipping_last_name\”;s:0:\”\”;s:16:\”shipping_company\”;s:0:\”\”;}\”;}’, 1548289800)
    ON DUPLICATE KEY UPDATE session_value = VALUES(session_value), session_expiry = VALUES(session_expiry) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Session_Handler->save_data

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘_yith_ywraq_session_4f74cc1cb5bf684d65362c274f442975’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, YITH_YWRAQ_Session->save_data, get_option

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_yith_ywraq_session_4f74cc1cb5bf684d65362c274f442975’, ‘a:1:{s:3:\”raq\”;s:6:\”a:0:{}\”;}’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, YITH_YWRAQ_Session->save_data, add_option

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘_yith_ywraq_session_expires_4f74cc1cb5bf684d65362c274f442975’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, YITH_YWRAQ_Session->save_data, add_option, get_option

    [22-Jan-2019 00:30:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_yith_ywraq_session_expires_4f74cc1cb5bf684d65362c274f442975’, ‘1548289800’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, YITH_YWRAQ_Session->save_data, add_optionwp

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Errors in the log’ is closed to new replies.

Tags