Getting synxtax error rarely but is there

A bug indeed! I’m grateful for the report. It looks like things go wrong when a monitor runs at the same time as something on your system drops or creates a table in the database.

https://github.com/OllieJones/index-wp-mysql-for-speed/issues/51

Here’s the text from the image in your report.

WordPress database error: [You have an error in your SQL syntax,' check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DROP TABLE IF EXISTS pwbe_variations/**imfs-
at line 1]
EXPLAIN DROP TABLE IF EXISTS
WordPress database error: [You have an error in your SQL syntax,' check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TEMPORARY TABLE pwbe_variations
(post_id BIGINT(20) UNSIGNED, parent_p...' at line 1]
EXPLAIN CREATE TEMPORARY TABLE pwbe_variations (post_id BIGIUT(2?) UNSIGNED, BIGINT(2?) UNSIGNED, PRIMARY KEY (post_id)
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DROP TABLE IF EXISTS pwbe_products/**imfs-
at line 1]
EXPLAIN DROP TABLE IF EXISTS
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TEMPORARY TABLE pwbe_products
(post_id BIGINT(20) UNSIGNED, PRIMARY KE...' at line 1]
EXPLAIN CREATE TEMPORARY TABLE pwbe_products (post_id BIGIUT(2?) UNSIGNED, PRIMARY KEY (post_id)

Thank you for looking into it

Sounds like missing semicolons between SQL statements. If the SQL that led to these errors is available, please provide it. It will probably confirm that “;” is missing in several places. Or it may show something else that went wrong.

I uploaded the report, that doesn’t have that info you’re asking for? Other than that, its the plugin queries which faced issue, I am not much aware of where to find SQL for that.

This is a bug in the query monitor-gathering code. It tries to EXPLAIN DDL statements which fails.

The fix is here, and will be available in the next release of the plugin.

https://github.com/OllieJones/index-wp-mysql-for-speed/commit/adc332b9c8ade38f1a006ce5baa2ba14b83ce6bf

Thanks again.