Woocommerce Version : 4.1.1 error : wp_wc_reserved_stock table creation failed

  • Resolved caalo2000

    (@caalo2000)


    3 years, 11 months ago

    Hi,

    The last version: 4.1.1 give this error in admin page :

    WooCommerce wp_wc_reserved_stock table creation failed. Does the my-database-user user have CREATE privileges on the my-database_woocommerce database?

    do you have an idea about this ?

    Thank you for your support.

Viewing 13 replies - 16 through 28 (of 28 total)
1 2
  • etlund

    (@etlund)

    3 years, 11 months ago

    @conschneider FYI, I tried the link you provided and got an error from Chrome: “wp_wc_reserved_stock.sql.zip” is dangerous so Chrome has blocked it.”

    • This reply was modified 3 years, 11 months ago by etlund.
    edwynn

    (@edwynn)

    3 years, 11 months ago

    @conschneider I have tried to download the file but it is empty. You can upload it again.

    Thank you

    • This reply was modified 3 years, 11 months ago by edwynn.
    Plugin Support con

    (@conschneider)

    Engineer

    3 years, 11 months ago

    Hey,

    That download totally did not work. I have created a gist: https://gist.github.com/c7b5ca8cf76a94b2df88f2c30756046b

    Either run this as a SQL command or save the content as wp_wc_reserved_stock.sql and import.

    Kind regards,

    edwynn

    (@edwynn)

    3 years, 11 months ago

    @conschneider I see this error when i try your sql code in mysql.

    # 1067 – Invalid default value for ‘timestamp’

    Plugin Support con

    (@conschneider)

    Engineer

    3 years, 11 months ago

    Hi @edwynn

    I updated the Gist. Can you try again?

    Kind regards,

    edwynn

    (@edwynn)

    3 years, 11 months ago

    Hi @conschneider

    I just change this line and it work.

    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

    Thank you for the support!!

    • This reply was modified 3 years, 11 months ago by edwynn.
    Plugin Support con

    (@conschneider)

    Engineer

    3 years, 11 months ago

    Hi @edwynn

    You are very welcome. Thank you for adding your input.
    Glad it worked for you in the end 👍.

    Kind regards,

    craigrogersuk

    (@craigrogersuk)

    3 years, 10 months ago

    Just to confirm, I don’t use Gutenberg, I still use a classic editor. So I disabled the WooCommerce Blocks plugin and of course, the error has gone.

    As I don’t use Gutenberg is it ok to leave this disabled?

    Thanks

    Plugin Support con

    (@conschneider)

    Engineer

    3 years, 10 months ago

    Hi there,

    As I don’t use Gutenberg is it ok to leave this disabled?

    Yes it is. The WooCommerce Blocks plugin adds Gutenberg blocks, nothing else.

    Kind regards,

    tigercjn

    (@tigercjn)

    3 years, 8 months ago

    The table was there in my installation, I renamed it to _old and the deactivated and reactivated the plugin and it created a new table. The error message is still there.

    tonip0ika

    (@tonip0ika)

    3 years, 8 months ago

    I Cant know what to do with this?

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

    Im not expert, so can someone help?

    kaleba

    (@kaleba)

    3 years, 5 months ago

    mine gives the same error message but when i searched for the table in the data base it was there, i found it but the error message still appears, any ideas?

    dzhuninski

    (@dzhuninski)

    3 years, 3 months ago

    We fix the problem, in our case problem was because we use capitalize charters in mysql db name and mysql db user. We create mysql db user and name without using capitalize charters, only normal letters and numbers, in db prefix also, so we fix problem 🙂

Viewing 13 replies - 16 through 28 (of 28 total)
1 2
  • The topic ‘Woocommerce Version : 4.1.1 error : wp_wc_reserved_stock table creation failed’ is closed to new replies.