Problem with woocommerce creating wp_wc_download_log

[stefanos82]

In my WooCommerce status, I get the following message:

Missing base tables: peiramasqlitewp_wc_download_log. Some WooCommerce functionality may not work as expected.

As you can see I see a custom prefix and I don't know whether it plays role or not.

Here's the actual schema for the missing table:

CREATE TABLE `wp_wc_download_log` (
  `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`download_log_id`),
  KEY `permission_id` (`permission_id`),
  KEY `timestamp` (`timestamp`),
  CONSTRAINT `fk_wp_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `wp_woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

What could possibly causing the problem from creating the table?

[aaemnnosttv]

I also don't see it, but it looks like all others are there?

⚡  wp db tables      
wp_woocommerce_tax_rates
wp_woocommerce_tax_rate_locations
wp_woocommerce_shipping_zones
wp_woocommerce_shipping_zone_methods
wp_woocommerce_shipping_zone_locations
wp_woocommerce_sessions
wp_woocommerce_payment_tokens
wp_woocommerce_payment_tokenmeta
wp_woocommerce_order_items
wp_woocommerce_order_itemmeta
wp_woocommerce_log
wp_woocommerce_downloadable_product_permissions
wp_woocommerce_attribute_taxonomies
wp_woocommerce_api_keys
wp_wc_webhooks
wp_wc_tax_rate_classes
wp_wc_reserved_stock
wp_wc_product_meta_lookup
wp_wc_order_tax_lookup
wp_wc_order_stats
wp_wc_order_product_lookup
wp_wc_order_coupon_lookup
wp_wc_customer_lookup
wp_wc_category_lookup
wp_wc_admin_notes
wp_wc_admin_note_actions
wp_users
wp_usermeta
wp_terms
wp_termmeta
wp_term_taxonomy
wp_term_relationships
wp_posts
wp_postmeta
wp_options
wp_links
wp_comments
wp_commentmeta
wp_actionscheduler_logs
wp_actionscheduler_groups
wp_actionscheduler_claims
wp_actionscheduler_actions
sqlite_sequence

[stefanos82]

I will double-check it tomorrow when I will have more time (it's quite late here) and I will let you know.

[stefanos82]

Quick update: yes, other WC tables are there.

[aaemnnosttv]

Following up here – is this still an issue with the latest version?

[stefanos82]

I have no idea, because I switched the specific project back to MySQL.

What is the appropriate way to setup SQLite with an existing project? It seems there's no obvious way to do such thing.