From 755396e2e59c28fc4194ba3d44082cac4a3f915b Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 9 Feb 2026 16:58:09 +0100 Subject: [PATCH] Bug 41800: Fix syspref explanations There are discrepancies between new an upgraded installations Test plan: 0. Do not apply these patches, use main 1. Add my misc4dev gitlab repo and checkout the branch linked to issue 101 https://gitlab.com/koha-community/koha-misc4dev/-/issues/101 2. Run `perl /kohadevbox/misc4dev/run_tests.pl --run-all-tests` => It should crash when running check_sysprefs.t (BEFORE the prove all perl tests command) 3. Apply these patches, repeat 2. Tests from the prove all perl tests command should run (no need to wait for them to finish) --- .../data/mysql/atomicupdate/bug_41800.pl | 177 +++++++++++++++++- installer/data/mysql/db_revs/220600028.pl | 2 +- installer/data/mysql/db_revs/220600079.pl | 6 +- installer/data/mysql/mandatory/sysprefs.sql | 40 ++-- 4 files changed, 200 insertions(+), 25 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_41800.pl b/installer/data/mysql/atomicupdate/bug_41800.pl index 76397b40f7f..341ee1983ce 100755 --- a/installer/data/mysql/atomicupdate/bug_41800.pl +++ b/installer/data/mysql/atomicupdate/bug_41800.pl @@ -48,7 +48,109 @@ return { WHERE explanation LIKE '%.'; } ); - my $new_explanations = {}; + my $new_explanations = { + AcquisitionLog => q{If enabled, log acquisitions activity}, + AdditionalContentLog => q{If enabled, log additional content changes}, + + #27936 + AllowItemsOnHoldCheckoutSIP => + q{Do not generate RESERVED warning when checking out items reserved to someone else via SIP. This allows self checkouts for those items}, + AmazonCoverImages => q{Display Cover Images in staff interface from Amazon Web Services}, + AnonymousPatron => + q{Set the identifier (borrowernumber) of the anonymous patron. Used for suggestion and checkout history privacy}, + ArticleRequestsOpacHostRedirection => + q{Enables redirection from child to host when requesting articles on the Opac}, + autoControlNumber => + q{Used to autogenerate a Control Number: biblionumber will be as biblionumber, OFF will leave the field as it is}, + AutomaticCheckinAutoFill => q{Automatically fill the next hold with an automatic check in cronjob}, + BiblioItemtypeInfo => q{Control which itemtype info displays for biblio level itemtypes}, + BrowseResultSelection => + q{Enable/Disable browsing search results fromt the bibliographic record detail page in staff interface}, + CheckPrevCheckoutDelay => + q{Maximum number of days that will trigger a warning if the patron has borrowed that item in the past when CheckPrevCheckout is enabled}, + CirculateILL => q{If enabled, it is possible to circulate ILL items from within ILL}, + CustomCoverImages => + q{If enabled, the custom cover images will be displayed in the staff interface. CustomCoverImagesURL must be defined}, + DefaultAuthorityTab => q{Default tab to show when displaying authorities}, + DefaultHoldExpirationdate => q{Automatically set default expiration date for holds}, + DefaultPatronSearchFields => + q{Pipe separated list defining the default fields to be used during a patron search using the "standard" option. If empty Koha will default to "firstname|surname|othernames|cardnumber|userid". Additional fields added to this preference will be added as search options in the dropdown menu on the patron search page}, + Display856uAsImage => + q{Display the URI in the 856u field as an image, the corresponding staff interface XSLT option must be on}, + EnableItemGroupHolds => q{Enable item group holds feature}, + ERMModule => q{Enable the e-resource management module}, + ERMProviderEbscoApiKey => q{API key for EBSCO}, + ERMProviderEbscoCustomerID => q{Customer ID for EBSCO}, + ERMProviders => q{Set the providers for the ERM module}, + ExpireReservesAutoFillEmail => + q{Send email notification of hold filled from automatically expired/cancelled hold to this address. If not defined, Koha will fallback to the library reply-to address}, + finesMode => + q{Choose the fines mode, 'off' (no charges), 'production' (accrue overdue fines). Requires accruefines cronjob}, + HoldsSplitQueue => q{In the staff interface, split the holds view by the given criteria}, + ILLPartnerCode => q{Patrons from this patron category will be used as partners to place ILL requests with}, + IntranetCoce => q{If on, enables cover retrieval from the configured Coce server in the staff interface}, + intranetcolorstylesheet => q{Define the color stylesheet to use in the staff interface}, + IntranetFavicon => + q{Enter a complete URL to an image to replace the default Koha favicon on the staff interface}, + IntranetNav => + q{Use HTML tabs to add navigational links to the top-hand navigational bar in the staff interface}, + IntranetNumbersPreferPhrase => + q{Control the use of phr operator in callnumber and standard number staff interface searches}, + intranetreadinghistory => q{If enabled, Checkout history is enabled for all patrons}, + ManualRenewalPeriodBase => + q{Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for manual renewals}, + noissuescharge => q{Define maximum amount withstanding before checkouts are blocked}, + NoIssuesChargeGuarantees => q{Define maximum amount withstanding before checkouts are blocked}, + NoticesLog => q{If enabled, log changes to notice templates}, + NotifyPasswordChange => q{Notify patrons whenever their password is changed}, + NovelistSelectStaffEnabled => + q{Enable Novelist Select content in the staff interface. Requires Novelist Profile and Password}, + NovelistSelectStaffProfile => q{Novelist Select user Profile for staff interface}, + NovelistSelectStaffView => q{Where to display Novelist Select content in the staff interface}, + numSearchResultsDropdown => + q{Enable option list of number of results per page to show in staff interface search results}, + OpacHiddenItemsHidesRecord => + q{Hide bibliographic record when all its items are hidden because of OpacHiddenItems}, + OPACHoldsIfAvailableAtPickup => + q{Allow patrons to place a hold at pickup locations (libraries) where the item is available}, + OPACMySummaryHTML => + q{Enter the HTML that will appear in a column on the 'my summary' and 'my checkout history' tabs when a user is logged in to the OPAC. Enter {BIBLIONUMBER}, {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the HTML. Leave blank to disable}, + OPACPrivacy => q{if ON, allows patrons to define their privacy rules (checkout history)}, + OverDriveCirculation => q{Enable client to see their OverDrive account}, + OverDriveClientKey => q{Client key for OverDrive integration}, + OverDriveClientSecret => q{Client key for OverDrive integration}, + OverDriveLibraryID => q{Library ID for OverDrive integration}, + patronimages => q{Enable patron images for the staff interface}, + PatronRestrictionTypes => q{Specify type of patron restriction being applied}, + PrivacyPolicyConsent => q{Data privacy policy consent in the OPAC}, + RedirectGuaranteeEmail => q{Enable the ability to redirect guarantee email messages to guarantor}, + Reference_NFL_Statuses => q{Contains not for loan statuses considered as available for reference}, + RequireChoosingExistingAuthority => + q{Require existing authority selection in controlled fields during cataloging}, + RESTPublicAnonymousRequests => + q{If enabled, the API will allow anonymous access to public routes that don't require authenticated access}, + RetainPatronsSearchTerms => + q{If enabled, searches entered into the checkout and patrons search bars will be retained}, + SerialsDefaultEmailAddress => q{Default email address that serials notices are sent from}, + SerialsDefaultReplyTo => q{Default email address used as reply-to for notices sent by the serials module}, + staffClientBaseURL => + q{Specify the base URL of the staff interface starting with http:// or https://. Do not include a trailing slash in the URL. (This must be filled in correctly for CAS, svc, and load_testing to work.)}, + StaffHighlightedWords => q{Highlight search terms on staff interface}, + StaffInterfaceLanguages => q{Set the default language in the staff interface}, + StaffLangSelectorMode => q{Select the location to display the language selector in staff interface}, + StaffLoginRestrictLibraryByIP => + q{If enabled, IP authentication is enabled, blocking access to the staff interface from unauthorized IP addresses based on branch}, + StaffSerialIssueDisplayCount => + q{Number of serial issues to display per subscription in the staff interface}, + TrackLastPatronActivityTriggers => + q{If set, the field borrowers.lastseen will be updated every time a patron performs a selected action}, + UnseenRenewals => + q{Allow renewals to be recorded as "unseen" by the library, and count against the patrons unseen renewals limit}, + UpdateNotForLoanStatusOnCheckin => + qq{This is a list of item types and value pairs.\nExamples:\n_ALL_:\n -1: 0\n\nCR:\n 1: 0\n\nWhen an item is checked in, if its item type matches CR then when the value on the left (1) matches the items not for loan value it will be updated to the value on the right.\n\nThe special term _ALL_ is used on the left side of the colon (:) to affect all item types. This does not override all other rules\n\nEach item type needs to be defined on a separate line on the left side of the colon (:).\nEach pair of not for loan values, for that item type, should be listed on separate lines below the item type, each indented by a leading space}, + UseCirculationDesks => q{Use circulation desks with circulation}, + UseICUStyleQuotes => q#Tell Koha whether to use ICU style quotes ({) or default (") when tracing subjects#, + }; for my $variable ( sort { lc($a) cmp lc($b) } keys %$new_explanations ) { my $explanation = $new_explanations->{$variable}; $dbh->do( @@ -60,5 +162,78 @@ return { ); } + $dbh->do( + q{ + UPDATE systempreferences + SET options='cron|preferences|never', + explanation='How should Koha determine whether to end autorenewal notices' + WHERE variable="AutoRenewalNotices" + } + ); + + # from 30879, missing "biblionumber" + $dbh->do( + q{ + UPDATE systempreferences + SET options='call_number|pubdate|acqdate|title|author|biblionumber' + WHERE variable="ComponentSortField" + } + ); + + # from db_revs/221200048.pl, was 'multi' + $dbh->do( + q{ + UPDATE systempreferences + SET type='multiple' + WHERE variable="EmailFieldPrecedence" + } + ); + + $dbh->do( + q{ + UPDATE systempreferences + SET options='local|ebsco', + type="multiple" + WHERE variable="ERMProviders" + } + ); + + # From db_revs/231200005.pl, options and type were swapped + $dbh->do( + q{ + UPDATE systempreferences + SET options=NULL, + type='YesNo' + WHERE variable="HidePersonalPatronDetailOnCirculation" + } + ); + + # From db_revs/220600028.pl + $dbh->do( + q{ + UPDATE systempreferences + SET type='YesNo' + WHERE variable="IntranetAddMastheadLibraryPulldown" + } + ); + + # OverDriveLibraryID had the description + # PatronsPerPage had '20' + $dbh->do( + q{ + UPDATE systempreferences + SET options=NULL + WHERE type='Integer' + } + ); + + # Was missing some options + $dbh->do( + q{ + UPDATE systempreferences + SET options='datetime,transaction_branchcode,transaction_type,itemnumber,itemtype,holdingbranch,homebranch,location,itemcallnumber,ccode' + WHERE variable="PseudonymizationTransactionFields" + } + ); }, }; diff --git a/installer/data/mysql/db_revs/220600028.pl b/installer/data/mysql/db_revs/220600028.pl index 2cc5a7f49b7..8a5fd9d21e3 100755 --- a/installer/data/mysql/db_revs/220600028.pl +++ b/installer/data/mysql/db_revs/220600028.pl @@ -9,7 +9,7 @@ return { $dbh->do( q{ INSERT IGNORE INTO systempreferences (`variable`,`value`,`options`,`explanation`,`type`) - VALUES ('IntranetAddMastheadLibraryPulldown','0','','Add a library select pulldown menu on the staff header search','YesNo ') + VALUES ('IntranetAddMastheadLibraryPulldown','0','','Add a library select pulldown menu on the staff header search','YesNo') } ); diff --git a/installer/data/mysql/db_revs/220600079.pl b/installer/data/mysql/db_revs/220600079.pl index 41bea0a1d99..73cc785e19b 100755 --- a/installer/data/mysql/db_revs/220600079.pl +++ b/installer/data/mysql/db_revs/220600079.pl @@ -9,7 +9,7 @@ return { $dbh->do( q{ - INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) + INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'); } ); @@ -395,7 +395,7 @@ return { $dbh->do( q{ - INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) + INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'multiple'); } ); @@ -404,7 +404,7 @@ return { $dbh->do( q{ - INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) + INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('ERMProviderEbscoCustomerID', '', '', 'Customer ID for EBSCO', 'free'), ('ERMProviderEbscoApiKey', '', '', 'API key for EBSCO', 'free'); diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 307fa72ba42..c5d83077b4d 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -13,7 +13,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: their own only, any within their branch, or all','Choice'), ('AcqWarnOnDuplicateInvoice','0',NULL,'Warn librarians when they try to create a duplicate invoice','YesNo'), ('ActionLogsTraceDepth', '0', NULL, 'Sets the maximum depth of the action logs stack trace', 'Integer'), -('AdditionalContentLog','0',NULL,'If enabled, log OPAC news changes','YesNo'), +('AdditionalContentLog','0',NULL,'If enabled, log additional content changes','YesNo'), ('AdditionalContentsEditor','tinymce','tinymce|codemirror','Choose tool for editing News', 'Choice'), ('AdditionalFieldsInZ3950ResultAuthSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of an authority Z39.50 search', 'Free'), ('AdditionalFieldsInZ3950ResultSearch', '', NULL, 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950', 'Free'), @@ -91,17 +91,17 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('autoBarcode','OFF','incremental|annual|hbyymmincr|EAN13|OFF','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','Choice'), ('AutoClaimReturnStatusOnCheckin','',NULL,'When in use this system preference will automatically resolve the claim return and will update the lost authorized value upon check in','Free'), ('AutoClaimReturnStatusOnCheckout','',NULL,'When in use this system preference will automatically resolve the claim return and will update the lost authorized value upon check out','Free'), -('autoControlNumber','OFF','biblionumber|OFF','Used to autogenerate a Control Number: biblionumber will be as biblionumber, OFF will leave the field as it is;','Choice'), +('autoControlNumber','OFF','biblionumber|OFF','Used to autogenerate a Control Number: biblionumber will be as biblionumber, OFF will leave the field as it is','Choice'), ('AutoCreateAuthorities','0',NULL,'Automatically create authorities that do not exist when cataloging records','YesNo'), ('AutoCreditNumber', '', NULL, 'Automatically generate a number for account credits', 'Choice'), ('AutoEmailNewUser','0',NULL,'Send an email to newly created patrons','YesNo'), ('AutoILLBackendPriority','',NULL,'Set the automatic backend selection priority','ill-backends'), ('AutoLinkBiblios','0',NULL,'If enabled, link biblio to authorities on creation and edit','YesNo'), -('AutomaticCheckinAutoFill','0',NULL,'Automatically fill the next hold with an automatic check in','YesNo'), +('AutomaticCheckinAutoFill','0',NULL,'Automatically fill the next hold with an automatic check in cronjob','YesNo'), ('AutomaticConfirmTransfer','0',NULL,'Defines whether transfers should be automatically confirmed at checkin if modal dismissed','YesNo'), ('AutomaticEmailReceipts','0',NULL,'Send email receipts for payments and write-offs','YesNo'), ('AutomaticItemReturn','1',NULL,'If enabled, Koha will automatically set up a transfer of this item to its homebranch','YesNo'), -('AutomaticRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for automatic renewals ','Choice'), +('AutomaticRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for automatic renewals','Choice'), ('autoMemberNum','0',NULL,'If enabled, patron number is auto-calculated','YesNo'), ('AutoRemoveOverduesRestrictions','no','no|when_no_overdue|when_no_overdue_causing_debarment', 'Defines if and on what conditions OVERDUES debarments should automatically be lifted when overdue items are returned by the patron','Choice'), ('AutoRenewalNotices','preferences','cron|preferences|never','How should Koha determine whether to end autorenewal notices','Choice'), @@ -176,7 +176,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'), ('COinSinOPACResults','1',NULL,'If enabled, use COinS in OPAC search results page. NOTE: this can slow down search response time significantly','YesNo'), ('CollapseFieldsPatronAddForm','',NULL,'Collapse these fields by default when adding a new patron. These fields can still be expanded','Multiple'), -('ComponentSortField','title','call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'), +('ComponentSortField','title','call_number|pubdate|acqdate|title|author|biblionumber','Specify the default field used for sorting','Choice'), ('ComponentSortOrder','asc','asc|dsc|az|za','Specify the default sort order','Choice'), ('ConfirmFutureHolds','0',NULL,'Number of days for confirming future holds','Integer'), ('ConsiderHeadingUse', '0', NULL, 'Consider MARC21 authority heading use (main/added entry, or subject, or series title) in cataloging and linking', 'YesNo'), @@ -200,10 +200,10 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('decreaseLoanHighHoldsDuration','',NULL,'Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds','Integer'), ('decreaseLoanHighHoldsIgnoreStatuses', '', 'damaged|itemlost|notforloan|withdrawn', 'Ignore items with these statuses for dynamic high holds checking', 'Choice'), ('decreaseLoanHighHoldsValue','',NULL,'Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)','Integer'), -('DefaultAuthorityTab','0','0|1|2|3|4|5|6|7|8|9','Default tab to shwo when displaying authorities','Choice'), +('DefaultAuthorityTab','0','0|1|2|3|4|5|6|7|8|9','Default tab to show when displaying authorities','Choice'), ('DefaultClassificationSource','ddc',NULL,'Default classification scheme used by the collection. E.g., Dewey, LCC, etc','ClassSources'), ('DefaultCountryField008','',NULL,'Fill in the default country code for field 008 Range 15-17 of MARC21 - Place of publication, production, or execution. See MARC Code List for Countries','Free'), -('DefaultHoldExpirationdate','0',NULL,'Automatically set expiration date for holds','YesNo'), +('DefaultHoldExpirationdate','0',NULL,'Automatically set default expiration date for holds','YesNo'), ('DefaultHoldExpirationdatePeriod','0',NULL,'How long into the future default expiration date is set to be','Integer'), ('DefaultHoldExpirationdateUnitOfTime','days','days|months|years','Which unit of time is used when setting the default expiration date. ','choice'), ('DefaultHoldPickupLocation','loggedinlibrary','loggedinlibrary|homebranch|holdingbranch','Which branch should a hold pickup location default to. ','choice'), @@ -261,7 +261,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('EnableBooking','1',NULL,'If enabled, activate every functionalities related with Bookings module','YesNo'), ('EnableBorrowerFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to a borrower record','YesNo'), ('EnableExpiredPasswordReset', '0', NULL, 'Enable ability for patrons with expired password to reset their password directly', 'YesNo'), -('EnableItemGroupHolds','0',NULL,'Enable item groups holds feature','YesNo'), +('EnableItemGroupHolds','0',NULL,'Enable item group holds feature','YesNo'), ('EnableItemGroups','0',NULL,'Enable the item groups feature','YesNo'), ('EnableOpacSearchHistory','1','YesNo','Enable or disable opac search history',''), ('EnablePointOfSale','0',NULL,'Enable the point of sale feature to allow anonymous transactions with the accounting system. (Requires UseCashRegisters)','YesNo'), @@ -271,7 +271,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ERMModule', '0', NULL, 'Enable the e-resource management module', 'YesNo'), ('ERMProviderEbscoApiKey', '', NULL, 'API key for EBSCO', 'Free'), ('ERMProviderEbscoCustomerID', '', NULL, 'Customer ID for EBSCO', 'Free'), -('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'Choice'), +('ERMProviders', 'local', 'local|ebsco', 'Set the providers for the ERM module', 'multiple'), ('ExcludeHolidaysFromMaxPickUpDelay', '0', NULL, 'If enabled, reserves max pickup delay takes into accountthe closed days', 'YesNo'), ('expandedSearchOption','0',NULL,'If enabled, set advanced search to be expanded by default','YesNo'), ('ExpireReservesAutoFill','0',NULL,'Automatically fill the next hold with a automatically canceled expired waiting hold','YesNo'), @@ -411,7 +411,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('makePreviousSerialAvailable','0',NULL,'make previous serial automatically available when collecting a new serial. Please note that the item-level_itypes syspref must be set to specific item','YesNo'), ('Mana','2',NULL,'request to Mana Webservice. Mana centralize common information between other Koha to facilitate the creation of new subscriptions, vendors, report queries etc... You can search, share, import and comment the content of Mana','Choice'), ('ManaToken','',NULL,'Security token used for authentication on Mana KB service (anti spam)','Textarea'), -('ManualRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for manual renewals ','Choice'), +('ManualRenewalPeriodBase','date_due','date_due|now','Set whether the renewal date should be counted from the date_due or from the moment the Patron asks for renewal, for manual renewals','Choice'), ('MARCAuthorityControlField008','|| aca||aabn | a|a d',NULL,'Define the contents of MARC21 authority control field 008 position 06-39','Textarea'), ('MarcFieldDocURL', '', NULL, 'URL used for MARC field documentation. Following substitutions are available: {MARC} = marc flavour, eg. "MARC21" or "UNIMARC". {FIELD} = field number, eg. "000" or "048". {LANG} = user language, eg. "en" or "fi-FI"', 'Free'), ('MarcFieldForCreatorId','',NULL,'Where to store the borrowernumber of the record\'s creator','Free'), @@ -458,7 +458,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content. Requires Novelist Profile and Password','YesNo'), ('NovelistSelectPassword','',NULL,'Novelist select user Password','Free'), ('NovelistSelectProfile','',NULL,'Novelist Select user Profile','Free'), -('NovelistSelectStaffEnabled','0',NULL,'Enable Novelist Select content in the staff interface. Requires Novelist Profile and Password','YesNo'), +('NovelistSelectStaffEnabled','0',NULL,'Enable Novelist Select content in the staff interface. Requires Novelist Profile and Password','YesNo'), ('NovelistSelectStaffProfile','',NULL,'Novelist Select user Profile for staff interface','Free'), ('NovelistSelectStaffView','tab','tab|above|below','Where to display Novelist Select content in the staff interface','Choice'), ('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'), @@ -518,7 +518,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('OPACFRBRizeEditions','0',NULL,'If enabled, the OPAC will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','YesNo'), ('OpacHiddenItems','',NULL,'This syspref allows to define custom rules for hiding specific items at the OPAC. See https://wiki.koha-community.org/wiki/OpacHiddenItems for more information','Textarea'), ('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by comma, that can see items otherwise hidden by OpacHiddenItems','Textarea'), -('OpacHiddenItemsHidesRecord','1',NULL,'Hide biblio record when all its items are hidden because of OpacHiddenItems','YesNo'), +('OpacHiddenItemsHidesRecord','1',NULL,'Hide bibliographic record when all its items are hidden because of OpacHiddenItems','YesNo'), ('OpacHighlightedWords','1',NULL,'If Set, then queried words are higlighted in OPAC','YesNo'), ('OpacHoldNotes','0',NULL,'Show hold notes on OPAC','YesNo'), ('OPACHoldRequests','1',NULL,'If enabled, globally enables patron holds on OPAC','YesNo'), @@ -644,7 +644,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('PatronSelfRegistrationLibraryList','',NULL,'Only display libraries listed. If empty, all libraries are displayed','Free'), ('PatronSelfRegistrationPrefillForm','1',NULL,'Display password and prefill login form after a patron has self-registered','YesNo'), ('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate their account','YesNo'), -('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'), +('PatronsPerPage','20',NULL,'Number of Patrons Per Page displayed by default','Integer'), ('PhoneNotification','0',NULL,'If enabled, enables generation of phone notifications to be sent by plugins','YesNo'), ('PlaceHoldsOnOrdersFromSuggestions','0',NULL,'If enabled, enables generation of holds when orders are placed from suggestions','YesNo'), ('PrefillGuaranteeField', 'phone,email,streetnumber,address,city,state,zipcode,country', NULL, 'Prefill these fields in guarantee member entry form from guarantor patron record', 'Multiple'), @@ -662,7 +662,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ProtectSuperlibrarianPrivileges','1',NULL,'If enabled, non-superlibrarians cannot set superlibrarian privileges','YesNo'), ('Pseudonymization','0',NULL,'If enabled patrons and transactions will be copied in a separate table for statistics purpose','YesNo'), ('PseudonymizationPatronFields','','title,city,state,zipcode,country,branchcode,categorycode,dateenrolled,sex,sort1,sort2','Patron fields to copy to the pseudonymized_transactions table','multiple'), -('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the pseudonymized_transactions table','multiple'), +('PseudonymizationTransactionFields','','datetime,transaction_branchcode,transaction_type,itemnumber,itemtype,holdingbranch,homebranch,location,itemcallnumber,ccode','Transaction fields to copy to the pseudonymized_transactions table','multiple'), ('PurgeListShareInvitesOlderThan', '14', NULL, 'If not empty, number of days used when deleting unaccepted list share invites', 'Integer'), ('PurgeSuggestionsOlderThan', '', NULL, 'If this script is called without the days parameter', 'Integer'), ('QueryAutoTruncate','1',NULL,'If enabled, query truncation is enabled by default','YesNo'), @@ -710,7 +710,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('RestrictionBlockRenewing','0',NULL,'If patron is restricted, should renewal be allowed or blocked','YesNo'), ('RestrictPatronsWithFailedNotices', '0', NULL, 'If enabled then when SMS and email notices fail sending at the Koha level then a debarment will be applied to a patrons account', 'YesNo'), ('RetainCatalogSearchTerms', '1', NULL, 'If enabled, searches entered into the catalog search bar will be retained', 'YesNo'), -('RetainPatronsSearchTerms', '1', NULL, 'If enabled, searches entered into the checkout and patrons search bar will be retained', 'YesNo'), +('RetainPatronsSearchTerms', '1', NULL, 'If enabled, searches entered into the checkout and patrons search bars will be retained', 'YesNo'), ('ReturnBeforeExpiry','0',NULL,'If enabled, checkout will be prevented if returndate is after patron card expiry','YesNo'), ('ReturnLog','1',NULL,'If enabled, enables the circulation (returns) log','YesNo'), ('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'), @@ -742,8 +742,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'), ('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'), ('SeparateHoldingsByGroup','0',NULL,'Separate current branch holdings and holdings from libraries in the same library groups','YesNo'), -('SerialsDefaultEmailAddress', '', NULL, 'Default email address used as reply-to for notices sent by the serials module', 'Free'), -('SerialsDefaultReplyTo', '', NULL, 'Default email address that serials notices are sent from', 'Free'), +('SerialsDefaultEmailAddress', '', NULL, 'Default email address that serials notices are sent from', 'Free'), +('SerialsDefaultReplyTo', '', NULL, 'Default email address used as reply-to for notices sent by the serials module', 'Free'), ('SerialsSearchResultsLimit', '', NULL, 'Serials search results limit', 'Integer'), ('SessionRestrictionByIP','1',NULL,'Check for change in remote IP address for session security. Disable only when remote IP address changes frequently','YesNo'), ('SessionStorage','mysql','mysql|Pg|tmp','Use database or a temporary file for storing session data','Choice'), @@ -831,7 +831,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('TraceCompleteSubfields','0',NULL,'Force subject tracings to only match complete subfields','YesNo'), ('TraceSubjectSubdivisions','0',NULL,'Create searches on all subdivisions for subject tracings','YesNo'), ('TrackClicks','0',NULL,'Track links clicked','Integer'), -('TrackLastPatronActivityTriggers','',NULL,'If set, the field borrowers.lastseen will be updated everytime a patron performs a selected action','multiple'), +('TrackLastPatronActivityTriggers','',NULL,'If set, the field borrowers.lastseen will be updated every time a patron performs a selected action','multiple'), ('TransfersBlockCirc','1',NULL,'Should the transfer modal block circulation staff from continuing scanning items','YesNo'), ('TransfersLog','0',NULL,'If enabled, log item transfer changes','YesNo'), ('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'), @@ -876,7 +876,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('useDaysMode','Calendar','Calendar|Days|Datedue|Dayweek','Choose the method for calculating due date: select Calendar, Datedue or Dayweek to use the holidays module, and Days to ignore the holidays module','Choice'), ('useDefaultReplacementCost', '0', NULL, 'default replacement cost defined in item type', 'YesNo'), ('useDischarge','0',NULL,'Allows librarians to discharge borrowers and borrowers to request a discharge','YesNo'), -('UseICUStyleQuotes','0',NULL,'Tell Koha whether to use ICU style quotes ({) or default (") when tracing subjects ','YesNo'), +('UseICUStyleQuotes','0',NULL,'Tell Koha whether to use ICU style quotes ({) or default (") when tracing subjects','YesNo'), ('UseLocationAsAQInSIP', '0', NULL, 'Use permanent_location instead of homebranch for AQ in SIP response', 'YesNo'), ('UseOCLCEncodingLevels','0',NULL,'If enabled, include OCLC encoding levels in leader value builder dropdown for position 17','YesNo'), ('UseRecalls','0',NULL,'Enable or disable recalls','YesNo'), @@ -896,5 +896,5 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('XSLTResultsDisplay','default',NULL,'Enable XSL stylesheet control over results page display on intranet','Free'), ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','Free'), ('z3950NormalizeAuthor','0',NULL,'If enabled, Personal Name Authorities will replace authors in biblio.author','YesNo'), -('z3950Status','',NULL,'This syspref allows to define custom YAML based rules for marking items unavailable in z3950 results.','Textarea') +('z3950Status','',NULL,'This syspref allows to define custom YAML based rules for marking items unavailable in z3950 results','Textarea') ; -- 2.43.0