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