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
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
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 ***