Need to Drop Tables upon plugin deletion

  • Your plugin is not deleting all tables and I’m unable to pull the site.
    mysqldump: Got error: 1356: View 'wp_xxx_wsm_bounceVisits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author osama.esh

    (@osamaesh)

    please go the plugin main page > settings and un check the option “keep data after uninstalling the plugin”

    please check this link:
    https://ibb.co/chDszZP

    Thread Starter Christina

    (@carasmo)

    I did that and saved. All the tables are still there. This is confirmed by Flywheel tech support, the tables remain in spite of having that box UNchecked.

    https://ibb.co/Z6w7W0f

    • This reply was modified 2 years, 5 months ago by Christina.
    Plugin Author osama.esh

    (@osamaesh)

    backup your database and run this command:

    SELECT CONCAT( ‘DROP TABLE ‘, GROUP_CONCAT(table_name) , ‘;’ )
    AS statement FROM information_schema.tables
    WHERE table_name LIKE ‘wp_xxx_wsm%’;

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Need to Drop Tables upon plugin deletion’ is closed to new replies.