Bugzilla – Attachment 168403 Details for
Bug 36424
Database update 23.06.00.061 breaks due to syntax error
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
apt upgrade output after changing version to 22.0500000
Koha-bug-36424-apt-upgrade-output_v2024-07-02.md (text/markdown), 35.48 KB, created by
Pablo AB
on 2024-07-02 20:40:52 UTC
(
hide
)
Description:
apt upgrade output after changing version to 22.0500000
Filename:
MIME Type:
Creator:
Pablo AB
Created:
2024-07-02 20:40:52 UTC
Size:
35.48 KB
patch
obsolete
>## Attempt to upgrade 22.05 â 23.11 @ 2024-07-02 > >1. apt update, upgrade, on 22.05 (22.0600040 on db) >2. koha-mysql $INSTANCE -e 'UPDATE systempreferences SET VALUE = '22.0500000' WHERE variable = "version"' >3. Set 23.11 on `koha.list` >4. apt update, upgrade; koha-common (23.11.06-2) over (22.05.22-1), stdout/err to txt (attached). > >### `apt upgrade`, last secton > >``` >Upgrading database schema for myinstance >Upgrade to 22.06.00.000 [17:13:49]: Increase DBRev for 22.06 > ð The road of excess > ð leads to the palace of wisdom; > ð for we never know what is enough > ð until we know what is more than enough. >Upgrade to 22.06.00.001 [17:13:49]: Bug 23659 - Allow hold pickup location to default to item home branch for item-level holds > Added new system preference 'DefaultHoldPickupLocation' >Upgrade to 22.06.00.002 [17:13:49]: Bug 30850 - Message about mappings changes for 110$a > 110$a was added as a default mapping for biblio.author in MARC21. This will only change the mapping on new installations. If you wish to change the mappings on your existing installation, go to Administration > Koha to MARC mapping and add 110$a to biblio.author and then run batchRebuilBiblioTables.pl. >Upgrade to 22.06.00.003 [17:13:49]: Bug 30924 - Add missing RecallCancellation option to branchtransfers.reason ENUM >Upgrade to 22.06.00.004 [17:13:50]: Bug 12446 - Ability to allow guarantor relationship for all patron category types > Added column 'categories.can_be_guarantee' >Upgrade to 22.06.00.005 [17:13:50]: Bug 24239 - Let the ILL module set ad hoc hard due dates > Added column 'illrequests.due_date' >Upgrade to 22.06.00.006 [17:13:51]: Bug 21978 - Add middle_name to borrowers table > Added column 'borrowers.middle_name' > Added column 'deletedborrowers.middle_name' > Added column 'borrower_modifications.middle_name' > Added middle name to DefaultPatronSearchFields >Upgrade to 22.06.00.007 [17:13:51]: Bug 29129 - Update the DisplayClearnScreenButton system pref to allow for a choice between ISSUESLIP and ISSUEQSLIP >Upgrade to 22.06.00.008 [17:13:51]: Bug 30327 - Sort component parts > Added new system preference 'ComponentSortField' > Added new system preference 'ComponentSortOrder' >Upgrade to 22.06.00.009 [17:13:51]: Bug 30889 - Add calling context information to background_jobs >Upgrade to 22.06.00.010 [17:13:51]: Bug 30823 - Replace recalls FULFILL actions with FILL in action logs >Upgrade to 22.06.00.011 [17:13:51]: Bug 30275 - Add a checkout_renewals table > Added new table 'checkout_renewals' > Renamed `issues.renewals` to `issues.renewals_count` > Renamed `old_issues.renewals` to `old_issues.renewals_count` >Upgrade to 22.06.00.012 [17:13:51]: Bug 24010 - Make subscription.staffdisplaycount and opacdisplaycount integer columns >Upgrade to 22.06.00.013 [17:13:51]: Bug 24865 - Customize the Accountlines Description > Added new letter 'OVERDUE_FINE_DESC' (print) >Upgrade to 22.06.00.014 [17:13:51]: Bug 24857 - Add ability to group items on a record > Added new system preference 'EnableItemGroups' > Added new permission 'manage_item_groups' > Added new table 'item_groups' > Added new table 'item_group_items' >Upgrade to 22.06.00.015 [17:13:51]: Bug 28854 - Item bundles support > Added new table 'item_bundles' > Missing from bundle LOST AV added > Added to bundle NOT_LOAN AV added > Added new system preference 'BundleLostValue' > Added new system preference 'BundleNotLoanValue' > Dropped unique constraint on issue_id in return_claims >Upgrade to 22.06.00.016 [17:13:51]: Bug 28854 - Add new 'item_issue' unique index to return claims >Upgrade to 22.06.00.017 [17:13:51]: Bug 29632 - Add callnumber type to allow sorting > Add callnumber to search_field type enum >Upgrade to 22.06.00.018 [17:13:51]: Bug 11889 - Add option to keep public or shared lists when deleting patron > Added new system preference 'ListOwnershipUponPatronDeletion' >Upgrade to 22.06.00.019 [17:13:51]: Bug 30933 - Add a designated owner for shared and public lists at patron deletion > Added new system preference 'ListOwnerDesignated' > Updated system preference 'ListOwnershipUponPatronDeletion' >Upgrade to 22.06.00.020 [17:13:52]: Bug 31086 - Do not allow NULL values in branchcodes for reserves > Removed NULL option from branchcode for reserves >Upgrade to 22.06.00.021 [17:13:52]: Bug 31157 - Make --frombranch option (overdue_notices.pl) available as a syspref > Added new system preference 'OverdueNoticeFrom' >Upgrade to 22.06.00.022 [17:13:52]: Bug 30650 - Add Curbside pickup feature > Added new table 'curbside_pickup_policy' > Added new table 'curbside_pickup_opening_slots' > Added new table 'curbside_pickups' > Added new table 'curbside_pickup_issues' > Added new letter 'NEW_CURBSIDE_PICKUP' (email) > Added new system preference 'CurbsidePickup' > Added new permission 'manage_curbside_pickups' (circulation) > Added new permission 'manage_curbside_pickups' (admin) > Added column 'curbside_pickup_policy.enable_waiting_holds_only' >Upgrade to 22.06.00.023 [17:13:52]: Bug 22456 - Allow cancelling waiting holds > Added new table 'hold_cancellation_requests' >Upgrade to 22.06.00.024 [17:13:52]: Bug 29012/33847 - Some rules are not saved when left blank while editing a 'rule' line in smart-rules.pl > Set derived values for blank circulation rules that weren't saved to the database >Upgrade to 22.06.00.025 [17:13:52]: Bug 14364 - Allow automatically canceled expired waiting holds to fill the next hold > Added new system preference 'ExpireReservesAutoFill' > Added new letter 'HOLD_CHANGED' (email) >Upgrade to 22.06.00.026 [17:13:52]: Bug 30984 - Log the cron script that generated an action log if there is one >Upgrade to 22.06.00.027 [17:13:52]: Bug 28269 - Make it possible to search orders with ISSN > Added new system preference 'SearchWithISSNVariations' >Upgrade to 22.06.00.028 [17:13:52]: Bug 30077 - Add option for library dropdown in search function for staff interface > Added new system preference 'IntranetAddMastheadLibraryPulldown' >Upgrade to 22.06.00.029 [17:14:00]: Bug 30392 - Add deleteditems.deleted_on >Upgrade to 22.06.00.030 [17:14:00]: Bug 31274 - OPACSuggestionAutoFill must be 1 or 0 > Updated system preference 'OPACSuggestionAutoFill' >Upgrade to 22.06.00.031 [17:14:00]: Bug 30327 - Add biblionumber to ComponentSortField > Added biblionumber option to ComponentSortField >Upgrade to 22.06.00.032 [17:14:00]: Bug 30500 - Add option to allow user to change the pickup location while a hold is in transit > Added new system preference 'OPACInTransitHoldPickupLocationChange' >Upgrade to 22.06.00.033 [17:14:00]: Bug 27779 - Simplify credit descriptions >Upgrade to 22.06.00.034 [17:14:00]: Bug 29897 - Display author identifiers for researchers > Added new system preference 'OPACAuthorIdentifiers' >Upgrade to 22.06.00.035 [17:14:00]: Bug 28787 - Send a notice with the TOTP token > Added new letter '2FA_OTP_TOKEN' (email) >Upgrade to 22.06.00.036 [17:14:01]: Bug 31017 - Add type option to vendors > Added column 'aqbooksellers.type' > Added VENDOR_TYPE authorised value category >Upgrade to 22.06.00.037 [17:14:01]: Bug 23681 - Add customisable patron restriction types > Added new table 'restriction_types' > Added system restriction_types > Added borrower_debarments relation > Added new permission 'manage_patron_restrictions' > Added new system preference 'PatronRestrictionTypes' >Upgrade to 22.06.00.038 [17:14:01]: Bug 30335 - Add manual_invoice and manual_credit permissions > Added new permission 'manual_credit' > Added new permission 'manual_invoice' >Upgrade to 22.06.00.039 [17:14:01]: Bug 31374 - Add a non-public note column to the suggestions table > Added column 'suggestions.staff_note' >Upgrade to 22.06.00.040 [17:14:01]: Bug 30619 - Add email notice for Point of Sale > RECEIPT > Added new letter 'RECEIPT' (email) >Upgrade to 22.06.00.041 [17:14:02]: Bug 30483 - Make issues.borrowernumber and issues.itemnumber NOT NULL >Upgrade to 22.06.00.042 [17:14:02]: Bug 27981 - Make it possible to force 001 = biblionumber > Added new system preference 'autoControlNumber' >Upgrade to 22.06.00.043 [17:14:02]: Bug 20058 - Option to use shelving location instead of homebranch for sorting > Added new system preference 'UseLocationAsAQInSIP' >Upgrade to 22.06.00.044 [17:14:02]: Bug 26247 - Add new retain search terms preferences > Added new system preference 'RetainCatalogSearchTerms' > Added new system preference 'RetainPatronsSearchTerms' >Upgrade to 22.06.00.045 [17:14:02]: Bug 29144 - Copy and remove branches.opac_info >Upgrade to 22.06.00.046 [17:14:02]: Bug 15348 - Add new column aqorders.estimated_delivery_date >Upgrade to 22.06.00.047 [17:14:02]: Bug 30025 - Split and rename BiblioAddsAuthorities system preference > Added new system preference 'RequireChoosingExistingAuthority' > Added new system preference 'AutoLinkBiblios' > Removed system preference 'BiblioAddsAuthorities' >Upgrade to 22.06.00.048 [17:14:02]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL >Upgrade to 22.06.00.049 [17:14:03]: Bug 30490 - Adjust FK constraint for parent item type >Upgrade to 22.06.00.050 [17:14:03]: Bug 30497 - Recreate old_reserves_ibfk_4 if cascading >Upgrade to 22.06.00.051 [17:14:03]: Bug 7021 - Add patron category to the statistics table > Added column 'statistics.categorycode' >Upgrade to 22.06.00.052 [17:14:03]: Bug 25735 - Add Elasticsearch field 'available' >Upgrade to 22.06.00.053 [17:14:03]: Bug 30484 - Add a notice template for ILL Update notices > Added new letter 'ILL_REQUEST_UPDATE' (email) > Added new letter 'ILL_REQUEST_UPDATE' (sms) >Upgrade to 22.06.00.054 [17:14:03]: Bug 23538 - Add new system preferences EmailPatronRegistrations and EmailAddressForPatronRegistrations and new OPAC_REG letter > Added new system preference 'EmailPatronRegistrations' > Added new letter 'OPAC_REG' (email) >Upgrade to 22.06.00.055 [17:14:03]: Bug 26368 - Add OCLC Encoding Levels system preference > Added new system preference 'UseOCLCEncodingLevels' >Upgrade to 22.06.00.056 [17:14:03]: Bug 30571 - Table z3950servers: three cols NOT NULL >Upgrade to 22.06.00.057 [17:14:03]: Bug 29071 - Set HoldsQueueSplitNumbering where not set > Added new system preference 'HoldsSplitQueueNumbering' >Upgrade to 22.06.00.058 [17:14:04]: Bug 30944 - Replace branchtransfers.cancellation_reason CancelRecall with RecallCancellation >Upgrade to 22.06.00.059 [17:14:04]: Bug 25936 - A password change notification feature > Added new letter 'PASSWORD_CHANGE' (email) > Added new system preference 'NotifyPasswordChange' >Upgrade to 22.06.00.060 [17:14:05]: Bug 10950 - Add preferred pronoun field to patron record > Added column 'borrowers.pronouns' > Added column 'deletedborrowers.pronouns' > Added column 'borrower_modifications.pronouns' >Upgrade to 22.06.00.061 [17:14:05]: Bug 31333 - Add the ability to limit purchase suggestions by patron category > Added new system preference 'suggestionPatronCategoryExceptions' >Upgrade to 22.06.00.062 [17:14:05]: Bug 27136 - Add missing languages: Cree, Afrikaans and Multiple languages, Undetermined and No linguistic content > Added missing languages >Upgrade to 22.06.00.063 [17:14:05]: Bug 31569 - Add primary key for import_biblios > Added primary key to import_biblios table >Upgrade to 22.06.00.064 [17:14:05]: Bug 14783 - Allow patrons to change pickup location for non-waiting holds > Added new system preference 'OPACAllowUserToChangeBranch' > Removed system preference 'OPACInTransitHoldPickupLocationChange' >Upgrade to 22.06.00.065 [17:14:05]: Bug 25426 - Add new syspref CircControlReturnsBranch > Added new system preference 'CircControlReturnsBranch' >Upgrade to 22.06.00.066 [17:14:05]: Bug 31626 - Add letter id to the message queue table > Added column 'message_queue.letter_id' >Upgrade to 22.06.00.067 [17:14:05]: Bug 17170 - Add saved search filters feature > Added new permission 'manage_search_filters' > Added new system preference 'SavedSearchFilters' >Upgrade to 22.06.00.068 [17:14:05]: Bug 30588 - Add an 'enforce' option for 'TwoFactorAuthentication' system preference > Updated system preference 'TwoFactorAuthentication' >Upgrade to 22.06.00.069 [17:14:05]: Bug 31715 - Add missing German (de) language translations > German (de) translations were added >Upgrade to 22.06.00.070 [17:14:05]: Bug 31577 - Add category list pull-down to OpacHiddenItemsExceptions > Updated system preference 'OpacHiddenItemsExceptions' >Upgrade to 22.06.00.071 [17:14:06]: Bug 23012 - Add PROCESSING_FOUND to account_credit_types >Upgrade to 22.06.00.072 [17:14:06]: Bug 24381 - Update accounts notices >Upgrade to 22.06.00.073 [17:14:06]: Bug 30036 - Add XSLT for authority results view in OPAC > Added new system preference 'AuthorityXSLTOpacResultsDisplay' >Upgrade to 22.06.00.074 [17:14:06]: Bug 30407 - Add ability to syspref UpdateNotForLoanStatusOnCheckin to show only the notforloan values message >Upgrade to 22.06.00.075 [17:14:06]: Bug 31948 - Add timestamp to tmp_holdsqueue table >Upgrade to 22.06.00.076 [17:14:06]: Bug 29792 - Fix transfers created from 'wrong transfer' checkin are not sent if modal dismissed > Added new system preference 'AutomaticConfirmTransfer' >Upgrade to 22.06.00.077 [17:14:06]: Bug 31713 - Add ACCOUNTS_SUMMARY slip notice > Added new letter 'ACCOUNTS_SUMMARY' (print) >Upgrade to 22.06.00.078 [17:14:06]: Bug 24860 - Add ability to place item group level holds > Added new system preference 'EnableItemGroupHolds' >Upgrade to 22.06.00.079 [17:14:07]: Bug 32030 - Add an ERM module > Added new system preference 'ERMModule' > Added new permission 'erm' > Added new table 'erm_agreements' > Added new table 'erm_agreement_periods' > Added new table 'erm_licenses' > Added new table 'erm_agreement_licenses' > Added new table 'erm_user_roles' > Added new table 'erm_agreement_relationships' > Added new table 'erm_documents' > Added new table 'erm_eholdings_packages' > Added new table 'erm_eholdings_packages_agreements' > Added new table 'erm_eholdings_titles' > Added new table 'erm_eholdings_resources' > Added column 'aqbooksellers.external_id' > Added new system preference 'ERMProviders' > Added new system preference 'ERMProviderEbscoCustomerID' > Added new system preference 'ERMProviderEbscoApiKey' >Upgrade to 22.06.00.080 [17:14:07]: Bug 30880 - Add branchonly option to OPACResultsUnavailableGroupingBy syspref >Upgrade to 22.06.00.081 [17:14:08]: Bug 31378 - Add identity_provider and identity_provider_domains configuration tables > Added new permission 'manage_identity_providers' > Added new table 'identity_providers' > Added new table 'identity_provider_domains' >Upgrade to 22.06.00.082 [17:14:08]: Bug 30250 - Add new system preference ApplyFrameworkDefaults > Added new system preference 'ApplyFrameworkDefaults' >Upgrade to 22.06.00.083 [17:14:08]: Bug 24606 - Add new table item_editor_templates > Added new table 'item_editor_templates' > Added new permission 'manage_item_editor_templates' >Upgrade to 22.06.00.084 [17:14:08]: Bug 32162 - Add primary key to erm_eholdings_packages_agreements >Upgrade to 22.06.00.085 [17:14:08]: Bug 32030 - Add primary key to erm_user_roles >Upgrade to 22.11.00.000 [17:14:08]: Koha 22.11.00 Rosalie release >Upgrade to 22.12.00.000 [17:14:08]: Increase DBRev for 22.12 > ð Deep into that darkness peering, long I stood there wondering, fearing, > ð Doubting, dreaming dreams no mortal ever dared to dream before; > ð But the silence was unbroken, and the stillness gave no token >Upgrade to 22.12.00.001 [17:14:09]: Bug 32330 - Add indexes to background_jobs table >Upgrade to 22.12.00.002 [17:14:09]: Bug 27424 - Add column to specify an SMTP server as the default >Upgrade to 22.12.00.003 [17:14:09]: Bug 20256 - Add ability to limit editing of items to home library > Added new permission 'edit_any_item' > Added 'edit_any_item' permission to users with edit items permission > Added column 'library_groups.ft_limit_item_editing' >Upgrade to 22.12.00.004 [17:14:09]: Bug 30642 - Record whether a renewal has been done manually or automatically. > Added column 'checkout_renewals.column_name' >Upgrade to 22.12.00.005 [17:14:09]: Bug 31051 - Add new system preference OPACShowSavings > Added new system preference 'OPACShowSavings' >Upgrade to 22.12.00.006 [17:14:09]: Bug 22428 - Changes the datatype of the field value column to text to stop input being cut short > Amended dataype of column field_value in table marc_modification_template_actions. >Upgrade to 22.12.00.007 [17:14:09]: Bug 32967 - Recalls notices are using the wrong database columns > Fix column names in PICKUP_RECALLED_ITEM notice > Fix column names in RECALL_REQUESTER_DET notice >Upgrade to 22.12.00.008 [17:14:09]: Bug 33004 - Add VENDOR_TYPE authorised value category > Added new authorised value category 'VENDOR_TYPE' >Upgrade to 22.12.00.009 [17:14:09]: Bug 32799 - Rename ILLSTATUS authorised value category > Renamed authorised value category 'ILLSTATUS' to 'ILL_STATUS_ALIAS' >Upgrade to 22.12.00.010 [17:14:09]: Bug 31028 - Add a way to record users concerns about catalog records > Added new table 'tickets' > Added new table 'ticket_updates' > Added new system preference 'OpacCatalogConcerns' > `CatalogConcernHelp` block added to html_customization > `CatalogConcernTemplate` block added to html_customization > Added new notice 'TICKET_ACKNOWLEDGE' > Added new notice 'TICKET_UPDATE' > Added new notice 'TICKET_RESOLVE' > Added new system preference 'CatalogerEmails' > Added new notice 'TICKET_NOTIFY' > Added new system preference 'CatalogConcerns' >Upgrade to 22.12.00.011 [17:14:10]: Bug 25655 - Store actual cost in foreign currency and currency from the invoices > Added column 'aqorders.invoice_unitprice' > Added column 'aqorders.invoice_currency' >Upgrade to 22.12.00.012 [17:14:10]: Bug 30624 - Add loggedinlibrary permission > Added new permission 'loggedinlibrary' >Upgrade to 22.12.00.013 [17:14:10]: Bug 32057 - Add optional stack trace to action logs > Added column 'action_logs.trace' > Added new system preference 'ActionLogsTraceDepth' >Upgrade to 22.12.00.014 [17:14:10]: Bug 30555 - Add more sample notice for sms messages > Added new letter 'CHECKIN' (sms) > Added new letter 'CHECKOUT' (sms) > Added new letter 'DUE' (sms) > Added new letter 'DUEDGST' (sms) > Added new letter 'PREDUE' (sms) > Added new letter 'PREDUEDGST' (sms) > Added new letter 'HOLD' (sms) >Upgrade to 22.12.00.015 [17:14:10]: Bug 3150 - Add LIST and CART notices > Added new letter 'LIST' (email) > Added new letter 'CART' (email) >Upgrade to 22.12.00.016 [17:14:10]: Bug 32437 - Add primary key to import_auths tables > Added PRIMARY KEY ON import_record_id to import_authd table >Upgrade to 22.12.00.017 [17:14:10]: Bug 31123 - Add `ContentWarningField` preference >Upgrade to 22.12.00.018 [17:14:10]: Bug 30403 - Add system preference UpdateNotForLoanStatusOnCheckout >Upgrade to 22.12.00.019 [17:14:12]: Bug 33368 - Extend borrowers.flags to bigint >Upgrade to 22.12.00.020 [17:14:12]: Bug 33192 - Rename `AutoEmailPrimaryAddress` to `EmailFieldPrimary` > Updated system preference 'AutoEmailPrimaryAddress' >Upgrade to 22.12.00.021 [17:14:12]: Bug 33103 - Add vendor aliases > Added new table 'aqbookseller_aliases' >Upgrade to 22.12.00.022 [17:14:12]: Bug 12029 - Enable users to dismiss their patron messages > Added column 'messages.patron_read_date' >Upgrade to 22.12.00.023 [17:14:12]: Bug 33300 - Fix missing wrong system preference 'AutomaticWrongTransfer' > Wrong system preference 'AutomaticWrongTransfer' does not exist >Upgrade to 22.12.00.024 [17:14:12]: Bug 33128 - Add missing Polish (pl) language translations > Polish (pl) translations were added >Upgrade to 22.12.00.025 [17:14:12]: Bug 32745 - Update context={} for invalid background jobs >Upgrade to 22.12.00.026 [17:14:12]: Bug 22440 - Add new /ill_requests endopoint > Added column 'illrequests.deleted_biblio_id' > Added foreign key constraint 'illrequests.illrequests_bibfk' >Upgrade to 22.12.00.027 [17:14:13]: Bug 33262 - Store biblionumber of deleted record in acquisition orders > Added column 'aqorders.deleted_biblionumber' >Upgrade to 22.12.00.028 [17:14:13]: Bug 33104 - Add vendor interfaces > Added new table 'aqbookseller_interfaces' > Added new authorised value category 'VENDOR_INTERFACE_TYPE' >Upgrade to 22.12.00.029 [17:14:13]: Bug 33197 - Rename GDPR_Policy system preference > Rename system preference GDPR_Policy to PrivacyPolicyConsent >Upgrade to 22.12.00.030 [17:14:13]: Bug 33053 - Remove default from biblio_id for item_groups and recalls tables >Upgrade to 22.12.00.031 [17:14:13]: Bug 33673 - Change "global system preferences" to "system preferences" > Updated manage_sysprefs permission description. >Upgrade to 22.12.00.032 [17:14:13]: Bug 30928 - Add interface field to statistics table > Added column 'statistics.interface' >Upgrade to 22.12.00.033 [17:14:16]: Bug 28328 - Extend biblioitems.lccn >Upgrade to 22.12.00.034 [17:14:16]: Bug 33557 - Add a system preference LinkerConsiderThesaurus > Added new system preference 'LinkerConsiderThesaurus' >Upgrade to 22.12.00.035 [17:14:16]: Bug 33567 - Replace empty Reference_NFL_Statuses pref >Upgrade to 22.12.00.036 [17:14:16]: Bug 31557 - Add syspref HoldsQueuePrioritizeBranch >Upgrade to 22.12.00.037 [17:14:30]: Bug 31212 - Update items.datelastseen and deleteditems.datelastseen to datetime data format > items and deleteditems table updated >Upgrade to 22.12.00.038 [17:14:31]: Bug 33489 - Add indices to default patron search fields > Added new index on borrowers.cardnumber > Added new index on borrowers.userid > Added new index on borrowers.midddle_name >Upgrade to 22.12.00.039 [17:14:31]: Bug 32357 - Set borrower_message_preferences.days_in_advance default to NULL > Updated column 'borrower_message_preferences.days_in_advance default' to NULL >Upgrade to 22.12.00.040 [17:14:31]: Bug 33488 - Add index to fromBranch for branch_transfer_limits > Added new index on branch_transfer_limits.fromBranch >Upgrade to 22.12.00.041 [17:14:31]: Bug 30649 - Increase the vendor EDI account password field to 256 characters >Upgrade to 22.12.00.042 [17:14:31]: Bug 30418 - Add new list permission and new column to virtualshelves >Upgrade to 22.12.00.043 [17:14:32]: Bug 21330 - Add XSLT for authority details view in OPAC > Added new system preference 'AuthorityXSLTOpacDetailsDisplay' >Upgrade to 22.12.00.044 [17:14:32]: Bug 11844 - Add column additional_fields.marcfield_mode > Added column 'additional_fields.marcfield >Upgrade to 22.12.00.045 [17:14:32]: Bug 33297 - Fix missing 's' in system preference 'RetainPatronSearchTerms' >Upgrade to 22.12.00.046 [17:14:32]: Bug 30358 - Add new system preference StripWhitespaceChars >Upgrade to 22.12.00.047 [17:14:32]: Bug 32450 - Create a database flag for whether a debit type should be included in the noissuescharge block on circulation and remove redundant sysprefs. > Added column 'account_debit_types.restricts_checkouts' > ManInvInNoissuesCharge is included in the charge, default database value of 1 can be applied. > RentalsInNoissuesCharge is included in the charge, default database value of 1 can be applied. > HoldsInNoissuesCharge was not found in this Koha instance, default value has been applied. >Upgrade to 22.12.00.048 [17:14:32]: Bug 29046 - Allow setting first_valid_email_address field precedence order > Added new system preference 'EmailFieldPrecedence' >Upgrade to 23.05.00.000 [17:14:32]: Koha 23.05.00 release >Upgrade to 23.06.00.000 [17:14:32]: Increase DBRev for 23.06 > ð Another one bites the dust; > ð and another one gone and another one gone. > ð Another one bites the dust. > ð Hey I'm gonna get you too! > ð Another one bites the dust. >Upgrade to 23.06.00.001 [17:14:32]: Bug 33697 - Remove RecordedBooks (rbdigital) integration > Removed system preference 'RecordedBooksClientSecret' > Removed system preference 'RecordedBooksDomain' > Removed system preference 'RecordedBooksLibraryID' >Upgrade to 23.06.00.002 [17:14:32]: Bug 21983 - Deleted biblio handling on ILL >Upgrade to 23.06.00.003 [17:14:32]: Bug 32478 - Remove usage of Koha::Config::SysPref->find since bypasses cache > Replace 'NULL' with 'null' in ItemsDeniedRenewal system preference > Clear system preference cache >Upgrade to 23.06.00.004 [17:14:32]: Bug 33945 - Add system preference LoadCheckoutsTableDelay >Upgrade to 23.06.00.005 [17:14:32]: Bug 33961 - Remove Offline circulation tool > Removed system preference 'AllowOfflineCirculation' >Upgrade to 23.06.00.006 [17:14:32]: Bug 33117 - Patron checkout is not able to find patrons if using a second surname or other name during the search > Added new system preference 'DefaultPatronSearchMethod' >Upgrade to 23.06.00.007 [17:14:52]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors > Updated biblioitems.place to text > Updated deletedbiblioitems.place to text > Remove index on biblioitems.publishercode > Updated biblioitems.publishercode to text > Create index on biblioitems.publishercode > Remove index on deletedbiblioitems.publishercode > Updated deletedbiblioitems.publishercode to text > Create index on deletedbiblioitems.publishercode > Updated biblioitems.size to text > Updated deletedbiblioitems.size to text > Updated biblioitems.pages to text > Updated deletedbiblioitems.pages to text > Updated biblioitems.illus to text > Updated deletedbiblioitems.illus to text >Upgrade to 23.06.00.008 [17:14:52]: Bug 33039 - Add published on template to serial subscriptions table >Upgrade to 23.06.00.009 [17:14:52]: Bug 30979 - Add OPACTrustedCheckout system preference >Upgrade to 23.06.00.010 [17:14:52]: Bug 33028 - Fix wrongly formatted values for monetary values in circulation rules > Circulation rules have been validated. All circulation rule values are correctly formatted. >Upgrade to 23.06.00.011 [17:14:52]: Bug 33105 - Add vendor issues > Added new table 'aqbookseller_issues' > Added new permission 'acquisition.issue_manage' > Added new authorised value category 'VENDOR_ISSUE_TYPE' >Upgrade to 23.06.00.012 [17:14:52]: Bug 33379 - Remove unused column virtualshelfcontents.flags > Removed column 'virtualshelfcontents.flags' >Upgrade to 23.06.00.013 [17:14:53]: Bug 28966 - Holds queue view too slow to load for large numbers of holds > Set primary key for table 'tmp_holdsqueue' to 'itemnumber' >Upgrade to 23.06.00.014 [17:14:53]: Bug 30451 - Update FK constraint on aqorders.subscriptionid to ON DELETE SET NULL > Update FK constraint on subscriptionid >Upgrade to 23.06.00.015 [17:14:53]: Bug 34494 - Fix tmp_holdsqueue for MySQL compatibility >Upgrade to 23.06.00.016 [17:14:53]: Bug 34584 - Update SocialNetworks system preference to Choice > Updated system preference 'SocialNetworks' >Upgrade to 23.06.00.017 [17:14:53]: Bug 32911 - Remove ILL partner_code config from koha-conf.xml and turn it into a system preference > Moved value of partner_code in koha-conf.xml into new system preference 'ILLPartnerCode' >Upgrade to 23.06.00.018 [17:14:53]: Bug 27378 - Adds the sysprefs for cookie consents > Added new system preference 'CookieConsentedJS' > Added new system preference 'CookieConsent' >Upgrade to 23.06.00.019 [17:14:53]: Bug 34789 - Correct datatypes and column name in table erm_eholdings_titles > Column preceeding_publication_title renamed to preceding_publication_title_id > Column publication_title datatype amended to mediumtext > Column notes datatype amended to mediumtext >Upgrade to 23.06.00.020 [17:14:54]: Bug 27634 - Add categorycode and dateexpiry to PatronSelfRegistrationBorrowerUnwantedField >Upgrade to 23.06.00.021 [17:14:54]: Bug 33716 - Add new ILLModuleDisclaimerByType system preference > Added new system preference 'ILLModuleDisclaimerByType' >Upgrade to 23.06.00.022 [17:14:54]: Bug 34844 - Add permission manage_item_editor_templates > Added new permission 'manage_item_editor_templates' >Upgrade to 23.06.00.023 [17:14:54]: Bug 34843 - Restore comment on article_requests.toc_request >Upgrade to 23.06.00.024 [17:14:54]: Bug 34720 - Add system preference UpdateNotForLoanStatusOnCheckout > Skipped - System preference exists already in DB >Upgrade to 23.06.00.025 [17:14:54]: Bug 29822 - Convert DefaultPatronSeachFields from csv to psv > Updated system preference 'DefaultPatronSearchFields >Upgrade to 23.06.00.026 [17:14:54]: Bug 34748 - Fix column name in column configuration for basket summary > Update column configuration with new columnname order_line >Upgrade to 23.06.00.027 [17:14:54]: Bug 29145 - Change type of AutoRemoveOverduesRestrictions system preference > Type of AutoRemoveOverduesRestrictions system preference has been changed >Upgrade to 23.06.00.028 [17:14:54]: Bug 9525 - Add option to set group as local float group > Added column 'library_groups.ft_local_float_group' >Upgrade to 23.06.00.029 [17:14:54]: Bug 34657 - Update MARC frameworks to use renamed UNIMARC plugin (unimarc_field_123defg.pl) > Update complete: MARC subfields which were configured to use unimarc_field123d.pl, unimarc_field123e.pl, unimarc_field123f.pl, or unimarc_field123g.pl will now use unimarc_field123defg.pl >Upgrade to 23.06.00.030 [17:14:54]: Bug 28688 - Add notice MEMBERSHIP_RENEWED >Upgrade to 23.06.00.031 [17:14:54]: Bug 12532 - Add new system preference RedirectGuaranteeEmail and cc_address field > Added system preference 'RedirectGuaranteeEmail' > Added column 'cc_address' >Upgrade to 23.06.00.032 [17:14:54]: Bug 25560 - Migrating existing UpdateNotForLoanStatusOnCheckin rules to new format >Upgrade to 23.06.00.033 [17:14:54]: Bug 34075 - Add DefaultAuthorityTab system preference > Added new system preference 'DefaultAuthorityTab' >Upgrade to 23.06.00.034 [17:14:54]: Bug 21246 - A preference to specify how many previous patrons to show for showLastPatron > Added new system preference 'showLastPatronCount' >Upgrade to 23.06.00.035 [17:14:54]: Bug 16223 - Add new columns lift_after_payment and fee_limit to table restriction_types > Added column 'restriction_types.lift_after_payment' > Added column 'restriction_types.fee_limit' >Upgrade to 23.06.00.036 [17:14:55]: Bug 30719 - Add ability to create batch ILL requests > Added new table 'illbatch_statuses' > Added new table 'illbatches' > Added column 'illrequests.batch_id' > Added new ILL batch status 'NEW' > Added new ILL batch status 'IN_PROGRESS' > Added new ILL batch status 'COMPLETED' > Added new ILL batch status 'UNKNOWN' >Upgrade to 23.06.00.037 [17:14:55]: Bug 31631 - Allow choosing for tax-exclusive values to be used for calculating fund values (spent, ordered) > Added new system preference 'CalculateFundValuesIncludingTax' >Upgrade to 23.06.00.038 [17:14:56]: Bug 30708 - Add a preservation module > Added new system preference 'PreservationModule' > Added new system preference 'PreservationNotForLoanWaitingListIn' > Added new system preference 'PreservationNotForLoanDefaultTrainIn' > Added new permission 'preservation' > Added new table 'preservation_processings' > Added new table 'preservation_trains' > Added new table 'preservation_processing_attributes' > Added new table 'preservation_trains_items' > Added new table 'preservation_processing_attributes_items' >Upgrade to 23.06.00.039 [17:14:56]: Bug 32721 - Allow branch specific javascript and css to be injected into the OPAC depending on a branchcode > Added column 'branches.opacuserjs' > Added column 'branches.opacusercss' >Upgrade to 23.06.00.040 [17:14:56]: Bug 25816 - Add OPAC messages in SIP display > Added new system preference 'SIP2AddOpacMessagesToScreenMessage' >Upgrade to 23.06.00.041 [17:14:56]: Bug 31383 - Split the additional_contents table > Renamed additional_contents.idnew with 'id' > Added new table 'additional_contents_localizations' > Removed 'title', 'content', 'lang' columns from additional_contents > Adjusted notice template 'ISSUESLIP' >Upgrade to 23.06.00.042 [17:14:56]: Bug 33845 - Update holds_table column settings entries to holds-table > Update columns settings to use table name holds-table >Upgrade to 23.06.00.043 [17:14:56]: Bug 31357 - Add new system preference IntranetReadingHistoryHolds >Upgrade to 23.06.00.044 [17:14:56]: Bug 25393 - Create separate 'no automatic renewal before' rule > New circulation rule 'noautorenewalbefore' has been added. Defaulting value to 'norenewalbefore'. >Upgrade to 23.06.00.045 [17:14:56]: Bug 28166 - Add system preference for additional columns for Z39.50 authority search results > Added new system preference 'AdditionalFieldsInZ3950ResultAuthSearch' >Upgrade to 23.06.00.046 [17:14:56]: Bug 33547 - Add a new notice template 'PRES_TRAIN_ITEM' > Added new letter 'PRES_TRAIN_ITEM' (print) >Upgrade to 23.06.00.047 [17:14:56]: Bug 15504 - Adds a new system preference - TrackLastPatronActivityTriggers > Added system preference 'TrackLastPatronActivityTriggers' > Removed system preference 'TrackLastPatronActivity' >Upgrade to 23.06.00.048 [17:14:57]: Bug 27153 - Add option to filter search fields > Added column 'search_marc_to_field.filter' > Updated primary key to include filter >Upgrade to 23.06.00.049 [17:14:57]: Bug 31503 - Change patron_consent.type > Changed column 'patron_consent.type' >Upgrade to 23.06.00.050 [17:14:57]: Bug 31846 - Allow setting serials search results limit > Added new system preference 'SerialsSearchResultsLimit' >Upgrade to 23.06.00.051 [17:14:57]: Bug 10762 - Make it possible to adjust the barcode height and width on labels > Added column 'creator_layouts.scale_width' > Added column 'creator_layouts.scale_height' >Upgrade to 23.06.00.052 [17:14:57]: Bug 8838 - Add digest option for HOLD notice > Added new notice 'HOLDDGST' (email) > Added new notice 'HOLDDGST' (sms) >Upgrade to 23.06.00.053 [17:14:58]: Bug 33970 - Bind ILL attributes to specific backends > Added column 'illrequestattributes.backend' > Removed 'illrequestattributes.illrequestattributes_ifk' foreign key > Removed 'illrequestattributes' primary key > Added new primary key in 'illrequestattributes' > Added 'illrequestattributes.illrequestattributes_ifk' foreign key > Updated 'backend' column for all pre-existing rows in 'illrequestattributes' >Upgrade to 23.06.00.054 [17:14:58]: Bug 33887 - Automatically fill the next hold with a automatic check in. > Added new system preference 'AutomaticCheckinAutoFill' >Upgrade to 23.06.00.055 [17:14:58]: Bug 34520 - Correct item_groups FK in reserves table > FK 'reserves_ibfk_ig' on reserves updated to ON DELETE SET NULL >Upgrade to 23.06.00.056 [17:14:59]: Bug 34587 - Add ERM Usage Statistics module > Added new table 'erm_usage_data_providers' > Added new table 'erm_counter_files' > Added new table 'erm_counter_logs' > Added new table 'erm_usage_titles' > Added new table 'erm_usage_platforms' > Added new table 'erm_usage_databases' > Added new table 'erm_usage_items' > Added new table 'erm_usage_mus' > Added new table 'erm_usage_yus' > Added new table 'erm_default_usage_reports' >Upgrade to 23.06.00.057 [17:14:59]: Bug 26170 - Add protected status for patrons > Added column 'borrowers.protected' > Added column 'deletedborrowers.protected' >Upgrade to 23.06.00.058 [17:14:59]: Bug 33664 - Allow cancelling of orders from closed baskets > Added new system preference 'CancelOrdersInClosedBaskets' >Upgrade to 23.06.00.059 [17:14:59]: Bug 8367 - Set hold pickup period circulation rule > Added default circulation rule for holds_pickup_period >Upgrade to 23.06.00.060 [17:14:59]: Bug 18203 - Add per borrower category restrictions on ILL placement > Added column 'categories.can_place_ill_in_opac' >Upgrade to 23.06.00.061 [17:14:59]: Bug 29002 - Add bookings table >ERROR - {UNKNOWN}: DBI Exception: 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 5 at /usr/share/koha/lib/C4/Installer.pm line 741 > >dpkg: error processing package koha-common (--configure): > installed koha-common package post-installation script subprocess returned error exit status 1 >Errors were encountered while processing: > koha-common >E: Sub-process /usr/bin/dpkg returned an error code (1) >```
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 36424
:
167670
|
167773
| 168403 |
168446