Update 7202 (Convert block deltas from ID numbers to machine names) throwing errors [#1700662]

Comment	File	Size	Author
#17	mailchimp-blockdeltaupdate-1700662-17.patch	2.14 KB	lsolesen
#9	mailchimp-blockdeltaupdate-1700662-9.patch	2.16 KB	antipex

Comment #1

FrancescoUK commented 26 July 2012 at 12:12

Same problem here, while updating I've got:

The following updates returned messages

mailchimp_lists module

Update #7202
Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bartik-mailchimp_lists-customers' for key 'tmd': UPDATE {block} SET delta=:db_update_placeholder_0 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => customers [:db_condition_placeholder_0] => 190 ) in mailchimp_lists_update_7202() (line 250 of /<...>/sites/all/modules/mailchimp/modules/mailchimp_lists/mailchimp_lists.install).

Log in or register to post comments

Comment #2

rickmanelius commented 26 July 2012 at 17:10

The issue I'm having is that there two row records where the only difference is one has a delta of 1 and the other has the delta of the machine name.

The way we could get around this is to simply query to see if that machine name already exists... and delete instead of update.

Your mileage may vary as the numeric delta block was listed as being set in node/309, but I didn't have a block set there, so I'm unclear as to what happened there!

Log in or register to post comments

Comment #3

antipex commented 26 July 2012 at 20:03

Status:

Active

» Fixed

Committed a fix for this.

Log in or register to post comments

Comment #4

Stanto commented 27 July 2012 at 01:16

Just a heads up, even with the latest version, I still have the same issue.

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'delta' cannot be null: UPDATE {block} SET delta=:db_update_placeholder_0 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_condition_placeholder_0] => 644 ) in mailchimp_lists_update_7202() (line 270 of /docroot/sites/all/modules/mailchimp/modules/mailchimp_lists/mailchimp_lists.install).

You can see that now the error is on line 270 and not 250, so it's the latest version available in git / dev.

Log in or register to post comments

Comment #5

FrancescoUK commented 27 July 2012 at 09:31

Thank you all for the valuable feedback.

May I ask you (if possible of course) to post a patch as this issue is popping up everytime I need to upgrade a module :-(

Log in or register to post comments

Comment #6

Ndesign commented 30 July 2012 at 18:37

Status:

Fixed

» Needs work

where is the committed fix for this

Log in or register to post comments

Comment #7

essbee commented 2 August 2012 at 00:15

Yep also getting the error in #4

Log in or register to post comments

Comment #8

Pheonix25 commented 2 August 2012 at 10:46

QUICK FIX:
Go in to the 'block' table, & find the mailchimp_list entries:
SELECT * FROM `block` WHERE module = 'mailchimp_lists'

There should be two "bunches", one with numerical values, and one with named values (for each enabled theme) like the below:

bid - module - delta

XXX - mailchimp_lists - 1
XXX - mailchimp_lists - 2
XXX - mailchimp_lists - list1
XXX - mailchimp_lists - list2

CONFIRM that the rest of the values (except for the deltas) are identical.

DELETE the rows that contain named deltas (in my example above, #'s 3 & 4)

Then, run 'drush updatedb' and the numerical delta values should be updated to the list names (i.e.: delta '1' should change to 'list1' in my example above)

** Works on my machine, no liability when you run this in your prod environment, etc. etc. **

Log in or register to post comments

Comment #9

antipex commented 2 August 2012 at 18:32

Status:

Needs work

» Needs review

Status	File	Size
new	mailchimp-blockdeltaupdate-1700662-9.patch	2.16 KB

Attached is a patch to potentially fix this. I've added a check to see if list results are returned before running the updates, so this appears to solve the issue of a null delta column.