Upgrade to 3.01.00.000 done (start of 3.1)
DBD::mysql::db do failed: Table 'hold_fill_targets' already exists at installer/data/mysql/updatedatabase.pl line 1984.
DBD::mysql::db do failed: Duplicate column name 'item_level_request' at installer/data/mysql/updatedatabase.pl line 2003.
Upgrade to 3.01.00.001 done (add hold_fill_targets table and a column to tmp_holdsqueue)
Upgrade to 3.01.00.002 done (bug 2582: set null issues.issuedate to lastreneweddate)
DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 1 at installer/data/mysql/updatedatabase.pl line 2050.
Upgrade to 3.01.00.003 done (add new syspref)
Upgrade to 3.01.00.004 done (added OPACDisplayRequestPriority system preference)
DBD::mysql::db do failed: Duplicate entry '4' for key 1 at installer/data/mysql/updatedatabase.pl line 2068.
Upgrade to 3.01.00.005 done (Add letter for holds notifications)
DBD::mysql::db do failed: Duplicate key name 'issn' at installer/data/mysql/updatedatabase.pl line 2077.
Upgrade to 3.01.00.006 done (add index on biblioitems.issn)
Upgrade to 3.01.00.007 done (fix display of many sysprefs)
Upgrade to 3.01.00.008 done (added branch_transfer_limits table and UseBranchTransferLimits system preference)
DBD::mysql::db do failed: Duplicate entry '1-circulate_remaining_permissions' for key 1 at installer/data/mysql/updatedatabase.pl line 2132.
DBD::mysql::db do failed: Duplicate entry '1-override_renewals' for key 1 at installer/data/mysql/updatedatabase.pl line 2133.
Upgrade to 3.01.00.009 done (added subpermissions for circulate permission)
Upgrade to 3.01.00.010 done (bug 2687: increase length of borrower attribute fields)
Upgrade to 3.01.00.011 done (removed bogus intranetuserjs syspref)
DBD::mysql::db do failed: Table 'branch_item_rules' already exists at installer/data/mysql/updatedatabase.pl line 2167.
DBD::mysql::db do failed: Table 'default_branch_item_rules' already exists at installer/data/mysql/updatedatabase.pl line 2178.
DBD::mysql::db do failed: Duplicate column name 'holdallowed' at installer/data/mysql/updatedatabase.pl line 2186.
DBD::mysql::db do failed: Duplicate column name 'holdallowed' at installer/data/mysql/updatedatabase.pl line 2190.
Upgrade to 3.01.00.012 done (Add tables and system preferences for holds policies)
Upgrade to 3.01.00.013 done (data for Email Checkout Slips project)
Upgrade to 3.01.00.014 done ( Updated table for Branch Transfer Limits)
DBD::mysql::db do failed: Duplicate entry 'OPACAmazonCoverImages' for key 1 at installer/data/mysql/updatedatabase.pl line 2275.
DBD::mysql::db do failed: Duplicate entry 'AmazonCoverImages' for key 1 at installer/data/mysql/updatedatabase.pl line 2277.
Upgrade to 3.01.00.015 done (added Syndetics Enhanced Content system preferences)
Upgrade to 3.01.00.016 done (Added Babeltheque syspref)
Upgrade to 3.01.00.017 done ( Updated table for Serials Display)
Upgrade to 3.01.00.018 done (added deletedborrowers.smsalertnumber, missed in 3.00.00.091)
Upgrade to 3.01.00.019 done (adding OPACShowCheckoutName systempref)
Upgrade to 3.01.00.020 done (adding LibraryThing for Libraries sysprefs)
Upgrade to 3.01.00.021 done (adding OPACAmazonReviews syspref)
Upgrade to 3.01.00.022 done (bug 2945: increase size of labels_conf.formatstring)
Upgrade to 3.01.00.023 done (bug 2765: increase width of isbn column in several tables)
Upgrade to 3.01.00.024 done (change labels.batch_id from varchar to int)
Upgrade to 3.01.00.025 done (added ceilingDueDate system preference)
Upgrade to 3.01.00.026 done (added numReturnedItemsToShow system preference)
Upgrade to 3.01.00.027 done (Increased size of zebraqueue biblio_auth_number to address bug 3148.)
DBD::mysql::db do failed: Duplicate entry 'AmazonReviews' for key 1 at installer/data/mysql/updatedatabase.pl line 2392.
Upgrade to 3.01.00.028 done (added AmazonReviews)
Upgrade to 3.01.00.029 done (fixed bug 2599: using Spanish search limit retrieves Russian results)
DBD::mysql::db do failed: Duplicate entry 'AllowNotForLoanOverride' for key 1 at installer/data/mysql/updatedatabase.pl line 2410.
Upgrade to 3.01.00.030 done (added AllowNotForLoanOverride system preference)
Upgrade to 3.01.00.031 done (fix column widths in branch_transfer_limits)
DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 1 at installer/data/mysql/updatedatabase.pl line 2427.
Upgrade to 3.01.00.032 done (Change the field)
Upgrade to 3.01.00.033 done (DB changes to allow patron category defaults for messaging preferences)
Upgrade to 3.01.00.034 done (Adding graceperiod column to subscription table)
Upgrade to 3.01.00.035 done (Adding location to subscription table)
DBD::mysql::db do failed: Duplicate entry 'viewISBD' for key 1 at installer/data/mysql/updatedatabase.pl line 2470.
DBD::mysql::db do failed: Duplicate entry 'viewLabeledMARC' for key 1 at installer/data/mysql/updatedatabase.pl line 2471.
DBD::mysql::db do failed: Duplicate entry 'viewMARC' for key 1 at installer/data/mysql/updatedatabase.pl line 2472.
Upgrade to 3.01.00.036 done (new viewISBD, viewLabeledMARC, viewMARC sysprefs and tweak IntranetBiblioDefaultView)
Upgrade to 3.01.00.037 done (added FilterBeforeOverdueReport syspref and new index on authorised_values)
Upgrade to 3.01.00.038 done (add ZIP, city, country, URL, and notes column to branches)
Upgrade to 3.01.00.039 done (added SpineLabelFormat and SpineLabelAutoPrint sysprefs)
Upgrade to 3.01.00.040 done (AllowHoldDateInFuture and OPACAllowHoldDateInFuture sysprefs)
DBD::mysql::db do failed: Duplicate entry 'AWSPrivateKey' for key 1 at installer/data/mysql/updatedatabase.pl line 2516.
Upgrade to 3.01.00.041 done (added AWSPrivateKey syspref - note that if you use enhanced content from Amazon, this should be set right away.)
Upgrade to 3.01.00.042 done (added OPACFineNoRenewals syspref)
Upgrade to 3.01.00.043 done (amended Item added NewItemsDefaultLocation, InProcessingToShelvingCart, ReturnToShelvingCart sysprefs)
Upgrade to 3.01.00.044 done (added DisplayClearScreenButton system preference)
Upgrade to 3.01.00.045 done (added a preference to hide the patrons name in the staff catalog)Upgrade to 3.01.00.046 done (add country and B_country to borrowers)
Upgrade to 3.01.00.047 done (bug 2761: change max length of itemcallnumber to 255 from 30)
Upgrade to 3.01.00.048 done (bug 2611: fix spelling/capitalization in permission flag descriptions)
Upgrade to 3.01.00.049 done (bug 2611: changed catalogue to catalog per the standard)
Upgrade to 3.01.00.050 done (bug 1934: Add OPACSearchForTitleIn syspref)
Upgrade to 3.01.00.051 done (fixed typos in new sysprefs)
Upgrade to 3.01.00.052 done (bug 3481: add permanent_location column to deleteditems)
Upgrade to 3.01.00.053 done (Migrated labels tables and data to new schema.) NOTE: All existing label batches have been assigned to the first branch in the list of branches. This is ONLY true of migrated label batches.
Upgrade to 3.01.00.054 done (bug 1600, bug 3454: add altcontactcountry and B_address2 to borrowers and deletedborrowers)
Upgrade to 3.01.00.055 done (changed OPACSearchForTitleIn per requests in bug 1934)
Upgrade to 3.01.00.056 done (Bug 1172 : Add OPACPatronDetails syspref)
Upgrade to 3.01.00.057 done (Bug 2576 : Add OPACFinesTab syspref)
Upgrade to 3.01.00.058 done (Added primary keys to language tables)
Upgrade to 3.01.00.059 done (added DisplayOPACiconsXSLT sysprefs)
Upgrade to 3.01.00.060 done ( Added AllowAllMessageDeletion syspref and messages table )
Upgrade to 3.01.00.061 done ( Added ShowPatronImageInWebBasedSelfCheck system preference )
Upgrade to 3.01.00.062 done (added csv export profiles)
DBD::mysql::db do failed: Table 'fieldmapping' already exists at installer/data/mysql/updatedatabase.pl line 2710.
Upgrade to 3.01.00.065 done (Moving allowed renewals from itemtypes to issuingrule)
Upgrade to 3.01.00.066 done (Moving max allowed reserves from system preference to issuingrule)
Upgrade to 3.01.00.067 done (added permissions for batch modification and deletion)
DBD::mysql::db do failed: Duplicate column name 'finedays' at installer/data/mysql/updatedatabase.pl line 2767.
Upgrade done (Adding finedays in issuingrules table)
Upgrade done (added OPAC search history preference and table)
Upgrade done (Added a lib_opac field in authorised_values table)
Upgrade to 3.01.00.071 done ( Adding enddate to subscription)
Upgrade to 3.01.00.072 done (add new syspref and column in borrowers)
Upgrade to 3.01.00.073 done (adding aqcontract table)
Upgrade to 3.01.00.074 done (edit aqbasket table done)
Upgrade to 3.01.00.075 done (adding uncertainprices)
Upgrade to 3.01.00.076 done (adding basketgroups)
Upgrade to 3.01.00.077 done (Adding new aqbudgetperiods, aqbudgets and aqbudget_planning tables )
Upgrade to 3.01.00.078 done (adds 'budget_period_total' column to aqbudgetperiods table)
Upgrade to 3.01.00.079 done (adds 'active' column to currencies table)
Upgrade to 3.01.00.080 done (adds permissions for the acquisitions module)
Upgrade to 3.01.00.081 done (added per-supplier gstrate setting)
Upgrade to 3.01.00.082 done (adding ReservesNeedReturns systempref, in circulation)
Upgrade to 3.01.00.083 done (New aqorders_items table for acqui)
Upgrade to 3.01.00.084 done (CurrencyFormat syspref added)
Upgrade to 3.01.00.085 done update budget_id size that should not be a tinyint
Upgrade to 3.01.00.086 done SuggestionsUpgrade to 3.01.00.087 done drop column budget_amount_sublevel from aqbudgets
Upgrade to 3.01.00.088 done (intranetbookbag syspref added)
Upgrade to 3.01.00.090 done (granular permissions for guided reports added)
Upgrade to 3.01.00.091 done (opac-detail default tag updated)
Upgrade to 3.01.00.092 done (Added RoutingListAddReserves syspref)
Upgrade to 3.01.00.093 done (added index to ISSN)
Upgrade to 3.01.00.094 done (adding deliveryplace deliverycomment to basketgroups)
Upgrade to 3.01.00.095 done (stocknumber field added)
Upgrade to 3.01.00.096 done (PDF orders system preferences added and updated)
Upgrade to 3.01.00.097 done (Adding billingplace to aqbasketgroups)
Upgrade to 3.01.00.098 done (changing frameworkcode length in auth_subfield_structure)
Upgrade to 3.01.00.099 done (granular permissions for cataloging added)
Upgrade done (added CAS authentication system preferences)
Upgrade to 3.01.00.101 done (added OverdueNoticeBcc system preferences)
Upgrade done (fixed spelling error in edit_catalogue permission)
Upgrade done (adding patron permissions for tags tool)
Upgrade to 3.01.00.104 done ( add defaults to authorized values for MANUAL_INV and BOR_NOTES and add new default LOC authorized values for shelf to cart processing )
Upgrade to 3.01.00.105 done (added collection and collection_tracking tables for rotating collections functionality)
Upgrade done (added OpacAddMastheadLibraryPulldown system preferences)
Upgrade to 3.01.00.107 done (Migrated labels and patroncards tables and data to new schema.)
Upgrade done (added separators for csv export)
Upgrade done (added encoding for csv export)
Upgrade done (Add enrolment period date support)
Upgrade done (mark DBrev for 3.2-alpha release)
Upgrade done ( added Show Spine Label Printer on Bib Items Details preferences )
Upgrade done (added two new syspref: OPACXSLTResultsDisplay and OPACXSLTDetailDisplay). You may have to go in Admin > System preference to tweak XSLT related syspref both in OPAC and Search tabs.
Upgrade to 3.01.00.114 done ( Added AutoSelfCheckAllowed, AutoSelfCheckID, and AutoShelfCheckPass system preference )
Upgrade to 3.01.00.115 done ( Default aqorders.quantityreceived to 0 )
Upgrade done ( corrected default OrderPdfFormat value if still set wrong )
Upgrade to 3.01.00.117 done (corrected ISO 639-2 language code for Portuguese)
Upgrade to 3.01.00.118 done (bug 4203: add display column to aqbudgets_planning if missing)
Upgrade to 3.01.00.119 done (Locale::Currency::Format installed.)
Upgrade to 3.01.00.120 done (bug 1080: add soundon system preference for circulation sounds)
Upgrade to 3.01.00.121 done ( Added Additional Fields to Reserves tables )
Upgrade to 3.01.00.122 done. — Add a new system preference OAI-PMF:ConfFile
Upgrade to 3.01.00.123 done (Add granular permission for holds modification and update description of reserveforothers permission)
Upgrade to 3.01.00.124 done (bug 3242: add HOLDPLACED letter template, which is used when emailLibrarianWhenHoldIsPlaced is enabled)
Upgrade to 3.01.00.125 done (bug 3482: Printable hold and overdue notices)
Upgrade to 3.01.00.126 done (Adding ILS-DI updates and ILS-DI:AuthorizedIPs)
Upgrade to 3.01.00.127 done (bug 4190: messages in patron account did not work with branchcodes > 4)
Upgrade to 3.01.00.128 done (bug 4331: index orders by budget_id)
Upgrade done (Change permissions names for item batch modification / deletion)
Upgrade done (change reserves.expirationdate values of 0000-00-00 to NULL (bug 1532)Upgrade to 3.01.00.131 done (adding print and feed message transport types)
Upgrade to 3.01.00.132 done (Adding index to language_descriptions table)
Upgrade to 3.01.00.133 done (bug 4405: added OverduesBlockCirc syspref to control whether circulation is blocked if a borrower has overdues)
Upgrade to 3.01.00.134 done adding syspref DisplayMultiPlaceHold to control whether multiple holds can be placed from the search results pageUpgrade to 3.01.00.135 done (bug 4377: added HOLD_PRINT message template)Upgrade to 3.01.00.136 done Adding a new permission to edit itemsDBD::mysql::db do failed: Duplicate entry '15-check_expiration' for key 1 at installer/data/mysql/updatedatabase.pl line 3683.
Upgrade to 3.01.00.137 done (adding granular permissions for serials)Upgrade to 3.01.00.138 done (bug 4896: removing GranularPermissions syspref; use of granular permissions is now the default)Upgrade to 3.01.00.139 done (bug 3682: change message_name from varchar(20) to varchar(40))
Upgrade to 3.01.00.140 done (bug 4312 TagsModeration changed from NULL to 0)
Upgrade to 3.01.00.141 done Remove upcoming events messaging option (bug 2434)Upgrade to 3.01.00.142 done Remove upcoming events messaging option part 2 (bug 2434)Create index on authorised_values and borrower_attribute_types (bug 4139)Update the 'default' to 'normal' for the IntranetBiblioDefaultView syspref (bug 5007)Upgrade to 3.01.00.145 done (Add index on guarantorid)
Upgrade to 3.01.00.999 done (3.2.0 release candidate)
Upgrade to 3.02.00.000 done (Add HomeOrHoldingBranchReturn system preference)
Upgrade to 3.02.00.001 done (bug 3756: remove disused system preferences)
Upgrade to 3.02.00.002 done (bug 3881: remove unused OpacPrivacy system preference)
Upgrade to 3.02.00.003 done (correct ILS-DI:AuthorizedIPs)
Upgrade to 3.02.00.004 done (3.2.0 general release)
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha/#sql-755_1d`, CONSTRAINT `subscriptionroutinglist_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE) at installer/data/mysql/updatedatabase.pl line 3835.
Upgrade to 3.03.00.001 done (Make subscriptionroutinglist more strict)
Upgrade to 3.03.00.002 done (Correct language mappings)
Upgrade to 3.03.00.003 done (Add UseTablesortForCirc syspref)
Upgrade to 3.03.00.004 done (bug 5127: add default templates for suggestion status change notifications)
Upgrade to 3.03.00.005 done (Add itemBarcodeInputFilter choice libsuite8)
Upgrade to 3.03.00.006 done (Fix differences between borrowers and deletedborrowers)
Upgrade to 3.03.00.007 done (Added acq related columns to suggestions)
Upgrade to 3.03.00.008 done adding syspref OPACNoResultsFound to control what displays when no results are found for a search in the OPAC.Upgrade to 3.03.00.009 done (Add IntranetUserCSS syspref)
Upgrade to 3.03.00.010 done (Fix misspelled 034r subfield in MARC21 Frameworks)
Upgrade to 3.03.00.011 done (Bug 5186: allow GST rate to be set to 0)
DBD::mysql::db do failed: Duplicate entry 'maxItemsInSearchResults' for key 1 at installer/data/mysql/updatedatabase.pl line 3956.
Upgrade to 3.03.00.012 done (Bug 2142: maxItemsInSearchResults syspref resurrected)
Upgrade to 3.03.00.013 done (added 'OpacPublic' syspref)
Upgrade to 3.03.00.014 done (Add flexible shelf browser constraints)
Upgrade to 3.03.00.015 done (Bug 5619: Add subfield 9 to marc21 648,654,655,656,657,658,662)
DBD::mysql::db do failed: Duplicate column name 'privacy' at installer/data/mysql/updatedatabase.pl line 3998.
DBD::mysql::db do failed: Duplicate column name 'privacy' at installer/data/mysql/updatedatabase.pl line 3999.
Upgrade to 3.03.00.016 done (OpacPrivacy reimplementation)
Upgrade to 3.03.00.017 done (Enable currency rates >= 100)
Upgrade to 3.03.00.018 done (Correct language descriptions)
Upgrade to 3.03.00.019 done (Correct language descriptions for Norwegian)
Upgrade to 3.03.00.020 done (Bug 5811: Add sysprefs controlling overriding fines)
Upgrade to 3.03.00.021 done (bug 5642: longer serial enumeration)
Upgrade to 3.03.00.022 done (Add AuthoritiesLog syspref)
Upgrade to 3.03.00.023 done (Reconcile aqbasketgroups)
Upgrade to 3.03.00.024 done (Add syspref to force whole-subfield matching on subject tracings)
Upgrade to 3.03.00.025 done (Add syspref to control if user can choose pickup branch for holds)
Upgrade to 3.03.00.026 done ( fix capitalization in message type )
Upgrade to 3.03.00.027 done (Preferences for facet count)
Upgrade to 3.03.00.028 done (Add FacetLabelTruncationLength syspref to control facets displayed length)
Upgrade to 3.03.00.029 done (Add syspref to control if user can choose branch when making purchase suggestion)
Upgrade to 3.03.00.030 done (Add sysprefs to control custom favicons)
Upgrade to 3.03.00.031 done (Add syspref FineNotifyAtCheckin)
Upgrade to 3.03.00.032 done ( include subdivisions when generating subject tracing searches )
Upgrade to 3.03.00.033 done (System pref StaffAuthorisedValueImages)
Upgrade to 3.03.00.034 done (Add hidelostitems preference to borrower categories)
Upgrade to 3.03.00.035 done (Move global and ceiling due dates to Circ Rules level)
Upgrade to 3.03.00.036 done ( Make COinS optional in OPAC search results )
Upgrade to 3.03.00.037 done (Add 'Display856uAsImage' and 'OPACDisplay856uAsImage' syspref)
Upgrade to 3.03.00.038 done ( Add Self-checkout by Login system preferences )
Upgrade to 3.03.00.039 done (Add syspref ShowReviewer)
Upgrade to 3.03.00.040 done (Add syspref UseControlNumber)
Upgrade to 3.03.00.041 done (Add sysprefs to control alternate holdings information display)
Upgrade to 3.03.00.042 DATABASE UPGRADE LOGdone (Change items.stocknumber to be not unique)
Upgrade to 3.03.00.043 done ( add generic boolean YES_NO authorised_values pair )
Upgrade to 3.03.00.044 done (adding freedeliveryplace to basketgroups)
Upgrade to 3.03.00.045 DATABASE UPGRADE LOGdone (Remove obsolete columns from aqbooksellers and aqbudgets if needed)
Upgrade to 3.03.00.046 done (Setting NULL default value for delayn columns in table overduerules)
Upgrade to 3.03.00.047 done (Add state field to patron's addresses)
Upgrade to 3.03.00.048 done (Add state to branch address)
Upgrade to 3.03.00.049 done (adding note and manager_id fields in accountlines table)
Upgrade to 3.03.00.050 done (Adding OpacHiddenItems syspref)
Upgrade to 3.03.00.051 done (Remove spaces and dashes from message_attribute names)
Upgrade to 3.03.00.052 done (Add syspref WaitingNotifyAtCheckin)
Upgrade to 3.04.00.000 done Koha 3.4.0 release
Upgrade to 3.04.01.000 done (Incrementing version for 3.4.1 release. See release notes for details.)