Something is causing errors

  • Resolved tnc05

    (@tnc05)


    5 years, 5 months ago

    Hello! I’ve installed Wordfence some days ago and something is causing a lot of lines on my error.log

    Any idea? Thanks!!

    FROMwppw_wfblocks7WHEREtypeIN (7) AND (expiration= 0 ORexpiration> UNIX_TIMESTAMP()) ORDER BYtypeSortASC,id` DESC realizada por wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::lockouts, wfBlock::allBlocks
    [29-Dec-2020 15:11:42 UTC] Error Commands out of sync; you can’t run this command now de la base de datos de WordPress para la consulta 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`

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfpeter

    (@wfpeter)

    5 years, 4 months ago

    Hi @tnc05, thanks for the message about this issue.

    The MySQL documentation says that this error is caused by incorrectly using two functions that Wordfence doesn’t use.

    We are only seeing this on sites that are on a LiteSpeed web server. It might not be LiteSpeed itself, but something about the configuration on servers in a certain distribution with LiteSpeed.

    We recommend that you ask 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.

    We did see one user who saw an improvement when their hosting provider applied some MySQL tuning but I have also seen cases of this that took some additional work.

    If you could, can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    Let us know how you get on!

    Peter.

    Plugin Support wfpeter

    (@wfpeter)

    5 years, 4 months ago

    Hi @tnc05, as we haven’t received a diagnostic report in the time since you created this topic, perhaps referring to your hosting provider or logs resulted in finding the solution here.

    If you have any Wordfence questions in future, don’t hesitate to start another topic and we’ll always be glad to help out.

    Thanks,

    Peter.

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

The topic ‘Something is causing errors’ is closed to new replies.