Hello,
The issue you’re experiencing is likely related to database permissions. Specifically, the database user assigned to your WordPress installation might not have the CREATE VIEW permission, which is required to properly set up certain tables or views for the plugin.
To resolve this:
- Check Database Permissions: Ensure that the database user has the necessary permissions, particularly the CREATE VIEW privilege. You can do this via your hosting provider’s control panel or by contacting their support team for assistance.
- Contact Hosting Provider: If you’re unsure how to adjust these permissions or confirm the database user’s privileges, reach out to your hosting provider. Let them know that the issue involves missing database tables and that the plugin might require the CREATE VIEW permission to function correctly.
Once the permissions are properly set, try reinstalling the plugin, and it should resolve the issue. Let me know if you need further assistance!
I have the same issue. I had an older inactive 2023 version of the plugin as I hadn’t been using it for a long time and a lot of data in wsm db tables that is no longer relevant which I wanted to remove. I re-activated, checked and saved the option to remove all data on delete and then deleted it.
running another wp-search replace <url> –dry-run identifies the tables are gone, but throws a load of errors about wsm views being referenced, so it didn’t remove the views.
So I uploaded the latest version of the plugin and activated it, hoping to have another go at clearing it, but now it says 17 tables are missing and the fix now button does nothing.
I’ve checked db user perms and the db user has all perms.
Any clues? There are now 5 wsm views and 0 wsm tables in the db.
Same issue for me and it’s very frustrating because I’m a newbie and never ran into this issue before.
