Reporting on behalf of a customer:

After trying to update the module to 7.x-1.1, update.php returns:

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '26-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) AND (rid = :db_condition_placeholder_2) ; Array ( [:db_update_placeholder_0] => purge on-screen [:db_condition_placeholder_0] => purge notification [:db_condition_placeholder_1] => acquia_purge [:db_condition_placeholder_2] => 26 ) in acquia_purge_update_7103() (line 153 of /mnt/gfs/lafddev/livedev/docroot/sites/all/modules/contrib/acquia_purge/acquia_purge.install).
CommentFileSizeAuthor
#2 2498329.patch2.29 KBnielsvm

Comments

nielsvm’s picture

nielsvm commented

For increased readability, this is the real query:

UPDATE {role_permission}
SET permission='purge on-screen'
WHERE (permission = 'purge notification') AND (module = acquia_purge) AND (rid = 26) ;

This originates from acquia_purge_update_7103().

nielsvm’s picture

nielsvm commented
StatusFileSize
new 2498329.patch2.29 KB
nielsvm’s picture

nielsvm commented
Status: Active » Closed (fixed) 
[7.x-1.x cab74c6] Issue #2498329 by nielsvm, Waliur: Acquia_purge update error
 Author: nielsvm <nielsvm@163285.no-reply.drupal.org>
 1 file changed, 24 insertions(+), 19 deletions(-)

This fix lands in 7.x-1.2.