Missing tables

  • Resolved gericjhon

    (@gericjhon)


    2 years, 9 months ago

    Missing base tables:
    wpgj_woocommerce_shipping_zones, wpgj_woocommerce_shipping_zone_methods
    wpgj_wc_order_stats
    wpgj_wc_order_coupon_lookup.

    Some WooCommerce functionality may not work as expected.

    How do I fix this thing I cant manually add them, I already exhausted the woo-commerce tools to generate these tables but it’s not working.
    I don’t know why but we disabled our shipping on out store, since we don’t sell a physical thing.

Viewing 1 replies (of 1 total)
  • xue28 (woo-hc)

    (@xue28)

    2 years, 8 months ago

    Hi @gericjhon

    Thanks for reaching out!

    I understand that you’re having some issues with missing base tables.

    The tables you’ve mentioned are indeed important for WooCommerce to function properly. The woocommerce_shipping_zones and woocommerce_shipping_zone_methods tables are related to the shipping functionality, while the wc_order_stats and wc_order_coupon_lookup tables are used for storing order statistics and coupon data respectively.

    Given that you mentioned you do not sell physical products and have disabled shipping on your store, the missing shipping-related tables should not affect your store’s functionality. However, the missing wc_order_stats and wc_order_coupon_lookup tables could potentially cause issues.

    If you’ve already tried using the WooCommerce tools to regenerate these tables and it didn’t work, it might be due to a plugin conflict or a problem with your database. Here are a few steps you can take:

    1. Disable all plugins except WooCommerce: Sometimes, other plugins can interfere with WooCommerce’s functionality. Try disabling all other plugins and then attempt to regenerate the tables again using WooCommerce tools. If this works, you can enable the other plugins one by one to identify which one is causing the conflict.
    2. Check your database: If disabling plugins doesn’t solve the problem, there might be an issue with your database. If you’re comfortable with doing so, you can check your database using a tool like phpMyAdmin to see if there’s an issue. Please make sure to back up your database before making any changes.
    3. Reinstall WooCommerce: If all else fails, you can try reinstalling WooCommerce. Please make sure to back up your site before doing this as it could potentially lead to data loss.

    Hope this helps!

Viewing 1 replies (of 1 total)

The topic ‘Missing tables’ is closed to new replies.