IRC log for #koha, 2022-06-29

All times shown according to UTC.

Time S Nick Message
00:03 nugged seems it is.
00:05 nugged this is missing: https://github.com/NatLibFi/Ko[…]0a951d6b381725cee
01:45 wajasu opac Did you mean: <span>Search also for broader subjects</span> ... showing in my ktd
01:46 wajasu ./koha-tmpl/opac-tmpl/bootstrap/​en/modules/text/explodedterms.tt
01:46 wajasu wonders why <span> shows.
01:47 wajasu koha version 22.06.00.008
02:22 wajasu if I run: ktd up -d  while one is running, will I get another set of instances ie. koha-koha-2 or will it collide
02:25 davidnind[m] I just tried starting another one with the current one I have running - you get error messages, and the current one running crashes for me
02:25 davidnind[m] you then have to kd twice
02:26 davidnind[m] actually you only need to kd once
02:27 davidnind[m] for your opac span - I think that might be an error - I can't replicate as I'm not sure how to enable the "Did you mean"
02:27 davidnind[m] (I'm still using the old shortcuts, haven't tested or changed to the new way yet...)
06:54 reiveune joined #koha
06:54 liliputech joined #koha
06:54 fridolin joined #koha
06:57 m23 joined #koha
07:00 alex_ joined #koha
07:01 alex_ joined #koha
07:07 cait1 joined #koha
07:07 cait1 good morning #koha
07:07 dcook Morning morning
07:07 dcook Question... does anyone have Chinese, Japanese, or Korean printing in their label creator?
07:07 dcook Or rather... a mix of English and Chinese?
07:07 dcook It's looking kind of impossible to me...
07:07 cait1 hm i did test once with arabic, but it's been a longer time
07:08 cait1 i think it just depends on the fonts you use?
07:08 dcook Yeah it looks liek it
07:08 dcook I can't find a font file that supports both English and Chinese
07:08 dcook It seems like Latin, Greek, Cyrillic OR CJK
07:08 dcook Not an issue for single language libraries but harder for multilingual ones
07:10 dcook I think we might go with https://github.com/bywatersolu[…]lugin-label-maker
07:10 dcook The Label Creator is really begging for a makeover/replacement...
07:11 cait1 hm
07:19 cait1 you can always volunteer ;)
07:20 cait1 is there any documentation for the koha-plugin-label-maker?
07:23 fridolin the code ^^
07:33 cait1 found 2 videos ;)
07:33 cait1 another question: someone aware of a value builde for validating data? giving feedback on your input
07:39 cait1 I have done generator plugins that populates the field, but nothing die other way around
07:47 dcook cait1: I'm already working late tonight O_O
08:00 ashimema Morning #koha
08:00 ashimema Evening dcook
08:02 dcook hola
08:02 wahanui hello, dcook
08:24 liliputech morning
09:02 magnuse \o/
09:10 koha-jenkins Yippee, build fixed!
09:10 koha-jenkins Project Koha_21.11_D12 build #92: FIXED in 35 min: https://jenkins.koha-community[…]oha_21.11_D12/92/
09:10 wahanui Congratulations!
09:12 liliputech \o/
09:15 FlorianB joined #koha
09:18 FlorianB Hello! Got another permission related question here.
09:18 FlorianB If a user has the, let's say, CAN_user_tools_moderate_tags permission at 1; would a more general [% IF ( CAN_user_tools ) %] return true?
09:19 koha-jenkins Yippee, build fixed!
09:19 koha-jenkins Project Koha_21.11_D9 build #99: FIXED in 44 min: https://jenkins.koha-community[…]Koha_21.11_D9/99/
09:19 wahanui Congratulations!
09:21 alohabot 🎁 🐷 Koha '21.11.x' packages pushed to 'koha-staging' repo  ðŸœðŸªðŸŒ¯
09:21 Joubu FlorianB: no, you need the whole permission "tools" to have CAN_user_tools == 1
09:25 liliputech Joubu: just checked with FlorianB, if any sub-tools permission is enabled, CAN_user_tools is then true
09:27 Joubu always confirm yourself what I am saying ;)
09:28 cait1 I think the templats work a bit different than the checks in .pl
09:28 cait1 so that might be the confusing bit?
09:28 Joubu that's definitely confusing
09:29 liliputech Joubu: lol ^^
09:29 FlorianB If you check intranet-main.tt for instance, you have multiple instances of CAN_user_tools conditions, and after giving a test user no other sub-tool permission but the edit_calendar, it's enough for all the CAN_user_tools condition to be true
09:29 FlorianB Which is probably true with all other permissions categories then
09:29 Joubu pl side it's '*' for any and 1 for all
09:30 Joubu so maybe CAN_user_tools is true, but you could differ both behaviour testing with '1' or '*'
09:31 Joubu If that's true, it's not confusing. But we should improve our conditions in .tt and explicit == '1' or == '*'
09:34 FlorianB Got it, thanks for the confirmation!
09:35 FlorianB Gonna make a few more tests and probably add a tiny patch then :D
09:36 koha-jenkins Yippee, build fixed!
09:36 koha-jenkins Project Koha_21.11_U20 build #102: FIXED in 57 min: https://jenkins.koha-community[…]ha_21.11_U20/102/
09:36 wahanui Congratulations!
09:42 Joubu ashimema: please see the last patch on bug 30982, allow-owner is not working for me
09:42 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=30982 enhancement, P5 - low, ---, jonathan.druart+koha, In Discussion , Use the REST API for background job list view
09:45 koha-jenkins Yippee, build fixed!
09:45 koha-jenkins Project Koha_21.11_D10 build #117: FIXED in 34 min: https://jenkins.koha-community[…]ha_21.11_D10/117/
09:45 wahanui Congratulations!
09:47 koha-jenkins Yippee, build fixed!
09:47 koha-jenkins Project Koha_21.11_D11 build #130: FIXED in 1 hr 9 min: https://jenkins.koha-community[…]ha_21.11_D11/130/
09:47 wahanui Congratulations!
09:48 alohabot 🎁 🦊 Koha '21.11.x' packages pushed to 'koha-staging' repo  ðŸœðŸŽðŸ±
09:53 koha-jenkins Yippee, build fixed!
09:53 koha-jenkins Project Koha_21.11_U18 build #109: FIXED in 1 hr 13 min: https://jenkins.koha-community[…]ha_21.11_U18/109/
09:53 wahanui Congratulations!
10:03 koha-jenkins Yippee, build fixed!
10:03 koha-jenkins Project Koha_21.11_U22 build #37: FIXED in 44 min: https://jenkins.koha-community[…]oha_21.11_U22/37/
10:03 wahanui Congratulations!
10:05 ashimema ack.. looking at the code it's allow-owner that I've discussed before and bemoaned it's a bit of a mess.
10:06 ashimema I'm thinking drop that last patch as you've proved it doesn't work right now.. and we can follow through on that stuff in another way..
10:06 ashimema I'm considering search_limited at the moment in relation to bug 29523
10:06 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=29523 major, P5 - low, ---, tomascohen, Signed Off , Add a way to prevent embedding objects that should not be allowed
10:06 ashimema the deeper I dig on this stuff the more scared I am by it.
10:09 domm[m] We got a bug report by catalogers who wanted to merge duplicate authorities via the webinterface. When one of the auths has a lot of linked biblios, the request times out, leaving the database in a rather dirty state (some biblios are linked to the new auth, some not, but the old auth is gone(-ish))
10:09 domm[m] is this a known bug? Shall I report it as a new bug?
10:09 domm[m] Is there a workaround via a commandline script?
10:15 ashimema ooh, thanks for the QA comment on bug 29523 Joubu.. I certainly still need to enhance the tests 🙂
10:15 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=29523 major, P5 - low, ---, tomascohen, Signed Off , Add a way to prevent embedding objects that should not be allowed
10:17 ashimema as for the caching.. you're probably right there.. it's a hang over from this being submitted before we'd discussed caching in more detail
10:18 Joubu I don't understand 29523 - it looks like we need a filter_by_accessible or something
10:18 Joubu with the current patches, can we filter a set?
10:18 koha-jenkins Project Koha_21.11_D10 build #118: SUCCESS in 33 min: https://jenkins.koha-community[…]ha_21.11_D10/118/
10:19 ashimema this is all about embedding.. so it's all at least one level deep
10:20 Joubu don't we use JOINs for embed?
10:20 ashimema what has now dawned on me is that for embedding we always use the plain relationships accessor... whichis never filtered.. so yes JOINs
10:20 Joubu yes, so it's not efficient
10:20 ashimema the code here then iterates that results of the JOINed data to filter things out
10:21 ashimema depends on perspective
10:21 Joubu perf side :)
10:21 ashimema but yeah.. it's very difficult to magically get this right
10:21 ashimema perf wise
10:21 ashimema perf wise adding a JOIN to everything always is bad
10:21 ashimema likewise.. perf wise never using a JOIN is also bad.
10:22 Joubu we would add the join only if the embed is needed
10:22 ashimema we do only add the JOIN if the embed is needed
10:22 Joubu :q
10:22 Joubu ha!
10:23 ashimema but we always add it if the embed is needed
10:23 ashimema but the join is 'dumb'.. i.e. it doesn't handle our filtering
10:23 ashimema hence our after the fact filtering introduced in this bug
10:23 ashimema make sense?
10:24 Joubu yes, I think so
10:25 ashimema but I am now considering whether always joining when an embed is added is sensible at all
10:25 ashimema it always makes sense if the query uses something in the join in the where..
10:25 Joubu I am a bit late anyway. There is something that smells but I cannot spot what exactly
10:26 ashimema but if it doesn't.. perhaps it does just make more sense to call a relation_filtered method for our relation handling
10:26 Joubu Having a test per object we embed can be very bad for perf
10:27 Joubu I do see the problem with the "libraries_where_can_see_patrons" problematic. It's very specific and we need to process every item
10:27 Joubu but most of the time a filter_by could do the job (maybe?)
10:29 ashimema it all boils down to here: https://git.koha-community.org[…]ject.pm#L589-L628
10:30 ashimema where we use '$relation' there we should perhaps check for the existence of '$relation_filtered' and use that instead
10:32 ashimema $self->$relation->count; becomes $self->$relation_filtered->count; for example
10:32 Joubu $self->$relation->filter_by_accessible
10:32 Joubu filter_by_accessible will be defined at koha::objects level and only return $self
10:33 ashimema That works
10:33 ashimema Yup
10:33 koha-jenkins Project Koha_21.11_U20 build #103: SUCCESS in 57 min: https://jenkins.koha-community[…]ha_21.11_U20/103/
10:35 ashimema OK.. unless you're intended to have a go at this I can give it another round..
10:35 ashimema probably on a fresh branch as this has too much history already
10:35 ashimema might steal the unit tests though..
10:36 Joubu please do!
10:38 oleonard joined #koha
10:42 oleonard o/
10:47 koha-jenkins Project Koha_21.11_D12 build #93: SUCCESS in 43 min: https://jenkins.koha-community[…]oha_21.11_D12/93/
10:53 koha-jenkins Project Koha_21.11_D11 build #131: SUCCESS in 1 hr 6 min: https://jenkins.koha-community[…]ha_21.11_D11/131/
10:55 koha-jenkins Project Koha_21.11_D9 build #100: SUCCESS in 36 min: https://jenkins.koha-community[…]oha_21.11_D9/100/
11:09 koha-jenkins Project Koha_21.11_U18 build #110: UNSTABLE in 1 hr 16 min: https://jenkins.koha-community[…]ha_21.11_U18/110/
11:11 Shane-S joined #koha
11:13 Shane-S So my page load times are a little slow when performing item adds etc. I remember a while back someone had me enable something and speeds went up a ton. I thought it was Plack...but that seems to be on. I am on 22.05.00.000
11:15 Shane-S SS of what is currently installed/enabled and what is not: https://pasteboard.co/IyjykR3A5fDp.png
11:18 Shane-S If it helps, its a 2 CPU VM with 6Gb ram on Ubuntu 22.04
11:19 cait joined #koha
11:19 marcelr joined #koha
11:19 marcelr o/
11:28 tcohen ºo
11:29 koha-jenkins Project Koha_21.11_D12 build #94: SUCCESS in 34 min: https://jenkins.koha-community[…]oha_21.11_D12/94/
11:29 tcohen hi
11:30 Shane-S Hello
11:30 wahanui what's up, Shane-S
11:30 koha-jenkins Project Koha_21.11_U22 build #38: SUCCESS in 43 min: https://jenkins.koha-community[…]oha_21.11_U22/38/
11:35 koha-jenkins Yippee, build fixed!
11:35 koha-jenkins Project Koha_21.11_U18 build #111: FIXED in 1 hr 1 min: https://jenkins.koha-community[…]ha_21.11_U18/111/
11:35 wahanui Congratulations!
11:35 Shane-S Is there anything aside from Memcache, Apache Cache, and Plack that will speed up Koha page loads?
11:35 magnuse_ joined #koha
11:48 FlorianB joined #koha
11:52 Joubu Shane-S: mysql tuning maybe?
11:56 reiveune joined #koha
11:58 mtj Shane-S: google pagespeed can work well, as a general thing - but probably wont help much for that specific problem
11:58 mtj Shane-S: i would experiment with adding more cpu cores, for a start
11:59 koha-jenkins Project Koha_21.11_D11 build #132: SUCCESS in 1 hr 5 min: https://jenkins.koha-community[…]ha_21.11_D11/132/
12:04 koha-jenkins Project Koha_21.11_U22 build #39: SUCCESS in 33 min: https://jenkins.koha-community[…]oha_21.11_U22/39/
12:14 Shane-S Thanks I will have a look and see if CPU cores help. Its a fresh and empty install. I am using it to inventory laptops and other computer hardware. We added 200 chromebooks yesterday and it takes about 10-15 seconds after doing "Add&Duplicate".
12:16 Shane-S Plack is enabled by default now correct? I remember 2-3 years back enabling it at an old job and it was super fast page loads....but I am think I might have done 4 CPU cores.
12:17 mtj i think its not enables by default, check the about page to confirm
12:17 Joubu 10 sec to add 200 items? Seems correct to  me
12:19 liliputech joined #koha
12:20 mtj hmm, yeah agree
12:27 koha-jenkins Project Koha_21.11_D9 build #101: SUCCESS in 1 hr 17 min: https://jenkins.koha-community[…]oha_21.11_D9/101/
12:42 FlorianB joined #koha
12:45 Dyrcona joined #koha
12:46 liliputech joined #koha
12:50 FlorianB joined #koha
13:04 reiveune joined #koha
13:13 cait1 domm: did you get a reply t yoru merge question?
13:14 cait1 domm[m]: you might want to have a look at AuthorityMergeLimit system preference, you can limit how many are records are udpated on the fly and leave a bigger number of titles to a cronjob
13:15 davidnind[m] domm: there is a bug, just looking for it now...
13:15 magnuse__ joined #koha
13:16 cait1 davidnind[m]: shoudl you be awake? also hi!
13:17 davidnind[m] cait1: I shouldn'tt be, but woke up a little while ago wide awake 🙂
13:17 cait1 oh, I don't like that
13:18 cait1 maybe a cup of hot tea? sometimes helps (nothing that makes you more awake of course, but herbal or so)
13:21 davidnind[m] domm: Bug 30883
13:21 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=30883 critical, P5 - low, ---, fridolin.somers, Pushed to stable , Authorities merge is limited to 100 biblio with Elasticsearch
13:23 cait1 tcohen++
13:38 lukeg joined #koha
13:39 lukeg marcelr++
13:39 lukeg thanks for putting some energy into Bug 12758
13:39 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=12758 normal, P5 - low, ---, m.de.rooy, ASSIGNED , Failure when loading or parsing XSLT stylesheets over HTTPS
13:45 marcelr lukeg ashimema just hope to put a bit more on that report
13:45 marcelr shame that these libs are still not supporting https
13:47 cait joined #koha
13:52 lukeg joined #koha
14:22 lukeg joined #koha
14:23 alex_ joined #koha
14:36 FlorianB cait1: Hi! If you're available, can I DM you about the bug 26247? It should be quick.
14:36 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=26247 major, P5 - low, ---, nick, Patch doesn't apply , Search terms retained in header search creates UX inconsistency
14:37 cait1 FlorianB: not the best timing right now
14:37 cait1 I don't really remember the bug well - maybe oleonard-away would be better?
15:01 Shane-S joined #koha
15:04 alex__ joined #koha
15:04 Shane-S So I wasn't clear earlier. It takes 10-15 second per item added manually using Add&Duplicate under Edit Items. I upgraded the VM to 4 CPU / 8Gb. Same issue, when I click Add & Duplicate it is taking 10-15 second for the page to load.
15:15 reiveune joined #koha
15:16 FlorianB joined #koha
15:17 FlorianB cait1: Okay nevermind, internet is being really wonky tonight, i'll come back to it tomorrow if that's alright ^^
15:18 cait1 yes ok
15:20 FlorianB Thanks!
15:22 alex_ joined #koha
15:39 Shane-S I think I lost connection?
15:42 cait1 left #koha
15:45 cait joined #koha
15:46 FlorianB joined #koha
15:46 FlorianB left #koha
15:51 Shane-S Trying to follow a guide and it says to check "You should have “PSGI: Plack (deployment)” under Server Information" I don't see that is that still accurate of 22.05 ?
16:04 tuxayo Shane-S: what do you have in "PSGI: " ?
16:05 Shane-S I don't even see that value
16:06 Shane-S nm wrong screen
16:06 Shane-S Plack
16:08 Shane-S Alright....guess I am just stuck with a record load time delay...maybe it is a network issue and not a server issue.
16:09 Shane-S I logged into my old work Koha server (its live on the web) and it load faster then this new one.....and it has 15,000+ records...so I am thinking it might be LAN related.
16:09 lukeg joined #koha
16:09 wajasu oh. how convenient. ABoutKOha->SystemInformation. you guys put the autoincrement fix queries showing me what i need to address
16:10 tcohen Joubu++
16:17 Shane-S is there a setting to remove focus from the search / checkin / checkout box?
16:17 Shane-S Its a pain to have to click anywhere on the page and press then "end" key to get down the bottom when I am doing add&duplicate
16:18 Shane-S unless there is an easy way to scan the fields I need into a spreadsheet and then mass upload via CSV
16:50 m23 joined #koha
17:00 Shane-S To add items to a biblio do I have to create a MARC file? Can I export an existing item as a marc record template to fill in?
17:54 oleonard_ joined #koha
17:55 inlibro_ joined #koha
17:57 jeff__ joined #koha
17:59 Dyrcona joined #koha
18:08 cait joined #koha
18:21 davidnind[m] Shane-S: you can add multiple records at once, if the only thing that s different is the barcode (it should increment automatically) - from the record details view Edit > Edit items, fill in the common details the click the "Add multiple copies of this item"
18:22 davidnind[m] Shane-S: no setting that I know of to remove the focus, except adding customer JaaScript to UserJS
18:22 Shane-S davidnind[m]: sadly I have to change inventory #, barcode (system serial...not incremental), and public note...so I think I have to do an external file
18:24 Shane-S davidnind[m]: thanks
18:25 davidnind[m] Shane-S: That's a pain! Maybe export the record and an item, then use somethin like MARCEdit to copy and edit items then reimport - I'm sure it is possible, but is not something I've done
18:26 davidnind[m] or put in a spreadsheet, then convert to MARC using MARCEdit and import
18:47 fridolin joined #koha
19:08 m23 joined #koha
20:24 wajasu ok. i'm going to install the latest koha for production. should i use 20.05  or 21.05 or 21.11?
20:28 wajasu or 22.05.01 from jun27
20:56 davidnind[m] 22.05.x is the latest stable version, but I think most people allow 1 or 2 monthly maintenance releases to catch any unexpected issues with a new release
20:59 fridolin davidnind[m]: great thanks for your testing, your footprint is stringly visible in Koha :D
20:59 davidnind[m] If you want to want to run the most bug-free release of Koha at any given time you should track the oldoldstable branch. (21.05.x)
20:59 fridolin a small step for you, a giant step for community
21:00 davidnind[m] If you want the most feature rich release of Koha and don't mind dealing with a few bugs every few months then track the stable branch. (22.05.x)
21:00 davidnind[m] The happy middle ground of oldstable will get new features six months later than stable, but should be considerably more tried and tested, and as such more bug free. (22.11.x)
21:01 fridolin We at Biblibre are going to 21.11 next month
21:01 fridolin it is stable enought
21:02 davidnind[m] oops 22.11.x s/be 21.11.x... for oldstable
21:07 davidnind[m] fridolin: 😊 (trying to sign off at least one bug a day, but focus will now be on the documentation)
21:12 * fridolin goes on QAing some bugs
21:17 alohabot 🎁 🐭 Koha '22.05.x' packages pushed to 'koha-staging' repo  ðŸ›ðŸ­ðŸœ
21:40 wajasu thx. i'll try stable now while i test my vm build script.
21:53 koha-jenkins Project Koha_22.05_U20 build #21: SUCCESS in 1 hr 1 min: https://jenkins.koha-community[…]oha_22.05_U20/21/
22:00 davidnind[m] Question about sandboxes: if there is a patch with a database update, how do you do that? I can't see anything under the Actions menu.
22:09 koha-jenkins Project Koha_22.05_U22 build #19: SUCCESS in 35 min: https://jenkins.koha-community[…]oha_22.05_U22/19/
22:11 koha-jenkins Project Koha_22.05_U18 build #25: STILL UNSTABLE in 1 hr 18 min: https://jenkins.koha-community[…]oha_22.05_U18/25/
22:13 davidnind[m] @later tell ashimema: FYI your sandboxes don't seem to be running http://sandboxes.ptfs-europe.co.uk/
22:13 huginn davidnind[m]: The operation succeeded.
22:22 davidnind[m] answering my own question: if there is a database update required for a patch, the sandboxes take care of it (looked at provision log)
23:03 koha-jenkins Project Koha_22.05_D11 build #28: STILL UNSTABLE in 1 hr 10 min: https://jenkins.koha-community[…]oha_22.05_D11/28/
23:21 wajasu well that deb11 stable install went well. so much eaasier than 10 years ago, where i had to grab perl modules from all over the net. koha-common rocks!
23:27 davidnind[m] that's great to hear!
23:46 wajasu i used the signed-by with the koha gpg key in my koha.list.  pulled koha-common just fine
23:48 wajasu my old 3.10 version had some custom xslt tht i did years ago for my librarian. he said we don't need tht anymore. so i canrun with the defaults now. excellent!
23:57 wajasu FYI in my koha-testing-docker that I ran a day ago, I had a <span> tag showing in the opac did you mean.
23:58 wajasu its not in stable

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary