@rollemamedia – this error is related to the recent migration to custom tables in WooCommerce. You can see an answer to this issue on GitHub: https://github.com/woocommerce/action-scheduler/issues/504#issuecomment-606575698
It was suggested that you temporarily disable the migration to custom tables using:
add_filter( 'action_scheduler_migration_dependencies_met', '__return_false' );
Once the fix for #437 if released, you can then remove that code to continue the migration process.
– Joey
Hi Joey,
Thanks for the quick reply!
I add the code to the functions.php and forced Woocommerce to run the database update. The shop has 2500 products. So i think this will take a while…
Keep you updated in this post 🙂
Kind regards,
Redmer
@jricketts4 – Now i get this in my log file:
2020-04-16T07:18:46+00:00 CRITICAL Uncaught RuntimeException: Claiming actions failed. Database error. in /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:675
Stack trace:
#0 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions(1392803, 25, NULL, Array, '')
#1 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(206): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '')
#2 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_HybridStore->stake_claim(25)
#3 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch( in /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 675
2020-04-16T13:52:47+00:00 CRITICAL Uncaught InvalidArgumentException: Unidentified action 49 in /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php:495
Stack trace:
#0 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php(482): ActionScheduler_wpPostStore->get_date_gmt('49')
#1 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(274): ActionScheduler_wpPostStore->get_date('49')
#2 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(78): ActionScheduler_HybridStore->get_date('49')
#3 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(52): ActionScheduler_wcSystemStatus->get_action_status_date('pending', 'o in /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php on line 495
2020-04-16T16:19:40+00:00 CRITICAL Uncaught RuntimeException: Claiming actions failed. Database error. in /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:675
Stack trace:
#0 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions(2446368, 25, NULL, Array, '')
#1 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(206): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '')
#2 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_HybridStore->stake_claim(25)
#3 /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch( in /var/www/vhosts/domainname.nl/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 675
Hope you can help me out.
