WSM Tables Still Referenced After Plugin Removal

  • Hello,

    I have a paid license. But, I needed to remove VSP from one of my sites. I made sure to deselect “Check to keep data and uncheck to remove data.” prior to removing the VSP plugins. Looking at myPHPAdmin I see no “wsm” tables.

    However, when doing a database backup with UPdraftPlus I get the following errors:

    * Failed to backup database table: (View ‘bdkiron2_trybdk.wp_wsm_dateHourWiseBounce’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (table_details_error)

    * Failed to backup database table: (View ‘bdkiron2_trybdk.wp_wsm_dateHourWiseBounceRate’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (table_details_error)

    * Failed to backup database table: (View ‘bdkiron2_trybdk.wp_wsm_dateHourWiseFirstVisitors’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (table_details_error)

    * Failed to backup database table: (View ‘bdkiron2_trybdk.wp_wsm_dateHourWisePageViews’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (table_details_error)

    * Failed to backup database table: (View ‘bdkiron2_trybdk.wp_wsm_dateHourWiseVisitors’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (table_details_error)

    Why are wsm tables still being referenced? Is there a file that I need to edit to prevent this?

    Thanks so much.

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

    (@osamaesh)

    Hello,
    Thank you for reporting this issue,
    we will take care of this in the next update,

    now, you can go to the PHPMyAdmin and then select the site database and remove the views (view prefix is wsm_)

    thank you

    Hi @osamaesh ,

    We just experienced the same issue in our customer’s website who uses our hosting. For the past 3 nights, server backups were partial failing because of this. We strongly suggest fixing that issue in your plugin.

    To be clear, our customer had the “keep data” setting as checked. We installed and verified that.

    Even so, it should never cause that. It gave a database error when trying to access those tables. We did not take note of that error.

    These are the ones that caused issues:
    wsm_dateHourWiseBounce
    wsm_dateHourWiseBounceRate
    wsm_dateHourWiseFirstVisitors
    wsm_dateHourWisePageViews
    wsm_dateHourWiseVisitors

    Example error during backup: “mysqldump: Couldn’t execute ‘show fields from x_wsm_dateHourWiseBounce‘: View ‘database-name-here.x_wsm_dateHourWiseBounce’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)”

    We then unchecked that setting to “keep data”, saved, and deactivated and removed the plugin. Upon checking the database, all your plugin’s tables are still there.

    We hope that you can revise the data removal setting.

    Plugin Author osama.esh

    (@osamaesh)

    Thank you for letting us know,
    We will fix the issue in the next release (within one/two weeks).

    You can go to the PHPMyAdmin and then select the site database and remove the views (view prefix is wsm_)

    The next update date will be 10 Aug 2021

    Sorry for being late dears

    Plugin Author osama.esh

    (@osamaesh)

    Hello @contrid & @gulkana

    Please try the new version, problem solved

    Thank you!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WSM Tables Still Referenced After Plugin Removal’ is closed to new replies.