IRC log for #koha, 2021-01-18

All times shown according to UTC.

Time S 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[…]ha_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[…]ha_19.11_U20/186/
00:21 inlibro joined #koha
01:07 magnuse joined #koha
01:21 inlibro joined #koha
01:23 AndrewFH joined #koha
02:04 morrism joined #koha
02:18 morrism joined #koha
02:21 inlibro joined #koha
03:22 inlibro joined #koha
03:23 AndrewFH joined #koha
03:58 AndrewFH joined #koha
04:22 inlibro joined #koha
05:22 morrism joined #koha
05:22 inlibro joined #koha
05:22 morrism joined #koha
05:58 did joined #koha
06:07 dcook joined #koha
06:13 chriss joined #koha
06:22 inlibro joined #koha
06:56 jsicot joined #koha
07:16 jsicot joined #koha
07:19 jsicot Hi #koha
07:20 reiveune joined #koha
07:20 reiveune hello
07:22 inlibro joined #koha
07:24 sophie_m joined #koha
07:32 magnuse \o/
07:33 morrism joined #koha
07:48 fridolin joined #koha
07:58 alex_a joined #koha
07:58 alex_a Bonjour
08:09 severine_q joined #koha
08:09 severine_q good morning #koha :)
08:20 cait joined #koha
08:22 inlibro joined #koha
08:33 cait good morning #koha :)
08:45 cait1 joined #koha
08:45 severine_q Good morning cait !!
08:46 cait2 joined #koha
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[…]_bug.cgi?id=25213 enhancement, P5 - low, ---, koha-bugs, NEW , Notify reporter when an OPAC problem is resolved
09:16 lds joined #koha
09:20 morrism joined #koha
09:22 cait i think sending notices might be alittle hard already, but we will see .)
09:23 inlibro joined #koha
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.or[…]/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:14 paul_p joined #koha
10:18 magnuse wow, aleisha++
10:19 cait aleisha++
10:22 severine_q joined #koha
10:23 inlibro joined #koha
10:31 ashimema bug 27454 sorted cait
10:31 huginn Bug[…]_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:17 dolf joined #koha
11:20 Oak joined #koha
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/ page?
11:23 morrism joined #koha
11:23 inlibro joined #koha
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:
11:37 davidnind left #koha
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[…]_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 `​arcxml&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
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.or[…]_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:23 inlibro joined #koha
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:32 fridolin joined #koha
12:32 morrism joined #koha
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/ 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?[…].html#ListRecords
13:08 Joubu yes, thanks
13:08 Joubu[…]ol.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:23 inlibro joined #koha
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:49 AndrewFH joined #koha
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:07 AndrewFH joined #koha
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 or
14:23 inlibro joined #koha
14:39 dolf Done. See bug 27463
14:39 huginn Bug[…]_bug.cgi?id=27463 normal, P5 - low, ---, koha-bugs, NEW , OAI-PMH date handling in
14:39 dolf Joubu: I'm not sure how to CC them.
14:40 Joubu done
14:43 dolf Champion
14:50 bdonnahue2 joined #koha
14:53 AndrewFH joined #koha
14:56 severine_q joined #koha
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[…]w_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:04 morrism joined #koha
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:24 inlibro joined #koha
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.o​rg/Koha-community/Koha.git but it doesn't look like it works yet
15:46 AndrewFH joined #koha
15:52 Joubu https
15:53 Dyrcona joined #koha
15:53 Joubu cait: git remote set-url origin[…]ommunity/Koha.git
15:54 fridolin left #koha
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[…]oha_20.11_U20/25/
16:22 dpk_ joined #koha
16:22 koha-jenkins Project Koha_20.11_U2010 build #25: SUCCESS in 59 min: https://jenkins.koha-community[…]a_20.11_U2010/25/
16:24 inlibro joined #koha
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[…]oha_20.11_U18/22/
16:26 reiveune bye
16:26 AndrewFH joined #koha
16:26 reiveune left #koha
16:29 koha-jenkins Project Koha_20.11_D10 build #41: STILL UNSTABLE in 1 hr 6 min: https://jenkins.koha-community[…]oha_20.11_D10/41/
16:53 koha-jenkins Project Koha_20.11_D9 build #34: SUCCESS in 46 min: https://jenkins.koha-community[…]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[…]oha_20.11_D11/40/
17:24 inlibro joined #koha
17:25 koha-jenkins Project Koha_20.11_U16 build #27: SUCCESS in 1 hr 2 min: https://jenkins.koha-community[…]oha_20.11_U16/27/
17:29 AndrewFH joined #koha
17:56 aswin joined #koha
17:57 aswin left #koha
18:05 AndrewFH joined #koha
18:24 inlibro joined #koha
18:31 ccordova joined #koha
18:56 paul_p joined #koha
19:00 AndrewFH joined #koha
19:24 inlibro joined #koha
19:42 AndrewFH joined #koha
19:48 aleisha joined #koha
19:57 AndrewFH joined #koha
20:25 inlibro joined #koha
20:32 hayley joined #koha
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: 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 <>" imported so I don't know what's going on - maybe the move of repo changed something?
20:59 marie-luce joined #koha
21:12 catherine joined #koha
21:13 eden joined #koha
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 joined #koha
21:14 mazen hi
21:14 wahanui bonjour, mazen
21:14 mazen Hi wahanui
21:14 ella joined #koha
21:15 mazen Hello ella
21:15 ella ello Mazen
21:15 Jimmy joined #koha
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 ava joined #koha
21:16 mazen hello ava
21:16 ava hi
21:16 wahanui hola, ava
21:16 amy_ joined #koha
21:16 amy_ hello
21:16 wahanui niihau, amy_
21:17 caroline_crazycatlady welcome!
21:18 victoria joined #koha
21:25 inlibro joined #koha
22:01 cait1 joined #koha
22:25 cait1 @later tell fridolin can you please reconsider bug 15448 and dependency?
22:25 huginn cait1: The operation succeeded.
22:25 inlibro joined #koha
22:35 * cait1 waves
22:38 M_Adamyk joined #koha
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:42 AndrewFH joined #koha
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:15 hayley joined #koha
23:16 marie-luce nice cat
23:19 AndrewFH joined #koha
23:25 inlibro joined #koha
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 :)
23:59 AndrewFH joined #koha

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