Shipping Zone Database Error

  • Hi I am running into some db issues with the shipping zone… I keep getting the following on my debug log:

    WordPress database error Table ‘db578289832.wp_woocommerce_shipping_zone_shipping_methods’ doesn’t exist for query SELECT * FROM wp_woocommerce_shipping_zones sz
    join wp_woocommerce_shipping_zone_shipping_methods szm on sz.zone_id = szm.zone_id

    I am troubleshooting a different issue, but this may be related and could be pretty important piece to resolving my issue. I have a plugin to handle my UPS Shipping called UPS Toolbox, and sporadically the plugin does NOT charge the customer the UPS charge, but creates labels and finalizes the transaction with no other issues. I am currently working with the developer on this, and he believes this may be part of the issue.

    The System Report:

    ### WordPress Environment ###

    Home URL: https://bovellas.com
    Site URL: https://bovellas.com
    WC Version: 2.6.9
    Log Directory Writable: ?
    WP Version: 4.6.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ?
    WP Cron: ?
    Language: en_US

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 5.6.28
    PHP Post Max Size: 64 MB
    PHP Time Limit: 50000
    PHP Max Input Vars: 5000
    cURL Version: 7.38.0
    OpenSSL/1.0.1t

    SUHOSIN Installed: –
    MySQL Version: ? 5.1.73 – We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
    Max Upload Size: 64 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 2.6.9
    :
    woocommerce_sessions: ?
    woocommerce_api_keys: ?
    woocommerce_attribute_taxonomies: ?
    woocommerce_downloadable_product_permissions: ?
    woocommerce_order_items: ?
    woocommerce_order_itemmeta: ?
    woocommerce_tax_rates: ?
    woocommerce_tax_rate_locations: ?
    woocommerce_shipping_zones: ?
    woocommerce_shipping_zone_locations: ?
    woocommerce_shipping_zone_methods: ?
    woocommerce_payment_tokens: ?
    woocommerce_payment_tokenmeta: ?
    MaxMind GeoIP Database: ?

    ### Active Plugins (9) ###

    Bovellas Pastry Shoppe Contact Form: by Sergio Ribeiro – 1.0.0
    Akismet: by Automattic – 3.2
    Bovella’s Pastry Shoppe Sales Report: by Sergio Ribeiro – 1.0.0
    PayPal for WooCommerce: by Angell EYE – 1.2.4
    Responsive Lightbox: by dFactory – 1.6.10
    WooCommerce TM Extra Product Options: by themecomplete – 4.3.4
    WooCommerce UPS Toolbox: by Catman Studios – 1.17.3
    WooCommerce: by WooThemes – 2.6.9
    Yoast SEO: by Team Yoast – 3.9

    ### Settings ###

    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2

    ### API ###

    API Enabled: ?

    ### WC Pages ###

    Shop Base: #4 – /shop/
    Cart: #5 – /cart/
    Checkout: #6 – /checkout/
    My Account: #7 – /my-account/

    ### Taxonomies ###

    Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)

    ### Theme ###

    Name: Bovellas Pastry Shoppe
    Version: 1.0.0
    Author URL: https://simetriastudio.com
    Child Theme: ? – If you’re modifying WooCommerce on a parent theme you didn’t build personally
    then we recommend using a child theme. See: How to create a child theme

    WooCommerce Support: ?

    ### Templates ###

    Overrides: –

    Thank you for your time.

    Serge

    • This topic was modified 7 years, 11 months ago by Sribeiro.
Viewing 2 replies - 1 through 2 (of 2 total)

  • @sribeiro did you check your database to see if the table wp_woocommerce_shipping_zone_shipping_methods exists? That table should have been installed in one of the recent WooCommerce updates when you did your database update.

    Your MySQL version is also very old, you need to get that upgraded.

    Thread Starter Sribeiro

    (@sribeiro)

    Thanks anphira, I have wp_woocommerce_shipping_zone_shipping_methods table in the database, and I am currently upgrading the MySQL version as we speak.

    Why would I still get that error message in the debug logs if the table exists? It is empty, but it exists.

    Sergio

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Shipping Zone Database Error’ is closed to new replies.