Bug 36992 - Upgrade database error -24.05
Summary: Upgrade database error -24.05
Status: RESOLVED DUPLICATE of bug 36993
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: 23.11
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-30 01:36 UTC by Vivek
Modified: 2024-05-31 08:12 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Vivek 2024-05-30 01:36:27 UTC
Hello,

Koha 24.05 web installer error

Update database

We are upgrading from Koha 23.12.00.022 to 24.05.00.000

Upgrade to 23.12.00.023 [11:31:12]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'budget_period_id': used in a foreign key constraint 'aqbudgetperiods_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 741

Please advice how to revert back to earlier version and resolve this error to upgrade to 24.05

Thanks
Vivek
Comment 1 Vivek 2024-05-30 01:53:17 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
Comment 2 Katrin Fischer 2024-05-31 08:12:23 UTC
Hi Vivek, thank for filing this report. I am trying to collect and order the different reports. Closing this as a duplicate of bug 36993.

You might find some helpful notes on bug 36978 while we work on resolving these issues.

*** This bug has been marked as a duplicate of bug 36993 ***