PLAY [all] ********************************************************************* TASK [Gathering Facts] ********************************************************* ok: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using 'translateav' as instance name" } TASK [Check if git dir already exists] ***************************************** ok: [localhost] TASK [Force get new tags and branches] ***************************************** changed: [localhost] TASK [Clone koha source to /usr/local/src/koha] ******************************** skipping: [localhost] TASK [Copy source koha clone for sandbox] ************************************** changed: [localhost] TASK [Change owner for koha clone for sandbox] ********************************* changed: [localhost] TASK [Create a new database for Koha instance] ********************************* changed: [localhost] TASK [Ensure user doesn't exist or the create below will fail] ***************** ok: [localhost] TASK [mysql_user] ************************************************************** changed: [localhost] TASK [Install koha git config for sandbox] ************************************* changed: [localhost] TASK [Start new koha-testing-docker container] ********************************* changed: [localhost] TASK [Get host port for sandbox staff port] ************************************ changed: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using '52999' as staff port" } TASK [Get host port for sandbox opac port] ************************************* changed: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using '53000' as opac port" } TASK [Get host port for sandbox ssh port] ************************************** changed: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using '53000' as ssh port" } TASK [Install apache config for sandbox instance] ****************************** changed: [localhost] TASK [Symlink the new apache config from sites-available to sites-enabled] ***** changed: [localhost] TASK [Add docker container koha-translateav to ansible hosts] ****************** ok: [localhost] TASK [Test connection to docker container] ************************************* changed: [localhost -> koha-translateav] TASK [debug] ******************************************************************* skipping: [localhost] TASK [Pausing for 5 minutes whilst container sets itself up] ******************* Pausing for 300 seconds (ctrl+C then 'C' = continue early, ctrl+C then 'A' = abort) ok: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "GIT_REMOTE is set to " } TASK [Add git remote as translateav in docker container] ********************** skipping: [localhost] TASK [git checkout commit_id or tag in docker container] ********************** skipping: [localhost] TASK [git checkout translateav/ in docker container] *************************** skipping: [localhost] TASK [Marking repo as a safe git directory] ************************************ changed: [localhost -> koha-translateav] TASK [Checkout origin/main in docker container] ******************************** changed: [localhost -> koha-translateav] TASK [Apply bug 38136 via git-bz in docker container] ************************** changed: [localhost -> koha-translateav] TASK [Generating CSS and JS using yarn build] ********************************** fatal: [localhost -> koha-translateav]: FAILED! => {"changed": true, "cmd": "koha-shell -c 'cd /kohadevbox/koha && PATH=/usr/local/sbin:/usr/bin:/usr/local/bin:/usr/sbin:/sbin:/bin:/kohadevbox/bin:/kohadevbox/koha/node_modules/.bin:/kohadevbox/node_modules/.bin yarn build' translateav", "delta": "0:00:01.309423", "end": "2025-04-01 08:10:29.264753", "msg": "non-zero return code", "rc": 1, "start": "2025-04-01 08:10:27.955330", "stderr": "Error: Cannot find module 'node-sass-tilde-importer'\nRequire stack:\n- /kohadevbox/koha/gulpfile.js\n- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/shared/require-or-import.js\n- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/versioned/^4.0.0/index.js\n- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/index.js\n- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/bin/gulp.js\n at Module._resolveFilename (node:internal/modules/cjs/loader:1140:15)\n at Module._load (node:internal/modules/cjs/loader:981:27)\n at Module.require (node:internal/modules/cjs/loader:1231:19)\n at require (node:internal/modules/helpers:177:18)\n at Object. (/kohadevbox/koha/gulpfile.js:14:23)\n at Module._compile (node:internal/modules/cjs/loader:1364:14)\n at Module._extensions..js (node:internal/modules/cjs/loader:1422:10)\n at Module.load (node:internal/modules/cjs/loader:1203:32)\n at Module._load (node:internal/modules/cjs/loader:1019:12)\n at Module.require (node:internal/modules/cjs/loader:1231:19) {\n code: 'MODULE_NOT_FOUND',\n requireStack: [\n '/kohadevbox/koha/gulpfile.js',\n '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/shared/require-or-import.js',\n '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/versioned/^4.0.0/index.js',\n '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/index.js',\n '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/bin/gulp.js'\n ]\n}\nerror Command failed with exit code 1.\nerror Command failed with exit code 1.", "stderr_lines": ["Error: Cannot find module 'node-sass-tilde-importer'", "Require stack:", "- /kohadevbox/koha/gulpfile.js", "- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/shared/require-or-import.js", "- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/versioned/^4.0.0/index.js", "- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/index.js", "- /usr/local/share/.config/yarn/global/node_modules/gulp-cli/bin/gulp.js", " at Module._resolveFilename (node:internal/modules/cjs/loader:1140:15)", " at Module._load (node:internal/modules/cjs/loader:981:27)", " at Module.require (node:internal/modules/cjs/loader:1231:19)", " at require (node:internal/modules/helpers:177:18)", " at Object. (/kohadevbox/koha/gulpfile.js:14:23)", " at Module._compile (node:internal/modules/cjs/loader:1364:14)", " at Module._extensions..js (node:internal/modules/cjs/loader:1422:10)", " at Module.load (node:internal/modules/cjs/loader:1203:32)", " at Module._load (node:internal/modules/cjs/loader:1019:12)", " at Module.require (node:internal/modules/cjs/loader:1231:19) {", " code: 'MODULE_NOT_FOUND',", " requireStack: [", " '/kohadevbox/koha/gulpfile.js',", " '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/shared/require-or-import.js',", " '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/lib/versioned/^4.0.0/index.js',", " '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/index.js',", " '/usr/local/share/.config/yarn/global/node_modules/gulp-cli/bin/gulp.js'", " ]", "}", "error Command failed with exit code 1.", "error Command failed with exit code 1."], "stdout": "yarn run v1.22.22\n$ yarn css:build && yarn js:build && yarn api:bundle\n$ gulp css && gulp css --view opac\ninfo Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.\ninfo Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.", "stdout_lines": ["yarn run v1.22.22", "$ yarn css:build && yarn js:build && yarn api:bundle", "$ gulp css && gulp css --view opac", "info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.", "info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command."]} ...ignoring TASK [Install OpenSSH Server] ************************************************** changed: [localhost -> koha-translateav] TASK [Enable PermitRootLogin for sshd] ***************************************** changed: [localhost -> koha-translateav] TASK [Start sshd] ************************************************************** changed: [localhost -> koha-translateav] TASK [Set root password to 'koha'] ********************************************* changed: [localhost -> koha-translateav] TASK [Install Postfix MTA] ***************************************************** changed: [localhost -> koha-translateav] TASK [Enable smtp-sink for mail] *********************************************** changed: [localhost -> koha-translateav] TASK [Enable email processing] ************************************************* changed: [localhost -> koha-translateav] TASK [Index the records for the first time] ************************************ changed: [localhost -> koha-translateav] TASK [Restart Zebra after indexing records] ************************************ changed: [localhost -> koha-translateav] TASK [Restart Plack after indexing records] ************************************ changed: [localhost -> koha-translateav] TASK [Restart apache, one last time] ******************************************* changed: [localhost] TASK [Clean up docker files] *************************************************** changed: [localhost] RUNNING HANDLER [Restart apache] *********************************************** changed: [localhost] RUNNING HANDLER [Update koha git repo for sandbox] ***************************** changed: [localhost] RUNNING HANDLER [Restart plack in docker container] **************************** changed: [localhost -> koha-translateav] RUNNING HANDLER [Run updatedatabase.pl in docker container] ******************** fatal: [localhost -> koha-translateav]: FAILED! => {"changed": true, "cmd": "koha-shell -c 'perl -I /kohadevbox/koha /kohadevbox/koha/installer/data/mysql/updatedatabase.pl' translateav", "delta": "0:00:07.540508", "end": "2025-04-01 08:11:22.964540", "msg": "non-zero return code", "rc": 1, "start": "2025-04-01 08:11:15.424032", "stderr": "", "stderr_lines": [], "stdout": "0E0\nUpgrade to 23.12.00.021 [08:11:18]: Bug 35973 - Correct system preference 'RedirectGuaranteeEmail'\n\tCorrected system preference 'RedirectGuaranteeEmail'\nUpgrade to 23.12.00.022 [08:11:18]: Bug 35724 - Add new fields to EDI accounts for librarians to configure non-standard EDI SFTP port numbers\n\tAdded column 'vendor_edi_accounts.download_port'\n\tAdded column 'vendor_edi_accounts.upload_port'\nUpgrade to 23.12.00.023 [08:11:18]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL\n\tDropped foreign key aqbudgetperiods_ibfk_1\n\tUpdated aqbudgets.budget_period_id to NOT accept NULL values\n\tReadded foreign key aqbudgetperiods_ibfk_1\nUpgrade to 23.12.00.024 [08:11:18]: Bug 35065 - Move ILLModuleCopyrightClearance to additional contents\n\tRemoved system preference 'ILLModuleCopyrightClearance'\nUpgrade to 23.12.00.025 [08:11:18]: Bug 33393 - Modify sentence above the order table in English 1-page order PDF\n\tAdded system preference '1PageOrderPDFText'\nUpgrade to 23.12.00.026 [08:11:18]: Bug 35616 - Add source column to tickets table\n\tAdded column 'tickets.source'\nUpgrade to 23.12.00.027 [08:11:18]: Bug 32602 - Add administrative plugins type\n\tAdded new permission 'plugins_admin'\nUpgrade to 23.12.00.028 [08:11:18]: Bug 16122 - Add localuse column to items table and deleted items table\n\tAdded column 'items.localuse'\n\tAdded column 'deleteditems.localuse'\n\tYou may use the new /misc/maintenance/update_localuse_from_statistics.pl script to populate the new field from the existing statistics data\nUpgrade to 23.12.00.029 [08:11:19]: Bug 35919 - Add record_sources table\n\tAdded new table 'record_sources'\n\tAdded new column 'biblio_metadata.record_source_id'\n\tAdded new foreign key 'biblio_metadata.record_metadata_fk_2'\n\tAdded new column 'deletedbiblio_metadata.record_source_id'\n\tAdded new foreign key 'deletedbiblio_metadata.record_metadata_fk_2'\n\tAdded new permission 'manage_record_sources'\nUpgrade to 23.12.00.030 [08:11:19]: Bug 35728 - Add option to NOT redirect to result when search returns only one record\n\tAdded system preference 'RedirectToSoleResult'\nUpgrade to 23.12.00.031 [08:11:19]: Bug 31791 - Add the ability to lock record modification\n\tAdded new permission 'editcatalogue.edit_locked_records'\n\tAdded new permission 'editcatalogue.set_record_sources'\nUpgrade to 23.12.00.032 [08:11:19]: Bug 33478 - Customise the format of notices when they are printed\n\tAdded column 'letter.style'\nUpgrade to 23.12.00.033 [08:11:19]: Bug 31652 - Add geo-search: new value for search_field.type enum\n\tAdded new value 'geo_point' to search_field.type enum\nUpgrade to 23.12.00.034 [08:11:19]: Bug 12802 - Change type of system preference EmailFieldPrimary to multiple\n\tUpdated system preference 'EmailFieldPrimary' to include 'selected addresses' option\n\tAdded new system preference 'EmailFieldSelection'\nUpgrade to 23.12.00.035 [08:11:19]: Bug 29393 - Add permission borrowers:send_messages_to_borrowers\n\tAdded new permission 'send_messages_to_borrowers'\nUpgrade to 23.12.00.036 [08:11:19]: Bug 35138 - Make the Elasticsearch facets configurable\n\tUpdated DisplayLibraryFacets and search field configuration\nUpgrade to 23.12.00.037 [08:11:19]: Bug 35626 - Add statuses to catalog concerns\n\tAdded column 'tickets.status'\n\tAdded column 'ticket_updates.status'\n\tAdded TICKET_STATUS authorised value category\nUpgrade to 23.12.00.038 [08:11:19]: Bug 32435 - Add ticket resolutions to catalog concerns\n\tAdded TICKET_RESOLUTION authorised value category\nUpgrade to 23.12.00.039 [08:11:19]: Bug 36002 - Remove aqorders.purchaseordernumber\nUpgrade to 23.12.00.040 [08:11:19]: Bug 32610 - Add option for additional patron attributes of type date\n\tAdded column 'borrower_attribute_types.is_date'\nUpgrade to 23.12.00.041 [08:11:19]: Bug 15565 - Add DisplayMultiItemHolds system preference\n\tAdded new system preference 'DisplayMultiItemHolds'\nUpgrade to 23.12.00.042 [08:11:19]: Bug 35657 - Add assignee_id to tickets\n\tAdded column 'tickets.assignee_id'\n\tAdded column 'ticket_updates.assignee_id'\nUpgrade to 23.12.00.043 [08:11:19]: Bug 25159 - Add action logs should be stored in JSON ( and as a diff of the change )\n\tAdded column 'action_logs.diff'\nUpgrade to 23.12.00.044 [08:11:19]: Bug 36120 - Add pickup location to bookings\n\t\u001b[34mNo bookings found that need updating to include a pickup library\u001b[0m\nUpgrade to 23.12.00.045 [08:11:19]: Bug 22740 - Preferences to enable automated setting of lost status when the associated fine is paid or written off\n\tAdded new system preference 'UpdateItemLostStatusWhenPaid'\n\tAdded new system preference 'UpdateItemLostStatusWhenWriteoff'\nUpgrade to 23.12.00.046 [08:11:19]: Bug 27753 - Automate resolution of return claim when checking in an item\n\tAdded new system preference 'AutoClaimReturnStatusOnCheckin'\n\tAdded new system preference 'AutoClaimReturnStatusOnCheckout'\nUpgrade to 23.12.00.047 [08:11:19]: Bug 35169 - Add new system preferences for longoverdue.pl borrowers categories\n\tAdded new system preference 'DefaultLongOverduePatronCategories'\n\tAdded new system preference 'DefaultLongOverdueSkipPatronCategories'\nUpgrade to 23.12.00.048 [08:11:19]: Bug 33134 - Add some 76 missing languages\n\tAdded 76 new languages\nUpgrade to 23.12.00.049 [08:11:19]: Bug 36396 - Link Elasticsearch facets with authorized value categories\n\tAdded Elasticsearch facets with authorized value categories\nUpgrade to 23.12.00.050 [08:11:19]: Bug 36687 - Set itemtypes.notforloan to NOT NULL and tinyint(1)\n\tUpdated itemtypes.notforlaon column'\nUpgrade to 23.12.00.051 [08:11:19]: Bug 31097 - Change default 'Manual' restriction test\n\t\u001b[34mUpdated patron restriction types display for MANUAL restrictions from 'Manual' to 'Manual restriction'\u001b[0m\nUpgrade to 23.12.00.052 [08:11:19]: Bug 32256 - Self checkout batch mode\n\tAdded system preference 'SCOBatchCheckoutsValidCategories'\nUpgrade to 23.12.00.053 [08:11:20]: Bug 36755 - Increase length of 'code' column in borrower_attribute_types\n\tIncreased borrower_attribute_types.code column length from 10 to 64\nUpgrade to 23.12.00.054 [08:11:20]: Bug 19768 - Add 'Title notes' tab to OpacSerialDefaultTab system preference\n\tAdded 'Title notes' option to opacSerialDefaultTab system preference\nUpgrade to 23.12.00.055 [08:11:20]: Bug 30047 - Add thesaurus and heading fields to auth_header table\n\tAdded column 'auth_header.heading'\nUpgrade to 23.12.00.056 [08:11:20]: Bug 35149 - Add 'do nothing' option to CircAutoPrintQuickSlip syspref explanation\n\tUpdated system preference 'CircAutoPrintQuickSlip'\nUpgrade to 23.12.00.057 [08:11:20]: Bug 29948 - Display author information for researchers\n\tAdded new system preference 'OPACAuthorIdentifiersAndInformation'\n\t Removed system preference 'OPACAuthorIdentifiers'\nUpgrade to 23.12.00.058 [08:11:20]: Bug 28869 - Add authorised_value_categories.is_integer_only\nUpgrade to 23.12.00.059 [08:11:20]: Bug 36819 - Change barcode width value if it still has the wrong default value\n\t\u001b[33mChanged the barcode width in patron card creator default layout from 8% to 80%.\u001b[0m\nUpgrade to 23.12.00.060 [08:11:20]: Bug 36665 - Add system preference StaffLoginBranchBasedOnIP\n\tAdded new system preference 'StaffLoginBranchBasedOnIP'\nUpgrade to 23.12.00.061 [08:11:20]: Bug 26176 - Rename AutoLocation and StaffLoginBranchBasedOnIP system preferences\n\t\u001b[32mRenamed system preference 'AutoLocation' to 'StaffLoginRestrictLibraryByIP'\u001b[0m\n\t\u001b[32mRenamed system preference 'StaffLoginBranchBasedOnIP' to 'StaffLoginLibraryBasedOnIP'\u001b[0m\nUpgrade to 24.05.00.000 [08:11:20]: Koha 24.05.00 release\nUpgrade to 24.06.00.000 [08:11:20]: Increase DBRev for 24.06\n\t🎵 Mamma mia, here we go again!\nUpgrade to 24.06.00.001 [08:11:20]: Bug 36986 - Rename StaffLoginLibraryBasedOnIP system preference\nUpgrade to 24.06.00.002 [08:11:20]: Bug 36453 - BlockExpiredPatronOpacActions should allow multiple actions options\n\t\u001b[32mBlockExpiredPatronOpacActions system preference type updated to multiple.\u001b[0m\n\t\u001b[34mBlockExpiredPatronOpacActions system preference value updated to 'hold,renew'.\u001b[0m\n\t\u001b[32mUpdated categories.BlockExpiredPatronOpacActions to varchar(128)\u001b[0m\n\t\u001b[34mPatron categories BlockExpiredPatronOpacActions = -1 have been updated to follow the syspref BlockExpiredPatronOpacActions.\u001b[0m\nUpgrade to 24.06.00.003 [08:11:20]: Bug 34597 - Update BlockExpiredPatronOpacActions to include ill_request\n\t\u001b[32mBlockExpiredPatronOpacActions system updated to include ill_request.\u001b[0m\nUpgrade to 24.06.00.004 [08:11:20]: Bug 18493 - Add missing languages to search options\n\t\u001b[32mAdded language_subtag_registry for Greenlandic\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Greenlandic\u001b[0m\n\t\u001b[32mAdded english language description for Greenlandic\u001b[0m\n\t\u001b[32mAdded native language description for Greenlandic\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Karelian\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Karelian\u001b[0m\n\t\u001b[32mAdded english language description for Karelian\u001b[0m\n\t\u001b[32mAdded native language description for Karelian\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Cornish\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Cornish\u001b[0m\n\t\u001b[32mAdded english language description for Cornish\u001b[0m\n\t\u001b[32mAdded native language description for Cornish\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Burmese\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Burmese\u001b[0m\n\t\u001b[32mAdded english language description for Burmese\u001b[0m\n\t\u001b[32mAdded native language description for Burmese\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Punjabi\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Punjabi\u001b[0m\n\t\u001b[32mAdded english language description for Punjabi\u001b[0m\n\t\u001b[32mAdded native language description for Punjabi\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Pashto\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Pashto\u001b[0m\n\t\u001b[32mAdded english language description for Pashto\u001b[0m\n\t\u001b[32mAdded native language description for Pashto\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Finnish Kalo\u001b[0m\n\t\u001b[32mAdded english language description for Finnish Kalo\u001b[0m\n\t\u001b[32mAdded native language description for Finnish Kalo\u001b[0m\n\t\u001b[32mAdded native language description for Finnish Kalo\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Akkala Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Akkala Sami\u001b[0m\n\t\u001b[32mAdded english language description for Akkala Sami\u001b[0m\n\t\u001b[32mAdded native language description for Akkala Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Kildin Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Kildin Sami\u001b[0m\n\t\u001b[32mAdded english language description for Kildin Sami\u001b[0m\n\t\u001b[32mAdded native language description for Kildin Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Ter Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Ter Sami\u001b[0m\n\t\u001b[32mAdded english language description for Ter Sami\u001b[0m\n\t\u001b[32mAdded native language description for Ter Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Pite Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Pite Sami\u001b[0m\n\t\u001b[32mAdded english language description for Pite Sami\u001b[0m\n\t\u001b[32mAdded native language description for Pite Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Kemi Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Kemi Sami\u001b[0m\n\t\u001b[32mAdded english language description for Kemi Sami\u001b[0m\n\t\u001b[32mAdded native language description for Kemi Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Ume Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Ume Sami\u001b[0m\n\t\u001b[32mAdded english language description for Ume Sami\u001b[0m\n\t\u001b[32mAdded native language description for Ume Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Southern Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Southern Sami\u001b[0m\n\t\u001b[32mAdded english language description for Southern Sami\u001b[0m\n\t\u001b[32mAdded native language description for Southern Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Northern Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Northern Sami\u001b[0m\n\t\u001b[32mAdded english language description for Northern Sami\u001b[0m\n\t\u001b[32mAdded native language description for Northern Sami\u001b[0m\n\t\u001b[32mAdded native language description for Northern Sami\u001b[0m\n\t\u001b[32mAdded native language description for Northern Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Sami languages\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Sami languages\u001b[0m\n\t\u001b[32mAdded english language description for Sami languages\u001b[0m\n\t\u001b[32mAdded native language description for Sami languages\u001b[0m\n\t\u001b[32mAdded native language description for Sami languages\u001b[0m\n\t\u001b[32mAdded native language description for Sami languages\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Lule Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Lule Sami\u001b[0m\n\t\u001b[32mAdded english language description for Lule Sami\u001b[0m\n\t\u001b[32mAdded native language description for Lule Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Inari Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Inari Sami\u001b[0m\n\t\u001b[32mAdded english language description for Inari Sami\u001b[0m\n\t\u001b[32mAdded native language description for Inari Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Skolt Sami\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Skolt Sami\u001b[0m\n\t\u001b[32mAdded english language description for Skolt Sami\u001b[0m\n\t\u001b[32mAdded native language description for Skolt Sami\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Somali\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Somali\u001b[0m\n\t\u001b[32mAdded english language description for Somali\u001b[0m\n\t\u001b[32mAdded native language description for Somali\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Sotho\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Sotho\u001b[0m\n\t\u001b[32mAdded english language description for Sotho\u001b[0m\n\t\u001b[32mAdded native language description for Sotho\u001b[0m\n\t\u001b[32mAdded language_subtag_registry for Votic\u001b[0m\n\t\u001b[32mAdded language_rfc4646_to_iso639 for Votic\u001b[0m\n\t\u001b[32mAdded english language description for Votic\u001b[0m\n\t\u001b[32mAdded native language description for Votic\u001b[0m\n\t\u001b[32mUpdated native lv language description from Latvija to Latviešu valoda\u001b[0m\n\t\u001b[32mUpdated native lt language description from Lietuvių to Lietuvių kalba\u001b[0m\n\t\u001b[32mAdded native language description for Ancient Greek\u001b[0m\n\t\u001b[32mAdded native language description for Esperanto\u001b[0m\n\t\u001b[32mAdded native language description for Sanskrit\u001b[0m\n\t\u001b[32mAdded native language description for Irish Gaelic\u001b[0m\n\t\u001b[32mAdded native language description for Bosnian\u001b[0m\n\t\u001b[32mAdded native language description for Kazakh\u001b[0m\n\t\u001b[32mAdded native language description of Standard Tibetan\u001b[0m\n\t\u001b[32mAdded native language description of Welsh\u001b[0m\nUpgrade to 24.06.00.005 [08:11:20]: Bug 35639 - Add the SMSSendMaxChar system preference to limit the number of characters in a SMS message\n\t\u001b[32mAdded new system preference 'SMSSendMaxChar'\u001b[0m\nUpgrade to 24.06.00.006 [08:11:20]: Bug 35597 - Add SuggestionsLog system preference \n\t\u001b[32mAdded new system preference 'SuggestionsLog'\u001b[0m\nUpgrade to 24.06.00.007 [08:11:20]: Bug 36330 - Fix typo 'reseve' in COMMENTs for table course_items\n\t\u001b[32mComment for course_items.location was updated.\u001b[0m\n\t\u001b[32mComment for course_items.enabled was updated.\u001b[0m\nUpgrade to 24.06.00.008 [08:11:20]: Bug 35153 - Move IntranetmainUserblock to additional contents\n\t\u001b[32mRemoved system preference 'IntranetmainUserblock'\u001b[0m\nUpgrade to 24.06.00.009 [08:11:20]: Bug 33317 - Add new system preference OpacMetaRobots\n\t\u001b[32mAdded system preference 'OpacMetaRobots'\u001b[0m\nUpgrade to 24.06.00.010 [08:11:20]: Bug 34481 - Add IncludeSeeAlsoFromInSearches like IncludeSeeFromInSearches\n\t\u001b[32mAdded new system preference 'IncludeSeeAlsoFromInSearches'\u001b[0m\nUpgrade to 24.06.00.011 [08:11:20]: Bug 37216 - Ensure EmailFieldSelection options are correct\n\t\u001b[32mUpdated system preference 'EmailFieldSelection'\u001b[0m\nUpgrade to 24.06.00.012 [08:11:20]: Bug 26205 - Add new system preference OPACShowLibraries\n\t\u001b[32mAdded new system preference 'OPACShowLibraries'\u001b[0m\nUpgrade to 24.06.00.013 [08:11:20]: Bug 18317 - Allow check out of already checked out items through SIP\n\t\u001b[32mAdded new system preference 'AllowItemsOnLoanCheckoutSIP'\u001b[0m\nUpgrade to 24.06.00.014 [08:11:20]: Bug 33363 - Split suggestions_manage into three separate permissions for creating, updating, and deleting suggetions\n\t\u001b[32mAdded new permissions suggestions_create\u001b[0m\n\t\u001b[32mAdded new permissions suggestions_delete\u001b[0m\n\t\u001b[32mAdded new permissions suggestions_create to patrons with suggestions_manage\u001b[0m\n\t\u001b[32mAdded new permissions suggestions_delete to patrons with suggestions_manage\u001b[0m\nUpgrade to 24.06.00.015 [08:11:20]: Bug 36453 - Update BlockExpiredPatronOpacActions where 24.06.000.02 was already run\n\t\u001b[34mcategories.BlockExpiredPatronOpacActions already varchar(128)\u001b[0m\nUpgrade to 24.06.00.016 [08:11:20]: Bug 28924 - Adds columns to patron categories to allow category level values for the no issue charge sysprefs\n\t\u001b[32mAdded column 'noissuescharge' to categories\u001b[0m\n\t\u001b[32mAdded column 'noissueschargeguarantees' to categories\u001b[0m\n\t\u001b[32mAdded column 'noissueschargeguarantorswithguarantees' to categories\u001b[0m\nUpgrade to 24.06.00.017 [08:11:20]: Bug 13888 - 'Lists' permission should allow/disallow using the lists module in staff\n\t\u001b[32mAdded permission 'use_public_lists'\u001b[0m\n\t\u001b[32mAdded permission 'create_public_lists'\u001b[0m\nUpgrade to 24.06.00.018 [08:11:20]: Bug 29509 - Update users with list_borrowers permission where required\n\t\u001b[34mAdded permission 'list_borrowers' to 1 users with 'manage_bookings' permissions\u001b[0m\nUpgrade to 24.06.00.019 [08:11:20]: Bug 23781 - Recalls notices and messaging preferences\n\t\u001b[32mAdded recalls SMS notices: RETURN_RECALLED_ITEM, PICKUP_RECALLED_ITEM\u001b[0m\n\t\u001b[32mAdded message attributes for recalls: Recall_Waiting, Recall_Requested\u001b[0m\n\t\u001b[32mAdded message transports for recalls notices\u001b[0m\nUpgrade to 24.06.00.020 [08:11:20]: Bug 36996 - Add z3950Status system preference\n\t\u001b[32mAdded new system preference 'Z3950Status'\u001b[0m\nUpgrade to 24.06.00.021 [08:11:20]: Bug 35539 - Remove unused columns from 'categories' table\n\t\u001b[34mRemoved 'bulk' column from 'categories' table\u001b[0m\n\t\u001b[34mRemoved 'finetype' column from 'categories' table\u001b[0m\n\t\u001b[34mRemoved 'issuelimit' column from 'categories' table\u001b[0m\nUpgrade to 24.06.00.022 [08:11:20]: Bug 37419 - Replace FK constraint to avoid data loss\n\t\u001b[32mUpdated foreign key 'biblio_metadata.record_metadata_fk_2'\u001b[0m\nUpgrade to 24.06.00.023 [08:11:21]: Bug 36757 - Notify assignee when a concern is assigned to them\n\t\u001b[32mAdded notice 'TICKET_ASSIGNED'\u001b[0m\nUpgrade to 24.06.00.024 [08:11:21]: Bug 35044 - Add repeatable option to additional_fields\n\t\u001b[32mAdded repeatable column to additional_fields table\u001b[0m\n\t\u001b[32mRemoved UNIQUE KEY `field_record` (`field_id`,`record_id`) from the additional_field_values table\u001b[0m\nUpgrade to 24.06.00.025 [08:11:21]: Bug 26777 - Adds new system preferences 'OPACVirtualCard and 'OPACVirtualCardBarcode'\n\t\u001b[32mAdded new system preference 'OPACVirtualCard'\u001b[0m\n\t\u001b[32mAdded new system preference 'OPACVirtualCardBarcode'\u001b[0m\nUpgrade to 24.06.00.026 [08:11:21]: Bug 20411 - Remove StaffDetailItemSelection system preference\n\t\u001b[32mRemoved system preference 'StaffDetailItemSelection'\u001b[0m\nUpgrade to 24.06.00.027 [08:11:21]: Bug 27490 - Change language syspref to StaffInterfaceLanguages\n\t\u001b[32mUpdated system preference 'language' to 'StaffInterfaceLanguages'\u001b[0m\nUpgrade to 24.06.00.028 [08:11:21]: Bug 37757 - More robust handling of EmailFieldPrimary system preference values\n\t\u001b[32mUpdated system preference 'EmailFieldPrimary'\u001b[0m\nUpgrade to 24.06.00.029 [08:11:21]: Bug 37592 - Add creation_date, modification_date fields to bookings table\n\t\u001b[32mAdded column 'bookings.creation_date'\u001b[0m\n\t\u001b[32mAdded column 'bookings.modification_date'\u001b[0m\nUpgrade to 24.06.00.030 [08:11:21]: Bug 37601 - Add status column to bookings table\n\t\u001b[32mAdded column 'bookings.status'\u001b[0m\nUpgrade to 24.06.00.031 [08:11:21]: Bug 23685 - Add system preferences ReportsExportFormatODS and ReportsExportLimit\n\t\u001b[32mAdded new system preferences 'ReportsExportFormatODS' and 'ReportsExportLimit'\u001b[0m\nUpgrade to 24.06.00.032 [08:11:21]: Bug 37856 - Add column 'erm_usage_data_providers.service_platform'\n\t\u001b[32mAdded column 'service_platformerm_usage_data_providers'\u001b[0m\nUpgrade to 24.06.00.033 [08:11:21]: Bug 35655 - Add a way to disable RabbitMQ\n\t\u001b[32mAdded new system preference 'JobsNotificationMethod'\u001b[0m\nUpgrade to 24.06.00.034 [08:11:21]: Bug 37967 - Add auto renewal message_transport for phone\n\t\u001b[32mAdded phone messaging transports for auto-renewals\u001b[0m\nUpgrade to 24.06.00.035 [08:11:21]: Bug 37446 - Fix holdingbranch and homebranch facet labels\n\tUpdated search field configuration for holdingbranch and homebranch\nUpgrade to 24.06.00.036 [08:11:21]: Bug 37954 - Move holdings_barcodes setting to holdings_barcode\n\t\u001b[34mNo settings for holdings_barcodes found\u001b[0m\n\tRemoved settings for holdings_barcodes\nUpgrade to 24.06.00.037 [08:11:21]: Bug 36798 - Add 'SearchCancelledAndInvalidISBNandISSN' preference\n\t\u001b[32mAdded new system preference 'SearchCancelledAndInvalidISBNandISSN'\u001b[0m\nUpgrade to 24.06.00.038 [08:11:21]: Bug 36766 - Add command-line utility to SFTP a file to a remote server\n\t\u001b[32mAdded new sample notices 'SFTP_FAILURE' and 'SFTP_SUCCESS'\u001b[0m\nUpgrade to 24.06.00.039 [08:11:21]: Bug 28575 - Add a system preference to prevent refunds on lost items if the fee was paid more than a set number of days ago\n\t\u001b[32mAdded new system preference 'NoRefundOnLostFinesPaidAge'\u001b[0m\nUpgrade to 24.06.00.040 [08:11:21]: Bug 23295 - Automatically debar patrons if SMS or email notice fail\n\t\u001b[32mAdded new system preference 'RestrictPatronsWithFailedNotices'\u001b[0m\n\t\u001b[32mAdded new system restriction type 'NOTICE_FAILURE_SUSPENSION'\u001b[0m\nUpgrade to 24.06.00.041 [08:11:21]: Bug 30955 - Move existing list notices to new lists category\n\t\u001b[32mMoved SHARE_ACCEPT notice to lists module\u001b[0m\n\t\u001b[32mMoved SHARE_INVITE notice to lists module\u001b[0m\n\t\u001b[32mMoved LIST notice to lists module\u001b[0m\nUpgrade to 24.06.00.042 [08:11:21]: Bug 37969 - Add nor language code\n\t\u001b[32mAdded nor language code\u001b[0m\nUpgrade to 24.06.00.043 [08:11:21]: Bug 38193 - Add cancellation_reason field to bookings table\n\t\u001b[32mAdded column 'bookings.cancellation_reason'\u001b[0m\nUpgrade to 24.06.00.044 [08:11:21]: Bug 28833 - Speed up holds queue builder via parallel processing\n\t\u001b[32mAdded new system preference 'HoldsQueueParallelLoopsCount'\u001b[0m\nUpgrade to 24.06.00.045 [08:11:21]: Bug 35906 - Add bookable column on itemtypes table\n\t\u001b[32mAdded column 'itemtypes.bookable'\u001b[0m\n\t\u001b[32mUpdated column 'items.bookable' allow nullable\u001b[0m\n\t\u001b[32mUpdated column 'deleteditems.bookable' allow nullable\u001b[0m\nUpgrade to 24.06.00.046 [08:11:21]: Bug 38222 - Add cancellation reasons to bookings\n\t\u001b[32mAdded new authorized value category 'BOOKING_CANCELLATION'\u001b[0m\nUpgrade to 24.06.00.047 [08:11:21]: Bug 35659 - OAI-PMH harvester\n\t\u001b[32mAdded new table 'oai_servers'\u001b[0m\n\t\u001b[32mAdded new table 'import_oai_biblios'\u001b[0m\n\t\u001b[32mAdded new table 'import_oai_authorities'\u001b[0m\n\t\u001b[32mAdded new system preference 'OAI-PMH:HarvestEmailReport'\u001b[0m\n\t\u001b[32mAdded OAI_HARVEST_REPORT letter\u001b[0m\nUpgrade to 24.06.00.048 [08:11:21]: Bug 33484 - Add state save as an option to datatables\n\t\u001b[32mAdded column 'tables_settings.default_save_state'\u001b[0m\n\t\u001b[32mAdded column 'tables_settings.default_save_state_search'\u001b[0m\nUpgrade to 24.06.00.049 [08:11:21]: Bug 38274 - Fix typo in Arabic language description\n\t\u001b[32mUpdated Arabic language description\u001b[0m\nUpgrade to 24.06.00.050 [08:11:21]: Bug 30648 - Store biblionumber of deleted records in old_reserves\n\t\u001b[32mAdded column 'reserves.deleted_biblionumber'\u001b[0m\n\t\u001b[32mAdded column 'old_reserves.deleted_biblionumber'\u001b[0m\nUpgrade to 24.06.00.051 [08:11:21]: Bug 14180 - Add system preference AlwaysLoadCheckoutsTable\n\t\u001b[32mAdded new system preference 'AlwaysLoadCheckoutsTable'\u001b[0m\nUpgrade to 24.06.00.052 [08:11:21]: Bug 35305 - Add XSLT for authority details display in staff interface\n\t\u001b[32mAdded new system preference 'AuthorityXSLTDetailsDisplay'\u001b[0m\nUpgrade to 24.06.00.053 [08:11:21]: Bug 37511 - Add a new column p_cs_precedes to the table currency\n\t\u001b[32mAdded column 'currency.p_cs_precedes'\u001b[0m\nUpgrade to 24.06.00.054 [08:11:21]: Bug 35570 - Update 'FreeForm' ILL backend to 'Standard'\nUpgrade to 24.06.00.055 [08:11:21]: Bug 33462 - Force password reset for new patrons entered by staff\n\t\u001b[32mAdded new system preference 'ForcePasswordResetWhenSetByStaff'\u001b[0m\n\t\u001b[32mAdded column 'categories.force_password_reset_when_set_by_staff'\u001b[0m\nUpgrade to 24.06.00.056 [08:11:21]: Bug 36822 - Sanitize borrowers.updated_on\nUpgrade to 24.06.00.057 [08:11:21]: Bug 22421 - Add issue constraints to accountlines\n\t\u001b[32mAdded column 'accountlines.old_issue_id'\u001b[0m\n\t\u001b[32mAdded constraint 'accountlines.old_issues'\u001b[0m\n\t\u001b[32mUpdated 'accountlines.old_issue_id' from 'old_issues'\u001b[0m\n\t\u001b[32mFixed 'accountlines.issue_id' where missing from issues\u001b[0m\n\t\u001b[32mAdded constraint 'accountlines.issues'\u001b[0m\n\t\u001b[32mAdded old_issue_id to accountlines and set up appropriate constraints)\u001b[0m\nUpgrade to 24.06.00.058 [08:11:22]: Bug 28633 - Add preferred_name to borrowers table\n\t\u001b[32mAdded column 'borrowers.preferred_name'\u001b[0m\n\t\u001b[32mAdded column 'deletedborrowers.preferred_name'\u001b[0m\n\t\u001b[32mAdded column 'borrower_modifications.preferred_name'\u001b[0m\n\t\u001b[34mAdded 'preferred_name' to DefaultPatronSearchFields\u001b[0m\n\t\u001b[32mInitially set 'preferred_name' to 'firstname'\u001b[0m\nUpgrade to 24.06.00.059 [08:11:22]: Bug 37221 - Add new system preference OPACOverDrive\n\t\u001b[32mAdded new system preference 'OPACOverDrive'\u001b[0m\nUpgrade to 24.06.00.060 [08:11:22]: Bug 33766 - Add system preference to determine label of userid input on login form\n\t\u001b[32mAdded new system preference 'OPACLoginLabelTextContent'\u001b[0m\nUpgrade to 24.06.00.061 [08:11:22]: Bug 38011 - Add missing foreign key to subscription table\n\t\u001b[32mAdded new foreign key 'subscription_ibfk_4'\u001b[0m\nUpgrade to 24.06.00.062 [08:11:22]: Bug 34355 - Add a table to allow creation of MARC order accounts and a system preference to activate it\n\t\u001b[32mAdded new table 'marc_order_accounts'\u001b[0m\n\t\u001b[32mAdded new system preference 'MarcOrderingAutomation'\u001b[0m\n\t\u001b[32mAdded new permission 'marc_order_manage'\u001b[0m\nUpgrade to 24.06.00.063 [08:11:22]: Bug 33641 - Added issues.checkin_library and old_issues.checkin_library\n\t\u001b[32mAdded column 'issues.checkin_library'\u001b[0m\n\t\u001b[32mAdded column 'old_issues.checkin_library'\u001b[0m\nUpgrade to 24.06.00.064 [08:11:22]: Bug 38436 - Adjust column names for holdings tables in the table settings\n\t\u001b[32mColumn names renamed\u001b[0m\nUpgrade to 24.11.00.000 [08:11:22]: Koha 24.11.00 release\nUpgrade to 24.12.00.000 [08:11:22]: Increase DBRev for 24.12\n\t🚧 Let's do this.\nUpgrade to 24.12.00.001 [08:11:22]: Bug 38522 - Increase erm_agreements.license_info length\n\t\u001b[32mUpdated erm_agreements.license_info to mediumtext.\u001b[0m\nUpgrade to 24.12.00.002 [08:11:22]: Bug 37292 - Add index on 'oauth_access_tokens.expires'\n\t\u001b[32mAdded index on 'oauth_access_tokens.expires'\u001b[0m\nUpgrade to 24.12.00.003 [08:11:22]: Bug 33268 - Add rules to preserve current MARC record overlay rules behavior\n\t\u001b[32mAdded record overlay rules to preserve current behavior\u001b[0m\nUpgrade to 24.12.00.004 [08:11:22]: Bug 35154 - Move StaffLoginInstructions to additional contents\n\t\u001b[32mRemoved system preference 'StaffLoginInstructions'\u001b[0m\nUpgrade to 24.12.00.005 [08:11:22]: Bug 35152 - Move RoutingListNote to additional contents\n\t\u001b[32mAdded 'RoutingListNote' HTML customization\u001b[0m\n\t\u001b[32mRemoved system preference 'RoutingListNote'\u001b[0m\nUpgrade to 24.12.00.006 [08:11:22]: Bug 38794 - Update description of authorized value AggregatedFullText\n\t\u001b[32mUpdated description of authorized value AggregatedFullText\u001b[0m\nUpgrade to 24.12.00.007 [08:11:22]: Bug 30300 - Add 'patron expiry' to messaging preferences\n\t\u001b[32mMessage attribute 'Patron_Expiry' added\u001b[0m\n\t\u001b[32mMEMBERSHIP_EXPIRY added to message_transports\u001b[0m\nUpgrade to 24.12.00.008 [08:11:22]: Bug 35028 - Add system preference 'PatronSelfRegistrationAlert'\n\t\u001b[32mAdded new system preference 'PatronSelfRegistrationAlert'\u001b[0m\nUpgrade to 24.12.00.009 [08:11:22]: Bug 36954 - Adjustment for logfiles in koha-sip\n\t\u001b[33mIMPORTANT: If you use SIP, please edit your /etc/koha/sites/[CLONE]/log4perl.conf at upgrade time.\u001b[0m\n\t\u001b[33mReplace sip.log there by sip-output.log.\u001b[0m\nUpgrade to 24.12.00.010 [08:11:22]: Bug 35635 - Add opac_mandatory column to borrower_attribute_type table\n\t\u001b[32mModified column 'borrower_attribute_types.mandatory'\u001b[0m\n\t\u001b[32mAdded column 'borrower_attribute_types.opac_mandatory'\u001b[0m\n\t\u001b[32mUpdate opac_mandatory to match mandatory column\u001b[0m\nUpgrade to 24.12.00.011 [08:11:22]: Bug 26684 - Drop marc column from auth_header\n\t\u001b[32mRemoved column 'auth_header.marc'\u001b[0m\nUpgrade to 24.12.00.012 [08:11:22]: Bug 30888 - Add table deletedauth_header\n\t\u001b[32mAdded new table 'deletedauth_header'\u001b[0m\nUpgrade to 24.12.00.013 [08:11:22]: Bug 38689 - Add edifact_errors table to record edifact error messages\n\t\u001b[32mAdded new table 'edifect_errors'\u001b[0m\nUpgrade to 24.12.00.014 [08:11:22]: Bug 38108 - Add AlwaysShowHoldingsTableFilters system preference\n\t\u001b[32mAdded new system preference 'AlwaysShowHoldingsTableFilters'\u001b[0m\nUpgrade to 24.12.00.015 [08:11:22]: Bug 39075 - Follow up for bug 34587 to fix incorrect default values for timestamps\n\t\u001b[32mSuccessfully corrected incorrect default value for 'erm_counter_files.date_uploaded\u001b[0m\n\t\u001b[32mSuccessfully corrected incorrect default value for 'erm_counter_logs.importdate\u001b[0m\nUpgrade to 24.12.00.016 [08:11:22]: Bug 36833 - Add German translations for new languages\n\t\u001b[32mAdded German translations for new languages\u001b[0m\n\t\u001b[32mUpdated German translation for Latin\u001b[0m\nUpgrade to 24.12.00.017 [08:11:22]: Bug 32630 - Don't delete illrequests when borrower is deleted\n\t\u001b[32mUpdated borrowernumber constraint on illrequests table\u001b[0m\nUpgrade to 24.12.00.018 [08:11:22]: Bug 38663 - Add additional fields to libraries\n\t\u001b[34mConverting record_id from int(11) to VARCHAR(11)...\n\t\u001b[0m\n\t\u001b[31mERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN new_record_id TO record_id' at line 1 at /kohadevbox/koha/C4/Installer.pm line 771\n\t\u001b[0m\nDEV atomic update /kohadevbox/koha/installer/data/mysql/atomicupdate/bug-38136.pl [08:11:22]: Bug 38136 - Add localization.property\n\t\u001b[32mAdded column localization.property and updated localization.entity values\u001b[0m", "stdout_lines": ["0E0", "Upgrade to 23.12.00.021 [08:11:18]: Bug 35973 - Correct system preference 'RedirectGuaranteeEmail'", "\tCorrected system preference 'RedirectGuaranteeEmail'", "Upgrade to 23.12.00.022 [08:11:18]: Bug 35724 - Add new fields to EDI accounts for librarians to configure non-standard EDI SFTP port numbers", "\tAdded column 'vendor_edi_accounts.download_port'", "\tAdded column 'vendor_edi_accounts.upload_port'", "Upgrade to 23.12.00.023 [08:11:18]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL", "\tDropped foreign key aqbudgetperiods_ibfk_1", "\tUpdated aqbudgets.budget_period_id to NOT accept NULL values", "\tReadded foreign key aqbudgetperiods_ibfk_1", "Upgrade to 23.12.00.024 [08:11:18]: Bug 35065 - Move ILLModuleCopyrightClearance to additional contents", "\tRemoved system preference 'ILLModuleCopyrightClearance'", "Upgrade to 23.12.00.025 [08:11:18]: Bug 33393 - Modify sentence above the order table in English 1-page order PDF", "\tAdded system preference '1PageOrderPDFText'", "Upgrade to 23.12.00.026 [08:11:18]: Bug 35616 - Add source column to tickets table", "\tAdded column 'tickets.source'", "Upgrade to 23.12.00.027 [08:11:18]: Bug 32602 - Add administrative plugins type", "\tAdded new permission 'plugins_admin'", "Upgrade to 23.12.00.028 [08:11:18]: Bug 16122 - Add localuse column to items table and deleted items table", "\tAdded column 'items.localuse'", "\tAdded column 'deleteditems.localuse'", "\tYou 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 [08:11:19]: Bug 35919 - Add record_sources table", "\tAdded new table 'record_sources'", "\tAdded new column 'biblio_metadata.record_source_id'", "\tAdded new foreign key 'biblio_metadata.record_metadata_fk_2'", "\tAdded new column 'deletedbiblio_metadata.record_source_id'", "\tAdded new foreign key 'deletedbiblio_metadata.record_metadata_fk_2'", "\tAdded new permission 'manage_record_sources'", "Upgrade to 23.12.00.030 [08:11:19]: Bug 35728 - Add option to NOT redirect to result when search returns only one record", "\tAdded system preference 'RedirectToSoleResult'", "Upgrade to 23.12.00.031 [08:11:19]: Bug 31791 - Add the ability to lock record modification", "\tAdded new permission 'editcatalogue.edit_locked_records'", "\tAdded new permission 'editcatalogue.set_record_sources'", "Upgrade to 23.12.00.032 [08:11:19]: Bug 33478 - Customise the format of notices when they are printed", "\tAdded column 'letter.style'", "Upgrade to 23.12.00.033 [08:11:19]: Bug 31652 - Add geo-search: new value for search_field.type enum", "\tAdded new value 'geo_point' to search_field.type enum", "Upgrade to 23.12.00.034 [08:11:19]: Bug 12802 - Change type of system preference EmailFieldPrimary to multiple", "\tUpdated system preference 'EmailFieldPrimary' to include 'selected addresses' option", "\tAdded new system preference 'EmailFieldSelection'", "Upgrade to 23.12.00.035 [08:11:19]: Bug 29393 - Add permission borrowers:send_messages_to_borrowers", "\tAdded new permission 'send_messages_to_borrowers'", "Upgrade to 23.12.00.036 [08:11:19]: Bug 35138 - Make the Elasticsearch facets configurable", "\tUpdated DisplayLibraryFacets and search field configuration", "Upgrade to 23.12.00.037 [08:11:19]: Bug 35626 - Add statuses to catalog concerns", "\tAdded column 'tickets.status'", "\tAdded column 'ticket_updates.status'", "\tAdded TICKET_STATUS authorised value category", "Upgrade to 23.12.00.038 [08:11:19]: Bug 32435 - Add ticket resolutions to catalog concerns", "\tAdded TICKET_RESOLUTION authorised value category", "Upgrade to 23.12.00.039 [08:11:19]: Bug 36002 - Remove aqorders.purchaseordernumber", "Upgrade to 23.12.00.040 [08:11:19]: Bug 32610 - Add option for additional patron attributes of type date", "\tAdded column 'borrower_attribute_types.is_date'", "Upgrade to 23.12.00.041 [08:11:19]: Bug 15565 - Add DisplayMultiItemHolds system preference", "\tAdded new system preference 'DisplayMultiItemHolds'", "Upgrade to 23.12.00.042 [08:11:19]: Bug 35657 - Add assignee_id to tickets", "\tAdded column 'tickets.assignee_id'", "\tAdded column 'ticket_updates.assignee_id'", "Upgrade to 23.12.00.043 [08:11:19]: Bug 25159 - Add action logs should be stored in JSON ( and as a diff of the change )", "\tAdded column 'action_logs.diff'", "Upgrade to 23.12.00.044 [08:11:19]: Bug 36120 - Add pickup location to bookings", "\t\u001b[34mNo bookings found that need updating to include a pickup library\u001b[0m", "Upgrade to 23.12.00.045 [08:11:19]: Bug 22740 - Preferences to enable automated setting of lost status when the associated fine is paid or written off", "\tAdded new system preference 'UpdateItemLostStatusWhenPaid'", "\tAdded new system preference 'UpdateItemLostStatusWhenWriteoff'", "Upgrade to 23.12.00.046 [08:11:19]: Bug 27753 - Automate resolution of return claim when checking in an item", "\tAdded new system preference 'AutoClaimReturnStatusOnCheckin'", "\tAdded new system preference 'AutoClaimReturnStatusOnCheckout'", "Upgrade to 23.12.00.047 [08:11:19]: Bug 35169 - Add new system preferences for longoverdue.pl borrowers categories", "\tAdded new system preference 'DefaultLongOverduePatronCategories'", "\tAdded new system preference 'DefaultLongOverdueSkipPatronCategories'", "Upgrade to 23.12.00.048 [08:11:19]: Bug 33134 - Add some 76 missing languages", "\tAdded 76 new languages", "Upgrade to 23.12.00.049 [08:11:19]: Bug 36396 - Link Elasticsearch facets with authorized value categories", "\tAdded Elasticsearch facets with authorized value categories", "Upgrade to 23.12.00.050 [08:11:19]: Bug 36687 - Set itemtypes.notforloan to NOT NULL and tinyint(1)", "\tUpdated itemtypes.notforlaon column'", "Upgrade to 23.12.00.051 [08:11:19]: Bug 31097 - Change default 'Manual' restriction test", "\t\u001b[34mUpdated patron restriction types display for MANUAL restrictions from 'Manual' to 'Manual restriction'\u001b[0m", "Upgrade to 23.12.00.052 [08:11:19]: Bug 32256 - Self checkout batch mode", "\tAdded system preference 'SCOBatchCheckoutsValidCategories'", "Upgrade to 23.12.00.053 [08:11:20]: Bug 36755 - Increase length of 'code' column in borrower_attribute_types", "\tIncreased borrower_attribute_types.code column length from 10 to 64", "Upgrade to 23.12.00.054 [08:11:20]: Bug 19768 - Add 'Title notes' tab to OpacSerialDefaultTab system preference", "\tAdded 'Title notes' option to opacSerialDefaultTab system preference", "Upgrade to 23.12.00.055 [08:11:20]: Bug 30047 - Add thesaurus and heading fields to auth_header table", "\tAdded column 'auth_header.heading'", "Upgrade to 23.12.00.056 [08:11:20]: Bug 35149 - Add 'do nothing' option to CircAutoPrintQuickSlip syspref explanation", "\tUpdated system preference 'CircAutoPrintQuickSlip'", "Upgrade to 23.12.00.057 [08:11:20]: Bug 29948 - Display author information for researchers", "\tAdded new system preference 'OPACAuthorIdentifiersAndInformation'", "\t Removed system preference 'OPACAuthorIdentifiers'", "Upgrade to 23.12.00.058 [08:11:20]: Bug 28869 - Add authorised_value_categories.is_integer_only", "Upgrade to 23.12.00.059 [08:11:20]: Bug 36819 - Change barcode width value if it still has the wrong default value", "\t\u001b[33mChanged the barcode width in patron card creator default layout from 8% to 80%.\u001b[0m", "Upgrade to 23.12.00.060 [08:11:20]: Bug 36665 - Add system preference StaffLoginBranchBasedOnIP", "\tAdded new system preference 'StaffLoginBranchBasedOnIP'", "Upgrade to 23.12.00.061 [08:11:20]: Bug 26176 - Rename AutoLocation and StaffLoginBranchBasedOnIP system preferences", "\t\u001b[32mRenamed system preference 'AutoLocation' to 'StaffLoginRestrictLibraryByIP'\u001b[0m", "\t\u001b[32mRenamed system preference 'StaffLoginBranchBasedOnIP' to 'StaffLoginLibraryBasedOnIP'\u001b[0m", "Upgrade to 24.05.00.000 [08:11:20]: Koha 24.05.00 release", "Upgrade to 24.06.00.000 [08:11:20]: Increase DBRev for 24.06", "\t🎵 Mamma mia, here we go again!", "Upgrade to 24.06.00.001 [08:11:20]: Bug 36986 - Rename StaffLoginLibraryBasedOnIP system preference", "Upgrade to 24.06.00.002 [08:11:20]: Bug 36453 - BlockExpiredPatronOpacActions should allow multiple actions options", "\t\u001b[32mBlockExpiredPatronOpacActions system preference type updated to multiple.\u001b[0m", "\t\u001b[34mBlockExpiredPatronOpacActions system preference value updated to 'hold,renew'.\u001b[0m", "\t\u001b[32mUpdated categories.BlockExpiredPatronOpacActions to varchar(128)\u001b[0m", "\t\u001b[34mPatron categories BlockExpiredPatronOpacActions = -1 have been updated to follow the syspref BlockExpiredPatronOpacActions.\u001b[0m", "Upgrade to 24.06.00.003 [08:11:20]: Bug 34597 - Update BlockExpiredPatronOpacActions to include ill_request", "\t\u001b[32mBlockExpiredPatronOpacActions system updated to include ill_request.\u001b[0m", "Upgrade to 24.06.00.004 [08:11:20]: Bug 18493 - Add missing languages to search options", "\t\u001b[32mAdded language_subtag_registry for Greenlandic\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Greenlandic\u001b[0m", "\t\u001b[32mAdded english language description for Greenlandic\u001b[0m", "\t\u001b[32mAdded native language description for Greenlandic\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Karelian\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Karelian\u001b[0m", "\t\u001b[32mAdded english language description for Karelian\u001b[0m", "\t\u001b[32mAdded native language description for Karelian\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Cornish\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Cornish\u001b[0m", "\t\u001b[32mAdded english language description for Cornish\u001b[0m", "\t\u001b[32mAdded native language description for Cornish\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Burmese\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Burmese\u001b[0m", "\t\u001b[32mAdded english language description for Burmese\u001b[0m", "\t\u001b[32mAdded native language description for Burmese\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Punjabi\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Punjabi\u001b[0m", "\t\u001b[32mAdded english language description for Punjabi\u001b[0m", "\t\u001b[32mAdded native language description for Punjabi\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Pashto\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Pashto\u001b[0m", "\t\u001b[32mAdded english language description for Pashto\u001b[0m", "\t\u001b[32mAdded native language description for Pashto\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Finnish Kalo\u001b[0m", "\t\u001b[32mAdded english language description for Finnish Kalo\u001b[0m", "\t\u001b[32mAdded native language description for Finnish Kalo\u001b[0m", "\t\u001b[32mAdded native language description for Finnish Kalo\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Akkala Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Akkala Sami\u001b[0m", "\t\u001b[32mAdded english language description for Akkala Sami\u001b[0m", "\t\u001b[32mAdded native language description for Akkala Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Kildin Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Kildin Sami\u001b[0m", "\t\u001b[32mAdded english language description for Kildin Sami\u001b[0m", "\t\u001b[32mAdded native language description for Kildin Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Ter Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Ter Sami\u001b[0m", "\t\u001b[32mAdded english language description for Ter Sami\u001b[0m", "\t\u001b[32mAdded native language description for Ter Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Pite Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Pite Sami\u001b[0m", "\t\u001b[32mAdded english language description for Pite Sami\u001b[0m", "\t\u001b[32mAdded native language description for Pite Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Kemi Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Kemi Sami\u001b[0m", "\t\u001b[32mAdded english language description for Kemi Sami\u001b[0m", "\t\u001b[32mAdded native language description for Kemi Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Ume Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Ume Sami\u001b[0m", "\t\u001b[32mAdded english language description for Ume Sami\u001b[0m", "\t\u001b[32mAdded native language description for Ume Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Southern Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Southern Sami\u001b[0m", "\t\u001b[32mAdded english language description for Southern Sami\u001b[0m", "\t\u001b[32mAdded native language description for Southern Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Northern Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Northern Sami\u001b[0m", "\t\u001b[32mAdded english language description for Northern Sami\u001b[0m", "\t\u001b[32mAdded native language description for Northern Sami\u001b[0m", "\t\u001b[32mAdded native language description for Northern Sami\u001b[0m", "\t\u001b[32mAdded native language description for Northern Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Sami languages\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Sami languages\u001b[0m", "\t\u001b[32mAdded english language description for Sami languages\u001b[0m", "\t\u001b[32mAdded native language description for Sami languages\u001b[0m", "\t\u001b[32mAdded native language description for Sami languages\u001b[0m", "\t\u001b[32mAdded native language description for Sami languages\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Lule Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Lule Sami\u001b[0m", "\t\u001b[32mAdded english language description for Lule Sami\u001b[0m", "\t\u001b[32mAdded native language description for Lule Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Inari Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Inari Sami\u001b[0m", "\t\u001b[32mAdded english language description for Inari Sami\u001b[0m", "\t\u001b[32mAdded native language description for Inari Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Skolt Sami\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Skolt Sami\u001b[0m", "\t\u001b[32mAdded english language description for Skolt Sami\u001b[0m", "\t\u001b[32mAdded native language description for Skolt Sami\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Somali\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Somali\u001b[0m", "\t\u001b[32mAdded english language description for Somali\u001b[0m", "\t\u001b[32mAdded native language description for Somali\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Sotho\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Sotho\u001b[0m", "\t\u001b[32mAdded english language description for Sotho\u001b[0m", "\t\u001b[32mAdded native language description for Sotho\u001b[0m", "\t\u001b[32mAdded language_subtag_registry for Votic\u001b[0m", "\t\u001b[32mAdded language_rfc4646_to_iso639 for Votic\u001b[0m", "\t\u001b[32mAdded english language description for Votic\u001b[0m", "\t\u001b[32mAdded native language description for Votic\u001b[0m", "\t\u001b[32mUpdated native lv language description from Latvija to Latviešu valoda\u001b[0m", "\t\u001b[32mUpdated native lt language description from Lietuvių to Lietuvių kalba\u001b[0m", "\t\u001b[32mAdded native language description for Ancient Greek\u001b[0m", "\t\u001b[32mAdded native language description for Esperanto\u001b[0m", "\t\u001b[32mAdded native language description for Sanskrit\u001b[0m", "\t\u001b[32mAdded native language description for Irish Gaelic\u001b[0m", "\t\u001b[32mAdded native language description for Bosnian\u001b[0m", "\t\u001b[32mAdded native language description for Kazakh\u001b[0m", "\t\u001b[32mAdded native language description of Standard Tibetan\u001b[0m", "\t\u001b[32mAdded native language description of Welsh\u001b[0m", "Upgrade to 24.06.00.005 [08:11:20]: Bug 35639 - Add the SMSSendMaxChar system preference to limit the number of characters in a SMS message", "\t\u001b[32mAdded new system preference 'SMSSendMaxChar'\u001b[0m", "Upgrade to 24.06.00.006 [08:11:20]: Bug 35597 - Add SuggestionsLog system preference ", "\t\u001b[32mAdded new system preference 'SuggestionsLog'\u001b[0m", "Upgrade to 24.06.00.007 [08:11:20]: Bug 36330 - Fix typo 'reseve' in COMMENTs for table course_items", "\t\u001b[32mComment for course_items.location was updated.\u001b[0m", "\t\u001b[32mComment for course_items.enabled was updated.\u001b[0m", "Upgrade to 24.06.00.008 [08:11:20]: Bug 35153 - Move IntranetmainUserblock to additional contents", "\t\u001b[32mRemoved system preference 'IntranetmainUserblock'\u001b[0m", "Upgrade to 24.06.00.009 [08:11:20]: Bug 33317 - Add new system preference OpacMetaRobots", "\t\u001b[32mAdded system preference 'OpacMetaRobots'\u001b[0m", "Upgrade to 24.06.00.010 [08:11:20]: Bug 34481 - Add IncludeSeeAlsoFromInSearches like IncludeSeeFromInSearches", "\t\u001b[32mAdded new system preference 'IncludeSeeAlsoFromInSearches'\u001b[0m", "Upgrade to 24.06.00.011 [08:11:20]: Bug 37216 - Ensure EmailFieldSelection options are correct", "\t\u001b[32mUpdated system preference 'EmailFieldSelection'\u001b[0m", "Upgrade to 24.06.00.012 [08:11:20]: Bug 26205 - Add new system preference OPACShowLibraries", "\t\u001b[32mAdded new system preference 'OPACShowLibraries'\u001b[0m", "Upgrade to 24.06.00.013 [08:11:20]: Bug 18317 - Allow check out of already checked out items through SIP", "\t\u001b[32mAdded new system preference 'AllowItemsOnLoanCheckoutSIP'\u001b[0m", "Upgrade to 24.06.00.014 [08:11:20]: Bug 33363 - Split suggestions_manage into three separate permissions for creating, updating, and deleting suggetions", "\t\u001b[32mAdded new permissions suggestions_create\u001b[0m", "\t\u001b[32mAdded new permissions suggestions_delete\u001b[0m", "\t\u001b[32mAdded new permissions suggestions_create to patrons with suggestions_manage\u001b[0m", "\t\u001b[32mAdded new permissions suggestions_delete to patrons with suggestions_manage\u001b[0m", "Upgrade to 24.06.00.015 [08:11:20]: Bug 36453 - Update BlockExpiredPatronOpacActions where 24.06.000.02 was already run", "\t\u001b[34mcategories.BlockExpiredPatronOpacActions already varchar(128)\u001b[0m", "Upgrade to 24.06.00.016 [08:11:20]: Bug 28924 - Adds columns to patron categories to allow category level values for the no issue charge sysprefs", "\t\u001b[32mAdded column 'noissuescharge' to categories\u001b[0m", "\t\u001b[32mAdded column 'noissueschargeguarantees' to categories\u001b[0m", "\t\u001b[32mAdded column 'noissueschargeguarantorswithguarantees' to categories\u001b[0m", "Upgrade to 24.06.00.017 [08:11:20]: Bug 13888 - 'Lists' permission should allow/disallow using the lists module in staff", "\t\u001b[32mAdded permission 'use_public_lists'\u001b[0m", "\t\u001b[32mAdded permission 'create_public_lists'\u001b[0m", "Upgrade to 24.06.00.018 [08:11:20]: Bug 29509 - Update users with list_borrowers permission where required", "\t\u001b[34mAdded permission 'list_borrowers' to 1 users with 'manage_bookings' permissions\u001b[0m", "Upgrade to 24.06.00.019 [08:11:20]: Bug 23781 - Recalls notices and messaging preferences", "\t\u001b[32mAdded recalls SMS notices: RETURN_RECALLED_ITEM, PICKUP_RECALLED_ITEM\u001b[0m", "\t\u001b[32mAdded message attributes for recalls: Recall_Waiting, Recall_Requested\u001b[0m", "\t\u001b[32mAdded message transports for recalls notices\u001b[0m", "Upgrade to 24.06.00.020 [08:11:20]: Bug 36996 - Add z3950Status system preference", "\t\u001b[32mAdded new system preference 'Z3950Status'\u001b[0m", "Upgrade to 24.06.00.021 [08:11:20]: Bug 35539 - Remove unused columns from 'categories' table", "\t\u001b[34mRemoved 'bulk' column from 'categories' table\u001b[0m", "\t\u001b[34mRemoved 'finetype' column from 'categories' table\u001b[0m", "\t\u001b[34mRemoved 'issuelimit' column from 'categories' table\u001b[0m", "Upgrade to 24.06.00.022 [08:11:20]: Bug 37419 - Replace FK constraint to avoid data loss", "\t\u001b[32mUpdated foreign key 'biblio_metadata.record_metadata_fk_2'\u001b[0m", "Upgrade to 24.06.00.023 [08:11:21]: Bug 36757 - Notify assignee when a concern is assigned to them", "\t\u001b[32mAdded notice 'TICKET_ASSIGNED'\u001b[0m", "Upgrade to 24.06.00.024 [08:11:21]: Bug 35044 - Add repeatable option to additional_fields", "\t\u001b[32mAdded repeatable column to additional_fields table\u001b[0m", "\t\u001b[32mRemoved UNIQUE KEY `field_record` (`field_id`,`record_id`) from the additional_field_values table\u001b[0m", "Upgrade to 24.06.00.025 [08:11:21]: Bug 26777 - Adds new system preferences 'OPACVirtualCard and 'OPACVirtualCardBarcode'", "\t\u001b[32mAdded new system preference 'OPACVirtualCard'\u001b[0m", "\t\u001b[32mAdded new system preference 'OPACVirtualCardBarcode'\u001b[0m", "Upgrade to 24.06.00.026 [08:11:21]: Bug 20411 - Remove StaffDetailItemSelection system preference", "\t\u001b[32mRemoved system preference 'StaffDetailItemSelection'\u001b[0m", "Upgrade to 24.06.00.027 [08:11:21]: Bug 27490 - Change language syspref to StaffInterfaceLanguages", "\t\u001b[32mUpdated system preference 'language' to 'StaffInterfaceLanguages'\u001b[0m", "Upgrade to 24.06.00.028 [08:11:21]: Bug 37757 - More robust handling of EmailFieldPrimary system preference values", "\t\u001b[32mUpdated system preference 'EmailFieldPrimary'\u001b[0m", "Upgrade to 24.06.00.029 [08:11:21]: Bug 37592 - Add creation_date, modification_date fields to bookings table", "\t\u001b[32mAdded column 'bookings.creation_date'\u001b[0m", "\t\u001b[32mAdded column 'bookings.modification_date'\u001b[0m", "Upgrade to 24.06.00.030 [08:11:21]: Bug 37601 - Add status column to bookings table", "\t\u001b[32mAdded column 'bookings.status'\u001b[0m", "Upgrade to 24.06.00.031 [08:11:21]: Bug 23685 - Add system preferences ReportsExportFormatODS and ReportsExportLimit", "\t\u001b[32mAdded new system preferences 'ReportsExportFormatODS' and 'ReportsExportLimit'\u001b[0m", "Upgrade to 24.06.00.032 [08:11:21]: Bug 37856 - Add column 'erm_usage_data_providers.service_platform'", "\t\u001b[32mAdded column 'service_platformerm_usage_data_providers'\u001b[0m", "Upgrade to 24.06.00.033 [08:11:21]: Bug 35655 - Add a way to disable RabbitMQ", "\t\u001b[32mAdded new system preference 'JobsNotificationMethod'\u001b[0m", "Upgrade to 24.06.00.034 [08:11:21]: Bug 37967 - Add auto renewal message_transport for phone", "\t\u001b[32mAdded phone messaging transports for auto-renewals\u001b[0m", "Upgrade to 24.06.00.035 [08:11:21]: Bug 37446 - Fix holdingbranch and homebranch facet labels", "\tUpdated search field configuration for holdingbranch and homebranch", "Upgrade to 24.06.00.036 [08:11:21]: Bug 37954 - Move holdings_barcodes setting to holdings_barcode", "\t\u001b[34mNo settings for holdings_barcodes found\u001b[0m", "\tRemoved settings for holdings_barcodes", "Upgrade to 24.06.00.037 [08:11:21]: Bug 36798 - Add 'SearchCancelledAndInvalidISBNandISSN' preference", "\t\u001b[32mAdded new system preference 'SearchCancelledAndInvalidISBNandISSN'\u001b[0m", "Upgrade to 24.06.00.038 [08:11:21]: Bug 36766 - Add command-line utility to SFTP a file to a remote server", "\t\u001b[32mAdded new sample notices 'SFTP_FAILURE' and 'SFTP_SUCCESS'\u001b[0m", "Upgrade to 24.06.00.039 [08:11:21]: Bug 28575 - Add a system preference to prevent refunds on lost items if the fee was paid more than a set number of days ago", "\t\u001b[32mAdded new system preference 'NoRefundOnLostFinesPaidAge'\u001b[0m", "Upgrade to 24.06.00.040 [08:11:21]: Bug 23295 - Automatically debar patrons if SMS or email notice fail", "\t\u001b[32mAdded new system preference 'RestrictPatronsWithFailedNotices'\u001b[0m", "\t\u001b[32mAdded new system restriction type 'NOTICE_FAILURE_SUSPENSION'\u001b[0m", "Upgrade to 24.06.00.041 [08:11:21]: Bug 30955 - Move existing list notices to new lists category", "\t\u001b[32mMoved SHARE_ACCEPT notice to lists module\u001b[0m", "\t\u001b[32mMoved SHARE_INVITE notice to lists module\u001b[0m", "\t\u001b[32mMoved LIST notice to lists module\u001b[0m", "Upgrade to 24.06.00.042 [08:11:21]: Bug 37969 - Add nor language code", "\t\u001b[32mAdded nor language code\u001b[0m", "Upgrade to 24.06.00.043 [08:11:21]: Bug 38193 - Add cancellation_reason field to bookings table", "\t\u001b[32mAdded column 'bookings.cancellation_reason'\u001b[0m", "Upgrade to 24.06.00.044 [08:11:21]: Bug 28833 - Speed up holds queue builder via parallel processing", "\t\u001b[32mAdded new system preference 'HoldsQueueParallelLoopsCount'\u001b[0m", "Upgrade to 24.06.00.045 [08:11:21]: Bug 35906 - Add bookable column on itemtypes table", "\t\u001b[32mAdded column 'itemtypes.bookable'\u001b[0m", "\t\u001b[32mUpdated column 'items.bookable' allow nullable\u001b[0m", "\t\u001b[32mUpdated column 'deleteditems.bookable' allow nullable\u001b[0m", "Upgrade to 24.06.00.046 [08:11:21]: Bug 38222 - Add cancellation reasons to bookings", "\t\u001b[32mAdded new authorized value category 'BOOKING_CANCELLATION'\u001b[0m", "Upgrade to 24.06.00.047 [08:11:21]: Bug 35659 - OAI-PMH harvester", "\t\u001b[32mAdded new table 'oai_servers'\u001b[0m", "\t\u001b[32mAdded new table 'import_oai_biblios'\u001b[0m", "\t\u001b[32mAdded new table 'import_oai_authorities'\u001b[0m", "\t\u001b[32mAdded new system preference 'OAI-PMH:HarvestEmailReport'\u001b[0m", "\t\u001b[32mAdded OAI_HARVEST_REPORT letter\u001b[0m", "Upgrade to 24.06.00.048 [08:11:21]: Bug 33484 - Add state save as an option to datatables", "\t\u001b[32mAdded column 'tables_settings.default_save_state'\u001b[0m", "\t\u001b[32mAdded column 'tables_settings.default_save_state_search'\u001b[0m", "Upgrade to 24.06.00.049 [08:11:21]: Bug 38274 - Fix typo in Arabic language description", "\t\u001b[32mUpdated Arabic language description\u001b[0m", "Upgrade to 24.06.00.050 [08:11:21]: Bug 30648 - Store biblionumber of deleted records in old_reserves", "\t\u001b[32mAdded column 'reserves.deleted_biblionumber'\u001b[0m", "\t\u001b[32mAdded column 'old_reserves.deleted_biblionumber'\u001b[0m", "Upgrade to 24.06.00.051 [08:11:21]: Bug 14180 - Add system preference AlwaysLoadCheckoutsTable", "\t\u001b[32mAdded new system preference 'AlwaysLoadCheckoutsTable'\u001b[0m", "Upgrade to 24.06.00.052 [08:11:21]: Bug 35305 - Add XSLT for authority details display in staff interface", "\t\u001b[32mAdded new system preference 'AuthorityXSLTDetailsDisplay'\u001b[0m", "Upgrade to 24.06.00.053 [08:11:21]: Bug 37511 - Add a new column p_cs_precedes to the table currency", "\t\u001b[32mAdded column 'currency.p_cs_precedes'\u001b[0m", "Upgrade to 24.06.00.054 [08:11:21]: Bug 35570 - Update 'FreeForm' ILL backend to 'Standard'", "Upgrade to 24.06.00.055 [08:11:21]: Bug 33462 - Force password reset for new patrons entered by staff", "\t\u001b[32mAdded new system preference 'ForcePasswordResetWhenSetByStaff'\u001b[0m", "\t\u001b[32mAdded column 'categories.force_password_reset_when_set_by_staff'\u001b[0m", "Upgrade to 24.06.00.056 [08:11:21]: Bug 36822 - Sanitize borrowers.updated_on", "Upgrade to 24.06.00.057 [08:11:21]: Bug 22421 - Add issue constraints to accountlines", "\t\u001b[32mAdded column 'accountlines.old_issue_id'\u001b[0m", "\t\u001b[32mAdded constraint 'accountlines.old_issues'\u001b[0m", "\t\u001b[32mUpdated 'accountlines.old_issue_id' from 'old_issues'\u001b[0m", "\t\u001b[32mFixed 'accountlines.issue_id' where missing from issues\u001b[0m", "\t\u001b[32mAdded constraint 'accountlines.issues'\u001b[0m", "\t\u001b[32mAdded old_issue_id to accountlines and set up appropriate constraints)\u001b[0m", "Upgrade to 24.06.00.058 [08:11:22]: Bug 28633 - Add preferred_name to borrowers table", "\t\u001b[32mAdded column 'borrowers.preferred_name'\u001b[0m", "\t\u001b[32mAdded column 'deletedborrowers.preferred_name'\u001b[0m", "\t\u001b[32mAdded column 'borrower_modifications.preferred_name'\u001b[0m", "\t\u001b[34mAdded 'preferred_name' to DefaultPatronSearchFields\u001b[0m", "\t\u001b[32mInitially set 'preferred_name' to 'firstname'\u001b[0m", "Upgrade to 24.06.00.059 [08:11:22]: Bug 37221 - Add new system preference OPACOverDrive", "\t\u001b[32mAdded new system preference 'OPACOverDrive'\u001b[0m", "Upgrade to 24.06.00.060 [08:11:22]: Bug 33766 - Add system preference to determine label of userid input on login form", "\t\u001b[32mAdded new system preference 'OPACLoginLabelTextContent'\u001b[0m", "Upgrade to 24.06.00.061 [08:11:22]: Bug 38011 - Add missing foreign key to subscription table", "\t\u001b[32mAdded new foreign key 'subscription_ibfk_4'\u001b[0m", "Upgrade to 24.06.00.062 [08:11:22]: Bug 34355 - Add a table to allow creation of MARC order accounts and a system preference to activate it", "\t\u001b[32mAdded new table 'marc_order_accounts'\u001b[0m", "\t\u001b[32mAdded new system preference 'MarcOrderingAutomation'\u001b[0m", "\t\u001b[32mAdded new permission 'marc_order_manage'\u001b[0m", "Upgrade to 24.06.00.063 [08:11:22]: Bug 33641 - Added issues.checkin_library and old_issues.checkin_library", "\t\u001b[32mAdded column 'issues.checkin_library'\u001b[0m", "\t\u001b[32mAdded column 'old_issues.checkin_library'\u001b[0m", "Upgrade to 24.06.00.064 [08:11:22]: Bug 38436 - Adjust column names for holdings tables in the table settings", "\t\u001b[32mColumn names renamed\u001b[0m", "Upgrade to 24.11.00.000 [08:11:22]: Koha 24.11.00 release", "Upgrade to 24.12.00.000 [08:11:22]: Increase DBRev for 24.12", "\t🚧 Let's do this.", "Upgrade to 24.12.00.001 [08:11:22]: Bug 38522 - Increase erm_agreements.license_info length", "\t\u001b[32mUpdated erm_agreements.license_info to mediumtext.\u001b[0m", "Upgrade to 24.12.00.002 [08:11:22]: Bug 37292 - Add index on 'oauth_access_tokens.expires'", "\t\u001b[32mAdded index on 'oauth_access_tokens.expires'\u001b[0m", "Upgrade to 24.12.00.003 [08:11:22]: Bug 33268 - Add rules to preserve current MARC record overlay rules behavior", "\t\u001b[32mAdded record overlay rules to preserve current behavior\u001b[0m", "Upgrade to 24.12.00.004 [08:11:22]: Bug 35154 - Move StaffLoginInstructions to additional contents", "\t\u001b[32mRemoved system preference 'StaffLoginInstructions'\u001b[0m", "Upgrade to 24.12.00.005 [08:11:22]: Bug 35152 - Move RoutingListNote to additional contents", "\t\u001b[32mAdded 'RoutingListNote' HTML customization\u001b[0m", "\t\u001b[32mRemoved system preference 'RoutingListNote'\u001b[0m", "Upgrade to 24.12.00.006 [08:11:22]: Bug 38794 - Update description of authorized value AggregatedFullText", "\t\u001b[32mUpdated description of authorized value AggregatedFullText\u001b[0m", "Upgrade to 24.12.00.007 [08:11:22]: Bug 30300 - Add 'patron expiry' to messaging preferences", "\t\u001b[32mMessage attribute 'Patron_Expiry' added\u001b[0m", "\t\u001b[32mMEMBERSHIP_EXPIRY added to message_transports\u001b[0m", "Upgrade to 24.12.00.008 [08:11:22]: Bug 35028 - Add system preference 'PatronSelfRegistrationAlert'", "\t\u001b[32mAdded new system preference 'PatronSelfRegistrationAlert'\u001b[0m", "Upgrade to 24.12.00.009 [08:11:22]: Bug 36954 - Adjustment for logfiles in koha-sip", "\t\u001b[33mIMPORTANT: If you use SIP, please edit your /etc/koha/sites/[CLONE]/log4perl.conf at upgrade time.\u001b[0m", "\t\u001b[33mReplace sip.log there by sip-output.log.\u001b[0m", "Upgrade to 24.12.00.010 [08:11:22]: Bug 35635 - Add opac_mandatory column to borrower_attribute_type table", "\t\u001b[32mModified column 'borrower_attribute_types.mandatory'\u001b[0m", "\t\u001b[32mAdded column 'borrower_attribute_types.opac_mandatory'\u001b[0m", "\t\u001b[32mUpdate opac_mandatory to match mandatory column\u001b[0m", "Upgrade to 24.12.00.011 [08:11:22]: Bug 26684 - Drop marc column from auth_header", "\t\u001b[32mRemoved column 'auth_header.marc'\u001b[0m", "Upgrade to 24.12.00.012 [08:11:22]: Bug 30888 - Add table deletedauth_header", "\t\u001b[32mAdded new table 'deletedauth_header'\u001b[0m", "Upgrade to 24.12.00.013 [08:11:22]: Bug 38689 - Add edifact_errors table to record edifact error messages", "\t\u001b[32mAdded new table 'edifect_errors'\u001b[0m", "Upgrade to 24.12.00.014 [08:11:22]: Bug 38108 - Add AlwaysShowHoldingsTableFilters system preference", "\t\u001b[32mAdded new system preference 'AlwaysShowHoldingsTableFilters'\u001b[0m", "Upgrade to 24.12.00.015 [08:11:22]: Bug 39075 - Follow up for bug 34587 to fix incorrect default values for timestamps", "\t\u001b[32mSuccessfully corrected incorrect default value for 'erm_counter_files.date_uploaded\u001b[0m", "\t\u001b[32mSuccessfully corrected incorrect default value for 'erm_counter_logs.importdate\u001b[0m", "Upgrade to 24.12.00.016 [08:11:22]: Bug 36833 - Add German translations for new languages", "\t\u001b[32mAdded German translations for new languages\u001b[0m", "\t\u001b[32mUpdated German translation for Latin\u001b[0m", "Upgrade to 24.12.00.017 [08:11:22]: Bug 32630 - Don't delete illrequests when borrower is deleted", "\t\u001b[32mUpdated borrowernumber constraint on illrequests table\u001b[0m", "Upgrade to 24.12.00.018 [08:11:22]: Bug 38663 - Add additional fields to libraries", "\t\u001b[34mConverting record_id from int(11) to VARCHAR(11)...", "\t\u001b[0m", "\t\u001b[31mERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN new_record_id TO record_id' at line 1 at /kohadevbox/koha/C4/Installer.pm line 771", "\t\u001b[0m", "DEV atomic update /kohadevbox/koha/installer/data/mysql/atomicupdate/bug-38136.pl [08:11:22]: Bug 38136 - Add localization.property", "\t\u001b[32mAdded column localization.property and updated localization.entity values\u001b[0m"]} NO MORE HOSTS LEFT ************************************************************* PLAY RECAP ********************************************************************* localhost : ok=42 changed=32 unreachable=0 failed=1 skipped=5 rescued=0 ignored=1