| Summary: | Upgrade database error -24.05 | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Vivek <vivek.yadava> |
| Component: | Installation and upgrade (web-based installer) | Assignee: | Bugs List <koha-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
| Severity: | enhancement | ||
| Priority: | P5 - low | CC: | gmcharlt, matthew.charlesworth |
| Version: | 23.11 | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
|
Description
Vivek
2024-05-30 01:36:27 UTC
After changing the value to aqbudgets.budget_period_id as NOT NULL it further goes and stuck at Add pickup location to bookings.
Web installer › Updating database structure
Update report:
Upgrade to 23.12.00.023 [11:47:06]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL
Updated aqbudgets.budget_period_id to NOT accept NULL values
Upgrade to 23.12.00.024 [11:47:06]: Bug 35065 - Move ILLModuleCopyrightClearance to additional contents
Removed system preference 'ILLModuleCopyrightClearance'
Upgrade to 23.12.00.025 [11:47:06]: Bug 33393 - Modify sentence above the order table in English 1-page order PDF
Added system preference '1PageOrderPDFText'
Upgrade to 23.12.00.026 [11:47:06]: Bug 35616 - Add source column to tickets table
Added column 'tickets.source'
Upgrade to 23.12.00.027 [11:47:06]: Bug 32602 - Add administrative plugins type
Added new permission 'plugins_admin'
Upgrade to 23.12.00.028 [11:47:07]: Bug 16122 - Add localuse column to items table and deleted items table
Added column 'items.localuse'
Added column 'deleteditems.localuse'
You may use the new /misc/maintenance/update_localuse_from_statistics.pl script to populate the new field from the existing statistics data
Upgrade to 23.12.00.029 [11:47:25]: Bug 35919 - Add record_sources table
Added new table 'record_sources'
Added new column 'biblio_metadata.record_source_id'
Added new foreign key 'biblio_metadata.record_metadata_fk_2'
Added new column 'deletedbiblio_metadata.record_source_id'
Added new foreign key 'deletedbiblio_metadata.record_metadata_fk_2'
Added new permission 'manage_record_sources'
Upgrade to 23.12.00.030 [11:47:25]: Bug 35728 - Add option to NOT redirect to result when search returns only one record
Added system preference 'RedirectToSoleResult'
Upgrade to 23.12.00.031 [11:47:25]: Bug 31791 - Add the ability to lock record modification
Added new permission 'editcatalogue.edit_locked_records'
Added new permission 'editcatalogue.set_record_sources'
Upgrade to 23.12.00.032 [11:47:25]: Bug 33478 - Customise the format of notices when they are printed
Added column 'letter.style'
Upgrade to 23.12.00.033 [11:47:26]: Bug 31652 - Add geo-search: new value for search_field.type enum
Added new value 'geo_point' to search_field.type enum
Upgrade to 23.12.00.034 [11:47:26]: Bug 12802 - Change type of system preference EmailFieldPrimary to multiple
Updated system preference 'EmailFieldPrimary' to include 'selected addresses' option
Added new system preference 'EmailFieldSelection'
Upgrade to 23.12.00.035 [11:47:26]: Bug 29393 - Add permission borrowers:send_messages_to_borrowers
Added new permission 'send_messages_to_borrowers'
Upgrade to 23.12.00.036 [11:47:26]: Bug 35138 - Make the Elasticsearch facets configurable
Updated DisplayLibraryFacets and search field configuration
Upgrade to 23.12.00.037 [11:47:26]: Bug 35626 - Add statuses to catalog concerns
Added column 'tickets.status'
Added column 'ticket_updates.status'
Added TICKET_STATUS authorised value category
Upgrade to 23.12.00.038 [11:47:26]: Bug 32435 - Add ticket resolutions to catalog concerns
Added TICKET_RESOLUTION authorised value category
Upgrade to 23.12.00.039 [11:47:26]: Bug 36002 - Remove aqorders.purchaseordernumber
Upgrade to 23.12.00.040 [11:47:26]: Bug 32610 - Add option for additional patron attributes of type date
Added column 'borrower_attribute_types.is_date'
Upgrade to 23.12.00.041 [11:47:26]: Bug 15565 - Add DisplayMultiItemHolds system preference
Added new system preference 'DisplayMultiItemHolds'
Upgrade to 23.12.00.042 [11:47:26]: Bug 35657 - Add assignee_id to tickets
Added column 'tickets.assignee_id'
Added column 'ticket_updates.assignee_id'
Upgrade to 23.12.00.043 [11:47:27]: Bug 25159 - Add action logs should be stored in JSON ( and as a diff of the change )
Added column 'action_logs.diff'
Update errors :
Upgrade to 23.12.00.044 [11:47:27]: Bug 36120 - Add pickup location to bookings
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'pickup_library_id': used in a foreign key constraint 'bookings_ibfk_4' at /usr/share/koha/lib/C4/Installer.pm line 741
Added column 'bookings.pickup_library_id'
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'pickup_library_id': used in a foreign key constraint 'bookings_ibfk_4' at /usr/share/koha/lib/C4/Installer.pm line 741
Set existing bookings pickup location to item homebranch
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'pickup_library_id': used in a foreign key constraint 'bookings_ibfk_4' at /usr/share/koha/lib/C4/Installer.pm line 741
|