table creation failed

  • I have updated woocommerce to the last release, but I’ve got an issue with the db.
    I can’t create table into the db, I receive this error “table creation failed” “Does the *ADMIN* user have CREATE privileges on the *ADMIN* database?”
    I checked the status of woocommerce and there are errors in some tables, I see that the prefix is “IgI_” but the old and working table have prefix “igi_”.
    I have changed nothing, but it looks like the prefix now has some capital letters, is this the problem? how can I fix it?

    Fabio

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    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.

    Thread Starter lastfabio

    (@lastfabio)

    Thanks for your answer, is it possible to attach a screenshot to explain the issue?

    Plugin Support RK a11n

    (@riaanknoetze)

    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.

    Thread Starter lastfabio

    (@lastfabio)

    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

    Plugin Support 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,

    Thread Starter lastfabio

    (@lastfabio)

    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

    Plugin 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,

    Thread Starter lastfabio

    (@lastfabio)

    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.

    Thread Starter lastfabio

    (@lastfabio)

    I have read that many other users have this problem “WooCommerce reserved_stock table creation failed” but I can’t understand what causes it.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘table creation failed’ is closed to new replies.