Hi there,
It sounds like the database user (configured on the server side) doesn’t have the correct privileges *and* that the prefixes were changed. To remedy that, you’d need to get in touch with the website hosting provider as it’s not something that can be addressed from within the WordPress admin area.
Thanks for your answer, is it possible to attach a screenshot to explain the issue?
Attaching screenshot isn’t possible on the forum thread directly, although you could upload them to an image hosting solution like Dropbox, Imgur, Google Drive or snipboard.io and then share the direct links here.
This is the error:
https://www.dropbox.com/s/vnnjcwnxwq1ozke/ss_3.jpg?dl=0
This is the status of woocommerce:
https://www.dropbox.com/s/8cj7jmca8kmzowm/ss_1.png?dl=0
https://www.dropbox.com/s/z8bxbid0pmrgjf7/ss_2.png?dl=0
As you can see there is a problem as the tables with prefix IgI_ don’t exist, and I can’t create them. But old tables with prefix igi_ have no problem. Something has happened with the last update of woocommerce as I have never changed the prefix neither the privileges on DB.
regards
con
(@conschneider)
Engineer
Hi there,
I have changed nothing, but it looks like the prefix now has some capital letters, is this the problem? how can I fix it?
Yes, I see what you mean. In general the prefix must be the same on all tables. I would try and fix this manually.
But looking at the table mish mash, I would also actually fetch a backup, revert and start again. It looks like something elemental went wrong here.
Do you have a backup handy that you can use to rollback?
Kind regards,
Hi, unluckily I have no backup. When you say to fix it manually, do you mean to change the prefix from Igi_ to the original igi_? If you mean that, should I just edit wp-config.php?
thanks for the support
con
(@conschneider)
Engineer
Hi there,
> Hi, unluckily I have no backup.
Your hosting provider might have one for you.
> When you say to fix it manually, do you mean to change the prefix from Igi_ to the original igi_?
Yes. A web developer who has experience with the database structure can help you take a look at the current data.
> If you mean that, should I just edit wp-config.php?
That depends. Someone has to check the database structure with you. I think you will need MySQL / PHPmyAdmin to edit the database directly. Also take a database backup beforehand: https://help.one.com/hc/en-us/articles/360002107438-Change-the-table-prefix-for-WordPress-
Kind regards,
Hi, I followed the instructions, but now I have this issue:
“Sorry, you are not allowed to access this page.”
And I can’t access to the backend.
I have read that many other users have this problem “WooCommerce reserved_stock table creation failed” but I can’t understand what causes it.
