Trying to remove plugin – db errors – SHOW FULL COLUMNS FROM

  • Resolved measureddesigns

    (@andtay2001)


    2 years ago

    Hi,

    I experienced the missing ciient_id column errors in this thread, so removed both wsal tables.

    I tried reinstalling the plugin but always get errors even with the remove settings option enabled before uninstall.

    I now just want to get rid of the plugin, as it’s giving me json errors that prevent other actions on the site working correctly.

    I’m now seeing errors similar to this thread;
    https://www.ads-software.com/support/topic/table-wp_wsal_options-doesnt-exist-errors/

    SHOW FULL COLUMNS FROM wpyi_wsal_metadata

    WordPress database error: [Table ‘MY_DB_NAME.wpyi_wsal_metadata’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpyi_wsal_metadata

    WordPress database error: [Table ‘MY_DB_NAME.wpyi_wsal_metadata’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpyi_wsal_metadata

    WordPress database error: [Table ‘MY_DB_NAME.wpyi_wsal_metadata’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpyi_wsal_metadata

    WordPress database error: [Table ‘MY_DB_NAME.wpyi_wsal_occurrences’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpyi_wsal_occurrences

    These appear on product pages. How to remove them and the plugin fully?

    Thanks

    Andrew

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support robertabela

    (@robert681)

    Hello @andtay2001

    I am sorry to read about your issues.

    However, I am not understanding what issues originally started all this. From the errors you’ve pasted in this ticket it seems that the database tables the plugin uses do not exist. You can easily solve this by deactivating the plugin and reactivating it, and the plugin will create the tables (considering the database user has the privileges to do so).

    If you still would like to remove the plugin, all you need to do is deactivate it and uninstall it from the plugins page in the WordPress dashboard.

    I hope the above helps. Please let me know if you need any further information and asssitance.

    Have a great day.

    Thread Starter measureddesigns

    (@andtay2001)

    Hi,

    The plugin was no longer listed within admin > plugins, but there was still a physical folder on the server.

    I deleted this but still had the issue.

    Removing the plugin folder ‘wp-security-audit-log’ seems to have fixed it. I’m not sure if that’s part of the same plugin but the error has now gone.

    Thanks

    Andrew

    Plugin Support robertabela

    (@robert681)

    I am glad to read that you solved the issue Andrew.

    This might explain what happened; the plugin has a setting so it does not show up in the plugin settings. It could be that you or someone from your team enabled it, hence why it was not listed there.

    But indeed, deleting the plugin folder “uninstalls” the plugin.

    I am sorry that you had such an experience with our plugin. If you ever try it again, please drop us a note should you need any assistance.

    Have a great day.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Trying to remove plugin – db errors – SHOW FULL COLUMNS FROM’ is closed to new replies.