IRC log for #koha, 2022-10-05

All times shown according to UTC.

Time S Nick Message
00:06 fridolin joined #koha
01:05 dcook Whoa the metacpan styling change has thrown me for a loop...
01:21 dpk joined #koha
04:10 Oak joined #koha
05:25 dcook Ah my daylight savings time change means you Europeans are probably all still sleeping...
05:53 ashimema joined #koha
05:53 ashimema Ha, yeah, it surprised me the other day too
06:02 fridolin joined #koha
06:21 magnuse \o/
06:22 magnuse end of dst on october 30th here...
06:59 alex_ joined #koha
06:59 alex_ Bonjour
06:59 wahanui kia ora, alex_
07:00 lds joined #koha
07:00 cait joined #koha
07:09 ashimema cait++ QA Machine!
07:11 cait1 joined #koha
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 ?
07:33 huginn` Bug https://bugs.koha-community.or[…]_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 joined #koha
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:44 Library1Cy joined #koha
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 :)
07:57 reiveune joined #koha
07:57 reiveune left #koha
07:58 reiveune joined #koha
08:53 reiveune left #koha
08:59 reiveune joined #koha
10:02 cait joined #koha
10:19 oleonard joined #koha
10:45 pastebot "oleonard" at pasted "Anyone else seen this error during upgrade?" (2 lines) at
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.or[…]_bug.cgi?id=30571 enhancement, P5 - low, ---,, 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 joined #koha
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.or[…]_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.or[…]_bug.cgi?id=30571 enhancement, P5 - low, ---,, 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:21 alex_ joined #koha
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[…]1_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 joined #koha
11:36 AndroUser Good day!
11:39 magnuse_ joined #koha
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
11:58 AndroUser joined #koha
12:00 marcelr sure it is
12:01 marcelr i have two other ones from you in my queue still
12:13 schnydszch joined #koha
12:15 magnuse__ joined #koha
12:17 AndroUser2 joined #koha
12:36 khall joined #koha
12:48 reiveune left #koha
12:48 AndroUser2 joined #koha
12:50 reiveune joined #koha
12:54 marie-luce joined #koha
13:04 caroline_catlady joined #koha
13:04 AndroUser2 joined #koha
13:06 caroline_crazycatlady joined #koha
13:18 AndroUser2 joined #koha
13:23 indradg joined #koha
13:24 Dyrcona joined #koha
13:31 nikkom joined #koha
13:31 nikkom
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?
13:49 AndroUser2 joined #koha
13:51 khall_ joined #koha
13:54 AndroUser2 joined #koha
14:04 pastebot "oleonard" at pasted "nikkom: SQL based on the query used in the "Patrons who haven't checked out" built-in report" (5 lines) at
14:11 AndroUser2 joined #koha
14:22 lukeg joined #koha
14:48 magnuse_ joined #koha
15:00 bag joined #koha
15:03 schnydszch joined #koha
15:03 eugene_ joined #koha
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:12 reiveune left #koha
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:21 AndroUser2 joined #koha
15:24 schnydszch joined #koha
15:27 schnydszch joined #koha
15:29 schnydszch joined #koha
15:33 AndroUser2 joined #koha
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.or[…]w_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:
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 :)
16:12 cait1 left #koha
16:47 cait joined #koha
16:49 cait joined #koha
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?
18:59 fridolin joined #koha
19:32 tcohen @later tell liliputech please take care of the follow-up I added for 21.11.x https://bugs.koha-community.or[…]g.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
22:43 AndroUser2 joined #koha
22:45 alexbuckley joined #koha
22:47 AndroUser2 joined #koha
22:52 AndroUser2 joined #koha
23:24 AndroUser2 joined #koha
23:36 AndroUser2 joined #koha
23:46 AndroUser2 joined #koha

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