Bug 36993 Testing ================= 1. Manually updating the database ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ koha-mysql kohadev Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 285 Server version: 10.5.25-MariaDB-ubu2004 mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [koha_kohadev]> ALTER TABLE aqbudgets MODIFY COLUMN `budget_period_id` INT(11) NULL; Query OK, 0 rows affected (0.039 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [koha_kohadev]> UPDATE aqbudgets SET budget_period_id = NULL WHERE budget_period_id IN(SELECT budget_period_id FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"); Query OK, 0 rows affected (0.001 sec) Rows matched: 0 Changed: 0 Warnings: 0 MariaDB [koha_kohadev]> DELETE FROM aqbudgetperiods WHERE budget_period_description = "Budget for funds without budget"; Query OK, 0 rows affected (0.001 sec) MariaDB [koha_kohadev]> UPDATE systempreferences SET value="23.1200022" WHERE variable = "Version"; Query OK, 1 row affected (0.002 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [koha_kohadev]> \q Bye 2. Running the installer ~~~~~~~~~~~~~~~~~~~~~~~~ kohadev-koha@kohadevbox:koha(bz36993)$ installer/data/mysql/updatedatabase.pl Upgrade to 23.12.00.023 [18:15:23]: 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 [18:15:24]: Bug 35065 - Move ILLModuleCopyrightClearance to additional contents Removed system preference 'ILLModuleCopyrightClearance' Upgrade to 23.12.00.025 [18:15:24]: Bug 33393 - Modify sentence above the order table in English 1-page order PDF Added system preference '1PageOrderPDFText' Upgrade to 23.12.00.026 [18:15:24]: Bug 35616 - Add source column to tickets table Upgrade to 23.12.00.027 [18:15:24]: Bug 32602 - Add administrative plugins type Upgrade to 23.12.00.028 [18:15:24]: Bug 16122 - Add localuse column to items table and deleted items table 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 [18:15:24]: Bug 35919 - Add record_sources table Added new permission 'manage_record_sources' Upgrade to 23.12.00.030 [18:15:24]: 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 [18:15:24]: 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 [18:15:24]: Bug 33478 - Customise the format of notices when they are printed Upgrade to 23.12.00.033 [18:15:24]: 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 [18:15:24]: 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 [18:15:24]: Bug 29393 - Add permission borrowers:send_messages_to_borrowers Added new permission 'send_messages_to_borrowers' Upgrade to 23.12.00.036 [18:15:24]: Bug 35138 - Make the Elasticsearch facets configurable Updated DisplayLibraryFacets and search field configuration Upgrade to 23.12.00.037 [18:15:24]: Bug 35626 - Add statuses to catalog concerns Added TICKET_STATUS authorised value category Upgrade to 23.12.00.038 [18:15:24]: Bug 32435 - Add ticket resolutions to catalog concerns Added TICKET_RESOLUTION authorised value category Upgrade to 23.12.00.039 [18:15:24]: Bug 36002 - Remove aqorders.purchaseordernumber Upgrade to 23.12.00.040 [18:15:24]: Bug 32610 - Add option for additional patron attributes of type date Upgrade to 23.12.00.041 [18:15:24]: Bug 15565 - Add DisplayMultiItemHolds system preference Added new system preference 'DisplayMultiItemHolds' Upgrade to 23.12.00.042 [18:15:24]: Bug 35657 - Add assignee_id to tickets Upgrade to 23.12.00.043 [18:15:24]: Bug 25159 - Add action logs should be stored in JSON ( and as a diff of the change ) Added column 'action_logs.diff' Upgrade to 23.12.00.044 [18:15:24]: Bug 36120 - Add pickup location to bookings Upgrade to 23.12.00.045 [18:15:24]: Bug 22740 - Preferences to enable automated setting of lost status when the associated fine is paid or written off Added new system preference 'UpdateItemLostStatusWhenPaid' Added new system preference 'UpdateItemLostStatusWhenWriteoff' Upgrade to 23.12.00.046 [18:15:24]: Bug 27753 - Automate resolution of return claim when checking in an item Added new system preference 'AutoClaimReturnStatusOnCheckin' Added new system preference 'AutoClaimReturnStatusOnCheckout' Upgrade to 23.12.00.047 [18:15:24]: Bug 35169 - Add new system preferences for longoverdue.pl borrowers categories Added new system preference 'DefaultLongOverduePatronCategories' Added new system preference 'DefaultLongOverdueSkipPatronCategories' Upgrade to 23.12.00.048 [18:15:24]: Bug 33134 - Add some 76 missing languages Added 76 new languages Upgrade to 23.12.00.049 [18:15:24]: Bug 36396 - Link Elasticsearch facets with authorized value categories Added Elasticsearch facets with authorized value categories Upgrade to 23.12.00.050 [18:15:24]: Bug 36687 - Set itemtypes.notforloan to NOT NULL and tinyint(1) Updated itemtypes.notforlaon column' Upgrade to 23.12.00.051 [18:15:24]: Bug 31097 - Change default 'Manual' restriction test Updated patron restriction types display for MANUAL restrictions from 'Manual' to 'Manual restriction' Upgrade to 23.12.00.052 [18:15:24]: Bug 32256 - Self checkout batch mode Added system preference 'SCOBatchCheckoutsValidCategories' Upgrade to 23.12.00.053 [18:15:24]: Bug 36755 - Increase length of 'code' column in borrower_attribute_types Increased borrower_attribute_types.code column length from 10 to 64 Upgrade to 23.12.00.054 [18:15:24]: Bug 19768 - Add 'Title notes' tab to OpacSerialDefaultTab system preference Added 'Title notes' option to opacSerialDefaultTab system preference Upgrade to 23.12.00.055 [18:15:24]: Bug 30047 - Add thesaurus and heading fields to auth_header table Upgrade to 23.12.00.056 [18:15:24]: Bug 35149 - Add 'do nothing' option to CircAutoPrintQuickSlip syspref explanation Updated system preference 'CircAutoPrintQuickSlip' Upgrade to 23.12.00.057 [18:15:24]: Bug 29948 - Display author information for researchers Added new system preference 'OPACAuthorIdentifiersAndInformation' Removed system preference 'OPACAuthorIdentifiers' Upgrade to 23.12.00.058 [18:15:24]: Bug 28869 - Add authorised_value_categories.is_integer_only Upgrade to 23.12.00.059 [18:15:24]: Bug 36819 - Change barcode width value if it still has the wrong default value Changed the barcode width in patron card creator default layout from 8% to 80%. Upgrade to 23.12.00.060 [18:15:24]: Bug 36665 - Add system preference StaffLoginBranchBasedOnIP Added new system preference 'StaffLoginBranchBasedOnIP' Upgrade to 23.12.00.061 [18:15:24]: Bug 26176 - Rename AutoLocation and StaffLoginBranchBasedOnIP system preferences ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'StaffLoginRestrictLibraryByIP' for key 'PRIMARY' at /kohadevbox/koha/C4/Installer.pm line 741 3. Values in the database ~~~~~~~~~~~~~~~~~~~~~~~~~ MariaDB [koha_kohadev]> select * from aqbudgets; +-----------+------------------+----------------+----------------+-------------------+---------------+---------------+---------------+--------------+---------------------+------------------+---------------+---------------+-----------------+-------------------+ | budget_id | budget_parent_id | budget_code | budget_name | budget_branchcode | budget_amount | budget_encumb | budget_expend | budget_notes | timestamp | budget_period_id | sort1_authcat | sort2_authcat | budget_owner_id | budget_permission | +-----------+------------------+----------------+----------------+-------------------+---------------+---------------+---------------+--------------+---------------------+------------------+---------------+---------------+-----------------+-------------------+ | 1 | NULL | Main fund | Main fund | kNycM23On | 1000.000000 | 10.000000 | 32774.060000 | PYhZJdzXEC | 2024-05-31 18:01:40 | 1 | NULL | NULL | 1804035270 | 57145446 | | 2 | 1 | Fund 1_2 | Fund 1_2 | NOpzMoKVO | 100.000000 | 75294.620000 | 77260.710000 | rS7YAa2BIk | 2024-05-31 18:01:40 | 1 | NULL | NULL | 551988829 | 1609208924 | | 3 | NULL | Secondary fund | Secondary fund | OVGePdfwUn | 1000.000000 | 10.000000 | 32288.250000 | jbsM7HNl | 2024-05-31 18:01:40 | 1 | NULL | NULL | 1038413021 | 915083507 | +-----------+------------------+----------------+----------------+-------------------+---------------+---------------+---------------+--------------+---------------------+------------------+---------------+---------------+-----------------+-------------------+ 3 rows in set (0.001 sec) 4. Database structure for aqbudgets ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ MariaDB [koha_kohadev]> describe aqbudgets; +-------------------+---------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------+------+-----+---------------------+-------------------------------+ | budget_id | int(11) | NO | PRI | NULL | auto_increment | | budget_parent_id | int(11) | YES | MUL | NULL | | | budget_code | varchar(30) | YES | MUL | NULL | | | budget_name | varchar(80) | YES | | NULL | | | budget_branchcode | varchar(10) | YES | MUL | NULL | | | budget_amount | decimal(28,6) | YES | | 0.000000 | | | budget_encumb | decimal(28,6) | YES | | 0.000000 | | | budget_expend | decimal(28,6) | YES | | 0.000000 | | | budget_notes | longtext | YES | | NULL | | | timestamp | timestamp | NO | | current_timestamp() | on update current_timestamp() | | budget_period_id | int(11) | NO | MUL | NULL | | | sort1_authcat | varchar(80) | YES | | NULL | | | sort2_authcat | varchar(80) | YES | | NULL | | | budget_owner_id | int(11) | YES | MUL | NULL | | | budget_permission | int(1) | YES | | 0 | | +-------------------+---------------+------+-----+---------------------+-------------------------------+ 15 rows in set (0.001 sec)