Time Nick Message 01:03 huginn News from kohagit: Bug 29077: (follow-up) Use another syntax <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=05fd2369f01a4d787af25dc41a8c00e6a0597345> 01:03 huginn News from kohagit: Bug 30072: (followup) Fix random failure of Holds_hooks.t <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=763bfaa55b3391c1927b6e81482d7bc32f3a4351> 01:03 huginn News from kohagit: Bug 30482: Potential for bad string concatenation in cataloging validation error... <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=545922e4cbde833494155a25382e23ff8f59e7e3> 01:03 huginn News from kohagit: Bug 30224: Show correct important field in cataloguing validation <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0ba9d950988522d9242b2c7ef251780c02bb1fd0> 01:03 huginn News from kohagit: Bug 29077: Remove blank indexes before convert <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8bb51dccb09722bde33b34ca5fa24f3181799454> 01:15 alohabot 🎠🦄 Koha 'master' packages pushed to 'koha-staging' repo ðŸŽðŸ¥—🿠01:44 koha-jenkins Yippee, build fixed! 01:44 koha-jenkins Project Koha_Master_D9 build #1941: FIXED in 40 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1941/ 01:44 wahanui Congratulations! 01:47 koha-jenkins Project Koha_Master_D11_My8 build #808: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_Master_D11_My8/808/ 02:04 koha-jenkins Project Koha_Master_U20 build #378: SUCCESS in 1 hr 0 min: https://jenkins.koha-community.org/job/Koha_Master_U20/378/ 02:06 koha-jenkins Yippee, build fixed! 02:06 koha-jenkins Project Koha_Master_D10 build #621: FIXED in 56 min: https://jenkins.koha-community.org/job/Koha_Master_D10/621/ 02:06 wahanui Congratulations! 02:23 koha-jenkins Yippee, build fixed! 02:23 koha-jenkins Project Koha_Master_D11_MDB_Latest build #881: FIXED in 38 min: https://jenkins.koha-community.org/job/Koha_Master_D11_MDB_Latest/881/ 02:23 wahanui Congratulations! 02:33 koha-jenkins Project Koha_Master_U22 build #33: UNSTABLE in 46 min: https://jenkins.koha-community.org/job/Koha_Master_U22/33/ 03:14 koha-jenkins Project Koha_Master build #1998: STILL UNSTABLE in 1 hr 8 min: https://jenkins.koha-community.org/job/Koha_Master/1998/ 03:18 koha-jenkins Project Koha_Master_D11_MDB_Latest build #882: SUCCESS in 54 min: https://jenkins.koha-community.org/job/Koha_Master_D11_MDB_Latest/882/ 05:51 reiveune hello 06:43 alex_ Bonjour 07:52 magnuse_ \o/ 08:23 severine_q Bonjour Koha ! 08:26 nlegrand Coucou #Koha 08:31 magnuse_ trying to upgrade from 20.11.06-1 to 21.11.04-2 i stumble on this: "Upgrade to 21.06.00.016 [10:17:13]: Bug 24387 - Rename opac_news with additional_contents ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table 'additional_contents' already exists at /usr/share/koha/lib/C4/Installer.pm line 738" anyone else seen that? 08:31 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24387 enhancement, P5 - low, ---, jonathan.druart+koha, RESOLVED FIXED, Rename News tool 08:33 triveni hi all 08:33 triveni i need help on koha server 08:34 triveni lot of processing runing background. how to stop this 08:34 triveni www-data 3279733 3279732 5 14:00 ? 00:00:03 /usr/bin/perl /home/ubuntu/kohaclone/opac/opac-search.pl www-data 3279769 3279768 5 14:00 ? 00:00:03 /usr/bin/perl /home/ubuntu/kohaclone/opac/opac-search.pl www-data 3279825 3279824 4 14:01 ? 00:00:02 /usr/bin/perl /home/ubuntu/kohaclone/opac/opac-search.pl www-data 3279836 3279835 5 14:01 ? 00:00:02 /usr/bin/perl /home/ubuntu/kohaclone/opac/opac-search.pl www-data 3279839 3279838 08:37 magnuse_ i am copying the db from a 20.11.06-1 install to a 21.11.04-2, then running koha-upgrade-schema. the db on the 20.11.06-1 system does not have the 'additional_contents' table... 08:44 nlegrand triveni: what is the state of the processes? 08:45 nlegrand Also, if you have a lot of searches, it's normal to see a lot of search processes. It's not normal if they last a long time. 08:50 fridolin nlegrand: for my info, BULAC is planning on upgrading to 21.11 ? 08:50 fridolin you have 20.11 rigth ? 08:50 triveni we have multiple client in server 08:56 triveni please need help on this 08:59 severine_q yes fridolin, we plan to updrage 20.11 > 21.11 at the end of may 09:01 fridolin ah great, we will start testing that in end may 09:02 fridolin no big surprise from what we started to test 09:03 severine_q good to know ! 09:05 fridolin Dont forget to adapt imports if you have homemade perl, see Bug 17600 09:05 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 enhancement, P5 - low, ---, jonathan.druart+koha, RESOLVED FIXED, Standardize the EXPORT 09:13 magnuse_ fridolin: i have a problem upgrading from 20.11.06-1 to 21.11.04-2, see above 09:13 magnuse_ no idea what is happening 09:14 magnuse_ after the failed upgrade, the database has both opac_news and 'additional_contents' 09:17 fridolin magnuse_: ah strange because there is : if( TableExists('opac_news') ) 09:18 magnuse_ true, very strange 09:18 fridolin table additional_contents should not exist in 20.11.06 09:21 magnuse_ if i comment out "if( TableExists('opac_news') )" at the top and the "ADD UNIQUE KEY additional_contents_uniq" part at the bottom of the db_rev file, it seems to work 09:22 magnuse_ yeah, the db on the 20.11.06 does not have additional_contents 09:56 oleonard Hi #koha 10:22 tcohen hola #koha 10:25 tcohen @seen Joubu 10:25 huginn tcohen: Joubu was last seen in #koha 4 days, 20 hours, 38 minutes, and 14 seconds ago: <Joubu> @later tell marcelr Use of uninitialized value in string eq at /kohadevbox/koha/C4/Context.pm line 784 10:27 Joubu hola Tomas 10:30 tcohen I want to work on QA for bug 27344 10:30 tcohen should I pick the remote branch? 10:30 tcohen bug 27344 10:31 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27344 enhancement, P5 - low, ---, jonathan.druart+koha, Needs Signoff , Implement Elastic's update_index_background using Koha::BackgroundJob 10:37 Joubu tcohen: yes, I think so 10:42 tcohen it needs a rebase... 10:46 enkidu Hi all 10:48 enkidu I guess, koha-run-backups script works incorrectly and delete the files after doing backups, does anyone has an doubt about this? 10:52 tcohen enkidu: that's not how koha-run-backups works 10:52 tcohen it should be rotating the backups 10:54 enkidu tcohen: it should keep backups for at least xx days written in script by parameter --days 10:54 Joubu tcohen: rebased 10:54 tcohen enkidu: yes, I'm familiar with the script 10:55 enkidu I've seen the files in the directory but it is being deleted after work finished 10:55 tcohen thanks Joubu 10:55 tcohen enkidu: is this in production or a dev env? 10:55 tcohen how can I try to reproducE? 10:56 tcohen which exact command are you running on which Koha version? 10:56 enkidu it is in the production 10:56 enkidu 21.11.04 10:56 enkidu You should delete or remove all backup files first, to different location 10:57 enkidu I've tried with almost empty directory 10:57 cait me waves 10:58 tcohen koha-run-backups has been modified last time on November 2020 10:59 enkidu koha-run-backups --days 2 --output /var/spool/koha 11:01 tcohen https://snipboard.io/ebNr9p.jpg 11:01 tcohen I think you are right 11:02 tcohen please file a bug 11:02 tcohen and provide a patch 11:02 tcohen haha 11:02 enkidu ahaha 11:02 tcohen <.< 11:02 enkidu let me create the bug I'll also look at the script 11:03 tcohen keep in mind that it hasn't changed for a while 11:03 tcohen which means maybe it is another piece of the puzzle 11:12 enkidu Bug is ready :) but not yet the solution https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30627 11:12 huginn Bug 30627: normal, P5 - low, ---, koha-bugs, NEW , koha-run-backups delete the backup files after finished its job without caring days option 11:13 cait hm, looks like someone filled pu the queue again... 11:13 cait from 15 to 26 again... 11:13 tcohen cait: that's a never ending game anyways 11:14 tcohen and the patron search change is probably needing many follow-ups 11:14 tcohen so, expected 11:37 cait tcohen: I know the game, just like to complain sometimes anyways :) 11:51 enkidu tcohen: I got the issue and put some info into bug 30627. 11:51 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30627 normal, P5 - low, ---, koha-bugs, NEW , koha-run-backups delete the backup files after finished its job without caring days option 11:52 enkidu If somehow there are some other backup files script count also them and delete the backup files 11:53 magnuse_ phew, looks like the upgrade to 21.11.04-2 is working nicely on another test server 12:13 magnuse_ well, akshuly, i'm not seeing the problem with additional_contents, but now i get this: Upgrade to 21.11.02.003 [13:58:57]: Bug 29605 - Resync DB structure for existing installations 12:13 magnuse_ ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'yi' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 738 12:13 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29605 major, P5 - low, ---, jonathan.druart+koha, RESOLVED FIXED, DB structure may not be synced with kohastructure.sql 12:15 cait that's the patch that edded yiddish language i tihnk 12:21 magnuse_ i do have two "yi | Hebr" in language_script_mapping 12:21 cait not sure why, but maybe becuase of a backport it could have been added twice? 12:27 tcohen my atomicupdate was aware of that possibility 12:28 tcohen well, it does an INSERT IGNORE 12:28 tcohen but there was the problem there was no constraint 12:29 tcohen we should make it remove duplicates before 29605 is applied 12:31 cait ... I am back on preferred name - 28633 12:31 cait i think that is the issue, the constraint was only added later 12:33 cait hm 12:33 cait Joubu: did you test that Koha/Database/Columns.pm will be translated? 12:33 cait 12:33 cait to my knowledge .pl and .pm are not parsed - but I might be worng 12:34 cait "initials" => __("Initials") 12:34 tcohen cait: about yiddish: sort of 12:34 tcohen bug 29605 was actually a dependency for it 12:34 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29605 major, P5 - low, ---, jonathan.druart+koha, RESOLVED FIXED, DB structure may not be synced with kohastructure.sql 12:34 cait backports? 12:34 wahanui backports are starting to get a bit more involved too now. These filters are driving me nuts, hehe 12:34 tcohen so maybe the problem is it got backported without the DB structure change 12:35 cait Joubu: ok, I see that was part of the test plan, so I believe they will show up in po :) 12:55 cait hm ok, this is odd 12:55 cait error: The following untracked working tree files would be overwritten by checkout: 12:55 cait api/v1/swagger/parameters/import_record_match.json 12:55 cait api/v1/swagger/parameters/import_record_match.yaml 12:55 cait Please move or remove them before you switch branches. 12:55 cait but they don't show in git status 12:55 cait i tried a git reset --hard origin/master 12:55 cait and a git clean -f 12:55 cait and they are still... there? 12:57 magnuse_ my quickfix for the upgrade: for i in $( sudo koha-list --enabled ) ; do echo "DELETE FROM language_script_mapping WHERE language_subtag = 'yi'; INSERT INTO language_script_mapping SET language_subtag = 'yi', script_subtag = 'Hebr';" | sudo koha-mysql $i ; done 13:19 magnuse_ i was today years old when i learned about "$ who mom likes" 13:21 oleonard ?? 13:23 ashimema lol 13:23 * ashimema likes 'who like cookies' ;) 13:24 ashimema the who command on linux oleonard 13:24 ashimema used to say who you are connected as 13:24 ashimema it's often used as 'who am i' 13:24 ashimema but you can actually use any two strings to get the same result and 'who mom likes' became a thing 13:26 oleonard my mom doesn't like anyone I guess 13:30 oleonard Here's what I'm thinking for copying patron permissions: 13:30 oleonard https://snipboard.io/0aB8u7.jpg 13:30 oleonard You click "Copy settings" on the source patron and then open the target patron and click "Paste settings." 13:30 oleonard Is that too convoluted? 13:31 ashimema i like it 13:31 ashimema have you played with the bywater plugins in this area oleonard? 13:31 oleonard No but I should 13:32 oleonard I honestly had no idea there were so many plugins now. 13:33 ashimema https://github.com/bywatersolutions/koha-plugin-batch-permissions-modifier 13:33 ashimema it would be lovely to have some of that functionality in core 13:34 oleonard (always the risk of having plugin capability) 13:34 ashimema yup 13:34 ashimema I've been meaning to put that stuff in core for ages.. but as always.. there's never enough time 13:36 oleonard Does Koha have some kind of plugin template in core? 13:37 ashimema hmm 13:37 ashimema not really in core as such 13:37 ashimema bywater maintain the kitchen-sink plugin as an example one though 13:40 oleonard I wonder if it wouldn't be a good idea... A central place where things like template... uh templates, could go. 13:40 oleonard Just idly thinking. 14:02 ashimema yup 14:02 ashimema gitlab has some things too 14:02 ashimema I'd like to see some community maintained plugins too.. one's we adopt 14:49 * cait waves again 14:50 Joubu @later tell fridolin there are more patches on bug 30373. I haven't had the time to test them yet but I think you should push them anyway (it will be easier to test them) 14:50 huginn Joubu: The operation succeeded. 14:52 Joubu @later tell fridolin we will need https://gitlab.com/koha-community/koha-misc4dev/-/merge_requests/52 as well, I tested it last week and no regression found so far (at least for marc21) 14:52 huginn Joubu: The operation succeeded. 14:52 Joubu ashimema, tcohen: ^ 14:53 ashimema excellent 14:53 wahanui darn tootin' it is. 15:04 reiveune bye 15:12 cait could someone take over bug 22785 in QA? 15:12 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22785 enhancement, P5 - low, ---, nick, Signed Off , Manage matches when importing through stage MARC record import 15:36 cait oleonard: what's your opinion on bug 30622 - cardnumber/userid fo rall patron searches as direct link? 15:36 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30622 major, P5 - low, ---, jonathan.druart+koha, Needs Signoff , Search for cardnumber needs to go directly to patron record when placing a hold 15:38 oleonard I think it is the expected behavior to have a redirect when a single result is found. 15:39 cait the problem is I think it did a contains search 15:39 cait instead if the previous: if there is an exact match ... 15:39 oleonard I don't understand 15:41 cait hm maybe you are right 15:41 cait say you have a cardnumber 42 and a cardnumber 4242 15:41 cait you scan the card 15:41 cait it will go to a list of those 2 15:42 cait instead of opening the patron account 15:42 cait if you have used the feature for autocardnumber with a low start number that could be pretty annoying/long lists 15:44 ashimema oh... 15:45 cait I am just doing some testing in 20.11 to see the old behavior 15:53 oleonard Focus no longer moves to the "Check out" form field when switching to the tab in the header search form. 15:54 cait all the small things 16:04 cait Joubu: working on 29648 - as promised 16:57 oleonard Interesting. An open JQuery bug: "You cannot programmatically focus an element after you have attempted to focus it while it was hidden" 16:57 cait my brain refuses to parset hat 16:58 oleonard If I can find a workaround you won't have to. 16:58 cait that sounds good :) 17:10 tcohen back 17:14 tcohen oleonard: around? 17:14 oleonard Yes 17:15 tcohen if I wanted to tweak Koha's style for a specific library 17:15 tcohen the ideal solution would be to have a custom opac.scss file, right? 17:15 tcohen and rebuild? 17:15 tcohen or should all be done on top of stock Koha's 17:20 ashimema we nearly always use OPACUserCSS to overload things.. very rarely do we use oapc.css 17:22 oleonard We use OpacAdditionalStylesheet. 17:23 oleonard I prefer that over OPACUserCSS because it is a cache-able file rather than additional markup on each page. 17:24 ashimema that's a good point 17:25 oleonard Not ideal if the library wants to do a lot of tweaking and they don't have web storage somewhere. 17:38 cait opacusercss mostly, apart from a few bigger projects 17:44 ashimema bug 30387 is interesting.. I'm sure I've come accross this before and got told it was a feature rather than a bug? 17:44 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30387 normal, P5 - low, ---, lucas, Signed Off , IndependentBranches allows users to change libraries when they should not be able to 17:44 * ashimema dissapears again 17:51 oleonard this form focus thing is kicking my butt. 17:59 * cait sends oleonard cookies and also disappears 17:59 cait back tomorrow