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%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 15 replies - 1 through 15 (of 24 total) 1 [2](https://wordpress.org/support/topic/database-error-tables-missing/page/2/?output_format=md) [→](https://wordpress.org/support/topic/database-error-tables-missing/page/2/?output_format=md) * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17717597) * This is an excerpt from the status report * WC Database Version: 8.8.2 WC Database Prefix: uIa81BA_Total Database Size: 24.26MBDatabase Data Size: 17.14MBDatabase Index Size: 7.12MBuIa81BA_woocommerce_sessions: ❌ Table does not existuIa81BA_woocommerce_api_keys: ❌ Table does not existuIa81BA_woocommerce_attribute_taxonomies: ❌ Table does not existuIa81BA_woocommerce_downloadable_product_permissions: ❌ Table does not existuIa81BA_woocommerce_order_items: ❌ Table does not existuIa81BA_woocommerce_order_itemmeta: ❌ Table does not existuIa81BA_woocommerce_tax_rates: ❌ Table does not existuIa81BA_woocommerce_tax_rate_locations: ❌ Table does not existuIa81BA_woocommerce_shipping_zones: ❌ Table does not existuIa81BA_woocommerce_shipping_zone_locations: ❌ Table does not existuIa81BA_woocommerce_shipping_zone_methods: ❌ Table does not existuIa81BA_woocommerce_payment_tokens: ❌ Table does not existuIa81BA_woocommerce_payment_tokenmeta: ❌ Table does not existuIa81BA_woocommerce_log: ❌ Table does not exist * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17718123) * Can you do us a favor and go to **WooCommerce** > **Status** > **Get Systems Report** and copy it, then come back here and use a code block to pate it into. If you want to omit the site url you can. Nothing else though. * Thanks * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17718448) * ```wp-block-code ` ### WordPress Environment ### WordPress address (URL): Site address (URL): WC Version: 8.8.2 REST API Version: ✔ 8.8.2 Action Scheduler Version: ✔ 3.7.4 Log Directory Writable: ✔ WP Version: 6.5.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Microsoft-IIS/10.0 PHP Version: 7.4.33 PHP Post Max Size: 16 MB PHP Time Limit: 120 PHP Max Input Vars: 1000 cURL Version: 7.70.0 OpenSSL/1.1.1s SUHOSIN Installed: – MySQL Version: 5.5.5-10.6.16-MariaDB Max Upload Size: 16 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 8.8.2 WC Database Prefix: uIa81BA_ Total Database Size: 24.58MB Database Data Size: 17.43MB Database Index Size: 7.15MB uIa81BA_woocommerce_sessions: ❌ Table does not exist uIa81BA_woocommerce_api_keys: ❌ Table does not exist uIa81BA_woocommerce_attribute_taxonomies: ❌ Table does not exist uIa81BA_woocommerce_downloadable_product_permissions: ❌ Table does not exist uIa81BA_woocommerce_order_items: ❌ Table does not exist uIa81BA_woocommerce_order_itemmeta: ❌ Table does not exist uIa81BA_woocommerce_tax_rates: ❌ Table does not exist uIa81BA_woocommerce_tax_rate_locations: ❌ Table does not exist uIa81BA_woocommerce_shipping_zones: ❌ Table does not exist uIa81BA_woocommerce_shipping_zone_locations: ❌ Table does not exist uIa81BA_woocommerce_shipping_zone_methods: ❌ Table does not exist uIa81BA_woocommerce_payment_tokens: ❌ Table does not exist uIa81BA_woocommerce_payment_tokenmeta: ❌ Table does not exist uIa81BA_woocommerce_log: ❌ Table does not exist uia81ba_actionscheduler_actions: Data: 0.05MB + Index: 0.16MB + Engine InnoDB uia81ba_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_booking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bookingdates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_album: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_album_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_file_paths: Data: 0.25MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_image: Data: 0.05MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_image_comment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_image_rate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_image_tag: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_shortcode: Data: 0.14MB + Index: 0.00MB + Engine InnoDB uia81ba_bwg_theme: Data: 0.08MB + Index: 0.00MB + Engine InnoDB uia81ba_commentmeta: Data: 0.17MB + Index: 0.03MB + Engine InnoDB uia81ba_comments: Data: 0.13MB + Index: 0.09MB + Engine InnoDB uia81ba_contactformmaker: Data: 0.27MB + Index: 0.00MB + Engine InnoDB uia81ba_contactformmaker_blocked: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_contactformmaker_submits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_contactformmaker_themes: Data: 1.52MB + Index: 0.00MB + Engine InnoDB uia81ba_contactformmaker_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_crp_portfolios: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_elp_deliverreport: Data: 0.00MB + Index: 0.00MB + Engine MyISAM uia81ba_elp_emaillist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM uia81ba_elp_pluginconfig: Data: 0.00MB + Index: 0.00MB + Engine MyISAM uia81ba_elp_sendsetting: Data: 0.00MB + Index: 0.00MB + Engine MyISAM uia81ba_elp_sentdetails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM uia81ba_elp_templatetable: Data: 0.01MB + Index: 0.00MB + Engine MyISAM uia81ba_ewwwio_images: Data: 0.34MB + Index: 0.25MB + Engine InnoDB uia81ba_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_ig_actions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB uia81ba_ig_blocked_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_ig_campaigns: Data: 0.02MB + Index: 0.05MB + Engine InnoDB uia81ba_ig_contactmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_ig_contacts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uia81ba_ig_contacts_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_ig_contact_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_ig_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_ig_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB uia81ba_ig_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_ig_lists_contacts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_ig_mailing_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_ig_queue: Data: 0.02MB + Index: 0.13MB + Engine InnoDB uia81ba_ig_sending_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_iowd_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uia81ba_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_nxs_log: Data: 0.20MB + Index: 0.00MB + Engine InnoDB uia81ba_nxs_query: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_options: Data: 5.50MB + Index: 0.22MB + Engine InnoDB uia81ba_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB uia81ba_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_postmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB uia81ba_posts: Data: 1.52MB + Index: 0.27MB + Engine InnoDB uia81ba_sies_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_subscribe2: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_trp_dictionary_en_us_nl_nl: Data: 0.19MB + Index: 0.08MB + Engine InnoDB uia81ba_trp_gettext_en_us: Data: 0.36MB + Index: 0.39MB + Engine InnoDB uia81ba_trp_gettext_nl_nl: Data: 0.27MB + Index: 0.28MB + Engine InnoDB uia81ba_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB uia81ba_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB uia81ba_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB uia81ba_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB uia81ba_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB uia81ba_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uia81ba_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uia81ba_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB uia81ba_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB uia81ba_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uia81ba_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uia81ba_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB uia81ba_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uia81ba_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uia81ba_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uia81ba_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB uta81ba_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uta81ba_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB uta81ba_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uta81ba_options: Data: 1.52MB + Index: 0.03MB + Engine InnoDB uta81ba_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uta81ba_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB uta81ba_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uta81ba_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uta81ba_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB uta81ba_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uta81ba_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB uta81ba_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ### Post Type Counts ### attachment: 680 bwg_gallery: 2 bwg_tag: 41 custom_css: 1 customize_changeset: 1 elementor_library: 1 es_template: 2 language_switcher: 3 nav_menu_item: 101 page: 86 post: 23 product: 2 proof_gallery: 2 pt-music-album: 7 pt-portfolio: 6 revision: 306 whizzy_proof_gallery: 1 wp_global_styles: 1 wpcf7_contact_form: 1 yprm_footer_builder: 5 yprm_header_builder: 7 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (27) ### Redux Framework: by Team Redux – 4.4.15 Advanced Custom Fields: by WP Engine – 6.2.9 Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2 All-in-One WP Migration Unlimited Extension: by ServMask – 2.56 All-in-One WP Migration: by ServMask – 7.81 Black Studio TinyMCE Widget: by Black Studio – 2.7.2 Contact Form 7: by Takayuki Miyoshi – 5.9.3 CookieYes | GDPR Cookie Consent: by CookieYes – 3.2.2 Envato Market: by Envato – 2.0.11 Extendify: by Extendify – 1.13.5 Easy HTTPS (SSL) Redirection: by Tips and Tricks HQ – 1.9.2 WPBakery Page Builder: by Michael M - WPBakery.com – 7.6 PixProof: by Pixelgrade – 2.0.1 PT Music Album: by Promo Theme – 1.0.4 PT Novo Shortcodes: by Promo Theme – 4.2.5 PT Portfolio: by Promo Theme – 1.0.5 QuickCal: by QuickCal – 1.0.12 Advanced Editor Tools: by Automattic – 5.9.2 Unyson: by ThemeFuse – 2.7.31 Increase Maximum Upload File Size: by Imagify – 2.0.4 WooPayments: by Automattic – 7.5.3 WooCommerce PayPal Payments: by WooCommerce – 2.6.1 WooCommerce Shipping & Tax: by WooCommerce – 2.5.4 WooCommerce: by Automattic – 8.8.2 WP File Manager: by mndpsingh287 – 7.2.6 Perfect Images (Optimize, Rebuild, Replace, Thumbnails, Retina): by Jordy Meow – 6.5.5 WP Super Cache: by Automattic – 1.12.0 ### Inactive Plugins (0) ### ### Dropin Plugins () ### advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php ### Settings ### API Enabled: ✔ Force SSL: – Currency: EUR (€) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 0 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: – HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – ### Logging ### Enabled: ✔ Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 days Level threshold: – Log directory size: 134 KB ### WC Pages ### Shop base: ❌ Page ID is set but the page does not exist Cart: #7 - /cart/ Checkout: #8 - /checkout/ My account: #9 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Novo Version: 4.2.5 Author URL: http://themeforest.net/user/ypromo Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: novo/woocommerce/archive-product.php version 4.0.0 is out of date. The core version is 8.6.0 novo/woocommerce/cart\cart-empty.php novo/woocommerce/cart\cart-item-data.php novo/woocommerce/cart\cart-totals.php novo/woocommerce/cart\cart.php novo/woocommerce/cart\cross-sells.php novo/woocommerce/cart\mini-cart.php novo/woocommerce/cart\proceed-to-checkout-button.php novo/woocommerce/cart\shipping-calculator.php novo/woocommerce/checkout\form-billing.php novo/woocommerce/checkout\form-checkout.php novo/woocommerce/checkout\form-shipping.php novo/woocommerce/checkout\payment.php novo/woocommerce/checkout\review-order.php novo/woocommerce/content-product.php novo/woocommerce/content-single-product.php novo/woocommerce/content-widget-product.php novo/woocommerce/global\quantity-input.php novo/woocommerce/global\wrapper-end.php novo/woocommerce/global\wrapper-start.php novo/woocommerce/loop\add-to-cart.php novo/woocommerce/loop\loop-end.php novo/woocommerce/loop\loop-start.php novo/woocommerce/loop\no-products-found.php novo/woocommerce/loop\orderby.php novo/woocommerce/loop\pagination.php novo/woocommerce/loop\price.php novo/woocommerce/loop\rating.php novo/woocommerce/loop\result-count.php novo/woocommerce/loop\sale-flash.php novo/woocommerce/notices\error.php novo/woocommerce/notices\notice.php novo/woocommerce/notices\success.php novo/woocommerce/order\order-details-customer.php version 6.5.0 is out of date. The core version is 8.7.0 novo/woocommerce/order\order-details.php novo/woocommerce/order\tracking.php novo/woocommerce/product-searchform.php novo/woocommerce/single-product\add-to-cart\external.php novo/woocommerce/single-product\add-to-cart\grouped.php novo/woocommerce/single-product\add-to-cart\simple.php novo/woocommerce/single-product\add-to-cart\variable.php novo/woocommerce/single-product\add-to-cart\variation-add-to-cart-button.php novo/woocommerce/single-product\meta.php novo/woocommerce/single-product\price.php novo/woocommerce/single-product\product-attributes.php novo/woocommerce/single-product\product-image.php novo/woocommerce/single-product\related.php novo/woocommerce/single-product\tabs\additional-information.php novo/woocommerce/single-product\tabs\description.php novo/woocommerce/single-product\tabs\tabs.php novo/woocommerce/single-product\title.php novo/woocommerce/single-product\up-sells.php novo/woocommerce/single-product-reviews.php novo/woocommerce/single-product.php novo/woocommerce/content-product_cat.php novo/woocommerce/taxonomy-product_cat.php Outdated Templates: ❌ Learn how to update ### WooPayments ### Version: 7.5.3 Connected to WPCOM: Yes WPCOM Blog ID: 85225860 Account ID: acct_1P8eVWCKjMpGGmRp Payment Gateway: Disabled Test Mode: Disabled Enabled APMs: card WooPay: Not eligible Apple Pay / Google Pay: Enabled (product,cart,checkout) Fraud Protection Level: basic Multi-currency: Enabled Public Key Encryption: Disabled Auth and Capture: Enabled Documents: Enabled Logging: Disabled ### WooCommerce PayPal Payments ### Onboarded: ✔ Shop country code: NL WooCommerce currency supported: ✔ Advanced Card Processing available in country: ✔ Pay Later messaging available in country: – Webhook status: – PayPal Vault enabled: – ACDC Vault enabled: – Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – Subscriptions Mode: Disabled ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management product-virtual-downloadable product-external-affiliate product-grouped product-linked product-pre-publish-modal remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience product-custom-fields settings async-product-editor-category-field launch-your-store Daily Cron: ✔ Next scheduled: 2024-04-28 06:34:24 +02:00 Options: ✔ Notes: 72 Onboarding: completed ### Action Scheduler ### Complete: 50 Oldest: 2024-04-26 14:13:56 +0000 Newest: 2024-04-28 02:19:11 +0000 Pending: 2 Oldest: 2024-04-28 14:14:14 +0000 Newest: 2024-04-28 14:19:11 +0000 Failed: 1 Oldest: 2024-04-26 14:48:59 +0000 Newest: 2024-04-26 14:48:59 +0000 ### Status report information ### Generated at: 2024-04-28 08:13:57 +02:00 ` ``` * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17719187) * For some reason the prefix changed somewhere. We’re you tinkering in the database or using an app that somehow changed the prefix for those tables? * 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 ``` * Do you know how to change the prefix for those tables? Let me know your skillset please and if not I’ll instruct you how. * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17719578) * Thank you, Stef. I attempted to change the prefix several days ago and blew up my entire website. That should say something about my skillset. 😉 Curiosity and perseverance have gotten me this far. So yes please, I would appreciate instructions on how to do this. * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17720840) * Ha, got it. Well, super simple. Log into phpmyadmin and then click the database for which you are changing these. Then click the SQL tab. * Then place this in the box and click go. * ```wp-block-code RENAME table uta81ba_ TO uIa81BA_; ``` * That’s it. Those tables should now be recognized. Here’s a [screenshot](https://loom.com/i/972acbf82b4c457e869f47c267ca1dab) * Hope this helps * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17721419) * I logged into phpMyAdmin (there were two accounts listed but it seemed to be obvious which one I needed and, if I didn’t already have white hair, it would have gone white. A list of 117 tables with that prefix? I tried to select them all and then do what you described but got an error message. * At that point my hosting provider finally agreed to step in (he’s not a fan of WordPress) and see if he can fix things. So I’ll wait for him now and get back to you. * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17721548) * I think you misunderstood what I wrote. I don’t think I said SELECT all your tables. I think I even pointed the exact flow in my screenshot. 1, 2 and 3. * But I’m glad your host has stepped in. * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17721587) * I don’t think I misunderstood you. But your screenshot showed a very clear source, for your database and I encountered a list of 117 tables! I have no idea why my phpadmin looks so different from what you showed. * I don’t know if my hosting provider can solve it, he’s always said that he dislikes WP, but we shall see. * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17721990) * All WP databases are pretty the same. There was no need to touch any tables as I stated and showed in my screenshot. 1. Tap the DB that you want to change this for. Some folks have more than one DB in their instance 2. Then tap SQL tab 3. Paste the snippet I wrote for you 4. Click “Go” * That’s it. Nothing else to do. You can always take a screenshot of your phpmyadmin area. * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17722579) * That’s exactly what I’ve been doing, whether or not tables are selected. This is the error message I get: * #1146 – Table ‘wp_woth1.uta81ba_’ doesn’t exist * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17723095) * And I checked again, but the table prefix in my database is actually uia81ba_. And I still got the error message #1146 – Table ‘wp_woth1.uia81ba_’ 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/#post-17723594) * I don’t think you’re understanding what I stated above. That’s why you’re missing this. I don’t know how to better explain this. Do you NOT see the “T” in the incorrect table prefixes that I posted above? * Your prefix is with an “I” NOT a “T” and that’s why these tables are not being recognized. Please tell your host that. I’m scared of what you are doing. * Thread Starter [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/) * (@madeleinelenagh) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17723634) * Stef, I’m not that stupid. I copied and pasted exactly what you posted here. And the message I got from SQL was that it could not find any tables spelled with a t. It isn’t distinguishing the uppercase T from the lower case t. And when I took a second look at the incorrect code, I saw that what we were seeing as a T could also be an uppercase I (with serif). * ```wp-block-code uIa81BA_ ``` * And that’s what I’m seeing in the database: uia81ba_ Which would mean that the prefix is correct. So something else is wrong. - This reply was modified 2 years, 1 month ago by [MadeleineLenagh](https://wordpress.org/support/users/madeleinelenagh/). * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [2 years, 1 month ago](https://wordpress.org/support/topic/database-error-tables-missing/#post-17723643) * No one called you stupid. But if you look at your system report they’re at the bottom. Clear as day. I’m using uppercase to point out the LETTER not that it is uppercase. That’s irrelevant. * You also said earlier you selected all the tables when you first did this. That was not the process. So I’m going to bow out and let someone else help you. Viewing 15 replies - 1 through 15 (of 24 total) 1 [2](https://wordpress.org/support/topic/database-error-tables-missing/page/2/?output_format=md) [→](https://wordpress.org/support/topic/database-error-tables-missing/page/2/?output_format=md) 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