Title: database error – tables missing
Last modified: April 26, 2024

---

# database error – tables missing

 *  Resolved [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/)
 * (@madeleinelenagh)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-tables-missing%2Fpage%2F2%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

[←](https://wordpress.org/support/topic/database-error-tables-missing/?output_format=md)
[1](https://wordpress.org/support/topic/database-error-tables-missing/?output_format=md)
2

 *  Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/)
 * (@madeleinelenagh)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17723659)
 * > If you look at your system report the prefix for all tables is
   >     ```wp-block-code
   >     uIa81BA
   >     ```
   > 
   > but those tables are looking for
   >     ```wp-block-code
   >     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.
   >     ```wp-block-code
   >     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](https://wordpress.org/support/users/serafinnyc/)
 * (@serafinnyc)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17723695)
 * 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](https://wordpress.org/support/users/madeleinelenagh/)
 * (@madeleinelenagh)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17723766)
 * Yes, I can see them in the database. So why does SQL not see them?
 * > **SQL query:** [Copy](https://xmail.nl:8443/phpMyAdmin/index.php?route=/database/sql&db=wp_woth1#)
   >     ```wp-block-code
   >     RENAME table uta81ba_ TO uia81BA_;
   >     ```
   > 
   > **MySQL said: **[](https://xmail.nl:8443/phpMyAdmin/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html)`#
   > 1146 - Table 'wp_woth1.uta81ba_' doesn't exist`
 *  [Stef](https://wordpress.org/support/users/serafinnyc/)
 * (@serafinnyc)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17723997)
 * 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](https://loom.com/i/418b25fa2e564c91a6f5fa5f19eb91d7).
 *  Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/)
 * (@madeleinelenagh)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17724082)
 * ![](https://i0.wp.com/lenagh.nl/wp-content/uploads/2024/04/php3.jpg?ssl=1)
 * That’s exactly what it looks like when I first open PHPmyadmin. And this is the
   information Plesk gives me about the database.
 * ![](https://i0.wp.com/lenagh.nl/wp-content/uploads/2024/04/php4.jpg?ssl=1)
 *  [Stef](https://wordpress.org/support/users/serafinnyc/)
 * (@serafinnyc)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17724096)
 * 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](https://wordpress.org/support/users/madeleinelenagh/)
 * (@madeleinelenagh)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17724131)
 * Even with a large screen, that doesn’t fit LOL! Here’s page 3 of the navigation
   table.
 * ![](https://i0.wp.com/lenagh.nl/wp-content/uploads/2024/04/php5.jpg?ssl=1)
 *  [Stef](https://wordpress.org/support/users/serafinnyc/)
 * (@serafinnyc)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17724150)
 * 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](https://wordpress.org/support/users/anastas10s/)
 * (@anastas10s)
 * [2 years ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17751202)
 * 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)

[←](https://wordpress.org/support/topic/database-error-tables-missing/?output_format=md)
[1](https://wordpress.org/support/topic/database-error-tables-missing/?output_format=md)
2

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

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * 24 replies
 * 3 participants
 * Last reply from: [anastas10s](https://wordpress.org/support/users/anastas10s/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/database-error-tables-missing/page/2/#post-17751202)
 * Status: resolved