View | Details | Raw Unified | Return to bug 30951
Collapse All | Expand All

(-)a/output (-1 / +1915 lines)
Line 0 Link Here
0
- 
1
Use of uninitialized value in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 78.
2
DBD::mysql::db do failed: Table 'koha_kohadev.bookshelf' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 81.
3
DBD::mysql::db do failed: Table 'koha_kohadev.shelfcontents' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 82.
4
DBD::mysql::db do failed: Duplicate column name 'biblionumber' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 83.
5
DBD::mysql::db do failed: Unknown column 'virtualshelfcontents.itemnumber' in 'where clause' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 84.
6
DBD::mysql::db do failed: Duplicate key name 'biblionumber' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 86.
7
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.
8
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.
9
DBD::mysql::db do failed: Can't DROP COLUMN `itemnumber`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 91.
10
Upgrade to 3.00.00.001 done (virtualshelves)
11
Upgrade to 3.00.00.002 done (sessions uses CGI::session, new table structure for sessions)
12
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 112.
13
Upgrade to 3.00.00.003 done (adding ReservesNeedReturns systempref, in circulation)
14
Upgrade to 3.00.00.004 done (adding DebugLevel systempref, in 'Admin' tab)
15
DBD::mysql::db do failed: Table 'tags' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 131.
16
DBD::mysql::db do failed: Table 'nozebra' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 137.
17
Upgrade to 3.00.00.005 done (adding tags and nozebra tables )
18
Upgrade to 3.00.00.006 done (filled issues.issuedate with timestamp)
19
Upgrade to 3.00.00.007 done (set SessionStorage variable)
20
DBD::mysql::db do failed: Duplicate column name 'datecreated' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 166.
21
Upgrade to 3.00.00.008 done (biblio creation date)
22
DBD::mysql::db do failed: Unknown column 'classification' in 'field list' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 183.
23
DBD::mysql::db do failed: Unknown column 'volumeddesc' in 'biblioitems' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 190.
24
DBD::mysql::db do failed: Unknown column 'classification' in 'field list' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 210.
25
DBD::mysql::db do failed: Can't DROP COLUMN `classification`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 217.
26
DBD::mysql::db do failed: Can't DROP COLUMN `marc`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 224.
27
DBD::mysql::db do failed: Unknown column 'volumeddesc' in 'deletedbiblioitems' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 230.
28
DBD::mysql::db do failed: Unknown column 'classification' in 'field list' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 251.
29
DBD::mysql::db do failed: Can't DROP COLUMN `classification`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 256.
30
DBD::mysql::db do failed: Can't DROP COLUMN `bulk`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 265.
31
DBD::mysql::db do failed: Duplicate column name 'cn_source' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 295.
32
DBD::mysql::db do failed: Can't DROP COLUMN `cutterextra`; check that it exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 312.
33
Upgrade to 3.00.00.009 done (major changes to biblio, biblioitems, items, and deleted* versions of same
34
DBD::mysql::db do failed: Duplicate key name 'userid' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 321.
35
Upgrade to 3.00.00.010 done (userid index added)
36
DBD::mysql::db do failed: Duplicate column name 'categorytype' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 330.
37
Upgrade to 3.00.00.011 done (added branchcategory type)
38
DBD::mysql::db do failed: Table 'class_sort_rules' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 339.
39
DBD::mysql::db do failed: Table 'class_sources' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 346.
40
Upgrade to 3.00.00.012 done (classification sources added)
41
DBD::mysql::db do failed: Table 'import_batches' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 376.
42
DBD::mysql::db do failed: Table 'import_records' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 391.
43
DBD::mysql::db do failed: Table 'import_record_matches' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 413.
44
DBD::mysql::db do failed: Table 'import_biblios' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 421.
45
DBD::mysql::db do failed: Table 'import_items' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 437.
46
DBD::mysql::db do failed: Table 'koha_kohadev.marc_breeding' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 452.
47
DBD::mysql::db do failed: Table 'koha_kohadev.marc_breeding' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 457.
48
DBD::mysql::db do failed: Table 'koha_kohadev.marc_breeding' doesn't exist at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 464.
49
DBD::mysql::db do failed: Unknown table 'koha_kohadev.marc_breeding' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 477.
50
Upgrade to 3.00.00.013 done (import_batches et al. added)
51
DBD::mysql::db do failed: Duplicate column name 'lastbranch' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 485.
52
Upgrade to 3.00.00.014 done (userid index added)
53
DBD::mysql::db do failed: Table 'saved_sql' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 492.
54
DBD::mysql::db do failed: Table 'saved_reports' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 505.
55
Upgrade to 3.00.00.015 done (saved_sql and saved_reports added)
56
DBD::mysql::db do failed: Table 'reports_dictionary' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 518.
57
Upgrade to 3.00.00.016 done (reports_dictionary) added)
58
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.
59
DBD::mysql::db do failed: Duplicate key name 'timestamp' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 535.
60
DBD::mysql::db do failed: Duplicate column name 'action_id' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 536.
61
DBD::mysql::db do failed: Multiple primary key defined at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 538.
62
Upgrade to 3.00.00.017 done (added column to action_logs)
63
DBD::mysql::db do failed: Duplicate column name 'done' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 545.
64
Upgrade to 3.00.00.018 done (adding timestamp and done columns to zebraque table to improve problem tracking) added)
65
Upgrade to 3.00.00.019 done (made bib/item PKs auto_increment)
66
Upgrade to 3.00.00.020 done (dropped uniqueness of key on deleteditems.barcode)
67
Upgrade to 3.00.00.021 done (extended missed branchcode columns to 10 chars)
68
DBD::mysql::db do failed: Duplicate column name 'damaged' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 583.
69
DBD::mysql::db do failed: Duplicate column name 'damaged' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 585.
70
Upgrade to 3.00.00.022 done (adding damaged column to items table)
71
Upgrade to 3.00.00.023 done (adding new system preference for controlling YUI path)
72
Upgrade to 3.00.00.024 done (changing itemtype to (10))
73
DBD::mysql::db do failed: Duplicate column name 'itype' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 607.
74
Upgrade to 3.00.00.025 done (reintroduce items.itype - fill from itemtype)
75
 Upgrade to 3.00.00.026 done (adding new system preference for choosing whether homebranch or holdingbranch is checked in circulation)
76
DBD::mysql::db do failed: Table 'marc_matchers' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 626.
77
DBD::mysql::db do failed: Table 'matchpoints' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 636.
78
DBD::mysql::db do failed: Table 'matchpoint_components' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 645.
79
DBD::mysql::db do failed: Table 'matchpoint_component_norms' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 658.
80
DBD::mysql::db do failed: Table 'matcher_matchpoints' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 666.
81
DBD::mysql::db do failed: Table 'matchchecks' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 674.
82
Upgrade to 3.00.00.027 done (added C4::Matcher serialization tables)
83
 Upgrade to 3.00.00.028 done (adding new system preference for changing reserve/holds behaviour with independent branches)
84
DBD::mysql::db do failed: Duplicate column name 'matcher_id' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 702.
85
Upgrade to 3.00.00.029 done (adding matcher_id to import_batches)
86
DBD::mysql::db do failed: Table 'services_throttle' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 709.
87
Upgrade to 3.00.00.030 done (adding services throttle table and sysprefs for xISBN)
88
Upgrade to 3.00.00.031 done (adding additional system preference)
89
Upgrade to 3.00.00.032 done (fixed MARC framework references to items.withdrawn)
90
Upgrade to 3.00.00.033 done (Adding permissions flag for staff member access modification.  )
91
DBD::mysql::db do failed: Duplicate column name 'sortfield' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 783.
92
Upgrade to 3.00.00.034 done (Adding sortfield for Virtual Shelves.  )
93
Upgrade to 3.00.00.035 done (MARC frameworks: make classification source a drop-down)
94
Upgrade to 3.00.00.036 done (OPACItemsResultsDisplay systempreference added)
95
DBD::mysql::db do failed: Duplicate column name 'altcontactfirstname' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 807.
96
DBD::mysql::db do failed: Duplicate column name 'altcontactsurname' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 808.
97
DBD::mysql::db do failed: Duplicate column name 'altcontactaddress1' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 809.
98
DBD::mysql::db do failed: Duplicate column name 'altcontactaddress2' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 810.
99
DBD::mysql::db do failed: Duplicate column name 'altcontactaddress3' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 811.
100
DBD::mysql::db do failed: Duplicate column name 'altcontactzipcode' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 812.
101
DBD::mysql::db do failed: Duplicate column name 'altcontactphone' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 813.
102
Upgrade to 3.00.00.037 done (Adding Alternative Contact Person information to borrowers table)
103
Upgrade to 3.00.00.038 done ('alter finesMode systempreference, remove superfluous syspref.')
104
Upgrade to 3.00.00.039 done ('add circ sysprefs CircControl, finesCalendar, and uppercasesurnames, and delete HomeOrHoldingBranch.')
105
Upgrade to 3.00.00.040 done ('add circ sysprefs todaysIssuesDefaultSortOrder and previousIssuesDefaultSortOrder.')
106
Upgrade to 3.00.00.041 done (disallow NULL in several item status columns)
107
DBD::mysql::db do failed: Duplicate column name 'symbol' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 881.
108
Upgrade to 3.00.00.043 done (currency table: add symbol and timestamp columns)
109
DBD::mysql::db do failed: Duplicate column name 'altcontactfirstname' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 888.
110
Upgrade to 3.00.00.044 done (syncing deletedborrowers table with borrowers table)
111
DBD::mysql::db do failed: Table 'language_subtag_registry' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 912.
112
DBD::mysql::db do failed: Table 'language_rfc4646_to_iso639' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 924.
113
DBD::mysql::db do failed: Table 'language_descriptions' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 930.
114
DBD::mysql::db do failed: Table 'language_script_bidi' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 939.
115
DBD::mysql::db do failed: Table 'language_script_mapping' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 953.
116
Upgrade to 3.00.00.045 done (adding language subtag registry and basic BiDi support NOTE: You should import the subtag registry SQL)
117
DBD::mysql::db do failed: Table 'serialitems' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 973.
118
Upgrade to 3.00.00.046 done (Add serialitems table to link serial issues to items. )
119
Upgrade to 3.00.00.047 done ( Added OpacRenewalAllowed syspref )
120
DBD::mysql::db do failed: Duplicate column name 'more_subfields_xml' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 988.
121
Upgrade to 3.00.00.048 done (added items.more_subfields_xml)
122
DBD::mysql::db do failed: Duplicate column name 'encoding' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 995.
123
Upgrade to 3.00.00.049 done ( Added encoding field to z3950servers table )
124
Upgrade to 3.00.00.050 done ( Added OpacHighlightedWords syspref )
125
Upgrade to 3.00.00.051 done ( Corrected opacthemes explanation. )
126
DBD::mysql::db do failed: Duplicate column name 'more_subfields_xml' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1016.
127
Upgrade to 3.00.00.052 done ( Adding missing column to deleteditems table. )
128
DBD::mysql::db do failed: Table 'printers_profile' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1023.
129
DBD::mysql::db do failed: Table 'labels_profile' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1037.
130
Upgrade to 3.00.00.053 done ( Printer Profile tables added )
131
Upgrade to 3.00.00.054 done ( Added another barcode autogeneration sequence to barcode.pl. )
132
DBD::mysql::db do failed: Duplicate key name 'zebraqueue_lookup' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1056.
133
Upgrade to 3.00.00.055 done ( Added index on zebraqueue. )
134
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1062.
135
DBD::mysql::db do failed: Duplicate column name 'enumchron' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1067.
136
Upgrade to 3.00.00.056 done ( Added item.enumchron column, and framework map to 952h )
137
Upgrade to 3.00.00.058 done ( lang field in opac_news made longer )
138
Upgrade to 3.00.00.059 done ( Added labels_templates table if it did not exist. )
139
Upgrade to 3.00.00.060 done ( Added patronimage table. )
140
DBD::mysql::db do failed: Duplicate column name 'font' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1148.
141
Upgrade to 3.00.00.061 done ( Added font column to labels_templates )
142
DBD::mysql::db do failed: Table 'old_issues' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1155.
143
DBD::mysql::db do failed: Table 'old_reserves' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1175.
144
Upgrade to 3.00.00.062 done ( Added old_issues and old_reserves tables )
145
DBD::mysql::db do failed: Duplicate column name 'enumchron' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1214.
146
DBD::mysql::db do failed: Duplicate column name 'copynumber' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1218.
147
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)
148
Upgrade to 3.00.00.064 done (IMPORTANT: Upgrading to Amazon.com Associates Web Service 4.0 ) 
149
DBD::mysql::db do failed: Table 'patroncards' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1238.
150
Upgrade to 3.00.00.065 done (Adding patroncards table for patroncards generation feature. ) 
151
Upgrade to 3.00.00.066 done (fix for bug 1873: virtualshelfcontents dateadded column empty. ) 
152
Upgrade to 3.00.00.067 done (Updating patronimages syspref to reflect current kohastructure.sql. ) 
153
DBD::mysql::db do failed: Table 'permissions' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1269.
154
DBD::mysql::db do failed: Table 'user_permissions' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1277.
155
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.
156
Upgrade to 3.00.00.068 done (adding permissions and user_permissions tables and GranularPermissions syspref) 
157
DBD::mysql::db do failed: Unknown column 'class' in 'labels_conf' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1312.
158
Upgrade to 3.00.00.069 done ( Correcting columname in labels_conf )
159
Update yuipath syspref to 2.5.1 if necessary
160
DBD::mysql::db do failed: Duplicate column name 'serialsadditems' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1330.
161
Use of uninitialized value $serialsadditems in concatenation (.) or string at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1335.
162
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.
163
Upgrade to 3.00.00.071 done ( moving serialsadditems from syspref to subscription )
164
DBD::mysql::db do failed: Duplicate column name 'formatstring' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1343.
165
Upgrade to 3.00.00.072 done ( Adding format string to labels generator. )
166
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.
167
DBD::mysql::db do failed: Table 'tags_approval' already exists at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1369.
168
Upgrade to 3.00.00.073 done (Baker/Taylor,Tags: sysprefs and tables (tags_all, tags_index, tags_approval)) 
169
Upgrade to 3.00.00.074 done (updating imagetype.imageurls to reflect new icon locations.)
170
DBD::mysql::db do failed: Duplicate column name 'imageurl' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1426.
171
Upgrade to 3.00.00.075 done (adding imageurl field to authorised_values table)
172
DBD::mysql::db do failed: Duplicate column name 'nomatch_action' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1433.
173
DBD::mysql::db do failed: Duplicate column name 'item_action' at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1435.
174
Upgrade to 3.00.00.076 done (changes to import_batches and import_records)
175
Upgrade to 3.00.00.077 done (drop categorytable, subcategorytable, and mediatypetable)
176
Upgrade to 3.00.00.078 done (add browser table if not already present)
177
Upgrade to 3.00.00.079 done (add browser table if not already present)
178
Upgrade to 3.00.00.080 done (catch up on DB schema changes since alpha and beta)
179
Upgrade to 3.00.00.081 done (added borrower_attributes and  borrower_attribute_types)
180
Upgrade to 3.00.00.082 done (adding lastincrement column to accountlines table)
181
Upgrade to 3.00.00.083 done (Changing yuipath behaviour in managing a local value)
182
Upgrade to 3.00.00.084 done (add new sysprefs)
183
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1582.
184
Upgrade to 3.00.00.085 done (move editing tab of various MARC21 subfields)
185
Upgrade to 3.00.00.086 done (Table structure for table `tmp_holdsqueue`)
186
Upgrade to 3.00.00.087 done (added 2 new 'AutoEmailOpacUser' sysprefs)
187
Upgrade to 3.00.00.088 done (added 2 new 'AutoEmailOpacUser' sysprefs)
188
Upgrade to 3.00.00.089 done (added new AdvancedSearchTypes syspref)
189
Upgrade to 3.00.00.090 done (added several circ rules tables)
190
Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 588.
191
C4::Installer::load_sql returned the following errors while attempting to load :
192
Use of uninitialized value $filename in pattern match (m//) at /kohadevbox/koha/C4/Installer.pm line 556.
193
Use of uninitialized value $filename in open at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
194
Use of uninitialized value $filename in concatenation (.) or string at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
195
Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 583.
196
Something went wrong loading file  (Can't open '' for input:
197
No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
198
) at /kohadevbox/koha/C4/Installer.pm line 583.
199
Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 588.
200
C4::Installer::load_sql returned the following errors while attempting to load :
201
Use of uninitialized value $filename in pattern match (m//) at /kohadevbox/koha/C4/Installer.pm line 556.
202
Use of uninitialized value $filename in open at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
203
Use of uninitialized value $filename in concatenation (.) or string at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
204
Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 583.
205
Something went wrong loading file  (Can't open '' for input:
206
No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
207
) at /kohadevbox/koha/C4/Installer.pm line 583.
208
Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 588.
209
C4::Installer::load_sql returned the following errors while attempting to load :
210
Use of uninitialized value $filename in pattern match (m//) at /kohadevbox/koha/C4/Installer.pm line 556.
211
Use of uninitialized value $filename in open at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
212
Use of uninitialized value $filename in concatenation (.) or string at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
213
Use of uninitialized value $filename in concatenation (.) or string at /kohadevbox/koha/C4/Installer.pm line 583.
214
Something went wrong loading file  (Can't open '' for input:
215
No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.32/YAML/XS.pm line 48.
216
) at /kohadevbox/koha/C4/Installer.pm line 583.
217
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,
218
Upgrade to 3.00.00.092 done (added new AllowOnShelfHolds syspref)
219
Upgrade to 3.00.00.093 done (Change data type of items.copynumber to allow free text)
220
Upgrade to 3.00.00.094 done (Change Collation of marc_subfield_structure to allow mixed case in subfield labels.)
221
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 1833.
222
Upgrade to 3.00.00.095 done (fix invalid authority types in MARC21 frameworks [bug 2254])
223
Upgrade to 3.00.00.096 done (fix name borrower_message_preferences.wants_digest)
224
Upgrade to 3.00.00.097 done (updating 4 fields in message_queue table)
225
Upgrade to 3.00.00.098 done (removing unused RSS message_transport_type)
226
Upgrade to 3.00.00.099 done (Adding OpacSuppression syspref)
227
Upgrade to 3.00.00.100 done (Adding lastmodified column to virtualshelves)
228
Upgrade to 3.00.00.101 done (Updating columnd definitions for patron category codes in notice/statsu triggers and deletedborrowers tables.)
229
Upgrade to 3.00.00.102 done (Updating serialitems table to allow for multiple items per serial fixing kohabug 2380)
230
Upgrade to 3.00.00.103 done ( Verifying the removal of serialsadditems from syspref fixing kohabug 2219)
231
Upgrade to 3.00.00.104 done (remove superseded 'noOPACHolds' system preference per bug 2413)
232
Upgrade to 3.00.00.105 done (added SMSSendDriver system preference)
233
Upgrade to 3.00.00.106 done (remove default '0000-00-00' in subscriptionhistory.enddate field)
234
Upgrade to 3.00.00.107 done (warning added to OPACShelfBrowser system preference)
235
Upgrade to 3.01.00.000 done (start of 3.1)
236
Upgrade to 3.01.00.001 done (add hold_fill_targets table and a column to tmp_holdsqueue)
237
Upgrade to 3.01.00.002 done (bug 2582: set null issues.issuedate to lastreneweddate)
238
Upgrade to 3.01.00.003 done (add new syspref)
239
Upgrade to 3.01.00.004 done (added OPACDisplayRequestPriority system preference)
240
Upgrade to 3.01.00.005 done (Add letter for holds notifications)
241
Upgrade to 3.01.00.006 done (add index on biblioitems.issn)
242
Upgrade to 3.01.00.007 done (fix display of many sysprefs)
243
Upgrade to 3.01.00.008 done (added branch_transfer_limits table and UseBranchTransferLimits system preference)
244
Upgrade to 3.01.00.009 done (added subpermissions for circulate permission)
245
Upgrade to 3.01.00.010 done (bug 2687: increase length of borrower attribute fields)
246
Upgrade to 3.01.00.011 done (removed bogus intranetuserjs syspref)
247
Upgrade to 3.01.00.012 done (Add tables and system preferences for holds policies)
248
Upgrade to 3.01.00.013 done (data for Email Checkout Slips project)
249
Upgrade to 3.01.00.014 done ( Updated table for Branch Transfer Limits)
250
Upgrade to 3.01.00.015 done (added Syndetics Enhanced Content system preferences)
251
Upgrade to 3.01.00.016 done (Added Babeltheque syspref)
252
Upgrade to 3.01.00.017 done ( Updated table for Serials Display)
253
Upgrade to 3.01.00.018 done (added deletedborrowers.smsalertnumber, missed in 3.00.00.091)
254
Upgrade to 3.01.00.019 done (adding OPACShowCheckoutName systempref)
255
Upgrade to 3.01.00.020 done (adding LibraryThing for Libraries sysprefs)
256
Upgrade to 3.01.00.021 done (adding OPACAmazonReviews syspref)
257
Upgrade to 3.01.00.022 done (bug 2945: increase size of labels_conf.formatstring)
258
Upgrade to 3.01.00.023 done (bug 2765: increase width of isbn column in several tables)
259
Upgrade to 3.01.00.024 done (change labels.batch_id from varchar to int)
260
Upgrade to 3.01.00.025 done (added ceilingDueDate system preference)
261
Upgrade to 3.01.00.026 done (added numReturnedItemsToShow system preference)
262
Upgrade to 3.01.00.027 done (Increased size of zebraqueue biblio_auth_number to address bug 3148.)
263
Upgrade to 3.01.00.028 done (added AmazonReviews)
264
Upgrade to 3.01.00.029 done (fixed bug 2599: using Spanish search limit retrieves Russian results)
265
Upgrade to 3.01.00.030 done (added AllowNotForLoanOverride system preference)
266
Upgrade to 3.01.00.031 done (fix column widths in branch_transfer_limits)
267
Upgrade to 3.01.00.032 done (Change the field)
268
Upgrade to 3.01.00.033 done (DB changes to allow patron category defaults for messaging preferences)
269
Upgrade to 3.01.00.034 done (Adding graceperiod column to subscription table)
270
Upgrade to 3.01.00.035 done (Adding location to subscription table)
271
Upgrade to 3.01.00.036 done (new viewISBD, viewLabeledMARC, viewMARC sysprefs and tweak IntranetBiblioDefaultView)
272
Upgrade to 3.01.00.037 done (added FilterBeforeOverdueReport syspref and new index on authorised_values)
273
Upgrade to 3.01.00.038 done (add ZIP, city, country, URL, and notes column to branches)
274
Upgrade to 3.01.00.039 done (added SpineLabelFormat and SpineLabelAutoPrint sysprefs)
275
Upgrade to 3.01.00.040 done (AllowHoldDateInFuture and OPACAllowHoldDateInFuture sysprefs)
276
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.)
277
Upgrade to 3.01.00.042 done (added OPACFineNoRenewals syspref)
278
Upgrade to 3.01.00.043 done (amended Item added NewItemsDefaultLocation, InProcessingToShelvingCart, ReturnToShelvingCart sysprefs)
279
Upgrade to 3.01.00.044 done (added DisplayClearScreenButton system preference)
280
Upgrade to 3.01.00.045 done (added a preference to hide the patrons name in the staff catalog)
281
Upgrade to 3.01.00.046 done (add country and B_country to borrowers)
282
 Upgrade to 3.01.00.047 done (bug 2761: change max length of itemcallnumber to 255 from 30)
283
 Upgrade to 3.01.00.048 done (bug 2611: fix spelling/capitalization in permission flag descriptions)
284
Upgrade to 3.01.00.049 done (bug 2611: changed catalogue to catalog per the standard)
285
Upgrade to 3.01.00.050 done (bug 1934: Add OPACSearchForTitleIn syspref)
286
Upgrade to 3.01.00.051 done (fixed typos in new sysprefs)
287
Upgrade to 3.01.00.052 done (bug 3481: add permanent_location column to deleteditems)
288
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.
289
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
290
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.
291
Upgrade to 3.01.00.054 done (bug 1600, bug 3454: add altcontactcountry and B_address2 to borrowers and deletedborrowers)
292
Upgrade to 3.01.00.055 done (changed OPACSearchForTitleIn per requests in bug 1934)
293
Upgrade to 3.01.00.056 done (Bug 1172 : Add OPACPatronDetails syspref)
294
Upgrade to 3.01.00.057 done (Bug 2576 : Add OPACFinesTab syspref)
295
Upgrade to 3.01.00.058 done (Added primary keys to language tables)
296
Upgrade to 3.01.00.059 done (added DisplayOPACiconsXSLT sysprefs)
297
Upgrade to 3.01.00.060 done ( Added AllowAllMessageDeletion syspref and messages table )
298
Upgrade to 3.01.00.061 done ( Added ShowPatronImageInWebBasedSelfCheck system preference )
299
Upgrade to 3.01.00.062 done (added csv export profiles)
300
Upgrade to 3.01.00.063 done (Created table fieldmapping)
301
Upgrade to 3.01.00.064 done (Version number skipped: nothing done)
302
Upgrade to 3.01.00.065 done (Moving allowed renewals from itemtypes to issuingrule)
303
Upgrade to 3.01.00.066 done (Moving max allowed reserves from system preference to issuingrule)
304
Upgrade to 3.01.00.067 done (added permissions for batch modification and deletion)
305
Upgrade to 3.01.00.068 done (Adding finedays in issuingrules table)
306
Upgrade to 3.01.00.069 done (added OPAC search history preference and table)
307
Upgrade to 3.01.00.070 done (Added a lib_opac field in authorised_values table)
308
Upgrade to 3.01.00.071 done ( Adding enddate to subscription)
309
Upgrade to 3.01.00.072 done (add new syspref and column in borrowers)
310
Upgrade to 3.01.00.073 done (adding aqcontract table)
311
Upgrade to 3.01.00.074 done (edit aqbasket table done)
312
Upgrade to 3.01.00.075 done (adding uncertainprices)
313
Upgrade to 3.01.00.076 done (adding basketgroups)
314
Upgrade to 3.01.00.077 done (Adding new aqbudgetperiods, aqbudgets and aqbudget_planning tables  )
315
Upgrade to 3.01.00.078 done (adds 'budget_period_total' column to aqbudgetperiods table)
316
Upgrade to 3.01.00.079 done (adds 'active' column to currencies table)
317
Upgrade to 3.01.00.080 done (adds permissions for the acquisitions module)
318
Upgrade to 3.01.00.081 done (added per-supplier gstrate setting)
319
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3117.
320
Upgrade to 3.01.00.082 done (adding ReservesNeedReturns systempref, in circulation)
321
Upgrade to 3.01.00.083 done (New aqorders_items table for acqui)
322
Upgrade to 3.01.00.084 done (CurrencyFormat syspref added)
323
Upgrade to 3.01.00.085 done update budget_id size that should not be a tinyint
324
Upgrade to 3.01.00.086 done (Suggestions)
325
Upgrade to 3.01.00.087 done (Drop column budget_amount_sublevel from aqbudgets)
326
Upgrade to 3.01.00.088 done (intranetbookbag syspref added)
327
Upgrade to 3.01.00.090 done (granular permissions for guided reports added)
328
Upgrade to 3.01.00.091 done (opac-detail default tag updated)
329
Use of uninitialized value in pattern match (m//) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3220.
330
Upgrade to 3.01.00.092 done (Added RoutingListAddReserves syspref)
331
Upgrade to 3.01.00.093 done (added index to ISSN)
332
Upgrade to 3.01.00.094 done (adding deliveryplace deliverycomment to basketgroups)
333
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3266.
334
Upgrade to 3.01.00.095 done (stocknumber field added)
335
Upgrade to 3.01.00.096 done (PDF orders system preferences added and updated)
336
Upgrade to 3.01.00.097 done (Adding billingplace to aqbasketgroups)
337
Upgrade to 3.01.00.098 done (changing frameworkcode length in auth_subfield_structure)
338
Upgrade to 3.01.00.099 done (granular permissions for cataloging added)
339
Upgrade to 3.01.00.100 done (added CAS authentication system preferences)
340
Upgrade to 3.01.00.101 done (added OverdueNoticeBcc system preferences)
341
Upgrade to 3.01.00.102 done (fixed spelling error in edit_catalogue permission)
342
Upgrade to 3.01.00.103 done (adding patron permissions for tags tool)
343
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 )
344
Upgrade to 3.01.00.105 done (added collection and collection_tracking tables for rotating collections functionality)
345
Upgrade to 3.01.00.106 done (added OpacAddMastheadLibraryPulldown system preferences)
346
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.
347
DB ERROR: Key column 'printer_name' doesn't exist in table
348
Upgrade to 3.01.00.107 done (Migrated labels and patroncards tables and data to new schema.)
349
Upgrade to 3.01.00.108 done (added separators for csv export)
350
Upgrade to 3.01.00.109 done (added encoding for csv export)
351
Upgrade to 3.01.00.110 done (Add enrolment period date support)
352
Upgrade to 3.01.00.111 done (mark DBrev for 3.2-alpha release)
353
Upgrade to 3.01.00.112 done ( added Show Spine Label Printer on Bib Items Details preferences )
354
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.
355
Upgrade to 3.01.00.114 done ( Added AutoSelfCheckAllowed, AutoSelfCheckID, and AutoShelfCheckPass system preference )
356
Upgrade to 3.01.00.115 done ( Default aqorders.quantityreceived to 0 )
357
Upgrade to 3.01.00.116 done (corrected default OrderPdfFormat value if still set wrong )
358
Upgrade to 3.01.00.117 done (corrected ISO 639-2 language code for Portuguese)
359
Upgrade to 3.01.00.118 done (bug 4203: add display column to aqbudgets_planning if missing)
360
Upgrade to 3.01.00.119 done (Locale::Currency::Format installed.)
361
Upgrade to 3.01.00.120 done (bug 1080: add soundon system preference for circulation sounds)
362
Upgrade to 3.01.00.121 done ( Added Additional Fields to Reserves tables )
363
Upgrade to 3.01.00.122 done. — Add a new system preference OAI-PMF:ConfFile
364
Upgrade to 3.01.00.123 done (Add granular permission for holds modification and update description of reserveforothers permission)
365
Upgrade to 3.01.00.124 done (bug 3242: add HOLDPLACED letter template, which is used when emailLibrarianWhenHoldIsPlaced is enabled)
366
Upgrade to 3.01.00.125 done (bug 3482: Printable hold and overdue notices)
367
Upgrade to 3.01.00.126 done (Adding ILS-DI updates and ILS-DI:AuthorizedIPs)
368
Upgrade to 3.01.00.127 done (bug 4190: messages in patron account did not work with branchcodes > 4)
369
Upgrade to 3.01.00.128 done (bug 4331: index orders by budget_id)
370
Upgrade to 3.01.00.129 done (Change permissions names for item batch modification / deletion)
371
Upgrade to 3.01.00.130 done (change reserves.expirationdate values of 0000-00-00 to NULL (bug 1532)
372
Upgrade to 3.01.00.131 done (adding print and feed message transport types)
373
Upgrade to 3.01.00.132 done (Adding index to language_descriptions table)
374
Upgrade to 3.01.00.133 done (bug 4405: added OverduesBlockCirc syspref to control whether circulation is blocked if a borrower has overdues)
375
Upgrade to 3.01.00.134 done (adding syspref DisplayMultiPlaceHold to control whether multiple holds can be placed from the search results page)
376
Upgrade to 3.01.00.135 done (bug 4377: added HOLD_PRINT message template)
377
Upgrade to 3.01.00.136 done (Adding a new permission to edit items)
378
Upgrade to 3.01.00.137 done (adding granular permissions for serials)
379
Upgrade to 3.01.00.138 done (bug 4896: removing GranularPermissions syspref; use of granular permissions is now the default)
380
Upgrade to 3.01.00.139 done (bug 3682: change message_name from varchar(20) to varchar(40))
381
Upgrade to 3.01.00.140 done (bug 4312 TagsModeration changed from NULL to 0)
382
Upgrade to 3.01.00.141 done Remove upcoming events messaging option (bug 2434)
383
Upgrade to 3.01.00.142 done (Remove upcoming events messaging option part 2 (bug 2434))
384
Upgrade to 3.01.00.143 done (Create index on authorised_values and borrower_attribute_types (bug 4139))
385
Upgrade to 3.01.00.144 done (Update the 'default' to 'normal' for the IntranetBiblioDefaultView syspref (bug 5007))
386
Upgrade to 3.01.00.145 done (Add index on guarantorid)
387
Upgrade to 3.01.00.999 done (3.2.0 release candidate)
388
Upgrade to 3.02.00.000 done (Add HomeOrHoldingBranchReturn system preference)
389
Upgrade to 3.02.00.001 done (bug 3756: remove disused system preferences)
390
Upgrade to 3.02.00.002 done (bug 3881: remove unused OpacPrivacy system preference)
391
Upgrade to 3.02.00.003 done (correct ILS-DI:AuthorizedIPs)
392
Upgrade to 3.02.00.004 done (3.2.0 general release)
393
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3821.
394
Upgrade to 3.03.00.001 done (Make subscriptionroutinglist more strict)
395
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3848.
396
Upgrade to 3.03.00.002 done (Correct language mappings)
397
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3864.
398
Upgrade to 3.03.00.003 done (Add UseTablesortForCirc syspref)
399
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3871.
400
Upgrade to 3.03.00.004 done (bug 5127: add default templates for suggestion status change notifications)
401
Upgrade to 3.03.00.005 done (Add itemBarcodeInputFilter choice libsuite8)
402
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3911.
403
Upgrade to 3.03.00.006 done (Fix differences between borrowers and deletedborrowers)
404
Upgrade to 3.03.00.007 done (Added acq related columns to suggestions)
405
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.)
406
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3937.
407
Upgrade to 3.03.00.009 done (Add IntranetUserCSS syspref)
408
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3944.
409
Upgrade to 3.03.00.010 done (Fix misspelled 034r subfield in MARC21 Frameworks)
410
Upgrade to 3.03.00.011 done (Bug 5186: allow GST rate to be set to 0)
411
Upgrade to 3.03.00.012 done (Bug 2142: maxItemsInSearchResults syspref resurrected)
412
Upgrade to 3.03.00.013 done (added 'OpacPublic' syspref)
413
Upgrade to 3.03.00.014 done (Add flexible shelf browser constraints)
414
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 3983.
415
Upgrade to 3.03.00.016 done (OpacPrivacy reimplementation)
416
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4014.
417
Upgrade to 3.03.00.017 done (Enable currency rates >= 100)
418
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4021.
419
Upgrade to 3.03.00.018 done (Correct language descriptions)
420
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4029.
421
Upgrade to 3.03.00.019 done (Correct language descriptions for Norwegian)
422
Upgrade to 3.03.00.020 done (Bug 5811: Add sysprefs controlling overriding fines)
423
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4056.
424
Upgrade to 3.03.00.021 done (bug 5642: longer serial enumeration)
425
Upgrade to 3.03.00.022 done (Add AuthoritiesLog syspref)
426
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4073.
427
Upgrade to 3.03.00.023 done (Reconcile aqbasketgroups)
428
Upgrade to 3.03.00.024 done (Add syspref to force whole-subfield matching on subject tracings)
429
Upgrade to 3.03.00.025 done (Add syspref to control if user can choose pickup branch for holds)
430
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4103.
431
Upgrade to 3.03.00.026 done ( fix capitalization in message type )
432
Upgrade to 3.03.00.027 done (Preferences for facet count)
433
Upgrade to 3.03.00.028 done (Add FacetLabelTruncationLength syspref to control facets displayed length)
434
Upgrade to 3.03.00.029 done (Add syspref to control if user can choose branch when making purchase suggestion)
435
Upgrade to 3.03.00.030 done (Add sysprefs to control custom favicons)
436
Upgrade to 3.03.00.031 done (Add syspref FineNotifyAtCheckin)
437
Upgrade to 3.03.00.032 done ( include subdivisions when generating subject tracing searches )
438
Upgrade to 3.03.00.033 done (System pref StaffAuthorisedValueImages)
439
Upgrade to 3.03.00.034 done (Add hidelostitems preference to borrower categories)
440
Upgrade to 3.03.00.035 done (Move global and ceiling due dates to Circ Rules level)
441
Upgrade to 3.03.00.036 done ( Make COinS optional in OPAC search results )
442
Upgrade to 3.03.00.037 done (Add 'Display856uAsImage' and 'OPACDisplay856uAsImage' syspref)
443
Upgrade to 3.03.00.038 done ( Add Self-checkout by Login system preferences )
444
Upgrade to 3.03.00.039 done (Add syspref ShowReviewer)
445
Upgrade to 3.03.00.040 done (Add syspref UseControlNumber)
446
Upgrade to 3.03.00.041 done (Add sysprefs to control alternate holdings information display)
447
Upgrade to 3.03.00.042 done (5860 Index itemstocknumber)
448
Upgrade to 3.03.00.043 done ( add generic boolean YES_NO authorised_values pair )
449
Upgrade to 3.03.00.044 done (adding freedeliveryplace to basketgroups)
450
Upgrade to 3.03.00.045 done (Remove obsolete columns from aqbooksellers and aqbudgets if needed)
451
Upgrade to 3.03.00.046 done (Setting NULL default value for delayn columns in table overduerules)
452
Upgrade to 3.03.00.047 done (Add state field to patron's addresses)
453
Upgrade to 3.03.00.048 done (Add state to branch address)
454
Upgrade to 3.03.00.049 done (adding note and manager_id fields in accountlines table)
455
Upgrade to 3.03.00.050 done (Adding OpacHiddenItems syspref)
456
Upgrade to 3.03.00.051 done (Remove spaces and dashes from message_attribute names)
457
Upgrade to 3.03.00.052 done (Add syspref WaitingNotifyAtCheckin)
458
Upgrade to 3.04.00.000 done Koha 3.4.0 release 
459
Upgrade to 3.05.00.001 done (Adds New System preference numSearchRSSResults)
460
Upgrade to 3.05.00.002 done (Fix for stocknumber index)
461
Upgrade to 3.05.00.003 done (Adds New System preference OpacRenewalBranch)
462
Upgrade to 3.05.00.004 done (Add syspref ShowReviewerPhoto)
463
Upgrade to 3.05.00.005 done (Adds pref BasketConfirmations)
464
Upgrade to 3.05.00.006 done (Add syspref MARCAuthorityControlField008)
465
Upgrade to 3.05.00.007 done (Add syspref OpenLibraryCovers)
466
Add state and country to cities table corresponding to new columns in borrowers
467
Upgrade to 3.05.00.009 done (issues referential integrity)
468
Create an index on reserves to speed up holds awaiting pickup report bug 5866
469
Upgrade to 3.05.00.011 done (add OPACResultsSidebar syspref (enh 6165))
470
Upgrade to 3.05.00.012 done (add RecordLocalUseOnReturn syspref (enh 6403))
471
Upgrade to 3.05.00.013 done (Add syspref 'OpacKohaUrl')
472
Modified userid column length into 75 in borrowers
473
Upgrade to 3.05.00.015 done (Add support for EBSCO's NoveList Select (enh 6902))
474
Upgrade to 3.05.00.016 done (Add EasyAnalyticalRecords syspref)
475
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4499.
476
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4499.
477
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4505.
478
Upgrade to 3.05.00.018 done (add OpacNavBottom syspref (enh 6825): if appropriate, you can split OpacNav into OpacNav and OpacNavBottom)
479
Upgrade to 3.05.00.019 done (remove duplicate VOKAL Book icons, bug 6862)
480
Upgrade to 3.05.00.020 done (Add syspref AcqViewBaskets)
481
Upgrade to 3.05.00.021 done (Added a display_checkout field in borrower_attribute_types table)
482
Upgrade to 3.05.00.022 done (6094: Fixing ModAuthority problems, add a need_merge_authorities table)
483
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. )
484
Upgrade to 3.06.00.000 done Koha 3.6.0 release 
485
Upgrade done (Change borrowers.debarred into Date )
486
Setting NULL to debarred where 0000-00-00 is stored (bug 7272)
487
Updating message_name in message_attributes
488
Upgrade to 3.07.00.004 done (Add column to suggestions table to store patrons' reasons for submitting a suggestion. )
489
Upgrade to 3.07.00.005 done (BorrowerUnwantedField syspref)
490
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). )
491
Upgrade to 3.07.00.007 done alter items.material from varchar(10) to text 
492
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4619.
493
Upgrade to 3.07.00.008 done (add MARC21 field 545 to framework)
494
Upgrade to 3.07.00.009 done (Add claims_count and claimed_date fields in aqorders table)
495
Upgrade to 3.07.00.010 done (Added support for local cover images)
496
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.)
497
Upgrade to 3.07.00.012 add 'AllowItemsOnHoldCheckout' syspref 
498
Upgrade to 3.07.00.013 done (Bug 7345: Add system preference OpacExportOptions.)
499
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).
500
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 4703.
501
Upgrade to 3.07.00.015 done (Added a mapping for biblioitems.editionstatement.)
502
Upgrade to 3.07.00.016 done (Added index on items.itemcallnumber)
503
Upgrade to 3.07.00.017 done (Add sysprefs to control transfer when cancel all waiting holds)
504
Upgrade to 3.07.00.018 done ( adding offline operations table )
505
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)
506
Upgrade to 3.07.00.020 done (Bug 3516: Add the option to show patron images in the OPAC.)
507
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)
508
Upgrade to 3.07.00.022 done (Bug 7493 - Add constraint linking OPAC comment biblionumber to biblio, OPAC comment borrowernumber to borrowers.)
509
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)
510
Upgrade to 3.07.00.024 done (Added system preference ExpireReservesMaxPickUpDelay, system preference ExpireReservesMaxPickUpDelayCharge, add reseves.charge_if_expired)
511
Upgrade to 3.07.00.025 done (Correct table name for local cover images if needed. )
512
Upgrade to 3.07.00.026 done (Add syspref CalendarFirstDayOfWeek used to select the first day of week to use in the calendar. )
513
Upgrade to 3.07.00.027 done (Added system preference RoutingListNote for adding a general note to all routing lists.)
514
Upgrade to 3.07.00.028 done (Bug 6296 New System preference AllowPKIAuth)
515
Upgrade to 3.07.00.029 done (Atomic update for OAI-PMH sets management)
516
Upgrade to 3.07.00.030 done (Atomic update for OAI-PMH sets management)
517
Upgrade to 3.07.00.031 done (Add syspref to tell Koha if ICU indexing is in use for Zebra or not.)
518
Upgrade to 3.07.00.032 done (BZ7310: Improving list permissions)
519
Upgrade to 3.07.00.033 done add opac_info to branches 
520
Upgrade to 3.07.00.034 done (New fields category_code and class in borrower_attribute_types table)
521
Upgrade to 3.07.00.035 done (Setting up issues and accountlines tables for hourly loans)
522
Upgrade to 3.07.00.036 done (New timeout field in z3950servers)
523
Upgrade to 3.07.00.037 done (Add new field maxlength to marc_subfield_structure)
524
Upgrade to 3.07.00.038 done (Added system preference 'UniqueItemFields')
525
Upgrade to 3.07.00.039 done (added syspref and table for babeltheque (Babeltheque_url_js, babeltheque))
526
Upgrade to 3.07.00.040 done (added syspref SocialNetworks, to display facebook/ggl+ and other buttons)
527
Upgrade to 3.07.00.041 done (Add system preference SubscriptionDuplicateDroppedInput)
528
Upgrade to 3.07.00.042 done (Add suspend fields to reserves table, add syspref AutoResumeSuspendedHolds)
529
Upgrade to 3.07.00.043 done (XSLT systempreference takes a path to file rather than YesNo)
530
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)
531
Upgrade to 3.07.00.046 done (Setting up issues tables for hourly loans (lengthunit fix))
532
Upgrade to 3.07.00.047 done (items_location and items_ccode indexes added for ShelfBrowser)
533
Upgrade to 3.07.00.048 done (Add 'ratings' table and 'OpacStarRatings' syspref)
534
Upgrade to 3.07.00.049 done (Add system preference OpacBrowseResults ))
535
Upgrade to 3.08.00.000 done
536
Upgrade to 3.09.00.001 done. (Bug 8002: Update patron attribute types table to allow NULL category_code)
537
Upgrade to 3.09.00.002 done (Added cache_expiry and public fields in
538
saved_reports table.)
539
Upgrade to 3.09.00.003 done (Added SvcMaxReportRows syspref)
540
Upgrade to 3.09.00.004 done (Adds permissions flag for access to the patron modifications tool)
541
Upgrade to 3.09.00.005 done (Adding Quote of the Day Option.)
542
Upgrade to 3.09.00.006 done (Changed system preference OPACDisplayRequestPriority -> OPACShowHoldQueueDetails)
543
Upgrade to 3.09.00.007 done (Insert ReservesControlBranch systempreference into systempreferences table )
544
Upgrade to 3.09.00.008 done (redefine the field id as PRIMARY KEY of sessions)
545
Upgrade to 3.09.00.009 done (redefine the field branchcode as PRIMARY KEY of branches)
546
Upgrade to 3.09.00.010 done (Add system preference issuelostitem ))
547
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 5371.
548
Upgrade to 3.09.00.011 done (Adding ean in biblioitems and deletedbiblioitems)
549
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 5375.
550
Upgrade to 3.09.00.012 done (Add system preference OpacBrowseResults ))
551
Upgrade to 3.09.00.013 done (Add system preference DefaultLanguageField008))
552
Upgrade done (Support for Talking Tech i-tiva phone notification system)
553
Upgrade to 3.09.00.015 done (Add System preference StatisticsFields)
554
Upgrade to 3.09.00.016 done (Add syspref OPACShowBarcode)
555
Upgrade to 3.09.00.017 done (Add customizable OpacNavRight region to the OPAC main page)
556
Upgrade to 3.09.00.018 done (Add aqbudgetborrowers table)
557
Upgrade to 3.09.00.019 done (Add OPACShowUnusedAuthorities system preference)
558
Upgrade to 3.09.00.020 done (Added borrow_files table, EnableBorrowerFiles syspref)
559
Upgrade to 3.09.00.021 done (Add syspref UpdateTotalIssuesOnCirc)
560
Upgrade to 3.09.00.022 done (Change search_history.query_cgi type to text. bug 5981)
561
Upgrade to 3.09.00.023 done (Add system preference SearchEngine )
562
Upgrade to 3.09.00.024 done (Add system preference IntranetSlipPrinterJS))
563
Upgrade to 3.09.00.025 done (add reserve_id to reserves & old_reserves tables)
564
Upgrade to 3.09.00.026 done (Added parameters subpermissions)
565
Upgrade to 3.09.00.027 done (Bug 7420 add overduefinescap to circulation matrix)
566
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 5623.
567
Upgrade to 3.09.00.028 done (Add thesaurus links for MARC21/NORMARC)
568
Upgrade to 3.09.00.029 done (Add itemBarcodeInputFilter choice EAN13)
569
Upgrade to 3.09.00.029 done ( Added EAN13 barcode autogeneration sequence )
570
Upgrade to 3.09.00.030 done (BZ 8263: Make OPAC stylesheet preferences more consistent)
571
Upgrade to 3.09.00.031 done ('Remove preferences controlling broken Amazon features (Bug 8679')
572
Upgrade to 3.09.00.032 done (Bug 8657 - Default sort by call number does not work. Correcting system preference value.)
573
Upgrade to 3.09.00.033 done (Add OpacSuppressionByIPRange syspref)
574
Upgrade to 3.09.00.034 done (Bug 8207: correct typo in authority types)
575
Upgrade to 3.09.00.035 done (Adding PrefillItem and SubfieldsToUseWhenPrefill sysprefs)
576
Upgrade to 3.09.00.036 done (Add colum agerestriction to biblioitems and deletedbiblioitems, add system preferences AgeRestrictionMarker and AgeRestrictionOverride)
577
Upgrade to 3.09.00.037 done (creating `transport_cost` table; adding UseTransportCostMatrix systempref, in circulation)
578
Upgrade to 3.09.00.038 done (Increase the maximum size of a borrower attribute value)
579
Upgrade to 3.09.00.039 done (Add system preference DidYouMeanFromAuthorities)
580
Upgrade to 3.09.00.040 done (Add IncludeSeeFromInSearches system preference)
581
Upgrade to 3.09.00.041 done (Add system preference ExportRemoveFields)
582
Upgrade to 3.09.00.042 done (Adds New System preference ExportWithCsvProfile)
583
Upgrade to 3.09.00.043 done (Adding parent_ordernumber in aqorders)
584
Upgrade done ( Added Collection Code to Statistics table. )
585
Upgrade to 3.09.00.045 done. (Bug 8002: Update patron attribute types table from varchar(1) to varchar(10) category_code)
586
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.
587
Please check, and fix it if necessary.Upgrade to 3.09.00.046 done (adding accountlines_id field in accountlines table)
588
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)
589
Upgrade to 3.09.00.049 done (Add OPACMobileUserCSS, OpacMainUserBlockMobile, OpacShowLibrariesPulldownMobile and OpacShowFiltersPulldownMobile sysprefs)
590
Upgrade to 3.09.00.050 done saved_sql new fields report_group and report_area; authorised_values.category 16 char 
591
Upgrade to 3.09.00.051 done (Add aqinvoices table) 
592
Upgrade to 3.09.00.052 done (Add systempreferences to decrease loan length on high demand items decreaseLoanHighHolds, decreaseLoanHighHoldsValue and decreaseLoanHighHoldsDuration) 
593
Upgrade to 3.09.00.053 done (Added support for staging authorities)
594
Upgrade to 3.09.00.054 done (Change column name in aqorders gst --> gstrate)
595
Upgrade to 3.09.00.055 done (Add discount field in aqorders table)
596
Upgrade to 3.09.00.056 done (Add system preference AuthDisplayHierarchy)
597
Upgrade to 3.09.00.057 done (Bug 5356: Added billingplace, deliveryplace to the aqbasket table)
598
Upgrade to 3.09.00.058 done (Add Did You Mean? configuration)
599
Upgrade to 3.09.00.059 done (Add system preference BlockReturnOfWithdrawnItems)
600
Upgrade to 3.09.00.060 done (Added HoldsToPullStartDate syspref)
601
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.)
602
Upgrade to 3.09.00.062 done (Disable obsolete NoZebra and QueryRemoveStopwords sysprefs)
603
Use of uninitialized value $gist_syspref in split at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 6076.
604
Upgrade to 3.09.00.063 done (Bug 8832, Set the syspref gist with the existing values)
605
Upgrade to 3.09.00.064 done (Bug 6428: Added coded_location_qualifier to the items table)
606
Upgrade to 3.09.00.065 done (Bug 6428: Added coded_location_qualifier to the deleteditems table)
607
Upgrade to 3.09.00.066 done (Bug 9107: remove DidYouMeanFromAuthorities syspref)
608
Upgrade to 3.09.00.067 done (Bug 9064: statistics.ccode potentially wrongly defined)
609
Upgrade to 3.10.00.00 done (release tag)
610
Upgrade to 3.11.00.001 done (Bug 2832 - Add alphabet syspref)
611
Upgrade to 3.11.00.002 done (Bug 9030: Add constraint on aqorders_items.ordernumber)
612
Upgrade to 3.11.00.003 done (Bug 7189: Add system preference RefundLostItemFeeOnReturn)
613
Upgrade to 3.11.00.004 done (Bug 8782: Add field subscription.closed)
614
Upgrade to 3.11.00.005 done (Bug 7919: Display of values depending on the connexion library)
615
Upgrade to 3.11.00.006 done (Bug 9167: Update the virtualshelves.sortfield column with 'copyrightdate' if needed)
616
Upgrade to 3.11.00.007 done (Bug 9056: add German and a couple of French translations to language_descriptions)
617
Upgrade to 3.11.00.008 done (Bug 7067: Add Patron Self Registration)
618
Upgrade to 3.11.00.009 done (Bug 7674: Add systempreferences SeparateHoldings, SeparateHoldingsBranch, OpacSeparateHoldings and OpacSeparateHoldingsBranch) 
619
Upgrade to 3.11.00.010 done (Bug 9151 - Renewal notice according to patron alert preferences)
620
Upgrade to 3.11.00.011 done (Bug 8377: Add HTML5MediaEnabled and HTML5MediaExtensions sysprefs)
621
Upgrade to 3.11.00.012 done (Bug 9206: Only allow place holds in records that the patron don't have in his possession)
622
Upgrade to 3.11.00.013 done (Bug 9162 - Add a system preference to set which notes fields appears on title notes/description separator)
623
Upgrade to 3.11.00.014 done (Bug 9009: Add SCOUserCSS and SCOUserJS sysprefs)
624
Upgrade to 3.11.00.015 done (Add sysprefs RentalsInNoissuesCharge and ManInvInNoissuesCharge.)
625
Upgrade to 3.11.00.016 done (Bug 9382 (updated with bug 9745) - refresh permission descriptions to make more sense)
626
Upgrade to 3.11.00.017 done (Add IDreamBooks enhanced content)
627
Upgrade to 3.11.00.018 done (Bug 9395: Problem with callnumber and standard number search in OPAC and Staff Client)
628
Upgrade to 3.11.00.019 done (Bug 9145 - Add syspref UNIMARCAuthorityField100)
629
Upgrade to 3.11.00.020 done (Bug 8347 - Koha forces UNIMARC 100 field code language to 'fre')
630
Upgrade to 3.11.00.021 done (Bug 5888 - Subject search pop-up for the OPAC)
631
Upgrade to 3.11.00.022 done (Bug 9587 - Allow login via Persona)
632
Upgrade to 3.11.00.023 done (Bug 9520 - Update default LOC Z39.50 target)
633
Upgrade to 3.11.00.024 done (Bug 5079: Add OpacItemLocation syspref)
634
Upgrade to 3.11.00.025 done (Adds feature Bug 8917, the ability to track links clicked)
635
Upgrade to 3.11.00.026 done (Bug 9207: Add new index batch_id_record_type to import_records)
636
Upgrade to 3.11.00.027 done ( Add circ permission overdues_report )
637
Upgrade to 3.11.00.028 done (Bug 9756 - Patron self registration missing the system preference PatronSelfRegistrationAdditionalInstructions)
638
Upgrade to 3.11.00.029 done (Bug 9239: Make it possible for Koha to use QueryParser)
639
Upgrade to 3.11.00.030 done (Add system preference FinesIncludeGracePeriod)
640
Upgrade to 3.11.00.100 done (3.12-alpha release)
641
Upgrade to 3.11.00.101 done (Bug 9341: Problem with UNIMARC authors facets)
642
Upgrade to 3.11.00.102 done (Remove deprecated NoZebra and QueryRemoveStopwords sysprefs)
643
Upgrade to 3.11.00.103 done (Bug 9827 - Remove 'insecure' system preference)
644
Upgrade to 3.11.00.104 done (3.12-alpha2 release)
645
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 6614.
646
Upgrade to 3.11.00.105 done (Bug 9353: Missing subfields on MARC21 frameworks)
647
Upgrade to 3.11.00.106 done (Bug 7804: Added plugin system.)
648
Upgrade to 3.11.00.107 done (Bug 9014: Add syspref TimeFormat)
649
Upgrade to 3.11.00.108 done (Bug 7241: Fix on circulation logs)
650
WARNING about bug 7241: to partially correct the broken logs, the log history is filled with the first found item for each biblio.
651
Upgrade to 3.11.00.109 done (Bug 9403: Add DisplayIconsXSLT)
652
Upgrade to 3.11.00.110 done (Bug 8220 - Allow koc uploads to go to process queue)
653
Upgrade to 3.11.00.111 done (use new <<items.fine>> syntax in notices)
654
Upgrade to 3.11.00.112 done (Bug 8365: Add colum issuingrules.renewalperiod)
655
Upgrade to 3.11.00.113 done (Bug 9257 - Add groups to normal search pulldown)
656
Upgrade to 3.11.00.115 done (Bug 7740: Add syspref HighlightOwnItemsOnOPAC)
657
Upgrade to 3.11.00.116 done (Bug 5343: table aqorders: DROP serialid and subscription fields and ADD subscriptionid, table subscription: ADD reneweddate)
658
Upgrade to 3.11.00.200 done (3.12-beta1 release)
659
Upgrade to 3.11.00.201 done (Bug 9498 - Update encoding for Norwegian sample Z39.50 servers)
660
Upgrade to 3.11.00.202 done (Bug 9381: Add Catalan laguage)
661
Upgrade to 3.11.00.203 done (Bug 2046 - increasing title column length for suggestions)
662
Upgrade to 3.11.00.300 done (3.12-beta3 release)
663
Upgrade to 3.11.00.301 done (Bug 9681: Add some database indexes)
664
Upgrade to 3.12.00.000 done (3.12.0 release)
665
Upgrade to 3.13.00.000 done (start the journey to Koha Pi)
666
Upgrade to 3.13.00.001 done (Add Course Reserves ( system preference UseCourseReserves ))
667
Upgrade to 3.13.00.002 done (Bug 10080 - Change system pref IndependantBranches to IndependentBranches)
668
Upgrade to 3.13.00.003 done (Bug 7718 - Remove itemnumber column from serials table)
669
Upgrade to 3.13.00.004 done (Bug 9722: Allow users to add notes when placing a hold in OPAC)
670
Upgrade to 3.13.00.005 done (Bug 10052: Make intranetstylesheet and intranetcolorstylesheet behave exactly like their opac counterparts)
671
Upgrade to 3.13.00.006 done (Bug 10120: Fines on item return controlled by a systempreference)
672
Upgrade to 3.13.00.007 done (Bug 10343: Rename OpacShowHoldNotes to OpacHoldNotes)
673
Upgrade to 3.13.00.008 done (Bug 10443: make sure borrower_files table exists)
674
Upgrade to 3.13.00.009 done (Bug 9987 - Drop column aqorders.biblioitemnumber)
675
Upgrade to 3.13.00.010 done (Bug 10366 - Add system preference to enabling warning librarian when invoice is duplicated)
676
Upgrade to 3.13.00.011 done (Bug 9519: Wrong language code for Italian in the advanced search language limitations)
677
Upgrade to 3.13.00.012 done (Bug 10490: Correct datatype for overduefinescap in issuingrules)
678
Upgrade to 3.13.00.013 done (Bug 9576: add AllowTooManyOverride syspref to enable or disable issue limit confirmation)
679
Upgrade to 3.13.00.014 done (Bug 10604: correct width of courses.department and courses.term)
680
Upgrade to 3.13.00.015 done (Bug 7494: Add itemBarcodeFallbackSearch syspref)
681
Upgrade to 3.13.00.016 done (Bug 10550 - Fix database typo wthdrawn)
682
Upgrade to 3.13.00.017 done (Bug 10320 - Show results from library's OverDrive collection in OPAC search)
683
Upgrade to 3.13.00.018 done (Bug 5349: Add aqorders_transfers table)
684
Upgrade to 3.13.00.019 done (Bug 10513 - Light up a warning/message when returning a chosen item type)
685
Upgrade to 3.13.00.020 done (Bug 7639: system preferences to forgive fines on lost items)
686
Upgrade to 3.13.00.021 done (Bug 9761: Add ConfirmFutureHolds pref)
687
Upgrade to 3.13.00.022 done (Bug 10687 - Delete erroneous tags 68a and 68b on default MARC21 auth framework)
688
Upgrade to 3.13.00.023 done (Bug 9611 upgrading password storage system)
689
Upgrade to 3.13.00.024 done (Bug 10096 - Add a Z39.50 interface for authority searching)
690
Upgrade to 3.13.00.025 done (Bug 9295: OAI notequal: add operator column to OAI mappings table)
691
Upgrade to 3.13.00.026 done (Bug 10602: Add the column auth_subfield_structure.defaultvalue)
692
Upgrade to 3.13.00.027 done (Bug 10240: Add syspref AllowOfflineCirculation)
693
Upgrade to 3.13.00.028 done (Bug 10853: Add new field export_format.type and rename export_format.marcfields with export_format.content)
694
Upgrade to 3.13.00.029 done (Bug 10854: Add the default CSV profile for claiming issues)
695
Upgrade to 3.13.00.030 done (Bug 10636 - patronimage should have borrowernumber as PK, not cardnumber)
696
Upgrade to 3.13.00.031 done (Bug 10565 - Add a 'Patron List' feature for storing and manipulating collections of patrons)
697
Upgrade to 3.13.00.032 done (Bug 5336: Add the new column aqorders.orderstatus)
698
Upgrade to 3.13.00.033 done (Bug 7688: add subscription_frequencies and subscription_numberpatterns tables)
699
Upgrade to 3.13.00.034 done (Bug 7131 - way to overlay items in in marc import)
700
Upgrade to 3.13.00.035 done (Bug 2720 - Overdues which debar automatically should undebar automatically when returned)
701
Upgrade to 3.13.00.036 done (Add system preference StaffDetailItemSelection)
702
Upgrade to 3.13.00.037 done (Bug 10572: Add phone to message_transport_types table for new installs)
703
Upgrade to 3.13.00.038 done (Bug 8435: Add superserials permission)
704
Upgrade to 3.13.00.039 done (Add branch and users list to baskets. New permission order_manage_all)
705
Upgrade to 3.13.00.040 done ( Bug 8015: Added tables for MARC Modification Framework )
706
Upgrade to 3.13.00.041 done (Bug 10986: Added AcqItemSetSubfieldsWhenReceived syspref)
707
Upgrade to 3.13.00.042 done (Koha 3.14 beta)
708
Upgrade to 3.13.00.043 done (Bug 11196: Add system preference SearchEngine if missing )
709
Upgrade to 3.14.00.000 done (3.14.0 release)
710
Upgrade to 3.15.00.000 done (the road goes ever on)
711
Upgrade to 3.15.00.001 done (Bug 11040: Add option to print full slip when checking out a null barcode)
712
Upgrade to 3.15.00.002 done (Bug 11275: alter deleteditems.materials from varchar(10) to text)
713
Upgrade to 3.15.00.003 done (Bug 2546: Update fine descriptions)
714
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 7853.
715
Upgrade to 3.15.00.004 done (Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB update)
716
Upgrade to 3.15.00.005 done (Bug 8230: Add AcquisitionDetails system preference)
717
Upgrade to 3.15.00.006 done (Bug 11249 - Add DB indexes on borrower names)
718
Upgrade to 3.15.00.007 done (Bug 9673 - Track when items are marked as lost or withdrawn)
719
Upgrade to 3.15.00.008 done (Bug 11384) - change name of collections_tracker.ctId column)
720
Upgrade to 3.15.00.009 done (Bug 11391) - drop default value on suggestions.suggesteddate column)
721
Upgrade to 3.15.00.010 done (Bug 6331: remove obsolete column in deleteditems.marc)
722
Upgrade to 3.15.00.011 done (Bug 8018: set 9999 as default max length for subfields)
723
Upgrade to 3.15.00.012 done (Bug 10863 - Add permissions force_checkout and manage_restrictions)
724
Upgrade to 3.15.00.013 done (Bug 11237: Update explanation and default value for AcqItemSetSubfieldsWhenReceived syspref)
725
Upgrade to 3.15.00.014 done (Bug 11415: add system preference for automatic self checkout receipt printing)
726
Upgrade to 3.15.00.015 done (Bug 10907: Add OpacSuggestionManagedBy system preference)
727
Upgrade to 3.15.00.016 done (Bug 11268 - Biblioitems URL field is too small for some URLs)
728
Upgrade to 3.15.00.017 done (Bug 11611 - fix possible confusion between UNIMARC and MARC21 in some sysprefs)
729
Upgrade to 3.15.00.018 done (Bug 7372: Move road types from the roadtype table to the ROADTYPE authorised values)
730
Upgrade to 3.15.00.019 done (Bug 11256: Add system preference OpacMaxItemsToDisplay)
731
Upgrade to 3.15.00.020 done (Bug 11343: Add system preference MaxItemsForBatch )
732
Upgrade to 3.15.00.021 done (Bug 3445: Add indexes to action_logs table)
733
Upgrade to 3.15.00.022 done (Bug 11751: Remove memberofinstitytion system preference)
734
Upgrade to 3.15.00.023 done (Bug 10861: Add CardnumberLength syspref)
735
Upgrade to 3.15.00.024 done (Bug 10012 - remove last vestiges of NoZebra)
736
Upgrade to 3.15.00.025 done (Bug 11928 - remove unused table)
737
Upgrade to 3.15.00.026 done (Bug 11973 - Fix Armenian language description)
738
Upgrade to 3.15.00.027 done (Bug 7567: Add branchcode to opac_news)
739
Upgrade to 3.15.00.028 done (Bug 7413: Allow OPAC renewal x days before due date)
740
Upgrade to 3.15.00.029 done (Bug 11846 - correct borrower_debarments with expiration 9999-12-31)
741
Upgrade to 3.15.00.030 done (Bug 12052: Add OPACMySummaryNote syspref)
742
Upgrade to 3.15.00.031 done (Bug 9448 - Add separate permission for writing off fees)
743
Upgrade to 3.15.00.032 done (Bug 9416 - In each order, add a new note made for the vendor)
744
Upgrade to 3.15.00.033 done (Bug 10951: Add NoLoginInstructions pref)
745
Upgrade to 3.15.00.034 done (Bug 10986: system preferences to limit languages in advanced search )
746
Upgrade to 3.15.00.035 done (Bug 9032: Share a list)
747
Upgrade to 3.15.00.036 done (Bug 10859 - Add system preference AllowMultipleIssuesOnABiblio)
748
Upgrade to 3.15.00.037 done (Bug 11351 - Add support for SIP2 media type)
749
Upgrade to 3.15.00.038 done (Bug 11334 - Add facet for home library)
750
Upgrade done (Bug 9016: Adds multi transport types management for notices)
751
Upgrade to 3.15.00.040 done (Bug 10845: Multi transport types for holds)
752
Upgrade to 3.15.00.041 done (Bug 11867: Update letters *_PHONE)
753
Upgrade to 3.15.00.042 done (Bug 10694 - Allow arbitrary backdating of returns)
754
Upgrade to 3.15.00.043 done (Bug 7180: Added MarcFieldsToOrder syspref)
755
Upgrade to 3.15.00.044 done (Added isocode to the currency table)
756
Upgraded to 3.15.00.045 done (Bug 6739 - expired patrons not blocked from opac actions)
757
Upgrade to 3.15.00.046 done (Bug 10807 - Add db field search_history.type)
758
Upgrade to 3.15.00.047 done (Bug 10862: Add EnableSearchHistory syspref)
759
Upgrade to 3.15.00.048 done (Bug 10195: Records hidden with OpacSuppression can still be accessed)
760
Upgrade to 3.15.00.049 done (Bug 5377 - Biblioitems isbn and issn fields too small for multiple ISBN and ISSN)
761
Upgrade to 3.15.00.050 done (Bug 10500 - Improve isbn matching when importing records)
762
Upgrade to 3.15.00.051 done (Koha 3.16 beta)
763
Upgrade to 3.15.00.052 done (Koha 3.16 RC)
764
Upgrade to 3.16.00.000 done (3.16.0 release)
765
Upgrade to 3.17.00.000 done (there is no time to rest on our laurels)
766
Upgrade to 3.17.00.001 done (Bug 10330 - Rename system preference authoritysep to AuthoritySeparator)
767
Upgrade to 3.17.00.002 done (Bug 3050 - Add an option to upload scanned invoices)
768
Upgrade to 3.17.00.003 done (Bug 7825 - Changed OPACItemHolds syspref to Choice)
769
Upgrade to 3.17.00.004 done (Bug 6254 - can't set patron privacy by default)
770
Upgrade to 3.17.00.005 done (Bug 12230: Add new issuing rule maxsuspensiondays)
771
Upgrade to 3.17.00.006 done (Bug 7720 - Ambiguity in OPAC Details location.)
772
Upgrade to 3.17.00.007 done (Bug 11629 - Add ability to update not for loan status on checkin)
773
Upgrade to 3.17.00.008 done (Bug 11169 - Add OPACAcquisitionDetails syspref)
774
Upgrade to 3.17.00.009 done (Bug 11703 - Remove UseTablesortForCirc syspref)
775
Upgrade to 3.17.00.010 done (Bug 11347 - PROG/CCSR deprecation: Remove opacsmallimage system preference)
776
Upgrade to 3.17.00.011 done (Bug 12649: Add Croatian language)
777
Upgrade to 3.17.00.012 done ( Bug 12512 - PROG/CCSR deprecation: Remove OpacShowFiltersPulldownMobile system preference )
778
Upgrade to 3.17.00.013 done (Re-add system preference maxreserves)
779
Upgrade to 3.17.00.014 done (Bug 12529 - Adding a syspref to allow the overdue notices to consider the calendar when generating notices)
780
Upgrade to 3.17.00.015 done (Bug 10212 - Create new table columns_settings)
781
Upgrade to 3.17.00.016 done (Bug 10402: Move bookseller contacts to separate table)
782
Upgrade to 3.17.00.017 done (Bug 6536: Z3950 improvements)
783
Upgrade to 3.17.00.018 done (Bug 12205: Add HoldsInNoissuesCharge systempreference)
784
Upgrade to 3.17.00.019 done (Bug 6149: Operator highlighted in search results)
785
Upgrade to 3.17.00.020 done (Bug 8735 - Expire holds waiting only on days the library is open)
786
Upgrade to 3.17.00.021 done (Bug 12582 - Control of branch displayed in search results linked to HomeOrHoldingBranch)
787
Upgrade to 3.17.00.022 done (Bug 7817: Check for permanent_location)
788
Upgrade to 3.17.00.023 done (Bug 11169 - Add AcqItemSetSubfieldsWhenReceiptIsCancelled syspref)
789
Upgrade to 3.17.00.024 done (Bug 11577: [ENH] Automatic renewal feature)
790
Upgrade to 3.17.00.025 done (Bug 12728: Checked syspref StatisticsFields)
791
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 8835.
792
Upgrade to 3.17.00.027 done (Bug 12538 - Remove SearchEngine syspref)
793
Upgrade to 3.17.00.028 done (Bug 12296 - search box replaceable with a system preference)
794
Upgrade to 3.17.00.029 done (Bug 12424 - ddc sorting of call numbers truncates long Cutter parts)
795
Upgrade to 3.17.00.030 done (Bug 11926: Add UsageStats systempreferences (HEA))
796
Upgrade to 3.17.00.031 done (Bug 2969: Report Name should be mandatory for saved reports)
797
Upgrade to 3.17.00.032 done (Bug 9530: Adding replyto and returnpath addresses.)
798
Upgrade to 3.17.00.033 done (Bug 13088 - Allow the user to specify a max amount of facets to show)
799
Upgrade to 3.17.00.034 done (Bug 11007 - DROP column aqorders.cancelledby)
800
Upgrade to 3.17.00.035 done (Bug 5342: Add claims_count field in serial table)
801
Upgrade to 3.17.00.036 done ( Bug 12513 - PROG/CCSR deprecation: Remove OpacShowLibrariesPulldownMobile system preference )
802
Upgrade to 3.17.00.037 done ( Bug 12246 - PROG/CCSR deprecation: Remove OpacMainUserBlockMobile system preference )
803
Upgrade to 3.17.00.038 done ( Bug 12245 - PROG/CCSR deprecation: Remove OPACMobileUserCSS system preference )
804
Upgrade to 3.17.00.039 done (Bug 12539 - PROG/CCSR deprecation: Remove hardcoded theme from C4/Templates.pm)
805
Upgrade to 3.17.00.040 done (Bug 12223: 'prog' and 'ccsr' themes removed)
806
Upgrade to 3.17.00.041 done (Bug 11346: Deprecate the 'prog' and 'CCSR' themes)
807
Upgrade to 3.17.00.042 done (Bug 12494: Remove yuipath system preference)
808
Upgrade to 3.17.00.043 done (Bug 7162: Add aqorders.cancellationreason)
809
Upgrade to 3.17.00.044 done (Bug 10860: Add new system preference OnSiteCheckouts + fields [old_]issues.onsite_checkout)
810
Upgrade to 3.17.00.045 done (Bug 11126 - Make the holds system optionally give precedence to local holds)
811
Upgrade to 3.17.00.046 done (Bug 11425: Add items_search_fields table)
812
Upgrade to 3.17.00.047 done (Bug 8836 - Resurrect Rotating Collections)
813
Upgrade to 3.17.00.048 done (Bug 12448 - Add RentalFeesCheckoutConfirmation syspref)
814
Upgrade to 3.17.00.049 done (Bug 12250: Update descriptions for languages, scripts and regions)
815
Upgrade to 3.17.00.050 done (Bug 12403: Add permission tools_records_batchdelitem)
816
Upgrade to 3.17.00.051 done (Bug 13211: Added system preferences GoogleIndicTransliteration on the OPAC)
817
Upgrade to 3.17.00.052 done (Bug 9043: Add system preference OpacAdvSearchOptions and OpacAdvSearchMoreOptions)
818
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))
819
Upgrade to 3.17.00.054 done (Bug 11634 - Allow renewal of item with unfilled holds if other available items can fill those holds)
820
Upgrade to 3.17.00.055 done (Bug 11401 - Add support for Norwegian national library card)
821
Upgrade to 3.17.00.056 done (Bug 9043 - Update the values for OpacAdvSearchOptions and OpacAdvSearchOptions)
822
Upgrade to 3.17.00.057 done (Koha 3.18 beta)
823
Upgrade to 3.17.00.058 done (Bug 8337: System preferences for longoverdue cron)
824
Upgrade to 3.17.00.059 done (Bug 10749: Fix typo in budget_add_del permission description)
825
Upgrade to 3.17.00.060 done (Bug 12298: Delete the 'feed' message transport type (deleted!))
826
Upgrade to 3.18.00.000 done (3.18.0 release)
827
Upgrade to 3.19.00.000 done (there's life after 3.18)
828
Upgrade to 3.19.00.001 done (Bug 13436: Add more options to UsageStatsLibraryType)
829
upgrade to 3.19.00.002 done (Bug 10753: replace __ANY__ with empty string in suggestions.branchcode)
830
Upgrade to 3.19.00.003 done (Bug 1861: Unique patrons logins not (totally) enforced)
831
Upgrade to 3.19.00.004 done (Bug 13346: OpacExportOptions is now multiple)
832
Upgrade to 3.19.00.005 done (Bug 13379: Modify authorised_values.category to varchar(32))
833
Upgrade to 3.19.00.006 done (Bug 11944: Convert DB tables to utf8_unicode_ci)
834
Use of uninitialized value in numeric gt (>) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 9774.
835
Use of uninitialized value in numeric gt (>) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 9799.
836
Upgrade to 3.19.00.008 done (Bug 12601: Add new foreign key aqorders.budget_id)
837
Upgrade to 3.19.00.009 done (Bug 13007: Add new foreign key suggestions.budgetid)
838
Upgrade to 3.19.00.010 done (Bug 5511: SessionRestrictionByIP)
839
Upgrade to 3.19.00.011 done (Bug 13417: Add permission to delete public lists)
840
Upgrade to 3.19.00.012 done (Bug 13523 Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)
841
Upgrade to 3.19.00.013 done (Bug 11395: Add permission tools_records_batchmod)
842
Upgrade to 3.19.00.014 done (Bug 12648: Add letter ACQ_NOTIF_ON_RECEIV )
843
Upgrade to 3.19.00.015 done (Bug 11430: Add primary key for search_history)
844
Upgrade to 3.19.00.016 done (Bug 13380: Add the ORDER_CANCELLATION_REASON authorised value)
845
Upgrade to 3.19.00.017 done (Bug 5786: Move AllowOnShelfHolds to circulation matrix; Move OPACItemHolds system preference to circulation matrix)
846
Upgrade to 3.19.00.018 done (Bug 10328: Rename opaccolorstylesheet to OpacAdditionalStylesheet
847
Upgrade to 3.19.00.019 done (Bug 9580: Cover image from Coce, a remote image URL cache)
848
Upgrade to 3.19.00.020 done (Bug 11008: DROP column aqorders.supplierreference)
849
Upgrade to 3.19.00.021 done (Bug 2806: Remove issuingbranch columns)
850
Upgrade to 3.19.00.022 done (Bug 13006: Drop column suggestion.mailoverseeing)
851
Upgrade to 3.19.00.023 done (Bug 13497: Remove the AddPatronLists system preferences)
852
Upgrade to 3.19.00.024 done (Bug 13539: Remove table patroncards from database as it's no longer in use)
853
Upgrade to 3.19.00.025 done (Bug 13528: Add the SearchWithISBNVariations syspref)
854
Use of uninitialized value in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 10064.
855
Upgrade to 3.19.00.026 done (Bug 13322: Update MARC21 frameworks to Update No. 19 - October 2014)
856
Upgrade to 3.19.00.027 done (Bug 4222: Nonpublic note not appearing in the staff client) <b>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 </b>)
857
Upgrade to 3.19.00.028 done (Bug 13790: Add unique id issue_id to issues and oldissues tables)
858
Upgrade to 3.19.00.029 done (Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT)
859
Upgrade to 3.19.00.030 done (Bug 14030: Add Georgian language and fix Kannada language code)
860
Upgrade to 3.19.00.031 done (Bug 8992: Add system preference IdRef))
861
Upgrade to 3.19.00.032 done (Bug 4041: Address Format as a I18N/L10N system preference
862
Upgrade to 3.19.00.033 done (Bug 11165: Update auth_header.datemodified when updated)
863
Upgrade to 3.19.00.034 done (Bug 13984: CardnumberLength syspref missing on some setups
864
Upgrade to 3.19.00.035 done (Bug 8007: Add System Preferences useDischarge, the discharge notice and the new table discharges)
865
Upgrade to 3.19.00.036 done (Bug 13889: Add cron jobs information to system log)
866
Upgrade to 3.19.00.037 done (Bug 13810: Change collate for tagsubfield (utf8_bin))
867
Upgrade to 3.19.00.038 done (Bug 13421: Add DB field virtualshelves.created_on)
868
Upgrade to 3.19.00.039 done (Koha 3.20 beta)
869
Upgrade to 3.19.00.040 done (Bug 11006: Drop column aqorders.totalamount)
870
Upgrade to 3.19.00.041 done (Bug 14132: suggestions table is missing indexes)
871
Upgrade to 3.19.00.042 done (Bug 8480: Add foreign key on auth_subfield_structure.authtypecode)
872
Upgrade to 3.19.00.043 done (Bug 5338: Add Serial to the report groups if does not exist)
873
Upgrade to 3.20.00.000 done (Koha 3.20)
874
Upgrade to 3.21.00.000 done (El tiempo vuela, un nuevo ciclo comienza.)
875
Upgrade to 3.21.00.001 done (Bug 12160: Rename intranetuserjs to IntranetUserJS)
876
Upgrade to 3.21.00.002 done (Bug 12160: Rename opacuserjs to OPACUserJS)
877
Upgrade to 3.21.00.003 done (Bug 14285: Add new region India)
878
Upgrade to 3.21.00.004 done (Bug 5010: Fix OPACBaseURL to include protocol)
879
Upgrade to 3.21.00.005 done (Bug 14024: Add reports to action logs)
880
Upgrade to 3.21.00.006 done (Bug 7976: Remove the 'borrow' permission)
881
Upgrade to 3.21.00.007 done (Bug 14053: Acquisition db tables are missing indexes)
882
Upgrade to 3.21.00.008 done (Bug 7981: Transfer message on return. HomeOrHoldingBranchReturn syspref removed in favour of circulation rules.)
883
Upgrade to 3.21.00.009 done (Bug 13993: Correct orderstatus for transferred orders)
884
Upgrade to 3.21.00.010 done (Bug 7793: redefine the field message_id as PRIMARY KEY of message_queue)
885
Upgrade to 3.21.00.011 done (Bug 14252: Make the OPAC language switcher available in the masthead navbar, footer, or both)
886
Upgrade to 3.21.00.012 done (Bug 13014: Add the TO_PROCESS letter code)
887
Upgrade to 3.21.00.013 done (Bug 9942: Privacy is correctly set)
888
Upgrade to 3.21.00.014 done (Bug 3206: OAI repository deleted record support)
889
Upgrade to 3.21.00.015 done (Bug 12137: Extend functionality of CalendarFirstDayOfWeek to be any day)
890
Upgrade to 3.21.00.016 done (Bug 13948: Add ability to dump template toolkit variables to html comment)
891
Upgrade to 3.21.00.017 done (Bug 6874: New cataloging plugin upload.pl)
892
This plugin comes with a new config variable (upload_path) and a new table (uploaded_files)
893
To use it, set 'upload_path' config variable and 'OPACBaseURL' system preference and link this plugin to a subfield (856$u for instance)
894
Upgrade to 3.21.00.018 done (Bug 13485: Add a page to display links to restricted sites)
895
Upgrade to 3.21.00.019 done (Bug 9809: Get rid of reserveconstraints)
896
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)
897
Upgrade to 3.21.00.021 done (Bug 11584: Add wysiwyg editor to system preferences dealing with HTML)
898
Upgrade to 3.21.00.022 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve)
899
Upgrade to 3.21.00.023 done (Bug 14717: Prevent 0000-00-00 dates in patron data)
900
Upgrade to 3.21.00.024 done (Bug 14098: Regression in Marc Modification Templates)
901
Upgrade to 3.21.00.025 done (Bug 12357: Enhancements to RIS and BibTeX exporting)
902
Upgrade to 3.21.00.026 done (Bug 14472: Wrong ISSN search index in record matching rules)
903
Upgrade to 3.21.00.027 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO)
904
Upgrade to 3.21.00.028 done (Bug 14321: Merge UploadedFile and UploadedFiles into Koha::Upload)
905
Upgrade to 3.21.00.029 done (Bug 14368: Add discharges history)
906
Upgrade to 3.21.00.030 done (Bug 14201: Remove unused code or template from some MARC21 leader plugins )
907
Upgrade to 3.21.00.031 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences)
908
Upgrade to 3.21.00.032 done (Bug 10855: Additional fields for subscriptions)
909
Upgrade to 3.21.00.033 done (Bug 10020: Drop table ethnicity and columns ethnicity and ethnotes)
910
Upgrade to 3.21.00.034 done (Bug 6810: Send membership expiry reminder notices)
911
Upgrade to 3.21.00.035 done (Bug 14045: Add DB fields maxonsiteissueqty and pref ConsiderOnSiteCheckoutsAsNormalCheckouts)
912
Upgrade to 3.21.00.036 done (Bug 10363: There is no package for authorised values)
913
Upgrade to 3.21.00.037 done (Bug 8236: Prevent renewing if overdue or restriction)
914
Upgrade to 3.21.00.038 done (Bug 11759: Add the batch checkout feature)
915
Upgrade to 3.21.00.039 done (Bug 12194: Add column oblique_title to layouts)
916
Upgrade to 3.21.00.040 done (Bug 10937: Option to hide and group itemtypes from advanced search)
917
Upgrade to 3.21.00.041 done (Bug 13590: Add ability to charge fines at start of charge period)
918
Upgrade to 3.21.00.042 done (Bug 15069: items_search_fields.authorised_values_category is still a varchar(32))
919
Upgrade to 3.21.00.043 done (Bug 11559: Professional cataloger's interface)
920
Upgrade to 3.21.00.044 done (Bug 14100: Generic solution for language overlay)
921
Upgrade to 3.21.00.045 done (Bug 14246: (newsauthor) Add borrowernumber to koha_news)
922
Upgrade to 3.21.00.046 done (Bug 14247: (newsauthor) System preference for news author display)
923
Upgrade to 3.21.00.047 done (Bug 10904: Limit patron update request management by branch)
924
Upgrade to 3.21.00.048 done (Bug 14978: Make sure issues.itemnumber is a unique key)
925
Upgrade to 3.21.00.049 done (Bug 11431: Add additional sound options for warnings)
926
Upgrade to 3.21.00.050 done (Bug 12933: Add ability to print overdue slip from staff intranet)
927
Upgrade to 3.21.00.051 done (Bug 14544: Move the list related code to Koha::Virtualshelves)
928
Upgrade to 3.21.00.052 done (Bug 8296: Add descriptive (text) published date field for serials)
929
Upgrade to 3.21.00.053 done (Bug 9468: create new SUGGEST_FORMAT authorised_value list)
930
Upgrade to 3.21.00.054 done (Bug 8064: Merge several biblio records)
931
Upgrade to 3.21.00.055 done (Koha 3.22 beta)
932
Upgrade to 3.21.00.056 done (Bug 12072: New dateformat dd.mm.yyyy)
933
Upgrade to 3.22.00.000 done (Koha 3.22)
934
Upgrade to 3.23.00.000 done (The year of the monkey will be here soon.)
935
Upgrade to 3.23.00.001 done (Bug 11625 - Add pref DefaultToLoggedInLibraryCircRules and DefaultToLoggedInLibraryNoticesSlips)
936
Upgrade to 3.23.00.002 done (Bug 11747 - add pref DefaultToLoggedInLibraryOverdueTriggers)
937
Upgrade to 3.23.00.003 done (Bug 8085 - Rename 'Reserve slip' to 'Hold slip')
938
Upgrade to 3.23.00.004 done (Bug 9819 - stopwords related code should be removed)
939
Upgrade to 3.23.00.005 done (Bug 11569 - Typo in userpermissions.sql)
940
Upgrade to 3.23.00.006 done ( Bug 8956 - Split serials enumeration data into separate fields )
941
Upgrade to 3.23.00.007 done (Bug 13624 - Remove columns branchcode, categorytype from table overduerules_transport_types)
942
Upgrade to 3.23.00.008 done (Bug 9303 - relative's checkouts in the opac)
943
Upgrade to 3.23.00.009 done (Bug 11622 - Add ability to pay fees and fines from OPAC via PayPal)
944
Upgrade to 3.23.00.010 done (Bug 9129 - Add the ability to set the maximum fine for an item to its replacement price)
945
Upgrade to 3.23.00.011 done (Bug 13592 - Hold fee not being applied on placing a hold)
946
Upgrade to 3.23.00.012 done (Bug 15380 - Move the authority types related code to Koha::Authority::Type[s] - part 1)
947
Upgrade to 3.23.00.013 done (Bug 14945 - Add the ability to store the last patron to return an item)
948
Upgrade to 3.23.00.014 done (Bug 10076 - Add Bcc syspref for claimacquisition and clamissues)
949
Upgrade to 3.23.00.015 done (Bug 15443 - Re-code RESERVESLIP as HOLD_SLIP)
950
Upgrade to 3.23.00.016 done (Bug 8753 - Add forgot password link to OPAC)
951
Upgrade to 3.23.00.017 done (Bug 14893 - Separate temporary storage per instance in Upload.pm)
952
Upgrade to 3.23.00.018 done (Bug 15446 - Fix systempreferences rows where type=YesNo and value='')
953
Upgrade to 3.23.00.019 done (Bug 15411 - Change Non Fiction to Non-fiction in authorised_values)
954
Upgrade to 3.23.00.020 done (Bug 9021 - Add SMS via email as an alternative to SMS services via SMS::Send drivers)
955
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)
956
Upgrade to 3.23.00.022 done (Bug 13534 - Deleting staff patron will delete tags approved by this patron)
957
Upgrade to 3.23.00.023 done (Bug 6624 - Allow Koha to use the new read API from OpenLibrary)
958
Upgrade to 3.23.00.024 done (Bug 15517 - Tables borrowers and deletedborrowers differ again)
959
Upgrade to 3.23.00.025 done (Bug 15526 - Drop nozebra database table)
960
Upgrade to 3.23.00.026 done (Bug 15343 - Allow patrons to choose their own password on self registration)
961
Upgrade to 3.23.00.027 done (Bug 4941 - Can't set branch in staff client when singleBranchMode is enabled)
962
Upgrade to 3.23.00.028 done (Bug 14658 - Split PatronSelfRegistrationBorrowerUnwantedField into two preferences for creating and editing)
963
Upgrade to 3.23.00.029 done (Bug 14199 - Unify all organization code plugins)
964
Upgrade to 3.23.00.030 done (Bug 15311: Let libraries set text to display when OpacMaintenance = on)
965
Upgrade to 3.23.00.031 done (Bug 14395 - Two different ways to calculate 'No renewal before')
966
Upgrade to 3.23.00.032 done (Bug 15675 - Add issue_id column to accountlines and use it for updating fines)
967
Upgrade to 3.23.00.033 done (Bug 14659 - Allow patrons to enter card number and patron category on OPAC registration page)
968
Upgrade to 3.23.00.034 done (Bug 11023: Adds field 'new' in items and deleteditems tables)
969
Upgrade to 3.23.00.035 done (Bug 14168 - enhance streaming cataloging to include youtube)
970
Upgrade to 3.23.00.036 done (Bug 12803 - Add ability to skip closed libraries when generating the holds queue)
971
Upgrade to 3.23.00.037 done (Bug 15084 - Move the currency related code to Koha::Acquisition::Currenc[y|ies])
972
Upgrade to 3.23.00.038 done (Bug 14694 - Make decreaseloanHighHolds more flexible)
973
Upgrade to 3.23.00.039 done (Bug 15084 - Move the currency related code to Koha::Acquisition::Currenc[y|ies])
974
Upgrade to 3.23.00.040 done (Bug 16019 - Check intranetcolorstylesheet for blue.css)
975
Upgrade to 3.23.00.041 done (Bug 16007: Make sure overduerules_transport_types.letternumber exists)
976
Upgrade to 3.23.00.042 done (Bug 16004 - Replace items.new with items.new_status)
977
Upgrade to 3.23.00.043 done (Bug 16070 - Empty (undef) system preferences may cause some issues in combination with memcache)
978
Upgrade to 3.23.00.044 done (Bug 10988 - Allow login via Google OAuth2 (OpenID Connect))
979
Upgrade to 3.23.00.045 done (Bug 7736 - Edifact QUOTE and ORDER functionality))
980
Upgrade to 3.23.00.046 done (Bug 15630 - Make Edifact module pluggable))
981
Upgrade to 3.23.00.047 done (Bug 15008 - Add custom HTML areas to circulation and reports home pages)
982
Upgrade to 3.23.00.048 done (Bug 5979 - Add separate OPACISBD system preference)
983
Upgrade to 3.23.00.049 done (Bug 12267 - Allow password option in Patron Attribute non functional)
984
WARNING: If you plan to use Elasticsearch you should go to 'Home › Administration › Search engine configuration' and reset the mappings
985
Upgrade to 3.23.00.050 done (Bug 12478 - Elasticsearch support for Koha)
986
Upgrade to 3.23.00.051 done (Bug 16354 - Fix FK constraints for edifact_messages table)
987
Upgrade to 3.23.00.052 done (Bug 14686 - New menu option and permission for file uploading)
988
Upgrade to 3.23.00.053 done (Bug 16217 - Notice' names may have diverged)
989
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)
990
Upgrade to 3.23.00.055 done (Bug 15533 - Allow patrons and librarians to select itemtype when placing hold)
991
Upgrade to 3.23.00.056 done (Bug 14577 - Allow restriction of checkouts based on fines of guarantor/guarantee)
992
Upgrade to 3.23.00.057 done (Bug 15531 - Add support for standing orders)
993
The system preferences AuthorisedValueImages and StaffAuthorisedValueImages have been turned off
994
authorised_values.imageurl is not populated, that means you are not using this feature
995
Upgrade to 3.23.00.058 done (Bug 16041 - StaffAuthorisedValueImages & AuthorisedValueImages preferences - impact on search performance)
996
Upgrade to 3.23.00.059 done (Bug 16167 - Remove prefs to drive authorised value images)
997
Upgrade to 3.23.00.060 done (Bug 12528 - Enable staff to deny message setting access to patrons on the OPAC)
998
Upgrade to 3.23.00.061 done (Bug 16170 - Add FK for biblionumber in items)
999
Upgrade to 3.23.00.062 done (Bug 16414 - aqorders.budgetgroup_id has never been used and can be removed)
1000
Upgrade to 3.23.00.063 done (Bug 16402: Fix DB structure to work on MySQL 5.7)
1001
Upgrade to 3.23.00.064 done (Bug 15086 - Creators layout and template sql has warnings)
1002
Upgrade to 16.05.00.000 done (Koha 16.05)
1003
Upgrade to 16.06.00.000 done (Koha 16.06 - starting a new dev line at KohaCon16 in Thessaloniki, Greece! Koha is great!)
1004
Upgrade to 16.06.00.001 done (Bug 16200 - 'Hold waiting too long' fee has a translation problem)
1005
Upgrade to 16.06.00.002 done (Bug 10459 - borrowers should have a timestamp)
1006
Upgrade to 16.06.00.003 done (Bug 11490 - MaxItemsForBatch should be split into two new prefs)
1007
Upgrade to 16.06.00.004 done (Bug 15485: Allow choosing different XSLTs for lists)
1008
Upgrade to 16.06.00.005 done (Bug 16768 - Add official number format for Switzerland: 1'234'567.89)
1009
Upgrade to 16.06.00.006 done (Bug 14048: Change RefundLostItemFeeOnReturn to be branch specific)
1010
Upgrade to 16.06.00.007 done (Bug 3534 - Patron quick add form)
1011
Upgrade to 16.06.00.008 done (Bug 6906 - show 'Borrower has previously issued $ITEM' alert on checkout)
1012
Upgrade to 16.06.00.009 done (Bug 14902 - Add qualifier menu to staff side 'Search the Catalog')
1013
Upgrade to 16.06.00.010 done (Bug 15128 - Add ability to limit the number of open purchase suggestions a patron can make)
1014
Upgrade to 16.06.00.011 done (Bug 11606 - Novelist Select in Staff Client)
1015
Upgrade to 16.06.00.012 done (Bug 16573 - Web installer fails to load structure and sample data on MySQL 5.7)
1016
Upgrade to 16.06.00.013 done (Bug 7441 - Search results showing wrong branch)
1017
Upgrade to 16.06.00.014 done (Bug 16829: action_logs should have an 'interface' column)
1018
Upgrade to 16.06.00.015 done (Bug 14642: Add logging of hold modifications)
1019
Upgrade to 16.06.00.016 done (Bug 7045 - Default-value substitution inconsistent)
1020
Upgrade to 16.06.00.017 done (Bug 10848 - Allow configuration of mandatory/required fields on the suggestion form in OPAC)
1021
Upgrade to 16.06.00.018 done (Bug 14695 - Add ability to place multiple item holds on a given record per patron)
1022
Upgrade to 16.06.00.019 done (Bug 15839 - Move the reviews related code to Koha::Reviews)
1023
Upgrade to 16.06.00.020 done (Bug 16272 - Transform checkout from on-site checkout to regular checkout)
1024
Upgrade to 16.06.00.021 done (Bug 16275 - Prevent patron self registration if the email already filled in borrowers.email)
1025
Upgrade to 16.06.00.022 done (Bug 16978 - Add delete reports user permission)
1026
Upgrade to 16.06.00.023 done (Bug 17187)
1027
Note: Pref value for timeout has been adjusted.
1028
Upgrade to 16.06.00.024 done (Bug 16311 - Advanced search language limit typo for Romanian)
1029
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)
1030
Upgrade to 16.06.00.026 done (Bug 16274 - Make the selfregistration branchcode selection configurable)
1031
Upgrade to 16.06.00.027 done (Bug 16276: Add a new pref TrackLastPatronActivity and new column borrowers.lastseen)
1032
Attempting upgrade to 16.06.00.028 (Bug 17135) ...
1033
No fine records needed to be fixed
1034
Upgrade to 16.06.00.028 done (Bug 17135 - Fine for the previous overdue may get overwritten by the next one)
1035
Use of uninitialized value $original_version in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 13039.
1036
Upgrade to 16.06.00.029 done (Bug 14707 - Change UsageStatsCountry from free text to a dropdown list)
1037
Upgrade to 16.06.00.030 done (Bug 16552 - Add the ability to change the default holdings sort)
1038
Upgrade to 16.06.00.031 done (Bug 16273 - Prevent selfregistration from printing the borrower password and filling the logging form)
1039
Upgrade to 16.06.00.032 done (Bug 17357 - WTHDRAWN is still used in installer files)
1040
Upgrade to 16.06.00.033 done (Bug 17216 - Add a new table to store authorized value categories)
1041
Upgrade to 16.06.00.034 done (Bug 10455 - remove redundant 'biblioitems.marc' field)
1042
Upgrade to 16.06.00.035 done (Bug 15131: Give SCO separate control for AllowItemsOnHoldCheckout)
1043
Upgrade to 16.06.00.036 done (Bug 5670 - Housebound Readers Module)
1044
Upgrade to 16.06.00.037 done (Bug 14610 - Add ability to place article requests in Koha)
1045
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)
1046
Upgrade to 16.06.00.039 done (Bug 14598: itemtype is not set on statistics by C4::Circulation::AddReturn)
1047
Upgrade to 16.06.00.040 done (Bug 5260 - Add option to send an order by e-mail to the acquisition module)
1048
Upgrade to 16.06.00.041 done (Bug 14629 - Add aggressive ISSN matching feature equivalent to the aggressive ISBN matcher)
1049
Upgrade to 16.06.00.042 done (Bug 13321 - Tax and prices calculation need to be fixed)
1050
Upgrade to 16.06.00.043 done (Bug 13323 - Change the tax rate on receiving)
1051
Upgrade to 16.06.00.044 done (Bug 17397 - Show name of librarian who created circulation message)
1052
Upgrade to 16.06.00.045 done (Bug 17443 - Make possible to renew patron by later of expiry and current date)
1053
Upgrade to 16.06.00.046 done (Bug 15581 - Add a circ rule to not allow auto-renewals after defined loan period)
1054
Upgrade to 16.06.00.047 done (Bug 17518: Displayed language name for Czech is wrong)
1055
Upgrade to 16.06.00.048 done (Bug 17663 - Forgotten userpermissions)
1056
Upgrade to 16.06.00.049 done (Bug 17391 - ReturnpathDefault and ReplyToDefault missing from syspref.sql)
1057
Upgrade to 16.06.00.050 done (Bug 8835). Everything is fine.
1058
Upgrade to 16.11.00.000 done (Koha 16.11)
1059
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.)
1060
Upgrade to 16.12.00.001 done (Bug 17767 - Let Koha::Patron::Modification handle extended attributes)
1061
Upgrade to 16.12.00.002 done (Bug 14187 - branchtransfer needs a primary key (id) for DBIx and common sense.)
1062
Upgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an authentication method)
1063
Upgrade to 16.12.00.004 done (Bug 17196 - Move marcxml out of the biblioitems table)
1064
Upgrade to 16.12.00.005 done (Bug 17913 - AuthorityMergeMode)
1065
Upgrade to 16.12.00.006 done (Bug 17813: Table borrower_attributes needs a primary key
1066
Upgrade to 16.12.00.007 done (Bug 17960 - Rename opac_news with opac_news.content (template notices have been updated!))
1067
Upgrade to 16.12.00.008 done (Bug 15503 - Grab Item Information from Order Files)
1068
Upgrade to 16.12.00.009 done (Bug 17453 - Inter-site holds improvement)
1069
Upgrade to 16.12.00.010 done (Bug 16034 - Integration with OverDrive Patron API)
1070
Upgrade to 16.12.00.011 done (Bug 17260 - updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns)
1071
Upgrade to 16.12.00.012 done (Bug 14764 - Add OPAC News branch selector)
1072
Upgrade to 16.12.00.013 done (Bug 16530 - Add a circ sidebar navigation menu)
1073
Upgrade to 16.12.00.014 done (Bug 8010 - Search history can be added to the wrong patron)
1074
Upgrade to 16.12.00.015 done (Bug 18066 - Hea version 2)
1075
Upgrade to 16.12.00.016 done (Bug 13757: Make patron attributes editable in the opac if set to 'editable in OPAC)'
1076
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)'
1077
Upgrade to 16.12.00.018 done (Bug 15498 - Replace ExportWithCsvProfile with ExportCircHistory)'
1078
Upgrade to 16.12.00.019 done (Bug 18173 - Remove issues.return DB field)
1079
Upgrade to 16.12.00.020 done (Bug 17560 - Hold fee placement at point of checkout)
1080
Upgrade to 16.12.00.021 done (Bug 17708 - Renewal log seems empty)
1081
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.
1082
Upgrade to 16.12.00.022 done (Bug 17866 - Change sender for serial claim notifications)
1083
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.
1084
Upgrade to 16.12.00.023 done (Bug 9988 - Add AuthorityMergeLimit)
1085
Upgrade to 16.12.00.024 done (Bug 14537 - The system preference 'OverdueNoticeBcc' is mis-named.)
1086
Upgrade to 16.12.00.025 done (Bug 17669 - Introduce preference for deleting temporary uploads)
1087
Upgrade to 16.12.00.026 done (Bug 18427 - Add a primary key to serialitems)
1088
Upgrade to 16.12.00.027 done (Bug 12461 - Add patron clubs feature)
1089
Upgrade to 16.12.00.028 done (Bug 18110 - Adds FR to the syspref AddressFormat)
1090
Upgrade to 16.12.00.029 done (Bug 14224: Add column issues.note and issues.notedate)
1091
Upgrade to 16.12.00.030 done (Bug 16344 - Add a circ rule to limit the auto renewals given a specific date)
1092
Upgrade to 16.12.00.031 done (Bug 15108: OAI-PMH provider improvements)
1093
Upgrade to 16.12.00.032 done (Bug 12063 - Update reserves.expirationdate)
1094
Upgrade to 16.12.00.033 done (Bug 17762 - Add columns letter.lang and borrowers.lang to allow translation of notices)
1095
Upgrade to 16.12.00.034 done (Bug 15582 - Ability to block auto renewals if the OPACFineNoRenewals amount is reached)
1096
Upgrade to 16.12.00.035 done (Bug 15705 - Notify the user on auto renewing)
1097
Upgrade to 16.12.00.036 done (Bug 17465 - Add a System Preference to control number of Saved Reports displayed)
1098
Upgrade to 16.12.00.037 done (Bug 18314 - Add FailedLoginAttempts and borrowers.login_attempts)
1099
Upgrade to 16.12.00.038 done (Bug 18663 - Missing db update for ExportRemoveFields)
1100
Upgrade to 16.12.00.039 done (Bug 18600 - Missing db update for TalkingTechItivaPhoneNotification)
1101
Upgrade to 17.05.00.000 done (Koha 17.05)
1102
Upgrade to 17.06.00.000 done (He pai ake te iti i te kore)
1103
Upgrade to 17.06.00.001 done (Bug 8612 - Add new column export_format.used_for)
1104
Upgrade to 17.06.00.002 done (Bug 18228 - Alter table virtualshelves to simplify permissions)
1105
Upgrade to 17.06.00.003 done (Bug 18801 - Update incorrect Default auth type codes)
1106
Upgrade to 17.06.00.004 done (Bug 16892: Add automatic patron registration via OAuth2 login)
1107
Upgrade to 17.06.00.005 done (Bug 18718 - Language selector in staff header menu similar to OPAC )
1108
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.
1109
Upgrade to 17.06.00.006 done (Bug 18811 - Visibility settings inconsistent between framework and authority editor)
1110
Upgrade to 17.06.00.007 done (Bug 10132 - MARCOrgCode on branch level (branches.marcorgcode))
1111
Upgrade to 17.06.00.008 done (Bug 6758 - Capture membership renewal date for reporting purposes (borrowers.date_renewed))
1112
Upgrade to 17.06.00.009 done (Bug 19344 -  Reorder lang and login_attempts in the [deleted]borrowers tables)
1113
Upgrade to 17.06.00.010 done (Bug 13912 - System preference for default place of publication (country code) for field 008, range 15-17)
1114
Upgrade to 17.06.00.011 done (Bug 13766 - Make ean mediumtext and add ean indexes)
1115
Upgrade to 17.06.00.012 done (Bug 19043 - Z39.50 target for Columbia University is no longer publicly available.)
1116
Upgrade to 17.06.00.013 done (Bug 16401 - fix potentialy bad set staffClientBaseURL preference)
1117
Upgrade to 17.06.00.014 done (Bug 15685 - Allow creation of items (AcqCreateItem) to be customizable per-basket)
1118
Upgrade to 17.06.00.015 done (Bug 19186 - Insert system preference SelfCheckoutByLogin if missing)
1119
Upgrade to 17.06.00.016 done (Bug 18298 - Allow enforcing password complexity (system preference RequireStrongPassword))
1120
Upgrade to 17.06.00.017 done (Bug 14826 - Resurrect account offsets table (Add new tables account_offsets and account_offset_types))
1121
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)
1122
Upgrade to 17.06.00.019 done (Bug 12768 - Add 'Processing Fee' to the account_offset_types table if missing)
1123
Upgrade to 17.06.00.020 done (Bug 19028: Add 'shelving location' to holdings table in detail page (Rename syspref OpacLocationBranchToDisplayShelving with OpacLocationOnDetail))
1124
Upgrade to 17.06.00.021 done (Bug 17381 - Add system preference SCOMainUserBlock)
1125
Upgrade to 17.06.00.022 done (Bug 19038: Remove OPACShowBarcode syspref)
1126
Upgrade to 17.06.00.023 done (Bug 12363 - Add system preference MarkLostItemsAsReturned)
1127
Upgrade to 17.06.00.024 done (Bug 2093 - Add system preference OPACUserSummary)
1128
Upgrade to 17.06.00.025 done (Bug 13178 - Increase cardnumber fields to VARCHAR(32))
1129
Upgrade to 17.06.00.026 done (Bug 10748 - Add system preference BlockReturnOfLostItems)
1130
Upgrade to 17.06.00.027 done (Bug 18882 - Add location code to statistics table for checkouts and renewals)
1131
Upgrade to 17.06.00.028 done (Bug 7317 - Add an Interlibrary Loan Module to Circulation and OPAC)
1132
Upgrade to 17.11.00.000 done (Koha 17.11)
1133
Upgrade to 17.12.00.000 done (Tē tōia, tē haumatia)
1134
Upgrade to 17.12.00.001 done (Bug 19724 - Add [deleted]biblio_metadata.timestamp)
1135
Upgrade to 17.12.00.002 done (Bug 19096 - Make Default authoritative for Koha to MARC mappings)
1136
Upgrade to 17.12.00.003 done (Bug 10021 - Drop notifys-related table and columns)
1137
Upgrade to 17.12.00.004 done (Bug 19278 - Add a configurable default page size for REST endpoints)
1138
Upgrade to 17.12.00.005 done (Bug 18915 - Correct CHECKOUT_NOTE notice template)
1139
Upgrade to 17.12.00.006 done (Bug 17682 - Update URL for Google Scholar in OPACSearchForTitleIn)
1140
Upgrade to 17.12.00.007 done (Bug 15707 - Add new table library_groups)
1141
Upgrade to 17.12.00.008 done (Bug 16735 - Migrate library search groups into the new hierarchical groups)
1142
Upgrade to 17.12.00.009 done (Bug 18403 - Add the view_borrower_infos_from_any_libraries permission )
1143
Upgrade to 17.12.00.010 done (Bug 20133 - Add library_groups.ft_hide_patron_info)
1144
Upgrade to 17.12.00.011 done (Bug 20157 - Use group 'features' to decide which groups to use for group searching functionality)
1145
Upgrade to 17.12.00.012 done (Bug 15752 - Add system preference AutoSwitchPatron)
1146
Upgrade to 17.12.00.013 done (Bug 20175 - Set DEFAULT NULL value for club_enrollments.date_created)
1147
Upgrade to 17.12.00.014 done (Bug 19790 - Remove additionalauthors.author from installer files)
1148
Upgrade to 17.12.00.015 done (Bug 20144 - Adapt DB structure to work with new SQL modes)
1149
Upgrade to 17.12.00.016 done (Bug 18336 - Convert DB tables to utf8mb4 🎁)
1150
Upgrade to 17.12.00.017 done (Bug 17672 - Add damaged_on to items and deleteditems tables)
1151
Upgrade to 17.12.00.018 done (Bug 19290 - Add system preference BrowseResultSelection)
1152
Upgrade to 17.12.00.019 done (Bug 20074 - Auth_subfield_structure changes hidden attribute)
1153
Upgrade to 17.12.00.020 done (Bug 20082 - Update descriptions of Vietnamese language)
1154
Upgrade to 17.12.00.021 done (Bug 13287 - Add system preference PurgeSuggestionsOlderThan)
1155
Upgrade to 17.12.00.022 done (Bug 4078 - Add column currency.p_sep_by_space)
1156
Upgrade to 17.12.00.023 done (Bug 20264 - Remove system preference 'checkdigit')
1157
Upgrade to 17.12.00.024 done (Bug 15492 - Add a standalone self-checkin module)
1158
Upgrade to 17.12.00.025 done (Bug 20291 - Add StaffLoginInstructions system preference and rename NoLoginInstructions with OpacLoginInstructions)
1159
Upgrade to 17.12.00.026 done (Bug 19804 - Add issuingrules.suspension_chargeperiod)
1160
Upgrade to 17.12.00.027 done (Bug 19289 - Add system preference UseACQFrameworkForBiblioRecords)
1161
Upgrade to 17.12.00.028 done (Bug 9701 - Add default indicators (marc_tag_structure.indX_defaultvalue))
1162
Upgrade to 17.12.00.029 done (Bug 14769 - Authorities merge: Set correct indicators in biblio field (new system preference AuthorityControlledIndicators))
1163
Upgrade to 17.12.00.030 done (Bug 19882 - Add system preference NovelistSelectStaffProfile)
1164
Upgrade to 17.12.00.031 done (Bug 11674 - Add system preference MarcFieldDocURL)
1165
Upgrade to 17.12.00.032 done (Bug 19794 - Rename RLIST notice to SERIAL_ALERT)
1166
Upgrade to 17.12.00.033 done (Bug 18786 - Add ability to create custom payment types)
1167
Upgrade to 17.12.00.034 done (Bug 18790 - Add ability to void payment)
1168
Upgrade to 17.12.00.035 done (Bug 19974 - Make MarkLostItemsAsReturned multiple)
1169
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))
1170
Upgrade to 17.12.00.037 done (This change has been reverted, nothing done!)
1171
Upgrade to 17.12.00.038 done (Bug 20245 - Use Bibliographic code value for Slovak language)
1172
Upgrade to 17.12.00.039 done (Bug 20482 - Use Bibliographic code value for Basque, Maori and Albanian languages)
1173
Upgrade to 17.12.00.040 done (Bug 20100 - Add new system preference ProtectSuperlibrarianPrivileges)
1174
Upgrade to 17.12.00.041 done (Bug 11317 - Add a new permission to access files stored on the server)
1175
Upgrade to 17.12.00.042 done (Bug 20402 - Implement OAuth2 authentication for REST API)
1176
Upgrade to 17.12.00.043 done (Bug 20568 - Add API key management interface for patrons)
1177
Upgrade to 17.12.00.044 done (Bug 20624 - Disable OAuth2 client credentials grant by default)
1178
Upgrade to 18.05.00.000 done (Koha 18.05)
1179
Upgrade to 18.06.00.000 done (Koha 18.06 - It's Adventure time!)
1180
Upgrade to 18.06.00.001 done (Bug 3849- Improve descriptions of granular acquisition permissions)
1181
Upgrade to 18.06.00.002 done (Bug 2426 - Remove deprecated management permission)
1182
Upgrade to 18.06.00.003 done (Bug 20073 - Add new types for Elasticsearch fields)
1183
Upgrade to 18.06.00.004 done (Bug 20980 - Manual credit offsets are stored as debits)
1184
Upgrade to 18.06.00.005 done (Bug 12395 - Save order line's creator)
1185
Upgrade to 18.06.00.006 done (Bug 19524 - Share patron lists between staff)
1186
Upgrade to 18.06.00.007 done (Bug 7651 - Add separate permission for managing currencies and exchange rates)
1187
Upgrade to 18.06.00.008 done (Bug 13560 - need an add option in marc modification templates)
1188
Upgrade to 18.06.00.009 done (Bug 19166 - Add the ability to add adjustments to an invoice)
1189
Upgrade to 18.06.00.010 done (Bug 19191 - Add ability to email receipts for account payments and write-offs)
1190
Upgrade to 18.06.00.011 done (Bug 17698: Add column issues.noteseen and old_issues.noteseen)
1191
Upgrade to 18.06.00.012 done (Bug 11911 - Add separate permission for managing suggestions)
1192
Upgrade to 18.06.00.013 done (Bug 20997 - Add Koha::Account::Line::apply)
1193
Upgrade to 18.06.00.014 done (Bug 21121 - New syspref to allow hiding of private patron data in circulation page)
1194
Upgrade to 18.06.00.015 done (Bug 21226 - Remove prefs OCLCAffiliateID, XISBN and XISBNDailyLimit)
1195
Upgrade to 18.06.00.016 done (Bug 20773 - expirationdate filled for waiting holds)
1196
Upgrade to 18.06.00.017 done (Bug 21144: Add ROADTYPE to default authorised values categories)
1197
Upgrade to 18.06.00.018 done (Bug 20487: Clear items.onloan for unissued items)
1198
Upgrade to 18.06.00.019 done (Bug 19719: Default to hiding collection code column)
1199
Upgrade to 18.06.00.020 done (Bug 15524 - Set limit on maximum possible holds per patron by category)
1200
Upgrade to 18.06.00.021 done (Bug 21068 - Remove system preferences NorwegianPatronDB*)
1201
Upgrade to 18.06.00.022 done (Bug 19383 - Add ability to print hold receipts automatically)
1202
Upgrade to 18.06.00.023 done (Bug 18639 - Add replacementprice field to aqorders table)
1203
Upgrade to 18.06.00.024 done (Bug 7534 - Let libraries have configuration for pickup locations)
1204
Upgrade to 18.06.00.025 done (Bug 19817: Add pref KohaManualLanguage and KohaManualBaseURL)
1205
Upgrade to 18.06.00.026 done (Bug 17530 - Add pref ArticleRequestsLinkControl)
1206
Upgrade to 18.06.00.027 done (Bug 21235: Remove table services_throttle)
1207
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)
1208
Upgrade to 18.06.00.029 done (Bug 21288: Slowness in acquisition caused by GetInvoices
1209
Upgrade to 18.06.00.030 done (Bug 20777 - Remove unused field accountlines.dispute)
1210
Upgrade to 18.06.00.031 done (Bug 20819: Add patron_consent)
1211
Upgrade to 18.06.00.032 done (Bug 5458: length of items.ccode disagrees with authorised_values.authorised_value)
1212
Upgrade to 18.06.00.033 done (Bug 12747 - Add AdditionalFieldsInZ3950ResultSearch system preference)
1213
Upgrade to 18.06.00.034 done (Bug 17602 - Integrate support for OneClickdigital/Recorded Books API)
1214
Upgrade to 18.06.00.035 done (Bug 21403 - Add Indian Amazon Affiliate option to AmazonLocale setting)
1215
Upgrade to 18.06.00.036 done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules)
1216
Upgrade to 18.06.00.037 done (Bug 21082 - Add overdrive patron auth method)
1217
Upgrade to 18.06.00.038 done (Bug 21417 - EDI ordering fails when basket and EAN libraries do not match)
1218
Upgrade to 18.06.00.039 done (Bug 15520 - Add more granular permission for only editing own library's circ rules)
1219
Upgrade to 18.06.00.040 done (Bug 11897 - Add Stock Rotation Feature)
1220
Upgrade to 18.06.00.041 done (Bug 20772 - Add illrequestattributes.readonly and illrequest.price_paid columns)
1221
Upgrade to 18.06.00.042 done (Bug 21617: Make statistics.ccode longer)
1222
Upgrade to 18.06.00.043 done (Bug 15486: Restrict number of holds placed by day)
1223
Upgrade to 18.06.00.044 done (Bug 15766: Add column creator_batches.description)
1224
Upgrade to 18.06.00.045 done (Bug 21639 - Add phone transports by default)
1225
Upgrade to 18.06.00.046 done (Bug 18591 - Add comments to ILL requests)
1226
Upgrade to 18.06.00.047 done (Bug 19263 - Advanced Editor - Rancor - Add auto control number (001) widget)
1227
Upgrade to 18.06.00.048 done (Bug 21682 - Remove default on stockrotationrotas.description)
1228
Upgrade to 18.06.00.049 done (Bug 21656 - Stock Rotation Notice, Template Toolkit Syntax Correction)
1229
Upgrade to 18.06.00.050 done (Bug 14385 - Add OpacHiddenItemExceptions)
1230
Upgrade to 18.06.00.051 done (Bug 8630 - Add covers from AdLibris to the OPAC and Intranet)
1231
Upgrade to 18.06.00.052 done (Bug 14391: Add granular permissions to the administration module)
1232
Upgrade to 18.06.00.053 done (Bug 15494 - Block renewals by arbitrary item values)
1233
Upgrade to 18.06.00.054 done (Bug 18316 - Add column search_field.weight)
1234
Upgrade to 18.06.00.055 done (Bug 12365: Add column issuingrules.note)
1235
Upgrade to 18.06.00.057 done (Bug 20312 - Add showLastPatron systempreference)
1236
Upgrade to 18.06.00.058 done (Bug 19349 - Add system preferences MarcFieldForCreatorId, MarcFieldForCreatorName, MarcFieldForModifierId, MarcFieldForModifierName)
1237
Upgrade to 18.06.00.059 done (Bug 20356 - Add EmailSMSSendDriverFromAddress system preference)
1238
Upgrade to 18.06.00.060 done (Bug 15836 - Add class_sort_rules.split_routine and split_regex)
1239
Upgrade to 18.06.00.061 done (Bug 19893 - Add elasticsearch index status preferences)
1240
Upgrade to 18.06.00.062 done (Bug 21730: Add new authorised value category PA_CLASS)
1241
Upgrade to 18.11.00.000 done (18.11.00 release)
1242
Upgrade to 18.12.00.000 done (...and Steven!)
1243
Upgrade to 18.12.00.001 (Bug 21961 - Fix typo in manage_didyoumean permission)
1244
Upgrade to 18.12.00.002 done (Bug 21065 - Set ON DELETE SET NULL on accountlines.borrowernumber)
1245
Upgrade to 18.12.00.003 done (Bug 22024 - Add missing splitting rule definitions)
1246
Upgrade to 18.12.00.004 done (Bug 19066 - Add branchcode to accountlines)
1247
Upgrade to 18.12.00.005 done (Bug 22030: Add OverDriveUsername syspref)
1248
Upgrade to 18.12.00.006 done (Bug 21915 - Add a way to automatically reconcile balance for patrons)
1249
Upgrade to 18.12.00.007 done (Bug 21753: Drop chargename from issuingrules )
1250
Upgrade to 18.12.00.008 done (Bug 17047 - Mana knowledge base)
1251
Upgrade to 18.12.00.009 done (Bug 21241 - Add FallbackToSMSIfNoEmail syspref )
1252
Upgrade to 18.12.00.010 done (Bug 22061 - Add a /public namespace that can be switched on/off)
1253
Upgrade to 18.12.00.011 done (Bug 22155 - biblio_metadata.marcflavour should be renamed 'schema')
1254
Upgrade to 18.12.00.012 done (Bug 22132 - Add Basic authentication)
1255
Upgrade to 18.12.00.013 done (Bug 22198 - Add ghranular permission setting for Mana KB)
1256
Upgrade to 18.12.00.014 done (Bug 13515 - Add a FOREIGN KEY constaint on messages.borrowernumber)
1257
Upgrade to 18.12.00.015 done (Bug 3820 - Update patron modification logs)
1258
Upgrade to 18.12.00.016 done (Bug 20581 - Allow manual selection of custom ILL request statuses)
1259
Upgrade to 18.12.00.017 done (Bug 21747 - Update account_offset_types to include 'fine_increase' and 'fine_decrease')
1260
Upgrade to 18.12.00.018 done (Bug 19575 - Use canonical field names and resolve aliased fields)
1261
Upgrade to 18.12.00.019 done (Bug 21728 - Add 'Reserve Fee' to the account_offset_types table if missing)
1262
Upgrade to 18.12.00.020 done (Bug 18925 - Move maxissueqty and maxonsiteissueqty to circulation_rules)
1263
Upgrade to 18.12.00.021 done (Bug 20912 - Support granular rental charges)
1264
Upgrade to 18.12.00.022 done (Bug 15774 - Add permission for managing additional fields)
1265
Upgrade to 18.12.00.023 done (Bug 20639 - Add ILLOpacbackends syspref)
1266
Upgrade to 18.12.00.024 done (Bug 22368 - Add missing constraints to suggestions)
1267
Upgrade to 18.12.00.025 done (Bug 21846 - Using emoji as tags has broken weights)
1268
WARNING: (Bug 21846) You need to manually run /kohadevbox/koha/misc/maintenance/fix_tags_weight.pl to fix possible issues with tags.
1269
Upgrade to 18.12.00.026 done (Bug 20750 - Allow timestamped auditing of ILL request events)
1270
Upgrade to 18.12.00.027 done (Bug 18837: Add ILLModuleUnmediated Syspref)
1271
Upgrade to 18.12.00.028 done (Bug 21756 - Add 'Account Fee' and 'Hold Expired' to the account_offset_types table if missing)
1272
Upgrade to 18.12.00.029 done (Bug 18736 - Add syspref to control order rounding)
1273
Upgrade to 18.12.00.030 done (Bug 21683 - Remove accountlines.accountno and statistics.proccode fields)
1274
Upgrade to 18.12.00.031 done (Bug 22008 - Add missing constraints for accountlines.manager_id)
1275
Upgrade to 18.12.00.032 done (Bug 18235 - Elastic search - make facets configurable)
1276
Upgrade to 18.12.00.033 done (Bug 18213 - Add language facets to Elasticsearch)
1277
Upgrade to 18.12.00.034 done (Bug 22516 - Drop deprecated accountlines.lastincrement field)
1278
Upgrade to 18.12.00.035 done (Bug 19722 - Add a MaxItemsToDisplayForBatchMod preference)
1279
Upgrade to 18.12.00.036 done (Bug 22518 - Fix accounttype 'O' to 'FU' - 0 updated)
1280
Upgrade to 18.12.00.037 done (Bug 22607 - Set default value of issues.renewals to 0)
1281
Upgrade to 18.12.00.038 done (Bug 22512 - Add status to accountlines)
1282
Upgrade to 18.12.00.039 done (Bug 22600 - Add interface to accountlines)
1283
Upgrade to 18.12.00.040 done (Bug 12166 - Remove 'Reserve Charge' text from accountlines description)
1284
Upgrade to 18.12.00.041 done (Bug 19670 - Change collation of marc_field to allow mixed case search field mappings)
1285
Upgrade to 18.12.00.042 done (Bug 29891 - Remove non-XSLT detail view in the staff client)
1286
Upgrade to 18.12.00.043 done (Bug 21953 - Remove 'Lost Item' text from accountlines description)
1287
Upgrade to 18.12.00.044 done (Bug 21890 - Patron password reset by category)
1288
Upgrade to 18.12.00.045 done (Bug 10796 - Patron password change by category)
1289
Upgrade to 18.12.00.046 done (Bug 22695 - Remove non-XSLT search results view from the staff client)
1290
Upgrade to 18.12.00.047 done (Bug 14557: Add Libris spellchecking system preferences)
1291
Upgrade to 18.12.00.048 done (Bug 22044 - Set a default value for NoRenewalBeforePrecision)
1292
Upgrade to 18.12.00.049 done (Bug 21336 - Add field flgAnonymized)
1293
Upgrade to 18.12.00.050 done (Bug 21336 - Add preferences)
1294
Upgrade to 18.12.00.051 done (Bug 21336 - Reset login_attempts)
1295
Upgrade to 18.12.00.052 done (Bug 22311 - Add a SysPref to allow adding content to the #moresearches div in the opac)
1296
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)
1297
Upgrade to 18.12.00.054 done (Bug 20128: Add permission for Advanced Cataloging Editor)
1298
Upgrade to 18.12.00.055 done (Bug 22521 - Update accountlines.accounttype to varchar(16), and map new statuses)
1299
Upgrade to 18.12.00.056 done (Bug 8701 - Update OpacHiddenItems system preference description)
1300
Upgrade to 18.12.00.057 done (Bug 13795 - Delete unused fields from statistics table)
1301
Use of uninitialized value $opaclang in split at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 18235.
1302
Upgrade to 18.12.00.058 done (Bug 22318: Move contents of OpacNavRight preference to Koha news system)
1303
Upgrade to 18.12.00.059 done (Bug 22532 - Remove import_records z3950random column)
1304
Upgrade to 18.12.00.060 done (Bug 22564 - Fix accounttype 'Rep' - 0 updated)
1305
Upgrade to 18.12.00.061 done (Bug 21336 - (follow-up) Rename flgAnonymized column)
1306
Upgrade to 18.12.00.062 done (Bug 22339 - Fix search field mappings of MARC fixed fields)
1307
Upgrade to 18.12.00.063 done (Bug 22511 - Update existing VOID accountlines)
1308
Upgrade to 18.12.00.064 done (Bug 14576: Add UpdateItemLocationOnCheckin syspref)
1309
Upgrade to 18.12.00.065 done (Bug 10300 - Allow transferring of items to be have separate IndependentBranches syspref)
1310
Upgrade to 18.12.00.066 done (Bug 8995 - Add new preferences for OpenURLResolvers)
1311
Upgrade to 18.12.00.067 done (Bug 8000 - Add new preferences for SendAllEmailsTo)
1312
Upgrade to 18.12.00.068 done (Bug 7088: Cannot renew items on hold even with override)
1313
Upgrade to 18.12.00.069 done (Bug 22053 - enable all plugins)
1314
Upgrade to 18.12.00.070 done (Bug 14407 - Limit web-based self-checkout to specific IP addresses)
1315
Upgrade to 18.12.00.071 done (Bug 22809 - Move 'ACCOUNT_CREDIT' from template to a slip)
1316
Upgrade to 18.12.00.072 done (Bug 22809 - Move 'INVOICE' from template to a slip)
1317
Upgrade to 18.12.00.073 done (Bug 5770 - Email librarian when purchase suggestion made)
1318
Upgrade to 18.12.00.074 done (Bug 21411 - Add keyboard_shortcuts table)
1319
Upgrade to 18.12.00.075 done (Bug 22899 - Add items constraint to tmp_holdsqueue)
1320
Upgrade to 19.05.00.000 done (19.05.00 release)
1321
Upgrade to 19.06.00.000 done (Wingardium Leviosa!)
1322
Upgrade to 19.06.00.001 done (Bug 22960: Fix typo in syspref description)
1323
Upgrade to 19.06.00.002 done (Bug 10215: Increase the size of opacnote and librariannote for table subscriptionhistory)
1324
Upgrade to 19.06.00.003 done (Bug 22867: UniqueItemFields preference value should be pipe-delimited)
1325
Upgrade to 19.06.00.004 done (Bug 22770: Fix typo in language description for el in German)
1326
Upgrade to 19.06.00.005 done (Bug  9834: Add the reserves.item_level_hold column)
1327
Upgrade to 19.06.00.006 done (Bug 21073: Improve plugin performance)
1328
Upgrade to 19.06.00.007 done (Bug 22653: Remove unimplemented RotationPreventTransfers system preference)
1329
Upgrade to 19.06.00.008 done (Bug 23109: Improve description of staffaccess permission)
1330
Upgrade to 19.06.00.009 done (Bug 17178: add shortcut to keyboard_shortcuts)
1331
Upgrade to 19.06.00.010 done (Bug 18928: Move holdallowed, hold_fulfillment_policy, returnbranch to circulation_rules)
1332
Upgrade to 19.06.00.011 done (Bug 18930: Move lost item refund rules to circulation_rules table)
1333
Upgrade to 19.06.00.012 done (Bug 22563: Fix accounttypes for 'L', 'LR' and 'CR')
1334
Upgrade to 19.06.00.013 done (Bug 23151: Add borrower_modifications.changed_fields column)
1335
Upgrade to 19.06.00.014 done (Bug 11573: Fix accounttypes for 'Rent')
1336
Upgrade to 19.06.00.015 done (Bug 22524: Fix date/time-last-modified search with Elasticsearch)
1337
Upgrade to 19.06.00.016 done (Bug 23396: Fix missing keyboard_shortcuts table)
1338
Upgrade to 19.06.00.017 done (Bug 22610: Fix accounttypes for SIP2 payments)
1339
Use of uninitialized value $marcflavour in string eq at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 19187.
1340
Upgrade to 19.06.00.018 done (Bug 11529: Add medium, subtitle and part information to biblio table)
1341
NOTE: misc/batchRebuildBiblioTables.pl should be run to populate the fields introduced in bug 11529. It may take some time for larger databases.
1342
1343
Upgrade to 19.06.00.019 done (Bug 23228: Add option to automatically display payment receipt for printing after making a payment)
1344
Upgrade to 19.06.00.020 done (Bug 23416: Add PreserveSerialNotes syspref)
1345
Upgrade to 19.06.00.021 done (Bug 23309: Can't add new subfields to bibliographic frameworks in strict mode)
1346
Upgrade to 19.06.00.022 done (Bug 14570: Make it possible to add multiple guarantors to a record)
1347
Upgrade to 19.06.00.023 done (Bug 22258: Add ElasticsearchMARCFormat preference)
1348
Upgrade to 19.06.00.024 done (Bug 23539: accountlines.accounttype should match authorised_values.authorised_value in size)
1349
Upgrade to 19.06.00.025 done (Bug 22996: Add pref BarcodeSeparators)
1350
Upgrade to 19.06.00.026 done (Bug 20691: Add ability for guarantors to view guarantee's fines in OPAC)
1351
Upgrade to 19.06.00.027 done (Bug 15497: Add itemtypes_branches table)
1352
Upgrade to 19.06.00.028 done (Bug 11573: Fix accounttypes for 'A')
1353
Upgrade to 19.06.00.029 done (Bug 23321: Add cash_registers table, permissions and preferences)
1354
Upgrade to 19.06.00.030 done (Bug 19618: add club_holds tables)
1355
Upgrade to 19.06.00.031 done (Bug 23566: Add OPACDetailQRCode system preference)
1356
Upgrade to 19.06.00.032 done (Bug 20589: Add field boosting and use elastic query fields parameter instead of depricated _all)
1357
Upgrade to 19.06.00.033 done (Bug 23686: Add OnSiteCheckoutAutoCheck system preference)
1358
Upgrade to 19.06.00.034 done (Bug 23007: Make transfer modals optionally block circ)
1359
Upgrade to 19.06.00.035 done (Bug 18421: Add Coce image cache to the Intranet)
1360
Upgrade to 19.06.00.036 done (Bug 20334: Add elasticsearch escape options preference)
1361
Upgrade to 19.06.00.037 done (Bug 21701: PayPal return URL option)
1362
Upgrade to 19.06.00.038 done (Bug 23697: Rename CircAutocompl system preference to PatronAutoComplete)
1363
Upgrade to 19.06.00.039 done (Bug 17179: Add additional keyboard_shortcuts)
1364
Upgrade to 19.06.00.040 done (Bug 17140: Add pref to allow rounding fines at payment)
1365
Upgrade to 19.06.00.041 done (Bug 22880: Allow granular control of socialnetworks preference)
1366
Upgrade to 19.06.00.042 done (Bug 22445: Add new pref *CustomCoverImages*)
1367
Upgrade to 19.06.00.043 done (Bug 23049: Add account debit_types)
1368
Upgrade to 19.06.00.044 done (Bug 23805: Add account credit_types)
1369
Upgrade to 19.06.00.045 done (Bug 23866: Set HEA syspref to prompt for review)
1370
Upgrade to 19.06.00.046 done (Bug 15260: Option for extended loan with useDaysMode)
1371
Upgrade to 19.06.00.047 done (Bug 14697: Extend and enhance 'Claims returned' lost status)
1372
Upgrade to 19.06.00.048 done (Bug 22581: add new OPACShowMusicalInscripts and OPACPlayMusicalInscripts system preferences)
1373
Upgrade to 19.06.00.049 done (Bug 13958: Add a SuspensionsCalendar syspref)
1374
Upgrade to 19.06.00.050 done (Bug 23293: Add 'OPACFineNoRenewalsIncludeCredits' system preference)
1375
Upgrade to 19.11.00.000  [12:51:56]: 19.11.00 release
1376
Upgrade to 19.12.00.000  [12:51:56]: Dobbie is a free elf...
1377
Upgrade to 19.12.00.001  [12:51:56]: Bug 17831 - Remove non-existing bibliosubject.subject from frameworks
1378
Upgrade to 19.12.00.002  [12:51:56]: Bug 23233 - Rename AllowItemsOnHoldCheckout syspref
1379
Upgrade to 19.12.00.003  [12:51:56]: Bug 22284 - Add ft_local_hold_group column to library_groups
1380
Upgrade to 19.12.00.004  [12:51:56]: Bug 24080 - Add PAYOUT account_debit_type
1381
Upgrade to 19.12.00.005  [12:51:56]: Bug 24329 - Do not update action_log.timestamp
1382
Upgrade to 19.12.00.006  [12:51:56]: Bug 24263 - Replace relationship with NULL when empty string
1383
Upgrade to 19.12.00.007  [12:51:56]: Bug 23442 - Add REFUND to account_credit_types
1384
Upgrade to 19.12.00.008  [12:51:56]: Bug 24206 - Update OpacSearchForTitleIn system preference
1385
Upgrade to 19.12.00.009  [12:51:56]: Bug 23354 - Add 'Purchase' account offset type
1386
Upgrade to 19.12.00.010  [12:51:56]: Bug 21520 - Add rule_order and rule_operator fields to oai_sets_mappings table
1387
Upgrade to 19.12.00.011  [12:51:56]: Bug 24289 - Adding foreign keys on *_holidays.branchcode tables
1388
Upgrade to 19.12.00.012  [12:51:56]: Bug 24481 - Move permission to correct module_bit
1389
Upgrade to 19.12.00.013  [12:51:56]: Bug 24478 - Add `EnablePointOfSale` system preference to allow disabling the point of sale feature)
1390
Upgrade to 19.12.00.014  [12:51:56]: Bug 24287 - Add 'reason' field to transfers table
1391
Upgrade to 19.12.00.015  [12:51:56]: Bug 24296 - Update stockrotation to use 'reason' field in transfers table
1392
Upgrade to 19.12.00.016  [12:51:56]: Bug 22868 - Move suggestions_manage subpermission out of acquisition permission
1393
Upgrade to 19.12.00.017  [12:51:56]: Bug 21674 - Add unique key (parent_id, branchcode) to library_group
1394
Upgrade to 19.12.00.018  [12:51:56]: Bug 18936 - Convert issuingrules fields to circulation_rules
1395
Upgrade to 19.12.00.019  [12:51:56]: Bug 23673 - modify time_queued and add updated_on to message_queue
1396
Upgrade to 19.12.00.020  [12:51:56]: Bug  8643 - Add important constraint to marc subfields
1397
Upgrade to 19.12.00.021  [12:51:56]: Bug 24592 - Update LOST_RETURN to LOST_FOUND
1398
Upgrade to 19.12.00.022  [12:51:56]: Bug 20882 - items.uri to MEDIUMTEXT
1399
Upgrade to 19.12.00.023  [12:51:56]: Bug 24640 - Allow quotes.timestamp to be NULL
1400
Upgrade to 19.12.00.024  [12:51:56]: Bug 21633 - Remove finesMode "test"
1401
Upgrade to 19.12.00.025  [12:51:56]: Bug 24103 - add DumpSearchQueryTemplate syspref
1402
Upgrade to 19.12.00.026  [12:51:56]: Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches
1403
Upgrade to 19.12.00.027  [12:51:56]: Bug 24532 - Fix pathological cases of negative debits
1404
Upgrade to 19.12.00.028  [12:51:56]: Bug 14567 - Add OpacBrowseSearch syspref
1405
Upgrade to 19.12.00.029  [12:51:56]: Bug 17702 - Add column account_credit_types.archived
1406
Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115.
1407
Upgrade to 19.12.00.030  [12:51:56]: Bug 22880 - Move contents of opacheader preference to Koha news system
1408
Upgrade to 19.12.00.031  [12:51:56]: Bug 22273 - Column article_requests.created_on should not be updated
1409
Upgrade to 19.12.00.032  [12:51:56]: Bug 24735 - Remove UseQueryParser system preference
1410
Upgrade to 19.12.00.033  [12:51:56]: Bug 23355 - Add cash_register_actions table
1411
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
1412
Upgrade to 19.12.00.035  [12:51:56]: Bug 23442 - Add a refund option to the point of sale system
1413
Upgrade to 19.12.00.036  [12:51:56]: Bug 24369 - Add CORS support to Koha
1414
Upgrade to 19.12.00.037  [12:51:56]: Bug 23051 - Add RenewAccruingItemInOpac syspref
1415
Upgrade to 19.12.00.038  [12:51:56]: Bug 23112 - Add CirculateILL syspref
1416
Upgrade to 19.12.00.039  [12:51:56]: Bug 17845 - Drop unused table printers and branchprinter column
1417
Upgrade to 19.12.00.040  [12:51:56]: Bug 17374 - Update description of DefaultPatronSearchFields
1418
Upgrade to 19.12.00.041  [12:51:56]: Bug 24722 - Enforce NOT NULL constraint for reserves.priority
1419
Upgrade to 19.12.00.042  [12:51:56]: Bug 22821 - Add reply_address to message_queue
1420
Upgrade to 19.12.00.043  [12:51:56]: Bug 24296 - Add 'return' reasons to branchtransfers enum
1421
Upgrade to 19.12.00.044  [12:51:57]: Bug 24846 - Add a new permission for new tool batch extend due dates
1422
Upgrade to 19.12.00.045  [12:51:57]: Bug  4461 - Add CollapseFieldsPatronAddForm system preference
1423
Upgrade to 19.12.00.046  [12:51:57]: Bug 24818 - Update 'accountlines.date' from DATE to TIMESTAMP
1424
Upgrade to 19.12.00.047  [12:51:57]: Bug 22987 - Add biblioimages.timestamp
1425
Upgrade to 19.12.00.048  [12:51:57]: Bug 24299 - Add 'collection' reasons to branchtransfers enum
1426
Upgrade to 19.12.00.049  [12:51:57]: Bug 24299 - Add 'reserve' reasons to branchtransfers enum
1427
Upgrade to 19.12.00.050  [12:51:57]: Bug 24854 - Remove IDreamBooks* system preferences
1428
Upgrade to 19.12.00.051  [12:51:57]: Bug 24759 - Cleanup OpacRenewalBranch
1429
Upgrade to 19.12.00.052  [12:51:57]: Bug 21443 - Add ability to exclude holidays when calculating rentals fees by time period
1430
Upgrade to 19.12.00.053  [12:51:57]: Bug 24476 - Allow patrons to opt-out of autorenewal
1431
Upgrade to 19.12.00.054  [12:51:57]: Bug 13881 - Add desk management
1432
Upgrade to 19.12.00.055  [12:51:57]: Bug 23590 - Add lastmodificationby and lastmodificationdate to the suggestions table
1433
Upgrade to 19.12.00.056  [12:51:57]: Bug 20415 - Remove UseKohaPlugins preference
1434
Upgrade to 19.12.00.057  [12:51:57]: Bug 20399 - Remove INTRAdidyoumean preference
1435
Upgrade to 19.12.00.058  [12:51:57]: Bug 14715 - Add sysprefs numSearchResultsDropdown and OPACnumSearchResultsDropdown
1436
Upgrade to 19.12.00.059  [12:51:57]: Bug 18177 - Remove some unused columns from aqbooksellers
1437
Upgrade to 19.12.00.060  [12:51:57]: Bug 23204 - Change enum order for marc_type in search_marc_map to fix sorting
1438
Upgrade to 19.12.00.061  [12:51:57]: Bug 24474 - Add `onpayment` option to MarkLostItemsAsReturned
1439
Upgrade to 19.12.00.062  [12:51:57]: Bug 25010 - Fix typo in account_debit_type description
1440
Upgrade to 19.12.00.063  [12:51:57]: Bug 22534 - Add PreFillGuaranteeField syspref
1441
Upgrade to 19.12.00.064  [12:51:57]: Bug  4944 - Add new system preference OpacNoItemTypeImages
1442
Upgrade to 19.12.00.065  [12:51:57]: Bug 23173 - Add ILLCheckAvailability syspref
1443
Upgrade to 19.12.00.066  [12:51:57]: Bug  4461 - Add OPACReportProblem system preference
1444
Upgrade to 19.12.00.067  [12:51:57]: Bug 20754 - Remove double accepted list shares
1445
Upgrade to 19.12.00.068  [12:51:57]: Bug 21190 - Add prefs AuthFailureLog and AuthSuccessLog
1446
Upgrade to 19.12.00.069  [12:51:57]: Bug 22784 - Add a new suggestions.archived column
1447
Upgrade to 19.12.00.070  [12:51:57]: Bug 22774 - Limit purchase suggestion in a specified time period
1448
Upgrade to 19.12.00.071  [12:51:57]: Bug 22887 - Add unique constraint to authorised_values
1449
Upgrade to 19.12.00.072  [12:51:57]: Bug 24380 - Add syspref CalculateFinesOnBackdate
1450
Upgrade to 19.12.00.073  [12:51:57]: Bug 25152 - Update subscription.closed to tinyint(1) as per guidelines
1451
Upgrade to 19.12.00.074  [12:51:57]: Bug 25147 - Rename AllowSelfCheckReturns to SCOAllowCheckin for consistency
1452
Upgrade to 19.12.00.075  [12:51:57]: Bug 25086 - Set changed_fields column of borrower_modifications as nullable
1453
Upgrade to 19.12.00.076  [12:51:57]: Bug 21901 - Add foreign key constraints on serial
1454
Upgrade to 19.12.00.077  [12:51:57]: Bug 23727 - Editing course reserve items is broken
1455
Upgrade to 19.12.00.078  [12:51:57]: Bug 24913 - Add PatronSelfRegistrationConfirmEmail syspref
1456
Upgrade to 19.12.00.079  [12:51:57]: Bug 25045 - Add a way to restrict anonymous access to public routes (OpacPublic behaviour)
1457
Upgrade to 19.12.00.080  [12:51:57]: Bug 23081 - Set default to 0 for items.issues
1458
Upgrade to 19.12.00.081  [12:51:57]: Bug 22630 - Add course_items.homebranch
1459
Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115.
1460
Upgrade to 19.12.00.082  [12:51:57]: Bug 23794 - Move contents of OpacMainUserBlock preference to Koha news system
1461
Upgrade to 19.12.00.083  [12:51:57]: Bug 17355 - Add is_system to authorised_value_categories table
1462
Upgrade to 19.12.00.084  [12:51:58]: Bug 17682 - Add macros db table and permissions
1463
Upgrade to 19.12.00.085  [12:51:58]: Bug 24161 - Add new join table aqorders_claims to keep track of claims
1464
Upgrade to 19.12.00.086  [12:51:58]: Bug 24163 - Define a default CSV profile for late orders
1465
Upgrade to 19.12.00.087  [12:51:58]: Bug 25184 - Items with a negative notforloan status should not be captured for holds
1466
Upgrade to 19.12.00.088  [12:51:58]: Bug 24378 - Fix some grammatical errors in default auto renewal notice
1467
Upgrade to 19.12.00.089  [12:51:58]: Bug 25389 - Catch errant cases of LOST_RETURNED
1468
Upgrade to 19.12.00.090  [12:51:58]: Bug 13881 - Add issue desks system preference
1469
Upgrade to 19.12.00.091  [12:51:58]: Bug 13881 - Correction to preference terminology
1470
Upgrade to 20.05.00.000  [12:51:58]: 20.05.00 alpha release
1471
Upgrade to 20.06.00.000  [12:51:58]: All our codebase are belong to everybody
1472
Upgrade to 20.06.00.001  [12:51:59]: Bug 24986 - Switch borrowers address related fields to TINYTEXT or MEDIUMTEXT
1473
Upgrade to 20.06.00.002  [12:51:59]: Bug 25184 - Items with a negative notforloan status should not be captured for holds
1474
Upgrade to 20.06.00.003  [12:51:59]: Bug 24156 - Add new table tables_settings
1475
Upgrade to 20.06.00.004  [12:51:59]: Bug 25851 - Remove holdallowed rule if value is an empty string
1476
Upgrade to 20.06.00.005  [12:51:59]: Bug 24379 - Set login_attempts NOT NULL
1477
Upgrade to 20.06.00.006  [12:51:59]: Bug 24151 - Add pseudonymized_transactions tables and sysprefs for Pseudonymization
1478
Upgrade to 20.06.00.007  [12:51:59]: Bug 22844 - Add borrower_attribute_types.mandatory
1479
Upgrade to 20.06.00.008  [12:51:59]: Bug 23148 - Replace Bridge icons with transparent PNG files
1480
Upgrade to 20.06.00.009  [12:51:59]: Bug 23391 - Hide finished ILL requests
1481
Upgrade to 20.06.00.010  [12:51:59]: Bug 20815 - Add NoRefundOnLostReturnedItemsAge system preference
1482
Upgrade to 20.06.00.011  [12:51:59]: Bug  5087 - Add export_format.staff_only
1483
Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115.
1484
Upgrade to 20.06.00.012  [12:51:59]: Bug 23795 - Convert OpacCredits system preference to news block
1485
Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115.
1486
Upgrade to 20.06.00.013  [12:51:59]: Bug 23795 - Convert OpacCustomSearch system preference to news block
1487
Upgrade to 20.06.00.014  [12:51:59]: Bug 23797 - Extend the opac_news lang column to accommodate longer values
1488
Use of uninitialized value in split at /kohadevbox/koha/C4/Languages.pm line 115.
1489
Upgrade to 20.06.00.015  [12:51:59]: Bug 23797 - Convert OpacLoginInstructions system preference to news block
1490
Upgrade to 20.06.00.016  [12:51:59]: Bug 23092 - Add 'daterequested' field to transfers table
1491
Upgrade to 20.06.00.017  [12:51:59]: Bug 25709 - Rename systempreference to NotesToHide
1492
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
1493
Upgrade to 20.06.00.019  [12:51:59]: Bug 22660 - Adds NewsToolEditor system preference
1494
Upgrade to 20.06.00.020  [12:51:59]: Bug 26070 - Remove references to deprecated Google Transliterate API
1495
Upgrade to 20.06.00.021  [12:51:59]: Bug 25871 - Add library option to OpacItemLocation
1496
Upgrade to 20.06.00.022  [12:51:59]: Bug 21946 - Add parent type to itemtypes
1497
Upgrade to 20.06.00.023  [12:51:59]: Bug 16371 - Quote of the Day (QOTD) for the staff interface 
1498
Upgrade to 20.06.00.024  [12:51:59]: Bug 25867 - Update subfield descriptions for 952$a and 952$b
1499
Upgrade to 20.06.00.025  [12:51:59]: Bug  6725 - Adds PatronDuplicateMatchingAddFields system preference
1500
Upgrade to 20.06.00.026  [12:51:59]: Bug 19036 - Add accountlines.credit_number, account_credit_types.credit_number_enabled and syspref AutoCreditNumber
1501
Upgrade to 20.06.00.027  [12:51:59]: Bug  8732 - Add new BiblioItemtypeInfo to system preferences
1502
Upgrade to 20.06.00.028  [12:51:59]: Bug 25958 - Allow LongOverdue cron to exclude specified lost values
1503
Upgrade to 20.06.00.029  [12:51:59]: Bug 25534 - Add ability to send an email specifying a reason when canceling a hold
1504
Upgrade to 20.06.00.030  [12:51:59]: Bug 20057 - Add new system preference 'AutoApprovePatronProfileSettings'
1505
Upgrade to 20.06.00.031  [12:52:00]: Bug 22789 - Add non_priority column on reserves and old_reserves tables
1506
Upgrade to 20.06.00.032  [12:52:00]: Bug 19889 - Add exclude_from_local_holds_priority column to items, deleteditems and categories tables
1507
Upgrade to 20.06.00.033  [12:52:00]: Bug 21066 - Rename column opac_news.timestamp with published_on
1508
Upgrade to 20.06.00.034  [12:52:00]: Bug 24197 - Add new system preference 'AddressForFailedOverdueNotices'
1509
Upgrade to 20.06.00.035  [12:52:00]: Bug 23682 - Add new system preference 'EdifactInvoiceImport'
1510
Upgrade to 20.06.00.036  [12:52:00]: Bug 20168 - Update OPACSearchForTitleIn to work with Bootstrap 4
1511
Upgrade to 20.06.00.037  [12:52:00]: Bug 23816 - Add min_password_length and require_strong_password columns in categories table
1512
Upgrade to 20.06.00.038  [12:52:00]: Bug 24807 - Add 'year' type to improve sorting behaviour
1513
Upgrade to 20.06.00.039  [12:52:00]: Bug 18958 - Add reserve_id to hold_fill_targets
1514
Upgrade to 20.06.00.040  [12:52:00]: Bug 26454 - Add system preference to set meta description for the OPAC
1515
Upgrade to 20.06.00.041  [12:52:00]: Bug 26268 - Remove items.paidfor field
1516
Upgrade to 20.06.00.042  [12:52:00]: Bug 25776 - Add letter.updated_on
1517
Upgrade to 20.06.00.043  [12:52:00]: Bug 25261 - Add CircConfirmItemParts syspref
1518
Upgrade to 20.06.00.044  [12:52:00]: Bug 22343 - Add SMTP configuration options
1519
Upgrade to 20.06.00.045  [12:52:00]: Bug 22417 - Add new table background_jobs
1520
Upgrade to 20.06.00.046  [12:52:00]: Bug 13535 - Add FK constraint on borrowernumber to alert table
1521
Upgrade to 20.06.00.047  [12:52:00]: Bug 23420 - Allow configuration of hidden fields on the suggestion form in OPAC
1522
Upgrade to 20.06.00.048  [12:52:00]: Bug 26529 - Remove blank default branch rules
1523
Upgrade to 20.06.00.049  [12:52:00]: Bug 26145 - Add the biblioimages.itemnumber column
1524
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'
1525
Upgrade to 20.06.00.051  [12:52:00]: Bug 12556 - Add new syspref HoldsNeedProcessingSIP
1526
Upgrade to 20.06.00.052  [12:52:00]: Bug 25460 - Update OAI set when adding/editing/deleting item records
1527
Upgrade to 20.06.00.053  [12:52:00]: Bug 26569 - Use gender neutral pronouns in system preference explanations
1528
Upgrade to 20.06.00.054  [12:52:00]: Bug 25596 - Add OVERPAYMENT credit type
1529
Use of uninitialized value in numeric gt (>) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 23117.
1530
Upgrade to 20.06.00.055  [12:52:00]: Bug 18050 - Add FK constraint on aqbudgets.budget_period_id
1531
Upgrade to 20.06.00.056  [12:52:00]: Bug 26853 - Update import_biblios columns and indexes
1532
Upgrade to 20.06.00.057  [12:52:00]: Bug 26638 - Add missing system preference ArticleRequestsMandatoryFieldsItemOnly
1533
Upgrade to 20.06.00.058  [12:52:00]: Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"
1534
Upgrade to 20.06.00.059  [12:52:00]: Bug 19482 - Add mandatory column to search_field for ES mapping
1535
Upgrade to 20.06.00.060  [12:52:00]: Bug 25334 - Add generic 'phone' message transport type
1536
Upgrade to 20.06.00.061  [12:52:00]: Bug 24412 - Attach waiting reserve to desk
1537
Upgrade to 20.06.00.062  [12:52:00]: Bug 23091 - Update refund rules
1538
Upgrade to 20.06.00.063  [12:52:00]: Bug 14866 - Add decreaseloanholds circulation rule
1539
Upgrade to 20.06.00.064  [12:52:00]: Bug 24603 - Add CANCELLATION credit_type_code
1540
Upgrade to 20.06.00.065  [12:52:00]: Bug 23916 - Add new [old_]issues.issuer DB fields
1541
Upgrade to 20.06.00.066  [12:52:00]: Bug 22818 - Add ILL notices
1542
Upgrade to 20.06.00.067  [12:52:00]: Bug 20936 - Add new system preference OPACHoldsHistory
1543
Upgrade to 20.06.00.068  [12:52:01]: Bug 23019 - Add import_batch_profiles table and profile_id column in import_batches
1544
Upgrade to 20.06.00.069  [12:52:01]: Bug 24083 - Add circulation_rules 'unseen_renewals_allowed'
1545
Upgrade to 20.11.00.000  [12:52:01]: Koha 20.11.00 release
1546
Upgrade to 20.12.00.000  [12:52:01]: Sorry, this is my first life, I am still learning!
1547
Upgrade to 20.12.00.001  [12:52:01]: Bug 27252 - Add ElasticsearchCrossFields system preference
1548
Upgrade to 20.12.00.002  [12:52:01]: Bug 27351 - Set type for UsageStatsCountry to Choice
1549
Upgrade to 20.12.00.003  [12:52:01]: Bug 27349 - Update type for Mana system preference to Choice
1550
Upgrade to 20.12.00.004  [12:52:01]: Bug 27485 - Rename system preference 'gist' to 'TaxRates'
1551
Upgrade to 20.12.00.005  [12:52:01]: Bug 27491 - Rename system preference 'opaclanguages' to 'OPACLanguages'
1552
Upgrade to 20.12.00.006  [12:52:01]: Bug 27487 - Rename system preference 'reviewson' to 'OPACComments
1553
Upgrade to 20.12.00.007  [12:52:01]: Bug 27486 - Renaming system preference 'delimiter' to 'CSVDelimiter'
1554
Upgrade to 20.12.00.008  [12:52:01]: Bug 25552 - Add missing Claims Returned option to MarkLostItemsAsReturned
1555
Upgrade to 20.12.00.009  [12:52:01]: Bug 27581 - Rename system preference 'UseICU' to 'UseICUStyleQuotes'
1556
Upgrade to 20.12.00.010  [12:52:01]: Bug 20410 - Remove OpacGroupResults
1557
Upgrade to 20.12.00.011  [12:52:01]: Bug 18506 - Add OPACShibOnly and staffShibOnly system preferences
1558
Upgrade to 20.12.00.012  [12:52:01]: Bug 27598 - Add UPLOAD as a built-in system authorized value category
1559
Upgrade to 20.12.00.013  [12:52:01]: Bug 24108 - Add system preference DefaultSaveRecordFileID
1560
Upgrade to 20.12.00.014  [12:52:01]: Bug  7806 - Remove remaining possible 0000-00-00 values
1561
Upgrade to 20.12.00.015  [12:52:01]: Bug 27316 - In Elastisearch mappings convert NULL (Undef) for sort to 1 (Yes)
1562
Upgrade to 20.12.00.016  [12:52:01]: Bug  8976 - Allow setting a default sequence of subfields in cataloguing editor
1563
Upgrade to 20.12.00.017  [12:52:01]: Bug 26937 - Add CheckPrevCheckoutDelay system preference)
1564
Upgrade to 20.12.00.018  [12:52:01]: Bug 27808 - Adjust items.onloan if needed
1565
Upgrade to 20.12.00.019  [12:52:01]: Bug 26057 - Add datecancelled field to branchtransfers
1566
Upgrade to 20.12.00.020  [12:52:01]: Bug 24446 - Update stockrotation 'daterequested' field in transfers table
1567
Upgrade to 20.12.00.021  [12:52:01]: Bug 22824 - Update syspref values for YesNo
1568
Upgrade to 20.12.00.022  [12:52:01]: Bug 12224 - Add CHECKINSLIP notice
1569
Upgrade to 20.12.00.023  [12:52:01]: Bug 27652 - Separate values for OPACHoldsIfAvailableAtPickupExceptions and BatchCheckoutsValidCategories with comma
1570
Upgrade to 20.12.00.024  [12:52:01]: Bug 18532 - Messaging preferences for auto renewals
1571
Upgrade to 20.12.00.025  [12:52:01]: Bug 27835 - Add new system preference ChargeFinesOnClosedDays
1572
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
1573
Upgrade to 20.12.00.027  [12:52:01]: Bug 27069 - Change holdallowed values from numbers to strings
1574
Upgrade to 20.12.00.028  [12:52:01]: Bug 14233 - Add id field to letter table
1575
Upgrade to 20.12.00.029  [12:52:01]: Bug 27726 - Increase field size for problem_reports.content
1576
Upgrade to 20.12.00.030  [12:52:01]: Bug 21549 - Add new system preference LockExpiredDelay
1577
Upgrade to 20.12.00.031  [12:52:01]: Bug 21260 - Add new system preference Reference_NFL_Statuses
1578
Upgrade to 20.12.00.032  [12:52:01]: Bug 15986 - Add sample HOLD_REMINDER notice
1579
Upgrade to 20.12.00.033  [12:52:01]: Bug 26940 - Put in sync borrowers.debarredcomment with comments from borrower_debarments
1580
Upgrade to 20.12.00.034  [12:52:01]: Bug 20854 - Add new system preference casServerVersion
1581
Upgrade to 20.12.00.035  [12:52:01]: Bug 23207 - Add automatic_checkin to itemtypes table
1582
Upgrade to 20.12.00.036  [12:52:01]: Bug 16787 - Add noReservesAllowed to club holds error codes
1583
Upgrade to 20.12.00.037  [12:52:01]: Bug 23971 - Add new system preference AcquisitionLog
1584
Upgrade to 20.12.00.038  [12:52:01]: Bug 27281 - Add 'ItemLost' to branchtransfers.cancellation_reason enum
1585
Upgrade to 20.12.00.039  [12:52:01]: Bug 12362 - Add 'TransferCancellation' to branchtransfers.reason enum
1586
Upgrade to 20.12.00.040  [12:52:01]: Bug 27971 - Add VOID debit type code
1587
Upgrade to 20.12.00.041  [12:52:01]: Bug 26734 - Update notices to use defaults
1588
Upgrade to 20.12.00.042  [12:52:01]: Bug 17202 - Add FK constraint for collection to collections_tracking
1589
Upgrade to 20.12.00.043  [12:52:01]: Bug 28258 - Update AUTO_RENEWAL content
1590
Upgrade to 20.12.00.044  [12:52:01]: Bug 28244 - Fix Ukrainian typo in English
1591
Upgrade to 20.12.00.045  [12:52:01]: Bug 21249 - Adding new system preference SearchLimitLibrary
1592
Upgrade to 20.12.00.046  [12:52:01]: Bug 14723 - Additional delivery notes to messages
1593
Upgrade to 20.12.00.047  [12:52:01]: Bug 23215 - Remove core PayPal support in favor of the use of plugins
1594
Upgrade to 20.12.00.048  [12:52:01]: Bug 26995 - [SKIP] Drop column relationship from borrower tables [not executed]
1595
Upgrade to 20.12.00.049  [12:52:01]: Bug 28108 - Move action logs 'SERIAL CLAIM' and 'ACQUISITION CLAIM' to a new 'CLAIMS' module
1596
Upgrade to 20.12.00.050  [12:52:01]: Bug 28108 - Add new systempreference OpacHiddenItemsHidesRecord
1597
Upgrade to 21.05.00.000  [12:52:01]: Koha 21.05.00 release
1598
Use of uninitialized value $biblio_adds_authorities in string eq at /kohadevbox/koha/installer/data/mysql/db_revs/220600047.pl line 11.
1599
Upgrade to 21.06.00.000  [12:52:01]: Increase DBRev for 21.06
1600
	🎵 Run, rabbit run. 🎶
1601
	Dig that hole, forget the sun,
1602
	And when at last the work is done
1603
	Don't sit down it's time to dig another one.
1604
Upgrade to 21.06.00.001  [12:52:01]: Bug 28489 - Modify sessions.a_session from longtext to longblob
1605
Upgrade to 21.06.00.002  [12:52:01]: Bug 28490 - Bring back accidentally deleted relationship columns
1606
Upgrade to 21.06.00.003  [12:52:01]: Bug 24434 - Add 'WrongTransfer' to branchtransfers.cancellation_reason enum
1607
Upgrade to 21.06.00.004  [12:52:01]: Bug 15788 - Split edit_borrowers permission
1608
Upgrade to 21.06.00.005  [12:52:01]: Bug 26205 - Add new system preference NewsLog to log news changes
1609
Upgrade to 21.06.00.006  [12:52:01]: Bug 14237 - Add individual bibliographic records to course reserves
1610
	Add course_items.biblionumber column
1611
	Add fk_course_items_biblionumber constraint
1612
	Change course_items.itemnumber to allow NULL values
1613
Upgrade to 21.06.00.007  [12:52:01]: Bug 11879 - Add a new field to patron record: main contact method
1614
Upgrade to 21.06.00.008  [12:52:01]: Bug 20310 - Add new system preference ArticleRequestsOpacHostRedirection
1615
Upgrade to 21.06.00.009  [12:52:01]: Bug 20472 - Add columns format and urls in article_requests table
1616
Upgrade to 21.06.00.010  [12:52:01]: Bug 20472 - Add new system preference ArticleRequestsSupportedFormats
1617
Upgrade to 21.06.00.011  [12:52:01]: Bug 28567 - Set to NULL empty branches fields
1618
Upgrade to 21.06.00.012  [12:52:01]: Bug 15067 - Add missing languages
1619
Upgrade to 21.06.00.013  [12:52:01]: Bug 22435 - Update existing offsets
1620
Upgrade to 21.06.00.014  [12:52:01]: Bug 28813 - Update delivery_note to failure_code in message_queue
1621
Upgrade to 21.06.00.015  [12:52:01]: Bug 12561 - Remove system preferences HighlightOwnItemsOnOPAC and HighlightOwnItemsOnOPACWhich
1622
Upgrade to 21.06.00.016  [12:52:02]: Bug 24387 - Rename opac_news with additional_contents
1623
Upgrade to 21.06.00.017  [12:52:02]: Bug 28872 - Update syspref values from on and off to 1 and 0
1624
Upgrade to 21.06.00.018  [12:52:02]: Bug 22690 - Add contraints to the linktracker table
1625
Upgrade to 21.06.00.019  [12:52:02]: Bug 26302 - Add system preferences OPACResultsMaxItems and OPACResultsMaxItemsUnavailable
1626
Upgrade to 21.06.00.020  [12:52:02]: Bug 28373 - Add new system preference PassItemMarcToXSLT
1627
	NOTE: You have defined a custom stylesheet for 'XSLTListsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT'
1628
	NOTE: You have defined a custom stylesheet for 'OPACXSLTDetailsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT'
1629
	NOTE: You have defined a custom stylesheet for 'OPACXSLTListsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT'
1630
	NOTE: You have defined a custom stylesheet for 'OPACXSLTResultsDisplay'. If it is utilizing item fields you must enable the system preference 'PassItemMarcToXSLT'
1631
Upgrade to 21.06.00.021  [12:52:02]: Bug 28774 - Delete blank rental discounts
1632
Upgrade to 21.06.00.022  [12:52:02]: Bug 28972 - Add missing foreign key constraints to holds queue table
1633
Upgrade to 21.06.00.023  [12:52:02]: Bug 28534 - Set pending_offline_operations INNoDB rather than MyISAM
1634
Upgrade to 21.06.00.024  [12:52:02]: Bug 29073 - Make DefaultHoldExpirationdate use 1/0 values
1635
Upgrade to 21.06.00.025  [12:52:02]: Bug 28826 - A system preference FacetOrder
1636
Upgrade to 21.06.00.026  [12:52:02]: Bug 28772 - Store hashed API key secrets
1637
Upgrade to 21.06.00.027  [12:52:02]: Bug 29137 - Add system preference CreateAVFromCataloguing
1638
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
1639
Upgrade to 21.06.00.029  [12:52:02]: Bug 27947 - Add authorised values list in article requests cancellation
1640
	Add AR_CANCELLATION category for authorised values
1641
	Add AR_CANCELLATION authorised values
1642
	Add cancellation_reason column in article_requests table
1643
	Replace notes by reason in notice AR_CANCELED
1644
Upgrade to 21.06.00.030  [12:52:02]: Bug 25429 - Add new system preference CleanUpDatabaseReturnClaims
1645
Upgrade to 21.06.00.031  [12:52:02]: Bug 18984 - Remove NORMARC from search_marc_map.marc_type
1646
Upgrade to 21.06.00.032  [12:52:02]: Bug 29138 - Use a zero instead of a 'no' in LoadSearchHistoryToTheFirstLoggedUser
1647
Upgrade to 21.06.00.033  [12:52:02]: Bug 29093 - Add column article_requests.toc_request
1648
Upgrade to 21.06.00.034  [12:52:02]: Bug 28831 - Add system preferences OPACResultsUnavailableGroupingBy
1649
Upgrade to 21.06.00.035  [12:52:02]: Bug 28153 - Add Hold Reminder messaging preference
1650
	Message attribute added
1651
	HOLD_REMINDER added to message_transports
1652
	Hold_Filled message preference copied to Hold_Reminder
1653
	Hold_Filled message transport preferences copied to Hold_Reminder
1654
Upgrade to 21.06.00.036  [12:52:02]: Bug 29200 - Remove Adlibris cover service integration
1655
	AdlibrisCoversEnabled and AdlibrisCoversURL preferences removed.
1656
Upgrade to 21.06.00.037  [12:52:02]: Bug 11175 - Show component records in detail views
1657
Upgrade to 21.06.00.038  [12:52:02]: Bug 14957 - Add a way to define overlay rules for incoming MARC records
1658
	Added new table 'marc_overlay_rules'
1659
	Added new system preferences 'MARCOverlayRules'
1660
	Added new permissions 'manage_marc_overlay_rules'
1661
Upgrade to 21.06.00.039  [12:52:02]: Bug 28959 - virtualshelves.category is really a boolean
1662
Upgrade to 21.06.00.040  [12:52:02]: Bug 28263 - Update AUTO_RENEWAL too_many message
1663
Upgrade to 21.06.00.041  [12:52:02]: Bug 27360 - Make display of libraries configurable
1664
Upgrade to 21.06.00.042  [12:52:02]: Bug 26326 - Add primary key to import_record_matches
1665
Upgrade to 21.06.00.043  [12:52:02]: Bug 29386 - Extend background_jobs.data to LONGTEXT
1666
Upgrade to 21.06.00.044  [12:52:02]: Bug 29180 - Rename system preference RequestOnOpac with OPACHoldRequests
1667
Upgrade to 21.06.00.045  [12:52:02]: Bug 24223 - Move contents of OpacNav system preference into additional contents
1668
	No OpacNav preference found. Update has already been run.
1669
Upgrade to 21.06.00.046  [12:52:02]: Bug 24224 - Move contents of OpacNavBottom system preference into additional contents
1670
	No OpacNavBottom preference found. Update has already been run.
1671
Upgrade to 21.06.00.047  [12:52:02]: Bug 28374 - Update point of sale print receipt
1672
	Added KohaDates, Branches and Price plugins
1673
	Replaced 'payment' with 'credit' param in RECEIPT template
1674
	Replaced 'offsets' with 'credit.debits' param in RECEIPT template
1675
	Replaced 'offset' with 'debit' param in RECEIPT template
1676
	Replaced 'debit.debit' with 'debit' param in RECEIPT template
1677
Upgrade to 21.06.00.048  [12:52:02]: Bug 29341 - Remove foreign keys on pseudonymized_transactions
1678
Upgrade to 21.06.00.049  [12:52:02]: Bug  5229 - Remove system preference 'OPACItemsResultsDisplay'
1679
Upgrade to 21.11.00.000  [12:52:02]: Koha 21.11.00 release
1680
Upgrade to 21.12.00.000  [12:52:02]: Increase DBRev for 21.12
1681
	📜 All that is gold does not glitter,
1682
	📜 Not all those who wander are lost;
1683
	📜 The old that is strong does not wither,
1684
	📜 Deep roots are not reached by the frost.
1685
Upgrade to 21.12.00.001  [12:52:02]: Bug 29586 - Add Hold Reminder messaging preference if missing
1686
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
1687
	Added new system preference 'PatronSelfModificationMandatoryField' with value 'surname|firstname'
1688
Upgrade to 21.12.00.003  [12:52:02]: Bug 29457 - Fee Cancellation records the wrong manager_id
1689
	WARNING: You may have some incorrect manager_id's recorded against account cancellation lines, please see bugzilla for details.
1690
	NOTE: You may already have this bugfix applied at an earlier upgrade.
1691
Upgrade to 21.12.00.004  [12:52:02]: Bug 26296 - Replace comma with pipe in OPACSuggestion field preferences
1692
Upgrade to 21.12.00.005  [12:52:02]: Bug 29778 - Delete orphan additional contents
1693
Upgrade to 21.12.00.006  [12:52:02]: Bug 29557 - Add auto_account_expired to AUTO_RENEWALS notice
1694
	Please update your AUTO_RENEWALS notice manually if you have changed or translated it
1695
Upgrade to 21.12.00.007  [12:52:02]: Bug 20076 - Add system preference EmailOverduesNoEmail
1696
Upgrade to 21.12.00.008  [12:52:02]: Bug 29495 - Drop issue_id constraint from return_claims table
1697
Upgrade to 21.12.00.009  [12:52:02]: Bug 29336 - Resize authorised value category fields to 32 chars
1698
Upgrade to 21.12.00.010  [12:52:02]: Bug 21729 - Add new column reserves.patron_expiration_date
1699
Upgrade to 21.12.00.011  [12:52:02]: Bug 27946 - Add article request fees
1700
Upgrade to 21.12.00.012  [12:52:02]: Bug 24220 - Move OpacMoreSearches to additional contents
1701
	No OpacMoreSearches preference found. Value was empty or update has already been run.
1702
Upgrade to 21.12.00.013  [12:52:03]: Bug 29605 - Resync DB structure for existing installations
1703
	Added missing primary key on language_script_mapping
1704
	Ensure NOT NULL on account_offsets.type
1705
	Ensure additional_contents.code is VARCHAR(100)
1706
	Ensure additional_contents.lang is VARCHAR(50)
1707
	Ensure NOT NULL on search_marc_map.marc_type
1708
	Ensure branchtransfers.cancellation_reason enum values are uppercase
1709
Upgrade to 21.12.00.014  [12:52:03]: Bug 29596 - Add Yiddish language
1710
Upgrade to 21.12.00.015  [12:52:03]: Bug 29943 - Fix typo in NOTIFY_MANAGER notice
1711
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
1712
	Removed any duplicate rows
1713
	Added a primary key on user_permissions on borrowernumber, module_bit, code
1714
Upgrade to 21.12.00.017  [12:52:03]: Bug 30128 - Change language_subtag_registry.description to varchar(255)
1715
Upgrade to 21.12.00.018  [12:52:03]: Bug 19532 - Add Recalls
1716
Upgrade to 21.12.00.019  [12:52:03]: Bug 27812 - Remove the ability to transmit a patron's plain text password over email
1717
	The notice template ACCTDETAILS no longer has access to the patron's plain text password. Please update the language of your ACCTDETAILS as needed.
1718
Upgrade to 21.12.00.020  [12:52:03]: Bug 24221 - Move OpacMySummaryNote to additional contents
1719
	No OpacMySummaryNote preference found. Value was empty or update has already been run.
1720
Upgrade to 21.12.00.021  [12:52:03]: Bug 30063 - Fix DefaultPatronSearchFields order
1721
Upgrade to 21.12.00.022  [12:52:03]: Bug 11083 - Add syspref AuthorityXSLTResultsDisplay
1722
Upgrade to 21.12.00.023  [12:52:03]: Bug 20517 - Add SIP2SortBinMapping system preference
1723
Upgrade to 21.12.00.024  [12:52:03]: Bug 20398 - Add system preference StaffHighlightedWords
1724
Upgrade to 21.12.00.025  [12:52:03]: Bug 29990 - Add new system preference ShowHeadingUse
1725
Upgrade to 21.12.00.026  [12:52:03]: Bug 17018 - Split AdvancedSearchTypes for staff and OPAC
1726
Upgrade to 21.12.00.027  [12:52:03]: Bug 26346 - Add allow_change_from_staff to virtualshelves table
1727
Upgrade to 21.12.00.028  [12:52:03]: Bug 16258 - A preference to enabled/disable edifact
1728
Upgrade to 21.12.00.029  [12:52:03]: Bug 30130 - A standard to edi_account
1729
Upgrade to 21.12.00.030  [12:52:03]: Bug 30135 - Add EdifactLSQ mapping system preference
1730
Upgrade to 21.12.00.031  [12:52:03]: Bug 30481 - DB schema sync for deleteditems
1731
Upgrade to 21.12.00.032  [12:52:03]: Bug 30498 - Correct enum search_field.type
1732
Upgrade to 21.12.00.033  [12:52:03]: Bug 27783 - Add background_jobs.queue
1733
	Added background_jobs.queue
1734
Upgrade to 21.12.00.034  [12:52:03]: Bug 30237 - Replace ACCDETAILS notice with WELCOME notice
1735
Upgrade to 21.12.00.035  [12:52:03]: Bug 30226 - Add the system preference AllowSetAutomaticRenewal
1736
Upgrade to 21.12.00.036  [12:52:03]: Bug 28786 - Add syspref TwoFactorAuthentication, fields secret and auth_method
1737
Upgrade to 21.12.00.037  [12:52:03]: Bug 27253 - Fix definition of borrowers.updated_on and deletedborrowers.updated_on
1738
	Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated
1739
	Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated
1740
	Fixed definition of borrowers.updated_on
1741
	Fixed definition of deletedborrowers.updated_on
1742
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
1743
	NumSavedReports value '20' moved to table settings
1744
Upgrade to 21.12.00.039  [12:52:03]: Bug 29092 - Add timestamp to account-fines table column settings
1745
Upgrade to 21.12.00.040  [12:52:03]: Bug 30565 - Update table stockrotationrotas
1746
Upgrade to 21.12.00.041  [12:52:03]: Bug 30449 - Check borrower_attribute_types FK constraint
1747
Upgrade to 21.12.00.042  [12:52:03]: Bug 30572 - Adjust search_marc_to_field.sort
1748
Upgrade to 21.12.00.043  [12:52:03]: Bug 30108 - Add preference OPACMandatoryHoldDates
1749
Upgrade to 21.12.00.044  [12:52:03]: Bug 29894 - Add 2FA (de)enabling notices
1750
Upgrade to 21.12.00.045  [12:52:03]: Bug 14242 - Add OPACSuggestionAutoFill system preference
1751
Upgrade to 21.12.00.046  [12:52:03]: Bug 22785 - Add chosen column to import_record_matches
1752
	chosen column added to import_record_matches
1753
Upgrade to 21.12.00.047  [12:52:03]: Bug 28138 - Add system preference RequirePaymentType
1754
Upgrade to 21.12.00.048  [12:52:03]: Bug 30291 - Renaming recalls table columns
1755
Upgrade to 21.12.00.049  [12:52:03]: Bug 30563 - Add system preference RequireCashRegister
1756
Upgrade to 21.12.00.050  [12:52:03]: Bug 29924 - Add password expiration
1757
	Added password_expiry_days to categories
1758
	Added password_expiration_date field to borrowers
1759
	Added password_expiration_date field to borrowers
1760
Upgrade to 21.12.00.051  [12:52:03]: Bug 29925 - Add password reset option
1761
Upgrade to 21.12.00.052  [12:52:03]: Bug 30290 - Modify AR notices, include TOC line
1762
Upgrade to 21.12.00.053  [12:52:03]: Bug 30611 - Add STAFF_PASSWORD_RESET notice
1763
Upgrade to 21.12.00.054  [12:52:03]: Bug 23352 - Adding new column 'subscription.ccode'
1764
Upgrade to 21.12.00.055  [12:52:03]: Bug 13412 - Add GenerateAuthorityField667 and GenerateAuthorityField670 system preferences
1765
Upgrade to 21.12.00.056  [12:52:03]: Bug 30728 - Allow opting out of real-time holds queue updating possible
1766
Upgrade to 21.12.00.057  [12:52:03]: Bug 30852 - Add index to article_requests.debit_id
1767
Upgrade to 22.05.00.000  [12:52:03]: Koha 22.05.00 release
1768
Upgrade to 22.06.00.000  [12:52:03]: Increase DBRev for 22.06
1769
	📜 The road of excess
1770
	📜 leads to the palace of wisdom;
1771
	📜 for we never know what is enough
1772
	📜 until we know what is more than enough.
1773
Upgrade to 22.06.00.001  [12:52:03]: Bug 23659 - Add DefaultHoldPickupLocation syspref
1774
	Added DefaultHoldPickupLocation syspref
1775
Upgrade to 22.06.00.002  [12:52:03]: Bug 30850 - Message about mappings changes for 110$a
1776
	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.
1777
Upgrade to 22.06.00.003  [12:52:03]: Bug 30924 - Add missing RecallCancellation option to branchtransfers.reason ENUM
1778
Upgrade to 22.06.00.004  [12:52:03]: Bug 12446 - Ability to allow guarantor relationship for all patron category types
1779
Upgrade to 22.06.00.005  [12:52:03]: Bug 24239 - Add due_date to illrequests
1780
Upgrade to 22.06.00.006  [12:52:03]: Bug 21978 - Add middle_name to borrowers table
1781
	Added middle name column to borrowers table
1782
	Added middle name column to deletedborrowers table
1783
	Added middle name column to borrower_modifications table
1784
	Added middle name to DefaultPatronSearchFields
1785
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
1786
Upgrade to 22.06.00.008  [12:52:03]: Bug 30327 - Add ComponentSortField and ComponentSortOrder sysprefs
1787
	Added ComponentSortField and ComponentSortOrder sysprefs
1788
Upgrade to 22.06.00.009  [12:52:03]: Bug 30889 - Add calling context information to background_jobs
1789
Upgrade to 22.06.00.010  [12:52:03]: Bug 30823 - Replace recalls FULFILL actions with FILL in action logs
1790
Upgrade to 22.06.00.011  [12:52:04]: Bug 30275 - Add a checkout_renewals table
1791
	Added new table 'checkout_renewals'
1792
	Renamed `issues.renewals` to `issues.renewals_count`
1793
	Renamed `old_issues.renewals` to `old_issues.renewals_count`
1794
Upgrade to 22.06.00.012  [12:52:04]: Bug 24010 - Make subscription.staffdisplaycount and opacdisplaycount integer columns
1795
Upgrade to 22.06.00.013  [12:52:04]: Bug 24865 - Customize the Accountlines Description
1796
Upgrade to 22.06.00.014  [12:52:04]: Bug 24857 - Add ability to group items on a record
1797
Upgrade to 22.06.00.015  [12:52:04]: Bug 28854 - Item bundles support
1798
	item_bundles table added
1799
	Missing from bundle LOST AV added
1800
	Added to bundle NOT_LOAN AV added
1801
	System preferences added and set
1802
	Dropped unique constraint on issue_id in return_claims
1803
Upgrade to 22.06.00.016  [12:52:04]: Bug 28854 - Add new unique index to return claims
1804
	item_issue index added to return_claims
1805
Upgrade to 22.06.00.017  [12:52:04]: Bug 29632 - Add callnumber type to allow sorting
1806
	Add callnumber to search_field type enum
1807
Upgrade to 22.06.00.018  [12:52:04]: Bug 11889 - Add pref ListOwnershipUponPatronDeletion
1808
Upgrade to 22.06.00.019  [12:52:04]: Bug 30933 - Add pref ListOwnerDesignated
1809
Upgrade to 22.06.00.020  [12:52:04]: Bug 31086 - Do not allow null values in branchcodes for reserves
1810
	Removed NULL option from branchcode for reserves
1811
Upgrade to 22.06.00.021  [12:52:04]: Bug 31157 - Add OverdueNoticeFrom preference
1812
Upgrade to 22.06.00.022  [12:52:04]: Bug 30650 - Curbside pickup tables
1813
Upgrade to 22.06.00.023  [12:52:04]: Bug 22456 - Allow cancelling waiting holds
1814
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
1815
	Add default values for blank circulation rules that weren't saved to the database
1816
Upgrade to 22.06.00.025  [12:52:04]: Bug 14364 - Allow automatically canceled expired waiting holds to fill the next hold
1817
	Added ExpireReservesAutoFill system preferences
1818
	Added HOLD_CHANGED notice
1819
Upgrade to 22.06.00.026  [12:52:04]: Bug 30984 - Log the cron script that generated an action log if there is one
1820
Upgrade to 22.06.00.027  [12:52:04]: Bug 28269 - Add new system preference SearchWithISSNVariations
1821
Upgrade to 22.06.00.028  [12:52:04]: Bug 30077 - Add new system preference IntranetAddMastheadLibraryPulldown
1822
Upgrade to 22.06.00.029  [12:52:04]: Bug 30392 - Add deleteditems.deleted_on
1823
Upgrade to 22.06.00.030  [12:52:04]: Bug 31274 - OPACSuggestionAutoFill must be 1 or 0
1824
Upgrade to 22.06.00.031  [12:52:04]: Bug 30327 - Add biblionumber to ComponentSortField
1825
	Added biblionumber option to ComponentSortField
1826
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
1827
	Added new system preference 'OPACInTransitHoldPickupLocationChange'
1828
Upgrade to 22.06.00.033  [12:52:04]: Bug 27779 - Simplify credit descriptions
1829
Upgrade to 22.06.00.034  [12:52:04]: Bug 29897 - Add new system preference OPACAuthorIdentifiers
1830
Upgrade to 22.06.00.035  [12:52:04]: Bug 28787 - Add new letter 2FA_OTP_TOKEN
1831
Upgrade to 22.06.00.036  [12:52:04]: Bug 31017 - Add type option to vendors
1832
	Added type column to aqbooksellers
1833
	Added VENDOR_TYPE authorised value category
1834
Upgrade to 22.06.00.037  [12:52:04]: Bug 23681 - Add customisable patron restriction types
1835
	Added restriction_types table
1836
	Added system restriction_types
1837
	Added borrower_debarments relation
1838
	Added manage_patron_restrictions permission
1839
	Added PatronRestrictionTypes preference
1840
Upgrade to 22.06.00.038  [12:52:04]: Bug 30335 - Add manual_invoice and manual_credit permissions
1841
Upgrade to 22.06.00.039  [12:52:04]: Bug 31374 - Add a non-public note column to the suggestions table
1842
	Add staff_note column to suggestions table
1843
Upgrade to 22.06.00.040  [12:52:04]: Bug 30619 - Add email notice for Point of Sale > RECEIPT
1844
Upgrade to 22.06.00.041  [12:52:04]: Bug 30483 - Make issues.borrowernumber and issues.itemnumber NOT NULL
1845
Upgrade to 22.06.00.042  [12:52:04]: Bug 27981 - Make it possible to force 001 = biblionumber
1846
	Added system preference autoControlNumber
1847
Upgrade to 22.06.00.043  [12:52:04]: Bug 20058 - Option to use shelving location instead of homebranch for sorting
1848
	Syspref UseLocationAsAQInSIP has been added
1849
Upgrade to 22.06.00.044  [12:52:04]: Bug 26247 - Add new retain search terms preferences
1850
	Added `RetainCatalogSearchTerms` preference
1851
	Added `RetainPatronsSearchTerms` preference
1852
Upgrade to 22.06.00.045  [12:52:04]: Bug 29144 - Copy and remove branches.opac_info
1853
Upgrade to 22.06.00.046  [12:52:04]: Bug 15348 - Add new column aqorders.estimated_delivery_date
1854
Upgrade to 22.06.00.047  [12:52:04]: Bug 30025 - Split and rename BiblioAddsAuthorities system preference
1855
	Added RequireChoosingExistingAuthority and AutoLinkBiblios
1856
	BiblioAddsAuthorities removed
1857
Upgrade to 22.06.00.048  [12:52:04]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL
1858
Upgrade to 22.06.00.049  [12:52:04]: Bug 30490 - Adjust FK constraint for parent item type
1859
Upgrade to 22.06.00.050  [12:52:04]: Bug 30497 - Recreate old_reserves_ibfk_4 if cascading
1860
Upgrade to 22.06.00.051  [12:52:04]: Bug  7021 - Add patron category to the statistics table
1861
Upgrade to 22.06.00.052  [12:52:04]: Bug 25735 - Add Elasticsearch field 'available'
1862
Upgrade to 22.06.00.053  [12:52:04]: Bug 30484 - Add a notice template for ILL Update notices
1863
	Bug 30484 DB update complete
1864
Upgrade to 22.06.00.054  [12:52:04]: Bug 23538 - Add new system preferences EmailPatronRegistrations and EmailAddressForPatronRegistrations and new OPAC_REG letter
1865
Upgrade to 22.06.00.055  [12:52:04]: Bug 26368 - Add OCLC Encoding Levels system preference
1866
	Added UseOCLCEncodingLevels system preference
1867
Upgrade to 22.06.00.056  [12:52:04]: Bug 30571 - Table z3950servers: three cols NOT NULL
1868
Upgrade to 22.06.00.057  [12:52:04]: Bug 29071 - Set HoldsQueueSplitNumbering where not set
1869
	Added HoldsSplitQueueNumbering if not already there
1870
Upgrade to 22.06.00.058  [12:52:05]: Bug 30944 - Replace branchtransfers.cancellation_reason CancelRecall with RecallCancellation
1871
Upgrade to 22.06.00.059  [12:52:05]: Bug 25936 - A password change notification feature
1872
Upgrade to 22.06.00.060  [12:52:05]: Bug 10950 - Add pronouns to borrowers table
1873
	Added pronouns column to borrowers table
1874
	Added pronouns column to deletedborrowers table
1875
	Added pronouns column to borrower_modifications table
1876
Upgrade to 22.06.00.061  [12:52:05]: Bug 31333 - Add new suggestionPatronCategoryExceptions system preference
1877
Upgrade to 22.06.00.062  [12:52:05]: Bug 27136 - Add missing languages: Cree, Afrikaans and Multiple languages, Undetermined and No linguistic content
1878
	Added missing languages
1879
Upgrade to 22.06.00.063  [12:52:05]: Bug 31569 - Add primary key for import_biblios
1880
	Added primary key to import_biblios table
1881
Upgrade to 22.06.00.064  [12:52:05]: Bug 14783 - Allow patrons to change pickup location for non-waiting holds
1882
	Added new system preference 'OPACAllowUserToChangeBranch'
1883
	Removed system preference 'OPACInTransitHoldPickupLocationChange'
1884
Upgrade to 22.06.00.065  [12:52:05]: Bug 25426 - Add new syspref CircControlReturnsBranch
1885
	Added new system preference 'CircControlReturnsBranch'
1886
Upgrade to 22.06.00.066  [12:52:05]: Bug 31626 - Add letter id to the message queue table
1887
	Added 'letter_id' column to 'message_queue' table
1888
Upgrade to 22.06.00.067  [12:52:05]: Bug 17170 - Add permission for creating saved search filters
1889
	Added manage_search_filters permission
1890
	Added search_filters table
1891
	Added SavedSearchFilters system preference
1892
Upgrade to 22.06.00.068  [12:52:05]: Bug 30588 - Add an 'enforce' option for TwoFactorAuthentication
1893
Upgrade to 22.06.00.069  [12:52:05]: Bug 31715 - Add missing German (de) language translations
1894
	German (de) translations were added
1895
Upgrade to 22.06.00.070  [12:52:05]: Bug 31577 - Add category list pull-down to OpacHiddenItemsExceptions
1896
	Settings for OpacHiddenItemsExceptions have been updated
1897
Upgrade to 22.06.00.071  [12:52:05]: Bug 23012 - Add PROCESSING_FOUND to account_credit_types
1898
Upgrade to 22.06.00.072  [12:52:05]: Bug 24381 - Update accounts notices
1899
Upgrade to 22.06.00.073  [12:52:05]: Bug 30036 - Add syspref AuthorityXSLTOpacResultsDisplay
1900
Upgrade to 22.06.00.074  [12:52:05]: Bug 30407 - Add ability to syspref UpdateNotForLoanStatusOnCheckin to show only the notforloan values message
1901
	Update is going well so far
1902
Upgrade to 22.06.00.075  [12:52:05]: Bug 31948 - Add timestamp to tmp_holdsqueue table
1903
Upgrade to 22.06.00.076  [12:52:05]: Bug 29792 - Add AutomaticConfirmTransfer system preference
1904
	AutomaticConfirmTransfer system preference added
1905
Upgrade to 22.06.00.077  [12:52:05]: Bug 31713 - Add ACCOUNTS_SUMMARY slip notice
1906
	Notice added
1907
Upgrade to 22.06.00.078  [12:52:05]: Bug 24860 - Add ability to place item group level holds
1908
	Added new system preference 'EnableItemGroupHolds'
1909
Upgrade to 22.06.00.079  [12:52:05]: Bug 32030 - Add an ERM module
1910
Upgrade to 22.06.00.080  [12:52:05]: Bug 30880 - Add branchonly option to OPACResultsUnavailableGroupingBy syspref
1911
Upgrade to 22.06.00.081  [12:52:05]: Bug 31378 - Add identity_provider and identity_provider_domains configuration tables
1912
	manage_identity_providers permission added
1913
Upgrade to 22.06.00.082  [12:52:05]: Bug 30250 - Add new system preference ApplyFrameworkDefaults
1914
	Added new system preference 'ApplyFrameworkDefaults'
1915
Upgrade to 22.06.00.083  [12:52:05]: Bug 24606 - Add new table item_editor_templates

Return to bug 30951