Duplicate Database Entry Error

  • Resolved nikstern007

    (@nikstern007)


    2 years, 10 months ago

    We are constantly getting similar errors like the one below in our logs. It is not from any conflict, as nothing else writes data to that table. Can you help us figure out what’s causing that?

    WordPress database error Duplicate entry '[email protected]' for key 'PRIMARY' for query INSERT INTOwp_mailchimp_carts(id,email,user_id,cart,created_at) VALUES ('e3d3b5b5427992ac63495d3135b3afd5', '[email protected]', 0, 'a:1:{s:32:\"ce1e85581146429283d851aa551bc2cb\";a:14:{s:6:\"addons\";a:0:{}s:3:\"key\";s:32:\"ce1e85581146429283d851aa551bc2cb\";s:10:\"product_id\";i:677331;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";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:18:\"available_quantity\";i:1;s:18:\"has_special_offers\";b:0;}}', '2022-04-26 10:33:27') 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

    Thanks,
    Nik

    • This topic was modified 2 years, 10 months ago by nikstern007.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author ryanhungate

    (@ryanhungate)

    @nikstern007 we’re adding some tweaks to this so the errors shouldn’t be reported in the next version of the plugin. It’s going through final QA right now and the change is here.

    We will keep this ticket open until it’s pushed up to get feedback.

    Plugin Author ryanhungate

    (@ryanhungate)

    @nikstern007 we’ve pushed out a tweak version 2.7 which should address this issue. We’re going to be doing smaller follow ups here shortly but this particular release should resolve that problem you were seeing. Please let us know if it’s still popping up after upgrade.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Duplicate Database Entry Error’ is closed to new replies.