Support » Plugin: Weight Tracker » Missing Tables and Syntax Error

  • Resolved danb228

    (@danb228)


    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

    (@aliakro)

    Hi,

    Thanks for reporting this – strange!

    I presume you have the latest version of the plugin?

    Al

    danb228

    (@danb228)

    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

    (@aliakro)

    Would you mind emailing me?

    email@yeken.uk

    Will be easier to talk it through.

    Plugin Author YeKen

    (@aliakro)

    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)
  • You must be logged in to reply to this topic.