From 9d4bc60ea5ff07fd7e1f896964b043d38ff869c2 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 16 Jul 2020 16:23:07 +1200 Subject: [PATCH] Bug 25858: Don't attempt to set flag if already set Signed-off-by: Aleisha Amohia (cherry picked from commit 6d6132777bc1dfd35e990ac469799ece679e4899) Signed-off-by: Victor Grousset/tuxayo --- 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 415c68d284..10acce20d9 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -18960,7 +18960,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)) }); SetVersion( $DBversion ); -- 2.20.1