@@ -, +, @@ --- installer/data/mysql/db_revs/211200016.pl | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) --- a/installer/data/mysql/db_revs/211200016.pl +++ a/installer/data/mysql/db_revs/211200016.pl @@ -11,10 +11,14 @@ return { primary_key_exists( 'user_permissions', 'module_bit' ) && primary_key_exists( 'user_permissions', 'code') ){ - $dbh->do(q{ - ALTER TABLE user_permissions DROP INDEX IF EXISTS `PRIMARY` - }); - say $out "Dropped any previously created primary key"; + eval { + local $dbh->{PrintError} = 0; + local $dbh->{RaiseError} = 0; + $dbh->do(q{ + ALTER TABLE user_permissions DROP PRIMARY KEY + }); + say $out "Dropped any previously created primary key"; + }; $dbh->do(q{ALTER TABLE user_permissions ADD COLUMN temp SERIAL PRIMARY KEY}); $dbh->do(q{DELETE t1 FROM user_permissions t1 INNER JOIN user_permissions t2 WHERE t1.temp < t2.temp AND t1.borrowernumber = t2.borrowernumber AND t1.module_bit = t2.module_bit AND t1.code = t2.code}); --