Error in SQL syntax

  • I was just letting wp-optimize do its cleanup and got these error messages, could you please tell me what to look for exactly?
    This affects 2 different wp-installations in one host.
    One is in the root-installation and one is in a subfolder.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-blog' at line 1]
OPTIMIZE TABLE wp2_dt-blog

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-frontpages' at line 1]
OPTIMIZE TABLE wp2_dt-frontpages

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-portfolio' at line 1]
OPTIMIZE TABLE wp2_dt-portfolio

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-sidebars' at line 1]
OPTIMIZE TABLE wp2_dt-sidebars

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-slides' at line 1]
OPTIMIZE TABLE wp2_dt-slides

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-slideshows' at line 1]
OPTIMIZE TABLE wp2_dt-slideshows

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-blog' at line 1]
OPTIMIZE TABLE wp1_dt-blog

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-frontpages' at line 1]
OPTIMIZE TABLE wp1_dt-frontpages

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-portfolio' at line 1]
OPTIMIZE TABLE wp1_dt-portfolio

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-sidebars' at line 1]
OPTIMIZE TABLE wp1_dt-sidebars

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-slides' at line 1]
OPTIMIZE TABLE wp1_dt-slides

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-slideshows' at line 1]
OPTIMIZE TABLE wp1_dt-slideshows

    https://www.ads-software.com/plugins/wp-optimize/

  • The topic ‘Error in SQL syntax’ is closed to new replies.