Error when activating WooCommerce on installation

Hi there,

Thank you for reaching out.

It sounds like wpjs_actionscheduler_actions and wpjs_actionscheduler_groups database tables do not exist and installing WooCommerce does not re-create them for some reason, causing your site to crash upon activating WooCommerce.

In WooCommerce 4.0, two standalone plugins (WooCommerce Admin and Action Scheduler) were merged into WooCommerce and some of the data was migrated to new Action Scheduler database tables.

There’s a chance that a conflict with one of your plugins is causing this, e.g. we’ve seen cases where the tables couldn’t be created due to a conflict with an old WooCommerce Memberships version.

I’d suggest attempting to install WooCommerce when all other plugins are disabled. Please also make sure your other plugins are up to date.

Installing version 3.x of WooCommerce and updating to 4.x with all other plugins disabled is an option, too. A plugin like WP Rollback could be used or you could download version 3.9.3 from GitHub directly:

https://github.com/woocommerce/woocommerce/releases?after=4.1.0

You’ll have to un-zip, remove the version from the folder name and re-zip before installing.

If these database tables are still not created after these actions – with WooCommerce plugin activated, please install the latest version of Action Scheduler:

https://github.com/woocommerce/action-scheduler/releases

The version number will also have to be removed from the folder and zip file names before installing.

In the long run, we advise against having a standalone version of WooCommerce Admin enabled but let us know if that helps.

If that fails as well – the database tables will have to be created manually or the data migration to these tables has to be restarted, although there’s a chance something else is failing, for example, the update and data migration to action scheduler database tables was completed on your old site but these tables were not migrated.

In that case, please copy your System Status Report from WooCommerce >> Status and paste it in your reply.

Please also check for any failed scheduled actions or pending ones with the run date/time in the past in Tools >> Scheduled actions and let us know.

Thank you!

Thank you @grigaswp for your comment!

I was successfully able to get through the setup using Woo version 3.9.3 from Github. However upon updating the plugin in the WP updates section I now get this error:

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
There has been a critical error on your website. Please check your site admin email inbox for instructions.

@grigaswp I also tried deactivating old plugins which are no longer supported in 4.2 and got this error:

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
There has been a critical error on your website. Please check your site admin email inbox for instructions.

Learn more about debugging in WordPress.

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT COUNT(DISTINCT claim_id) FROM wpjs_actionscheduler_actions WHERE claim_id != 0 AND status IN ( ‘pending’, ‘in-progress’)

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE 1=1 AND a.status=’pending’ AND a.scheduled_date_gmt <= ‘2020-06-17 14:24:44’ ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 5

@grigaswp Another update for you.

When installing version 4.0 I get the following:

Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

When clicking on the “update database” option, it returns the following:

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’woocommerce-db-updates’

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
There has been a critical error on your website. Please check your site admin email inbox for instructions.

Learn more about debugging in WordPress.

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

Another update. Just for fun (I have a backup of the site and a server snapshot so I really don’t care at this point) I deleted the database tables with the plugin active and got the following message:

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-subscription’ ORDER BY note_id ASC

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_notes

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
DELETE FROM wpjs_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SELECT action_id, name, label, query, status, is_primary FROM wpjs_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-update-db-reminder’ ORDER BY note_id ASC

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_notes

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
DELETE FROM wpjs_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SELECT action_id, name, label, query, status, is_primary FROM wpjs_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_notes

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
DELETE FROM wpjs_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
SELECT action_id, name, label, query, status, is_primary FROM wpjs_wc_admin_note_actions WHERE note_id = 0

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

Seems to be that Line 44 of Action Scheduler is always causing the issue on anything higher than Version 3.9.3 for me.

Hi there,

Thank you for the updates.

All errors point towards missing database tables and it looks like updating WooCommerce from 3.x to 4.x did not re-create those.

Have you tried installing standalone Action Scheduler plugin with WooCommerce 4.x active?

If that doesn’t help or that is not possible – the database tables might have to be re-created manually.

A copy of your System Status Report and information about scheduled actions could be helpful, too.

New Update!

When trying to activate the Action Scheduler as a plugin, I get the following (which looks very similar to that of what I showed earlier):

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/admin/web/jtns.stacklinservices.net/pu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
There has been a critical error on your website. Please check your site admin email inbox for instructions.

Learn more about debugging in WordPress.

Also, in addition I think I miscommunicated earlier. This is the first time that Woo has been installed on this setup. Prior setups didn’t use Woo on this site template.

I am willing to try building the tables manually. Can you advise of all table names needed for the process? Thank you again for your help @grigaswp

Hi there,

Indeed, the errors still seems to be very similar.

It’s hard to say why exactly these tables were not created just from the log though.

These are the tables you’ll need:

wpjs_actionscheduler_logs
wpjs_actionscheduler_action
wpjs_actionscheduler_claims
wpjs_actionscheduler_groups

Something like this should do the trick:

CREATE TABLE wpjs_actionscheduler_logs (
log_id bigint(20) unsigned NOT NULL auto_increment,
action_id bigint(20) unsigned NOT NULL,
message text NOT NULL,
log_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
log_date_local datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY (log_id),
KEY action_id (action_id),
KEY log_date_gmt (log_date_gmt)
) charset utf8;

CREATE TABLE wpjs_actionscheduler_actions (
action_id bigint(20) unsigned NOT NULL auto_increment,
hook varchar(191) NOT NULL,
status varchar(20) NOT NULL,
scheduled_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
scheduled_date_local datetime NOT NULL default ‘0000-00-00 00:00:00’,
args varchar(191),
schedule longtext,
group_id bigint(20) unsigned NOT NULL default ‘0’,
attempts int(11) NOT NULL default ‘0’,
last_attempt_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
last_attempt_local datetime NOT NULL default ‘0000-00-00 00:00:00’,
claim_id bigint(20) unsigned NOT NULL default ‘0’,
extended_args varchar(8000) DEFAULT NULL,
PRIMARY KEY (action_id),
KEY hook (hook(191)),
KEY status (status),
KEY scheduled_date_gmt (scheduled_date_gmt),
KEY args (args(191)),
KEY group_id (group_id),
KEY last_attempt_gmt (last_attempt_gmt),
KEY claim_id (claim_id)
) charset utf8;

CREATE TABLE wpjs_actionscheduler_claims (
claim_id bigint(20) unsigned NOT NULL auto_increment,
date_created_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY (claim_id),
KEY date_created_gmt (date_created_gmt)
) charset utf8;

CREATE TABLE wpjs_actionscheduler_groups (
group_id bigint(20) unsigned NOT NULL auto_increment,
slug varchar(255) NOT NULL,
PRIMARY KEY (group_id),
KEY slug (slug(191))
) charset utf8;

I hope this helps!

Hey, @grigaswp I’m sorry for not having much experience within SQL. I ran the first command and got this as a return:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘0000-00-00 00:00:00’,
log_date_local datetime NOT NULL default ‘0000-00-0’ at line 5

I’m SSH’ed into my server and have the DB selected and am logged in as the user, however it happens if logged in as root as well.

Again I am sorry for my incompetency. I have never had these issues before.

More information about the server. I am running MySQL version:

mysqld Ver 5.7.30-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

Just as an update to you guys. It seems to be something with that backup in particular as sites from scratch have no issues even with all the same plugins. Thank you very much for your assistance