MySQL error “Foreign key constraint is incorrectly formed” 3.6.2 update intext:”

  • Resolved weblv

    (@weblv)


    5 years, 10 months ago

    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 TABLE wp_wc_download_log
    ADD CONSTRAINT fk_wp_wc_download_log_permission_id FOREIGN KEY (permission_id)
    REFERENCES wp_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_tables

    This is hosted on a LAMP stack with:
    PHP 7.2.17
    10.2.23-MariaDB-cll-lve

    • This topic was modified 5 years, 10 months ago by weblv.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL error “Foreign key constraint is incorrectly formed” 3.6.2 update intext:”’ is closed to new replies.