database error..

  • Resolved franc3sc0s92

    (@franc3sc0s92)


    4 years, 8 months ago

    hi, i’ve a problem with wordfence on multisite.
    FROM wpcf_wfblocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC fatta da wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks
    [13-Mar-2020 20:16:04 UTC] WordPress errore sul database Commands out of sync; you can’t run this command now per la 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 wpcf_wfblocks7 WHERE type IN (3) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC fatta da wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::countryBlocks, wfBlock::allBlocks
    [13-Mar-2020 20:16:04 UTC] WordPress errore sul database Commands out of sync; you can’t run this command now per la 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 wpcf_wfblocks7 WHERE type IN (1, 8, 9, 2, 5, 6) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC fatta da wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::ipBlocks, wfBlock::allBlocks
    [13-Mar-2020 20:16:04 UTC] WordPress errore sul database Commands out of sync; you can’t run this command now per la 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

    cAN YOU HELP ME WITH THIS ERROR??

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

    (@wfphil)

    Hi @franc3sc0s92

    We have seen this on a few sites that are hosted on a LiteSpeed web server. If this applies to you then we are thinking the error in our query that runs in the shutdown handler is caused by another underlying problem, where the database connection is unexpectedly in a bad state, but PHP is still able to run the shutdown handlers.

    It might not be caused directly by another plugin, but we are not sure. It might not be LiteSpeed itself, but something about the configuration on servers in a certain distribution with LiteSpeed.

    We recommend asking your hosting provider to see if they can find anything in the MySQL logs, LiteSpeed’s logs, or syslog around the same time that the errors occur.

    It might be useful to have your Wordfence Diagnostics report. Please go to the top of the “Diagnostics” tab on the Wordfence “Tools” page. There will be a “SEND REPORT BY EMAIL” button to send the diagnostics report. Enter wftest [at] wordfence [dot] com as the email and @franc3sc0s92 as the forum username please.

    Once you have emailed me the diagnostics report can you reply here to let me know that it has been sent. This is important in the unlikely event that your installation of WordPress is having an issue with sending mail.

    Thread Starter franc3sc0s92

    (@franc3sc0s92)

    hi, i’ve send the diagnostic report. thanks

    Plugin Support wfphil

    (@wfphil)

    Hi @franc3sc0s92

    Thank you for sending the report.

    The MySQL documentation say that this error is caused by incorrectly using a couple of functions that Wordfence doesn’t use:

    https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html

    I see that you are using a LiteSpeed web server that I mentioned in my last reply so we recommend that your hosting provider has a look at all of the relevant log files I mentioned for clues.

    We have had one user that had a marked improvement when their hosting provider optimized the MySQL configuration.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘database error..’ is closed to new replies.