Support » Plugin: WooCommerce » SQL Error on update

  • Resolved Juergen Schulze

    (@1manfactory)


    Just found in my debug log:

    Cannot add or update a child row: a foreign key constraint fails (np.#sql-311_20, CONSTRAINT#sql-311_20_ibfk_1FOREIGN KEY (permission_id) REFERENCESwp_woocommerce_downloadable_product_permissions(permission_id) ON DELETE CASCADE) für Abfrage ALTER TABLE wp_wc_download_log ADD FOREIGN KEY (permission_id) REFERENCES wp_woocommerce_downloadable_product_permissions(permission_id) ON DELETE CASCADE von require(‘wp-blog-header.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, QM_DB->query

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there!

    I checked my own log and didn’t see a similar error. Is this an error that’s continually happening, or just happened once?

    Seems only to happen after update and BEFORE you accept to update woocommerce database to new version.
    but I am not 100% sure.

    Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Okay, so is everything working okay now?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL Error on update’ is closed to new replies.