Upgrade on my site throws an error in update 7102 -
Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'tcdpv7at2-system-help' for key 'tmd': INSERT INTO {block} (module, delta, theme, status, weight, region, pages, cache) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15); Array ( [:db_insert_placeholder_0] => system [:db_insert_placeholder_1] => help [:db_insert_placeholder_2] => tcdpv7at2 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => help [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => -1 [:db_insert_placeholder_8] => system [:db_insert_placeholder_9] => help [:db_insert_placeholder_10] => adaptivetheme_admin [:db_insert_placeholder_11] => 1 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => help [:db_insert_placeholder_14] => [:db_insert_placeholder_15] => -1 ) in _panopoly_install_help_block() (line 69 of /home/dev7/public_html/profiles/panopoly/panopoly.install).
tcpdv7at2 is the default theme on the site, and already has the help block enabled.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | panopoly-update_7102-2357515-1.patch | 1.06 KB | dsnopek |
Comments
Comment #1
dsnopekI updated the title to describe the problem more specifically. I'll start working on a fix!
Thanks for posting this issue!
Comment #2
dsnopekHere's a patch that works in my testing. I'll commit it soon!
Comment #4
dsnopekCommitted! And added relation to the issues that this code comes from originally: #2020715: Help Region?
Comment #5
dobie_gillis commentedExcellent! I just upgraded to panopoly-dev from 7.x-1.12 and I'm no longer getting this SQL error.
Comment #6
dsnopekFYI, I'm going to make a Panopoly 1.13 release for this fix tomorrow.
Comment #7
dsnopekIt appears this causes problems if the block module is already enabled, even if the 'help' block isn't placed! Updated title to reflect this.