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

Upgrading WooCommerce plugin to 7.3.0 version gave following error

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

Looks like woocommerce_downloadable_product_permissions table is missing from the database.

Solution

For me the problem was that table prefix wp_asffafsadfsadf_sadfadsfads_ was making wp_asffafsadfsadf_sadfadsfads_ woocommerce_downloadable_product_permissions table name length more than 64 which MySQL doesn’t allow.

I’ve to change prefix from wp_asffafsadfsadf_sadfadsfads_ to wp_ to make this error go away.

Comments