MySQL error “Foreign key constraint is incorrectly formed” 3.6.2 update intext:”
-
In our staging server while testing the update to WooCommerce 3.6 we got the following error on debug.log:
Can’t create table
name_witheld
.wp_wc_download_log
(errno: 150 “Foreign key constraint is incorrectly formed”) on query ALTER TABLEwp_wc_download_log
ADD CONSTRAINTfk_wp_wc_download_log_permission_id
FOREIGN KEY (permission_id
)
REFERENCESwp_woocommerce_downloadable_product_permissions
(permission_id
) ON DELETE CASCADE; require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::check_version, WC_Install::install, WC_Install::create_tablesThis is hosted on a LAMP stack with:
PHP 7.2.17
10.2.23-MariaDB-cll-lve
- The topic ‘MySQL error “Foreign key constraint is incorrectly formed” 3.6.2 update intext:”’ is closed to new replies.