On upgrading from 2.2 to 2.3, I got the following error:

The following updates returned messages
mailchimp_lists module
Update #7200
Failed: DatabaseSchemaObjectExistsException: Cannot add field mailchimp_lists.name: field already exists. in DatabaseSchema_mysql->addField() (line 323 of /var/www/drupal-7.10/includes/database/mysql/schema.inc).

Not sure what I should do now?

CommentFileSizeAuthor
#4 mailchimp-log.png56.05 KBemmajane

Comments

emmajane’s picture

emmajane commented

I assume that the problem is that the field isn't getting dropped as part of the update?

// drop the name field in case it was created in the original bunk 7200 update
db_drop_field('mailchimp_lists', 'name');

emmajane’s picture

emmajane commented

I tried uninstalling the module completely and reinstalling it, and now I'm getting the error:

Unable to connect webhooks: Setting up multiple WebHooks for one URL is not allowed.

levelos’s picture

levelos commented
Status: Active » Closed (duplicate)

@emmajane, the first part of your issue is a dup of #1358416: Entity load and save operations in hook_update_N cause update failures and should be all set. I'll roll a 2.4 release shortly. The webhooks error is not one I've seen before and happy to explore that in a separate issue. Do you mind opening a new issue and adding a few more details re: the web hooks? It's possible MailChimp changed their webhook API only allowing one URL per hook, in which case we'd need to include the list name in the md5 hash for each hook.

emmajane’s picture

emmajane commented
StatusFileSize
new mailchimp-log.png56.05 KB

I don't have the error any more (I created a new key and it's a live site so I don't have capacity to test) and it seems as though things are syncing correctly. I'll open a new issue if it reoccurs.