Commands out of sync

Hey @keironw,

Thanks for reporting this. Can you send me a Diagnostics report so I can get a better overview of your environment? Please navigate to Wordfence > Tools > Diagnostics. Here you can select SEND REPORT BY EMAIL. Please include your www.remarpro.com username and update this thread after you’ve sent it.

Thanks,

Gerroald

• This reply was modified 5 years, 8 months ago by WFGerroald.

Thanks.
The diagnostic report has been sent.

Keiron

Did the Diagnostics report help to suggest a solution? The error is still occurring.
Keiron

Hey @keironw.

Thanks for the bump on this.

I’ve looked for the Diagnostic report, and I can’t seem to find it. Can you please try sending it again?

Thanks,

Gerroald

Hey @keironw,

My apologies, I missed your first update.

I’ve looked, and I can’t seem to find your Diagnostics report. Can you please send it one more and update this thread afterward? Please be sure to include your www.remarpro.com username. It makes it easier to search.

Thanks,

Gerroald

I’ve sent the report to wftest at wordfence dot com

I hope you can find it this time.

Thanks,
Keiron

Is there anyone who can help me here? My error log is slowly getting bigger and bigger!
Keiron

Hey @keironw,

I’m still not seeing the Diagnostics report. Are you able to send out emails through the site? You can test this by navigating to Tools > Diagnostics > Other Test, which is at the very bottom of the page. You’ll notice two options to send test emails.

Send a test email from this WordPress server to an email address

Send a test activity report email

I’d like to help. But I really need to get an overview of your environment. If I need to bump the developers they’ll need to see this too.

Also, please make sure to add your www.remarpro.com username when sending the report.

Thanks,

Gerroald

The site is sending emails successfully, and I have sent the diagnostic report to myself. Please confirm what email address I should use for you and I will forward the diagnostic report to you.

Thanks,
Keiron

Still no reply.
@wfgerald – can you help?

Keiron

Sorry for the delay @keironw

This could be caused by an issue in PHP’s MySQLi extension that’s somehow being triggered. WordPress core doesn’t use it either, so unless there is a plugin involved in the problem, it could be a PHP issue.

If you run the server yourself, or via a developer you work with, we recommend checking for pending PHP updates and/or MySQL server updates, in case it’s actually a bug in one of the two that’s triggered by a combination of plugins you currently have. Of course, all the usual precautions for server updates should be taken (backups, making sure you can roll back if the update causes other problems, etc.), since PHP updates and MySQL updates could bring their own issues.

I was able to find your diagnostics and see you are on 5.6.40, which it would be recommended to upgrade for both security and performance reasons.

Let me know if you have any success with that.

Thanks. I have upgraded PHP to 7.2, but cannot change the MySQL version. I also removed one plugin [WP Responsive Menu] which was generating errors with PHP 7.2.
The WordFence error is still occurring, but no longer references mysqli:

[18-Aug-2019 14:04:41 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 wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks

Thanks @keironw

Can you please try running a repair on that ism_wfblocks7 table? If your site is hosted on a cPanel control panel, you can use the database check and repair tools in the MySQL Databases section.

Thanks. I did the check and it said the table was OK. However I did the repair anyway. The error is still continuing.

Hi, I am getting a similar error to this, did you find a solution?

thanks.