E_ERROR Woocommerce database update

Hello,

To check better, please provide the following:

Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

Can you please check the logs, and let us know if there are any other errors that start with wc_db_updates? Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any other errors are present).

Thanks.

Hi Igor, thank you! Here is the copied report>

### WordPress Environment ###

WordPress address (URL): https://wimperu.org
Site address (URL): https://wimperu.org
WC Version: 6.4.1
REST API Version: ? 6.4.1
WC Blocks Version: ? 7.2.2
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.3.2
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.28
PHP Post Max Size: 516 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.81.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 5.6.41-84.1
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: wp_
Total Database Size: 16.07MB
Database Data Size: 14.97MB
Database Index Size: 1.10MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 3.65MB + Index: 0.07MB + Engine MyISAM
wp_postmeta: Data: 0.96MB + Index: 0.08MB + Engine MyISAM
wp_posts: Data: 9.77MB + Index: 0.10MB + Engine MyISAM
wp_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

### Post Type Counts ###

attachment: 223
custom_css: 1
customize_changeset: 2
et_body_layout: 2
et_pb_layout: 41
et_template: 8
et_theme_builder: 1
nav_menu_item: 16
page: 37
post: 4
revision: 420
wc_membership_plan: 2
wp_global_styles: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (9) ###

Akismet Anti-Spam: by Automattic – 4.2.3
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.0
Jetpack: by Automattic – 10.8
MOJO Marketplace: by Mike Hansen – 1.6.2
OptinMonster: by OptinMonster Team – 2.6.12
Divi Supreme Pro: by Divi Supreme – 4.8.50
Mercado Pago payments for WooCommerce: by Mercado Pago – 5.7.6
WooCommerce: by Automattic – 6.4.1
WPForms Lite: by WPForms – 1.7.3

### Inactive Plugins (3) ###

Divi Carousel: by DiviGear – 2.0.23
Hello Dolly: by Matt Mullenweg – 1.7.2
SSL Insecure Content Fixer: by WebAware – 2.7.2

### Must Use Plugins (1) ###

Endurance Page Cache: by Mike Hansen – 2.2

### Settings ###

API Enabled: –
Force SSL: –
Currency: PEN (S/)
Currency Position: left_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

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: ?

### WC Pages ###

Shop base: #969 - /shop/
Cart: #970 - /cart/
Checkout: #971 - /checkout/
My account: #972 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Blacktree
Version: 1.0
Author URL: https://blacktree.pe
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 4.17.3
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

### Status report information ###

Generated at: 2022-04-25 22:05:41 +00:00

>>>>>>>
As for the logs, this is the only one, that it seems to be repeated 100 times, but all are basically the same:

2022-04-11T23:56:19+00:00 CRITICAL Uncaught RuntimeException: Unable to claim actions. Database error. in /home2/wimperu1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:683
Stack trace:
#0 /home2/wimperu1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(597): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, '')
#1 /home2/wimperu1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '')
#2 /home2/wimperu1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(153): ActionScheduler_HybridStore->stake_claim(25)
#3 /home2/wimperu1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch(25, 'WP Cron')
#4 /home2/wimperu1/public_ht in /home2/wimperu1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 683

Thanks a lot.

Hi @haykap,

Thank you for the system status and error logs.

Let’s see if you’re able to update the WC database after disabling all plugins (except WooCommerce) and temporarily switching to a default theme like Storefront.

You can install 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.

Let us know how it goes.

Thank you so much…

I installed the suggested plugin, and run the troubleshooting, activated the Woocommerce to update the database, but I get the same error.

“There has been a critical error on this website. Please check your site admin email inbox for instructions.”

All other plugins were disabled.

Any other ideas that could help? Thank you :).

Hi there,

Looking a bit closer at the error logs you shared it seems that the database table wimperu1_wrdp1.wp_actionscheduler_actions was not able to be created. Most often this happens when the “database user” that WordPress is utilizing doesn’t have permission to create the table.

You can check the permissions this database user has in the web host’s control panel. Make sure this user can create tables. Then you can temporarily disable WooCommerce and activate it again. That will trigger the creation of any missing table. If you’re still in trouble however we recommend getting in contact with your host’s support and asking them to take a look.

Best.

Thanks a lot,
I will take a look into it and report back.

Best. ??

Sure thing! That’s a good idea ??.

Do let us know if we can help with anything else here.

Cheers.

Thank you so much for your help, the only thing that got rid of the error was to run the tool “Verify base database tables”. It showed that tables were complete and without error, somehow this checking fixed something because the database could finally get updated and everything works fine now.

Thank you.

Awesome! Glad to know it is resolved.

Feel free to create a new topic if you need help with anything else.

Thanks