database error – tables missing

  • Resolved MadeleineLenagh

    (@madeleinelenagh)


    2 years, 1 month ago

    I reinstalled WooCommerce recently after having uninstalled it a few years ago. But now I need a webshop. Every time I open WP now, I get an error message:
    WooCommerce uIa81BA_wc_reserved_stock table creation failed. Does the wp_0pteb user have CREATE privileges on the wp_woth1 database?

    So I did a system status report, and it shows a large number of tables missing. Which could possibly be the reason I’m having trouble setting various options, like shipping, for my products.

    I read an old forum topic saying to change a script in wpconfig from uppercase letters to lowercase letters and managed to blow up the entire website. I have everything back now, except all the work I did during the past 3 weeks. So this time I would appreciate a way to fix this. 😉

    The page I need help with: [log in to see the link]

Viewing 9 replies - 16 through 24 (of 24 total)
1 2
  • Thread Starter MadeleineLenagh

    (@madeleinelenagh)

    2 years, 1 month ago

    If you look at your system report the prefix for all tables is

    uIa81BA

    but those tables are looking for

    uta81ba

    Could it be that you gave me the wrong string? This is what you told me to do:

    Then place this in the box and click go.

    RENAME table uta81ba_ TO uIa81BA_;

    And that bit about selecting the tables only happened that first time and didn’t make a difference to the response I got from SQL.

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    Because they’re at the bottom of the report. I’m not sure what you did when you did it. So it’s hard to say. Maybe create a loom of you going thru the process again? The snippet is going look for those and change them from uta81ba_ to uIa81BA_

    As of late that is the correct snippet for changing the table prefix easily

    Thread Starter MadeleineLenagh

    (@madeleinelenagh)

    2 years, 1 month ago

    Yes, I can see them in the database. So why does SQL not see them?

    SQL query: Copy

    RENAME table uta81ba_ TO uia81BA_;

    MySQL said: #1146 - Table 'wp_woth1.uta81ba_' doesn't exist

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    I’d first like to know why there’s a wp_woth1. in all of this. That’s not how it appears in your systems report. Please take a screenshot of your entire DB opened. Like this.

    Thread Starter MadeleineLenagh

    (@madeleinelenagh)

    2 years, 1 month ago

    That’s exactly what it looks like when I first open PHPmyadmin. And this is the information Plesk gives me about the database.

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    You cut this screenshot off I need the entire thing. Like I showed you on mine. Most importantly the bottom portion and or last pages

    Thread Starter MadeleineLenagh

    (@madeleinelenagh)

    2 years, 1 month ago

    Even with a large screen, that doesn’t fit LOL! Here’s page 3 of the navigation table.

    Stef

    (@serafinnyc)

    2 years, 1 month ago

    LOL well, you’re shown me what I needed to see. Those prefixes are right there. I’ve looked at my query 4x. Maybe 5 will help. Let me see

    anastas10s

    (@anastas10s)

    2 years ago

    Hi there 👋 We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 9 replies - 16 through 24 (of 24 total)
1 2

The topic ‘database error – tables missing’ is closed to new replies.