Error Message

Hi @vincedanks,

Thanks for reaching out.

I understand you’re having trouble setting up your WooCommerce store.

Looking at the error message, it is possible that the WooCommerce plugin is unable to create a necessary table in your WordPress database. In that case, could you please confirm if you’re setting up your store locally or in a live web host?

Hi,

Thanks for responding…

It’s a live web host (HostPapa)

Hi again @vincedanks,

It’s a live web host (HostPapa)

Thanks for confirming.

Could you please share the WooCommerce version you’re installing in your host?

I’m unable to replicate this issue from my test host. As a first step, I recommend sharing the error message with your host’s support team and see if they can assist with the issue.

Let us know how it goes.

Sharing the error message with the host was the first thing I did…and they said to get in touch with you.

The version I’m using is: 9.1.4

I also have the WooCommerce.com Update Manager installed.

Doing a Google search, I came a cross a few people saying it was something to do with database entires not being in lowercase?…doesn’t mean anything to me but wondered if that might mean anything to you?

Hi @vincedanks

WooCommerce 5xp2Ii0Mmb_wc_reserved_stock table creation failed. Does the wordpress_c user have CREATE privileges on the wordpress_6 database?

The error message you’re seeing suggests that the database user (wordpress_c) may not have the necessary privileges to create tables in the WordPress database (wordpress_6).

The first thing you should do is to ensure that the database user has all the necessary privileges. This can usually be done through your hosting control panel. If you’re unsure how to do this, I recommend contacting your host, HostPapa, for assistance.

Additionally, head over to WooCommerce → Status → Tools, and do the following:

• WooCommerce transients – Clear
• Expired transients – Clear
• Clear template cache – Clear
• Capabilities – Reset Capabilities
• Clear customer sessions -Clear
• Update database – Update
• Verify base database tables – Verify

Doing a Google search, I came a cross a few people saying it was something to do with database entires not being in lowercase?…doesn’t mean anything to me but wondered if that might mean anything to you?

It shouldn’t create any issues. However, MySQL is case-sensitive on some systems, so it’s generally best practice to keep database prefix names lowercase. Again, your host should be able to assist you with this.

I hope this clarifies your concern. If you have any other questions, feel free to ask.

Thanks Shameem, this is really useful…

HostPapa have told me that I do have privileges but if I go back to them with this information hopefully they should be able to sort it out…

I’ll post an update when I’ve contacted them.

Thanks again,

Vince

Hello vincedanks,

Thank you for your reply.

We are happy to be of your assistance.

I appreciate your willingness to share updates with us here.
Your contribution will prove helpful for many Woo users. ??

Have great day!

Hi Zubair,

Update as promised…

HostPapa’s support team resolved the problme…this is the email they sent me:

The issue was related to the DB prefix not being in lower case in the wp-config.php file and DB tables were using the lower case version.

It has been fixed now so the prefix is set as lower case in wp-config.php and is now consistent.

The error on the WooCommerce plugin should be resolved now, as the DB table now exists in the expected lowercase.

Please recheck and let us know if any issues persist.

All is good now…thanks again for your help.

Cheers,

Vince

Hello vincedanks,

Thank you for your update.

That is a piece of good news!
I appreciate you for sharing the solution here on the forum.
It will be helpful for many users who might encounter similar issues.

Please don’t hesitate to contact us again if you have more questions or concerns.
We are here to help.

Have a great weekend. ??

Best regards.

Hi @vincedanks

We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!

If you have further questions, please feel free to open a new topic.

Thanks!