Upgraded Acquia Purge to 7.x-1.0 and ran update.php immediately as per the release notes. Got this issue after the DB updates ran:

The following updates returned messages
acquia_purge module
Update #7103

    Failed: PDOException : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3-purge on-screen' for key 'PRIMARY': UPDATE {role_permission} SET permission=:db_update_placeholder_0 WHERE (permission = :db_condition_placeholder_0) AND (module = :db_condition_placeholder_1) ; Array ( [:db_update_placeholder_0] => purge on-screen [:db_condition_placeholder_0] => purge notification [:db_condition_placeholder_1] => acquia_purge ) in acquia_purge_update_7103() (line 142 in /mnt/www/html/SITENAME/docroot/sites/all/modules/contrib/acquia_purge/acquia_purge.install).

From:

7103 - Rename the 'purge notification' permission into 'purge on-screen'. Since version 7.x-1.0, this permission got renamed as its name became too specific. Before it only reflected on the on-screen purging progress bar but is now also used for permission to the manual purge form blocks.

I could replicate this issue on 2 different sites. Note that the renaming seems to have applied, still:

Acquia Purge
Purge on-screen
Process purges visually using a progress bar and grant access to the editorial manual purge blocks.
CommentFileSizeAuthor
#2 2334285.patch1.83 KBnielsvm

Comments

nielsvm’s picture

nielsvm commented
Priority: Major » Critical
nielsvm’s picture

nielsvm commented
StatusFileSize
new 2334285.patch1.83 KB

Okay, let's test this anavarre.

$ cd /sites/all/modules/acquia_purge
$ patch -p1 < 2334285.patch
$ drush updb --yes (or just update.php)
nielsvm’s picture

nielsvm commented
Status: Active » Reviewed & tested by the community 
[10:31:20] <anavarre> Updates were attempted. If you see no failures below, you may proceed happily back to your .... Otherwise, you may need to update your database manually. All errors have been logged.Front page.. Administration pages
[10:31:23] <anavarre> on both sites
[10:31:24] <anavarre> win
[10:31:25] <anavarre> :)
nielsvm’s picture

nielsvm commented
Status: Reviewed & tested by the community » Fixed 
[7.x-1.x eb093e1] Issue #2334285 by nielsvm | anavarre: Fixed Update #7103 failed with a PDO exception.
 1 file changed, 29 insertions(+), 11 deletions(-

  • nielsvm committed eb093e1 on 7.x-1.x 
    Issue #2334285 by nielsvm | anavarre: Fixed Update #7103 failed with a...

Status: Fixed » Closed (fixed)

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