From 175dfee55fc2990808ca082d42a13b8c3b1ed742 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Fri, 23 Jan 2026 14:00:56 -0500 Subject: [PATCH] Bug 41701: Fix definition of OAI-PMH:DeletedRecord preference in sysprefs.sql This patch updates the definition of the OAI-PMH:DeletedRecord preference in sysprefs.sql, correcting the switched options and explanation columns. To test, apply the patch and run updatedatabase. Check that the database has been updated correctly: SELECT `options`, `explanation` FROM `systempreferences` WHERE `variable` = 'OAI-PMH:DeletedRecord'; Sponsored-by: Athens County Public Libraries --- installer/data/mysql/atomicupdate/bug_41701.pl | 13 +++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 2 +- 2 files changed, 14 insertions(+), 1 deletion(-) create mode 100755 installer/data/mysql/atomicupdate/bug_41701.pl diff --git a/installer/data/mysql/atomicupdate/bug_41701.pl b/installer/data/mysql/atomicupdate/bug_41701.pl new file mode 100755 index 00000000000..ccd824069a3 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_41701.pl @@ -0,0 +1,13 @@ +use Modern::Perl; + +return { + bug_number => "41701", + description => "Fix values of OAI-PMH:DeletedRecord options and explanation columns", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + $dbh->do( + q{UPDATE systempreferences SET options = 'transient|persistent|no', explanation = 'Koha\'s deletedbiblio table will never be deleted (persistent), might be deleted (transient), or will never have any data in it (no)' WHERE variable = 'OAI-PMH:DeletedRecord'} + ); + }, + } diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index d1a15e58d3c..b876b535892 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -470,7 +470,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('OAI-PMH:AutoUpdateSets','0',NULL,'Automatically update OAI sets when a bibliographic or item record is created or updated','YesNo'), ('OAI-PMH:AutoUpdateSetsEmbedItemData', '0', NULL, 'Embed item information when automatically updating OAI sets. Requires OAI-PMH:AutoUpdateSets syspref to be enabled', 'YesNo'), ('OAI-PMH:ConfFile','',NULL,'If empty, Koha OAI Server operates in normal mode, otherwise it operates in extended mode.','File'), -('OAI-PMH:DeletedRecord','persistent','Koha\'s deletedbiblio table will never be deleted (persistent), might be deleted (transient), or will never have any data in it (no)','transient|persistent|no','Choice'), +('OAI-PMH:DeletedRecord','persistent','transient|persistent|no','Koha\'s deletedbiblio table will never be deleted (persistent), might be deleted (transient), or will never have any data in it (no)','Choice'), ('OAI-PMH:HarvestEmailReport','',NULL,'After an OAI-PMH harvest, send a report email to the email address','Free'), ('OAI-PMH:MaxCount','50',NULL,'OAI-PMH maximum number of records by answer to ListRecords and ListIdentifiers queries','Integer'), ('OnSiteCheckoutAutoCheck','0',NULL,'Enable/Do not enable onsite checkout by default if last checkout was an onsite checkout','YesNo'), -- 2.39.5