Hi,

Using the latest version of D6 and Mailchimp 6.26 . When a new user registers with the website i am getting the following error:

user warning: Duplicate entry 'xxx' for key 'PRIMARY' query: INSERT INTO mailchimp_user (uid, status) VALUES (xxx, 'pending') in /var/www/sites/all/modules/mailchimp/mailchimp.module on line 116.

This has only just started happening. There are approximately 6700 users in total.

Here is the relevant code:

// They don't *really* need to go in the queue unless they just changed their prefs.
if ($op == 'insert') {
db_query("INSERT INTO {mailchimp_user} (uid, status) VALUES (%d, '%s')", $account->uid, MAILCHIMP_USERSTATUS_PENDING);
}
else {
db_query("UPDATE {mailchimp_user} SET status = '%s' WHERE uid = %d", MAILCHIMP_USERSTATUS_PENDING, $account->uid);
}

Can anyone help please ...

Thanks

Comments

yesct’s picture

yesct commented

I get this also.
My version of php is 5.3.27
what is yours?

I did the normal things like clear the cache, and look at the table. doesn't seem to be any bad rows of data in the table.

to help the google and people googling find this, here is the error message I get:
user warning: Duplicate entry '425' for key 'PRIMARY' query: INSERT INTO mailchimp_user (uid, status) VALUES (425, 'pending') in /foo/sites/all/modules/mailchimp/mailchimp.module on line 116.

What should I do next?

Is there any additional info I can provide that might help?

nrackleff’s picture

nrackleff commented
Issue summary: View changes
Status: Active » Closed (won't fix)

“And now our watch [for support of the 6.x version of the MailChimp module] has ended…” With the end of Drupal 6 support, I’m sad to say we too must turn the page.

Fret not! The 7.x-4.x and 8.x versions come highly recommended. Both are using Mailchimp’s new API 3.0 and are being actively maintained. “What is dead may never die, but rises again, harder and stronger!”