uap action logs

Hi @atomicbong ,

Sorry about the confusion in the other thread. It’s fine to mark it as unresolved too; we’ll see any updates you send and can flag it accordingly too.

Okay, we do want to confirm again that what’s reference is not a table; it’s a database “view”, so it does work differently. It’s odd that your plugins are detecting it as a table, because it isn’t one.

If you have access to PHPMyAdmin through the hosting, it’s fine to go in, find the views, and drop them from there.

With regard to the cleanup routine, we rely on the WordPress native uninstall.php capabilities, so we could potentially see how it might not target child site views. We’ll take a look, but given the urgency, dropping views using PHPMyAdmin will be fastest, or you could potentially reactivate Automator on the child site that’s causing the error, drop the views and tables from Automator > Status > Tools, delete the plugin, then try again.

Please give me the sql query to run in phpmyadmin so as to solve this issue.

Sure. Based on what you sent us, something like the following would work (and you can adjust it based on how many sites you have using this as an example):

-- Drop views if they exist for uap_recipe_logs_view
DROP VIEW IF EXISTS wp_1_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_2_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_3_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_4_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_5_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_6_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_7_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_8_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_9_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_10_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_11_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_12_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_13_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_14_uap_recipe_logs_view;
DROP VIEW IF EXISTS wp_15_uap_recipe_logs_view;

-- Drop views if they exist for uap_trigger_logs_view
DROP VIEW IF EXISTS wp_1_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_2_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_3_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_4_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_5_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_6_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_7_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_8_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_9_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_10_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_11_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_12_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_13_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_14_uap_trigger_logs_view;
DROP VIEW IF EXISTS wp_15_uap_trigger_logs_view;

-- Drop views if they exist for uap_action_logs_view
DROP VIEW IF EXISTS wp_1_uap_action_logs_view;
DROP VIEW IF EXISTS wp_2_uap_action_logs_view;
DROP VIEW IF EXISTS wp_3_uap_action_logs_view;
DROP VIEW IF EXISTS wp_4_uap_action_logs_view;
DROP VIEW IF EXISTS wp_5_uap_action_logs_view;
DROP VIEW IF EXISTS wp_6_uap_action_logs_view;
DROP VIEW IF EXISTS wp_7_uap_action_logs_view;
DROP VIEW IF EXISTS wp_8_uap_action_logs_view;
DROP VIEW IF EXISTS wp_9_uap_action_logs_view;
DROP VIEW IF EXISTS wp_10_uap_action_logs_view;
DROP VIEW IF EXISTS wp_11_uap_action_logs_view;
DROP VIEW IF EXISTS wp_12_uap_action_logs_view;
DROP VIEW IF EXISTS wp_13_uap_action_logs_view;
DROP VIEW IF EXISTS wp_14_uap_action_logs_view;
DROP VIEW IF EXISTS wp_15_uap_action_logs_view;

-- Drop views if they exist for uap_api_logs_view
DROP VIEW IF EXISTS wp_1_uap_api_logs_view;
DROP VIEW IF EXISTS wp_2_uap_api_logs_view;
DROP VIEW IF EXISTS wp_3_uap_api_logs_view;
DROP VIEW IF EXISTS wp_4_uap_api_logs_view;
DROP VIEW IF EXISTS wp_5_uap_api_logs_view;
DROP VIEW IF EXISTS wp_6_uap_api_logs_view;
DROP VIEW IF EXISTS wp_7_uap_api_logs_view;
DROP VIEW IF EXISTS wp_8_uap_api_logs_view;
DROP VIEW IF EXISTS wp_9_uap_api_logs_view;
DROP VIEW IF EXISTS wp_10_uap_api_logs_view;
DROP VIEW IF EXISTS wp_11_uap_api_logs_view;
DROP VIEW IF EXISTS wp_12_uap_api_logs_view;
DROP VIEW IF EXISTS wp_13_uap_api_logs_view;
DROP VIEW IF EXISTS wp_14_uap_api_logs_view;
DROP VIEW IF EXISTS wp_15_uap_api_logs_view;

Hi,

I ran this query, and got the below result:
?# MySQL returned an empty result set (i.e. zero rows).

What do I need to change? Can someone help me look into this? I could provide a login, my business is halted.. Even installing Uncanny Automator and duplicating the sites is not working.

Please advise.

Hi,

Looking for some help please.

Sorry @atomicbong , did you adjust what we sent to target the specific site IDs for your network? Have you reached out to the host to have them drop the views? And sorry, did you also try installing Automator on the site with the ID that’s affecting, use our tool there to drop views and tables, and that failed as well?

And sure, if you want to reach out via our site with the additional details, our team can certainly resolve it for you.

Thanks

After selecting the delete all data in data management, and the deactivating and deleting the plugin, this still didn’t work.

Then I tried your query. It didn’t work.

Then I did this –
Instead of DROP VIEW IF EXISTS, I did DROP TABLE,
And it worked fine after that.

Please note. I had to do drop table after the plugin was deleted.

Thanks,

Interesting, so somehow something in your environment really is treating our view as a table. Thanks for the update here; I’ll pass this back to our developers for review.

It sounds like you’re okay now, but can you confirm?

Yes, confirmed. It’s working fine now. Thank you for your help.