Commands out of sync

  • My error_log file in the public_html folder is rapidly growing with the same repeated Wordfence error:
    [22-Jul-2019 10:52:58 UTC] 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 ism_wfblocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/uwc-east-africa/404.php’), get_header, locate_template, load_template, require_once(‘/themes/uwc-east-africa/header.php’), wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_postmeta_cache, update_meta_cache, mysqli_query, wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks

    I have tried deleting and then re-installing the Wordfence plugin to no avail.
    What can I do to correct this error?

Viewing 4 replies - 16 through 19 (of 19 total)
  • Thread Starter keironw

    (@keironw)

    No – Sadly I did not get any further responses from the Wordfence team and the error is still continuing. If you make any progress, please do let me know.

    Thanks

    Plugin Support wfscott

    (@wfscott)

    @keironw

    I took another quick look at your diagnostics and one thing that stands out is the advanced-cache.php drop-in plugin being used. I have one other customer I’m working on this issue with and the two of you have that in common. Maybe @xumbrella can confirm if he has the same on his site (Wordfence > Tools > Diagnostics > Drop-In WordPress Plugins)

    If a plugin created the file, it might be able to remove it by changing the plugin’s settings or disabling the plugin, if the plugin author wrote it that way — but otherwise, it can only be disabled by renaming or removing the file (these would be directly in wp-content/). I recommend just renaming the file for now until you see if the error comes back. If you are planning on removing it, please make a backup.

    Let me know if that helps the issue or if you’re still having trouble.

    Thread Starter keironw

    (@keironw)

    I deleted the advanced-cache.php file, but the error is still continuing!

    I have too problem “WordPress database error Commands out of sync;”.

    Any solution ?

    advanced-cache.php – LiteSpeed Cache’s file. Delete no effect.

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Commands out of sync’ is closed to new replies.