WooCommerce 1Qg_wc_reserved_stock table creation failed.

Hello there,

Did you try creating the database completely?

If that does not work, 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”.?

Let us know.

Hi,
thank you for the reply.
No, I did not. Do you mean, the entire database or only woocommerce tables? How can I do it?

Even though, here is the status report:

### WordPress Environment ###

WordPress address (URL): https://r3dcomponentes.com
Site address (URL): https://r3dcomponentes.com
WC Version: 6.2.0
REST API Version: ? 6.2.0
WC Blocks Version: ? 6.7.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.1.0
Log Directory Writable: ?
WP Version: 5.9
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: pt_PT
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.26
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.7.36-cll-lve
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.2.0
WC Database Prefix: 1Qg_
Total Database Size: 9.12MB
Database Data Size: 6.77MB
Database Index Size: 2.35MB
1Qg_woocommerce_sessions: ? Table does not exist
1Qg_woocommerce_api_keys: ? Table does not exist
1Qg_woocommerce_attribute_taxonomies: ? Table does not exist
1Qg_woocommerce_downloadable_product_permissions: ? Table does not exist
1Qg_woocommerce_order_items: ? Table does not exist
1Qg_woocommerce_order_itemmeta: ? Table does not exist
1Qg_woocommerce_tax_rates: ? Table does not exist
1Qg_woocommerce_tax_rate_locations: ? Table does not exist
1Qg_woocommerce_shipping_zones: ? Table does not exist
1Qg_woocommerce_shipping_zone_locations: ? Table does not exist
1Qg_woocommerce_shipping_zone_methods: ? Table does not exist
1Qg_woocommerce_payment_tokens: ? Table does not exist
1Qg_woocommerce_payment_tokenmeta: ? Table does not exist
1Qg_woocommerce_log: ? Table does not exist
1qg_actionscheduler_actions: Data: 0.05MB + Index: 0.13MB + Engine InnoDB
1qg_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
1qg_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
1qg_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
1qg_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
1qg_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
1qg_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
1qg_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
1qg_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
1qg_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
1qg_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_options: Data: 2.36MB + Index: 0.06MB + Engine InnoDB
1qg_postmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
1qg_posts: Data: 0.20MB + Index: 0.06MB + Engine InnoDB
1qg_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
1qg_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
1qg_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
1qg_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
1qg_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
1qg_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
1qg_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
1qg_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 15
customize_changeset: 23
feedback: 3
mailpoet_page: 1
nav_menu_item: 7
page: 19
post: 2
revision: 27
seedprod: 1
wpforms: 2
wp_global_styles: 2

### Security ###

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

### Active Plugins (8) ###

Site Kit by Google: by Google – 1.50.0
Jetpack: by Automattic – 10.6
MailPoet 3 (New): by MailPoet – 3.79.0
Max upload filesize: by Yinlong – 1.1.0
SpiceBox: by Spicethemes – 1.9
WooCommerce: by Automattic – 6.2.0
WPForms Lite: by WPForms – 1.7.2.1
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.3

### Inactive Plugins (2) ###

Akismet Anti-Spam: by Automattic – 4.2.2
Hello Dolly: by Matt Mullenweg – 1.7.2

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
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: –

### WC Pages ###

Shop base: #108 - /loja/
Cart: #109 - /carrinho/
Checkout: #110 - /finalizar-compra/
My account: #111 - /minha-conta/
Terms and conditions: ? Page not set

### Theme ###

Name: HoneyPress
Version: 2.3.3
Author URL: https://spicethemes.com
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: –

### Action Scheduler ###

Complete: 38
Oldest: 2022-01-27 21:43:52 +0000
Newest: 2022-02-12 09:44:10 +0000

Pending: 5
Oldest: 2022-02-12 12:26:34 +0000
Newest: 2022-02-19 09:45:08 +0000

### Status report information ###

Generated at: 2022-02-12 12:00:17 +00:00

Hi @rmrodrigues17

Thanks for sharing the System Status Report.

As you may have noticed it is showing a whole lot of problems about the tables.

As a first step, disable all plugins except for WooCommerce (there are 7 others active at the moment).

Once done, please go to WooCommerce > Status > Tools and then click on “Verify base database tables”. Once you’ve done that, let us know the results and if you’re still seeing the same database error messages.

Hi Margaret,
3 messages were shown.
Here is the result:
– WooCommerce 1Qg_wc_reserved_stock table creation failed. Does the ty4qc7ei_8epdb user have CREATE privileges on the ty4qc7ei_8epdb database?
– Action Scheduler migration in progress. The list of scheduled actions may be incomplete.
– Database verified successfully.

Do you need more info from my side?

Thank you for the help.

Hi @rmrodrigues17

Have you tried disabling all plugins except for WooCommerce and switching to the Storefront theme to rule out theme/plugin conflicts?
https://docs.woocommerce.com/document/how-to-test-for-conflicts/

You can also disable WooCommerce temporarily and enable it again to see if that helps.

We haven’t heard back from you in a while, so I’m going to mark this thread as resolved – we’ll be here if and/or when you are ready to continue.