Woocommerce Version : 4.1.1 error : wp_wc_reserved_stock table creation failed

same problem on 4 different website also for me.

Same problem,
i checked the logs, i think ‘timestamp’ is not supported under mysql 5.6.

Hi there,

i checked the logs, i think ‘timestamp’ is not supported under mysql 5.6.

Your diagnosis is correct.
One solution would be to create the tables manually similar to this: https://gist.github.com/conschneider/97891d599599d1953c33cb8b68805c1a

Kind regards,

“Similar to this” -> but then we need to know which columns to create, and how to create the table. ??

Does this create a blocking issue somewhere??

• This reply was modified 4 years, 6 months ago by danielbuvens. Reason: edit

CREATE TABLEwp_wc_reserved_stock` (
order_id bigint(20) unsigned NOT NULL,
product_id bigint(20) unsigned NOT NULL,
stock_quantity double NOT NULL DEFAULT 0,
timestamp datetime NOT NULL DEFAULT ‘0000-01-01 00:00:00’,
expires datetime NOT NULL DEFAULT ‘0000-01-01 00:00:00’,
PRIMARY KEY (order_id, product_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci;`

#1115 – Unknown character set: ‘utf8mb4’

Hi again,

“Similar to this” -> but then we need to know which columns to create, and how to create the table. ??

Does this create a blocking issue somewhere??

Correct, you need a blueprint. I created a vanilla WordPress install and activated WooCommerce and then created the SQL statements manually using Navicat for each missing table.

#1115 – Unknown character set: ‘utf8mb4’

The range of available character sets is defined by your MySQL server. You need to look them up or ask your hosting provider.

Kind regards,

I notice this error too, after upgrading to WooCommerce Blocks 2.6.0. I rolled back the plugin to 2.5.15 and the error message disappeared.

i Disable WooCommerce Blocks 2.6.0. and the error message disappeared too.

But i don’t know if the wp_wc_reserved_stock table is used by WooCommerce Blocks 2.6.0. or Woocommerce Version : 4.1.1

wp_wc_reserved_stock table is for what ? is a new table ?

Bests Regards.

Hi, I’ve seen the same error. The discussion here is a bit over my head. I hope there is a way to fix this that is a little less technical.

Same problem here, need some help to solve it please.

Can someone provide more information how to solve this problem. After firing queries to mysql database with no errors it didn’t remove the error message in wp-admin screen.

Hi,
I have the same problem

this is the error message:

WooCommerce wp_wc_reserved_stock table creation failed. Does the Sql##### user have CREATE privileges on the Sql####### database?

What can I do?

thanks

Rollback to WooCommerce blocks for the Gutenberg editor Version 2.5.15 and the error is gone for the moment.

A real solution would be much better.

Hi everyone,

The table creation mostly fails due to server settings. I don’t think there is much the plugin can do to buffer this.

Here is a MySQL export file of the affected table as Gist. https://gist.github.com/c7b5ca8cf76a94b2df88f2c30756046b
You can import this into your database. This should help.

**Before you do that, please do make a full backup!**

Ask you web hosting provider for help if you need assistance managing the database.

Kind regards,

• This reply was modified 4 years, 6 months ago by con. Reason: Replaced faulty download link with Gist