Time Nick Message 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.org/job/Koha_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.org/job/Koha_20.11_D11/246/ 02:16 vegasjoe Hello all. I am running into this error https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912 02:16 huginn Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 05:44 reiveune hello 05:50 Oak hello 05:50 wahanui hi, Oak 06:18 magnuse \o/ 06:56 alex_ Bonjour 06:56 wahanui niihau, alex_ 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.org/bugzilla3/show_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.org/bugzilla3/show_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. 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 : https://pastebin.com/S7gXt3A4 09:58 paxed how do cataloguers handle creating 001 when cataloguing a new record? 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! 11:09 marcelr hi #koha 11:26 tcohen ah, random test failures, who doesn't love them 11:26 ashimema hugs 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 127.0.0.1 pasted "When using the "git so" command in KTD" (7 lines) at https://paste.koha-community.org/10062 12:01 magnuse looks like https://paste.koha-community.org/ 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:56 vegasjoe Hello. I am struggling on how to recover from this error. https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912 12:56 huginn Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 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.org/bugzilla3/show_bug.cgi?id=30912 blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 13:17 vegasjoe Database update fails for 21.12.00.016- 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.org/bugzilla3/show_bug.cgi?id=30912#c5 13:23 huginn Bug 30912: blocker, P5 - low, ---, jonathan.druart+koha, Pushed to master , Database update fails for 21.12.00.016 Bug 30060 13:23 vegasjoe How do I apply the patch? 13:24 vegasjoe I am doing something wrong. 13:30 vegasjoe Did I miss a comment? 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/211200016.pl 14:01 tcohen in /usr/share/koha/ 14:01 tcohen make the changes from the patch 14:01 tcohen https://bugs.koha-community.org/bugzilla3/attachment.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: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 hi 14:15 wahanui niihau, lukeg 14:17 vegasjoe thank you that worked 14:19 tcohen vegasjoe: glad to hear 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:30 tcohen - sessionStorage=tmp and no permissions on the tmp firectory 14:30 tcohen you should check the logs, basically 14:45 oleonard lukeg: Does it look like Bug 27700 is still valid to you? 14:45 huginn Bug https://bugs.koha-community.org/bugzilla3/show_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:56 lukeg oleonard: it does still seem valid to me 14:56 oleonard What were you looking for? 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 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:58 reiveune bye 16:18 TimothyAlexis I really found this funny https://youtu.be/FCXA4ft5Weo 16:18 TimothyAlexis Didn't know someone could be hypnotized like that 16:56 koha-jenkins Project Koha_22.05_U22 build #9: STILL UNSTABLE in 58 min: https://jenkins.koha-community.org/job/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.org/job/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.org/job/Koha_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.org/bugzilla3/show_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.org/job/Koha_22.05_D11/17/ 17:38 tuxayo tcohen: thanks for the heads up about 30733, it's rebased now. 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.org/job/Koha_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.org/job/Koha_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.org/job/Koha_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.org/job/Koha_Master_D11_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.org/job/Koha_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.org/job/Koha_22.05_U18/14/ 19:49 koha-jenkins Project Koha_22.05_D11 build #18: STILL UNSTABLE in 1 hr 9 min: https://jenkins.koha-community.org/job/Koha_22.05_D11/18/