From cc1e25ec535fe938fd769e795f4a30b424b7539e Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Mon, 26 Nov 2018 13:08:05 +0000 Subject: [PATCH] Bug 21869: Fix incorrect value setting in DB update To test: 1 - Set some value for MarkLostAsReturned syspref 2 - Set your db version to 17.12.00.035 (or load an older db) 3 - updatedatabase 4 - Note your values are lost and db is incorrectly set 5 - Apply patch 6 - Reset values 7 - Reset DB version 8 - Run updatedatabase 9 - Original values are retained --- 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 16ff15528e..3104d1621b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -15923,7 +15923,7 @@ if( CheckVersion( $DBversion ) ) { INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('UpdateItemWhenLostFromHoldList','',NULL,'This is a list of values to update an item when it is marked as lost from the holds to pull screen','Free'); } ); $dbh->do( q{ - UPDATE systempreferences SET options="batchmod|moredetail|cronjob|additem|pendingreserves", value="batchmod|moredetail|cronjob|additem|pendingreserves" WHERE variable="MarkLostItemsAsReturned"; + UPDATE systempreferences SET options="batchmod|moredetail|cronjob|additem|pendingreserves" WHERE variable="MarkLostItemsAsReturned"; } ); SetVersion( $DBversion ); -- 2.11.0