Database tables seem to be missing after Woocommerce Update

  • Resolved plan17

    (@plan17)


    1 year, 8 months ago

    After updating the Woocommerce core plugins (9.1.1) and some related (Payments & Tax, Shipping, Shortcodes) the site broke completely, killing layout and css, not displaying images (Error 500) and leaving the WP backend in quite a mess. I ran the WordPress repair script via /wp-admin/maint/repair.php and it turned out two tables are missing:

    wp_woocommerce_gzd_dhl_labelmeta: Table ‘dbs6083915.wp_woocommerce_gzd_dhl_labelmeta’ doesn’t exist
    wp_woocommerce_gzd_dhl_labels: Table ‘dbs6083915.wp_woocommerce_gzd_dhl_labels’ doesn’t exist

    Judging from the name I assume these are part of the shipping plugin cause the “dhl“ refers to the German delivery service DHL.

    Attemps to reinstall the older plugin versions again did not bring any result.
    Anyone experienced similar effects or has an idea how to fix it beyond a complete database reinstall?

    Thanks in advance

    • This topic was modified 1 year, 8 months ago by plan17.
Viewing 3 replies - 1 through 3 (of 3 total)
  • xue28 (woo-hc)

    (@xue28)

    1 year, 8 months ago

    HI @plan17

    Thanks for reaching out!

    I understand that after updating WooCommerce core, your site broke completely, however, I am quite confused about the version you used here: Woocommerce core plugins (9.1.1) since the latest release is only 7.2.0.

    First, please make sure that you have followed the minimum server recommendations to run WooCommerce smoothly.

    If so, then please try to uninstall the plugin first and reinstall an older version like version 7.1 and see if this works. This should regenerate the missing or broken database tables on your site.

    Let us know how it goes!

    Thread Starter plan17

    (@plan17)

    1 year, 8 months ago

    Hi xue28,

    Thanks for your reply.
    Yes, it was 7.1.1 of course, not nine, sorry. Have solved the issue in the meantime and it seems that woocommerce was NOT the culprit 😉 I deleted an ._index.php and similar other — appearantly corrupted — files in the /wp-content directory that seen to have caused the 500 Internal Server Error. Not sure what exactly been the initial trigger, but maybe another plugin that I’ve updated.

    So thanks again and Happy Holidays 🙂

    Saif

    (@babylon1999)

    1 year, 8 months ago

    Glad to hear you’ve figured it out, @plan17! 😀

    I will mark the thread as solved. If you have a few minutes, we’d love it if you could leave us a review: https://wordpress.org/support/plugin/woocommerce/reviews/

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database tables seem to be missing after Woocommerce Update’ is closed to new replies.