Title: Missing Tables and Syntax Error
Last modified: August 20, 2019

---

# Missing Tables and Syntax Error

 *  Resolved [danb228](https://wordpress.org/support/users/danb228/)
 * (@danb228)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/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_USER
 * However, 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_ci
 * I 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

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [YeKen](https://wordpress.org/support/users/aliakro/)
 * (@aliakro)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/missing-tables-and-syntax-error/#post-11851867)
 * Hi,
 * Thanks for reporting this – strange!
 * I presume you have the latest version of the plugin?
 * Al
 *  Thread Starter [danb228](https://wordpress.org/support/users/danb228/)
 * (@danb228)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/missing-tables-and-syntax-error/#post-11851919)
 * The WordPress admin panel says version 7.1.12 which I assume is the latest version
   as I can’t update further.
 *  Plugin Author [YeKen](https://wordpress.org/support/users/aliakro/)
 * (@aliakro)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/missing-tables-and-syntax-error/#post-11856490)
 * Would you mind emailing me?
 * [email@yeken.uk](https://wordpress.org/support/topic/missing-tables-and-syntax-error/email@yeken.uk?output_format=md)
 * Will be easier to talk it through.
 *  Plugin Author [YeKen](https://wordpress.org/support/users/aliakro/)
 * (@aliakro)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/missing-tables-and-syntax-error/#post-11865344)
 * Dealing with via email.
 * It looks like a MySQL column called system is causing an issue.
 * 7.1.3 going out to fix this 🙂

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Missing Tables and Syntax Error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/weight-loss-tracker.svg)
 * [Weight Tracker](https://wordpress.org/plugins/weight-loss-tracker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/weight-loss-tracker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/weight-loss-tracker/)
 * [Active Topics](https://wordpress.org/support/plugin/weight-loss-tracker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/weight-loss-tracker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/weight-loss-tracker/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [YeKen](https://wordpress.org/support/users/aliakro/)
 * Last activity: [6 years, 9 months ago](https://wordpress.org/support/topic/missing-tables-and-syntax-error/#post-11865344)
 * Status: resolved