Title: database table does not exist
Last modified: September 1, 2016

---

# database table does not exist

 *  [fawazmek](https://wordpress.org/support/users/fawazmek/)
 * (@fawazmek)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/)
 * Hi,
 * I am using Flatsome Theme, it was all working fine. On my home page i have a 
   section where i post my best selling items manually by entering Product ID. However
   suddenly the theme or woocommerce stopped responding to that, and it start loading
   all my products no matter what product ID i enter. I have 750 products, and they
   are all loading even if i just enter 1 product ID.
    I got back to the theme developer
   support, and they investigated, they enter my wordpress dashboard and discovered
   that WooCommerce database table.
 * Which is the following:
 * Database
    WC Database Version: 2.6.4 woocommerce_sessions Table does not exist
   woocommerce_api_keys Table does not exist woocommerce_attribute_taxonomies Table
   does not exist woocommerce_downloadable_product_permissions Table does not exist
   woocommerce_order_items Table does not exist woocommerce_order_itemmeta Table
   does not exist woocommerce_tax_rates Table does not exist woocommerce_tax_rate_locations
   Table does not exist woocommerce_shipping_zones Table does not exist woocommerce_shipping_zone_locations
   Table does not exist woocommerce_shipping_zone_methods Table does not exist woocommerce_payment_tokens
   Table does not exist woocommerce_payment_tokenmeta Table does not exist MaxMind
   GeoIP Database: C:\Inetpub\vhosts\bulkco.ae\httpdocs/wp-content/uploads/GeoIP.
   dat
 * Im not even sure that this is the problem thats causing the issue.
 * How can i fix this?
 * Kind Regards,
 * [https://wordpress.org/plugins/woocommerce/](https://wordpress.org/plugins/woocommerce/)

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

 *  [Thomas Shellberg](https://wordpress.org/support/users/shellbeezy/)
 * (@shellbeezy)
 * Automattic Happiness Engineer
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/#post-7664314)
 * How are you displaying the ‘best selling items’? Using a widget or a custom template
   area?
    Does your database appear to be missing any data, like orders, taxes, 
   shipping? If a table is missing, you can try deactivating and reactivating WooCommerce;
   it should rebuild missing tables, but you certainly shouldn’t be missing that
   many tables.
 *  Thread Starter [fawazmek](https://wordpress.org/support/users/fawazmek/)
 * (@fawazmek)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/#post-7664375)
 * Im not sure you are familiar with the Flatsome Theme, but im displaying them 
   under a block with the following code:
 * [block id=”best-seller”]
 * [products ids=”105″ ]
 * And as you see, i only have one product ID, but it still displays all 750 products,
   i dont know whats causing this.
 * Im not using a widget or a custom template area no.
 * Im not using any shipping areas in my website and also not using any taxes on
   the website.
 * I also desactived and reactived the plugin, but no luck 🙁
 * I tried also deactivating all the plugins and try one by one, still didnt help.
 * I got the whole sustem report if you would like to take a look at it:
 * `
    ### WordPress Environment ###
 * WC Version: 2.6.4
    Log Directory Writable: ✔ WP Version: 4.5.3 WP Multisite: –
   WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US
 * ### Server Environment ###
 * Server Info: Microsoft-IIS/8.5
    PHP Version: 5.6.24 PHP Post Max Size: 8 MB PHP
   Time Limit: 60 PHP Max Input Vars: 1000 cURL Version: 7.49.1 OpenSSL/1.0.1t
 * SUHOSIN Installed: –
    MySQL Version: 5.6.26 Max Upload Size: 8 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: 2.6.4
    : woocommerce_sessions: ❌ Table does not exist woocommerce_api_keys:
   ❌ Table does not exist woocommerce_attribute_taxonomies: ❌ Table does not exist
   woocommerce_downloadable_product_permissions: ❌ Table does not exist woocommerce_order_items:
   ❌ Table does not exist woocommerce_order_itemmeta: ❌ Table does not exist woocommerce_tax_rates:
   ❌ Table does not exist woocommerce_tax_rate_locations: ❌ Table does not exist
   woocommerce_shipping_zones: ❌ Table does not exist woocommerce_shipping_zone_locations:
   ❌ Table does not exist woocommerce_shipping_zone_methods: ❌ Table does not 
   exist woocommerce_payment_tokens: ❌ Table does not exist woocommerce_payment_tokenmeta:
   ❌ Table does not exist MaxMind GeoIP Database: ✔
 * ### Active Plugins (15) ###
 * Font Awesome 4 Menus: by New Nine Media – 4.6.3.3
    Indeed Coming Soon: by indeed–
   2.7 WooCommerce Delivery Slots: by Iconic – 1.7.0 Max Mega Menu: by Tom Hemsley–
   2.2.3 Nextend Facebook Connect: by Roland Soos – 1.5.9 Ninja Forms: by The WP
   Ninjas – 2.9.55.2 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6
   Responsive Menu: by Responsive Menu – 3.0.9 SiteOrigin CSS: by SiteOrigin – 1.0.8
   Woo AJAX Cart: by Moises Heberle – 1.1 WooCommerce: by WooThemes – 2.6.4 WooSidebars:
   by WooThemes – 1.4.3 WP Instagram Widget: by Scott Evans – 1.9.8 YITH WooCommerce
   Ajax Search: by YITHEMES – 1.4.0 YITH WooCommerce Wishlist: by YITHEMES – 2.0.16
 * ### Settings ###
 * Force SSL: –
    Currency: AED (د.إ) Currency Position: right_space Thousand Separator:,
   Decimal Separator: . Number of Decimals: 2
 * ### API ###
 * API Enabled: ✔
 * ### WC Pages ###
 * Shop Base: #281 – /shop/
    Cart: #282 – /cart/ Checkout: #283 – /checkout/ My 
   Account: #271 – /my-account/
 * ### Taxonomies ###
 * Product Types: external (external)
    grouped (grouped) simple (simple) variable(
   variable)
 * ### Theme ###
 * Name: Flatsome Child Theme
    Version: 2.5 Author URL: http:%20//www.uxthemes.com/
   Child Theme: ✔ Parent Theme Name: Flatsome Parent Theme Version: 2.9.6 Parent
   Theme Author URL: [http://www.uxthemes.com/](http://www.uxthemes.com/) WooCommerce
   Support: ✔
 * ### Templates ###
 * Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart\
   cart.php flatsome/woocommerce/cart\proceed-to-checkout-button.php flatsome/woocommerce/
   checkout\form-checkout.php flatsome/woocommerce/content-product.php flatsome/
   woocommerce/content-product_cat.php flatsome/woocommerce/content-single-product.
   php flatsome/woocommerce/global\breadcrumb.php flatsome/woocommerce/global\wrapper-
   end.php flatsome/woocommerce/global\wrapper-start.php flatsome/woocommerce/loop\
   loop-end.php flatsome/woocommerce/loop\loop-start.php flatsome/woocommerce/loop\
   orderby.php flatsome/woocommerce/loop\pagination.php flatsome/woocommerce/loop\
   sale-flash.php flatsome/woocommerce/myaccount\form-login.php flatsome/woocommerce/
   myaccount\navigation.php flatsome/woocommerce/notices\error.php flatsome/woocommerce/
   notices\success.php flatsome/product-searchform.php flatsome/woocommerce/single-
   product\add-to-cart\grouped.php flatsome/woocommerce/single-product\add-to-cart\
   simple.php flatsome/woocommerce/single-product\add-to-cart\variable.php flatsome/
   woocommerce/single-product\add-to-cart\variation-add-to-cart-button.php flatsome/
   woocommerce/single-product\price.php flatsome/woocommerce/single-product\product-
   image.php flatsome/woocommerce/single-product\product-thumbnails.php flatsome/
   woocommerce/single-product\related.php flatsome/woocommerce/single-product\review.
   php flatsome/woocommerce/single-product\sale-flash.php flatsome/woocommerce/single-
   product\share.php flatsome/woocommerce/single-product\short-description.php flatsome/
   woocommerce/single-product\tabs\additional-information.php flatsome/woocommerce/
   single-product\tabs\description.php flatsome/woocommerce/single-product\tabs\
   tabs.php flatsome/woocommerce/single-product\title.php flatsome/woocommerce/single-
   product\up-sells.php flatsome/woocommerce/single-product-reviews.php flatsome/
   woocommerce/single-product.php
 * ————————————————————
 * Can you help me with this please, its my business website.
 * Kind Regards
 *  [Caleb Burks](https://wordpress.org/support/users/icaleb/)
 * (@icaleb)
 * Automattic Happiness Engineer
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/#post-7664422)
 * Those database errors are definitely a problem. Is your site working? Do orders
   have order items in them with itemmeta, do shipping zones and tax rates appear
   and work (I know you aren’t using them, but could try adding to them for testing)?
   If so, may just be some type of connection issue with the system status report.
   If not, then you need to look into that for sure.
 * I don’t think the database errors are the cause of this though. You said you 
   are using the `[products ids="105" ]` shortcode: [https://docs.woocommerce.com/document/woocommerce-shortcodes/#section-9](https://docs.woocommerce.com/document/woocommerce-shortcodes/#section-9).
   Maybe something is interferring with the query.
 * Try temporarily switching back to the WordPress Twenty Sixteen Theme, or [Storefront](http://www.woothemes.com/storefront/),
   and disable all plugins except for WooCommerce. If that resolves the issue, then
   slowly re-enable features until you find the one that’s causing the conflict.
 *  [robscott](https://wordpress.org/support/users/robscott/)
 * (@robscott)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/#post-8563399)
 * This is not a me too.
 * Working on a new-to-me client site I came across the same database tables not
   existing on an otherwise working (well the issue is not related) site.
 * In the above, there are two issues:
 * 1) database doesn’t contain necessary tables. This is a problem.
    2) The problems
   engaged with above.
 * Those database tables should exist. In the site in question, they do exist.
 * So I think the issue is that these aren’t being looked for correctly. In my case,
   there’s a non standard db prefix. I’m going to see if this is the root cause…
   Just posting here in case anyone else is similarly questioning themselves about
   db tables which are clearly present!
 *  [robscott](https://wordpress.org/support/users/robscott/)
 * (@robscott)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/#post-8563662)
 * Okay I have further info – the site in question is hosted on IIS (Windows) and
   probably (maybe, perhaps) it is that + the non standard database prefix which
   causes this.
 * I cannot confirm with my sample size of 1, but I have not seen this before in
   sites hosted in Linux.

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

The topic ‘database table does not exist’ 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/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * 5 replies
 * 4 participants
 * Last reply from: [robscott](https://wordpress.org/support/users/robscott/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/database-table-does-not-exist-1/#post-8563662)
 * Status: not resolved