Time  Nick      Message
01:05 dcook     Whoa the metacpan styling change has thrown me for a loop...
05:25 dcook     Ah my daylight savings time change means you Europeans are probably all still sleeping...
05:53 ashimema  Ha, yeah, it surprised me the other day too
06:21 magnuse   \o/
06:22 magnuse   end of dst on october 30th here...
06:59 alex_     Bonjour
06:59 wahanui   kia ora, alex_
07:09 ashimema  cait++ QA Machine!
07:16 cait1     good morning #koha
07:16 cait1     ashimema: i didn't touch a bug yesterday?
07:23 ashimema  this month
07:30 magnuse   cait++
07:31 magnuse   davidnind++
07:33 ashimema  does anyone here understand why the SQL in bug 31086 would run fine from an interactive mysql session and not from the db_rev.pl ?
07:33 huginn`   Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086 normal, P5 - low, ---, nick, RESOLVED FIXED, Do not allow hold requests with no branchcode
07:33 ashimema  I've now had reports of this issue happening three times.. but I really don't understand the resolution..
07:34 ashimema  how does running it interactively make any difference at all.. the SQL is exactly the same
07:35 cait1     ashimema: no idea... already ran into this wall yesterday
07:36 cait1     but thanks for taking a look
07:36 cait1     can you reproduce the error ?
07:37 cait1     or could it be a database version thing? Mysql vs. MariaDB?
07:39 ashimema  Someone emailed Tomas and I directly to complain about it..
07:39 ashimema  Nope, can't reproduce it
07:41 ashimema  Honestly, I found it rather rude, major rant about downtime and terrible developers and stables not being stable and we should completely change our release cycle and says it's a major breaking version change.. Koha 5
07:41 tundunf   hi everyone
07:41 ashimema  Morning tundunf
07:42 ashimema  How's your sorters this morning, hopefully the London change is working as expected :)
07:42 tundunf   It's working so far, thanks for your help!
07:43 ashimema  Excellent
07:43 wahanui   darn tootin' it is.
07:43 ashimema  It's great to see you on here more regularly now.. I love seeing customers joining in :)
07:44 tundunf   great to be here! I grew tired of lurking :)
07:44 ashimema  :)
07:45 ashimema  I hear your kohacon presentation went down very well, congrats
07:46 ashimema  It's on my watch list still, I've been so busy manning fort here that I've not caught up on it all yet
07:46 tundunf   thank you!
07:46 tundunf   I had a question about reservations - a student ran into the error "no record id specified" when trying to reserve a book. I couldn't replicate the error and they shouldn't have had any problems based on their user category permissions. Does anyone know what this error means?
07:47 ashimema  The next upgrade will put sorter config in your gift btw.. we move the configuration into staff preferences.. I'll have to take you through it some time.. it's not too hard, but also not the simplest pref there is
07:48 ashimema  Hmm, that's a strange error.. I can have a little dig when I get back from the school run
07:49 tundunf   Ah great, thank you!
07:55 cait1     never seen that one either - and also want to say nice to see you around :)
10:45 pastebot  "oleonard" at 127.0.0.1 pasted "Anyone else seen this error during upgrade?" (2 lines) at https://paste.koha-community.org/15792
10:47 oleonard  Seems like it doesn't like that I have a z3950 server with NULL encoding
10:55 cait      hm my fault
10:55 cait      i didnt't think those were possible
10:56 cait      did you add them through the gui?
10:56 oleonard  This is my test db which I've been upgrading for years
10:57 oleonard  So it often has weird cruft
10:57 cait      the bug is bug 30571
10:57 cait      brb
10:57 huginn`   Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30571 enhancement, P5 - low, ---, m.de.rooy, Pushed to master , Table z3950servers: Make host, syntax and encoding NOT NULL
10:57 cait      we need to check for existing NULL then there
11:02 ashimema  anyone here any good with how Makefile.PL works?
11:13 mtj       hi ashimema: ive have a little experince with it
11:14 ashimema  I thought I'd have a go at getting to the bottom of the permissions issues at upgrades
11:14 ashimema  but my brain isn't in the right place at the moment it seems
11:14 ashimema  we still have a few 'standard' type installs (and still the odd 'dev' too)..
11:15 ashimema  seems when you do a 'make upgrade' it borks lots of permissions and I'm struggling to see why/where/how
11:15 marcelr   o/
11:16 ashimema  dcook also reports similar for package upgrades in bug 31612
11:16 huginn`   Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31612 normal, P5 - low, ---, koha-bugs, NEW , koha-z3950-responder breaks if it's run in a Koha that was created before bug 28364 was applied
11:17 mtj       hmm, i havent used the 'make upgrade' before :/
11:19 cait1     marcelr: I think we need afollow up for bug 30571
11:19 huginn`   Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30571 enhancement, P5 - low, ---, m.de.rooy, Pushed to master , Table z3950servers: Make host, syntax and encoding NOT NULL
11:20 ashimema  Brb, quick walk round the block
11:21 marcelr   hi cait1 what kind of follow-up ?
11:21 mtj       ashimema: we probably need to sort a jenkins build that tests an upgrade
11:21 mtj       both pkg and tar installs
11:22 cait1     marcelr: oleonard's database had nulls, so the update failed
11:22 marcelr   ok, it would be highly unusual to have NULLs there though
11:22 cait1     marcelr: we probably need to deal with the old entries somehow... setting NULL to "" maybe?
11:22 marcelr   it is not possible to add entries with NULL
11:22 mtj       ashimema: i did make a start on a tarball install, https://jenkins.koha-community.org/view/20.11/job/Koha_20.11_D10-Tarball/33/
11:22 cait1     i thought so too, but in a very old Koha... hard to tell
11:23 marcelr   we can print a message or so in the atomic update
11:23 marcelr   i take a look
11:23 cait1     if we can make it 'work' i think it would be a little better
11:23 cait1     people get stuck on the failing database updates
11:23 marcelr   well we should guide them a bit how to continue at leat
11:24 marcelr   but these are really bad data
11:25 cait1     I know, don't tell me, it was oleonard's data! ;)
11:26 marcelr   i probably choose a bit lazy approach for very bad data :)
11:26 cait1     I gave it a thought during QA, but was nah... that is too paranoid
11:26 cait1     took us about a day to prove me wrong now :)
11:27 marcelr   i thought about it in dev, but left it as is
11:33 cait1     oleonard++
11:36 AndroUser Good day!
11:40 AndroUser I am trying out to edit a plugin (inlibro's carousel) to suit my need of getting url of records (856u). I can see in the plugin the part that constructs the code that will be inserted into the mainuserblock.
11:42 AndroUser The thing that I want to get is the first 856u, how do I call this given the bibliorecordnumber? I am not sure if Koha::Biblio will do the work for me?
11:55 marcelr   cait: added a few lines on 30571
11:55 kidclamp  my $record = Koha::Biblio->find({ biblionumber => $biblionumber })->metadata->record;
11:55 marcelr   hi kidclamp
11:56 marcelr   kidclamp: could I persuade you to qa 31503
11:57 kidclamp  yes
11:57 kidclamp  I woe you one ;-)
11:57 kidclamp  owe
11:57 kidclamp  some times i do create woe too
12:00 marcelr   sure it is
12:01 marcelr   i have two other ones from you in my queue still
13:31 nikkom    https://webchat.oftc.net/?channels=koha
13:31 nikkom    Thanks for your answer caroline yesterday. Is it right if I assume that if a  type=return record is exist in statistics table there must be a type=issue record in normal situation.
13:32 caroline  I would think so, yes
13:40 nikkom    I want to ask one more question: I want to find the number of patron who hasnt checkout any book and group them by sort1 and sort2 fields. Could you give me an idea?
14:04 pastebot  "oleonard" at 127.0.0.1 pasted "nikkom: SQL based on the query used in the "Patrons who haven't checked out" built-in report" (5 lines) at https://paste.koha-community.org/15806
15:06 eugene_   kidclamp: snippet of the code: my $biblio = Koha::Biblios->find($biblionumber);        my $record = $biblio->metadata->record;        if ($marcflavour eq 'MARC21'){
15:06 eugene_   $title = $record->subfield('245', 'a');
15:06 eugene_   $author = $record->subfield( '100', 'a' );
15:06 eugene_   $author = $record->subfield( '110', 'a' ) unless $author;
15:06 eugene_   $author = $record->subfield( '111', 'a' ) unless $author;
15:08 eugene_   not sure if this is correct: $bookurl = $record->subfield('856', 'u' ); I am not getting any output using it, I guess, for 856u, it is done differently?
15:19 eugene_   oops nevermind my question, $bookurl = $record->subfield('856', 'u' ) indeed is correct. sample record I was working on was 856$3 and not 856$u. Thanks kidclamp for the hint! :)
15:39 cait1     oleonard: i am sure we had a bug for the ... on the item form being changed to an icon or such - but I cannot find it, can you maybe?
15:39 cait1     I know you had done some mock-ups a little while ago
15:39 oleonard  Yeah there is a bug...
15:40 cait1     my brain refuses to think of more synonyms to search for right now :(
15:40 oleonard  Bug 7826
15:40 huginn`   Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7826 normal, P5 - low, ---, oleonard, NEW , Standardize link for triggering plugins and auto-entry
15:46 oleonard  cait1: More recently I shared this design: https://snipboard.io/TdVWHB.jpg
15:46 oleonard  Every time I work on it I end up pulling too many threads and I get lost
16:08 cait1     oleonard++ thx for trying :)
16:08 cait1     and for the bug!
16:12 cait1     oleonard-away: i quite like that design :)
17:02 ashimema  Lol
17:03 ashimema  Looks nice oleonard.. it's hard not to find oneself in the middle of a big knot to be unraveled
17:15 cait      ashimema++ # thx for QA :)
17:26 thd       tcohen: I have returned from the dentist.  Are you around?
19:32 tcohen    @later tell liliputech please take care of the follow-up I added for 21.11.x https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30976#c9
19:32 huginn`   tcohen: The operation succeeded.
19:32 huginn`   Bug 30976: normal, P5 - low, ---, jonathan.druart+koha, Pushed to stable , Cover images for biblio should be displayed first