database error – tables missing

  • Resolved MadeleineLenagh

    (@madeleinelenagh)


    7 months 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)
  • Thread Starter MadeleineLenagh

    (@madeleinelenagh)

    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)

    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)

    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)

    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)

    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)

    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)

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

    Stef

    (@serafinnyc)

    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

    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)
  • The topic ‘database error – tables missing’ is closed to new replies.