SAIwc_reserved_stock – WooCommerce version 6.5.1 – WordPress : 6.0

Hello,

I understand you are receiving the error wp_wc_reserved_stock table creation failed.

Can you tell me what actions were executed on your site to receive that error? So that we can get some context.

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”.?

Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Let us know, thanks.

• This reply was modified 2 years, 5 months ago by Igor H.

System Status : https://www.toptal.com/developers/hastebin/cawixejuni.yaml

Logs : https://www.toptal.com/developers/hastebin/legizeyaba.apache

Hi @valentindu62

Thanks for sharing the System Status Report and the error logs.

Was the site migrated in recently and then the problem started?

It seems that the database tables have not got created properly, and that seems to be related to the WC Database Prefix: SAI, which is in Uppercase letters. Please replace the uppercase characters with lowercase characters and that should help. You can find reference to this on these threads:
– https://www.ads-software.com/support/topic/woocommerce-version-4-1-1-error-wp_wc_reserved_stock-table-creation-failed/page/2/
– https://www.ads-software.com/support/topic/woocommerce-showing-message-wp_wc_reserved_stock-table-creation-failed/

Thank You

PS : Improvement: maybe warn, warn users for this kind of error to modify the prefix of the site.

Where to specify it when installing WordPress

Hi @valentindu62

Improvement: maybe warn, warn users for this kind of error to modify the prefix of the site

That’s a good suggestion. This issue can be avoided by having an error message in place, which should come up when the user gives an invalid/incorrect prefix.

Can I have you propose this feature on our Ideas Board and add your vote(s) to it? The more popular an idea becomes, the more of a priority it is for our developers to review it, and it could become a default feature in one of the upcoming versions of WooCommerce. You can find the Ideas Board at: https://ideas.woocommerce.com/forums/133476-woocommerce

Thanks