Missing Tables and Syntax Error
-
Hi,
I recently uninstalled the plugin along with removing it’s database tables and reinstalled it and have been receiving MySQL missing table errors for these tables (I initially had errors for all tables but the others were able to be rebuilt just fine):
wp_WS_LS_META_FIELDS
wp_WS_LS_GROUPS
wp_WS_LS_GROUPS_USERHowever, when I try to rebuild these tables through the settings page I get this error:
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 ‘system BIT DEFAULT 0, field_type int NOT NULL, ‘ at line 11]
CREATE TABLE wp_WS_LS_META_FIELDS ( id mediumint(9) NOT NULL AUTO_INCREMENT, field_key varchar(40) NOT NULL, field_name varchar(40) NOT NULL, abv varchar(5) NOT NULL, suffix varchar(5) NOT NULL, display_on_chart BIT DEFAULT 0, mandatory int DEFAULT 1, enabled int DEFAULT 1, hide_from_shortcodes int DEFAULT 0, system BIT DEFAULT 0, field_type int NOT NULL, sort int DEFAULT 100, UNIQUE KEY id (id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ciI also get this 4 error messages of this error on pages where I have the [wlt] shortcode in the content:
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 ‘system = 0 order by sort, field_name asc’ at line 1]
Select * from wp_WS_LS_META_FIELDS Where system = 0 order by sort, field_name asc
- The topic ‘Missing Tables and Syntax Error’ is closed to new replies.