Getting synxtax error rarely but is there

  • Resolved Akki

    (@luckyankit)


    2 years, 4 months ago

    Saw the error – you have an error in the SQL syntax, more details in the screenshot (https://ibb.co/9ws4pg1). I have no other plugin to assume for this error cause. I have also uploaded the report with ID qPuGNDgG which by chance I was monitoring at same time when this error showed up. Kindly can please check and see if this plugin is causing that.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author OllieJones

    (@olliejones)

    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)
    Thread Starter Akki

    (@luckyankit)

    Thank you for looking into it

    Plugin Author rjasdfiii

    (@rjasdfiii)

    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.

    Thread Starter Akki

    (@luckyankit)

    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.

    Plugin Author OllieJones

    (@olliejones)

    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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Getting synxtax error rarely but is there’ is closed to new replies.