Initial install of Woo plugin locks admin access

Hi @stuartpearson,

Thanks for reaching out!

I understand that you are unable to install and activate the WooCommerce plugin on your site.

This kind of problem is usually caused by a conflict with your theme or with another plugin:

• Temporarily switch your theme to Storefront
• Disable all plugins except for WooCommerce
• Repeat the action that is causing the problem

If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

Before you start

• First, please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site.
• Second, I would suggest installing a plugin called Health Check & Troubleshooting. This is a plugin developed by the WordPress community and it allows you to disable plugins without affecting your current site visitors.

You can make use of a staging/test site to proceed with the conflict test recommended above.

If your host doesn’t offer that option, we recommend WP Staging for quickly spinning up a new test site.

Let us know the result of the test.

I carried out a fresh install on a staging site hosted at a subdomain. I was able to install the WooCommerce plugin successfully with exactly the same other plugins. The theme I am using has updated today so not sure if that has applied a fix. However if I install the plugin on the original site it still fails with the same blank screen.
I’m using a different solution now, it’s just a hobby site so it’s not critical to find a solution but can test further if needed.

Stuart

Howdy,

However if I install the plugin on the original site it still fails with the same blank screen.

Let’s check if you have any error log entries on your original site.
WooCommerce attempts to log any fatal errors. You can find these under WooCommerce > Status >> Logs (click on the tab). After clicking on the logs tab examine the dropdown on the right for any “fatal-errors” entry.

Got any recent logs there?

Kind regards,

There is an issue with what you are asking, the plugin never gets fully installed on the original site. This means it doesn’t exist in the WordPress admin panel to check any logs. I have direct access to the file directory so if there is anything there I can retrieve it.

Stuart

Hi @stuartpearson

Could you enable WordPress debug logging on your site? This article can guide you through how to enable it.

Once enabled, please try reactivating WooCommerce, and then check the wp-content/debug.log file. If you find any errors in that file, please share that here in your reply.

Debug.log contents from attempting to activate the plugin, same blank screen again when ran.

`[27-Aug-2022 09:39:20 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( ‘pending’, ‘in-progress’) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_HybridStore->get_claim_count, ActionScheduler_DBStore->get_claim_count
[27-Aug-2022 09:39:20 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN (‘pending’) AND a.scheduled_date_gmt <= ‘2022-08-27 09:39:20’ LIMIT 0, 5 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:22 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:22 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN (‘complete’) AND a.last_attempt_gmt <= ‘2022-07-27 09:39:23’ LIMIT 0, 20 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN (‘canceled’) AND a.last_attempt_gmt <= ‘2022-07-27 09:39:23’ LIMIT 0, 20 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN (‘pending’) AND a.last_attempt_gmt <= ‘2022-08-27 09:34:23’ AND a.claim_id != 0 LIMIT 0, 20 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->reset_timeouts, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN (‘in-progress’) AND a.last_attempt_gmt <= ‘2022-08-27 09:34:23’ LIMIT 0, 20 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->mark_failures, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( ‘pending’, ‘in-progress’) made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_HybridStore->get_claim_count, ActionScheduler_DBStore->get_claim_count
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_claims’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_actionscheduler_claims made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_HybridStore->stake_claim, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->generate_claim_id
[27-Aug-2022 09:39:23 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query UPDATE wp_actionscheduler_actions SET claim_id=0, last_attempt_gmt=’2022-08-27 09:39:23′, last_attempt_local=’2022-08-27 10:39:23′ WHERE claim_id = 0 AND scheduled_date_gmt <= ‘2022-08-27 09:39:23′ AND status=’pending’ ORDER BY attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 25 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_HybridStore->stake_claim, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->claim_actions
[27-Aug-2022 09:39:24 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’woocommerce_cleanup_draft_orders’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->install, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->maybe_create_cronjobs, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:24 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’woocommerce_cleanup_draft_orders’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->install, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->maybe_create_cronjobs, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:24 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_actionscheduler_actions made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->install, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->maybe_create_cronjobs, as_schedule_recurring_action, ActionScheduler_ActionFactory->recurring, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action
[27-Aug-2022 09:39:27 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:27 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:28 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:28 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:33 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:33 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:34 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:34 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:34 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:34 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:35 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:35 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:36 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:36 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:36 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions
[27-Aug-2022 09:39:36 UTC] WordPress database error Table ‘dbs4652849.wp_actionscheduler_actions’ doesn’t exist for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->is_migration_scheduled, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_HybridStore->query_actions, ActionScheduler_DBStore->query_actions

Hi Stuart!

Thank you for sending the logs; it seems like the issue could be related to your database and action scheduler.

As a next step, to further check into this, kindly provide us your System Status; you can find it via WooCommerce > Status. Select ‘Get system report’ and then ‘Copy for support’. Once you do this, you can paste your response here.

Thanks!

I’m unable to provide the WooCommerce status as it never fully activates. Once I get the blank page after attempting to activate it I can no longer access the WordPress admin panel. To recover admin access I need to manually rename the WooCommerce folder which the WordPress instance detects and it deactivates the plugin.

Hi there @stuartpearson

It appears that one of the tables needed for WooCommerce is missing.

wp_actionscheduler_actions

You can temporarily remove code line 44 in plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php

Once done, go to WooCommerce > Status > Scheduled Actions to regenerate the tables.

You can put back the code line when tables are regenerated.

I hope this helps! ??

Following the instructions given to remove line 44 from the respective file I was able to successfully activate the plugin. Thanks for resolving the issue.

Hi @stuartpearson,

I’m happy to hear that you were able to sort this out by following @kaushiksomaiya’s instructions.

I’ll go ahead and mark this as resolved.

Have a fab one.