Time Nick Message 00:06 koha-jenkins Yippee, build fixed! 00:06 wahanui Congratulations! 00:06 koha-jenkins Project Koha_19.11_D10 build #122: FIXED in 35 min: https://jenkins.koha-community.org/job/Koha_19.11_D10/122/ 00:18 koha-jenkins Yippee, build fixed! 00:18 wahanui Congratulations! 00:18 koha-jenkins Project Koha_19.11_U20 build #186: FIXED in 47 min: https://jenkins.koha-community.org/job/Koha_19.11_U20/186/ 07:19 jsicot Hi #koha 07:20 reiveune hello 07:32 magnuse \o/ 07:58 alex_a Bonjour 08:09 severine_q good morning #koha :) 08:33 cait good morning #koha :) 08:45 severine_q Good morning cait !! 08:46 cait2 good morning severine_q :) 08:49 * cait2 tries to deduplicate 08:49 cait2 t 08:51 cait ashimema: Joubu: translate is acting up again 08:56 ashimema hum 08:57 ashimema I restarted apache 09:02 cait thx! 09:05 ashimema wow.. 113 Academy bugs 09:05 ashimema we marked up a fair few.. that should keep them busy :) 09:12 cait we'll see :) 09:12 cait a lot is manual, it hink having a bit more in koha might have been nice 09:13 ashimema well.. there's lots of little ACC2 one's :) 09:14 ashimema so those are nice easy ones to get people started 09:14 ashimema and I imagine some of the 'Problem reports' ones might get some love as it was an academy feature of Aliesha's in the first place.. she might like to hold someone's hand in enhancing that area. 09:15 * ashimema likes the idea of bug 25213 09:15 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25213 enhancement, P5 - low, ---, koha-bugs, NEW , Notify reporter when an OPAC problem is resolved 09:22 cait i think sending notices might be alittle hard already, but we will see .) 09:26 ashimema humm.. really.. 09:26 ashimema I thought there were plenty of examples to follow of adding a notice 09:27 ashimema that.. or just calling SendAlert 09:29 cait just not sure they will ge tthat far 09:30 ashimema fair enough 09:30 cait remember a lot will have got their first glimpse at programming like yesterda 09:30 cait y 09:30 davidnind aleisha has pre-selected quite a few and rated, plus 8 students working on Koha! https://wiki.koha-community.org/wiki/Catalyst_Academy 09:30 cait and that with python :) 09:30 ashimema cool 09:32 cait really excited about this 09:32 cait davidnind: thx for the sign-off btw :) 09:33 davidnind have been a bit slack lately, trying not to do any on aleisha's list until after the academy... 09:33 ashimema nice, that's a great page.. 09:33 cait very reasonable i'd say 10:18 magnuse wow, aleisha++ 10:19 cait aleisha++ 10:31 ashimema bug 27454 sorted cait 10:31 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27454 trivial, P5 - low, ---, martin.renvoize, Needs Signoff , Additional patron attributes change sequence on every reload of edit page 10:31 ashimema pun intended :P 10:32 cait lol 10:35 Joubu DT plugins should be in koha-tmpl/intranet-tmpl/lib/datatables or koha-tmpl/intranet-tmpl/lib/jquery/plugins? 10:35 Joubu IMO they should be in lib/datatables, but they are in jquery/plugins 10:36 ashimema hum.. 10:36 ashimema well.. datatables itself is a jquery plugin isn't it.. 10:36 ashimema so... perhaps 10:36 ashimema koha-tmpl/intranet-tmple/lib/jquery/plugins/datatables/ 10:37 ashimema but.. that's more typig. 10:37 Joubu and then move lib/datatables to jquery/plugins? 10:37 ashimema perhaps 10:37 Joubu it has always been there 10:38 Joubu I would not move it 10:38 Joubu will wait for Owen's pov 10:38 Joubu cait: the about page is messy about datatables's licenses... :-/ 10:43 cait hm? 10:43 cait because not all are listed or because we are listing false information? 10:55 ashimema well.. as it's always been there then I would take your first option.. i.e. /lib/datatabls/ 11:00 Joubu cait: no license for DT, license exist for plugin that has been removed, etc. 11:00 Joubu ashimema: yes, I will see if oleonard agrees when he will be around 11:21 dolf Hi :) I'm trying to debug an issue with an OAI-PMH client that I wrote. Some records seem to not get harvested when running through all the dates using the OAI-PMH client. Can someone tell me which field(s) in the Koha database is/are used to determine the "Last Modified" on the /cgi-bin/koha/oai.pl?verb=ListRecords page? 11:25 Joubu dolf: I think it's biblio.timestamp 11:26 Joubu yes, the code confirms that 11:30 dolf Thanks. For the record, this is the project I'm talking about: https://www.drupal.org/project/oai_pmh_harvester 11:43 cait Joubu: I remember a bug also taking the item timstamps into account, maybe depending on configuration? 11:44 cait bug 19725 claims it's bibio_metadata timestamp 11:44 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19725 major, P5 - low, ---, julian.maurice, CLOSED FIXED, OAI-PMH ListRecords and ListIdentifiers should use biblio_metadata.timestamp 12:05 dolf Hmm, as far as I know, OAI-PMH is just supposed to work with records, not items? 12:11 Joubu cait is correct, it's biblio_metadata.timestamp! 12:11 Joubu I was looking at the wrong place 12:12 dolf So when I look at `select timestamp from biblio where biblionumber=5;`, I get `2017-01-19 13:54:38`. Then I navigate to `oai.pl?verb=ListRecords&metadataPrefix=marcxml&from=2017-01-19&until=2017-01-20` to see what I get. Indeed, that biblio is listed, but the "Last Modified" says "2020-07-13 20:43:46". So there are two different dates being used here. What's the difference? 12:13 dolf I get the same timestamp for `select timestamp from biblio_metadata where biblionumber=5;`. 12:14 dolf And the same timestamp for `select timestamp from biblioitems where biblionumber=5;` 12:14 dolf So I'm still stumped about where "Last Modified" comes from. 12:15 Joubu which version of Koha? 12:15 wahanui which version of Koha are you using? How did you install 12:15 dolf 20.11, Debian packages. 12:16 dolf 20.11.00.000 12:19 cait dolf: you can also include items in your export, the manual has the howto :) 12:19 cait sorry, was at lunch break, reading back now 12:20 cait maybe the answer is in the commnts here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21517 12:20 huginn Bug 21517: major, P5 - low, ---, koha-bugs, NEW , OAI returns records outside of specified time range. 12:21 cait especially comment#2 12:22 cait dolf: a lotof libraries also include items when the records are harvested for a discovery -and they want a change on the callnumber or so show up there as well. Alternatives are using API like DAIA, but in that case the item data is usually not searchable in the discovery 12:25 dolf Hmm, I forgot about that issue (I submitted it). Let me read it again. 12:27 dolf OK, I read it. Still unclear about one thing: Is `SELECT MAX(timestamp)` used when querying the biblios to see if they match `&from=2017-01-19&until=2017-01-20`, or when displaying the data, or both? 12:29 cait sorry, have to pass on that one - it's int he code somewhere for sure... just too slow for me to find it right now 12:36 dolf OK, will try to read the code myself. I'm just not very familiar with perl syntax. :) 12:43 Joubu dolf: Koha/OAI/Server/ListBase.pm line 111 12:43 Joubu is that where you are? 12:43 dolf Joubu: Not yet, but now I know where to look, thanks! 12:44 Joubu it does a max of biblio_metadata, deleteditems and items 12:46 dolf I saw that, yes. But is that max also used for matching the query, or only when calculating the "datestamp"? If the former, I'm still left with the question: Which date is used when matching the query? 12:49 Joubu looks like it's only use for the "Last modified" display 12:49 Joubu the "from" and "to" retrieved from the URL are used on biblio_metadata (or deletedbiblio_metadata) 12:49 Joubu line ~60 of the same file 12:49 Joubu 61 my $table = $deleted ? 'deletedbiblio_metadata' : 'biblio_metadata'; 12:49 Joubu 62 my $sql = " 12:49 Joubu 63 SELECT biblionumber 12:49 Joubu 64 FROM $table 12:49 Joubu 65 WHERE (timestamp >= ? AND timestamp <= ?) 12:50 dolf Ah, thanks for confirming. I was just staring at those lines... 12:54 dolf So I'm still trying to think this through, but I feel like this might explain why some records don't get harvested. Not sure yet. 12:56 cait hmi wonder 12:57 cait shoudl we not make themboth the same? 12:57 cait i mean displaying one and using the other doesn't make much sense 12:57 cait they won't get harvested that way, which seems to have been the initial goal? 13:00 ashimema did I imagine a bug where we put the opac page title behind a syspref so it was easy to replace it? 13:00 Joubu where are documented the from and to parameter? 13:07 dolf Joubu: Do you mean this? https://www.openarchives.org/OAI/openarchivesprotocol.html#ListRecords 13:08 Joubu yes, thanks 13:08 Joubu https://www.openarchives.org/OAI/openarchivesprotocol.html#Datestamp 13:09 dolf cait: I can't see why they should differ :) (But I'm also trying to think of a test case where it would fail, and I don't have any proof of that yet) 13:09 Joubu "Harvesters may use datestamps to harvest only those records that were created, deleted, or modified within a specified date range." 13:09 Joubu in my understanding they should be the same 13:09 Joubu it's what we are doing we the "Last modified" value 13:11 dolf I know lots of SQL but zero Perl. Would love to help implement, but ... it won't be easy and the code quality might suffer. 13:12 Joubu it may impact the response performance as we will have to add 2 joins 13:24 Joubu Is today bank holiday in the USA? 13:25 Joubu Looks like it is, Martin Luther King, Jr. Day - Third Monday in January 13:27 dolf Joubu: I'm not convinced that the performance of the join would be worse, because then you don't have to execute a separate query for each record, as is currently the case (as far as I can read the code). It might even be faster. 13:41 dolf Also, I think the join is only necessary when the user has the "include items" option in their OAI-PMH config. 13:48 Joubu dolf: do you mean we should only MAX of items.timestamp if "include items" is set? 13:48 dolf yes, I think so 13:50 Joubu dolf: I would suggest you to open a new bug report and cc Julian (jajm), Ere and Frédéric (Demians) 13:50 dolf Will do. 13:54 cait new bug sounds great, thx dolf 13:54 cait also agree on the include items one 13:54 cait ashimema: LibraryName is what is used for the beginning of the page title 14:10 dolf Just an aside, before I create that new bug report. I was puzzled about the fact that none of my items in my library have a timestamp older than 2020-07-13. In fact, 38740 items share the exact same timestamp of "2020-07-13 22:43:46". Then I realized, this is when I updated Koha from 19.11.05 to 20.05.01 . So the update changed all of the item dates. This is understandable, if items needed to be updated, but it's problematic for the OAI-PMH process, because no 14:10 dolf matter how small you make the date increment (seconds is the smallest), you will at some point have to harvest all 38740 items at once! (That is, if you have include_items enabled). 14:11 dolf Was this an intentional or unintended part of one of the DB schema updates? 14:13 cait i assume there was a change ont he table that causes this, but i am not sure which one it would be 14:17 Joubu dolf: could be 18.06.00.018 or 19.12.00.080 14:39 dolf Done. See bug 27463 14:39 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27463 normal, P5 - low, ---, koha-bugs, NEW , OAI-PMH date handling in ListBase.pm 14:39 dolf Joubu: I'm not sure how to CC them. 14:40 Joubu done 14:43 dolf Champion 14:58 severine_q I've got a tiny (and probably stupid) question : bug 5927, I saw that only MARC21Utils have been modified, so it's not supposed to apply with Koha using Unimarc, right ? 14:58 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5927 enhancement, P5 - low, ---, nick, Pushed to master , Show series information in search results page 15:03 cait severine_q: true 15:03 cait we should have made the bug titlte state the format 15:03 cait i think most of us are too unfamiliar with unimarc to work on the xslt for it 15:06 severine_q thanks cait ! 15:06 severine_q no problem for that, it's just I couldn't see any difference on my opac, so I was wondering if my understanding for this patch was correcte :) 15:36 cait Joubu: can you remind me how i switch to the new repo? I didn't do that yet on my dev env it looks like and can't locate your email 15:41 cait i think i found out 15:43 cait tried git remote set-url origin git://git.koha-community.org/Koha-community/Koha.git but it doesn't look like it works yet 15:52 Joubu https 15:53 Joubu cait: git remote set-url origin https://git.koha-community.org/Koha-community/Koha.git 16:07 koha-jenkins Yippee, build fixed! 16:07 wahanui Congratulations! 16:07 koha-jenkins Project Koha_20.11_U20 build #25: FIXED in 44 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/25/ 16:22 koha-jenkins Project Koha_20.11_U2010 build #25: SUCCESS in 59 min: https://jenkins.koha-community.org/job/Koha_20.11_U2010/25/ 16:24 koha-jenkins Yippee, build fixed! 16:24 wahanui Congratulations! 16:24 koha-jenkins Project Koha_20.11_U18 build #22: FIXED in 1 hr 1 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/22/ 16:26 reiveune bye 16:29 koha-jenkins Project Koha_20.11_D10 build #41: STILL UNSTABLE in 1 hr 6 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/41/ 16:53 koha-jenkins Project Koha_20.11_D9 build #34: SUCCESS in 46 min: https://jenkins.koha-community.org/job/Koha_20.11_D9/34/ 17:14 koha-jenkins Project Koha_20.11_D11 build #40: STILL UNSTABLE in 49 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/40/ 17:25 koha-jenkins Project Koha_20.11_U16 build #27: SUCCESS in 1 hr 2 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/27/ 20:33 hayley hello, anyone around who knows debian packaging? I am trying to build a package the way I normally do but am getting the error W: GPG error: http://debian.koha-community.org/koha 20.11 InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3C9356BBA2E41F10 - but earlier up inn the command line I have gotten gpg: key 3C9356BBA2E41F10: public key "Koha Debian Package Signing Key 20:33 hayley <koha-devel@lists.koha-community.org>" imported so I don't know what's going on - maybe the move of repo changed something? 21:13 catherine hi 21:13 eden hi 21:13 aleisha academy students incoming! :) 21:14 eden hello 21:14 wahanui kia ora, eden 21:14 mazen hi 21:14 wahanui bonjour, mazen 21:14 mazen Hi wahanui 21:15 mazen Hello ella 21:15 ella ello Mazen 21:15 caroline_crazycatlady heelo academy! 21:15 mazen hi jimmy 21:15 mazen Hello caroline 21:15 Jimmy Hi! :D 21:16 eden hi caroline! 21:16 mazen hello ava 21:16 ava hi 21:16 wahanui hola, ava 21:16 amy_ hello 21:16 wahanui niihau, amy_ 21:17 caroline_crazycatlady welcome! 22:25 cait1 @later tell fridolin can you please reconsider bug 15448 and dependency? 22:25 huginn cait1: The operation succeeded. 22:35 * cait1 waves 22:39 M_Adamyk Quick question: once a patron's account is changed, the only way to see what was changed is through the modification logs, correct? 22:44 cait yes 23:05 mtj hey #koha 23:05 marie-luce hi mtj 23:05 mtj hayley, did you sort your GPG error problem? ^ 23:06 cait1 wow, the students are fast :) 23:08 mtj hi marie-luce, cait1 😽ðŸ¨ðŸ¹ 23:08 cait1 hi mtj :) 23:08 cait1 aw 23:16 marie-luce nice cat 23:44 cait1 i should sleep instead of trying ot keep up with 8 students much younger and more awake than me :) 23:44 cait1 open_source_academy++ 23:44 aleisha :)