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.

CommentFileSizeAuthor
#2 panopoly-update_7102-2357515-1.patch1.06 KBdsnopek

Comments

dsnopek’s picture

Title: Upgrade to 7.x-1.12 throws an error » panopoly_update_7102() breaks if 'help' block is already placed in a region

I updated the title to describe the problem more specifically. I'll start working on a fix!

Thanks for posting this issue!

dsnopek’s picture

Status: Active » Needs review
StatusFileSize
new1.06 KB

Here's a patch that works in my testing. I'll commit it soon!

  • dsnopek committed 50fce7b on 7.x-1.x
    Issue #2357515 by dsnopek | Steve Hanson: Fixed panopoly_update_7102()...
dsnopek’s picture

Status: Needs review » Fixed
Related issues: +#2020715: Help Region?

Committed! And added relation to the issues that this code comes from originally: #2020715: Help Region?

dobie_gillis’s picture

Excellent! I just upgraded to panopoly-dev from 7.x-1.12 and I'm no longer getting this SQL error.

dsnopek’s picture

FYI, I'm going to make a Panopoly 1.13 release for this fix tomorrow.

dsnopek’s picture

Title: panopoly_update_7102() breaks if 'help' block is already placed in a region » panopoly_update_7102() breaks if block module is already enabled

It appears this causes problems if the block module is already enabled, even if the 'help' block isn't placed! Updated title to reflect this.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.