From 3af399220286fc64d196a7687d6baf3191c39fb9 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 11 Nov 2022 13:52:40 +0100 Subject: [PATCH] output of updatedatabase from v3.0.6 to 22.06.00.083 https://bugs.koha-community.org/show_bug.cgi?id=30951 --- output | 1915 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 1915 insertions(+) create mode 100644 output diff --git a/output b/output new file mode 100644 index 00000000000..6ebcf99d50a --- /dev/null +++ b/output @@ -0,0 +1,1915 @@ +Use of uninitialized value in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 78. +DBD::mysql::db do failed: Table 'koha_kohadev.bookshelf' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 81. +DBD::mysql::db do failed: Table 'koha_kohadev.shelfcontents' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 82. +DBD::mysql::db do failed: Duplicate column name 'biblionumber' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 83. +DBD::mysql::db do failed: Unknown column 'virtualshelfcontents.itemnumber' in 'where clause' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 84. +DBD::mysql::db do failed: Duplicate key name 'biblionumber' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 86. +DBD::mysql::db do failed: Can't create table `koha_kohadev`.`virtualshelfcontents` (errno: 121 "Duplicate key on write or update") at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 88. +DBD::mysql::db do failed: Can't create table `koha_kohadev`.`virtualshelfcontents` (errno: 121 "Duplicate key on write or update") at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 90. +DBD::mysql::db do failed: Can't DROP COLUMN `itemnumber`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 91. +Upgrade to 3.00.00.001 done (virtualshelves) +Upgrade to 3.00.00.002 done (sessions uses CGI::session, new table structure for sessions) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 112. +Upgrade to 3.00.00.003 done (adding ReservesNeedReturns systempref, in circulation) +Upgrade to 3.00.00.004 done (adding DebugLevel systempref, in 'Admin' tab) +DBD::mysql::db do failed: Table 'tags' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 131. +DBD::mysql::db do failed: Table 'nozebra' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 137. +Upgrade to 3.00.00.005 done (adding tags and nozebra tables ) +Upgrade to 3.00.00.006 done (filled issues.issuedate with timestamp) +Upgrade to 3.00.00.007 done (set SessionStorage variable) +DBD::mysql::db do failed: Duplicate column name 'datecreated' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 166. +Upgrade to 3.00.00.008 done (biblio creation date) +DBD::mysql::db do failed: Unknown column 'classification' in 'field list' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 183. +DBD::mysql::db do failed: Unknown column 'volumeddesc' in 'biblioitems' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 190. +DBD::mysql::db do failed: Unknown column 'classification' in 'field list' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 210. +DBD::mysql::db do failed: Can't DROP COLUMN `classification`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 217. +DBD::mysql::db do failed: Can't DROP COLUMN `marc`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 224. +DBD::mysql::db do failed: Unknown column 'volumeddesc' in 'deletedbiblioitems' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 230. +DBD::mysql::db do failed: Unknown column 'classification' in 'field list' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 251. +DBD::mysql::db do failed: Can't DROP COLUMN `classification`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 256. +DBD::mysql::db do failed: Can't DROP COLUMN `bulk`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 265. +DBD::mysql::db do failed: Duplicate column name 'cn_source' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 295. +DBD::mysql::db do failed: Can't DROP COLUMN `cutterextra`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 312. +Upgrade to 3.00.00.009 done (major changes to biblio, biblioitems, items, and deleted* versions of same +DBD::mysql::db do failed: Duplicate key name 'userid' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 321. +Upgrade to 3.00.00.010 done (userid index added) +DBD::mysql::db do failed: Duplicate column name 'categorytype' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 330. +Upgrade to 3.00.00.011 done (added branchcategory type) +DBD::mysql::db do failed: Table 'class_sort_rules' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 339. +DBD::mysql::db do failed: Table 'class_sources' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 346. +Upgrade to 3.00.00.012 done (classification sources added) +DBD::mysql::db do failed: Table 'import_batches' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 376. +DBD::mysql::db do failed: Table 'import_records' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 391. +DBD::mysql::db do failed: Table 'import_record_matches' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 413. +DBD::mysql::db do failed: Table 'import_biblios' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 421. +DBD::mysql::db do failed: Table 'import_items' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 437. +DBD::mysql::db do failed: Table 'koha_kohadev.marc_breeding' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 452. +DBD::mysql::db do failed: Table 'koha_kohadev.marc_breeding' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 457. +DBD::mysql::db do failed: Table 'koha_kohadev.marc_breeding' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 464. +DBD::mysql::db do failed: Unknown table 'koha_kohadev.marc_breeding' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 477. +Upgrade to 3.00.00.013 done (import_batches et al. added) +DBD::mysql::db do failed: Duplicate column name 'lastbranch' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 485. +Upgrade to 3.00.00.014 done (userid index added) +DBD::mysql::db do failed: Table 'saved_sql' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 492. +DBD::mysql::db do failed: Table 'saved_reports' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 505. +Upgrade to 3.00.00.015 done (saved_sql and saved_reports added) +DBD::mysql::db do failed: Table 'reports_dictionary' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 518. +Upgrade to 3.00.00.016 done (reports_dictionary) added) +DBD::mysql::db do failed: Incorrect table definition; there can be only one auto column and it must be defined as a key at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 534. +DBD::mysql::db do failed: Duplicate key name 'timestamp' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 535. +DBD::mysql::db do failed: Duplicate column name 'action_id' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 536. +DBD::mysql::db do failed: Multiple primary key defined at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 538. +Upgrade to 3.00.00.017 done (added column to action_logs) +DBD::mysql::db do failed: Duplicate column name 'done' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 545. +Upgrade to 3.00.00.018 done (adding timestamp and done columns to zebraque table to improve problem tracking) added) +Upgrade to 3.00.00.019 done (made bib/item PKs auto_increment) +Upgrade to 3.00.00.020 done (dropped uniqueness of key on deleteditems.barcode) +Upgrade to 3.00.00.021 done (extended missed branchcode columns to 10 chars) +DBD::mysql::db do failed: Duplicate column name 'damaged' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 583. +DBD::mysql::db do failed: Duplicate column name 'damaged' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 585. +Upgrade to 3.00.00.022 done (adding damaged column to items table) +Upgrade to 3.00.00.023 done (adding new system preference for controlling YUI path) +Upgrade to 3.00.00.024 done (changing itemtype to (10)) +DBD::mysql::db do failed: Duplicate column name 'itype' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 607. +Upgrade to 3.00.00.025 done (reintroduce items.itype - fill from itemtype) + Upgrade to 3.00.00.026 done (adding new system preference for choosing whether homebranch or holdingbranch is checked in circulation) +DBD::mysql::db do failed: Table 'marc_matchers' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 626. +DBD::mysql::db do failed: Table 'matchpoints' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 636. +DBD::mysql::db do failed: Table 'matchpoint_components' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 645. +DBD::mysql::db do failed: Table 'matchpoint_component_norms' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 658. +DBD::mysql::db do failed: Table 'matcher_matchpoints' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 666. +DBD::mysql::db do failed: Table 'matchchecks' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 674. +Upgrade to 3.00.00.027 done (added C4::Matcher serialization tables) + Upgrade to 3.00.00.028 done (adding new system preference for changing reserve/holds behaviour with independent branches) +DBD::mysql::db do failed: Duplicate column name 'matcher_id' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 702. +Upgrade to 3.00.00.029 done (adding matcher_id to import_batches) +DBD::mysql::db do failed: Table 'services_throttle' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 709. +Upgrade to 3.00.00.030 done (adding services throttle table and sysprefs for xISBN) +Upgrade to 3.00.00.031 done (adding additional system preference) +Upgrade to 3.00.00.032 done (fixed MARC framework references to items.withdrawn) +Upgrade to 3.00.00.033 done (Adding permissions flag for staff member access modification. ) +DBD::mysql::db do failed: Duplicate column name 'sortfield' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 783. +Upgrade to 3.00.00.034 done (Adding sortfield for Virtual Shelves. ) +Upgrade to 3.00.00.035 done (MARC frameworks: make classification source a drop-down) +Upgrade to 3.00.00.036 done (OPACItemsResultsDisplay systempreference added) +DBD::mysql::db do failed: Duplicate column name 'altcontactfirstname' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 807. +DBD::mysql::db do failed: Duplicate column name 'altcontactsurname' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 808. +DBD::mysql::db do failed: Duplicate column name 'altcontactaddress1' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 809. +DBD::mysql::db do failed: Duplicate column name 'altcontactaddress2' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 810. +DBD::mysql::db do failed: Duplicate column name 'altcontactaddress3' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 811. +DBD::mysql::db do failed: Duplicate column name 'altcontactzipcode' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 812. +DBD::mysql::db do failed: Duplicate column name 'altcontactphone' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 813. +Upgrade to 3.00.00.037 done (Adding Alternative Contact Person information to borrowers table) +Upgrade to 3.00.00.038 done ('alter finesMode systempreference, remove superfluous syspref.') +Upgrade to 3.00.00.039 done ('add circ sysprefs CircControl, finesCalendar, and uppercasesurnames, and delete HomeOrHoldingBranch.') +Upgrade to 3.00.00.040 done ('add circ sysprefs todaysIssuesDefaultSortOrder and previousIssuesDefaultSortOrder.') +Upgrade to 3.00.00.041 done (disallow NULL in several item status columns) +DBD::mysql::db do failed: Duplicate column name 'symbol' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 881. +Upgrade to 3.00.00.043 done (currency table: add symbol and timestamp columns) +DBD::mysql::db do failed: Duplicate column name 'altcontactfirstname' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 888. +Upgrade to 3.00.00.044 done (syncing deletedborrowers table with borrowers table) +DBD::mysql::db do failed: Table 'language_subtag_registry' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 912. +DBD::mysql::db do failed: Table 'language_rfc4646_to_iso639' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 924. +DBD::mysql::db do failed: Table 'language_descriptions' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 930. +DBD::mysql::db do failed: Table 'language_script_bidi' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 939. +DBD::mysql::db do failed: Table 'language_script_mapping' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 953. +Upgrade to 3.00.00.045 done (adding language subtag registry and basic BiDi support NOTE: You should import the subtag registry SQL) +DBD::mysql::db do failed: Table 'serialitems' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 973. +Upgrade to 3.00.00.046 done (Add serialitems table to link serial issues to items. ) +Upgrade to 3.00.00.047 done ( Added OpacRenewalAllowed syspref ) +DBD::mysql::db do failed: Duplicate column name 'more_subfields_xml' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 988. +Upgrade to 3.00.00.048 done (added items.more_subfields_xml) +DBD::mysql::db do failed: Duplicate column name 'encoding' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 995. +Upgrade to 3.00.00.049 done ( Added encoding field to z3950servers table ) +Upgrade to 3.00.00.050 done ( Added OpacHighlightedWords syspref ) +Upgrade to 3.00.00.051 done ( Corrected opacthemes explanation. ) +DBD::mysql::db do failed: Duplicate column name 'more_subfields_xml' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1016. +Upgrade to 3.00.00.052 done ( Adding missing column to deleteditems table. ) +DBD::mysql::db do failed: Table 'printers_profile' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1023. +DBD::mysql::db do failed: Table 'labels_profile' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1037. +Upgrade to 3.00.00.053 done ( Printer Profile tables added ) +Upgrade to 3.00.00.054 done ( Added another barcode autogeneration sequence to barcode.pl. ) +DBD::mysql::db do failed: Duplicate key name 'zebraqueue_lookup' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1056. +Upgrade to 3.00.00.055 done ( Added index on zebraqueue. ) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1062. +DBD::mysql::db do failed: Duplicate column name 'enumchron' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1067. +Upgrade to 3.00.00.056 done ( Added item.enumchron column, and framework map to 952h ) +Upgrade to 3.00.00.058 done ( lang field in opac_news made longer ) +Upgrade to 3.00.00.059 done ( Added labels_templates table if it did not exist. ) +Upgrade to 3.00.00.060 done ( Added patronimage table. ) +DBD::mysql::db do failed: Duplicate column name 'font' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1148. +Upgrade to 3.00.00.061 done ( Added font column to labels_templates ) +DBD::mysql::db do failed: Table 'old_issues' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1155. +DBD::mysql::db do failed: Table 'old_reserves' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1175. +Upgrade to 3.00.00.062 done ( Added old_issues and old_reserves tables ) +DBD::mysql::db do failed: Duplicate column name 'enumchron' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1214. +DBD::mysql::db do failed: Duplicate column name 'copynumber' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1218. +Upgrade to 3.00.00.063 done ( Changed items.booksellerid and deleteditems.booksellerid to MEDIUMTEXT and added missing items.copynumber and deleteditems.copynumber to fix Bug 1927) +Upgrade to 3.00.00.064 done (IMPORTANT: Upgrading to Amazon.com Associates Web Service 4.0 ) +DBD::mysql::db do failed: Table 'patroncards' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1238. +Upgrade to 3.00.00.065 done (Adding patroncards table for patroncards generation feature. ) +Upgrade to 3.00.00.066 done (fix for bug 1873: virtualshelfcontents dateadded column empty. ) +Upgrade to 3.00.00.067 done (Updating patronimages syspref to reflect current kohastructure.sql. ) +DBD::mysql::db do failed: Table 'permissions' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1269. +DBD::mysql::db do failed: Table 'user_permissions' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1277. +DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_kohadev`.`permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1288. +Upgrade to 3.00.00.068 done (adding permissions and user_permissions tables and GranularPermissions syspref) +DBD::mysql::db do failed: Unknown column 'class' in 'labels_conf' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1312. +Upgrade to 3.00.00.069 done ( Correcting columname in labels_conf ) +Update yuipath syspref to 2.5.1 if necessary +DBD::mysql::db do failed: Duplicate column name 'serialsadditems' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1330. +Use of uninitialized value $serialsadditems in concatenation (.) or string at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1335. +DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1335. +Upgrade to 3.00.00.071 done ( moving serialsadditems from syspref to subscription ) +DBD::mysql::db do failed: Duplicate column name 'formatstring' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1343. +Upgrade to 3.00.00.072 done ( Adding format string to labels generator. ) +DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1368. +DBD::mysql::db do failed: Table 'tags_approval' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1369. +Upgrade to 3.00.00.073 done (Baker/Taylor,Tags: sysprefs and tables (tags_all, tags_index, tags_approval)) +Upgrade to 3.00.00.074 done (updating imagetype.imageurls to reflect new icon locations.) +DBD::mysql::db do failed: Duplicate column name 'imageurl' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1426. +Upgrade to 3.00.00.075 done (adding imageurl field to authorised_values table) +DBD::mysql::db do failed: Duplicate column name 'nomatch_action' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1433. +DBD::mysql::db do failed: Duplicate column name 'item_action' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1435. +Upgrade to 3.00.00.076 done (changes to import_batches and import_records) +Upgrade to 3.00.00.077 done (drop categorytable, subcategorytable, and mediatypetable) +Upgrade to 3.00.00.078 done (add browser table if not already present) +Upgrade to 3.00.00.079 done (add browser table if not already present) +Upgrade to 3.00.00.080 done (catch up on DB schema changes since alpha and beta) +Upgrade to 3.00.00.081 done (added borrower_attributes and borrower_attribute_types) +Upgrade to 3.00.00.082 done (adding lastincrement column to accountlines table) +Upgrade to 3.00.00.083 done (Changing yuipath behaviour in managing a local value) +Upgrade to 3.00.00.084 done (add new sysprefs) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1582. +Upgrade to 3.00.00.085 done (move editing tab of various MARC21 subfields) +Upgrade to 3.00.00.086 done (Table structure for table `tmp_holdsqueue`) +Upgrade to 3.00.00.087 done (added 2 new 'AutoEmailOpacUser' sysprefs) +Upgrade to 3.00.00.088 done (added 2 new 'AutoEmailOpacUser' sysprefs) +Upgrade to 3.00.00.089 done (added new AdvancedSearchTypes syspref) +Upgrade to 3.00.00.090 done (added several circ rules tables) +Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 588. +C4::Installer::load_sql returned the following errors while attempting to load : +Use of uninitialized value $filename in pattern match (m//) at /kohadevbox/koha/C4/Installer.pm line 556. +Use of uninitialized value $filename in open at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +Use of uninitialized value $filename in concatenation (.) or string at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 583. +Something went wrong loading file (Can't open '' for input: +No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +) at /kohadevbox/koha/C4/Installer.pm line 583. +Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 588. +C4::Installer::load_sql returned the following errors while attempting to load : +Use of uninitialized value $filename in pattern match (m//) at /kohadevbox/koha/C4/Installer.pm line 556. +Use of uninitialized value $filename in open at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +Use of uninitialized value $filename in concatenation (.) or string at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 583. +Something went wrong loading file (Can't open '' for input: +No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +) at /kohadevbox/koha/C4/Installer.pm line 583. +Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 588. +C4::Installer::load_sql returned the following errors while attempting to load : +Use of uninitialized value $filename in pattern match (m//) at /kohadevbox/koha/C4/Installer.pm line 556. +Use of uninitialized value $filename in open at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +Use of uninitialized value $filename in concatenation (.) or string at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 583. +Something went wrong loading file (Can't open '' for input: +No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48. +) at /kohadevbox/koha/C4/Installer.pm line 583. +Upgrade to 3.00.00.091 done (Table structure for table `message_queue`, `message_transport_types`, `message_attributes`, `message_transports`, `borrower_message_preferences`, and `borrower_message_transport_preferences`. Alter `borrowers` table, +Upgrade to 3.00.00.092 done (added new AllowOnShelfHolds syspref) +Upgrade to 3.00.00.093 done (Change data type of items.copynumber to allow free text) +Upgrade to 3.00.00.094 done (Change Collation of marc_subfield_structure to allow mixed case in subfield labels.) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1833. +Upgrade to 3.00.00.095 done (fix invalid authority types in MARC21 frameworks [bug 2254]) +Upgrade to 3.00.00.096 done (fix name borrower_message_preferences.wants_digest) +Upgrade to 3.00.00.097 done (updating 4 fields in message_queue table) +Upgrade to 3.00.00.098 done (removing unused RSS message_transport_type) +Upgrade to 3.00.00.099 done (Adding OpacSuppression syspref) +Upgrade to 3.00.00.100 done (Adding lastmodified column to virtualshelves) +Upgrade to 3.00.00.101 done (Updating columnd definitions for patron category codes in notice/statsu triggers and deletedborrowers tables.) +Upgrade to 3.00.00.102 done (Updating serialitems table to allow for multiple items per serial fixing kohabug 2380) +Upgrade to 3.00.00.103 done ( Verifying the removal of serialsadditems from syspref fixing kohabug 2219) +Upgrade to 3.00.00.104 done (remove superseded 'noOPACHolds' system preference per bug 2413) +Upgrade to 3.00.00.105 done (added SMSSendDriver system preference) +Upgrade to 3.00.00.106 done (remove default '0000-00-00' in subscriptionhistory.enddate field) +Upgrade to 3.00.00.107 done (warning added to OPACShelfBrowser system preference) +Upgrade to 3.01.00.000 done (start of 3.1) +Upgrade to 3.01.00.001 done (add hold_fill_targets table and a column to tmp_holdsqueue) +Upgrade to 3.01.00.002 done (bug 2582: set null issues.issuedate to lastreneweddate) +Upgrade to 3.01.00.003 done (add new syspref) +Upgrade to 3.01.00.004 done (added OPACDisplayRequestPriority system preference) +Upgrade to 3.01.00.005 done (Add letter for holds notifications) +Upgrade to 3.01.00.006 done (add index on biblioitems.issn) +Upgrade to 3.01.00.007 done (fix display of many sysprefs) +Upgrade to 3.01.00.008 done (added branch_transfer_limits table and UseBranchTransferLimits system preference) +Upgrade to 3.01.00.009 done (added subpermissions for circulate permission) +Upgrade to 3.01.00.010 done (bug 2687: increase length of borrower attribute fields) +Upgrade to 3.01.00.011 done (removed bogus intranetuserjs syspref) +Upgrade to 3.01.00.012 done (Add tables and system preferences for holds policies) +Upgrade to 3.01.00.013 done (data for Email Checkout Slips project) +Upgrade to 3.01.00.014 done ( Updated table for Branch Transfer Limits) +Upgrade to 3.01.00.015 done (added Syndetics Enhanced Content system preferences) +Upgrade to 3.01.00.016 done (Added Babeltheque syspref) +Upgrade to 3.01.00.017 done ( Updated table for Serials Display) +Upgrade to 3.01.00.018 done (added deletedborrowers.smsalertnumber, missed in 3.00.00.091) +Upgrade to 3.01.00.019 done (adding OPACShowCheckoutName systempref) +Upgrade to 3.01.00.020 done (adding LibraryThing for Libraries sysprefs) +Upgrade to 3.01.00.021 done (adding OPACAmazonReviews syspref) +Upgrade to 3.01.00.022 done (bug 2945: increase size of labels_conf.formatstring) +Upgrade to 3.01.00.023 done (bug 2765: increase width of isbn column in several tables) +Upgrade to 3.01.00.024 done (change labels.batch_id from varchar to int) +Upgrade to 3.01.00.025 done (added ceilingDueDate system preference) +Upgrade to 3.01.00.026 done (added numReturnedItemsToShow system preference) +Upgrade to 3.01.00.027 done (Increased size of zebraqueue biblio_auth_number to address bug 3148.) +Upgrade to 3.01.00.028 done (added AmazonReviews) +Upgrade to 3.01.00.029 done (fixed bug 2599: using Spanish search limit retrieves Russian results) +Upgrade to 3.01.00.030 done (added AllowNotForLoanOverride system preference) +Upgrade to 3.01.00.031 done (fix column widths in branch_transfer_limits) +Upgrade to 3.01.00.032 done (Change the field) +Upgrade to 3.01.00.033 done (DB changes to allow patron category defaults for messaging preferences) +Upgrade to 3.01.00.034 done (Adding graceperiod column to subscription table) +Upgrade to 3.01.00.035 done (Adding location to subscription table) +Upgrade to 3.01.00.036 done (new viewISBD, viewLabeledMARC, viewMARC sysprefs and tweak IntranetBiblioDefaultView) +Upgrade to 3.01.00.037 done (added FilterBeforeOverdueReport syspref and new index on authorised_values) +Upgrade to 3.01.00.038 done (add ZIP, city, country, URL, and notes column to branches) +Upgrade to 3.01.00.039 done (added SpineLabelFormat and SpineLabelAutoPrint sysprefs) +Upgrade to 3.01.00.040 done (AllowHoldDateInFuture and OPACAllowHoldDateInFuture sysprefs) +Upgrade to 3.01.00.041 done (added AWSPrivateKey syspref - note that if you use enhanced content from Amazon, this should be set right away.) +Upgrade to 3.01.00.042 done (added OPACFineNoRenewals syspref) +Upgrade to 3.01.00.043 done (amended Item added NewItemsDefaultLocation, InProcessingToShelvingCart, ReturnToShelvingCart sysprefs) +Upgrade to 3.01.00.044 done (added DisplayClearScreenButton system preference) +Upgrade to 3.01.00.045 done (added a preference to hide the patrons name in the staff catalog) +Upgrade to 3.01.00.046 done (add country and B_country to borrowers) + Upgrade to 3.01.00.047 done (bug 2761: change max length of itemcallnumber to 255 from 30) + Upgrade to 3.01.00.048 done (bug 2611: fix spelling/capitalization in permission flag descriptions) +Upgrade to 3.01.00.049 done (bug 2611: changed catalogue to catalog per the standard) +Upgrade to 3.01.00.050 done (bug 1934: Add OPACSearchForTitleIn syspref) +Upgrade to 3.01.00.051 done (fixed typos in new sysprefs) +Upgrade to 3.01.00.052 done (bug 3481: add permanent_location column to deleteditems) +DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows, col_gap, row_gap, units) SELECT lt.tmpl_id, lt.tmpl_code, lt.tmpl_desc,...' at line 1 at /kohadevbox/koha/installer/data/mysql/labels_upgrade.pl line 126. +DB ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows, col_gap, row_gap, units) SELECT lt.tmpl_id, lt.tmpl_code, lt.tmpl_desc,...' at line 1 +Upgrade to 3.01.00.053 done (Migrated labels tables and data to new schema.) NOTE: All existing label batches have been assigned to the first branch in the list of branches. This is ONLY true of migrated label batches. +Upgrade to 3.01.00.054 done (bug 1600, bug 3454: add altcontactcountry and B_address2 to borrowers and deletedborrowers) +Upgrade to 3.01.00.055 done (changed OPACSearchForTitleIn per requests in bug 1934) +Upgrade to 3.01.00.056 done (Bug 1172 : Add OPACPatronDetails syspref) +Upgrade to 3.01.00.057 done (Bug 2576 : Add OPACFinesTab syspref) +Upgrade to 3.01.00.058 done (Added primary keys to language tables) +Upgrade to 3.01.00.059 done (added DisplayOPACiconsXSLT sysprefs) +Upgrade to 3.01.00.060 done ( Added AllowAllMessageDeletion syspref and messages table ) +Upgrade to 3.01.00.061 done ( Added ShowPatronImageInWebBasedSelfCheck system preference ) +Upgrade to 3.01.00.062 done (added csv export profiles) +Upgrade to 3.01.00.063 done (Created table fieldmapping) +Upgrade to 3.01.00.064 done (Version number skipped: nothing done) +Upgrade to 3.01.00.065 done (Moving allowed renewals from itemtypes to issuingrule) +Upgrade to 3.01.00.066 done (Moving max allowed reserves from system preference to issuingrule) +Upgrade to 3.01.00.067 done (added permissions for batch modification and deletion) +Upgrade to 3.01.00.068 done (Adding finedays in issuingrules table) +Upgrade to 3.01.00.069 done (added OPAC search history preference and table) +Upgrade to 3.01.00.070 done (Added a lib_opac field in authorised_values table) +Upgrade to 3.01.00.071 done ( Adding enddate to subscription) +Upgrade to 3.01.00.072 done (add new syspref and column in borrowers) +Upgrade to 3.01.00.073 done (adding aqcontract table) +Upgrade to 3.01.00.074 done (edit aqbasket table done) +Upgrade to 3.01.00.075 done (adding uncertainprices) +Upgrade to 3.01.00.076 done (adding basketgroups) +Upgrade to 3.01.00.077 done (Adding new aqbudgetperiods, aqbudgets and aqbudget_planning tables ) +Upgrade to 3.01.00.078 done (adds 'budget_period_total' column to aqbudgetperiods table) +Upgrade to 3.01.00.079 done (adds 'active' column to currencies table) +Upgrade to 3.01.00.080 done (adds permissions for the acquisitions module) +Upgrade to 3.01.00.081 done (added per-supplier gstrate setting) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3117. +Upgrade to 3.01.00.082 done (adding ReservesNeedReturns systempref, in circulation) +Upgrade to 3.01.00.083 done (New aqorders_items table for acqui) +Upgrade to 3.01.00.084 done (CurrencyFormat syspref added) +Upgrade to 3.01.00.085 done update budget_id size that should not be a tinyint +Upgrade to 3.01.00.086 done (Suggestions) +Upgrade to 3.01.00.087 done (Drop column budget_amount_sublevel from aqbudgets) +Upgrade to 3.01.00.088 done (intranetbookbag syspref added) +Upgrade to 3.01.00.090 done (granular permissions for guided reports added) +Upgrade to 3.01.00.091 done (opac-detail default tag updated) +Use of uninitialized value in pattern match (m//) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3220. +Upgrade to 3.01.00.092 done (Added RoutingListAddReserves syspref) +Upgrade to 3.01.00.093 done (added index to ISSN) +Upgrade to 3.01.00.094 done (adding deliveryplace deliverycomment to basketgroups) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3266. +Upgrade to 3.01.00.095 done (stocknumber field added) +Upgrade to 3.01.00.096 done (PDF orders system preferences added and updated) +Upgrade to 3.01.00.097 done (Adding billingplace to aqbasketgroups) +Upgrade to 3.01.00.098 done (changing frameworkcode length in auth_subfield_structure) +Upgrade to 3.01.00.099 done (granular permissions for cataloging added) +Upgrade to 3.01.00.100 done (added CAS authentication system preferences) +Upgrade to 3.01.00.101 done (added OverdueNoticeBcc system preferences) +Upgrade to 3.01.00.102 done (fixed spelling error in edit_catalogue permission) +Upgrade to 3.01.00.103 done (adding patron permissions for tags tool) +Upgrade to 3.01.00.104 done ( add defaults to authorized values for MANUAL_INV and BOR_NOTES and add new default LOC authorized values for shelf to cart processing ) +Upgrade to 3.01.00.105 done (added collection and collection_tracking tables for rotating collections functionality) +Upgrade to 3.01.00.106 done (added OpacAddMastheadLibraryPulldown system preferences) +DBD::mysql::db do failed: Key column 'printer_name' doesn't exist in table at /kohadevbox/koha/installer/data/mysql/patroncards_upgrade.pl line 128. +DB ERROR: Key column 'printer_name' doesn't exist in table +Upgrade to 3.01.00.107 done (Migrated labels and patroncards tables and data to new schema.) +Upgrade to 3.01.00.108 done (added separators for csv export) +Upgrade to 3.01.00.109 done (added encoding for csv export) +Upgrade to 3.01.00.110 done (Add enrolment period date support) +Upgrade to 3.01.00.111 done (mark DBrev for 3.2-alpha release) +Upgrade to 3.01.00.112 done ( added Show Spine Label Printer on Bib Items Details preferences ) +Upgrade to 3.01.00.113 done (added two new syspref: OPACXSLTResultsDisplay and OPACXSLTDetailDisplay). You may have to go in Admin > System preference to tweak XSLT related syspref both in OPAC and Search tabs. +Upgrade to 3.01.00.114 done ( Added AutoSelfCheckAllowed, AutoSelfCheckID, and AutoShelfCheckPass system preference ) +Upgrade to 3.01.00.115 done ( Default aqorders.quantityreceived to 0 ) +Upgrade to 3.01.00.116 done (corrected default OrderPdfFormat value if still set wrong ) +Upgrade to 3.01.00.117 done (corrected ISO 639-2 language code for Portuguese) +Upgrade to 3.01.00.118 done (bug 4203: add display column to aqbudgets_planning if missing) +Upgrade to 3.01.00.119 done (Locale::Currency::Format installed.) +Upgrade to 3.01.00.120 done (bug 1080: add soundon system preference for circulation sounds) +Upgrade to 3.01.00.121 done ( Added Additional Fields to Reserves tables ) +Upgrade to 3.01.00.122 done. — Add a new system preference OAI-PMF:ConfFile +Upgrade to 3.01.00.123 done (Add granular permission for holds modification and update description of reserveforothers permission) +Upgrade to 3.01.00.124 done (bug 3242: add HOLDPLACED letter template, which is used when emailLibrarianWhenHoldIsPlaced is enabled) +Upgrade to 3.01.00.125 done (bug 3482: Printable hold and overdue notices) +Upgrade to 3.01.00.126 done (Adding ILS-DI updates and ILS-DI:AuthorizedIPs) +Upgrade to 3.01.00.127 done (bug 4190: messages in patron account did not work with branchcodes > 4) +Upgrade to 3.01.00.128 done (bug 4331: index orders by budget_id) +Upgrade to 3.01.00.129 done (Change permissions names for item batch modification / deletion) +Upgrade to 3.01.00.130 done (change reserves.expirationdate values of 0000-00-00 to NULL (bug 1532) +Upgrade to 3.01.00.131 done (adding print and feed message transport types) +Upgrade to 3.01.00.132 done (Adding index to language_descriptions table) +Upgrade to 3.01.00.133 done (bug 4405: added OverduesBlockCirc syspref to control whether circulation is blocked if a borrower has overdues) +Upgrade to 3.01.00.134 done (adding syspref DisplayMultiPlaceHold to control whether multiple holds can be placed from the search results page) +Upgrade to 3.01.00.135 done (bug 4377: added HOLD_PRINT message template) +Upgrade to 3.01.00.136 done (Adding a new permission to edit items) +Upgrade to 3.01.00.137 done (adding granular permissions for serials) +Upgrade to 3.01.00.138 done (bug 4896: removing GranularPermissions syspref; use of granular permissions is now the default) +Upgrade to 3.01.00.139 done (bug 3682: change message_name from varchar(20) to varchar(40)) +Upgrade to 3.01.00.140 done (bug 4312 TagsModeration changed from NULL to 0) +Upgrade to 3.01.00.141 done Remove upcoming events messaging option (bug 2434) +Upgrade to 3.01.00.142 done (Remove upcoming events messaging option part 2 (bug 2434)) +Upgrade to 3.01.00.143 done (Create index on authorised_values and borrower_attribute_types (bug 4139)) +Upgrade to 3.01.00.144 done (Update the 'default' to 'normal' for the IntranetBiblioDefaultView syspref (bug 5007)) +Upgrade to 3.01.00.145 done (Add index on guarantorid) +Upgrade to 3.01.00.999 done (3.2.0 release candidate) +Upgrade to 3.02.00.000 done (Add HomeOrHoldingBranchReturn system preference) +Upgrade to 3.02.00.001 done (bug 3756: remove disused system preferences) +Upgrade to 3.02.00.002 done (bug 3881: remove unused OpacPrivacy system preference) +Upgrade to 3.02.00.003 done (correct ILS-DI:AuthorizedIPs) +Upgrade to 3.02.00.004 done (3.2.0 general release) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3821. +Upgrade to 3.03.00.001 done (Make subscriptionroutinglist more strict) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3848. +Upgrade to 3.03.00.002 done (Correct language mappings) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3864. +Upgrade to 3.03.00.003 done (Add UseTablesortForCirc syspref) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3871. +Upgrade to 3.03.00.004 done (bug 5127: add default templates for suggestion status change notifications) +Upgrade to 3.03.00.005 done (Add itemBarcodeInputFilter choice libsuite8) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3911. +Upgrade to 3.03.00.006 done (Fix differences between borrowers and deletedborrowers) +Upgrade to 3.03.00.007 done (Added acq related columns to suggestions) +Upgrade to 3.03.00.008 done (adding syspref OPACNoResultsFound to control what displays when no results are found for a search in the OPAC.) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3937. +Upgrade to 3.03.00.009 done (Add IntranetUserCSS syspref) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3944. +Upgrade to 3.03.00.010 done (Fix misspelled 034r subfield in MARC21 Frameworks) +Upgrade to 3.03.00.011 done (Bug 5186: allow GST rate to be set to 0) +Upgrade to 3.03.00.012 done (Bug 2142: maxItemsInSearchResults syspref resurrected) +Upgrade to 3.03.00.013 done (added 'OpacPublic' syspref) +Upgrade to 3.03.00.014 done (Add flexible shelf browser constraints) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3983. +Upgrade to 3.03.00.016 done (OpacPrivacy reimplementation) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4014. +Upgrade to 3.03.00.017 done (Enable currency rates >= 100) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4021. +Upgrade to 3.03.00.018 done (Correct language descriptions) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4029. +Upgrade to 3.03.00.019 done (Correct language descriptions for Norwegian) +Upgrade to 3.03.00.020 done (Bug 5811: Add sysprefs controlling overriding fines) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4056. +Upgrade to 3.03.00.021 done (bug 5642: longer serial enumeration) +Upgrade to 3.03.00.022 done (Add AuthoritiesLog syspref) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4073. +Upgrade to 3.03.00.023 done (Reconcile aqbasketgroups) +Upgrade to 3.03.00.024 done (Add syspref to force whole-subfield matching on subject tracings) +Upgrade to 3.03.00.025 done (Add syspref to control if user can choose pickup branch for holds) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4103. +Upgrade to 3.03.00.026 done ( fix capitalization in message type ) +Upgrade to 3.03.00.027 done (Preferences for facet count) +Upgrade to 3.03.00.028 done (Add FacetLabelTruncationLength syspref to control facets displayed length) +Upgrade to 3.03.00.029 done (Add syspref to control if user can choose branch when making purchase suggestion) +Upgrade to 3.03.00.030 done (Add sysprefs to control custom favicons) +Upgrade to 3.03.00.031 done (Add syspref FineNotifyAtCheckin) +Upgrade to 3.03.00.032 done ( include subdivisions when generating subject tracing searches ) +Upgrade to 3.03.00.033 done (System pref StaffAuthorisedValueImages) +Upgrade to 3.03.00.034 done (Add hidelostitems preference to borrower categories) +Upgrade to 3.03.00.035 done (Move global and ceiling due dates to Circ Rules level) +Upgrade to 3.03.00.036 done ( Make COinS optional in OPAC search results ) +Upgrade to 3.03.00.037 done (Add 'Display856uAsImage' and 'OPACDisplay856uAsImage' syspref) +Upgrade to 3.03.00.038 done ( Add Self-checkout by Login system preferences ) +Upgrade to 3.03.00.039 done (Add syspref ShowReviewer) +Upgrade to 3.03.00.040 done (Add syspref UseControlNumber) +Upgrade to 3.03.00.041 done (Add sysprefs to control alternate holdings information display) +Upgrade to 3.03.00.042 done (5860 Index itemstocknumber) +Upgrade to 3.03.00.043 done ( add generic boolean YES_NO authorised_values pair ) +Upgrade to 3.03.00.044 done (adding freedeliveryplace to basketgroups) +Upgrade to 3.03.00.045 done (Remove obsolete columns from aqbooksellers and aqbudgets if needed) +Upgrade to 3.03.00.046 done (Setting NULL default value for delayn columns in table overduerules) +Upgrade to 3.03.00.047 done (Add state field to patron's addresses) +Upgrade to 3.03.00.048 done (Add state to branch address) +Upgrade to 3.03.00.049 done (adding note and manager_id fields in accountlines table) +Upgrade to 3.03.00.050 done (Adding OpacHiddenItems syspref) +Upgrade to 3.03.00.051 done (Remove spaces and dashes from message_attribute names) +Upgrade to 3.03.00.052 done (Add syspref WaitingNotifyAtCheckin) +Upgrade to 3.04.00.000 done Koha 3.4.0 release +Upgrade to 3.05.00.001 done (Adds New System preference numSearchRSSResults) +Upgrade to 3.05.00.002 done (Fix for stocknumber index) +Upgrade to 3.05.00.003 done (Adds New System preference OpacRenewalBranch) +Upgrade to 3.05.00.004 done (Add syspref ShowReviewerPhoto) +Upgrade to 3.05.00.005 done (Adds pref BasketConfirmations) +Upgrade to 3.05.00.006 done (Add syspref MARCAuthorityControlField008) +Upgrade to 3.05.00.007 done (Add syspref OpenLibraryCovers) +Add state and country to cities table corresponding to new columns in borrowers +Upgrade to 3.05.00.009 done (issues referential integrity) +Create an index on reserves to speed up holds awaiting pickup report bug 5866 +Upgrade to 3.05.00.011 done (add OPACResultsSidebar syspref (enh 6165)) +Upgrade to 3.05.00.012 done (add RecordLocalUseOnReturn syspref (enh 6403)) +Upgrade to 3.05.00.013 done (Add syspref 'OpacKohaUrl') +Modified userid column length into 75 in borrowers +Upgrade to 3.05.00.015 done (Add support for EBSCO's NoveList Select (enh 6902)) +Upgrade to 3.05.00.016 done (Add EasyAnalyticalRecords syspref) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4499. +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4499. +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4505. +Upgrade to 3.05.00.018 done (add OpacNavBottom syspref (enh 6825): if appropriate, you can split OpacNav into OpacNav and OpacNavBottom) +Upgrade to 3.05.00.019 done (remove duplicate VOKAL Book icons, bug 6862) +Upgrade to 3.05.00.020 done (Add syspref AcqViewBaskets) +Upgrade to 3.05.00.021 done (Added a display_checkout field in borrower_attribute_types table) +Upgrade to 3.05.00.022 done (6094: Fixing ModAuthority problems, add a need_merge_authorities table) +Upgrade to 3.05.00.023 done (Add syspref OpacShowRecentComments. When the preference is turned on a link to recent comments will appear in the OPAC masthead. ) +Upgrade to 3.06.00.000 done Koha 3.6.0 release +Upgrade done (Change borrowers.debarred into Date ) +Setting NULL to debarred where 0000-00-00 is stored (bug 7272) +Updating message_name in message_attributes +Upgrade to 3.07.00.004 done (Add column to suggestions table to store patrons' reasons for submitting a suggestion. ) +Upgrade to 3.07.00.005 done (BorrowerUnwantedField syspref) +Upgrade to 3.07.00.006 done (Add syspref CircAutoPrintQuickSlip to control what should happen when an empty barcode field is submitted in circulation: Display a print quick slip window (default value, 3.6 behaviour) or clear the screen (previous 3.6 behaviour). ) +Upgrade to 3.07.00.007 done alter items.material from varchar(10) to text +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4619. +Upgrade to 3.07.00.008 done (add MARC21 field 545 to framework) +Upgrade to 3.07.00.009 done (Add claims_count and claimed_date fields in aqorders table) +Upgrade to 3.07.00.010 done (Added support for local cover images) +Upgrade to 3.07.00.011 done (Added a system preference to allow renewal of Patron account either from todays date or from existing expiry date in the patrons account.) +Upgrade to 3.07.00.012 add 'AllowItemsOnHoldCheckout' syspref +Upgrade to 3.07.00.013 done (Bug 7345: Add system preference OpacExportOptions.) +RELTERMS category available for English-, French-, and Spanish-language relator terms. They are not loaded during upgrade but can be easily inserted using the provided marc21_relatorterms.sql SQL script (MARC21 only, and currently available for en, es, and fr only). +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4703. +Upgrade to 3.07.00.015 done (Added a mapping for biblioitems.editionstatement.) +Upgrade to 3.07.00.016 done (Added index on items.itemcallnumber) +Upgrade to 3.07.00.017 done (Add sysprefs to control transfer when cancel all waiting holds) +Upgrade to 3.07.00.018 done ( adding offline operations table ) +Upgrade to 3.07.00.019 done ( Adding additional options for the display of commenter's identity in the OPAC: Full name, first name, last name, first name and last name first initial, username, or no information) +Upgrade to 3.07.00.020 done (Bug 3516: Add the option to show patron images in the OPAC.) +Upgrade to 3.07.00.021 done (Enhancement 7284, improved authority matching, see http://wiki.koha-community.org/wiki/Bug7284_authority_matching_improvement wiki page for configuration update needed) +Upgrade to 3.07.00.022 done (Bug 7493 - Add constraint linking OPAC comment biblionumber to biblio, OPAC comment borrowernumber to borrowers.) +Upgrade to 3.07.00.023 done (Add branchcode and is_html to letter table; Default ISSUESLIP, RESERVESLIP and TRANSFERSLIP letters; Add NoticeCSS and SlipCSS sysprefs) +Upgrade to 3.07.00.024 done (Added system preference ExpireReservesMaxPickUpDelay, system preference ExpireReservesMaxPickUpDelayCharge, add reseves.charge_if_expired) +Upgrade to 3.07.00.025 done (Correct table name for local cover images if needed. ) +Upgrade to 3.07.00.026 done (Add syspref CalendarFirstDayOfWeek used to select the first day of week to use in the calendar. ) +Upgrade to 3.07.00.027 done (Added system preference RoutingListNote for adding a general note to all routing lists.) +Upgrade to 3.07.00.028 done (Bug 6296 New System preference AllowPKIAuth) +Upgrade to 3.07.00.029 done (Atomic update for OAI-PMH sets management) +Upgrade to 3.07.00.030 done (Atomic update for OAI-PMH sets management) +Upgrade to 3.07.00.031 done (Add syspref to tell Koha if ICU indexing is in use for Zebra or not.) +Upgrade to 3.07.00.032 done (BZ7310: Improving list permissions) +Upgrade to 3.07.00.033 done add opac_info to branches +Upgrade to 3.07.00.034 done (New fields category_code and class in borrower_attribute_types table) +Upgrade to 3.07.00.035 done (Setting up issues and accountlines tables for hourly loans) +Upgrade to 3.07.00.036 done (New timeout field in z3950servers) +Upgrade to 3.07.00.037 done (Add new field maxlength to marc_subfield_structure) +Upgrade to 3.07.00.038 done (Added system preference 'UniqueItemFields') +Upgrade to 3.07.00.039 done (added syspref and table for babeltheque (Babeltheque_url_js, babeltheque)) +Upgrade to 3.07.00.040 done (added syspref SocialNetworks, to display facebook/ggl+ and other buttons) +Upgrade to 3.07.00.041 done (Add system preference SubscriptionDuplicateDroppedInput) +Upgrade to 3.07.00.042 done (Add suspend fields to reserves table, add syspref AutoResumeSuspendedHolds) +Upgrade to 3.07.00.043 done (XSLT systempreference takes a path to file rather than YesNo) +Upgrade to 3.07.00.044 done (Add deliverytime field in aqbooksellers table)Upgrade to 3.07.00.045 done (Add 'webservice' to batch_type enum) +Upgrade to 3.07.00.046 done (Setting up issues tables for hourly loans (lengthunit fix)) +Upgrade to 3.07.00.047 done (items_location and items_ccode indexes added for ShelfBrowser) +Upgrade to 3.07.00.048 done (Add 'ratings' table and 'OpacStarRatings' syspref) +Upgrade to 3.07.00.049 done (Add system preference OpacBrowseResults )) +Upgrade to 3.08.00.000 done +Upgrade to 3.09.00.001 done. (Bug 8002: Update patron attribute types table to allow NULL category_code) +Upgrade to 3.09.00.002 done (Added cache_expiry and public fields in +saved_reports table.) +Upgrade to 3.09.00.003 done (Added SvcMaxReportRows syspref) +Upgrade to 3.09.00.004 done (Adds permissions flag for access to the patron modifications tool) +Upgrade to 3.09.00.005 done (Adding Quote of the Day Option.) +Upgrade to 3.09.00.006 done (Changed system preference OPACDisplayRequestPriority -> OPACShowHoldQueueDetails) +Upgrade to 3.09.00.007 done (Insert ReservesControlBranch systempreference into systempreferences table ) +Upgrade to 3.09.00.008 done (redefine the field id as PRIMARY KEY of sessions) +Upgrade to 3.09.00.009 done (redefine the field branchcode as PRIMARY KEY of branches) +Upgrade to 3.09.00.010 done (Add system preference issuelostitem )) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 5371. +Upgrade to 3.09.00.011 done (Adding ean in biblioitems and deletedbiblioitems) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 5375. +Upgrade to 3.09.00.012 done (Add system preference OpacBrowseResults )) +Upgrade to 3.09.00.013 done (Add system preference DefaultLanguageField008)) +Upgrade done (Support for Talking Tech i-tiva phone notification system) +Upgrade to 3.09.00.015 done (Add System preference StatisticsFields) +Upgrade to 3.09.00.016 done (Add syspref OPACShowBarcode) +Upgrade to 3.09.00.017 done (Add customizable OpacNavRight region to the OPAC main page) +Upgrade to 3.09.00.018 done (Add aqbudgetborrowers table) +Upgrade to 3.09.00.019 done (Add OPACShowUnusedAuthorities system preference) +Upgrade to 3.09.00.020 done (Added borrow_files table, EnableBorrowerFiles syspref) +Upgrade to 3.09.00.021 done (Add syspref UpdateTotalIssuesOnCirc) +Upgrade to 3.09.00.022 done (Change search_history.query_cgi type to text. bug 5981) +Upgrade to 3.09.00.023 done (Add system preference SearchEngine ) +Upgrade to 3.09.00.024 done (Add system preference IntranetSlipPrinterJS)) +Upgrade to 3.09.00.025 done (add reserve_id to reserves & old_reserves tables) +Upgrade to 3.09.00.026 done (Added parameters subpermissions) +Upgrade to 3.09.00.027 done (Bug 7420 add overduefinescap to circulation matrix) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 5623. +Upgrade to 3.09.00.028 done (Add thesaurus links for MARC21/NORMARC) +Upgrade to 3.09.00.029 done (Add itemBarcodeInputFilter choice EAN13) +Upgrade to 3.09.00.029 done ( Added EAN13 barcode autogeneration sequence ) +Upgrade to 3.09.00.030 done (BZ 8263: Make OPAC stylesheet preferences more consistent) +Upgrade to 3.09.00.031 done ('Remove preferences controlling broken Amazon features (Bug 8679') +Upgrade to 3.09.00.032 done (Bug 8657 - Default sort by call number does not work. Correcting system preference value.) +Upgrade to 3.09.00.033 done (Add OpacSuppressionByIPRange syspref) +Upgrade to 3.09.00.034 done (Bug 8207: correct typo in authority types) +Upgrade to 3.09.00.035 done (Adding PrefillItem and SubfieldsToUseWhenPrefill sysprefs) +Upgrade to 3.09.00.036 done (Add colum agerestriction to biblioitems and deletedbiblioitems, add system preferences AgeRestrictionMarker and AgeRestrictionOverride) +Upgrade to 3.09.00.037 done (creating `transport_cost` table; adding UseTransportCostMatrix systempref, in circulation) +Upgrade to 3.09.00.038 done (Increase the maximum size of a borrower attribute value) +Upgrade to 3.09.00.039 done (Add system preference DidYouMeanFromAuthorities) +Upgrade to 3.09.00.040 done (Add IncludeSeeFromInSearches system preference) +Upgrade to 3.09.00.041 done (Add system preference ExportRemoveFields) +Upgrade to 3.09.00.042 done (Adds New System preference ExportWithCsvProfile) +Upgrade to 3.09.00.043 done (Adding parent_ordernumber in aqorders) +Upgrade done ( Added Collection Code to Statistics table. ) +Upgrade to 3.09.00.045 done. (Bug 8002: Update patron attribute types table from varchar(1) to varchar(10) category_code) +Warning to Koha System Administrators: If you use borrower attributes defined by borrower categories, you have to check your configuration. A bug may have removed your attribute links to borrower categories. +Please check, and fix it if necessary.Upgrade to 3.09.00.046 done (adding accountlines_id field in accountlines table) +Upgrade to 3.09.00.047 done: adding AllowReturnToBranch syspref (bug 6151)Upgrade to 3.09.00.048 done (Raise the length of Authorised Values descriptions) +Upgrade to 3.09.00.049 done (Add OPACMobileUserCSS, OpacMainUserBlockMobile, OpacShowLibrariesPulldownMobile and OpacShowFiltersPulldownMobile sysprefs) +Upgrade to 3.09.00.050 done saved_sql new fields report_group and report_area; authorised_values.category 16 char +Upgrade to 3.09.00.051 done (Add aqinvoices table) +Upgrade to 3.09.00.052 done (Add systempreferences to decrease loan length on high demand items decreaseLoanHighHolds, decreaseLoanHighHoldsValue and decreaseLoanHighHoldsDuration) +Upgrade to 3.09.00.053 done (Added support for staging authorities) +Upgrade to 3.09.00.054 done (Change column name in aqorders gst --> gstrate) +Upgrade to 3.09.00.055 done (Add discount field in aqorders table) +Upgrade to 3.09.00.056 done (Add system preference AuthDisplayHierarchy) +Upgrade to 3.09.00.057 done (Bug 5356: Added billingplace, deliveryplace to the aqbasket table) +Upgrade to 3.09.00.058 done (Add Did You Mean? configuration) +Upgrade to 3.09.00.059 done (Add system preference BlockReturnOfWithdrawnItems) +Upgrade to 3.09.00.060 done (Added HoldsToPullStartDate syspref) +Upgrade to 3.09.00.061 done (Fixes Bug 5409, Set the syspref value to 1 if it is itemdetails and 0 if it is statuses, leaving it alone if it is already 1 or 0 and change the type of the syspref to YesNo.) +Upgrade to 3.09.00.062 done (Disable obsolete NoZebra and QueryRemoveStopwords sysprefs) +Use of uninitialized value $gist_syspref in split at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 6076. +Upgrade to 3.09.00.063 done (Bug 8832, Set the syspref gist with the existing values) +Upgrade to 3.09.00.064 done (Bug 6428: Added coded_location_qualifier to the items table) +Upgrade to 3.09.00.065 done (Bug 6428: Added coded_location_qualifier to the deleteditems table) +Upgrade to 3.09.00.066 done (Bug 9107: remove DidYouMeanFromAuthorities syspref) +Upgrade to 3.09.00.067 done (Bug 9064: statistics.ccode potentially wrongly defined) +Upgrade to 3.10.00.00 done (release tag) +Upgrade to 3.11.00.001 done (Bug 2832 - Add alphabet syspref) +Upgrade to 3.11.00.002 done (Bug 9030: Add constraint on aqorders_items.ordernumber) +Upgrade to 3.11.00.003 done (Bug 7189: Add system preference RefundLostItemFeeOnReturn) +Upgrade to 3.11.00.004 done (Bug 8782: Add field subscription.closed) +Upgrade to 3.11.00.005 done (Bug 7919: Display of values depending on the connexion library) +Upgrade to 3.11.00.006 done (Bug 9167: Update the virtualshelves.sortfield column with 'copyrightdate' if needed) +Upgrade to 3.11.00.007 done (Bug 9056: add German and a couple of French translations to language_descriptions) +Upgrade to 3.11.00.008 done (Bug 7067: Add Patron Self Registration) +Upgrade to 3.11.00.009 done (Bug 7674: Add systempreferences SeparateHoldings, SeparateHoldingsBranch, OpacSeparateHoldings and OpacSeparateHoldingsBranch) +Upgrade to 3.11.00.010 done (Bug 9151 - Renewal notice according to patron alert preferences) +Upgrade to 3.11.00.011 done (Bug 8377: Add HTML5MediaEnabled and HTML5MediaExtensions sysprefs) +Upgrade to 3.11.00.012 done (Bug 9206: Only allow place holds in records that the patron don't have in his possession) +Upgrade to 3.11.00.013 done (Bug 9162 - Add a system preference to set which notes fields appears on title notes/description separator) +Upgrade to 3.11.00.014 done (Bug 9009: Add SCOUserCSS and SCOUserJS sysprefs) +Upgrade to 3.11.00.015 done (Add sysprefs RentalsInNoissuesCharge and ManInvInNoissuesCharge.) +Upgrade to 3.11.00.016 done (Bug 9382 (updated with bug 9745) - refresh permission descriptions to make more sense) +Upgrade to 3.11.00.017 done (Add IDreamBooks enhanced content) +Upgrade to 3.11.00.018 done (Bug 9395: Problem with callnumber and standard number search in OPAC and Staff Client) +Upgrade to 3.11.00.019 done (Bug 9145 - Add syspref UNIMARCAuthorityField100) +Upgrade to 3.11.00.020 done (Bug 8347 - Koha forces UNIMARC 100 field code language to 'fre') +Upgrade to 3.11.00.021 done (Bug 5888 - Subject search pop-up for the OPAC) +Upgrade to 3.11.00.022 done (Bug 9587 - Allow login via Persona) +Upgrade to 3.11.00.023 done (Bug 9520 - Update default LOC Z39.50 target) +Upgrade to 3.11.00.024 done (Bug 5079: Add OpacItemLocation syspref) +Upgrade to 3.11.00.025 done (Adds feature Bug 8917, the ability to track links clicked) +Upgrade to 3.11.00.026 done (Bug 9207: Add new index batch_id_record_type to import_records) +Upgrade to 3.11.00.027 done ( Add circ permission overdues_report ) +Upgrade to 3.11.00.028 done (Bug 9756 - Patron self registration missing the system preference PatronSelfRegistrationAdditionalInstructions) +Upgrade to 3.11.00.029 done (Bug 9239: Make it possible for Koha to use QueryParser) +Upgrade to 3.11.00.030 done (Add system preference FinesIncludeGracePeriod) +Upgrade to 3.11.00.100 done (3.12-alpha release) +Upgrade to 3.11.00.101 done (Bug 9341: Problem with UNIMARC authors facets) +Upgrade to 3.11.00.102 done (Remove deprecated NoZebra and QueryRemoveStopwords sysprefs) +Upgrade to 3.11.00.103 done (Bug 9827 - Remove 'insecure' system preference) +Upgrade to 3.11.00.104 done (3.12-alpha2 release) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 6614. +Upgrade to 3.11.00.105 done (Bug 9353: Missing subfields on MARC21 frameworks) +Upgrade to 3.11.00.106 done (Bug 7804: Added plugin system.) +Upgrade to 3.11.00.107 done (Bug 9014: Add syspref TimeFormat) +Upgrade to 3.11.00.108 done (Bug 7241: Fix on circulation logs) +WARNING about bug 7241: to partially correct the broken logs, the log history is filled with the first found item for each biblio. +Upgrade to 3.11.00.109 done (Bug 9403: Add DisplayIconsXSLT) +Upgrade to 3.11.00.110 done (Bug 8220 - Allow koc uploads to go to process queue) +Upgrade to 3.11.00.111 done (use new <> syntax in notices) +Upgrade to 3.11.00.112 done (Bug 8365: Add colum issuingrules.renewalperiod) +Upgrade to 3.11.00.113 done (Bug 9257 - Add groups to normal search pulldown) +Upgrade to 3.11.00.115 done (Bug 7740: Add syspref HighlightOwnItemsOnOPAC) +Upgrade to 3.11.00.116 done (Bug 5343: table aqorders: DROP serialid and subscription fields and ADD subscriptionid, table subscription: ADD reneweddate) +Upgrade to 3.11.00.200 done (3.12-beta1 release) +Upgrade to 3.11.00.201 done (Bug 9498 - Update encoding for Norwegian sample Z39.50 servers) +Upgrade to 3.11.00.202 done (Bug 9381: Add Catalan laguage) +Upgrade to 3.11.00.203 done (Bug 2046 - increasing title column length for suggestions) +Upgrade to 3.11.00.300 done (3.12-beta3 release) +Upgrade to 3.11.00.301 done (Bug 9681: Add some database indexes) +Upgrade to 3.12.00.000 done (3.12.0 release) +Upgrade to 3.13.00.000 done (start the journey to Koha Pi) +Upgrade to 3.13.00.001 done (Add Course Reserves ( system preference UseCourseReserves )) +Upgrade to 3.13.00.002 done (Bug 10080 - Change system pref IndependantBranches to IndependentBranches) +Upgrade to 3.13.00.003 done (Bug 7718 - Remove itemnumber column from serials table) +Upgrade to 3.13.00.004 done (Bug 9722: Allow users to add notes when placing a hold in OPAC) +Upgrade to 3.13.00.005 done (Bug 10052: Make intranetstylesheet and intranetcolorstylesheet behave exactly like their opac counterparts) +Upgrade to 3.13.00.006 done (Bug 10120: Fines on item return controlled by a systempreference) +Upgrade to 3.13.00.007 done (Bug 10343: Rename OpacShowHoldNotes to OpacHoldNotes) +Upgrade to 3.13.00.008 done (Bug 10443: make sure borrower_files table exists) +Upgrade to 3.13.00.009 done (Bug 9987 - Drop column aqorders.biblioitemnumber) +Upgrade to 3.13.00.010 done (Bug 10366 - Add system preference to enabling warning librarian when invoice is duplicated) +Upgrade to 3.13.00.011 done (Bug 9519: Wrong language code for Italian in the advanced search language limitations) +Upgrade to 3.13.00.012 done (Bug 10490: Correct datatype for overduefinescap in issuingrules) +Upgrade to 3.13.00.013 done (Bug 9576: add AllowTooManyOverride syspref to enable or disable issue limit confirmation) +Upgrade to 3.13.00.014 done (Bug 10604: correct width of courses.department and courses.term) +Upgrade to 3.13.00.015 done (Bug 7494: Add itemBarcodeFallbackSearch syspref) +Upgrade to 3.13.00.016 done (Bug 10550 - Fix database typo wthdrawn) +Upgrade to 3.13.00.017 done (Bug 10320 - Show results from library's OverDrive collection in OPAC search) +Upgrade to 3.13.00.018 done (Bug 5349: Add aqorders_transfers table) +Upgrade to 3.13.00.019 done (Bug 10513 - Light up a warning/message when returning a chosen item type) +Upgrade to 3.13.00.020 done (Bug 7639: system preferences to forgive fines on lost items) +Upgrade to 3.13.00.021 done (Bug 9761: Add ConfirmFutureHolds pref) +Upgrade to 3.13.00.022 done (Bug 10687 - Delete erroneous tags 68a and 68b on default MARC21 auth framework) +Upgrade to 3.13.00.023 done (Bug 9611 upgrading password storage system) +Upgrade to 3.13.00.024 done (Bug 10096 - Add a Z39.50 interface for authority searching) +Upgrade to 3.13.00.025 done (Bug 9295: OAI notequal: add operator column to OAI mappings table) +Upgrade to 3.13.00.026 done (Bug 10602: Add the column auth_subfield_structure.defaultvalue) +Upgrade to 3.13.00.027 done (Bug 10240: Add syspref AllowOfflineCirculation) +Upgrade to 3.13.00.028 done (Bug 10853: Add new field export_format.type and rename export_format.marcfields with export_format.content) +Upgrade to 3.13.00.029 done (Bug 10854: Add the default CSV profile for claiming issues) +Upgrade to 3.13.00.030 done (Bug 10636 - patronimage should have borrowernumber as PK, not cardnumber) +Upgrade to 3.13.00.031 done (Bug 10565 - Add a 'Patron List' feature for storing and manipulating collections of patrons) +Upgrade to 3.13.00.032 done (Bug 5336: Add the new column aqorders.orderstatus) +Upgrade to 3.13.00.033 done (Bug 7688: add subscription_frequencies and subscription_numberpatterns tables) +Upgrade to 3.13.00.034 done (Bug 7131 - way to overlay items in in marc import) +Upgrade to 3.13.00.035 done (Bug 2720 - Overdues which debar automatically should undebar automatically when returned) +Upgrade to 3.13.00.036 done (Add system preference StaffDetailItemSelection) +Upgrade to 3.13.00.037 done (Bug 10572: Add phone to message_transport_types table for new installs) +Upgrade to 3.13.00.038 done (Bug 8435: Add superserials permission) +Upgrade to 3.13.00.039 done (Add branch and users list to baskets. New permission order_manage_all) +Upgrade to 3.13.00.040 done ( Bug 8015: Added tables for MARC Modification Framework ) +Upgrade to 3.13.00.041 done (Bug 10986: Added AcqItemSetSubfieldsWhenReceived syspref) +Upgrade to 3.13.00.042 done (Koha 3.14 beta) +Upgrade to 3.13.00.043 done (Bug 11196: Add system preference SearchEngine if missing ) +Upgrade to 3.14.00.000 done (3.14.0 release) +Upgrade to 3.15.00.000 done (the road goes ever on) +Upgrade to 3.15.00.001 done (Bug 11040: Add option to print full slip when checking out a null barcode) +Upgrade to 3.15.00.002 done (Bug 11275: alter deleteditems.materials from varchar(10) to text) +Upgrade to 3.15.00.003 done (Bug 2546: Update fine descriptions) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 7853. +Upgrade to 3.15.00.004 done (Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB update) +Upgrade to 3.15.00.005 done (Bug 8230: Add AcquisitionDetails system preference) +Upgrade to 3.15.00.006 done (Bug 11249 - Add DB indexes on borrower names) +Upgrade to 3.15.00.007 done (Bug 9673 - Track when items are marked as lost or withdrawn) +Upgrade to 3.15.00.008 done (Bug 11384) - change name of collections_tracker.ctId column) +Upgrade to 3.15.00.009 done (Bug 11391) - drop default value on suggestions.suggesteddate column) +Upgrade to 3.15.00.010 done (Bug 6331: remove obsolete column in deleteditems.marc) +Upgrade to 3.15.00.011 done (Bug 8018: set 9999 as default max length for subfields) +Upgrade to 3.15.00.012 done (Bug 10863 - Add permissions force_checkout and manage_restrictions) +Upgrade to 3.15.00.013 done (Bug 11237: Update explanation and default value for AcqItemSetSubfieldsWhenReceived syspref) +Upgrade to 3.15.00.014 done (Bug 11415: add system preference for automatic self checkout receipt printing) +Upgrade to 3.15.00.015 done (Bug 10907: Add OpacSuggestionManagedBy system preference) +Upgrade to 3.15.00.016 done (Bug 11268 - Biblioitems URL field is too small for some URLs) +Upgrade to 3.15.00.017 done (Bug 11611 - fix possible confusion between UNIMARC and MARC21 in some sysprefs) +Upgrade to 3.15.00.018 done (Bug 7372: Move road types from the roadtype table to the ROADTYPE authorised values) +Upgrade to 3.15.00.019 done (Bug 11256: Add system preference OpacMaxItemsToDisplay) +Upgrade to 3.15.00.020 done (Bug 11343: Add system preference MaxItemsForBatch ) +Upgrade to 3.15.00.021 done (Bug 3445: Add indexes to action_logs table) +Upgrade to 3.15.00.022 done (Bug 11751: Remove memberofinstitytion system preference) +Upgrade to 3.15.00.023 done (Bug 10861: Add CardnumberLength syspref) +Upgrade to 3.15.00.024 done (Bug 10012 - remove last vestiges of NoZebra) +Upgrade to 3.15.00.025 done (Bug 11928 - remove unused table) +Upgrade to 3.15.00.026 done (Bug 11973 - Fix Armenian language description) +Upgrade to 3.15.00.027 done (Bug 7567: Add branchcode to opac_news) +Upgrade to 3.15.00.028 done (Bug 7413: Allow OPAC renewal x days before due date) +Upgrade to 3.15.00.029 done (Bug 11846 - correct borrower_debarments with expiration 9999-12-31) +Upgrade to 3.15.00.030 done (Bug 12052: Add OPACMySummaryNote syspref) +Upgrade to 3.15.00.031 done (Bug 9448 - Add separate permission for writing off fees) +Upgrade to 3.15.00.032 done (Bug 9416 - In each order, add a new note made for the vendor) +Upgrade to 3.15.00.033 done (Bug 10951: Add NoLoginInstructions pref) +Upgrade to 3.15.00.034 done (Bug 10986: system preferences to limit languages in advanced search ) +Upgrade to 3.15.00.035 done (Bug 9032: Share a list) +Upgrade to 3.15.00.036 done (Bug 10859 - Add system preference AllowMultipleIssuesOnABiblio) +Upgrade to 3.15.00.037 done (Bug 11351 - Add support for SIP2 media type) +Upgrade to 3.15.00.038 done (Bug 11334 - Add facet for home library) +Upgrade done (Bug 9016: Adds multi transport types management for notices) +Upgrade to 3.15.00.040 done (Bug 10845: Multi transport types for holds) +Upgrade to 3.15.00.041 done (Bug 11867: Update letters *_PHONE) +Upgrade to 3.15.00.042 done (Bug 10694 - Allow arbitrary backdating of returns) +Upgrade to 3.15.00.043 done (Bug 7180: Added MarcFieldsToOrder syspref) +Upgrade to 3.15.00.044 done (Added isocode to the currency table) +Upgraded to 3.15.00.045 done (Bug 6739 - expired patrons not blocked from opac actions) +Upgrade to 3.15.00.046 done (Bug 10807 - Add db field search_history.type) +Upgrade to 3.15.00.047 done (Bug 10862: Add EnableSearchHistory syspref) +Upgrade to 3.15.00.048 done (Bug 10195: Records hidden with OpacSuppression can still be accessed) +Upgrade to 3.15.00.049 done (Bug 5377 - Biblioitems isbn and issn fields too small for multiple ISBN and ISSN) +Upgrade to 3.15.00.050 done (Bug 10500 - Improve isbn matching when importing records) +Upgrade to 3.15.00.051 done (Koha 3.16 beta) +Upgrade to 3.15.00.052 done (Koha 3.16 RC) +Upgrade to 3.16.00.000 done (3.16.0 release) +Upgrade to 3.17.00.000 done (there is no time to rest on our laurels) +Upgrade to 3.17.00.001 done (Bug 10330 - Rename system preference authoritysep to AuthoritySeparator) +Upgrade to 3.17.00.002 done (Bug 3050 - Add an option to upload scanned invoices) +Upgrade to 3.17.00.003 done (Bug 7825 - Changed OPACItemHolds syspref to Choice) +Upgrade to 3.17.00.004 done (Bug 6254 - can't set patron privacy by default) +Upgrade to 3.17.00.005 done (Bug 12230: Add new issuing rule maxsuspensiondays) +Upgrade to 3.17.00.006 done (Bug 7720 - Ambiguity in OPAC Details location.) +Upgrade to 3.17.00.007 done (Bug 11629 - Add ability to update not for loan status on checkin) +Upgrade to 3.17.00.008 done (Bug 11169 - Add OPACAcquisitionDetails syspref) +Upgrade to 3.17.00.009 done (Bug 11703 - Remove UseTablesortForCirc syspref) +Upgrade to 3.17.00.010 done (Bug 11347 - PROG/CCSR deprecation: Remove opacsmallimage system preference) +Upgrade to 3.17.00.011 done (Bug 12649: Add Croatian language) +Upgrade to 3.17.00.012 done ( Bug 12512 - PROG/CCSR deprecation: Remove OpacShowFiltersPulldownMobile system preference ) +Upgrade to 3.17.00.013 done (Re-add system preference maxreserves) +Upgrade to 3.17.00.014 done (Bug 12529 - Adding a syspref to allow the overdue notices to consider the calendar when generating notices) +Upgrade to 3.17.00.015 done (Bug 10212 - Create new table columns_settings) +Upgrade to 3.17.00.016 done (Bug 10402: Move bookseller contacts to separate table) +Upgrade to 3.17.00.017 done (Bug 6536: Z3950 improvements) +Upgrade to 3.17.00.018 done (Bug 12205: Add HoldsInNoissuesCharge systempreference) +Upgrade to 3.17.00.019 done (Bug 6149: Operator highlighted in search results) +Upgrade to 3.17.00.020 done (Bug 8735 - Expire holds waiting only on days the library is open) +Upgrade to 3.17.00.021 done (Bug 12582 - Control of branch displayed in search results linked to HomeOrHoldingBranch) +Upgrade to 3.17.00.022 done (Bug 7817: Check for permanent_location) +Upgrade to 3.17.00.023 done (Bug 11169 - Add AcqItemSetSubfieldsWhenReceiptIsCancelled syspref) +Upgrade to 3.17.00.024 done (Bug 11577: [ENH] Automatic renewal feature) +Upgrade to 3.17.00.025 done (Bug 12728: Checked syspref StatisticsFields) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 8835. +Upgrade to 3.17.00.027 done (Bug 12538 - Remove SearchEngine syspref) +Upgrade to 3.17.00.028 done (Bug 12296 - search box replaceable with a system preference) +Upgrade to 3.17.00.029 done (Bug 12424 - ddc sorting of call numbers truncates long Cutter parts) +Upgrade to 3.17.00.030 done (Bug 11926: Add UsageStats systempreferences (HEA)) +Upgrade to 3.17.00.031 done (Bug 2969: Report Name should be mandatory for saved reports) +Upgrade to 3.17.00.032 done (Bug 9530: Adding replyto and returnpath addresses.) +Upgrade to 3.17.00.033 done (Bug 13088 - Allow the user to specify a max amount of facets to show) +Upgrade to 3.17.00.034 done (Bug 11007 - DROP column aqorders.cancelledby) +Upgrade to 3.17.00.035 done (Bug 5342: Add claims_count field in serial table) +Upgrade to 3.17.00.036 done ( Bug 12513 - PROG/CCSR deprecation: Remove OpacShowLibrariesPulldownMobile system preference ) +Upgrade to 3.17.00.037 done ( Bug 12246 - PROG/CCSR deprecation: Remove OpacMainUserBlockMobile system preference ) +Upgrade to 3.17.00.038 done ( Bug 12245 - PROG/CCSR deprecation: Remove OPACMobileUserCSS system preference ) +Upgrade to 3.17.00.039 done (Bug 12539 - PROG/CCSR deprecation: Remove hardcoded theme from C4/Templates.pm) +Upgrade to 3.17.00.040 done (Bug 12223: 'prog' and 'ccsr' themes removed) +Upgrade to 3.17.00.041 done (Bug 11346: Deprecate the 'prog' and 'CCSR' themes) +Upgrade to 3.17.00.042 done (Bug 12494: Remove yuipath system preference) +Upgrade to 3.17.00.043 done (Bug 7162: Add aqorders.cancellationreason) +Upgrade to 3.17.00.044 done (Bug 10860: Add new system preference OnSiteCheckouts + fields [old_]issues.onsite_checkout) +Upgrade to 3.17.00.045 done (Bug 11126 - Make the holds system optionally give precedence to local holds) +Upgrade to 3.17.00.046 done (Bug 11425: Add items_search_fields table) +Upgrade to 3.17.00.047 done (Bug 8836 - Resurrect Rotating Collections) +Upgrade to 3.17.00.048 done (Bug 12448 - Add RentalFeesCheckoutConfirmation syspref) +Upgrade to 3.17.00.049 done (Bug 12250: Update descriptions for languages, scripts and regions) +Upgrade to 3.17.00.050 done (Bug 12403: Add permission tools_records_batchdelitem) +Upgrade to 3.17.00.051 done (Bug 13211: Added system preferences GoogleIndicTransliteration on the OPAC) +Upgrade to 3.17.00.052 done (Bug 9043: Add system preference OpacAdvSearchOptions and OpacAdvSearchMoreOptions) +Upgrade to 3.17.00.053 done (Bug 7673: Adds 2 new prefs (SubfieldsToAllowForRestrictedEditing and SubfieldsToAllowForRestrictedBatchmod) and 3 new permissions (edit_items_restricted and delete_all_items and items_batchmod_restricted)) +Upgrade to 3.17.00.054 done (Bug 11634 - Allow renewal of item with unfilled holds if other available items can fill those holds) +Upgrade to 3.17.00.055 done (Bug 11401 - Add support for Norwegian national library card) +Upgrade to 3.17.00.056 done (Bug 9043 - Update the values for OpacAdvSearchOptions and OpacAdvSearchOptions) +Upgrade to 3.17.00.057 done (Koha 3.18 beta) +Upgrade to 3.17.00.058 done (Bug 8337: System preferences for longoverdue cron) +Upgrade to 3.17.00.059 done (Bug 10749: Fix typo in budget_add_del permission description) +Upgrade to 3.17.00.060 done (Bug 12298: Delete the 'feed' message transport type (deleted!)) +Upgrade to 3.18.00.000 done (3.18.0 release) +Upgrade to 3.19.00.000 done (there's life after 3.18) +Upgrade to 3.19.00.001 done (Bug 13436: Add more options to UsageStatsLibraryType) +upgrade to 3.19.00.002 done (Bug 10753: replace __ANY__ with empty string in suggestions.branchcode) +Upgrade to 3.19.00.003 done (Bug 1861: Unique patrons logins not (totally) enforced) +Upgrade to 3.19.00.004 done (Bug 13346: OpacExportOptions is now multiple) +Upgrade to 3.19.00.005 done (Bug 13379: Modify authorised_values.category to varchar(32)) +Upgrade to 3.19.00.006 done (Bug 11944: Convert DB tables to utf8_unicode_ci) +Use of uninitialized value in numeric gt (>) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 9774. +Use of uninitialized value in numeric gt (>) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 9799. +Upgrade to 3.19.00.008 done (Bug 12601: Add new foreign key aqorders.budget_id) +Upgrade to 3.19.00.009 done (Bug 13007: Add new foreign key suggestions.budgetid) +Upgrade to 3.19.00.010 done (Bug 5511: SessionRestrictionByIP) +Upgrade to 3.19.00.011 done (Bug 13417: Add permission to delete public lists) +Upgrade to 3.19.00.012 done (Bug 13523 Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES) +Upgrade to 3.19.00.013 done (Bug 11395: Add permission tools_records_batchmod) +Upgrade to 3.19.00.014 done (Bug 12648: Add letter ACQ_NOTIF_ON_RECEIV ) +Upgrade to 3.19.00.015 done (Bug 11430: Add primary key for search_history) +Upgrade to 3.19.00.016 done (Bug 13380: Add the ORDER_CANCELLATION_REASON authorised value) +Upgrade to 3.19.00.017 done (Bug 5786: Move AllowOnShelfHolds to circulation matrix; Move OPACItemHolds system preference to circulation matrix) +Upgrade to 3.19.00.018 done (Bug 10328: Rename opaccolorstylesheet to OpacAdditionalStylesheet +Upgrade to 3.19.00.019 done (Bug 9580: Cover image from Coce, a remote image URL cache) +Upgrade to 3.19.00.020 done (Bug 11008: DROP column aqorders.supplierreference) +Upgrade to 3.19.00.021 done (Bug 2806: Remove issuingbranch columns) +Upgrade to 3.19.00.022 done (Bug 13006: Drop column suggestion.mailoverseeing) +Upgrade to 3.19.00.023 done (Bug 13497: Remove the AddPatronLists system preferences) +Upgrade to 3.19.00.024 done (Bug 13539: Remove table patroncards from database as it's no longer in use) +Upgrade to 3.19.00.025 done (Bug 13528: Add the SearchWithISBNVariations syspref) +Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 10064. +Upgrade to 3.19.00.026 done (Bug 13322: Update MARC21 frameworks to Update No. 19 - October 2014) +Upgrade to 3.19.00.027 done (Bug 4222: Nonpublic note not appearing in the staff client) Please check each of your frameworks to ensure your non-public item notes are mapped to items.itemnotes_nonpublic. After doing so please have your administrator run misc/batchRebuildItemsTables.pl ) +Upgrade to 3.19.00.028 done (Bug 13790: Add unique id issue_id to issues and oldissues tables) +Upgrade to 3.19.00.029 done (Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT) +Upgrade to 3.19.00.030 done (Bug 14030: Add Georgian language and fix Kannada language code) +Upgrade to 3.19.00.031 done (Bug 8992: Add system preference IdRef)) +Upgrade to 3.19.00.032 done (Bug 4041: Address Format as a I18N/L10N system preference +Upgrade to 3.19.00.033 done (Bug 11165: Update auth_header.datemodified when updated) +Upgrade to 3.19.00.034 done (Bug 13984: CardnumberLength syspref missing on some setups +Upgrade to 3.19.00.035 done (Bug 8007: Add System Preferences useDischarge, the discharge notice and the new table discharges) +Upgrade to 3.19.00.036 done (Bug 13889: Add cron jobs information to system log) +Upgrade to 3.19.00.037 done (Bug 13810: Change collate for tagsubfield (utf8_bin)) +Upgrade to 3.19.00.038 done (Bug 13421: Add DB field virtualshelves.created_on) +Upgrade to 3.19.00.039 done (Koha 3.20 beta) +Upgrade to 3.19.00.040 done (Bug 11006: Drop column aqorders.totalamount) +Upgrade to 3.19.00.041 done (Bug 14132: suggestions table is missing indexes) +Upgrade to 3.19.00.042 done (Bug 8480: Add foreign key on auth_subfield_structure.authtypecode) +Upgrade to 3.19.00.043 done (Bug 5338: Add Serial to the report groups if does not exist) +Upgrade to 3.20.00.000 done (Koha 3.20) +Upgrade to 3.21.00.000 done (El tiempo vuela, un nuevo ciclo comienza.) +Upgrade to 3.21.00.001 done (Bug 12160: Rename intranetuserjs to IntranetUserJS) +Upgrade to 3.21.00.002 done (Bug 12160: Rename opacuserjs to OPACUserJS) +Upgrade to 3.21.00.003 done (Bug 14285: Add new region India) +Upgrade to 3.21.00.004 done (Bug 5010: Fix OPACBaseURL to include protocol) +Upgrade to 3.21.00.005 done (Bug 14024: Add reports to action logs) +Upgrade to 3.21.00.006 done (Bug 7976: Remove the 'borrow' permission) +Upgrade to 3.21.00.007 done (Bug 14053: Acquisition db tables are missing indexes) +Upgrade to 3.21.00.008 done (Bug 7981: Transfer message on return. HomeOrHoldingBranchReturn syspref removed in favour of circulation rules.) +Upgrade to 3.21.00.009 done (Bug 13993: Correct orderstatus for transferred orders) +Upgrade to 3.21.00.010 done (Bug 7793: redefine the field message_id as PRIMARY KEY of message_queue) +Upgrade to 3.21.00.011 done (Bug 14252: Make the OPAC language switcher available in the masthead navbar, footer, or both) +Upgrade to 3.21.00.012 done (Bug 13014: Add the TO_PROCESS letter code) +Upgrade to 3.21.00.013 done (Bug 9942: Privacy is correctly set) +Upgrade to 3.21.00.014 done (Bug 3206: OAI repository deleted record support) +Upgrade to 3.21.00.015 done (Bug 12137: Extend functionality of CalendarFirstDayOfWeek to be any day) +Upgrade to 3.21.00.016 done (Bug 13948: Add ability to dump template toolkit variables to html comment) +Upgrade to 3.21.00.017 done (Bug 6874: New cataloging plugin upload.pl) +This plugin comes with a new config variable (upload_path) and a new table (uploaded_files) +To use it, set 'upload_path' config variable and 'OPACBaseURL' system preference and link this plugin to a subfield (856$u for instance) +Upgrade to 3.21.00.018 done (Bug 13485: Add a page to display links to restricted sites) +Upgrade to 3.21.00.019 done (Bug 9809: Get rid of reserveconstraints) +Upgrade to 3.21.00.020 done (Bug 13697: Option to don't charge a fee, if the patron changes to a category with enrolment fee) +Upgrade to 3.21.00.021 done (Bug 11584: Add wysiwyg editor to system preferences dealing with HTML) +Upgrade to 3.21.00.022 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) +Upgrade to 3.21.00.023 done (Bug 14717: Prevent 0000-00-00 dates in patron data) +Upgrade to 3.21.00.024 done (Bug 14098: Regression in Marc Modification Templates) +Upgrade to 3.21.00.025 done (Bug 12357: Enhancements to RIS and BibTeX exporting) +Upgrade to 3.21.00.026 done (Bug 14472: Wrong ISSN search index in record matching rules) +Upgrade to 3.21.00.027 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO) +Upgrade to 3.21.00.028 done (Bug 14321: Merge UploadedFile and UploadedFiles into Koha::Upload) +Upgrade to 3.21.00.029 done (Bug 14368: Add discharges history) +Upgrade to 3.21.00.030 done (Bug 14201: Remove unused code or template from some MARC21 leader plugins ) +Upgrade to 3.21.00.031 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) +Upgrade to 3.21.00.032 done (Bug 10855: Additional fields for subscriptions) +Upgrade to 3.21.00.033 done (Bug 10020: Drop table ethnicity and columns ethnicity and ethnotes) +Upgrade to 3.21.00.034 done (Bug 6810: Send membership expiry reminder notices) +Upgrade to 3.21.00.035 done (Bug 14045: Add DB fields maxonsiteissueqty and pref ConsiderOnSiteCheckoutsAsNormalCheckouts) +Upgrade to 3.21.00.036 done (Bug 10363: There is no package for authorised values) +Upgrade to 3.21.00.037 done (Bug 8236: Prevent renewing if overdue or restriction) +Upgrade to 3.21.00.038 done (Bug 11759: Add the batch checkout feature) +Upgrade to 3.21.00.039 done (Bug 12194: Add column oblique_title to layouts) +Upgrade to 3.21.00.040 done (Bug 10937: Option to hide and group itemtypes from advanced search) +Upgrade to 3.21.00.041 done (Bug 13590: Add ability to charge fines at start of charge period) +Upgrade to 3.21.00.042 done (Bug 15069: items_search_fields.authorised_values_category is still a varchar(32)) +Upgrade to 3.21.00.043 done (Bug 11559: Professional cataloger's interface) +Upgrade to 3.21.00.044 done (Bug 14100: Generic solution for language overlay) +Upgrade to 3.21.00.045 done (Bug 14246: (newsauthor) Add borrowernumber to koha_news) +Upgrade to 3.21.00.046 done (Bug 14247: (newsauthor) System preference for news author display) +Upgrade to 3.21.00.047 done (Bug 10904: Limit patron update request management by branch) +Upgrade to 3.21.00.048 done (Bug 14978: Make sure issues.itemnumber is a unique key) +Upgrade to 3.21.00.049 done (Bug 11431: Add additional sound options for warnings) +Upgrade to 3.21.00.050 done (Bug 12933: Add ability to print overdue slip from staff intranet) +Upgrade to 3.21.00.051 done (Bug 14544: Move the list related code to Koha::Virtualshelves) +Upgrade to 3.21.00.052 done (Bug 8296: Add descriptive (text) published date field for serials) +Upgrade to 3.21.00.053 done (Bug 9468: create new SUGGEST_FORMAT authorised_value list) +Upgrade to 3.21.00.054 done (Bug 8064: Merge several biblio records) +Upgrade to 3.21.00.055 done (Koha 3.22 beta) +Upgrade to 3.21.00.056 done (Bug 12072: New dateformat dd.mm.yyyy) +Upgrade to 3.22.00.000 done (Koha 3.22) +Upgrade to 3.23.00.000 done (The year of the monkey will be here soon.) +Upgrade to 3.23.00.001 done (Bug 11625 - Add pref DefaultToLoggedInLibraryCircRules and DefaultToLoggedInLibraryNoticesSlips) +Upgrade to 3.23.00.002 done (Bug 11747 - add pref DefaultToLoggedInLibraryOverdueTriggers) +Upgrade to 3.23.00.003 done (Bug 8085 - Rename 'Reserve slip' to 'Hold slip') +Upgrade to 3.23.00.004 done (Bug 9819 - stopwords related code should be removed) +Upgrade to 3.23.00.005 done (Bug 11569 - Typo in userpermissions.sql) +Upgrade to 3.23.00.006 done ( Bug 8956 - Split serials enumeration data into separate fields ) +Upgrade to 3.23.00.007 done (Bug 13624 - Remove columns branchcode, categorytype from table overduerules_transport_types) +Upgrade to 3.23.00.008 done (Bug 9303 - relative's checkouts in the opac) +Upgrade to 3.23.00.009 done (Bug 11622 - Add ability to pay fees and fines from OPAC via PayPal) +Upgrade to 3.23.00.010 done (Bug 9129 - Add the ability to set the maximum fine for an item to its replacement price) +Upgrade to 3.23.00.011 done (Bug 13592 - Hold fee not being applied on placing a hold) +Upgrade to 3.23.00.012 done (Bug 15380 - Move the authority types related code to Koha::Authority::Type[s] - part 1) +Upgrade to 3.23.00.013 done (Bug 14945 - Add the ability to store the last patron to return an item) +Upgrade to 3.23.00.014 done (Bug 10076 - Add Bcc syspref for claimacquisition and clamissues) +Upgrade to 3.23.00.015 done (Bug 15443 - Re-code RESERVESLIP as HOLD_SLIP) +Upgrade to 3.23.00.016 done (Bug 8753 - Add forgot password link to OPAC) +Upgrade to 3.23.00.017 done (Bug 14893 - Separate temporary storage per instance in Upload.pm) +Upgrade to 3.23.00.018 done (Bug 15446 - Fix systempreferences rows where type=YesNo and value='') +Upgrade to 3.23.00.019 done (Bug 15411 - Change Non Fiction to Non-fiction in authorised_values) +Upgrade to 3.23.00.020 done (Bug 9021 - Add SMS via email as an alternative to SMS services via SMS::Send drivers) +Upgrade to 3.23.00.021 done (Bug 15736 - Add a preference to control whether all items should be shown in checked-in items list) +Upgrade to 3.23.00.022 done (Bug 13534 - Deleting staff patron will delete tags approved by this patron) +Upgrade to 3.23.00.023 done (Bug 6624 - Allow Koha to use the new read API from OpenLibrary) +Upgrade to 3.23.00.024 done (Bug 15517 - Tables borrowers and deletedborrowers differ again) +Upgrade to 3.23.00.025 done (Bug 15526 - Drop nozebra database table) +Upgrade to 3.23.00.026 done (Bug 15343 - Allow patrons to choose their own password on self registration) +Upgrade to 3.23.00.027 done (Bug 4941 - Can't set branch in staff client when singleBranchMode is enabled) +Upgrade to 3.23.00.028 done (Bug 14658 - Split PatronSelfRegistrationBorrowerUnwantedField into two preferences for creating and editing) +Upgrade to 3.23.00.029 done (Bug 14199 - Unify all organization code plugins) +Upgrade to 3.23.00.030 done (Bug 15311: Let libraries set text to display when OpacMaintenance = on) +Upgrade to 3.23.00.031 done (Bug 14395 - Two different ways to calculate 'No renewal before') +Upgrade to 3.23.00.032 done (Bug 15675 - Add issue_id column to accountlines and use it for updating fines) +Upgrade to 3.23.00.033 done (Bug 14659 - Allow patrons to enter card number and patron category on OPAC registration page) +Upgrade to 3.23.00.034 done (Bug 11023: Adds field 'new' in items and deleteditems tables) +Upgrade to 3.23.00.035 done (Bug 14168 - enhance streaming cataloging to include youtube) +Upgrade to 3.23.00.036 done (Bug 12803 - Add ability to skip closed libraries when generating the holds queue) +Upgrade to 3.23.00.037 done (Bug 15084 - Move the currency related code to Koha::Acquisition::Currenc[y|ies]) +Upgrade to 3.23.00.038 done (Bug 14694 - Make decreaseloanHighHolds more flexible) +Upgrade to 3.23.00.039 done (Bug 15084 - Move the currency related code to Koha::Acquisition::Currenc[y|ies]) +Upgrade to 3.23.00.040 done (Bug 16019 - Check intranetcolorstylesheet for blue.css) +Upgrade to 3.23.00.041 done (Bug 16007: Make sure overduerules_transport_types.letternumber exists) +Upgrade to 3.23.00.042 done (Bug 16004 - Replace items.new with items.new_status) +Upgrade to 3.23.00.043 done (Bug 16070 - Empty (undef) system preferences may cause some issues in combination with memcache) +Upgrade to 3.23.00.044 done (Bug 10988 - Allow login via Google OAuth2 (OpenID Connect)) +Upgrade to 3.23.00.045 done (Bug 7736 - Edifact QUOTE and ORDER functionality)) +Upgrade to 3.23.00.046 done (Bug 15630 - Make Edifact module pluggable)) +Upgrade to 3.23.00.047 done (Bug 15008 - Add custom HTML areas to circulation and reports home pages) +Upgrade to 3.23.00.048 done (Bug 5979 - Add separate OPACISBD system preference) +Upgrade to 3.23.00.049 done (Bug 12267 - Allow password option in Patron Attribute non functional) +WARNING: If you plan to use Elasticsearch you should go to 'Home › Administration › Search engine configuration' and reset the mappings +Upgrade to 3.23.00.050 done (Bug 12478 - Elasticsearch support for Koha) +Upgrade to 3.23.00.051 done (Bug 16354 - Fix FK constraints for edifact_messages table) +Upgrade to 3.23.00.052 done (Bug 14686 - New menu option and permission for file uploading) +Upgrade to 3.23.00.053 done (Bug 16217 - Notice' names may have diverged) +Upgrade to 3.23.00.054 done (Bug 15532 - Add ability to allow only items whose home/holding branch matches the hold's pickup branch to fill a given hold) +Upgrade to 3.23.00.055 done (Bug 15533 - Allow patrons and librarians to select itemtype when placing hold) +Upgrade to 3.23.00.056 done (Bug 14577 - Allow restriction of checkouts based on fines of guarantor/guarantee) +Upgrade to 3.23.00.057 done (Bug 15531 - Add support for standing orders) +The system preferences AuthorisedValueImages and StaffAuthorisedValueImages have been turned off +authorised_values.imageurl is not populated, that means you are not using this feature +Upgrade to 3.23.00.058 done (Bug 16041 - StaffAuthorisedValueImages & AuthorisedValueImages preferences - impact on search performance) +Upgrade to 3.23.00.059 done (Bug 16167 - Remove prefs to drive authorised value images) +Upgrade to 3.23.00.060 done (Bug 12528 - Enable staff to deny message setting access to patrons on the OPAC) +Upgrade to 3.23.00.061 done (Bug 16170 - Add FK for biblionumber in items) +Upgrade to 3.23.00.062 done (Bug 16414 - aqorders.budgetgroup_id has never been used and can be removed) +Upgrade to 3.23.00.063 done (Bug 16402: Fix DB structure to work on MySQL 5.7) +Upgrade to 3.23.00.064 done (Bug 15086 - Creators layout and template sql has warnings) +Upgrade to 16.05.00.000 done (Koha 16.05) +Upgrade to 16.06.00.000 done (Koha 16.06 - starting a new dev line at KohaCon16 in Thessaloniki, Greece! Koha is great!) +Upgrade to 16.06.00.001 done (Bug 16200 - 'Hold waiting too long' fee has a translation problem) +Upgrade to 16.06.00.002 done (Bug 10459 - borrowers should have a timestamp) +Upgrade to 16.06.00.003 done (Bug 11490 - MaxItemsForBatch should be split into two new prefs) +Upgrade to 16.06.00.004 done (Bug 15485: Allow choosing different XSLTs for lists) +Upgrade to 16.06.00.005 done (Bug 16768 - Add official number format for Switzerland: 1'234'567.89) +Upgrade to 16.06.00.006 done (Bug 14048: Change RefundLostItemFeeOnReturn to be branch specific) +Upgrade to 16.06.00.007 done (Bug 3534 - Patron quick add form) +Upgrade to 16.06.00.008 done (Bug 6906 - show 'Borrower has previously issued $ITEM' alert on checkout) +Upgrade to 16.06.00.009 done (Bug 14902 - Add qualifier menu to staff side 'Search the Catalog') +Upgrade to 16.06.00.010 done (Bug 15128 - Add ability to limit the number of open purchase suggestions a patron can make) +Upgrade to 16.06.00.011 done (Bug 11606 - Novelist Select in Staff Client) +Upgrade to 16.06.00.012 done (Bug 16573 - Web installer fails to load structure and sample data on MySQL 5.7) +Upgrade to 16.06.00.013 done (Bug 7441 - Search results showing wrong branch) +Upgrade to 16.06.00.014 done (Bug 16829: action_logs should have an 'interface' column) +Upgrade to 16.06.00.015 done (Bug 14642: Add logging of hold modifications) +Upgrade to 16.06.00.016 done (Bug 7045 - Default-value substitution inconsistent) +Upgrade to 16.06.00.017 done (Bug 10848 - Allow configuration of mandatory/required fields on the suggestion form in OPAC) +Upgrade to 16.06.00.018 done (Bug 14695 - Add ability to place multiple item holds on a given record per patron) +Upgrade to 16.06.00.019 done (Bug 15839 - Move the reviews related code to Koha::Reviews) +Upgrade to 16.06.00.020 done (Bug 16272 - Transform checkout from on-site checkout to regular checkout) +Upgrade to 16.06.00.021 done (Bug 16275 - Prevent patron self registration if the email already filled in borrowers.email) +Upgrade to 16.06.00.022 done (Bug 16978 - Add delete reports user permission) +Upgrade to 16.06.00.023 done (Bug 17187) +Note: Pref value for timeout has been adjusted. +Upgrade to 16.06.00.024 done (Bug 16311 - Advanced search language limit typo for Romanian) +Upgrade to 16.06.00.025 done (Bug 7677 - Subscriptions: Ability to define default itemtype and automatically change itemtype of older issues on receive of next issue) +Upgrade to 16.06.00.026 done (Bug 16274 - Make the selfregistration branchcode selection configurable) +Upgrade to 16.06.00.027 done (Bug 16276: Add a new pref TrackLastPatronActivity and new column borrowers.lastseen) +Attempting upgrade to 16.06.00.028 (Bug 17135) ... +No fine records needed to be fixed +Upgrade to 16.06.00.028 done (Bug 17135 - Fine for the previous overdue may get overwritten by the next one) +Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 13039. +Upgrade to 16.06.00.029 done (Bug 14707 - Change UsageStatsCountry from free text to a dropdown list) +Upgrade to 16.06.00.030 done (Bug 16552 - Add the ability to change the default holdings sort) +Upgrade to 16.06.00.031 done (Bug 16273 - Prevent selfregistration from printing the borrower password and filling the logging form) +Upgrade to 16.06.00.032 done (Bug 17357 - WTHDRAWN is still used in installer files) +Upgrade to 16.06.00.033 done (Bug 17216 - Add a new table to store authorized value categories) +Upgrade to 16.06.00.034 done (Bug 10455 - remove redundant 'biblioitems.marc' field) +Upgrade to 16.06.00.035 done (Bug 15131: Give SCO separate control for AllowItemsOnHoldCheckout) +Upgrade to 16.06.00.036 done (Bug 5670 - Housebound Readers Module) +Upgrade to 16.06.00.037 done (Bug 14610 - Add ability to place article requests in Koha) +Upgrade to 16.06.00.038 done (Bug 14874 - Add ability to search for patrons by date of birth from checkout and patron quick searches) +Upgrade to 16.06.00.039 done (Bug 14598: itemtype is not set on statistics by C4::Circulation::AddReturn) +Upgrade to 16.06.00.040 done (Bug 5260 - Add option to send an order by e-mail to the acquisition module) +Upgrade to 16.06.00.041 done (Bug 14629 - Add aggressive ISSN matching feature equivalent to the aggressive ISBN matcher) +Upgrade to 16.06.00.042 done (Bug 13321 - Tax and prices calculation need to be fixed) +Upgrade to 16.06.00.043 done (Bug 13323 - Change the tax rate on receiving) +Upgrade to 16.06.00.044 done (Bug 17397 - Show name of librarian who created circulation message) +Upgrade to 16.06.00.045 done (Bug 17443 - Make possible to renew patron by later of expiry and current date) +Upgrade to 16.06.00.046 done (Bug 15581 - Add a circ rule to not allow auto-renewals after defined loan period) +Upgrade to 16.06.00.047 done (Bug 17518: Displayed language name for Czech is wrong) +Upgrade to 16.06.00.048 done (Bug 17663 - Forgotten userpermissions) +Upgrade to 16.06.00.049 done (Bug 17391 - ReturnpathDefault and ReplyToDefault missing from syspref.sql) +Upgrade to 16.06.00.050 done (Bug 8835). Everything is fine. +Upgrade to 16.11.00.000 done (Koha 16.11) +Upgrade to 16.12.00.000 done (Koha 16.12 - Our battered suitcases were piled on the sidewalk again; we had longer ways to go. But no matter, the road is life.) +Upgrade to 16.12.00.001 done (Bug 17767 - Let Koha::Patron::Modification handle extended attributes) +Upgrade to 16.12.00.002 done (Bug 14187 - branchtransfer needs a primary key (id) for DBIx and common sense.) +Upgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an authentication method) +Upgrade to 16.12.00.004 done (Bug 17196 - Move marcxml out of the biblioitems table) +Upgrade to 16.12.00.005 done (Bug 17913 - AuthorityMergeMode) +Upgrade to 16.12.00.006 done (Bug 17813: Table borrower_attributes needs a primary key +Upgrade to 16.12.00.007 done (Bug 17960 - Rename opac_news with opac_news.content (template notices have been updated!)) +Upgrade to 16.12.00.008 done (Bug 15503 - Grab Item Information from Order Files) +Upgrade to 16.12.00.009 done (Bug 17453 - Inter-site holds improvement) +Upgrade to 16.12.00.010 done (Bug 16034 - Integration with OverDrive Patron API) +Upgrade to 16.12.00.011 done (Bug 17260 - updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns) +Upgrade to 16.12.00.012 done (Bug 14764 - Add OPAC News branch selector) +Upgrade to 16.12.00.013 done (Bug 16530 - Add a circ sidebar navigation menu) +Upgrade to 16.12.00.014 done (Bug 8010 - Search history can be added to the wrong patron) +Upgrade to 16.12.00.015 done (Bug 18066 - Hea version 2) +Upgrade to 16.12.00.016 done (Bug 13757: Make patron attributes editable in the opac if set to 'editable in OPAC)' +Upgrade to 16.12.00.017 done (Bug 14146 - Additional days are not added to restriction period when checking-in several overdues for same patron)' +Upgrade to 16.12.00.018 done (Bug 15498 - Replace ExportWithCsvProfile with ExportCircHistory)' +Upgrade to 16.12.00.019 done (Bug 18173 - Remove issues.return DB field) +Upgrade to 16.12.00.020 done (Bug 17560 - Hold fee placement at point of checkout) +Upgrade to 16.12.00.021 done (Bug 17708 - Renewal log seems empty) +NOTE: The sender for claim notifications has been corrected. The email address of the staff member is no longer used. We will use the branch email address or KohaAdminEmailAddress, as is done for other notices. +Upgrade to 16.12.00.022 done (Bug 17866 - Change sender for serial claim notifications) +IMPORTANT NOTE: If you are not using a Debian package install, please verify that you no longer use misc/migration_tools/merge_authority.pl in your cron files AND add misc/cronjobs/merge_authorities.pl to cron now. This job is no longer optional! You need it to perform larger authority merges. +Upgrade to 16.12.00.023 done (Bug 9988 - Add AuthorityMergeLimit) +Upgrade to 16.12.00.024 done (Bug 14537 - The system preference 'OverdueNoticeBcc' is mis-named.) +Upgrade to 16.12.00.025 done (Bug 17669 - Introduce preference for deleting temporary uploads) +Upgrade to 16.12.00.026 done (Bug 18427 - Add a primary key to serialitems) +Upgrade to 16.12.00.027 done (Bug 12461 - Add patron clubs feature) +Upgrade to 16.12.00.028 done (Bug 18110 - Adds FR to the syspref AddressFormat) +Upgrade to 16.12.00.029 done (Bug 14224: Add column issues.note and issues.notedate) +Upgrade to 16.12.00.030 done (Bug 16344 - Add a circ rule to limit the auto renewals given a specific date) +Upgrade to 16.12.00.031 done (Bug 15108: OAI-PMH provider improvements) +Upgrade to 16.12.00.032 done (Bug 12063 - Update reserves.expirationdate) +Upgrade to 16.12.00.033 done (Bug 17762 - Add columns letter.lang and borrowers.lang to allow translation of notices) +Upgrade to 16.12.00.034 done (Bug 15582 - Ability to block auto renewals if the OPACFineNoRenewals amount is reached) +Upgrade to 16.12.00.035 done (Bug 15705 - Notify the user on auto renewing) +Upgrade to 16.12.00.036 done (Bug 17465 - Add a System Preference to control number of Saved Reports displayed) +Upgrade to 16.12.00.037 done (Bug 18314 - Add FailedLoginAttempts and borrowers.login_attempts) +Upgrade to 16.12.00.038 done (Bug 18663 - Missing db update for ExportRemoveFields) +Upgrade to 16.12.00.039 done (Bug 18600 - Missing db update for TalkingTechItivaPhoneNotification) +Upgrade to 17.05.00.000 done (Koha 17.05) +Upgrade to 17.06.00.000 done (He pai ake te iti i te kore) +Upgrade to 17.06.00.001 done (Bug 8612 - Add new column export_format.used_for) +Upgrade to 17.06.00.002 done (Bug 18228 - Alter table virtualshelves to simplify permissions) +Upgrade to 17.06.00.003 done (Bug 18801 - Update incorrect Default auth type codes) +Upgrade to 17.06.00.004 done (Bug 16892: Add automatic patron registration via OAuth2 login) +Upgrade to 17.06.00.005 done (Bug 18718 - Language selector in staff header menu similar to OPAC ) +WARNING: Bug 18811 fixed an inconsistency in the visibility settings for authority frameworks. It is recommended that you run script misc/maintenance/auth_show_hidden_data.pl to check if you have data in hidden fields and adjust your frameworks accordingly to prevent data loss when editing such records. +Upgrade to 17.06.00.006 done (Bug 18811 - Visibility settings inconsistent between framework and authority editor) +Upgrade to 17.06.00.007 done (Bug 10132 - MARCOrgCode on branch level (branches.marcorgcode)) +Upgrade to 17.06.00.008 done (Bug 6758 - Capture membership renewal date for reporting purposes (borrowers.date_renewed)) +Upgrade to 17.06.00.009 done (Bug 19344 - Reorder lang and login_attempts in the [deleted]borrowers tables) +Upgrade to 17.06.00.010 done (Bug 13912 - System preference for default place of publication (country code) for field 008, range 15-17) +Upgrade to 17.06.00.011 done (Bug 13766 - Make ean mediumtext and add ean indexes) +Upgrade to 17.06.00.012 done (Bug 19043 - Z39.50 target for Columbia University is no longer publicly available.) +Upgrade to 17.06.00.013 done (Bug 16401 - fix potentialy bad set staffClientBaseURL preference) +Upgrade to 17.06.00.014 done (Bug 15685 - Allow creation of items (AcqCreateItem) to be customizable per-basket) +Upgrade to 17.06.00.015 done (Bug 19186 - Insert system preference SelfCheckoutByLogin if missing) +Upgrade to 17.06.00.016 done (Bug 18298 - Allow enforcing password complexity (system preference RequireStrongPassword)) +Upgrade to 17.06.00.017 done (Bug 14826 - Resurrect account offsets table (Add new tables account_offsets and account_offset_types)) +Upgrade to 17.06.00.018 done (Bug 12768 - Insert system preferences useDefaultReplacementCost and ProcessingFeeNote + Add new columns defaultreplacecost and processfee to the itemtypes table) +Upgrade to 17.06.00.019 done (Bug 12768 - Add 'Processing Fee' to the account_offset_types table if missing) +Upgrade to 17.06.00.020 done (Bug 19028: Add 'shelving location' to holdings table in detail page (Rename syspref OpacLocationBranchToDisplayShelving with OpacLocationOnDetail)) +Upgrade to 17.06.00.021 done (Bug 17381 - Add system preference SCOMainUserBlock) +Upgrade to 17.06.00.022 done (Bug 19038: Remove OPACShowBarcode syspref) +Upgrade to 17.06.00.023 done (Bug 12363 - Add system preference MarkLostItemsAsReturned) +Upgrade to 17.06.00.024 done (Bug 2093 - Add system preference OPACUserSummary) +Upgrade to 17.06.00.025 done (Bug 13178 - Increase cardnumber fields to VARCHAR(32)) +Upgrade to 17.06.00.026 done (Bug 10748 - Add system preference BlockReturnOfLostItems) +Upgrade to 17.06.00.027 done (Bug 18882 - Add location code to statistics table for checkouts and renewals) +Upgrade to 17.06.00.028 done (Bug 7317 - Add an Interlibrary Loan Module to Circulation and OPAC) +Upgrade to 17.11.00.000 done (Koha 17.11) +Upgrade to 17.12.00.000 done (Tē tōia, tē haumatia) +Upgrade to 17.12.00.001 done (Bug 19724 - Add [deleted]biblio_metadata.timestamp) +Upgrade to 17.12.00.002 done (Bug 19096 - Make Default authoritative for Koha to MARC mappings) +Upgrade to 17.12.00.003 done (Bug 10021 - Drop notifys-related table and columns) +Upgrade to 17.12.00.004 done (Bug 19278 - Add a configurable default page size for REST endpoints) +Upgrade to 17.12.00.005 done (Bug 18915 - Correct CHECKOUT_NOTE notice template) +Upgrade to 17.12.00.006 done (Bug 17682 - Update URL for Google Scholar in OPACSearchForTitleIn) +Upgrade to 17.12.00.007 done (Bug 15707 - Add new table library_groups) +Upgrade to 17.12.00.008 done (Bug 16735 - Migrate library search groups into the new hierarchical groups) +Upgrade to 17.12.00.009 done (Bug 18403 - Add the view_borrower_infos_from_any_libraries permission ) +Upgrade to 17.12.00.010 done (Bug 20133 - Add library_groups.ft_hide_patron_info) +Upgrade to 17.12.00.011 done (Bug 20157 - Use group 'features' to decide which groups to use for group searching functionality) +Upgrade to 17.12.00.012 done (Bug 15752 - Add system preference AutoSwitchPatron) +Upgrade to 17.12.00.013 done (Bug 20175 - Set DEFAULT NULL value for club_enrollments.date_created) +Upgrade to 17.12.00.014 done (Bug 19790 - Remove additionalauthors.author from installer files) +Upgrade to 17.12.00.015 done (Bug 20144 - Adapt DB structure to work with new SQL modes) +Upgrade to 17.12.00.016 done (Bug 18336 - Convert DB tables to utf8mb4 🎁) +Upgrade to 17.12.00.017 done (Bug 17672 - Add damaged_on to items and deleteditems tables) +Upgrade to 17.12.00.018 done (Bug 19290 - Add system preference BrowseResultSelection) +Upgrade to 17.12.00.019 done (Bug 20074 - Auth_subfield_structure changes hidden attribute) +Upgrade to 17.12.00.020 done (Bug 20082 - Update descriptions of Vietnamese language) +Upgrade to 17.12.00.021 done (Bug 13287 - Add system preference PurgeSuggestionsOlderThan) +Upgrade to 17.12.00.022 done (Bug 4078 - Add column currency.p_sep_by_space) +Upgrade to 17.12.00.023 done (Bug 20264 - Remove system preference 'checkdigit') +Upgrade to 17.12.00.024 done (Bug 15492 - Add a standalone self-checkin module) +Upgrade to 17.12.00.025 done (Bug 20291 - Add StaffLoginInstructions system preference and rename NoLoginInstructions with OpacLoginInstructions) +Upgrade to 17.12.00.026 done (Bug 19804 - Add issuingrules.suspension_chargeperiod) +Upgrade to 17.12.00.027 done (Bug 19289 - Add system preference UseACQFrameworkForBiblioRecords) +Upgrade to 17.12.00.028 done (Bug 9701 - Add default indicators (marc_tag_structure.indX_defaultvalue)) +Upgrade to 17.12.00.029 done (Bug 14769 - Authorities merge: Set correct indicators in biblio field (new system preference AuthorityControlledIndicators)) +Upgrade to 17.12.00.030 done (Bug 19882 - Add system preference NovelistSelectStaffProfile) +Upgrade to 17.12.00.031 done (Bug 11674 - Add system preference MarcFieldDocURL) +Upgrade to 17.12.00.032 done (Bug 19794 - Rename RLIST notice to SERIAL_ALERT) +Upgrade to 17.12.00.033 done (Bug 18786 - Add ability to create custom payment types) +Upgrade to 17.12.00.034 done (Bug 18790 - Add ability to void payment) +Upgrade to 17.12.00.035 done (Bug 19974 - Make MarkLostItemsAsReturned multiple) +Upgrade to 17.12.00.036 done (Bug 19287 - Add ability to mark an item 'Lost' from 'Holds to pull' list (CanMarkHoldsToPullAsLost, UpdateItemWhenLostFromHoldList and CANCEL_HOLD_ON_LOST)) +Upgrade to 17.12.00.037 done (This change has been reverted, nothing done!) +Upgrade to 17.12.00.038 done (Bug 20245 - Use Bibliographic code value for Slovak language) +Upgrade to 17.12.00.039 done (Bug 20482 - Use Bibliographic code value for Basque, Maori and Albanian languages) +Upgrade to 17.12.00.040 done (Bug 20100 - Add new system preference ProtectSuperlibrarianPrivileges) +Upgrade to 17.12.00.041 done (Bug 11317 - Add a new permission to access files stored on the server) +Upgrade to 17.12.00.042 done (Bug 20402 - Implement OAuth2 authentication for REST API) +Upgrade to 17.12.00.043 done (Bug 20568 - Add API key management interface for patrons) +Upgrade to 17.12.00.044 done (Bug 20624 - Disable OAuth2 client credentials grant by default) +Upgrade to 18.05.00.000 done (Koha 18.05) +Upgrade to 18.06.00.000 done (Koha 18.06 - It's Adventure time!) +Upgrade to 18.06.00.001 done (Bug 3849- Improve descriptions of granular acquisition permissions) +Upgrade to 18.06.00.002 done (Bug 2426 - Remove deprecated management permission) +Upgrade to 18.06.00.003 done (Bug 20073 - Add new types for Elasticsearch fields) +Upgrade to 18.06.00.004 done (Bug 20980 - Manual credit offsets are stored as debits) +Upgrade to 18.06.00.005 done (Bug 12395 - Save order line's creator) +Upgrade to 18.06.00.006 done (Bug 19524 - Share patron lists between staff) +Upgrade to 18.06.00.007 done (Bug 7651 - Add separate permission for managing currencies and exchange rates) +Upgrade to 18.06.00.008 done (Bug 13560 - need an add option in marc modification templates) +Upgrade to 18.06.00.009 done (Bug 19166 - Add the ability to add adjustments to an invoice) +Upgrade to 18.06.00.010 done (Bug 19191 - Add ability to email receipts for account payments and write-offs) +Upgrade to 18.06.00.011 done (Bug 17698: Add column issues.noteseen and old_issues.noteseen) +Upgrade to 18.06.00.012 done (Bug 11911 - Add separate permission for managing suggestions) +Upgrade to 18.06.00.013 done (Bug 20997 - Add Koha::Account::Line::apply) +Upgrade to 18.06.00.014 done (Bug 21121 - New syspref to allow hiding of private patron data in circulation page) +Upgrade to 18.06.00.015 done (Bug 21226 - Remove prefs OCLCAffiliateID, XISBN and XISBNDailyLimit) +Upgrade to 18.06.00.016 done (Bug 20773 - expirationdate filled for waiting holds) +Upgrade to 18.06.00.017 done (Bug 21144: Add ROADTYPE to default authorised values categories) +Upgrade to 18.06.00.018 done (Bug 20487: Clear items.onloan for unissued items) +Upgrade to 18.06.00.019 done (Bug 19719: Default to hiding collection code column) +Upgrade to 18.06.00.020 done (Bug 15524 - Set limit on maximum possible holds per patron by category) +Upgrade to 18.06.00.021 done (Bug 21068 - Remove system preferences NorwegianPatronDB*) +Upgrade to 18.06.00.022 done (Bug 19383 - Add ability to print hold receipts automatically) +Upgrade to 18.06.00.023 done (Bug 18639 - Add replacementprice field to aqorders table) +Upgrade to 18.06.00.024 done (Bug 7534 - Let libraries have configuration for pickup locations) +Upgrade to 18.06.00.025 done (Bug 19817: Add pref KohaManualLanguage and KohaManualBaseURL) +Upgrade to 18.06.00.026 done (Bug 17530 - Add pref ArticleRequestsLinkControl) +Upgrade to 18.06.00.027 done (Bug 21235: Remove table services_throttle) +Upgrade to 18.06.00.028 done (Bug 19469 - Add ability to split view of holds view on record by pickup library and/or itemtype) +Upgrade to 18.06.00.029 done (Bug 21288: Slowness in acquisition caused by GetInvoices +Upgrade to 18.06.00.030 done (Bug 20777 - Remove unused field accountlines.dispute) +Upgrade to 18.06.00.031 done (Bug 20819: Add patron_consent) +Upgrade to 18.06.00.032 done (Bug 5458: length of items.ccode disagrees with authorised_values.authorised_value) +Upgrade to 18.06.00.033 done (Bug 12747 - Add AdditionalFieldsInZ3950ResultSearch system preference) +Upgrade to 18.06.00.034 done (Bug 17602 - Integrate support for OneClickdigital/Recorded Books API) +Upgrade to 18.06.00.035 done (Bug 21403 - Add Indian Amazon Affiliate option to AmazonLocale setting) +Upgrade to 18.06.00.036 done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules) +Upgrade to 18.06.00.037 done (Bug 21082 - Add overdrive patron auth method) +Upgrade to 18.06.00.038 done (Bug 21417 - EDI ordering fails when basket and EAN libraries do not match) +Upgrade to 18.06.00.039 done (Bug 15520 - Add more granular permission for only editing own library's circ rules) +Upgrade to 18.06.00.040 done (Bug 11897 - Add Stock Rotation Feature) +Upgrade to 18.06.00.041 done (Bug 20772 - Add illrequestattributes.readonly and illrequest.price_paid columns) +Upgrade to 18.06.00.042 done (Bug 21617: Make statistics.ccode longer) +Upgrade to 18.06.00.043 done (Bug 15486: Restrict number of holds placed by day) +Upgrade to 18.06.00.044 done (Bug 15766: Add column creator_batches.description) +Upgrade to 18.06.00.045 done (Bug 21639 - Add phone transports by default) +Upgrade to 18.06.00.046 done (Bug 18591 - Add comments to ILL requests) +Upgrade to 18.06.00.047 done (Bug 19263 - Advanced Editor - Rancor - Add auto control number (001) widget) +Upgrade to 18.06.00.048 done (Bug 21682 - Remove default on stockrotationrotas.description) +Upgrade to 18.06.00.049 done (Bug 21656 - Stock Rotation Notice, Template Toolkit Syntax Correction) +Upgrade to 18.06.00.050 done (Bug 14385 - Add OpacHiddenItemExceptions) +Upgrade to 18.06.00.051 done (Bug 8630 - Add covers from AdLibris to the OPAC and Intranet) +Upgrade to 18.06.00.052 done (Bug 14391: Add granular permissions to the administration module) +Upgrade to 18.06.00.053 done (Bug 15494 - Block renewals by arbitrary item values) +Upgrade to 18.06.00.054 done (Bug 18316 - Add column search_field.weight) +Upgrade to 18.06.00.055 done (Bug 12365: Add column issuingrules.note) +Upgrade to 18.06.00.057 done (Bug 20312 - Add showLastPatron systempreference) +Upgrade to 18.06.00.058 done (Bug 19349 - Add system preferences MarcFieldForCreatorId, MarcFieldForCreatorName, MarcFieldForModifierId, MarcFieldForModifierName) +Upgrade to 18.06.00.059 done (Bug 20356 - Add EmailSMSSendDriverFromAddress system preference) +Upgrade to 18.06.00.060 done (Bug 15836 - Add class_sort_rules.split_routine and split_regex) +Upgrade to 18.06.00.061 done (Bug 19893 - Add elasticsearch index status preferences) +Upgrade to 18.06.00.062 done (Bug 21730: Add new authorised value category PA_CLASS) +Upgrade to 18.11.00.000 done (18.11.00 release) +Upgrade to 18.12.00.000 done (...and Steven!) +Upgrade to 18.12.00.001 (Bug 21961 - Fix typo in manage_didyoumean permission) +Upgrade to 18.12.00.002 done (Bug 21065 - Set ON DELETE SET NULL on accountlines.borrowernumber) +Upgrade to 18.12.00.003 done (Bug 22024 - Add missing splitting rule definitions) +Upgrade to 18.12.00.004 done (Bug 19066 - Add branchcode to accountlines) +Upgrade to 18.12.00.005 done (Bug 22030: Add OverDriveUsername syspref) +Upgrade to 18.12.00.006 done (Bug 21915 - Add a way to automatically reconcile balance for patrons) +Upgrade to 18.12.00.007 done (Bug 21753: Drop chargename from issuingrules ) +Upgrade to 18.12.00.008 done (Bug 17047 - Mana knowledge base) +Upgrade to 18.12.00.009 done (Bug 21241 - Add FallbackToSMSIfNoEmail syspref ) +Upgrade to 18.12.00.010 done (Bug 22061 - Add a /public namespace that can be switched on/off) +Upgrade to 18.12.00.011 done (Bug 22155 - biblio_metadata.marcflavour should be renamed 'schema') +Upgrade to 18.12.00.012 done (Bug 22132 - Add Basic authentication) +Upgrade to 18.12.00.013 done (Bug 22198 - Add ghranular permission setting for Mana KB) +Upgrade to 18.12.00.014 done (Bug 13515 - Add a FOREIGN KEY constaint on messages.borrowernumber) +Upgrade to 18.12.00.015 done (Bug 3820 - Update patron modification logs) +Upgrade to 18.12.00.016 done (Bug 20581 - Allow manual selection of custom ILL request statuses) +Upgrade to 18.12.00.017 done (Bug 21747 - Update account_offset_types to include 'fine_increase' and 'fine_decrease') +Upgrade to 18.12.00.018 done (Bug 19575 - Use canonical field names and resolve aliased fields) +Upgrade to 18.12.00.019 done (Bug 21728 - Add 'Reserve Fee' to the account_offset_types table if missing) +Upgrade to 18.12.00.020 done (Bug 18925 - Move maxissueqty and maxonsiteissueqty to circulation_rules) +Upgrade to 18.12.00.021 done (Bug 20912 - Support granular rental charges) +Upgrade to 18.12.00.022 done (Bug 15774 - Add permission for managing additional fields) +Upgrade to 18.12.00.023 done (Bug 20639 - Add ILLOpacbackends syspref) +Upgrade to 18.12.00.024 done (Bug 22368 - Add missing constraints to suggestions) +Upgrade to 18.12.00.025 done (Bug 21846 - Using emoji as tags has broken weights) +WARNING: (Bug 21846) You need to manually run /kohadevbox/koha/misc/maintenance/fix_tags_weight.pl to fix possible issues with tags. +Upgrade to 18.12.00.026 done (Bug 20750 - Allow timestamped auditing of ILL request events) +Upgrade to 18.12.00.027 done (Bug 18837: Add ILLModuleUnmediated Syspref) +Upgrade to 18.12.00.028 done (Bug 21756 - Add 'Account Fee' and 'Hold Expired' to the account_offset_types table if missing) +Upgrade to 18.12.00.029 done (Bug 18736 - Add syspref to control order rounding) +Upgrade to 18.12.00.030 done (Bug 21683 - Remove accountlines.accountno and statistics.proccode fields) +Upgrade to 18.12.00.031 done (Bug 22008 - Add missing constraints for accountlines.manager_id) +Upgrade to 18.12.00.032 done (Bug 18235 - Elastic search - make facets configurable) +Upgrade to 18.12.00.033 done (Bug 18213 - Add language facets to Elasticsearch) +Upgrade to 18.12.00.034 done (Bug 22516 - Drop deprecated accountlines.lastincrement field) +Upgrade to 18.12.00.035 done (Bug 19722 - Add a MaxItemsToDisplayForBatchMod preference) +Upgrade to 18.12.00.036 done (Bug 22518 - Fix accounttype 'O' to 'FU' - 0 updated) +Upgrade to 18.12.00.037 done (Bug 22607 - Set default value of issues.renewals to 0) +Upgrade to 18.12.00.038 done (Bug 22512 - Add status to accountlines) +Upgrade to 18.12.00.039 done (Bug 22600 - Add interface to accountlines) +Upgrade to 18.12.00.040 done (Bug 12166 - Remove 'Reserve Charge' text from accountlines description) +Upgrade to 18.12.00.041 done (Bug 19670 - Change collation of marc_field to allow mixed case search field mappings) +Upgrade to 18.12.00.042 done (Bug 29891 - Remove non-XSLT detail view in the staff client) +Upgrade to 18.12.00.043 done (Bug 21953 - Remove 'Lost Item' text from accountlines description) +Upgrade to 18.12.00.044 done (Bug 21890 - Patron password reset by category) +Upgrade to 18.12.00.045 done (Bug 10796 - Patron password change by category) +Upgrade to 18.12.00.046 done (Bug 22695 - Remove non-XSLT search results view from the staff client) +Upgrade to 18.12.00.047 done (Bug 14557: Add Libris spellchecking system preferences) +Upgrade to 18.12.00.048 done (Bug 22044 - Set a default value for NoRenewalBeforePrecision) +Upgrade to 18.12.00.049 done (Bug 21336 - Add field flgAnonymized) +Upgrade to 18.12.00.050 done (Bug 21336 - Add preferences) +Upgrade to 18.12.00.051 done (Bug 21336 - Reset login_attempts) +Upgrade to 18.12.00.052 done (Bug 22311 - Add a SysPref to allow adding content to the #moresearches div in the opac) +Upgrade to 18.12.00.053 done (Bug 17171 - Add a syspref to allow currently issued items to be issued to a new patron without staff confirmation) +Upgrade to 18.12.00.054 done (Bug 20128: Add permission for Advanced Cataloging Editor) +Upgrade to 18.12.00.055 done (Bug 22521 - Update accountlines.accounttype to varchar(16), and map new statuses) +Upgrade to 18.12.00.056 done (Bug 8701 - Update OpacHiddenItems system preference description) +Upgrade to 18.12.00.057 done (Bug 13795 - Delete unused fields from statistics table) +Use of uninitialized value $opaclang in split at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 18235. +Upgrade to 18.12.00.058 done (Bug 22318: Move contents of OpacNavRight preference to Koha news system) +Upgrade to 18.12.00.059 done (Bug 22532 - Remove import_records z3950random column) +Upgrade to 18.12.00.060 done (Bug 22564 - Fix accounttype 'Rep' - 0 updated) +Upgrade to 18.12.00.061 done (Bug 21336 - (follow-up) Rename flgAnonymized column) +Upgrade to 18.12.00.062 done (Bug 22339 - Fix search field mappings of MARC fixed fields) +Upgrade to 18.12.00.063 done (Bug 22511 - Update existing VOID accountlines) +Upgrade to 18.12.00.064 done (Bug 14576: Add UpdateItemLocationOnCheckin syspref) +Upgrade to 18.12.00.065 done (Bug 10300 - Allow transferring of items to be have separate IndependentBranches syspref) +Upgrade to 18.12.00.066 done (Bug 8995 - Add new preferences for OpenURLResolvers) +Upgrade to 18.12.00.067 done (Bug 8000 - Add new preferences for SendAllEmailsTo) +Upgrade to 18.12.00.068 done (Bug 7088: Cannot renew items on hold even with override) +Upgrade to 18.12.00.069 done (Bug 22053 - enable all plugins) +Upgrade to 18.12.00.070 done (Bug 14407 - Limit web-based self-checkout to specific IP addresses) +Upgrade to 18.12.00.071 done (Bug 22809 - Move 'ACCOUNT_CREDIT' from template to a slip) +Upgrade to 18.12.00.072 done (Bug 22809 - Move 'INVOICE' from template to a slip) +Upgrade to 18.12.00.073 done (Bug 5770 - Email librarian when purchase suggestion made) +Upgrade to 18.12.00.074 done (Bug 21411 - Add keyboard_shortcuts table) +Upgrade to 18.12.00.075 done (Bug 22899 - Add items constraint to tmp_holdsqueue) +Upgrade to 19.05.00.000 done (19.05.00 release) +Upgrade to 19.06.00.000 done (Wingardium Leviosa!) +Upgrade to 19.06.00.001 done (Bug 22960: Fix typo in syspref description) +Upgrade to 19.06.00.002 done (Bug 10215: Increase the size of opacnote and librariannote for table subscriptionhistory) +Upgrade to 19.06.00.003 done (Bug 22867: UniqueItemFields preference value should be pipe-delimited) +Upgrade to 19.06.00.004 done (Bug 22770: Fix typo in language description for el in German) +Upgrade to 19.06.00.005 done (Bug 9834: Add the reserves.item_level_hold column) +Upgrade to 19.06.00.006 done (Bug 21073: Improve plugin performance) +Upgrade to 19.06.00.007 done (Bug 22653: Remove unimplemented RotationPreventTransfers system preference) +Upgrade to 19.06.00.008 done (Bug 23109: Improve description of staffaccess permission) +Upgrade to 19.06.00.009 done (Bug 17178: add shortcut to keyboard_shortcuts) +Upgrade to 19.06.00.010 done (Bug 18928: Move holdallowed, hold_fulfillment_policy, returnbranch to circulation_rules) +Upgrade to 19.06.00.011 done (Bug 18930: Move lost item refund rules to circulation_rules table) +Upgrade to 19.06.00.012 done (Bug 22563: Fix accounttypes for 'L', 'LR' and 'CR') +Upgrade to 19.06.00.013 done (Bug 23151: Add borrower_modifications.changed_fields column) +Upgrade to 19.06.00.014 done (Bug 11573: Fix accounttypes for 'Rent') +Upgrade to 19.06.00.015 done (Bug 22524: Fix date/time-last-modified search with Elasticsearch) +Upgrade to 19.06.00.016 done (Bug 23396: Fix missing keyboard_shortcuts table) +Upgrade to 19.06.00.017 done (Bug 22610: Fix accounttypes for SIP2 payments) +Use of uninitialized value $marcflavour in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 19187. +Upgrade to 19.06.00.018 done (Bug 11529: Add medium, subtitle and part information to biblio table) +NOTE: misc/batchRebuildBiblioTables.pl should be run to populate the fields introduced in bug 11529. It may take some time for larger databases. + +Upgrade to 19.06.00.019 done (Bug 23228: Add option to automatically display payment receipt for printing after making a payment) +Upgrade to 19.06.00.020 done (Bug 23416: Add PreserveSerialNotes syspref) +Upgrade to 19.06.00.021 done (Bug 23309: Can't add new subfields to bibliographic frameworks in strict mode) +Upgrade to 19.06.00.022 done (Bug 14570: Make it possible to add multiple guarantors to a record) +Upgrade to 19.06.00.023 done (Bug 22258: Add ElasticsearchMARCFormat preference) +Upgrade to 19.06.00.024 done (Bug 23539: accountlines.accounttype should match authorised_values.authorised_value in size) +Upgrade to 19.06.00.025 done (Bug 22996: Add pref BarcodeSeparators) +Upgrade to 19.06.00.026 done (Bug 20691: Add ability for guarantors to view guarantee's fines in OPAC) +Upgrade to 19.06.00.027 done (Bug 15497: Add itemtypes_branches table) +Upgrade to 19.06.00.028 done (Bug 11573: Fix accounttypes for 'A') +Upgrade to 19.06.00.029 done (Bug 23321: Add cash_registers table, permissions and preferences) +Upgrade to 19.06.00.030 done (Bug 19618: add club_holds tables) +Upgrade to 19.06.00.031 done (Bug 23566: Add OPACDetailQRCode system preference) +Upgrade to 19.06.00.032 done (Bug 20589: Add field boosting and use elastic query fields parameter instead of depricated _all) +Upgrade to 19.06.00.033 done (Bug 23686: Add OnSiteCheckoutAutoCheck system preference) +Upgrade to 19.06.00.034 done (Bug 23007: Make transfer modals optionally block circ) +Upgrade to 19.06.00.035 done (Bug 18421: Add Coce image cache to the Intranet) +Upgrade to 19.06.00.036 done (Bug 20334: Add elasticsearch escape options preference) +Upgrade to 19.06.00.037 done (Bug 21701: PayPal return URL option) +Upgrade to 19.06.00.038 done (Bug 23697: Rename CircAutocompl system preference to PatronAutoComplete) +Upgrade to 19.06.00.039 done (Bug 17179: Add additional keyboard_shortcuts) +Upgrade to 19.06.00.040 done (Bug 17140: Add pref to allow rounding fines at payment) +Upgrade to 19.06.00.041 done (Bug 22880: Allow granular control of socialnetworks preference) +Upgrade to 19.06.00.042 done (Bug 22445: Add new pref *CustomCoverImages*) +Upgrade to 19.06.00.043 done (Bug 23049: Add account debit_types) +Upgrade to 19.06.00.044 done (Bug 23805: Add account credit_types) +Upgrade to 19.06.00.045 done (Bug 23866: Set HEA syspref to prompt for review) +Upgrade to 19.06.00.046 done (Bug 15260: Option for extended loan with useDaysMode) +Upgrade to 19.06.00.047 done (Bug 14697: Extend and enhance 'Claims returned' lost status) +Upgrade to 19.06.00.048 done (Bug 22581: add new OPACShowMusicalInscripts and OPACPlayMusicalInscripts system preferences) +Upgrade to 19.06.00.049 done (Bug 13958: Add a SuspensionsCalendar syspref) +Upgrade to 19.06.00.050 done (Bug 23293: Add 'OPACFineNoRenewalsIncludeCredits' system preference) +Upgrade to 19.11.00.000 [12:51:56]: 19.11.00 release +Upgrade to 19.12.00.000 [12:51:56]: Dobbie is a free elf... +Upgrade to 19.12.00.001 [12:51:56]: Bug 17831 - Remove non-existing bibliosubject.subject from frameworks +Upgrade to 19.12.00.002 [12:51:56]: Bug 23233 - Rename AllowItemsOnHoldCheckout syspref +Upgrade to 19.12.00.003 [12:51:56]: Bug 22284 - Add ft_local_hold_group column to library_groups +Upgrade to 19.12.00.004 [12:51:56]: Bug 24080 - Add PAYOUT account_debit_type +Upgrade to 19.12.00.005 [12:51:56]: Bug 24329 - Do not update action_log.timestamp +Upgrade to 19.12.00.006 [12:51:56]: Bug 24263 - Replace relationship with NULL when empty string +Upgrade to 19.12.00.007 [12:51:56]: Bug 23442 - Add REFUND to account_credit_types +Upgrade to 19.12.00.008 [12:51:56]: Bug 24206 - Update OpacSearchForTitleIn system preference +Upgrade to 19.12.00.009 [12:51:56]: Bug 23354 - Add 'Purchase' account offset type +Upgrade to 19.12.00.010 [12:51:56]: Bug 21520 - Add rule_order and rule_operator fields to oai_sets_mappings table +Upgrade to 19.12.00.011 [12:51:56]: Bug 24289 - Adding foreign keys on *_holidays.branchcode tables +Upgrade to 19.12.00.012 [12:51:56]: Bug 24481 - Move permission to correct module_bit +Upgrade to 19.12.00.013 [12:51:56]: Bug 24478 - Add `EnablePointOfSale` system preference to allow disabling the point of sale feature) +Upgrade to 19.12.00.014 [12:51:56]: Bug 24287 - Add 'reason' field to transfers table +Upgrade to 19.12.00.015 [12:51:56]: Bug 24296 - Update stockrotation to use 'reason' field in transfers table +Upgrade to 19.12.00.016 [12:51:56]: Bug 22868 - Move suggestions_manage subpermission out of acquisition permission +Upgrade to 19.12.00.017 [12:51:56]: Bug 21674 - Add unique key (parent_id, branchcode) to library_group +Upgrade to 19.12.00.018 [12:51:56]: Bug 18936 - Convert issuingrules fields to circulation_rules +Upgrade to 19.12.00.019 [12:51:56]: Bug 23673 - modify time_queued and add updated_on to message_queue +Upgrade to 19.12.00.020 [12:51:56]: Bug 8643 - Add important constraint to marc subfields +Upgrade to 19.12.00.021 [12:51:56]: Bug 24592 - Update LOST_RETURN to LOST_FOUND +Upgrade to 19.12.00.022 [12:51:56]: Bug 20882 - items.uri to MEDIUMTEXT +Upgrade to 19.12.00.023 [12:51:56]: Bug 24640 - Allow quotes.timestamp to be NULL +Upgrade to 19.12.00.024 [12:51:56]: Bug 21633 - Remove finesMode "test" +Upgrade to 19.12.00.025 [12:51:56]: Bug 24103 - add DumpSearchQueryTemplate syspref +Upgrade to 19.12.00.026 [12:51:56]: Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches +Upgrade to 19.12.00.027 [12:51:56]: Bug 24532 - Fix pathological cases of negative debits +Upgrade to 19.12.00.028 [12:51:56]: Bug 14567 - Add OpacBrowseSearch syspref +Upgrade to 19.12.00.029 [12:51:56]: Bug 17702 - Add column account_credit_types.archived +Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115. +Upgrade to 19.12.00.030 [12:51:56]: Bug 22880 - Move contents of opacheader preference to Koha news system +Upgrade to 19.12.00.031 [12:51:56]: Bug 22273 - Column article_requests.created_on should not be updated +Upgrade to 19.12.00.032 [12:51:56]: Bug 24735 - Remove UseQueryParser system preference +Upgrade to 19.12.00.033 [12:51:56]: Bug 23355 - Add cash_register_actions table +Upgrade to 19.12.00.034 [12:51:56]: Bug 24081 - Add DISCOUNT to account_credit_types and account_offset_types, Add accounts discount permission +Upgrade to 19.12.00.035 [12:51:56]: Bug 23442 - Add a refund option to the point of sale system +Upgrade to 19.12.00.036 [12:51:56]: Bug 24369 - Add CORS support to Koha +Upgrade to 19.12.00.037 [12:51:56]: Bug 23051 - Add RenewAccruingItemInOpac syspref +Upgrade to 19.12.00.038 [12:51:56]: Bug 23112 - Add CirculateILL syspref +Upgrade to 19.12.00.039 [12:51:56]: Bug 17845 - Drop unused table printers and branchprinter column +Upgrade to 19.12.00.040 [12:51:56]: Bug 17374 - Update description of DefaultPatronSearchFields +Upgrade to 19.12.00.041 [12:51:56]: Bug 24722 - Enforce NOT NULL constraint for reserves.priority +Upgrade to 19.12.00.042 [12:51:56]: Bug 22821 - Add reply_address to message_queue +Upgrade to 19.12.00.043 [12:51:56]: Bug 24296 - Add 'return' reasons to branchtransfers enum +Upgrade to 19.12.00.044 [12:51:57]: Bug 24846 - Add a new permission for new tool batch extend due dates +Upgrade to 19.12.00.045 [12:51:57]: Bug 4461 - Add CollapseFieldsPatronAddForm system preference +Upgrade to 19.12.00.046 [12:51:57]: Bug 24818 - Update 'accountlines.date' from DATE to TIMESTAMP +Upgrade to 19.12.00.047 [12:51:57]: Bug 22987 - Add biblioimages.timestamp +Upgrade to 19.12.00.048 [12:51:57]: Bug 24299 - Add 'collection' reasons to branchtransfers enum +Upgrade to 19.12.00.049 [12:51:57]: Bug 24299 - Add 'reserve' reasons to branchtransfers enum +Upgrade to 19.12.00.050 [12:51:57]: Bug 24854 - Remove IDreamBooks* system preferences +Upgrade to 19.12.00.051 [12:51:57]: Bug 24759 - Cleanup OpacRenewalBranch +Upgrade to 19.12.00.052 [12:51:57]: Bug 21443 - Add ability to exclude holidays when calculating rentals fees by time period +Upgrade to 19.12.00.053 [12:51:57]: Bug 24476 - Allow patrons to opt-out of autorenewal +Upgrade to 19.12.00.054 [12:51:57]: Bug 13881 - Add desk management +Upgrade to 19.12.00.055 [12:51:57]: Bug 23590 - Add lastmodificationby and lastmodificationdate to the suggestions table +Upgrade to 19.12.00.056 [12:51:57]: Bug 20415 - Remove UseKohaPlugins preference +Upgrade to 19.12.00.057 [12:51:57]: Bug 20399 - Remove INTRAdidyoumean preference +Upgrade to 19.12.00.058 [12:51:57]: Bug 14715 - Add sysprefs numSearchResultsDropdown and OPACnumSearchResultsDropdown +Upgrade to 19.12.00.059 [12:51:57]: Bug 18177 - Remove some unused columns from aqbooksellers +Upgrade to 19.12.00.060 [12:51:57]: Bug 23204 - Change enum order for marc_type in search_marc_map to fix sorting +Upgrade to 19.12.00.061 [12:51:57]: Bug 24474 - Add `onpayment` option to MarkLostItemsAsReturned +Upgrade to 19.12.00.062 [12:51:57]: Bug 25010 - Fix typo in account_debit_type description +Upgrade to 19.12.00.063 [12:51:57]: Bug 22534 - Add PreFillGuaranteeField syspref +Upgrade to 19.12.00.064 [12:51:57]: Bug 4944 - Add new system preference OpacNoItemTypeImages +Upgrade to 19.12.00.065 [12:51:57]: Bug 23173 - Add ILLCheckAvailability syspref +Upgrade to 19.12.00.066 [12:51:57]: Bug 4461 - Add OPACReportProblem system preference +Upgrade to 19.12.00.067 [12:51:57]: Bug 20754 - Remove double accepted list shares +Upgrade to 19.12.00.068 [12:51:57]: Bug 21190 - Add prefs AuthFailureLog and AuthSuccessLog +Upgrade to 19.12.00.069 [12:51:57]: Bug 22784 - Add a new suggestions.archived column +Upgrade to 19.12.00.070 [12:51:57]: Bug 22774 - Limit purchase suggestion in a specified time period +Upgrade to 19.12.00.071 [12:51:57]: Bug 22887 - Add unique constraint to authorised_values +Upgrade to 19.12.00.072 [12:51:57]: Bug 24380 - Add syspref CalculateFinesOnBackdate +Upgrade to 19.12.00.073 [12:51:57]: Bug 25152 - Update subscription.closed to tinyint(1) as per guidelines +Upgrade to 19.12.00.074 [12:51:57]: Bug 25147 - Rename AllowSelfCheckReturns to SCOAllowCheckin for consistency +Upgrade to 19.12.00.075 [12:51:57]: Bug 25086 - Set changed_fields column of borrower_modifications as nullable +Upgrade to 19.12.00.076 [12:51:57]: Bug 21901 - Add foreign key constraints on serial +Upgrade to 19.12.00.077 [12:51:57]: Bug 23727 - Editing course reserve items is broken +Upgrade to 19.12.00.078 [12:51:57]: Bug 24913 - Add PatronSelfRegistrationConfirmEmail syspref +Upgrade to 19.12.00.079 [12:51:57]: Bug 25045 - Add a way to restrict anonymous access to public routes (OpacPublic behaviour) +Upgrade to 19.12.00.080 [12:51:57]: Bug 23081 - Set default to 0 for items.issues +Upgrade to 19.12.00.081 [12:51:57]: Bug 22630 - Add course_items.homebranch +Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115. +Upgrade to 19.12.00.082 [12:51:57]: Bug 23794 - Move contents of OpacMainUserBlock preference to Koha news system +Upgrade to 19.12.00.083 [12:51:57]: Bug 17355 - Add is_system to authorised_value_categories table +Upgrade to 19.12.00.084 [12:51:58]: Bug 17682 - Add macros db table and permissions +Upgrade to 19.12.00.085 [12:51:58]: Bug 24161 - Add new join table aqorders_claims to keep track of claims +Upgrade to 19.12.00.086 [12:51:58]: Bug 24163 - Define a default CSV profile for late orders +Upgrade to 19.12.00.087 [12:51:58]: Bug 25184 - Items with a negative notforloan status should not be captured for holds +Upgrade to 19.12.00.088 [12:51:58]: Bug 24378 - Fix some grammatical errors in default auto renewal notice +Upgrade to 19.12.00.089 [12:51:58]: Bug 25389 - Catch errant cases of LOST_RETURNED +Upgrade to 19.12.00.090 [12:51:58]: Bug 13881 - Add issue desks system preference +Upgrade to 19.12.00.091 [12:51:58]: Bug 13881 - Correction to preference terminology +Upgrade to 20.05.00.000 [12:51:58]: 20.05.00 alpha release +Upgrade to 20.06.00.000 [12:51:58]: All our codebase are belong to everybody +Upgrade to 20.06.00.001 [12:51:59]: Bug 24986 - Switch borrowers address related fields to TINYTEXT or MEDIUMTEXT +Upgrade to 20.06.00.002 [12:51:59]: Bug 25184 - Items with a negative notforloan status should not be captured for holds +Upgrade to 20.06.00.003 [12:51:59]: Bug 24156 - Add new table tables_settings +Upgrade to 20.06.00.004 [12:51:59]: Bug 25851 - Remove holdallowed rule if value is an empty string +Upgrade to 20.06.00.005 [12:51:59]: Bug 24379 - Set login_attempts NOT NULL +Upgrade to 20.06.00.006 [12:51:59]: Bug 24151 - Add pseudonymized_transactions tables and sysprefs for Pseudonymization +Upgrade to 20.06.00.007 [12:51:59]: Bug 22844 - Add borrower_attribute_types.mandatory +Upgrade to 20.06.00.008 [12:51:59]: Bug 23148 - Replace Bridge icons with transparent PNG files +Upgrade to 20.06.00.009 [12:51:59]: Bug 23391 - Hide finished ILL requests +Upgrade to 20.06.00.010 [12:51:59]: Bug 20815 - Add NoRefundOnLostReturnedItemsAge system preference +Upgrade to 20.06.00.011 [12:51:59]: Bug 5087 - Add export_format.staff_only +Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115. +Upgrade to 20.06.00.012 [12:51:59]: Bug 23795 - Convert OpacCredits system preference to news block +Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115. +Upgrade to 20.06.00.013 [12:51:59]: Bug 23795 - Convert OpacCustomSearch system preference to news block +Upgrade to 20.06.00.014 [12:51:59]: Bug 23797 - Extend the opac_news lang column to accommodate longer values +Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115. +Upgrade to 20.06.00.015 [12:51:59]: Bug 23797 - Convert OpacLoginInstructions system preference to news block +Upgrade to 20.06.00.016 [12:51:59]: Bug 23092 - Add 'daterequested' field to transfers table +Upgrade to 20.06.00.017 [12:51:59]: Bug 25709 - Rename systempreference to NotesToHide +Upgrade to 20.06.00.018 [12:51:59]: Bug 24157 - Add new permissions reopen_closed_invoices, edit_invoices, delete_invoices, merge_invoices, delete_basket +Upgrade to 20.06.00.019 [12:51:59]: Bug 22660 - Adds NewsToolEditor system preference +Upgrade to 20.06.00.020 [12:51:59]: Bug 26070 - Remove references to deprecated Google Transliterate API +Upgrade to 20.06.00.021 [12:51:59]: Bug 25871 - Add library option to OpacItemLocation +Upgrade to 20.06.00.022 [12:51:59]: Bug 21946 - Add parent type to itemtypes +Upgrade to 20.06.00.023 [12:51:59]: Bug 16371 - Quote of the Day (QOTD) for the staff interface +Upgrade to 20.06.00.024 [12:51:59]: Bug 25867 - Update subfield descriptions for 952$a and 952$b +Upgrade to 20.06.00.025 [12:51:59]: Bug 6725 - Adds PatronDuplicateMatchingAddFields system preference +Upgrade to 20.06.00.026 [12:51:59]: Bug 19036 - Add accountlines.credit_number, account_credit_types.credit_number_enabled and syspref AutoCreditNumber +Upgrade to 20.06.00.027 [12:51:59]: Bug 8732 - Add new BiblioItemtypeInfo to system preferences +Upgrade to 20.06.00.028 [12:51:59]: Bug 25958 - Allow LongOverdue cron to exclude specified lost values +Upgrade to 20.06.00.029 [12:51:59]: Bug 25534 - Add ability to send an email specifying a reason when canceling a hold +Upgrade to 20.06.00.030 [12:51:59]: Bug 20057 - Add new system preference 'AutoApprovePatronProfileSettings' +Upgrade to 20.06.00.031 [12:52:00]: Bug 22789 - Add non_priority column on reserves and old_reserves tables +Upgrade to 20.06.00.032 [12:52:00]: Bug 19889 - Add exclude_from_local_holds_priority column to items, deleteditems and categories tables +Upgrade to 20.06.00.033 [12:52:00]: Bug 21066 - Rename column opac_news.timestamp with published_on +Upgrade to 20.06.00.034 [12:52:00]: Bug 24197 - Add new system preference 'AddressForFailedOverdueNotices' +Upgrade to 20.06.00.035 [12:52:00]: Bug 23682 - Add new system preference 'EdifactInvoiceImport' +Upgrade to 20.06.00.036 [12:52:00]: Bug 20168 - Update OPACSearchForTitleIn to work with Bootstrap 4 +Upgrade to 20.06.00.037 [12:52:00]: Bug 23816 - Add min_password_length and require_strong_password columns in categories table +Upgrade to 20.06.00.038 [12:52:00]: Bug 24807 - Add 'year' type to improve sorting behaviour +Upgrade to 20.06.00.039 [12:52:00]: Bug 18958 - Add reserve_id to hold_fill_targets +Upgrade to 20.06.00.040 [12:52:00]: Bug 26454 - Add system preference to set meta description for the OPAC +Upgrade to 20.06.00.041 [12:52:00]: Bug 26268 - Remove items.paidfor field +Upgrade to 20.06.00.042 [12:52:00]: Bug 25776 - Add letter.updated_on +Upgrade to 20.06.00.043 [12:52:00]: Bug 25261 - Add CircConfirmItemParts syspref +Upgrade to 20.06.00.044 [12:52:00]: Bug 22343 - Add SMTP configuration options +Upgrade to 20.06.00.045 [12:52:00]: Bug 22417 - Add new table background_jobs +Upgrade to 20.06.00.046 [12:52:00]: Bug 13535 - Add FK constraint on borrowernumber to alert table +Upgrade to 20.06.00.047 [12:52:00]: Bug 23420 - Allow configuration of hidden fields on the suggestion form in OPAC +Upgrade to 20.06.00.048 [12:52:00]: Bug 26529 - Remove blank default branch rules +Upgrade to 20.06.00.049 [12:52:00]: Bug 26145 - Add the biblioimages.itemnumber column +Upgrade to 20.06.00.050 [12:52:00]: Bug 19382 - Add ability to block guarantees based on fees owed by guarantor and other guarantee - new system preference 'NoIssuesChargeGuarantorsWithGuarantees' +Upgrade to 20.06.00.051 [12:52:00]: Bug 12556 - Add new syspref HoldsNeedProcessingSIP +Upgrade to 20.06.00.052 [12:52:00]: Bug 25460 - Update OAI set when adding/editing/deleting item records +Upgrade to 20.06.00.053 [12:52:00]: Bug 26569 - Use gender neutral pronouns in system preference explanations +Upgrade to 20.06.00.054 [12:52:00]: Bug 25596 - Add OVERPAYMENT credit type +Use of uninitialized value in numeric gt (>) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 23117. +Upgrade to 20.06.00.055 [12:52:00]: Bug 18050 - Add FK constraint on aqbudgets.budget_period_id +Upgrade to 20.06.00.056 [12:52:00]: Bug 26853 - Update import_biblios columns and indexes +Upgrade to 20.06.00.057 [12:52:00]: Bug 26638 - Add missing system preference ArticleRequestsMandatoryFieldsItemOnly +Upgrade to 20.06.00.058 [12:52:00]: Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva" +Upgrade to 20.06.00.059 [12:52:00]: Bug 19482 - Add mandatory column to search_field for ES mapping +Upgrade to 20.06.00.060 [12:52:00]: Bug 25334 - Add generic 'phone' message transport type +Upgrade to 20.06.00.061 [12:52:00]: Bug 24412 - Attach waiting reserve to desk +Upgrade to 20.06.00.062 [12:52:00]: Bug 23091 - Update refund rules +Upgrade to 20.06.00.063 [12:52:00]: Bug 14866 - Add decreaseloanholds circulation rule +Upgrade to 20.06.00.064 [12:52:00]: Bug 24603 - Add CANCELLATION credit_type_code +Upgrade to 20.06.00.065 [12:52:00]: Bug 23916 - Add new [old_]issues.issuer DB fields +Upgrade to 20.06.00.066 [12:52:00]: Bug 22818 - Add ILL notices +Upgrade to 20.06.00.067 [12:52:00]: Bug 20936 - Add new system preference OPACHoldsHistory +Upgrade to 20.06.00.068 [12:52:01]: Bug 23019 - Add import_batch_profiles table and profile_id column in import_batches +Upgrade to 20.06.00.069 [12:52:01]: Bug 24083 - Add circulation_rules 'unseen_renewals_allowed' +Upgrade to 20.11.00.000 [12:52:01]: Koha 20.11.00 release +Upgrade to 20.12.00.000 [12:52:01]: Sorry, this is my first life, I am still learning! +Upgrade to 20.12.00.001 [12:52:01]: Bug 27252 - Add ElasticsearchCrossFields system preference +Upgrade to 20.12.00.002 [12:52:01]: Bug 27351 - Set type for UsageStatsCountry to Choice +Upgrade to 20.12.00.003 [12:52:01]: Bug 27349 - Update type for Mana system preference to Choice +Upgrade to 20.12.00.004 [12:52:01]: Bug 27485 - Rename system preference 'gist' to 'TaxRates' +Upgrade to 20.12.00.005 [12:52:01]: Bug 27491 - Rename system preference 'opaclanguages' to 'OPACLanguages' +Upgrade to 20.12.00.006 [12:52:01]: Bug 27487 - Rename system preference 'reviewson' to 'OPACComments +Upgrade to 20.12.00.007 [12:52:01]: Bug 27486 - Renaming system preference 'delimiter' to 'CSVDelimiter' +Upgrade to 20.12.00.008 [12:52:01]: Bug 25552 - Add missing Claims Returned option to MarkLostItemsAsReturned +Upgrade to 20.12.00.009 [12:52:01]: Bug 27581 - Rename system preference 'UseICU' to 'UseICUStyleQuotes' +Upgrade to 20.12.00.010 [12:52:01]: Bug 20410 - Remove OpacGroupResults +Upgrade to 20.12.00.011 [12:52:01]: Bug 18506 - Add OPACShibOnly and staffShibOnly system preferences +Upgrade to 20.12.00.012 [12:52:01]: Bug 27598 - Add UPLOAD as a built-in system authorized value category +Upgrade to 20.12.00.013 [12:52:01]: Bug 24108 - Add system preference DefaultSaveRecordFileID +Upgrade to 20.12.00.014 [12:52:01]: Bug 7806 - Remove remaining possible 0000-00-00 values +Upgrade to 20.12.00.015 [12:52:01]: Bug 27316 - In Elastisearch mappings convert NULL (Undef) for sort to 1 (Yes) +Upgrade to 20.12.00.016 [12:52:01]: Bug 8976 - Allow setting a default sequence of subfields in cataloguing editor +Upgrade to 20.12.00.017 [12:52:01]: Bug 26937 - Add CheckPrevCheckoutDelay system preference) +Upgrade to 20.12.00.018 [12:52:01]: Bug 27808 - Adjust items.onloan if needed +Upgrade to 20.12.00.019 [12:52:01]: Bug 26057 - Add datecancelled field to branchtransfers +Upgrade to 20.12.00.020 [12:52:01]: Bug 24446 - Update stockrotation 'daterequested' field in transfers table +Upgrade to 20.12.00.021 [12:52:01]: Bug 22824 - Update syspref values for YesNo +Upgrade to 20.12.00.022 [12:52:01]: Bug 12224 - Add CHECKINSLIP notice +Upgrade to 20.12.00.023 [12:52:01]: Bug 27652 - Separate values for OPACHoldsIfAvailableAtPickupExceptions and BatchCheckoutsValidCategories with comma +Upgrade to 20.12.00.024 [12:52:01]: Bug 18532 - Messaging preferences for auto renewals +Upgrade to 20.12.00.025 [12:52:01]: Bug 27835 - Add new system preference ChargeFinesOnClosedDays +Upgrade to 20.12.00.026 [12:52:01]: Bug 26498 - Bug 26498 - Add option to set a default expire date for holds at reservation time +Upgrade to 20.12.00.027 [12:52:01]: Bug 27069 - Change holdallowed values from numbers to strings +Upgrade to 20.12.00.028 [12:52:01]: Bug 14233 - Add id field to letter table +Upgrade to 20.12.00.029 [12:52:01]: Bug 27726 - Increase field size for problem_reports.content +Upgrade to 20.12.00.030 [12:52:01]: Bug 21549 - Add new system preference LockExpiredDelay +Upgrade to 20.12.00.031 [12:52:01]: Bug 21260 - Add new system preference Reference_NFL_Statuses +Upgrade to 20.12.00.032 [12:52:01]: Bug 15986 - Add sample HOLD_REMINDER notice +Upgrade to 20.12.00.033 [12:52:01]: Bug 26940 - Put in sync borrowers.debarredcomment with comments from borrower_debarments +Upgrade to 20.12.00.034 [12:52:01]: Bug 20854 - Add new system preference casServerVersion +Upgrade to 20.12.00.035 [12:52:01]: Bug 23207 - Add automatic_checkin to itemtypes table +Upgrade to 20.12.00.036 [12:52:01]: Bug 16787 - Add noReservesAllowed to club holds error codes +Upgrade to 20.12.00.037 [12:52:01]: Bug 23971 - Add new system preference AcquisitionLog +Upgrade to 20.12.00.038 [12:52:01]: Bug 27281 - Add 'ItemLost' to branchtransfers.cancellation_reason enum +Upgrade to 20.12.00.039 [12:52:01]: Bug 12362 - Add 'TransferCancellation' to branchtransfers.reason enum +Upgrade to 20.12.00.040 [12:52:01]: Bug 27971 - Add VOID debit type code +Upgrade to 20.12.00.041 [12:52:01]: Bug 26734 - Update notices to use defaults +Upgrade to 20.12.00.042 [12:52:01]: Bug 17202 - Add FK constraint for collection to collections_tracking +Upgrade to 20.12.00.043 [12:52:01]: Bug 28258 - Update AUTO_RENEWAL content +Upgrade to 20.12.00.044 [12:52:01]: Bug 28244 - Fix Ukrainian typo in English +Upgrade to 20.12.00.045 [12:52:01]: Bug 21249 - Adding new system preference SearchLimitLibrary +Upgrade to 20.12.00.046 [12:52:01]: Bug 14723 - Additional delivery notes to messages +Upgrade to 20.12.00.047 [12:52:01]: Bug 23215 - Remove core PayPal support in favor of the use of plugins +Upgrade to 20.12.00.048 [12:52:01]: Bug 26995 - [SKIP] Drop column relationship from borrower tables [not executed] +Upgrade to 20.12.00.049 [12:52:01]: Bug 28108 - Move action logs 'SERIAL CLAIM' and 'ACQUISITION CLAIM' to a new 'CLAIMS' module +Upgrade to 20.12.00.050 [12:52:01]: Bug 28108 - Add new systempreference OpacHiddenItemsHidesRecord +Upgrade to 21.05.00.000 [12:52:01]: Koha 21.05.00 release +Use of uninitialized value $biblio_adds_authorities in string eq at /kohadevbox/koha/installer/data/mysql/db_revs/220600047.pl line 11. +Upgrade to 21.06.00.000 [12:52:01]: Increase DBRev for 21.06 + 🎵 Run, rabbit run. 🎶 + Dig that hole, forget the sun, + And when at last the work is done + Don't sit down it's time to dig another one. +Upgrade to 21.06.00.001 [12:52:01]: Bug 28489 - Modify sessions.a_session from longtext to longblob +Upgrade to 21.06.00.002 [12:52:01]: Bug 28490 - Bring back accidentally deleted relationship columns +Upgrade to 21.06.00.003 [12:52:01]: Bug 24434 - Add 'WrongTransfer' to branchtransfers.cancellation_reason enum +Upgrade to 21.06.00.004 [12:52:01]: Bug 15788 - Split edit_borrowers permission +Upgrade to 21.06.00.005 [12:52:01]: Bug 26205 - Add new system preference NewsLog to log news changes +Upgrade to 21.06.00.006 [12:52:01]: Bug 14237 - Add individual bibliographic records to course reserves + Add course_items.biblionumber column + Add fk_course_items_biblionumber constraint + Change course_items.itemnumber to allow NULL values +Upgrade to 21.06.00.007 [12:52:01]: Bug 11879 - Add a new field to patron record: main contact method +Upgrade to 21.06.00.008 [12:52:01]: Bug 20310 - Add new system preference ArticleRequestsOpacHostRedirection +Upgrade to 21.06.00.009 [12:52:01]: Bug 20472 - Add columns format and urls in article_requests table +Upgrade to 21.06.00.010 [12:52:01]: Bug 20472 - Add new system preference ArticleRequestsSupportedFormats +Upgrade to 21.06.00.011 [12:52:01]: Bug 28567 - Set to NULL empty branches fields +Upgrade to 21.06.00.012 [12:52:01]: Bug 15067 - Add missing languages +Upgrade to 21.06.00.013 [12:52:01]: Bug 22435 - Update existing offsets +Upgrade to 21.06.00.014 [12:52:01]: Bug 28813 - Update delivery_note to failure_code in message_queue +Upgrade to 21.06.00.015 [12:52:01]: Bug 12561 - Remove system preferences HighlightOwnItemsOnOPAC and HighlightOwnItemsOnOPACWhich +Upgrade to 21.06.00.016 [12:52:02]: Bug 24387 - Rename opac_news with additional_contents +Upgrade to 21.06.00.017 [12:52:02]: Bug 28872 - Update syspref values from on and off to 1 and 0 +Upgrade to 21.06.00.018 [12:52:02]: Bug 22690 - Add contraints to the linktracker table +Upgrade to 21.06.00.019 [12:52:02]: Bug 26302 - Add system preferences OPACResultsMaxItems and OPACResultsMaxItemsUnavailable +Upgrade to 21.06.00.020 [12:52:02]: Bug 28373 - Add new system preference PassItemMarcToXSLT + NOTE: You have defined a custom stylesheet for 'XSLTListsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT' + NOTE: You have defined a custom stylesheet for 'OPACXSLTDetailsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT' + NOTE: You have defined a custom stylesheet for 'OPACXSLTListsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT' + NOTE: You have defined a custom stylesheet for 'OPACXSLTResultsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT' +Upgrade to 21.06.00.021 [12:52:02]: Bug 28774 - Delete blank rental discounts +Upgrade to 21.06.00.022 [12:52:02]: Bug 28972 - Add missing foreign key constraints to holds queue table +Upgrade to 21.06.00.023 [12:52:02]: Bug 28534 - Set pending_offline_operations INNoDB rather than MyISAM +Upgrade to 21.06.00.024 [12:52:02]: Bug 29073 - Make DefaultHoldExpirationdate use 1/0 values +Upgrade to 21.06.00.025 [12:52:02]: Bug 28826 - A system preference FacetOrder +Upgrade to 21.06.00.026 [12:52:02]: Bug 28772 - Store hashed API key secrets +Upgrade to 21.06.00.027 [12:52:02]: Bug 29137 - Add system preference CreateAVFromCataloguing +Upgrade to 21.06.00.028 [12:52:02]: Bug 27944 - Add REQUESTED as enum element for status column, move AR_PENDING letter to AR_REQUESTED, and add new AR_PENDING letter +Upgrade to 21.06.00.029 [12:52:02]: Bug 27947 - Add authorised values list in article requests cancellation + Add AR_CANCELLATION category for authorised values + Add AR_CANCELLATION authorised values + Add cancellation_reason column in article_requests table + Replace notes by reason in notice AR_CANCELED +Upgrade to 21.06.00.030 [12:52:02]: Bug 25429 - Add new system preference CleanUpDatabaseReturnClaims +Upgrade to 21.06.00.031 [12:52:02]: Bug 18984 - Remove NORMARC from search_marc_map.marc_type +Upgrade to 21.06.00.032 [12:52:02]: Bug 29138 - Use a zero instead of a 'no' in LoadSearchHistoryToTheFirstLoggedUser +Upgrade to 21.06.00.033 [12:52:02]: Bug 29093 - Add column article_requests.toc_request +Upgrade to 21.06.00.034 [12:52:02]: Bug 28831 - Add system preferences OPACResultsUnavailableGroupingBy +Upgrade to 21.06.00.035 [12:52:02]: Bug 28153 - Add Hold Reminder messaging preference + Message attribute added + HOLD_REMINDER added to message_transports + Hold_Filled message preference copied to Hold_Reminder + Hold_Filled message transport preferences copied to Hold_Reminder +Upgrade to 21.06.00.036 [12:52:02]: Bug 29200 - Remove Adlibris cover service integration + AdlibrisCoversEnabled and AdlibrisCoversURL preferences removed. +Upgrade to 21.06.00.037 [12:52:02]: Bug 11175 - Show component records in detail views +Upgrade to 21.06.00.038 [12:52:02]: Bug 14957 - Add a way to define overlay rules for incoming MARC records + Added new table 'marc_overlay_rules' + Added new system preferences 'MARCOverlayRules' + Added new permissions 'manage_marc_overlay_rules' +Upgrade to 21.06.00.039 [12:52:02]: Bug 28959 - virtualshelves.category is really a boolean +Upgrade to 21.06.00.040 [12:52:02]: Bug 28263 - Update AUTO_RENEWAL too_many message +Upgrade to 21.06.00.041 [12:52:02]: Bug 27360 - Make display of libraries configurable +Upgrade to 21.06.00.042 [12:52:02]: Bug 26326 - Add primary key to import_record_matches +Upgrade to 21.06.00.043 [12:52:02]: Bug 29386 - Extend background_jobs.data to LONGTEXT +Upgrade to 21.06.00.044 [12:52:02]: Bug 29180 - Rename system preference RequestOnOpac with OPACHoldRequests +Upgrade to 21.06.00.045 [12:52:02]: Bug 24223 - Move contents of OpacNav system preference into additional contents + No OpacNav preference found. Update has already been run. +Upgrade to 21.06.00.046 [12:52:02]: Bug 24224 - Move contents of OpacNavBottom system preference into additional contents + No OpacNavBottom preference found. Update has already been run. +Upgrade to 21.06.00.047 [12:52:02]: Bug 28374 - Update point of sale print receipt + Added KohaDates, Branches and Price plugins + Replaced 'payment' with 'credit' param in RECEIPT template + Replaced 'offsets' with 'credit.debits' param in RECEIPT template + Replaced 'offset' with 'debit' param in RECEIPT template + Replaced 'debit.debit' with 'debit' param in RECEIPT template +Upgrade to 21.06.00.048 [12:52:02]: Bug 29341 - Remove foreign keys on pseudonymized_transactions +Upgrade to 21.06.00.049 [12:52:02]: Bug 5229 - Remove system preference 'OPACItemsResultsDisplay' +Upgrade to 21.11.00.000 [12:52:02]: Koha 21.11.00 release +Upgrade to 21.12.00.000 [12:52:02]: Increase DBRev for 21.12 + 📜 All that is gold does not glitter, + 📜 Not all those who wander are lost; + 📜 The old that is strong does not wither, + 📜 Deep roots are not reached by the frost. +Upgrade to 21.12.00.001 [12:52:02]: Bug 29586 - Add Hold Reminder messaging preference if missing +Upgrade to 21.12.00.002 [12:52:02]: Bug 13188 - Allow configuration of required fields when a patron is editing their information via the OPAC + Added new system preference 'PatronSelfModificationMandatoryField' with value 'surname|firstname' +Upgrade to 21.12.00.003 [12:52:02]: Bug 29457 - Fee Cancellation records the wrong manager_id + WARNING: You may have some incorrect manager_id's recorded against account cancellation lines, please see bugzilla for details. + NOTE: You may already have this bugfix applied at an earlier upgrade. +Upgrade to 21.12.00.004 [12:52:02]: Bug 26296 - Replace comma with pipe in OPACSuggestion field preferences +Upgrade to 21.12.00.005 [12:52:02]: Bug 29778 - Delete orphan additional contents +Upgrade to 21.12.00.006 [12:52:02]: Bug 29557 - Add auto_account_expired to AUTO_RENEWALS notice + Please update your AUTO_RENEWALS notice manually if you have changed or translated it +Upgrade to 21.12.00.007 [12:52:02]: Bug 20076 - Add system preference EmailOverduesNoEmail +Upgrade to 21.12.00.008 [12:52:02]: Bug 29495 - Drop issue_id constraint from return_claims table +Upgrade to 21.12.00.009 [12:52:02]: Bug 29336 - Resize authorised value category fields to 32 chars +Upgrade to 21.12.00.010 [12:52:02]: Bug 21729 - Add new column reserves.patron_expiration_date +Upgrade to 21.12.00.011 [12:52:02]: Bug 27946 - Add article request fees +Upgrade to 21.12.00.012 [12:52:02]: Bug 24220 - Move OpacMoreSearches to additional contents + No OpacMoreSearches preference found. Value was empty or update has already been run. +Upgrade to 21.12.00.013 [12:52:03]: Bug 29605 - Resync DB structure for existing installations + Added missing primary key on language_script_mapping + Ensure NOT NULL on account_offsets.type + Ensure additional_contents.code is VARCHAR(100) + Ensure additional_contents.lang is VARCHAR(50) + Ensure NOT NULL on search_marc_map.marc_type + Ensure branchtransfers.cancellation_reason enum values are uppercase +Upgrade to 21.12.00.014 [12:52:03]: Bug 29596 - Add Yiddish language +Upgrade to 21.12.00.015 [12:52:03]: Bug 29943 - Fix typo in NOTIFY_MANAGER notice +Upgrade to 21.12.00.016 [12:52:03]: Bug 30060 - Update user_permissions to add primary key and remove null option from code column + Removed any duplicate rows + Added a primary key on user_permissions on borrowernumber, module_bit, code +Upgrade to 21.12.00.017 [12:52:03]: Bug 30128 - Change language_subtag_registry.description to varchar(255) +Upgrade to 21.12.00.018 [12:52:03]: Bug 19532 - Add Recalls +Upgrade to 21.12.00.019 [12:52:03]: Bug 27812 - Remove the ability to transmit a patron's plain text password over email + The notice template ACCTDETAILS no longer has access to the patron's plain text password. Please update the language of your ACCTDETAILS as needed. +Upgrade to 21.12.00.020 [12:52:03]: Bug 24221 - Move OpacMySummaryNote to additional contents + No OpacMySummaryNote preference found. Value was empty or update has already been run. +Upgrade to 21.12.00.021 [12:52:03]: Bug 30063 - Fix DefaultPatronSearchFields order +Upgrade to 21.12.00.022 [12:52:03]: Bug 11083 - Add syspref AuthorityXSLTResultsDisplay +Upgrade to 21.12.00.023 [12:52:03]: Bug 20517 - Add SIP2SortBinMapping system preference +Upgrade to 21.12.00.024 [12:52:03]: Bug 20398 - Add system preference StaffHighlightedWords +Upgrade to 21.12.00.025 [12:52:03]: Bug 29990 - Add new system preference ShowHeadingUse +Upgrade to 21.12.00.026 [12:52:03]: Bug 17018 - Split AdvancedSearchTypes for staff and OPAC +Upgrade to 21.12.00.027 [12:52:03]: Bug 26346 - Add allow_change_from_staff to virtualshelves table +Upgrade to 21.12.00.028 [12:52:03]: Bug 16258 - A preference to enabled/disable edifact +Upgrade to 21.12.00.029 [12:52:03]: Bug 30130 - A standard to edi_account +Upgrade to 21.12.00.030 [12:52:03]: Bug 30135 - Add EdifactLSQ mapping system preference +Upgrade to 21.12.00.031 [12:52:03]: Bug 30481 - DB schema sync for deleteditems +Upgrade to 21.12.00.032 [12:52:03]: Bug 30498 - Correct enum search_field.type +Upgrade to 21.12.00.033 [12:52:03]: Bug 27783 - Add background_jobs.queue + Added background_jobs.queue +Upgrade to 21.12.00.034 [12:52:03]: Bug 30237 - Replace ACCDETAILS notice with WELCOME notice +Upgrade to 21.12.00.035 [12:52:03]: Bug 30226 - Add the system preference AllowSetAutomaticRenewal +Upgrade to 21.12.00.036 [12:52:03]: Bug 28786 - Add syspref TwoFactorAuthentication, fields secret and auth_method +Upgrade to 21.12.00.037 [12:52:03]: Bug 27253 - Fix definition of borrowers.updated_on and deletedborrowers.updated_on + Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated + Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated + Fixed definition of borrowers.updated_on + Fixed definition of deletedborrowers.updated_on +Upgrade to 21.12.00.038 [12:52:03]: Bug 29648 - Move NumSavedReports to table settings and allow tables_settings.default_display_length to be NULL + NumSavedReports value '20' moved to table settings +Upgrade to 21.12.00.039 [12:52:03]: Bug 29092 - Add timestamp to account-fines table column settings +Upgrade to 21.12.00.040 [12:52:03]: Bug 30565 - Update table stockrotationrotas +Upgrade to 21.12.00.041 [12:52:03]: Bug 30449 - Check borrower_attribute_types FK constraint +Upgrade to 21.12.00.042 [12:52:03]: Bug 30572 - Adjust search_marc_to_field.sort +Upgrade to 21.12.00.043 [12:52:03]: Bug 30108 - Add preference OPACMandatoryHoldDates +Upgrade to 21.12.00.044 [12:52:03]: Bug 29894 - Add 2FA (de)enabling notices +Upgrade to 21.12.00.045 [12:52:03]: Bug 14242 - Add OPACSuggestionAutoFill system preference +Upgrade to 21.12.00.046 [12:52:03]: Bug 22785 - Add chosen column to import_record_matches + chosen column added to import_record_matches +Upgrade to 21.12.00.047 [12:52:03]: Bug 28138 - Add system preference RequirePaymentType +Upgrade to 21.12.00.048 [12:52:03]: Bug 30291 - Renaming recalls table columns +Upgrade to 21.12.00.049 [12:52:03]: Bug 30563 - Add system preference RequireCashRegister +Upgrade to 21.12.00.050 [12:52:03]: Bug 29924 - Add password expiration + Added password_expiry_days to categories + Added password_expiration_date field to borrowers + Added password_expiration_date field to borrowers +Upgrade to 21.12.00.051 [12:52:03]: Bug 29925 - Add password reset option +Upgrade to 21.12.00.052 [12:52:03]: Bug 30290 - Modify AR notices, include TOC line +Upgrade to 21.12.00.053 [12:52:03]: Bug 30611 - Add STAFF_PASSWORD_RESET notice +Upgrade to 21.12.00.054 [12:52:03]: Bug 23352 - Adding new column 'subscription.ccode' +Upgrade to 21.12.00.055 [12:52:03]: Bug 13412 - Add GenerateAuthorityField667 and GenerateAuthorityField670 system preferences +Upgrade to 21.12.00.056 [12:52:03]: Bug 30728 - Allow opting out of real-time holds queue updating possible +Upgrade to 21.12.00.057 [12:52:03]: Bug 30852 - Add index to article_requests.debit_id +Upgrade to 22.05.00.000 [12:52:03]: Koha 22.05.00 release +Upgrade to 22.06.00.000 [12:52:03]: Increase DBRev for 22.06 + 📜 The road of excess + 📜 leads to the palace of wisdom; + 📜 for we never know what is enough + 📜 until we know what is more than enough. +Upgrade to 22.06.00.001 [12:52:03]: Bug 23659 - Add DefaultHoldPickupLocation syspref + Added DefaultHoldPickupLocation syspref +Upgrade to 22.06.00.002 [12:52:03]: Bug 30850 - Message about mappings changes for 110$a + 110$a was added as a default mapping for biblio.author in MARC21. This will only change the mapping on new installations. If you wish to change the mappings on your existing installation, go to Administration > Koha to MARC mapping and add 110$a to biblio.author and then run batchRebuilBiblioTables.pl. +Upgrade to 22.06.00.003 [12:52:03]: Bug 30924 - Add missing RecallCancellation option to branchtransfers.reason ENUM +Upgrade to 22.06.00.004 [12:52:03]: Bug 12446 - Ability to allow guarantor relationship for all patron category types +Upgrade to 22.06.00.005 [12:52:03]: Bug 24239 - Add due_date to illrequests +Upgrade to 22.06.00.006 [12:52:03]: Bug 21978 - Add middle_name to borrowers table + Added middle name column to borrowers table + Added middle name column to deletedborrowers table + Added middle name column to borrower_modifications table + Added middle name to DefaultPatronSearchFields +Upgrade to 22.06.00.007 [12:52:03]: Bug 29129 - Update the DisplayClearnScreenButton system pref to allow for a choice between ISSUESLIP and ISSUEQSLIP +Upgrade to 22.06.00.008 [12:52:03]: Bug 30327 - Add ComponentSortField and ComponentSortOrder sysprefs + Added ComponentSortField and ComponentSortOrder sysprefs +Upgrade to 22.06.00.009 [12:52:03]: Bug 30889 - Add calling context information to background_jobs +Upgrade to 22.06.00.010 [12:52:03]: Bug 30823 - Replace recalls FULFILL actions with FILL in action logs +Upgrade to 22.06.00.011 [12:52:04]: Bug 30275 - Add a checkout_renewals table + Added new table 'checkout_renewals' + Renamed `issues.renewals` to `issues.renewals_count` + Renamed `old_issues.renewals` to `old_issues.renewals_count` +Upgrade to 22.06.00.012 [12:52:04]: Bug 24010 - Make subscription.staffdisplaycount and opacdisplaycount integer columns +Upgrade to 22.06.00.013 [12:52:04]: Bug 24865 - Customize the Accountlines Description +Upgrade to 22.06.00.014 [12:52:04]: Bug 24857 - Add ability to group items on a record +Upgrade to 22.06.00.015 [12:52:04]: Bug 28854 - Item bundles support + item_bundles table added + Missing from bundle LOST AV added + Added to bundle NOT_LOAN AV added + System preferences added and set + Dropped unique constraint on issue_id in return_claims +Upgrade to 22.06.00.016 [12:52:04]: Bug 28854 - Add new unique index to return claims + item_issue index added to return_claims +Upgrade to 22.06.00.017 [12:52:04]: Bug 29632 - Add callnumber type to allow sorting + Add callnumber to search_field type enum +Upgrade to 22.06.00.018 [12:52:04]: Bug 11889 - Add pref ListOwnershipUponPatronDeletion +Upgrade to 22.06.00.019 [12:52:04]: Bug 30933 - Add pref ListOwnerDesignated +Upgrade to 22.06.00.020 [12:52:04]: Bug 31086 - Do not allow null values in branchcodes for reserves + Removed NULL option from branchcode for reserves +Upgrade to 22.06.00.021 [12:52:04]: Bug 31157 - Add OverdueNoticeFrom preference +Upgrade to 22.06.00.022 [12:52:04]: Bug 30650 - Curbside pickup tables +Upgrade to 22.06.00.023 [12:52:04]: Bug 22456 - Allow cancelling waiting holds +Upgrade to 22.06.00.024 [12:52:04]: Bug 29012 - Some rules are not saved when left blank while editing a 'rule' line in smart-rules.pl + Add default values for blank circulation rules that weren't saved to the database +Upgrade to 22.06.00.025 [12:52:04]: Bug 14364 - Allow automatically canceled expired waiting holds to fill the next hold + Added ExpireReservesAutoFill system preferences + Added HOLD_CHANGED notice +Upgrade to 22.06.00.026 [12:52:04]: Bug 30984 - Log the cron script that generated an action log if there is one +Upgrade to 22.06.00.027 [12:52:04]: Bug 28269 - Add new system preference SearchWithISSNVariations +Upgrade to 22.06.00.028 [12:52:04]: Bug 30077 - Add new system preference IntranetAddMastheadLibraryPulldown +Upgrade to 22.06.00.029 [12:52:04]: Bug 30392 - Add deleteditems.deleted_on +Upgrade to 22.06.00.030 [12:52:04]: Bug 31274 - OPACSuggestionAutoFill must be 1 or 0 +Upgrade to 22.06.00.031 [12:52:04]: Bug 30327 - Add biblionumber to ComponentSortField + Added biblionumber option to ComponentSortField +Upgrade to 22.06.00.032 [12:52:04]: Bug 30500 - Add option to allow user to change the pickup location while a hold is in transit + Added new system preference 'OPACInTransitHoldPickupLocationChange' +Upgrade to 22.06.00.033 [12:52:04]: Bug 27779 - Simplify credit descriptions +Upgrade to 22.06.00.034 [12:52:04]: Bug 29897 - Add new system preference OPACAuthorIdentifiers +Upgrade to 22.06.00.035 [12:52:04]: Bug 28787 - Add new letter 2FA_OTP_TOKEN +Upgrade to 22.06.00.036 [12:52:04]: Bug 31017 - Add type option to vendors + Added type column to aqbooksellers + Added VENDOR_TYPE authorised value category +Upgrade to 22.06.00.037 [12:52:04]: Bug 23681 - Add customisable patron restriction types + Added restriction_types table + Added system restriction_types + Added borrower_debarments relation + Added manage_patron_restrictions permission + Added PatronRestrictionTypes preference +Upgrade to 22.06.00.038 [12:52:04]: Bug 30335 - Add manual_invoice and manual_credit permissions +Upgrade to 22.06.00.039 [12:52:04]: Bug 31374 - Add a non-public note column to the suggestions table + Add staff_note column to suggestions table +Upgrade to 22.06.00.040 [12:52:04]: Bug 30619 - Add email notice for Point of Sale > RECEIPT +Upgrade to 22.06.00.041 [12:52:04]: Bug 30483 - Make issues.borrowernumber and issues.itemnumber NOT NULL +Upgrade to 22.06.00.042 [12:52:04]: Bug 27981 - Make it possible to force 001 = biblionumber + Added system preference autoControlNumber +Upgrade to 22.06.00.043 [12:52:04]: Bug 20058 - Option to use shelving location instead of homebranch for sorting + Syspref UseLocationAsAQInSIP has been added +Upgrade to 22.06.00.044 [12:52:04]: Bug 26247 - Add new retain search terms preferences + Added `RetainCatalogSearchTerms` preference + Added `RetainPatronsSearchTerms` preference +Upgrade to 22.06.00.045 [12:52:04]: Bug 29144 - Copy and remove branches.opac_info +Upgrade to 22.06.00.046 [12:52:04]: Bug 15348 - Add new column aqorders.estimated_delivery_date +Upgrade to 22.06.00.047 [12:52:04]: Bug 30025 - Split and rename BiblioAddsAuthorities system preference + Added RequireChoosingExistingAuthority and AutoLinkBiblios + BiblioAddsAuthorities removed +Upgrade to 22.06.00.048 [12:52:04]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL +Upgrade to 22.06.00.049 [12:52:04]: Bug 30490 - Adjust FK constraint for parent item type +Upgrade to 22.06.00.050 [12:52:04]: Bug 30497 - Recreate old_reserves_ibfk_4 if cascading +Upgrade to 22.06.00.051 [12:52:04]: Bug 7021 - Add patron category to the statistics table +Upgrade to 22.06.00.052 [12:52:04]: Bug 25735 - Add Elasticsearch field 'available' +Upgrade to 22.06.00.053 [12:52:04]: Bug 30484 - Add a notice template for ILL Update notices + Bug 30484 DB update complete +Upgrade to 22.06.00.054 [12:52:04]: Bug 23538 - Add new system preferences EmailPatronRegistrations and EmailAddressForPatronRegistrations and new OPAC_REG letter +Upgrade to 22.06.00.055 [12:52:04]: Bug 26368 - Add OCLC Encoding Levels system preference + Added UseOCLCEncodingLevels system preference +Upgrade to 22.06.00.056 [12:52:04]: Bug 30571 - Table z3950servers: three cols NOT NULL +Upgrade to 22.06.00.057 [12:52:04]: Bug 29071 - Set HoldsQueueSplitNumbering where not set + Added HoldsSplitQueueNumbering if not already there +Upgrade to 22.06.00.058 [12:52:05]: Bug 30944 - Replace branchtransfers.cancellation_reason CancelRecall with RecallCancellation +Upgrade to 22.06.00.059 [12:52:05]: Bug 25936 - A password change notification feature +Upgrade to 22.06.00.060 [12:52:05]: Bug 10950 - Add pronouns to borrowers table + Added pronouns column to borrowers table + Added pronouns column to deletedborrowers table + Added pronouns column to borrower_modifications table +Upgrade to 22.06.00.061 [12:52:05]: Bug 31333 - Add new suggestionPatronCategoryExceptions system preference +Upgrade to 22.06.00.062 [12:52:05]: Bug 27136 - Add missing languages: Cree, Afrikaans and Multiple languages, Undetermined and No linguistic content + Added missing languages +Upgrade to 22.06.00.063 [12:52:05]: Bug 31569 - Add primary key for import_biblios + Added primary key to import_biblios table +Upgrade to 22.06.00.064 [12:52:05]: Bug 14783 - Allow patrons to change pickup location for non-waiting holds + Added new system preference 'OPACAllowUserToChangeBranch' + Removed system preference 'OPACInTransitHoldPickupLocationChange' +Upgrade to 22.06.00.065 [12:52:05]: Bug 25426 - Add new syspref CircControlReturnsBranch + Added new system preference 'CircControlReturnsBranch' +Upgrade to 22.06.00.066 [12:52:05]: Bug 31626 - Add letter id to the message queue table + Added 'letter_id' column to 'message_queue' table +Upgrade to 22.06.00.067 [12:52:05]: Bug 17170 - Add permission for creating saved search filters + Added manage_search_filters permission + Added search_filters table + Added SavedSearchFilters system preference +Upgrade to 22.06.00.068 [12:52:05]: Bug 30588 - Add an 'enforce' option for TwoFactorAuthentication +Upgrade to 22.06.00.069 [12:52:05]: Bug 31715 - Add missing German (de) language translations + German (de) translations were added +Upgrade to 22.06.00.070 [12:52:05]: Bug 31577 - Add category list pull-down to OpacHiddenItemsExceptions + Settings for OpacHiddenItemsExceptions have been updated +Upgrade to 22.06.00.071 [12:52:05]: Bug 23012 - Add PROCESSING_FOUND to account_credit_types +Upgrade to 22.06.00.072 [12:52:05]: Bug 24381 - Update accounts notices +Upgrade to 22.06.00.073 [12:52:05]: Bug 30036 - Add syspref AuthorityXSLTOpacResultsDisplay +Upgrade to 22.06.00.074 [12:52:05]: Bug 30407 - Add ability to syspref UpdateNotForLoanStatusOnCheckin to show only the notforloan values message + Update is going well so far +Upgrade to 22.06.00.075 [12:52:05]: Bug 31948 - Add timestamp to tmp_holdsqueue table +Upgrade to 22.06.00.076 [12:52:05]: Bug 29792 - Add AutomaticConfirmTransfer system preference + AutomaticConfirmTransfer system preference added +Upgrade to 22.06.00.077 [12:52:05]: Bug 31713 - Add ACCOUNTS_SUMMARY slip notice + Notice added +Upgrade to 22.06.00.078 [12:52:05]: Bug 24860 - Add ability to place item group level holds + Added new system preference 'EnableItemGroupHolds' +Upgrade to 22.06.00.079 [12:52:05]: Bug 32030 - Add an ERM module +Upgrade to 22.06.00.080 [12:52:05]: Bug 30880 - Add branchonly option to OPACResultsUnavailableGroupingBy syspref +Upgrade to 22.06.00.081 [12:52:05]: Bug 31378 - Add identity_provider and identity_provider_domains configuration tables + manage_identity_providers permission added +Upgrade to 22.06.00.082 [12:52:05]: Bug 30250 - Add new system preference ApplyFrameworkDefaults + Added new system preference 'ApplyFrameworkDefaults' +Upgrade to 22.06.00.083 [12:52:05]: Bug 24606 - Add new table item_editor_templates -- 2.25.1