Title: Database tables missing
Last modified: June 14, 2022

---

# Database tables missing

 *  Resolved [jameskat](https://wordpress.org/support/users/jameskat/)
 * (@jameskat)
 * [4 years ago](https://wordpress.org/support/topic/database-tables-missing-7/)
 * Hello
    in wp Dashboard I get a message from WooCommerce Database tables missing.
 * “One or more tables required for WooCommerce to function are missing, some features
   may not work as expected. Missing tables: wp_wc_rate_limits, wp_wc_product_attributes_lookup,
   wp_wc_product_download_directories.”
 * I have tray to Verify base database tables from Tools but nothing also i have
   tray the update the WooCommerce to version 6.5.1 but nothing.
 * Do you know someone how to fix this problem ?
 * Thanks for your time.

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [jameskat](https://wordpress.org/support/users/jameskat/)
 * (@jameskat)
 * [4 years ago](https://wordpress.org/support/topic/database-tables-missing-7/#post-15736416)
 * This is my system report.
 *     ```
       ### WordPress Environment ###
   
       WordPress address (URL): http://saborobotics.com
       Site address (URL): http://saborobotics.com
       WC Version: 6.5.1
       REST API Version: ✔ 6.5.1
       WC Blocks Version: ✔ 7.4.3
       Action Scheduler Version: ✔ 3.4.0
       Log Directory Writable: ✔
       WP Version: 6.0
       WP Multisite: –
       WP Memory Limit: 256 MB
       WP Debug Mode: –
       WP Cron: ✔
       Language: el
       External object cache: –
   
       ### Server Environment ###
   
       Server Info: Apache/2.4.39 (Unix) OpenSSL/1.0.1e-fips
       PHP Version: 7.2.16
       PHP Post Max Size: 8 MB
       PHP Time Limit: 30
       PHP Max Input Vars: 1000
       cURL Version: 7.19.7
       NSS/3.44
   
       SUHOSIN Installed: –
       MySQL Version: ❌ 5.5.59 - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
       Max Upload Size: 2 MB
       Default Timezone is UTC: ✔
       fsockopen/cURL: ✔
       SoapClient: ✔
       DOMDocument: ✔
       GZip: ✔
       Multibyte String: ✔
       Remote Post: ✔
       Remote Get: ✔
   
       ### Database ###
   
       WC Database Version: 6.5.1
       WC Database Prefix: wp_
       Total Database Size: 24.34MB
       Database Data Size: 21.99MB
       Database Index Size: 2.35MB
       wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
       wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
       wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
       wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
       wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_actionscheduler_actions: Data: 0.13MB + Index: 0.19MB + Engine InnoDB
       wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_actionscheduler_logs: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
       wp_alphabank_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
       wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
       wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_options: Data: 4.08MB + Index: 0.06MB + Engine InnoDB
       wp_postmeta: Data: 12.31MB + Index: 0.66MB + Engine InnoDB
       wp_posts: Data: 4.48MB + Index: 0.23MB + Engine InnoDB
       wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
       wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
       wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
       wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
       wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
       wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
       wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
       wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
       wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
   
       ### Post Type Counts ###
   
       apps: 2
       attachment: 56
       custom_css: 1
       customize_changeset: 22
       elementor_library: 30
       job: 6
       mc4wp-form: 1
       nav_menu_item: 45
       oembed_cache: 1
       page: 61
       polylang_mo: 2
       post: 16
       product: 19
       revision: 792
       shop_order: 12
       team: 5
       testimonial: 5
       webinars: 8
       wpcf7_contact_form: 9
       wptb-tables: 1
   
       ### Security ###
   
       Secure connection (HTTPS): ❌
       					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
       Hide errors from visitors: ✔
   
       ### Active Plugins (20) ###
   
       Polylang: by WP SYNTEX – 3.2.3
       Contact Form 7: by Takayuki Miyoshi – 5.5.6.1
       Codestar Framework: by Codestar – 1.0.1
       Duplicate Page: by mndpsingh287 – 4.4.8
       Elementor: by Elementor.com – 3.6.5
       PayPal Express Checkout Payment Gateway for WooCommerce ( Basic ): by WebToffee – 1.7.1
       GDPR: by Trew Knowledge – 2.1.2
       Get a Quote Button for WooCommerce: by wpbean – 1.2.4
       MC4WP: Mailchimp for WordPress: by ibericode – 4.8.7
       One Click Demo Import: by OCDI – 3.1.1
       Polylang for WooCommerce: by WP SYNTEX – 1.6.3
       Restore Classic Widgets: by Bill Minozzi – 1.5
       SaaSpot Core: by VictorThemes – 1.9
       Web Expert Eurobank WooCommerce Payment Gateway: by Web Expert – 1.0.36
       WooCommerce Easy Duplicate Product: by WPGem.com – 0.2.0.2
       Product And Custom Post type Dropdown CF7: by  – 1.0
       WooCommerce: by Automattic – 6.5.1
       WP-PageNavi: by Lester 'GaMerZ' Chan – 2.94.0
       WP Table Builder: by WP Table Builder – 1.3.17
       Related Products for WooCommerce: by WebToffee – 1.4.3
   
       ### Inactive Plugins (10) ###
   
       Akismet Anti-Spam: by Automattic – 4.2.4
       All-in-One WP Migration: by ServMask – 7.59
       All in One SEO: by All in One SEO Team – 4.2.0
       AMP: by AMP Project Contributors – 2.2.4
       Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.3
       Hello Dolly: by Matt Mullenweg – 1.7.2
       Jetpack: by Automattic – 10.2.1
       TaxoPress: by TaxoPress – 3.6.1
       WooCommerce Payments: by Automattic – 4.1.0 (update to version 4.2.1 is available)
       WP Mail SMTP: by WPForms – 3.4.0
   
       ### Settings ###
   
       API Enabled: –
       Force SSL: –
       Currency: EUR (€)
       Currency Position: right_space
       Thousand Separator: ,
       Decimal Separator: .
       Number of Decimals: 2
       Taxonomies: Product Types: external (external)
       grouped (grouped)
       simple (simple)
       subscription (subscription)
       variable (variable)
       variable subscription (variable-subscription)
   
       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: –
   
       ### WC Pages ###
   
       Shop base: #3350 - /shop/
       Cart: #3351 - /cart/
       Checkout: #3352 - /checkout/
       My account: #3353 - /my-account/
       Terms and conditions: ❌ Page not set
   
       ### Theme ###
   
       Name: SaaSpot Child
       Version: 1.0
       Author URL: http://themeforest.net/user/VictorThemes/portfolio
       Child Theme: ✔
       Parent Theme Name: SaaSpot
       Parent Theme Version: 1.8.7
       Parent Theme Author URL: http://themeforest.net/user/victorthemes/portfolio
       WooCommerce Support: ✔
   
       ### Templates ###
   
       Archive Template: Your theme has a woocommerce.php file
       you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
   
       Overrides: –
   
       ### WC Pages Translations ###
   
       Shop base: ✔
       Cart: ✔
       Checkout: ✔
       My account: ✔
   
       ### Action Scheduler ###
   
       Complete: 344
       Oldest: 2022-05-26 10:52:47 +0000
       Newest: 2022-06-14 13:41:56 +0000
   
       Failed: 3
       Oldest: 2022-06-10 06:31:16 +0000
       Newest: 2022-06-10 06:31:17 +0000
   
       ### Status report information ###
   
       Generated at: 2022-06-14 14:32:33 +00:00
       ```
   
 * Thanks for your time
 *  [Roxy](https://wordpress.org/support/users/roxannestoltz/)
 * (@roxannestoltz)
 * [4 years ago](https://wordpress.org/support/topic/database-tables-missing-7/#post-15736500)
 * Hi [@jameskat](https://wordpress.org/support/users/jameskat/) ,
 * Thanks for reaching out!
 * I understand that you have missing database tables and that you have already 
   tried to verify the database but the issue persists.
 * Please could you temporarily switch your site to the default [Storefront](https://wordpress.org/themes/storefront/)
   theme and disable all plugins **except for WooCommerce**.
 * Once that is done, navigate to **WooCommerce** > **Status **> **Tools**, and **
   Update databse** to see if those tables are created.
 * Please let me know how this goes!
 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [4 years ago](https://wordpress.org/support/topic/database-tables-missing-7/#post-15737965)
 * Hi [@jameskat](https://wordpress.org/support/users/jameskat/),
 * If updating the database as suggested by [@roxannestoltz](https://wordpress.org/support/users/roxannestoltz/)
   doesn’t help create those missing tables I’d suggest that you ask your host to
   do it for you. This Github has SQL instructions to proceed and create them in
   the correct way.
 * [https://github.com/woocommerce/woocommerce/blob/f994ba1839c2472aaa95560f7cfcfc259372e739/plugins/woocommerce/includes/class-wc-install.php#L1221](https://github.com/woocommerce/woocommerce/blob/f994ba1839c2472aaa95560f7cfcfc259372e739/plugins/woocommerce/includes/class-wc-install.php#L1221)
 *     ```
       PHP Version: 7.2.16
       MySQL Version: ❌ 5.5.59
       ```
   
 * Please also note that your WordPress site doesn’t meet our minimum requirements,
   then many plugins (including possibly the core WooCommerce plugin) won’t function
   as expected. Read over the WooCommerce Server Recommendations below.
 * [https://woocommerce.com/document/server-requirements/](https://woocommerce.com/document/server-requirements/)
 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/database-tables-missing-7/#post-15758644)
 * Hi there,
 * We’ve not heard back from you in a while so I’ll go ahead and mark this thread
   as resolved. Hopefully, you were able to find a solution to this issue.
 * If you have further questions, please feel free to open a new topic.
 * Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database 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/)

 * 4 replies
 * 3 participants
 * Last reply from: [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * Last activity: [3 years, 11 months ago](https://wordpress.org/support/topic/database-tables-missing-7/#post-15758644)
 * Status: resolved