IRC log for #koha, 2022-06-15

All times shown according to UTC.

Time S Nick Message
00:02 fridolin joined #koha
01:03 koha-jenkins Yippee, build fixed!
01:03 koha-jenkins Project Koha_21.05_D11 build #220: FIXED in 59 min: https://jenkins.koha-community[…]ha_21.05_D11/220/
01:03 wahanui Congratulations!
01:56 koha-jenkins Project Koha_20.11_D11 build #246: SUCCESS in 53 min: https://jenkins.koha-community[…]ha_20.11_D11/246/
02:15 vegasjoe joined #koha
02:16 vegasjoe Hello all. I am running into this error https://bugs.koha-community.or[…]_bug.cgi?id=30912
02:16 huginn Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for Bug 30060
02:24 vegasjoe joined #koha
04:21 Oak joined #koha
04:22 Oak joined #koha
04:52 fridolin joined #koha
05:44 reiveune joined #koha
05:44 reiveune hello
05:50 Oak hello
05:50 wahanui hi, Oak
06:03 Oak joined #koha
06:18 magnuse \o/
06:44 cait joined #koha
06:45 lds joined #koha
06:48 cait1 joined #koha
06:56 alex_ joined #koha
06:56 alex_ Bonjour
06:56 wahanui niihau, alex_
07:01 Oak joined #koha
07:13 magnuse is it possible to write a report that shows all patron in a patron category and one patron attribute, if they have it or not? i was thinking this, but it only gives the ones that have the attribute, not the ones that don't have it:
07:13 magnuse SELECT b.borrowernumber, ba.attribute AS attribute FROM borrowers b LEFT JOIN borrower_attributes ba ON b.borrowernumber = ba.borrowernumber WHERE ba.code = 'SOMETHING' AND b.categorycode = 'X'
07:17 cait1 it is definitely possible
07:17 cait1 hm let me check something
07:18 cait1 instead of a left join I have used
07:20 cait1 where borrowernumber not in (select borrowernumber from borrower_attributes where code = "X" and attribute is not null)  ?
07:20 cait1 the report ist actually a little different
07:20 cait1 is the entry there in attributes as NULL or is it missing?
07:20 cait1 magnuse: ^^
07:21 magnuse it is missing
07:22 cait1 ok, so you could create a list of borrowernumber that have it and compare that to your list
07:22 magnuse only a few patrons have the attribute, and i want to see all patrons based on some criteria, e.g. categorycode, and then i want to see if they have the attribute set or are missing it completely
07:22 cait1 i think
07:23 cait1 I'll paly a little
07:26 cait1 select cardnumber, surname,
07:26 cait1 (select attribute from borrower_attributes ba where code = "X" and ba.borrowernumber = b.borrowernumber )
07:26 cait1 from borrowers b
07:26 cait1 this works for me
07:28 cait1 magnuse: ^ :)
07:29 magnuse interesting!
07:29 Oak magnuse
07:29 Oak Hi cait1
07:30 magnuse Oak
07:30 Oak \o/
07:33 dcook Just about to run but had fun with bug 30962 and bug 17004 today
07:33 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=30962 enhancement, P5 - low, ---, koha-bugs, NEW , REST API: Add endpoint /patrons/:patron_id/check_password
07:33 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=17004 enhancement, P3, ---, koha-bugs, In Discussion , REST API: add route to authenticate patron (Single Sign On - SSO)
07:33 * dcook runs away on that note
07:33 magnuse dcook++
07:33 magnuse run dcook run
07:34 Oak dcook++
07:35 magnuse cait1: it totally works and you are a star! i would never in a million years have figured out to do it that way
07:35 magnuse cait++
07:35 magnuse @karm
07:35 huginn magnuse: downloading the Perl source
07:35 magnuse @karma
07:35 huginn magnuse: Highest karma: "Joubu" (1107), "cait" (893), and "ashimema" (711).  Lowest karma: "-" (-77), "failed" (-52), and "ie" (-40).  You (magnuse) are ranked 18 out of 1167.
08:24 Oak joined #koha
09:06 cait1 magnuse: i like sub queries
09:06 cait1 :)
09:06 magnuse :-)
09:07 magnuse i should use them more
09:57 fridolin magnuse: we have a help doc for a SQL query on patrons with an attribute :
09:58 paxed how do cataloguers handle creating 001 when cataloguing a new record?
10:01 cait1 left #koha
10:01 paxed our old koha had a local change to automatically add 001 if it was missing, so i created a plugin to do that
10:02 paxed really liking the plugin system
10:05 magnuse plugins++
10:06 paxed just need more hooks...
10:12 magnuse hook all the things!
10:25 oleonard joined #koha
10:39 m23 joined #koha
10:40 m23_ joined #koha
10:41 m23__ joined #koha
10:42 m23___ joined #koha
10:45 oleonard joined #koha
10:50 m23 joined #koha
11:09 marcelr joined #koha
11:09 marcelr hi #koha
11:26 tcohen ah, random test failures, who doesn't love them
11:26 ashimema hugs
11:28 Oak joined #koha
11:58 oleonard Anyone around who uses the "git so" command in ktd? I'm curious about the warning message git is showing now
12:00 pastebot "oleonard" at pasted "When using the "git so" command in KTD" (7 lines) at
12:01 magnuse looks like needs an updated cert?
12:03 kidclamp I have just been ignoring it
12:05 oleonard Yes, but kidclamp instead of ignoring it you could obsess over a solution.
12:09 kidclamp that sounds stressful
12:10 oleonard Oh I see, you're on island time now :)
12:16 * kidclamp floats on a mustache shaped island in a sea of clean shaven faces
12:20 kidclamp and now I have 'island boys'  stuck in my head
12:34 m23_ joined #koha
12:41 m23 joined #koha
12:55 vegasjoe joined #koha
12:56 vegasjoe Hello. I am struggling on how to recover from this error. https://bugs.koha-community.or[…]_bug.cgi?id=30912
12:56 huginn Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for Bug 30060
12:57 m23__ joined #koha
12:59 m23___ joined #koha
13:04 Oak joined #koha
13:09 vegasjoe Hello. I have an issue with database conversion.
13:10 Oak What is the issue?
13:10 wahanui i guess the issue is too... thi swould have been better as several bugs
13:16 vegasjoe bug 30912
13:16 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=30912 blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for Bug 30060
13:17 vegasjoe Database update fails for I am trying to get out of the issue.
13:23 Oak Thanks, have you tried what's described in this comment: https://bugs.koha-community.or[…]g.cgi?id=30912#c5
13:23 huginn Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for Bug 30060
13:23 vegasjoe How do I apply the patch?
13:24 vegasjoe I am doing something wrong.
13:24 Dyrcona joined #koha
13:27 vegasjoe joined #koha
13:30 vegasjoe Did I miss a comment?
13:33 vegasjoe joined #koha
13:34 vegasjoe From which directory do  you run restart_all?
13:35 vegasjoe also updatedatabase
13:44 vegasjoe what is KTD? Is it part of docker?
13:44 ashimema ktd is koha-testing-docker
13:44 ashimema it's a tool we use for development
13:45 ashimema where are you running into this issue.. on a live server.. or whilst developing
13:45 vegasjoe thank you
13:45 vegasjoe Live server
13:46 vegasjoe we did an update using apt and ran into this problem
14:01 tcohen vegasjoe: find the file installer/data/mysql/db_revs/
14:01 tcohen in /usr/share/koha/
14:01 tcohen make the changes from the patch
14:01 tcohen https://bugs.koha-community.or[…]ent.cgi?id=136029
14:02 tcohen and run koha-upgrade-schema $(koha-list)
14:02 tcohen if this is a live system
14:02 tcohen otherwise wait around 10 days for the point release to be published
14:05 vegasjoe thank you. I will try it
14:06 FlorianB joined #koha
14:07 FlorianB Hello Koha, quick question : is it possible to create a syspref with multiple booleans in it, or would it not be a good practice?
14:15 lukeg joined #koha
14:15 lukeg hi
14:15 wahanui niihau, lukeg
14:16 lukeg joined #koha
14:17 m23 joined #koha
14:17 vegasjoe thank you that worked
14:19 tcohen vegasjoe: glad to hear
14:22 m23 joined #koha
14:24 vegasjoe tcohen: Now I cannot log in.
14:28 vegasjoe I used the default user name and password in koha-conf.xml and still cannot log in
14:28 tcohen newer Koha doesn't allow db user login
14:28 tcohen you need a *real* user
14:28 tcohen if you don't have one
14:29 tuxayo FlorianB: There can be multiple sysprefs that are displayed in the same place. Look for  finesMode  and  ChargeFinesOnClosedDays  for example.
14:29 vegasjoe my *real* user also cannot log in
14:29 tcohen you can create one on the command line, but I don't remember the script name
14:29 tcohen the only thing I can think of
14:29 tcohen are
14:29 tcohen - creashed sessions table
14:29 Dyrcona joined #koha
14:30 tcohen - sessionStorage=tmp and no permissions on the tmp firectory
14:30 tcohen you should check the logs, basically
14:31 m23 joined #koha
14:35 lukeg joined #koha
14:45 oleonard lukeg: Does it look like Bug 27700 is still valid to you?
14:45 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=27700 minor, P5 - low, ---, koha-bugs, NEW , Patron quick add form is a single fieldset and contains no legend or headers
14:46 oleonard It might have been fixed by all the recent accessibility improvements. I see a heading and a legend on the fieldset now.
14:52 Oak joined #koha
14:56 lukeg oleonard: it does still seem valid to me
14:56 oleonard What were you looking for?
14:57 Oak joined #koha
14:57 lukeg IIRC, I got a complaint about it not have the same headings/fieldsets as the normal form
14:58 oleonard Thats kind of the point IMO
14:58 oleonard It's brief.
14:58 lukeg So for example, if you add surname & firstname to the quickaddfields you would see the Patron identity legend and fieldset
14:59 lukeg I don't disagree with you
15:00 bag joined #koha
15:00 lukeg It seems like if we made it work like I just described it would be the SlowAddForm
15:01 lukeg oleonard: I think maybe we should mark it as RESOLVED WORKSFORME ?
15:01 oleonard I get the feeling that what they really wanted was to hide certain fields from the "full" entry form, rather than create a quick one.
15:02 lukeg Right, and that can easily be done. I am going to mark it as resolved
15:02 oleonard Yeah, I would be fine with WORKSFORME if you are
15:46 lukeg1 joined #koha
15:58 reiveune bye
15:58 reiveune left #koha
16:02 reiveune joined #koha
16:08 FlorianB left #koha
16:17 TimothyAlexis joined #koha
16:18 TimothyAlexis I really found this funny
16:18 TimothyAlexis Didn't know someone could be hypnotized like that
16:30 reiveune left #koha
16:41 cait joined #koha
16:48 fridolin joined #koha
16:56 koha-jenkins Project Koha_22.05_U22 build #9: STILL UNSTABLE in 58 min: https://jenkins.koha-community[…]Koha_22.05_U22/9/
16:59 koha-jenkins Project Koha_22.05_U20 build #9: STILL UNSTABLE in 1 hr 2 min: https://jenkins.koha-community[…]Koha_22.05_U20/9/
17:18 koha-jenkins Project Koha_22.05_U18 build #12: STILL UNSTABLE in 1 hr 19 min: https://jenkins.koha-community[…]oha_22.05_U18/12/
17:19 tuxayo Hi :) Anyone up to signoff bug 30733 ? A second signoff will allow Fridolin (the 1st signoff) to do the QA.
17:19 tuxayo New simpler method to test instead of reviewing hundred of template changes: run the command to update the translations strings before and after the patch and do a diff. I can details for those interested.
17:19 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=30733 enhancement, P5 - low, ---, victor, Patch doesn't apply , Simplify translatable strings
17:20 tuxayo oh, it doesn't apply
17:37 koha-jenkins Project Koha_22.05_D11 build #17: STILL UNSTABLE in 40 min: https://jenkins.koha-community[…]oha_22.05_D11/17/
17:38 tuxayo tcohen: thanks for the heads up about 30733, it's rebased now.
17:50 lukeg joined #koha
18:12 koha-jenkins Yippee, build fixed!
18:12 koha-jenkins Project Koha_22.05_U20 build #10: FIXED in 54 min: https://jenkins.koha-community[…]oha_22.05_U20/10/
18:12 wahanui Congratulations!
18:15 koha-jenkins Project Koha_22.05_U22 build #10: FAILURE in 2 min 53 sec: https://jenkins.koha-community[…]oha_22.05_U22/10/
18:40 koha-jenkins Project Koha_22.05_U18 build #13: STILL UNSTABLE in 1 hr 3 min: https://jenkins.koha-community[…]oha_22.05_U18/13/
18:40 koha-jenkins Project Koha_Master_D11_MDB_Latest build #958: STILL UNSTABLE in 4 hr 9 min: https://jenkins.koha-community[…]1_MDB_Latest/958/
19:28 koha-jenkins Yippee, build fixed!
19:28 koha-jenkins Project Koha_22.05_U22 build #11: FIXED in 47 min: https://jenkins.koha-community[…]oha_22.05_U22/11/
19:28 wahanui Congratulations!
19:34 koha-jenkins Project Koha_22.05_U18 build #14: STILL UNSTABLE in 1 hr 19 min: https://jenkins.koha-community[…]oha_22.05_U18/14/
19:36 lukeg joined #koha
19:45 Dyrcona joined #koha
19:49 koha-jenkins Project Koha_22.05_D11 build #18: STILL UNSTABLE in 1 hr 9 min: https://jenkins.koha-community[…]oha_22.05_D11/18/
19:55 davidnind joined #koha
19:56 lukeg joined #koha
21:17 davidnind1 joined #koha
21:21 davidnind2 joined #koha
21:38 davidnind2 left #koha
22:58 lukeg joined #koha
23:01 lukeg1 joined #koha
23:23 alohalog` joined #koha
23:37 lukeg joined #koha

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