Commands out of sync

  • Resolved Oded Talmon

    (@odedta)


    3 years, 8 months ago

    Hello,
    error logs are being inflated with this sort of warnings/errors. Could you help me understand what it means and how to solve it please?

    Thanks

    [11-Aug-2020 08:34:54 UTC] שגיאת מסד נתונים Commands out of sync; you can't run this command now לשאילתה SELECT *, CASE 
WHEN <code>type</code> = 3 THEN 0
WHEN <code>type</code> = 4 THEN 1
WHEN <code>type</code> = 7 THEN 2
WHEN <code>type</code> = 6 THEN 3
WHEN <code>type</code> = 5 THEN 4
WHEN <code>type</code> = 9 THEN 5
WHEN <code>type</code> = 8 THEN 6
WHEN <code>type</code> = 2 THEN 7
WHEN <code>type</code> = 1 THEN 8
ELSE 9999
END AS <code>typeSort</code>, CASE 
WHEN <code>type</code> = 3 THEN <code>parameters</code>
WHEN <code>type</code> = 4 THEN <code>parameters</code>
WHEN <code>type</code> = 1 THEN <code>IP</code>
WHEN <code>type</code> = 9 THEN <code>IP</code>
WHEN <code>type</code> = 5 THEN <code>IP</code>
WHEN <code>type</code> = 6 THEN <code>IP</code>
WHEN <code>type</code> = 7 THEN <code>IP</code>
WHEN <code>type</code> = 2 THEN <code>IP</code>
WHEN <code>type</code> = 8 THEN <code>IP</code>
ELSE 9999
END AS <code>detailSort</code>
 FROM <code>ftnhla_wfblocks7</code> WHERE <code>type</code> IN (7) AND (<code>expiration</code> = 0 OR <code>expiration</code> > UNIX_TIMESTAMP()) ORDER BY <code>typeSort</code> ASC, <code>id</code> DESC נוצרה על ידי wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::lockouts, 
wfBlock::allBlocks
Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support WFAdam

    (@wfadam)

    3 years, 8 months ago

    Hello @odedta and thanks for reaching out to us!

    There could be a few causes for this issue, but before I speculate, 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.

    Most of the time I see this when a caching plugin is running on the site or an older version of PHP is running. If you do use a caching plugin, try disabling it and see if you get the error anymore.

    Let me know if this helps or when you send the diagnostic report!

    Thanks in advance!

    Thread Starter Oded Talmon

    (@odedta)

    3 years, 8 months ago

    Hello Adam,
    Thanks for your quick response.
    I don’t have a caching plugin running, though I do see a warning in the Site Health screen about the PHP version which is weird because I am running PHP 7.3.2 which is not old at all.
    Should I expect these type of errors on every site that is not running the latest version of PHP?
    I’ve sent the report, in the username fields I inserted “odedta”.

    Thanks!

    Plugin Support WFAdam

    (@wfadam)

    3 years, 8 months ago

    Hello again @odedta

    I was not able to find your diagnostic. If you could try to resend it, I can then take a look at it.

    I reviewed this issue with some of our team and it seems this issue has come up before. If you could help us out a little and find some information. See if you can find anything in the MySQL logs, Litespeed’s logs(if you use it), or Syslog around the same time that the errors occur.

    Thanks for your help!

    Thread Starter Oded Talmon

    (@odedta)

    3 years, 8 months ago

    Hey,
    I’ve sent another one: https://ibb.co/TY6fR1z
    As for the logs, i’m on a shared hosting with cPanel. The server is Litespeed but i’ve never seen the logs you mentioned, I assumed they show up only on VPS.
    I do have access to the RAW access log if you need.

    Thanks!

    Plugin Support WFAdam

    (@wfadam)

    3 years, 8 months ago

    Hello @odedta

    If you could, send the access logs from the time you are getting the error to wftest @ wordfence . com. Just put your username on the forum as the subject. Just would like to take a look to see if we can see anything out of the ordinary.

    I have heard of this happening once before but if I remember correctly, it was a plugin conflict and the issue went away.

    Let me know what you find and if you send the logs!

    Thanks!

    Thread Starter Oded Talmon

    (@odedta)

    3 years, 8 months ago

    Hello,
    This is happening in pretty much all of the websites I manage that use Wordfence.
    Anyway, i’ve send that email.
    Thanks

    Plugin Support WFAdam

    (@wfadam)

    3 years, 8 months ago

    Hello @odedta and sorry for the delay.

    I checked with our team on this issue. They recommended asking your host about it. You can mention that we have seen this issue on only a few servers in the past couple of years, and its always-on LiteSpeed, even though plenty of servers running LiteSpeed do not see this issue. I also recommend sending them the logs you had sent me with a few timestamps of when you are seeing the “Commands out of Sync” errors.

    Let us know what you find and thanks for your assistance!

    Thread Starter Oded Talmon

    (@odedta)

    3 years, 8 months ago

    Hello,
    I’ll definitely check with the hosting provider and let you know of their answer. In addition, I ran a google search on “Commands out of sync” and I saw a few answers in stackoverflow saying this is related to a correct use of functions, here is the link to the post: https://stackoverflow.com/a/3632320/4711865

    Please look into this on your end, perhaps you could use that post to make an improvement to the plugin and solve this.

    Thank you!

    Plugin Support WFAdam

    (@wfadam)

    3 years, 8 months ago

    Thanks again @odedta

    I have passed this along to our QA team.

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