Title: SQL Error on update
Last modified: May 24, 2018

---

# SQL Error on update

 *  Resolved [Juergen Schulze](https://wordpress.org/support/users/1manfactory/)
 * (@1manfactory)
 * [8 years ago](https://wordpress.org/support/topic/sql-error-on-update/)
 * 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_1`FOREIGN KEY (`permission_id`) REFERENCES`
   > wp_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
    -  This topic was modified 8 years ago by [Juergen Schulze](https://wordpress.org/support/users/1manfactory/).
    -  This topic was modified 8 years ago by [Juergen Schulze](https://wordpress.org/support/users/1manfactory/).

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [Hannah S.L.](https://wordpress.org/support/users/fernashes/)
 * (@fernashes)
 * Automattic Happiness Engineer
 * [8 years ago](https://wordpress.org/support/topic/sql-error-on-update/#post-10316905)
 * 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?
 *  Thread Starter [Juergen Schulze](https://wordpress.org/support/users/1manfactory/)
 * (@1manfactory)
 * [8 years ago](https://wordpress.org/support/topic/sql-error-on-update/#post-10317184)
 * 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.L.](https://wordpress.org/support/users/fernashes/)
 * (@fernashes)
 * Automattic Happiness Engineer
 * [8 years ago](https://wordpress.org/support/topic/sql-error-on-update/#post-10318205)
 * 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.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Hannah S.L.](https://wordpress.org/support/users/fernashes/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/sql-error-on-update/#post-10318205)
 * Status: resolved