From 347442aa12556fa5e8591fef8db84966db78f491 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Wed, 24 Jun 2020 10:06:57 +0000 Subject: [PATCH] Bug 25858: Don't attempt to set flag if already set --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 4b9bab7b3f..3d24651c65 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -20650,7 +20650,7 @@ if( CheckVersion( $DBversion ) ) { }); $dbh->do(q{ - UPDATE borrowers SET flags = flags + (1<<12) WHERE flags & (1 << 11) + UPDATE borrowers SET flags = flags + (1<<12) WHERE flags & (1 << 11) AND !(flags & (1 << 12)) }); NewVersion( $DBversion, 22868, 'Move suggestions_manage subpermission out of acquisition permission' ); -- 2.11.0