WooCommerce OM1iPZ_wc_reserved_stock table creation failed. Does the wp_3nabr us

Hi there,

The error is asking if the database user had the correct permission for your database. However, did the other WooCommerce tables create correctly, and was this the only one that had an error?

You could try to uninstall and reinstall the WooCommerce plugin, which should recreate the table.

Otherwise, please share a copy of your site’s System Status Report with us so that we can get more insight. To find it, go to WooCommerce ? Status, select “Get system report” and then “Copy for support”.? Then paste it here in your response.

### WordPress Environment ###

WordPress address (URL): https://lavishbeds.co.uk
Site address (URL): https://lavishbeds.co.uk
WC Version: 5.0.0
REST API Version: ? 5.0.0
WC Blocks Version: ? 4.0.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.9.0
Log Directory Writable: ?
WP Version: 5.6.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Microsoft-IIS/10.0
PHP Version: 7.4.15
PHP Post Max Size: 16 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.70.0
OpenSSL/1.1.1i

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.8-MariaDB
Max Upload Size: 16 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.0.0
WC Database Prefix: OM1iPZ_
Total Database Size: 13.27MB
Database Data Size: 7.97MB
Database Index Size: 5.30MB
OM1iPZ_woocommerce_sessions: ? Table does not exist
OM1iPZ_woocommerce_api_keys: ? Table does not exist
OM1iPZ_woocommerce_attribute_taxonomies: ? Table does not exist
OM1iPZ_woocommerce_downloadable_product_permissions: ? Table does not exist
OM1iPZ_woocommerce_order_items: ? Table does not exist
OM1iPZ_woocommerce_order_itemmeta: ? Table does not exist
OM1iPZ_woocommerce_tax_rates: ? Table does not exist
OM1iPZ_woocommerce_tax_rate_locations: ? Table does not exist
OM1iPZ_woocommerce_shipping_zones: ? Table does not exist
OM1iPZ_woocommerce_shipping_zone_locations: ? Table does not exist
OM1iPZ_woocommerce_shipping_zone_methods: ? Table does not exist
OM1iPZ_woocommerce_payment_tokens: ? Table does not exist
OM1iPZ_woocommerce_payment_tokenmeta: ? Table does not exist
OM1iPZ_woocommerce_log: ? Table does not exist
om1ipz_actionscheduler_actions: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
om1ipz_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
om1ipz_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_options: Data: 2.13MB + Index: 0.08MB + Engine InnoDB
om1ipz_postmeta: Data: 1.47MB + Index: 1.94MB + Engine InnoDB
om1ipz_posts: Data: 1.52MB + Index: 0.27MB + Engine InnoDB
om1ipz_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
om1ipz_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_usermeta: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
om1ipz_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
om1ipz_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
om1ipz_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
om1ipz_wc_customer_lookup: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
om1ipz_wc_download_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
om1ipz_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_wc_order_product_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
om1ipz_wc_order_stats: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
om1ipz_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_wc_product_meta_lookup: Data: 0.27MB + Index: 0.56MB + Engine InnoDB
om1ipz_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
om1ipz_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_wc_webhooks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
om1ipz_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_woocommerce_order_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
om1ipz_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
om1ipz_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
om1ipz_woocommerce_tax_rates: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
om1ipz_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
om1ipz_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_yoast_indexable: Data: 1.50MB + Index: 0.77MB + Engine InnoDB
om1ipz_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
om1ipz_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
om1ipz_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
om1ipz_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 160
customize_changeset: 20
global_product_addon: 1
nav_menu_item: 7
page: 13
post: 2
product: 15
product_variation: 682
revision: 22
shop_order: 1
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (10) ###

Contact Form 7: by Takayuki Miyoshi – 5.3.2
Jetpack by WordPress.com: by Automattic – 9.4
Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.19.2
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.1
WooCommerce Menu Cart: by Jeremiah Prummer
Ewout Fernhout – 2.9.6

WooCommerce Product Add-ons: by WooCommerce – 3.3.1
WooCommerce: by Automattic – 5.0.0
Yoast SEO: by Team Yoast – 15.8
WP Super Cache: by Automattic – 1.7.1
YITH WooCommerce Wishlist: by YITH – 3.0.20

### Inactive Plugins (1) ###

WooCommerce Stripe Gateway: by WooCommerce – 4.8.0

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
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: –

### WC Pages ###

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

### Theme ###

Name: Flatsome
Version: 3.12.3
Author URL: https://www.uxthemes.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 ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart\cart-empty.php
flatsome/woocommerce/cart\cart-shipping.php
flatsome/woocommerce/cart\cart.php
flatsome/woocommerce/checkout\form-checkout.php
flatsome/woocommerce/checkout\form-coupon.php
flatsome/woocommerce/checkout\terms.php
flatsome/woocommerce/checkout\thankyou.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global\breadcrumb.php
flatsome/woocommerce/global\quantity-input.php
flatsome/woocommerce/global\wrapper-end.php
flatsome/woocommerce/global\wrapper-start.php
flatsome/woocommerce/loop\loop-end.php
flatsome/woocommerce/loop\loop-start.php
flatsome/woocommerce/loop\pagination.php
flatsome/woocommerce/loop\result-count.php
flatsome/woocommerce/loop\sale-flash.php
flatsome/woocommerce/myaccount\form-login.php
flatsome/woocommerce/myaccount\navigation.php
flatsome/woocommerce/notices\error.php
flatsome/woocommerce/notices\notice.php
flatsome/woocommerce/notices\success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product\photoswipe.php
flatsome/woocommerce/single-product\price.php
flatsome/woocommerce/single-product\product-image.php
flatsome/woocommerce/single-product\product-thumbnails.php
flatsome/woocommerce/single-product\rating.php
flatsome/woocommerce/single-product\related.php
flatsome/woocommerce/single-product\review.php
flatsome/woocommerce/single-product\sale-flash.php
flatsome/woocommerce/single-product\share.php
flatsome/woocommerce/single-product\short-description.php
flatsome/woocommerce/single-product\tabs\tabs.php
flatsome/woocommerce/single-product\title.php
flatsome/woocommerce/single-product\up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php version 2.6.1 is out of date. The core version is 4.7.0

Outdated Templates: ?
					
					
						Learn how to update

### Action Scheduler ###

Canceled: 6
Oldest: -0001-11-30 00:00:00 +0000
Newest: -0001-11-30 00:00:00 +0000

Complete: 60
Oldest: 2021-02-22 14:50:07 +0000
Newest: 2021-02-23 22:51:43 +0000

Thanks for the System Status Report – at first glance, it seems like you have a whole bunch of tables missing, the ones starting with the capitalized string OM1iPZ_.

However, below that seems like what are all the required tables, except they start with the lowercase om1ipz_.

You can try the following: in your site’s config.php file, which you should find in the root of your WordPress installation, the variable $table_prefix = should be lowercase om1ipz_ – it seems like currently it’s set to the uppercase version. I’m not familiar with the temperament of your Microsoft-IIS/10.0 server, but if it’s case-sensitive, then this discrepancy might be part of the issue.

Let us know if that works!

It’s been a while since the last reply to this thread, so I’m going to go ahead and close it. If you require help with anything else, please feel free to start a new one.