When I have more than 1 required maillist I get an error on creating a new user account:

User warning: Duplicate entry '11628' for key 'PRIMARY' query: INSERT INTO mailchimp_user (uid, status) VALUES (11628, 'pending') in _db_query() (line 141 of /var/www/Drupal6/includes/database.mysql.inc).

This appears to be triggered by the code in mailchimp_user() that loops through all required lists on insert. Basically it's attempting to set the status as "pending" on the account for each required list. However, on insert this means it attempts to do an insert each time too, which obviously doesn't work. The attached patch should fix the issue.

CommentFileSizeAuthor
#1 mailchimp-1337272.patch1.04 KBhadsie
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

hadsie’s picture

FileSize
1.04 KB
nrackleff’s picture

Issue summary: View changes
Status: Needs review » 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!”