Bugzilla – Attachment 167315 Details for
Bug 36993
Upgrade fails at 23.12.00.023 [Bug 32132]
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Bug 36993 - Output from testing
Bug 36993 - Testing output.txt (text/plain), 11.57 KB, created by
David Nind
on 2024-05-31 18:33:29 UTC
(
hide
)
Description:
Bug 36993 - Output from testing
Filename:
MIME Type:
Creator:
David Nind
Created:
2024-05-31 18:33:29 UTC
Size:
11.57 KB
patch
obsolete
>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) >
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 36993
:
167306
| 167315 |
167377