Title: wp_mailchimp_carts WordPress database error
Last modified: November 5, 2020

---

# wp_mailchimp_carts WordPress database error

 *  Resolved [CarolineElisa](https://wordpress.org/support/users/carolineelisa/)
 * (@carolineelisa)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/)
 * Assume the following is from your plugin?:
 * `WordPress database error Duplicate entry 'xxx@aol.com' for key 'PRIMARY' for
   query INSERT INTO`wp_mailchimp_carts`(`id`,`email`,`user_id`,`cart`,`created_at`)
   VALUES ('ae942f4d88de1a0f1f1ed18b46d659d0', 'xxx@aol.com', 0, 'a:4:{s:32:\"6e970b97dba7d33215f0d2f07a929f6e\";
   a:11:{s:3:\"key\";s:32:\"6e970b97dba7d33215f0d2f07a929f6e\";s:10:\"product_id\";
   i:9580;s:12:\"variation_id\";i:9583;s:9:\"variation\";a:2:{s:19:\"attribute_pa_colour\";
   s:5:\"cream\";s:17:\"attribute_pa_size\";s:2:\"10\";}s:8:\"quantity\";i:1;s:9:\"
   data_hash\";s:32:\"171e7b04bb27dd437491b94adf584d82\";s:13:\"line_tax_data\";
   a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:39;
   s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:39;s:8:\"line_tax\";i:0;}
   s:32:\"a676821d081b1b5022b37b3a1067652f\";a:11:{s:3:\"key\";s:32:\"a676821d081b1b5022b37b3a1067652f\";
   s:10:\"product_id\";i:15448;s:12:\"variation_id\";i:15451;s:9:\"variation\";a:
   2:{s:19:\"attribute_pa_colour\";s:5:\"cream\";s:17:\"attribute_pa_size\";s:2:\"
   10\";}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"171e7b04bb27dd437491b94adf584d82\";
   s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"
   line_subtotal\";d:45;s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:45;
   s:8:\"line_tax\";i:0;}s:32:\"0863a119f33bd689f124b46beb977881\";a:11:{s:3:\"key\";
   s:32:\"0863a119f33bd689f124b46beb977881\";s:10:\"product_id\";i:23662;s:12:\"
   variation_id\";i:23676;s:9:\"variation\";a:2:{s:19:\"attribute_pa_colour\";s:
   10:\"solid-navy\";s:17:\"attribute_pa_size\";s:2:\"10\";}s:8:\"quantity\";i:1;
   s:9:\"data_hash\";s:32:\"16b3b8ca5332be9b0641a6ceac5618fc\";s:13:\"line_tax_data\";
   a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:29;
   s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:29;s:8:\"line_tax\";i:0;}
   s:32:\"6f3ecbf31a59781cc2ca9ef70fbaea70\";a:11:{s:3:\"key\";s:32:\"6f3ecbf31a59781cc2ca9ef70fbaea70\";
   s:10:\"product_id\";i:3133;s:12:\"variation_id\";i:24946;s:9:\"variation\";a:
   2:{s:19:\"attribute_pa_colour\";s:10:\"solid-navy\";s:17:\"attribute_pa_size\";
   s:2:\"10\";}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"16b3b8ca5332be9b0641a6ceac5618fc\";
   s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"
   line_subtotal\";d:39;s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:39;
   s:8:\"line_tax\";i:0;}}', '2020-11-05 18:32:03') made by do_action('wp_ajax_nopriv_mailchimp_set_user_by_email'),
   WP_Hook->do_action, WP_Hook->apply_filters, MailChimp_Service->set_user_by_email,
   MailChimp_Service->handleCartUpdated, MailChimp_Service->trackCart`

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

 *  Plugin Author [ryanhungate](https://wordpress.org/support/users/ryanhungate/)
 * (@ryanhungate)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/#post-13756000)
 * [@carolineelisa](https://wordpress.org/support/users/carolineelisa/) yes this
   is something we’re doing to keep track of your abandoned carts for “creating 
   the cart” again when they click the Abandoned Cart Automations. Are you saying
   that this is happening a lot or is it just sometimes?
 *  Thread Starter [CarolineElisa](https://wordpress.org/support/users/carolineelisa/)
 * (@carolineelisa)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/#post-13765252)
 * We have a lot of these in our debug log
 *  [siwhyatt](https://wordpress.org/support/users/siwhyatt/)
 * (@siwhyatt)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/#post-13987454)
 * I’m also getting these errors.
 * I see here in this github it’s been going on for some time: [https://github.com/mailchimp/mc-woocommerce/issues/438](https://github.com/mailchimp/mc-woocommerce/issues/438)
 * Are there plans to resolve it any time soon?
 *  Plugin Author [ryanhungate](https://wordpress.org/support/users/ryanhungate/)
 * (@ryanhungate)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/#post-14021990)
 * [@siwhyatt](https://wordpress.org/support/users/siwhyatt/) [@carolineelisa](https://wordpress.org/support/users/carolineelisa/)
   we are putting this in the current dev cycle of 2.5.1. Stay tuned 🙂
 *  Plugin Support [khungate](https://wordpress.org/support/users/khungate/)
 * (@khungate)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/#post-14191713)
 * Hi [@siwhyatt](https://wordpress.org/support/users/siwhyatt/) [@carolineelisa](https://wordpress.org/support/users/carolineelisa/)
   this should be resolved in the latest version of the plugin released today (v2.5.1).
   Thanks again for reporting, let us know if there’s anything else we can do.

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

The topic ‘wp_mailchimp_carts WordPress database error’ is closed to new replies.

 * ![](https://ps.w.org/mailchimp-for-woocommerce/assets/icon-256x256.png?rev=1509501)
 * [Mailchimp for WooCommerce](https://wordpress.org/plugins/mailchimp-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mailchimp-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mailchimp-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/mailchimp-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mailchimp-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mailchimp-for-woocommerce/reviews/)

 * 5 replies
 * 4 participants
 * Last reply from: [khungate](https://wordpress.org/support/users/khungate/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/wp_mailchimp_carts-wordpress-database-error/#post-14191713)
 * Status: resolved