• Resolved MeOnline

    (@webber2012)


    I suddenly get a message that Database tables are missing.
    Apparantly the following table is missing:
    _woocommerce_downloadable_product_permissions

    We’re not even using downloadable products.

    Is there a way to get this specific table back again?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Vedanshu – a11n

    (@vedjain)

    Hi, I am assuming you are on WooCommerce 4.3, if so, please go to wp-admin/admin.php?page=wc-status&tab=tools page on your website and find a button called Verify Database (It should be second last tool on the page). If you click on this button, WC will try to verify if all the tables are present (and create the ones that are not present).

    You are seeing this notice because we added a check to make sure if all needed DB tables are present or not.

    Thread Starter MeOnline

    (@webber2012)

    Thanks for your answer!

    I tried that (several times) but everytime I get a message saying that the database is being verified … one or more tables are still missing wp_woocommerce_downloadable_product_permissions

    I also tried updating the database but that doesn’t solve the issue either.

    Thread Starter MeOnline

    (@webber2012)

    Found the cause: had a too long database prefix, shortened it and verified the database again – problem solved. ??

    I am having a similar problem – here is the message that I am getting:

    One or more tables required for WooCommerce to function are missing, some features may not work as expected. Missing tables: 1603129140_wp_mbqng7f5mz_woocommerce_downloadable_product_permissions. Check again.

    I apologize that I am not a code warrior but I can’t find the wp-admin/admin.php?page=wc-status&tab=tools that you suggest. I have a bunch of downloadable products on my website and non of them will download for my customers. Please help me! (or direct me to someone I can hire to fix this)

    Thread Starter MeOnline

    (@webber2012)

    You cannot find https://www.yourdomain.com/wp-admin/admin.php?page=wc-status&tab=tools ?

    Besides that, seeing your table name, I suspect you also need to shorten the database prefix, that’s the part before
    _woocommerce_downloadable_product_permissions – so this part: 1603129140_wp_mbqng7f5mz
    Better change that to wp_ so it will be wp_woocommerce_downloadable_product_permissions

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Missing table?’ is closed to new replies.