Support » Plugin: WooCommerce » database table does not exist

  • 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/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Thomas Shellberg

    (@shellbeezy)

    Automattic Happiness Engineer

    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.

    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/
    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

    (@icaleb)

    Automattic Happiness Engineer

    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. Maybe something is interferring with the query.

    Try temporarily switching back to the WordPress Twenty Sixteen Theme, or 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.

    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!

    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.