Fatal error ActionScheduler_DBStore.php

Hello,

Error saving action: Database error.

Kindly go to WooCommerce > status > tools. You’ll see a button Verify base database tables, please click it. Let us know if this action is completed, or does it return an error?

Link to image: https://snipboard.io/JK1obc.jpg

If that does not work, you can try this work-around that is explained on GitHub.

I hope this helps, if not, please share a copy of your site’s System Status? So that we can check better, it is under WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

• This reply was modified 2 years ago by Igor H.

Hello.

Thank you for your replay

I clicked on:

Verify base database tables
Verify if all base database tables are present.

The page was re-loaded and I can see the message:
Database verified successfully.

However the error still here.
As soon I clicked on
WooCommerce database update required
I still getting the same error

### WordPress Environment ###

WordPress address (URL): https://sportsales.ca
Site address (URL): https://sportsales.ca
WC Version: 7.0.1
REST API Version: ? 7.0.1
WC Blocks Version: ? 8.8.2
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.1
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 10000
cURL Version: 7.66.0
OpenSSL/1.1.1q-fips

SUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.8.2
WC Database Prefix: nuc_
Total Database Size: 18.08MB
Database Data Size: 17.15MB
Database Index Size: 0.93MB
nuc_woocommerce_sessions: Data: 0.16MB + Index: 0.02MB + Engine InnoDB
nuc_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
nuc_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
nuc_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
nuc_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_actionscheduler_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_actionscheduler_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_actionscheduler_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_cartbounty: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_cartflows_ca_email_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_commentmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_comments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_duplicator_pro_packages: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
nuc_e_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_grp_google_place: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_grp_google_review: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_grp_google_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_options: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
nuc_postmeta: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
nuc_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
nuc_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_termmeta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
nuc_terms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_term_relationships: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
nuc_term_taxonomy: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
nuc_usermeta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
nuc_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wc_admin_notes: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
nuc_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
nuc_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
nuc_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
nuc_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
nuc_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
nuc_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
nuc_wpforms_tasks_meta: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
nuc_wpie_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wsm_browsers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wsm_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wsm_dailyHourlyReport: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
nuc_wsm_dateHourWiseBounceRate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wsm_dateHourWiseFirstVisitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wsm_dateHourWisePageViews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
nuc_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acoplw_badges: 2
acoplw_prod_list: 2
attachment: 1164
awl-labels: 1
custom_css: 1
elementor_library: 3
grw_feed: 1
mc4wp-form: 1
ml-slide: 4
ml-slider: 1
nav_menu_item: 52
oembed_cache: 1
page: 15
pins: 16
portfolio: 15
post: 23
product: 77
product_variation: 35
shop_order: 14
spucpt: 1
wc_afrsm: 2
woo_product_tab: 1
wp_global_styles: 1
wpcf7_contact_form: 2
wpforms: 1
wr_mapper: 2
xlwcty_thankyou: 1
yith_popup: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?Error messages should not be shown to visitors.

### Active Plugins (23) ###

Acowebs Product Labels For Woocommerce: by Acowebs – 1.4.0
Claue Addons: by JanStudio – 1.2.5
Duplicator Pro (Gold): by Snap Creek – 4.5.6
GTM4WP: by Thomas Geiger – 1.16.1
Elementor: by Elementor.com – 3.8.0
Fluid Checkout for WooCommerce - Lite: by Fluid Checkout – 2.0.8
Site Kit by Google: by Google – 1.86.0
Google XML Sitemaps: by Auctollo – 4.1.5
Import and export users and customers: by codection – 1.21.1
MyWaze: by Savvy WordPress Development – 1.6
SiteGround Optimizer: by SiteGround – 7.2.5
SiteGround Migrator: by SiteGround – 2.0.3
Advanced Flat Rate Shipping For WooCommerce: by theDotstore – 4.1.1
WooCommerce Blocks: by Automattic – 8.8.2
Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.3
CartBounty - Save and recover abandoned carts for WooCommerce: by Streamline.lv – 7.1.3
Woocommerce Single Product Page Customizer: by Geek Code Lab – 2.3
NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.15.1
WooCommerce Stripe Gateway: by WooCommerce – 6.9.0
WooCommerce: by Automattic – 7.0.1
WordPress Importer: by wordpressdotorg – 0.8
WPForms Lite: by WPForms – 1.7.7.2
Custom Product Tabs for WooCommerce: by YIKES
Inc. – 1.8.1

### Inactive Plugins (0) ###

### Settings ###

API Enabled: ?
Force SSL: –
Currency: CAD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #4 - /shop/
Cart: #5 - /cart/
Checkout: #6 - /checkout/
My account: #7 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Claue
Version: 1.5.8
Author URL: https://www.janstudio.net
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ? Next scheduled: 2022-11-09 13:25:26 +00:00
Options: ?
Notes: 267
Onboarding: completed

### Action Scheduler ###

Complete: 2
Oldest: 2022-11-06 11:03:50 +0000
Newest: 2022-11-06 11:03:50 +0000

Pending: 4
Oldest: 2022-11-06 11:03:50 +0000
Newest: 2022-11-06 11:03:50 +0000

### Status report information ###

Generated at: 2022-11-08 14:13:35 +00:00

Hello,

Thanks for sending the report.

May I ask if you disable all plugins except WooCommerce, and then try again to update the database and verify it, does it work?

Or is the issue still present? Let us know how that goes.

I deactivated all plugins

Each deactivation was coming with error so needed to refresh the page every time

Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/customer/www/sportsales.ca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/customer/www/sportsales.ca/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/customer/www/sportsales.ca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/customer/www/sportsales.ca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(105): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/customer/www/sportsales.ca/public_html/wp-content/plugins/woo in /home/customer/www/sportsales.ca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

Please take a look a screenshot. Only the woocomerce plugin is now active.
https://ibb.co/Bt5Qb89

I also flushed a dynamic cache in the hosting

The error is still here

I also paid attention that my site health have an message alert

Debug mode is often enabled to gather more details about an error or site failure, but may contain sensitive information which should not be available on a publicly available website.

The value, WP_DEBUG_DISPLAY, has either been enabled by WP_DEBUG or added to your configuration file. This will make errors display on the front end of your site.

I never see it before on my other webs…

Just a short follow up

define(‘WP_DEBUG’, true);

to

define(‘WP_DEBUG’, false);

so

Debug mode is often enabled to gather more details about an error or site failure, but may contain sensitive information which should not be available on a publicly available website.

The value, WP_DEBUG_DISPLAY, has either been enabled by WP_DEBUG or added to your configuration file. This will make errors display on the front end of your site.

was disabled.

But the main issue is still here.

short follow up..

Changed a theme to one that is coming with wordpress
Twenty Twenty-Three

Did not help ??

Hi,

Sorry to hear that the issue persists.

I’d recommend to backup your site and database. More info at Backing up WordPress content. Then temporarily deactivate all plugins including WooCommerce and download the Action Scheduler plugin, Install the Action Scheduler plugin – finally, activate all other plugins and check if the issue is resolved.

You can make this test using a staging environment (This is in case you would not like to touch the live site), you can use the plugin WP Staging for quickly spinning up a new test site.

Let us know if this make a difference.

I fixed the issue.
Randomly.. could say.
Please close the topic.