IRC log for #koha, 2015-04-21

All times shown according to UTC.

Time S Nick Message
00:00 dcook At least the PQF version just did when I tried it..
00:00 dcook Yep, that works :)
00:01 dcook I'm actually rather pleased about that one..
00:02 eythian if only zebra could tell that it was a number and therefor do a numberic search on it.
00:02 eythian Perhaps we should move to a system that's smarter than that... ;)
00:02 dcook hehe
00:03 dcook yeah, the only time I can really see specifying the type would be for things like... word list, phrase, exact
00:03 dcook I think I must have run into this one before, because I have no idea how I realized that was the problem... lol
00:03 dcook I shall reward myself with maple flavoured pastries ^_^
00:03 eythian yeah, specifying the type of search is fine. Same deal for ranges.
00:04 dcook Yeah. Oh man... don't even get me started on ranges in Koha :p
00:04 dcook Well, Zebra. Well,
00:04 eythian though, I wonder if elasticsearch will let me say "title is between aardvark and antelope"
00:04 dcook It would be neat if it could
00:04 * dcook wasn't kidding about the pastries. They're delicious.
00:04 eythian yeah, I have to translate the ranges from what we prepare that's zebra-ish into something that's sane.
00:06 dcook I don't think we allow too many ranges with Zebra at the moment
00:06 dcook I think I've added one or two locally..
00:09 * dcook hopes talljoy is still around
00:09 eythian heh
00:10 dcook lol
00:10 dcook Well, I feel good finding the answer even if the person who asked the question might not know the answer now :p
00:11 talljoy joined #koha
00:12 talljoy i am.  i was paying some bills.  but yay!  i will try that dcook
00:12 dcook :D
00:13 talljoy BINGO
00:14 dcook \o/
00:16 bag so like the Canadian-Australian to have maple flavoured pastries
00:18 dcook hehe. You know it!
00:18 dcook Favourite Tim Horton's donut is the maple one as well
00:18 dcook That may also be the most Canadian thing I've ever said
00:19 chrisvella joined #koha
00:19 talljoy eh?
00:20 dcook Also topical:[…]maple-syrup-heist
00:21 talljoy ah maple syrup intrigue
00:21 dcook Sounds like a case for Miss Maple. I mean Marple.
00:21 talljoy har har har
00:21 dcook :p
00:22 dcook Anyway, glad that did the trick.
00:22 dcook Oh... interesting
00:22 wahanui it has been said that interesting is sometimes good and sometimes bad
00:23 dcook I was just thinking that we could actually just specify the itemnumber alias as numeric
00:23 dcook Which is what we apparently do for "notforloan"
00:23 dcook Might make sense since itemnumber should always be an integer
00:23 talljoy yes
00:24 dcook Might bang out a bug report for that right now
00:24 talljoy sweet
00:25 bag sweet
00:26 bag sweet like maple
00:26 bag so dcook I live on a street that is called yaple
00:26 wizzyrea that's a funny street name
00:26 bag we always say on the phone - it’s yaple like maple but with a Y
00:26 dcook Yaple? Interesting
00:26 dcook Good way of remembering :)
00:27 bag But we’re moving to portland oregon in June
00:27 dcook :O
00:27 bag well thank goodness to be out of this drought here
00:27 dcook But... who will tell us about how California is paradise when the weather is bad elsewhere?
00:27 dcook Oh yeah?
00:27 dcook Btw, the weather sucks today here :p
00:27 bag dcook: I can still do that
00:27 dcook Laid my favourite umbrella to rest..
00:28 dcook Plus, you'll be able to say you live in Portland
00:28 bag wait dcook you are getting rain - rain is awesome
00:28 dcook Rain is kind of awesome
00:28 dcook Although my pant legs are still wet, which is less awesome
00:28 dcook And I really really liked that umbrella :p
00:28 dcook I would love to visit Portland one day. What's prompting that move?
00:29 bag we can’t afford to buy a house here - we can there
00:29 bag also we want to live in a metro area
00:29 dcook Mmm, fair enough
00:29 bag do the public transport and all that
00:29 dcook Yeah, there's no way I can afford to buy a house in Sydney
00:29 dcook Alas, not a lot of great alternatives in Oz
00:30 bag hey wizzyrea say hi to trea for me :)  wish him a happy birthday
00:30 dcook hehe
00:30 bag tell trea that he’s hitting well this year for the mets :)
00:31 bag tell me that doesn’t look like trea - https://thenypost.files.wordpr[…]2014/05/duda1.jpg
00:33 bag cover your mouth when you cough talljoy_porch
00:41 dcook You know you haven't sent in a patch for a while when you can't remember your git-bz commands off by heart..
00:42 dcook talljoy / talljoy_porch: If you're interested,[…]_bug.cgi?id=14031
00:42 huginn` Bug 14031: enhancement, P5 - low, ---, gmcharlt, Needs Signoff , Itemnumber should be a numeric search in
00:47 dcook Huh... I didn't know there was a "OPACShowCheckoutName" system preference
00:47 dcook I almost told someone that didn't exist, but decided to give it a double-check first...
00:55 talljoy joined #koha
00:56 talljoy thanks dcook  i'll bookmark that bug
00:56 dcook Sweet :)
01:42 eythian dcook: I hear it's windy there today
01:42 eythian @wunder nzwn
01:42 huginn` eythian: The current temperature in Wellington, New Zealand is 18.0°C (1:30 PM NZST on April 21, 2015). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 14.0°C. Pressure: 30.33 in 1027 hPa (Steady).
01:42 eythian @wunder syd
01:42 huginn` eythian: The current temperature in Bardwell Park, Sydney, New South Wales is 14.6°C (11:42 AM AEST on April 21, 2015). Conditions: Rain. Humidity: 92%. Dew Point: 13.0°C. Pressure: 30.09 in 1019 hPa (Steady).
01:43 dcook Yeah, it's pretty windy today
01:43 JoshB joined #koha
02:19 dcook Yikes...
02:19 dcook Just did a double-click on "Delete item" and hit cancel... and it deleted it anyway!
02:21 eythian in what?
02:22 dcook Ah, it's not just the double click... it's the confirm box in general
02:22 dcook 3.14.5 atm
02:22 dcook I'm going to test in master
02:22 dcook Yikes... master too
02:23 dcook If you click "Delete" for an item in the "Edit items" area... either option on the confirm box will delete the record
02:23 dcook in Chrome
02:23 dcook or IE
02:24 eythian any different in a free software/supported browser?
02:24 dcook :p
02:24 dcook I imagine Firefox will have the problem too, but I'll check anyway ;)
02:24 dcook Admittedly I don't have heaps of experience with confirm boxes over top of links I think...
02:25 dcook I think I did something once for the Z39.50...
02:25 dcook I recall the Javascript being a bit off
02:25 dcook Hmm, I really should start using Firefox again. I forgot that I only switched away because my netbook couldn't handle it memory-wise
02:26 dcook Oooh
02:26 dcook eythian: It looks like newer Firefox doesn't have this problem :p
02:26 eythian ime, chrome is worse for memory usage.
02:26 dcook That's what I've heard lately
02:26 dcook Maybe things changed a few years ago
02:26 eythian dcook: well, there you go. Stop using proprietary software and things won't explode so badly ;)
02:27 dcook In 2013, my netbook ground to a halt on Firefox, but flew on Chrome.
02:27 dcook eythian: If only it were so easy :p
02:27 dcook I have to support back to IE 8 in this case
02:27 * dcook rubs his hands together
02:28 eythian on the staff client??
02:28 dcook Yarp
02:29 eythian we strongly recommend that people don't use IE on the staff client, and if they do it's at their own risk.
02:29 bag wow good luck
02:29 bag dcook: come work with us - we wouldn’t put you through the same pain
02:29 dcook Yeah, I say the same thing, eythian. Alas, I don't make the rules :/.
02:29 dcook haha
02:30 eythian wahanui: dcook
02:30 wahanui hmmm... dcook is missing part of that original link due to a smiley face that comes up in dcook's IRC client
02:30 eythian wahanui: dcook
02:30 wahanui hmmm... dcook is the designated masochist
02:30 eythian there ^
02:30 dcook bag: Perhaps one day
02:30 dcook eythian: That also sounds about right :p
02:30 dcook Well, except I'd have to enjoy it for it to be masochism, no?
02:30 eythian I don't judge.
02:30 dcook I knew you were going to say that :p
02:55 ngourlay joined #koha
03:11 dcook Hmm, found a solution for both Firefox and Chrome... boo IE
03:15 * eythian suggests the solution for IE is to not use it. The only way to win is not to play.
03:16 dcook Something to be said for that. I suppose some people still don't have the choice though.
03:16 dcook I was in an office last week where IE 8 was the default. Mind you, I also had Chrome on my desktop... not sure how they managed that one.
03:21 wizzyrea dcook: we have clients who lobbied their IT so hard they gave in regarding not using IE with Koha.
03:21 dcook wizzyrea: Yeah, I figure that's the way to do it
03:21 wizzyrea like, emails/support tickets every couple of hours type of thing.
03:21 dcook Mind you, in this case, it's not just IE
03:21 dcook It's also Chrome
03:21 wizzyrea I think they were tired of the web being broken :P
03:21 dcook Well, except for the solution I came up with just now..
03:23 eythian
03:29 wizzyrea lol, I hope it's his car.
03:30 ibeardslee unlikely, that car doesn't look like it has a bike rack or room for one (or the bike).
03:38 dcook Hmm, nearly identical JS in Koha and non-Koha. Non-Koha works, but Koha doesn't. Bizarre...
03:42 wizzyrea what's the problem you're trying to solve?
03:42 dcook I don't even know anymore :p
03:42 * wizzyrea was looking at that thing you fixed for localcovers a couple of years ago earlier
03:43 wizzyrea that one has always been obtuse to me.
03:43 dcook Basically, clicking on "Delete" for an item will delete it regardless of whether you choose "Confirm" or "Cancel" in anything but Firefox
03:43 dcook localcovers?
03:43 dcook which one is that?
03:43 wizzyrea don't spend too many clock cycles on it ;)
03:44 dcook Well, this all goes back to a double-click on "Delete" in IE causing a fatal software error
03:44 dcook Which I fixed by applying a patch from Joubu...
03:44 dcook Except it didn't fix it
03:44 dcook Until I did a "Dumper($data)"
03:44 dcook Even removing "Dumper($data)" has no effect
03:44 wizzyrea which delete?
03:45 wizzyrea the one on the holdings table?
03:45 dcook If you go "Edit Items" then the delete in the first td
03:45 dcook Yarp
03:45 dcook On master and certainly back to 3.14.5
03:45 wizzyrea what changed near 3.14.5 there?
03:46 dcook Oh posisbly nothing. I just mean that's when I first noticed it.
03:46 wizzyrea the delete link when you click in the cell, or the one in the first cell?
03:47 dcook First cell
03:47 dcook Also either would od the same thing
03:49 wizzyrea b36d3bc796fd1b0a4db32729c994287425f10326 this is the last time anything was done with delete
03:49 wizzyrea which is 3.14-ish
03:50 dcook I don't think that commit has anything to do with delete?
03:50 dcook Ah, I see
03:50 dcook The row rather than the links..
03:50 wizzyrea Bug 10225 - If an item isn't editable, don't show the onclick Edit/Delete menu
03:50 huginn` Bug[…]_bug.cgi?id=10225 normal, P5 - low, ---, oleonard, CLOSED FIXED, If an item isn't editable, don't show the onclick Edit/Delete menu
03:50 dcook Yeah, I figure this might have been aroudn for ages?
03:50 wizzyrea dunno, that seems like the sort of thing that people would notice.
03:50 dcook I know, right?
03:51 dcook No one mentioned it to me either..
03:51 dcook I was just testing IE for the fatal software error
03:51 dcook Then just noticed in Chrome that cancelling the delete doesn't do anything
03:51 dcook But the funny thing is... identical code in a different site works in Chrome/Firefox/IE
03:51 dcook So it looks like something weird is going on in Koha specifically
03:54 wizzyrea intranetuserjs?
03:54 wahanui intranetuserjs is in the system preferences ;)
03:54 wizzyrea oh you mean identical code to do something similar on another site, not on another koha site.
03:54 dcook Nah, that's empty
03:55 dcook Yep
03:55 dcook Sorry, I'm making no sense
03:55 dcook The current Koha code is just not going to work for anything but Firefox it seems
03:55 dcook But changing the inline onclick to a jQuery onclick handler with with e.preventDefault();
03:55 dcook Except in IE
03:55 dcook Although it should be working in newer IE...
03:59 dcook hehe jsfiddle can't even handle IE8...
03:59 dcook Makes sense..
04:04 dcook Hmm, maybe because it's not identical code..
04:06 dcook Me thinks perhaps jsfiddle is screwing things up along the way..
04:07 dcook As in, screwing it up in a way that makes it looks like it works when it doesn't..
04:07 * dcook is tossing this one in the "too hard" basket
04:12 dcook Hmm, this problem is bad and should feel bad..
04:17 wizzyrea that is the 2nd time in 5 minutes someone has mentioned the "too hard" basket.
04:18 wizzyrea to me.
04:18 wizzyrea what are the odds?!
04:18 eythian I'd work them out, but ...
04:18 dcook hehe
04:18 wizzyrea >.<
04:52 eythian joined #koha
05:43 dcook Maybe I'm going crazy...
05:43 dcook Now it's working in Chrome..?
05:44 dcook And in IE...
05:44 * dcook thinks the universe might be trolling him
05:47 dcook We did have a caching issue with something else, so... I don't know. Let's chalk it up to that somehow...
05:49 dcook Or maybe the universe is trolling both myself and cait
05:49 dcook[…]_bug.cgi?id=13943
05:49 huginn` Bug 13943: normal, P5 - low, ---, gmcharlt, NEW , Cancelling the deletion process of an item deletes item anyway
05:50 cait joined #koha
05:50 cait morning #koha
05:50 dcook hey cait
05:51 dcook Must've felt your eats burning
05:51 dcook Just saw your comment on bug 14032
05:51 huginn` Bug[…]_bug.cgi?id=14032 major, P5 - low, ---, koha-bugs, RESOLVED INVALID, Delete item "confirm" only works in Firefox
05:51 dcook That's weird!
05:51 cait more itching... it's hay fever season
05:51 cait yeah it is
05:51 cait and the library wasn't very happy with... 'I don't knwo how that can happen'
05:51 cait me neither
05:51 dcook The boss suggested doing it a bit more simply
05:52 dcook Which worked, but I don't know if that was just chance too
05:52 cait i couldn't make out any pattern
05:52 cait we tried on the phone and it didn't work for her but for me
05:52 cait then we did a screenshare to find the difference
05:52 cait using my screen an dfirefox
05:52 cait and she managed to show me the problem once, but then not again
05:52 cait it's really weird
05:53 dcook Yeah, I was doing it consistently for a while...
05:53 dcook Now it works fine
05:53 cait we shoud close one of the 2 reports as duplicate - your pick ;)
05:53 dcook Hmm, dunno. I suppose either would need to be updated, and I need to grab a very late lunch :p
05:53 dcook bbiam
05:54 cait i need to go to work
06:00 dcook you win :p
06:07 cait left #koha
06:18 dcook @later tell cait I actually have two tabs open right now... master is working and modified 3.14.5 is not..
06:18 huginn` dcook: The operation succeeded.
06:40 reiveune joined #koha
06:40 reiveune hello
06:46 paul_p joined #koha
06:47 magnuse joined #koha
06:48 * magnuse waves from trondheim, sitting next to paul_p again
06:48 magnuse @wunder trondheim
06:48 huginn` magnuse: The current temperature in Halsoen, Stjørdal, Norway is 9.6°C (8:48 AM CEST on April 21, 2015). Conditions: Partly Cloudy. Humidity: 62%. Dew Point: 3.0°C. Windchill: 10.0°C. Pressure: 30.33 in 1027 hPa (Falling).
06:49 paul_p and it's a very sunny day for now, despite what wunder says ;-)
06:50 alex_a joined #koha
06:51 alex_a bonjour
06:51 drojf joined #koha
06:51 drojf morning #koha
06:58 magnuse hiya alex_a and drojf
06:58 indradg joined #koha
06:58 indradg good afternoon #koha
06:58 magnuse hiya indradg
06:58 * indradg waves at magnuse
06:59 alex_a joined #koha
06:59 indradg people... I'm looking for some suggestion, before I file a bug and work on the patch.
07:00 indradg anyone where who has sent SMS notifications from Koha?
07:00 indradg s/where/here
07:00 p_vdk joined #koha
07:04 cait joined #koha
07:05 magnuse kia ora cait
07:05 cait hi magnuse
07:07 fridolin joined #koha
07:07 dcook storm's a brewing...
07:07 dcook ciao all
07:09 indradg hi cait
07:10 irma joined #koha
07:12 Jul joined #koha
07:13 gaetan_B joined #koha
07:13 paul_p joined #koha
07:14 gaetan_B hello
07:14 wahanui hey, gaetan_B
07:16 Joubu joined #koha
07:17 Joubu Hello #koha
07:18 sophie_m joined #koha
07:18 fridolin hello
07:18 wahanui what's up, fridolin
07:18 fridolin wahanui: fine, old friend
07:18 wahanui fridolin: sorry...
07:29 indradg just a quick query should C4::Context->preference('SMSSendUsername') be set as a local pref?
07:31 wicope joined #koha
07:51 codavid joined #koha
07:52 codavid left #koha
08:03 irma joined #koha
08:17 drojf so, what's the most useful thing i could contriubute before feature freeze? i wanted to take another look at my email encryption feature, but i think a lot has to be changed/rebased so it is probably too late for that to get in
08:19 magnuse joined #koha
08:19 reiveune left #koha
08:23 reiveune joined #koha
08:25 cait drojf: hm good question
08:25 cait rda releated patches if they are not all signed off yet maybe
08:25 cait we got the first in, but not sure if there are some missing
08:25 cait xslt only for now
08:26 cait we will have to think about changing the indexing at some point too i guess
08:26 cait or you could help me poke at Jonathan's taxes patches
08:29 cait drojf: did i scare you off now?
08:30 drojf heh no, just running around here doing things :)
08:31 cait also if you got time another sign off on bug 7981 would be cool
08:31 cait we added some follow ups
08:32 drojf is huginn` asleep?
08:32 drojf lousy bot, making me use search instead of clicking a link
08:32 huginn` Bug[…]w_bug.cgi?id=7981 normal, P5 - low, ---, benjamin.rokseth, Signed Off , Remove HomeOrHoldingBranchReturn syspref
08:33 drojf and of course i mix up the numbers in search and end up at pencil icon on item record :D
08:34 cait heh, must be a german problem witht he numbers...
08:34 cait i never end up on the right bug at first try
08:34 drojf :D
08:35 drojf it might be a problem of mixing up thoughts in german and english and the different order of numbers. like twentyseven vs siebenundzwanzig ;)
08:36 cait who knows .)
08:40 drojf in reality, it's probably just me not paying close attention. but the other sounds much more interesting ;)
08:48 mveron joined #koha
09:00 ngourlay_ joined #koha
09:05 drojf joined #koha
09:05 gerundio joined #koha
09:08 magnuse wow, what is that patch touching every .pl file?
09:11 magnuse ah, bug 9978
09:11 huginn` Bug[…]w_bug.cgi?id=9978 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Update GNU licenses header in Koha files from GPL2 to GPL3
09:25 cait magnuse: yep :)
09:29 mveron Hi everybody :-)
09:31 mveron Question: If I did a patch, somebody signed off and added a follow up (test coverage) - can i then sign off the follow up? - It's Bug 13889
09:31 huginn` Bug[…]_bug.cgi?id=13889 enhancement, P5 - low, ---, veron, Needs Signoff , Add information about cron jobs to system log
09:31 drojf mveron: sure
09:41 Joubu yes of course :)
09:47 mveron Thanks Joubou and drojf :-)
09:48 cait *sigh*
09:48 cait i am trying to write a jquery snippet to move the 'serial receive' link out of the pull down
09:49 cait and it just won't work like it should... gr.
09:52 cait hmmm
09:54 indradg joined #koha
10:01 pastebot "gerundio" at pasted "Date::Calc::PP::Add_Delta_YM(): Date::Calc::Add_Delta_YM(): not a valid date at /usr/share/koha/lib/C4/ line 2607" (17 lines) at
10:01 gerundio hi, good morning
10:01 indradg Joubu: thanks for the reply on koha-devel :-)
10:01 Joubu indradg: you are welcome
10:02 Joubu indradg: you really should have a look at the patch on the bug (and sign it :D) if you want to create your own driver
10:02 gerundio I'm getting the error I posted above when trying to check a serial subscription info
10:02 Joubu gerundio: I had the same issue yesterday
10:03 Joubu gerundio: when patching bug 14022
10:03 huginn` Bug[…]_bug.cgi?id=14022 normal, P5 - low, ---, jonathan.druart, Passed QA , Subscription form resets 'subscription length' to issues on editing
10:03 indradg Joubu: doing that exactly! the yaml file helps as most indian bulk sms providers require a SenderID param in the POST, aside from user/pass
10:03 Joubu gerundio: do you get the error when editing a subsription?
10:04 gerundio this was reported to me by our librarians when testing our update to Koha 3.18.05
10:04 cait gerundio: check if the enddate and startdate for that serial are filled
10:05 cait there was a patch for ths problem - probably pushed to master very recently
10:05 Joubu cait: maybe, but I got it yesterday with the issues/months/weeks stuff
10:05 Joubu if it's set to months, you edit it (set to items because of the bug), save, and boom with the same error
10:05 cait it#s not pushed
10:05 cait bug 13109
10:05 huginn` Bug[…]_bug.cgi?id=13109 major, P3, ---, mtj, Passed QA , Serial failure for received and general viewing
10:05 cait the title is confusing
10:05 gerundio cait, I debugged a little and I think the error is thrown when the result of this query "select max(planneddate) from serial where subscriptionid = ?" at line 2381 from lib/C4/ is "0000-00-00"
10:08 gerundio cait, both startdate and enddate for the given subscription have values
10:09 pastebot "gerundio" at pasted "Subscription date values" (59 lines) at
10:09 gerundio cait, what do you think about it given those records?
10:11 pastebot "mveron" at pasted "For cait: snippet to move the 'serial receive' link out of the pull down" (3 lines) at
10:12 mveron cait ^
10:12 cait mveron: you are a hereo
10:12 cait ah
10:12 cait i want to move it :) not hide it
10:13 mveron ...where?
10:13 cait the library complains it's annoying to click on the pull down (which i can understand) - it used to be a link in the table
10:13 cait i thik you need an each... because the link is different... i'd be happy already if it was below, although my goan was to have it appear in the first column, maybe below the issn
10:14 * Joubu closes his eyes :)
10:14 cait hm?
10:15 Joubu I prefer not to see the js code to do that
10:15 magnuse joined #koha
10:15 cait lol
10:15 cait well i can#t get it to work... so you are safe for now
10:16 cait i really miss oleonard
10:17 gerundio cait, can you paste a screenshot of what you want to do?
10:17 cait not easily sorry
10:17 cait i will just let it sit for a bit i gues and try again a bit later
10:17 cait thx for offering help :)
10:17 gerundio eheheh :)
10:17 gerundio about the dates issue
10:18 gerundio have you looked at my last paste?
10:20 Joubu gerundio: do you get the error on editing a subs?
10:20 gerundio Joubu, yes
10:21 Joubu so there is a patch, see bug 14022
10:21 huginn` Bug[…]_bug.cgi?id=14022 normal, P5 - low, ---, jonathan.druart, Passed QA , Subscription form resets 'subscription length' to issues on editing
10:21 Joubu gerundio: you have        monthlength: 500
10:22 Joubu so on editing, the dropdown list "subscription length" is set to "issues = 500" instead of "months = 500"
10:22 Joubu you save and the process don't pass where it should pass, and boom
10:22 gerundio Joubu, wait, I'm not sure about it
10:23 gerundio the error occurs when I try to access koha/serials/subscription-d​
10:23 Joubu so it's not on editing :)
10:23 gerundio I'm not sure if this is simple a view or if it's the edit form
10:23 gerundio ok, so it's simple a view
10:24 Joubu did you have a look at the bug cait sent you?
10:24 Joubu bug 13109
10:24 huginn` Bug[…]_bug.cgi?id=13109 major, P3, ---, mtj, Passed QA , Serial failure for received and general viewing
10:26 gerundio I did, he mentioned startdate and enddate but this occurs with the planneddate
10:27 * mveron ...goes for lunch...
10:28 Joubu gerundio: select count(*) from serial where planneddate="0000-00-00"; ?
10:28 gerundio 67 records
10:31 gerundio I'm not familiar with the subscription dataset so I'm not sure why would the planneddate be "0000-00-00"
10:31 cait hm is this an irregular one?
10:31 cait frequency irregular?
10:32 Joubu irregularity is not set
10:33 Joubu It does not boom for me if I set planneddate=0000
10:33 cait btw... ig ot some jquery that works :P
10:37 cait and joubu is right to close his eyes ;)
10:38 Joubu gerundio: actually it seems related to the publisheddate
10:39 Joubu but still don't get the error
10:43 gerundio Joubu, check the error log I pasted at
10:43 gerundio you'll see "Date::Calc::PP::Add_Delta_YM(0000, 00, 00, 0, 1) called at /usr/share/koha/lib/C4/ line 2607"
10:44 gerundio that date value results from the SQL query with the planneddate
10:46 Joubu From what I see, it's the publisheddate in C4::Serials::GetNextDate
10:47 ashimema is matts_away really away?
10:47 Joubu 2518         my ( $year, $month, $day ) = split /-/, $publisheddate;
10:47 Joubu ashimema: yes, he should be back soon
10:47 Joubu ~30min
10:50 gerundio Joubu, you're right, it looks like it's the $publisheddate... which in this case is also "0000-00-00"
10:50 ashimema Cheers
10:50 gerundio did you try to replicate it that way?
10:52 pastebot "Joubu" at pasted "gerundio: proposed patch for your issue" (20 lines) at
10:53 Joubu gerundio: I am really not confident with this patch, not sure at all with the side effects it could caused
10:53 Joubu gerundio: could you try this patch and open a bug report with the steps to reproduce the issue please?
10:53 gerundio Joubu, I get that feeling everytime I work on some Koha patch :D
10:59 kivilahtio joined #koha
11:00 gerundio Joubu, correction ... it is the planneddate
11:00 gerundio look at the code sequence
11:01 gerundio my ($res) = $dbh->selectrow_array('select max(planneddate) from serial where subscriptionid = ?', undef, $subscriptionid);
11:01 gerundio my $nextdate = GetNextDate($subscription, $res);
11:01 gerundio sub GetNextDate {
11:01 gerundio my ( $subscription, $publisheddate, $updatecount ) = @_;
11:02 gerundio $publisheddate is simply the name of the variable which is assigned with the value from planneddate
11:02 Joubu C4::Serials--
11:02 gerundio your patch might work, but let me just dig a little deeper and I'll get back to you
11:04 grharry joined #koha
11:12 gaetan_B joined #koha
11:17 pastebot "mveron" at pasted "Some more CSS for cait" (23 lines) at
11:18 pastebot "mveron" at pasted "Some more CSS for cait" (23 lines) at
11:19 mveron cait: pure CSS, displays dropdown as inline
11:20 cait also nice :)
11:20 mveron It is like sudoku :-)
11:20 mveron ...tu puzzle it out
11:21 mveron to
11:21 * mveron has a meeting
11:31 Joubu ashimema: ^ :)
11:32 meliss joined #koha
11:41 * barton waves the morning wave.
11:43 magnuse joined #koha
11:58 gaetan_B1 joined #koha
12:03 carmen joined #koha
12:15 tcohen joined #koha
12:16 tcohen morning
12:16 magnuse ¡hola tcohen!
12:17 NateC joined #koha
12:18 magnuse tcohen: i wanted to test your patch for bug 14006, but zebra is doing strange things,,,
12:18 huginn` Bug[…]_bug.cgi?id=14006 normal, P5 - low, ---, nengard, Needs Signoff , checks the wrong zebra index mode
12:20 tcohen oh
12:20 tcohen magnuse: i noticed that the printed message is wrong also
12:21 tcohen morning cait
12:21 misilot question, Does anyone have a report that shows the deleted titles 035a? I tried using the Deleted Titles List to Send to OCLC from the reports library, however I haven't gotten any values to show up when I change it from the controlfield 001 to the datafield 035a. Thanks :)
12:23 mveron joined #koha
12:29 collum joined #koha
12:36 pastebot "magnuse" at pasted "My Zebra Weirdness of the day" (26 lines) at
12:37 magnuse ...if anyone is curiuos
12:37 magnuse TL;DR Running "ps aux | grep zebra" indicates zebra is running, but daemon does not think it is. Searching in Koha works.
12:37 tcohen where is that running?
12:38 tcohen misilot: you need to create an SQL report using ExtractValue() to get information directly from MARC
12:38 magnuse tcohen: on my laptop
12:38 magnuse ubuntu 14.04
12:38 tcohen magnuse: what debian version?
12:38 wahanui well, debian version is 6.0
12:38 tcohen ah
12:39 tcohen wahanui: forget that
12:39 wahanui tcohen: I forgot that
12:39 magnuse wahanui: forget debian version
12:39 wahanui magnuse: I forgot debian version
12:39 tcohen wahanui: debian version is Wheezy, of course
12:39 wahanui OK, tcohen.
12:39 tcohen what debian version?
12:39 wahanui well, debian version is Wheezy, of course
12:39 tcohen LOL
12:40 tcohen misilot: here you can see an example[…]ibrary#Query_MARC
12:41 paul_p joined #koha
12:43 tcohen hi paul_p
12:43 tcohen !
12:44 paul_p hi tcohen
12:45 Dyrcona joined #koha
12:45 cait misilot: 035 is not a controlfield - it has subfields :)
12:46 cait hm ok, i see ou found that, can you paste what you got?
12:46 misilot cait and tcohen i think i figured it out.
12:46 cait ok
12:46 misilot let me paste it to the
12:48 pastebot "misilot" at pasted "035a of deleted bibliographic records" (11 lines) at
12:49 gerundio Joubu, back to the date issue on subscriptions
12:49 cait not sure if it's  problem for your catalog, but 035 is repeatable
12:50 cait you might want to also check that the number starts with the oclc orgcode
12:51 cait but it might not be necessary
12:51 gerundio I'm not really sure about what is the common approach for date validations in Koha
12:53 gerundio the GetNextDate function always returns a YYYY-MM-DD formated date
12:54 misilot cait: do you know if there is an easy way to query to see if any of our records have duplicate 035 fields?
12:55 gerundio with one exception "return unless $subscription and $publisheddate;"
12:56 JoshB joined #koha
12:56 gerundio adding your "return if $publisheddate eq '0000-00-00';" instruction, while fixing the problem, seems a very narrow condition
12:59 gerundio for bug 13109 that cait mentioned before, the solution was accomplished by adding validation for the GetNextDate result, which is this case wouldn't work
12:59 huginn` Bug[…]_bug.cgi?id=13109 major, P3, ---, mtj, Passed QA , Serial failure for received and general viewing
13:00 grharry left #koha
13:00 gerundio cait, Joubu: should the validation for a '0000-00-00' date and other invalid values be done inside GetNextDate or before caliing it?
13:03 Joubu gerundio: it depends
13:03 Joubu gerundio: since the routine will failed, it should return (undef) if the parameters are invalids
13:04 Joubu but the caller should take into account that the routine returned an unexpected result
13:09 cait misilot: hm not easily - you'd easiest see it in your report probably -they appear one after the other
13:10 misilot cait: ah, ok if they will all show up, that works for us. I might add in the checks for the orgcode later if the need arises for us.  Thank you :)
13:15 nengard joined #koha
13:16 talljoy joined #koha
13:18 gerundio Joubu, I agree with your point of view
13:18 gerundio I'd just replace your condition with a check_date validation
13:19 gerundio so the code on GetNextDate would look like this:
13:19 gerundio my ( $year, $month, $day ) = split /-/, $publisheddate;
13:19 gerundio return unless check_date($year, $month, $day);
13:20 cma joined #koha
13:21 gerundio cait, this issue is very similar to bug 13109 you mentioned before, I could see it as an extension to it, as the patch to fix it is even in the same file... should I comment on it or open a new one?
13:21 huginn` Bug[…]_bug.cgi?id=13109 major, P3, ---, mtj, Passed QA , Serial failure for received and general viewing
13:38 Joubu gerundio: please open a new one (since this one is passed qa) and linked them
13:38 Joubu link*
13:39 gerundio ok, Joubu, will do
13:44 cdickinson joined #koha
13:49 tcohen Joubu, khall: http://jenkins.koha-community.[…]a_Master_U14/351/
13:49 tcohen it is odd, and I have no clue what the problem is
13:49 khall hmmm
13:49 tcohen it is failing on all debian versions
13:51 tcohen t/db_dependent/Circulation/CheckIfIssuedToPatron.t is failing on my box too :/
13:51 tcohen it seems to me that it has to do with the DB updates
13:51 Joubu t/db_dependent/Circulation/CheckIfIssuedToPatron.t .. ok
13:51 Joubu All tests successful.
13:51 Joubu they pass here
13:54 * tcohen is collecting evidence
13:55 cait misilot: exactly what Joubu said :)
14:04 mveron Joubu: See comment on Bug 13889
14:04 huginn` Bug[…]_bug.cgi?id=13889 enhancement, P5 - low, ---, veron, Signed Off , Add information about cron jobs to system log
14:07 talljoy joined #koha
14:14 khall tcohen: same for me, it all passes
14:14 paul_p who can update ?
14:14 tcohen i can
14:14 tcohen but usually wizzyrea and gmcharlt do it
14:14 paul_p Johanna, from finland sent an email to announce the koha seminar in may, and it seems it has not been put on the website events.
14:15 paul_p tcohen =[…]a-seminar-finland
14:18 tcohen Joubu: you told me t/db_dependent/Search.t passed too on your Debian 8?
14:18 tcohen right?
14:19 tcohen btw
14:19 tcohen mailvelope++ # awesome tool, awesome devs
14:21 tcohen bingo!
14:21 tcohen bgkriegel++ bgkriegel++ # :-D
14:28 Joubu tcohen: lot of warnings and errors but at then end I got All tests successful.
14:28 tcohen thanks Joubu
14:28 tcohen it seems that something got broken on a wrongly arranged updatedatabase patch
14:29 tcohen at some intermediate point
14:29 tcohen i cannot find the root cause
14:29 * Joubu still does not know how Jenkins work...
14:29 tcohen but starting with a 3.18.00 DB and updating up to doesn't show this problems
14:29 tcohen (same for a clean DB)
14:30 BigRig joined #koha
14:32 rocio joined #koha
14:32 paul_p joined #koha
14:33 tcohen Joubu: how jenkins works is pretty straightforward actually
14:34 tcohen it connects using SSH
14:34 tcohen with a specific user (jenkins)
14:34 tcohen it does its tasks based on a configuration
14:35 tcohen right now most of the tasks poll on a git branch, looking for changes every 15 minutes
14:35 pastebot "tcohen" at pasted "Joubu" (91 lines) at
14:35 tcohen and then runs that^^^
14:37 Joubu tcohen: Does the DB recreated from scratch before the start?
14:37 Joubu I don't think so
14:37 Joubu and it should, imo
14:39 tcohen Joubu: I like the idea, I forgot to do it at some point
14:39 tcohen what would you use?
14:39 tcohen a 3.0 db?
14:39 tcohen a 3.12?
14:39 wahanui somebody said a 3.12 was due to be released on May 22, 2013. Master entered a feature slush on March 15, 2013, and will enter a feature freeze on March 22, 2013 and a string freeze on May 1.
14:42 khall Joubu: for bugs 11625 and 11747, you mean you'd like me to split out the db entry and pref stuff into a separate patch, correct?
14:44 talljoy joined #koha
14:47 Joubu tcohen: I use the db generated by bug 10337
14:47 huginn` Bug[…]_bug.cgi?id=10337 enhancement, P5 - low, ---, jonathan.druart, In Discussion , UT: The unit tests cannot be launched by everyone
14:48 Joubu khall: there is a piece on one bug, but not complete, the other part is in another bug
14:48 Joubu khall: I just would like 1 patch for 1 pref on each bug report.
14:49 Joubu with 1 patch == + sysprefs.sql + admin pref tt
14:49 Joubu khall: is it clear :-/
14:50 khall Joubu: I think so but I can see the confusion. 11747 adds two sysprefs to kohastructure, updatedatabase, and admin.pref
14:51 khall sorry, make that bug *11625* adds two sysprefs to kohastructure, updatedatabase, and admin.pref
14:51 khall whereas bug 11747 adds one syspref, but only to sysprefs.sql
14:51 huginn` Bug[…]_bug.cgi?id=11747 enhancement, P5 - low, ---, kyle, Signed Off , Default to logged in library for Overdue notice/status triggers
14:51 khall s/kohastructure/sysprefs.sql
14:52 Joubu khall: yes, that's the problem
14:52 khall I need to fix 11747 to update sysprefs.sql and admin.pref
14:52 khall no changes should be needed for 11625.
14:52 khall Is that your assessment as well?
14:53 Joubu khall:[…]ment.cgi?id=38096
14:54 Joubu should only insert 1 pref
14:54 Joubu the other one should be insert *completely* (not only to sysprefs.sql) in 11747
14:55 khall ok, I'll get it sorted out!
14:57 khall Joubu: do you have any problem with me squashing/splitting the patches without any additional edits, for clarity?
14:58 Joubu not at all, It will be better! :)
14:59 khall excellent!
14:59 tcohen clarity++
15:02 reiveune bye
15:02 reiveune left #koha
15:02 cait drojf++ good testing
15:05 paul_p cait = can you edit ?
15:06 cait paul_p: i don't think so
15:06 cait what do you need?
15:06 paul_p add an event to the calendar (in Finland). Nevermind, I'll tell johanna -the organizer- to ask again
15:07 paul_p gmcharlt unless you're around & can do it for them
15:07 tcohen paul_p: i didn't find how to do it
15:11 paul_p tcohen thx to have tried
15:11 tcohen paul_p: found it
15:13 paul_p tcohen wonderful. Can you add ? (may 21 & 22)
15:15 gaetan_B1 bye
15:15 fridolin left #koha
15:19 tcohen paul_p: done. I hope I don't piss wizzyrea for this
15:25 khall Joubu: bugs 11625 and 11747 are all cleaned up now
15:35 Oak joined #koha
15:45 Dyrcona1 joined #koha
16:19 cait left #koha
16:36 rocio joined #koha
17:00 huginn` New commit(s) kohagit: Bug 13998: (RM followup) tests expect data on the database <[…]5d9c50d4a890346db> / Bug 10131: Add a fallback if the pref search is not a valid regex <[…]c32da051d4114719e>
17:18 wnickc joined #koha
17:19 cbrannon joined #koha
17:46 tcohen joined #koha
18:13 chris_n yet another reason for FOSS:[…]l-beca-1699132210
18:14 chris_n so what if I want to run koha on my car's ecu....
18:15 indradg joined #koha
18:23 Joubu joined #koha
18:25 slef @search HTTP::OAI
18:25 huginn` slef: There were no matching configuration variables.
18:25 slef @query HTTP::OAI
18:25 huginn` slef: Bug[…]_bug.cgi?id=10662 new feature, P1 - high, ---, dcook, ASSIGNED , Build OAI-PMH Harvesting Client
18:36 RAY_ joined #koha
18:47 ray_ joined #koha
18:54 sophie_m joined #koha
19:08 indradg joined #koha
19:22 indradg__ joined #koha
19:34 edveal joined #koha
19:48 mveron joined #koha
20:02 pianohacker joined #koha
20:04 cait joined #koha
20:04 * cait has arrived for the night shift
20:05 nengard hiya cait
20:05 nengard still afternoon here
20:05 cait hi nengard
20:05 cait 22:00 here... but was out for sushi :)
20:07 nengard yum
20:07 pianohacker I should go get sushi once school is out, it's been a while
20:07 pianohacker so good
20:08 cait we hav the best sushi place here - i'd show you :)
20:08 pianohacker you are much closer to the ocean :)
20:11 tcohen joined #koha
20:11 tcohen @wunder cordoba, argentina
20:11 huginn` tcohen: The current temperature in Bo Altos de San Martin - NW, Cordoba city, Cordoba City, Argentina is 19.9°C (5:10 PM ART on April 21, 2015). Conditions: Scattered Clouds. Humidity: 53%. Dew Point: 10.0°C. Pressure: 30.21 in 1023 hPa (Steady).
20:12 cait hi tcohen :)
20:12 tcohen hi cait
20:18 nengard cait we need kohacon in your neighborhood so we can go for sushi :)
20:19 cait yep :)
20:39 cait bgkriegel++
20:55 nengard left #koha
21:14 wizzyrea tcohen: nope, no irritation from me
21:14 * tcohen breathes relieved
21:14 wahanui breathes relieved is not his fault
21:14 cait heh
21:14 * cait waves at wizzyrea
21:15 wizzyrea hi :)
21:30 eythian hi
21:30 wahanui hi, eythian
21:34 cait morning eythian :)
21:34 eythian g'day cait
21:39 cait does someone know if there is a difference between double and decimal in mysql?
21:39 ribasushi joined #koha
21:39 eythian cait: off the top of my head, I'd expect double to be floating point, and decimal to be literal digits.
21:40 cait not sure i get it
21:40 cait but they are differnet things right?
21:40 eythian yes
21:40 cait so if we are no using decimal for money fields... we should keep it that wy probably?
21:40 eythian yes
21:40 eythian in fact
21:40 eythian a float type _must never_ be used for money
21:40 eythian ever
21:41 eythian because it will become inaccurate
21:41 eythian > The FLOAT and DOUBLE types represent approximate numeric data values.
21:41 eythian you don't want approximate for money things :)
21:42 eythian > The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with monetary data.
21:42 * eythian stops quoting the mysql manual now
21:42 cdickinson cait: double is traditional double-precision floating point... while with decimal you can choose your maximum number of digits on either side of the decimal point, and the precision of calculations
21:42 cait thx :)
21:43 cdickinson decimal is guaranteed to be accurate to a certain maximum precision, apparently
21:43 cdickinson 65 or something
21:45 eythian well, it's whatever you specify
21:45 tcohen 0.1+.8_more_times..+0.1 /= 1
21:45 tcohen in float
21:46 cait eythian++ cdickinson++ #assisting qa
21:47 eythian tcohen: oh yeah?
21:47 eythian perl -e 'foreach (1..10) { $a += 0.1 } print "$a\n";'
21:47 eythian 1
21:47 eythian hah! :)
21:48 eythian well that's weird
21:48 eythian perl -e 'foreach (1..100) { $a += 0.1 } print "$a\n";'
21:48 eythian 9.99999999999998
21:48 eythian oh, no it's not
21:48 eythian duh
22:00 cait hm what can i do if a patch doesn't include the schema update?
22:01 cait haven't had thathappen so far
22:02 eythian that'd be a fail, I expect.
22:11 JoshB joined #koha
22:11 edveal joined #koha
22:16 cait eythian: it's not mandatory yet i think hm
22:16 cait something we need to decide
22:17 eythian do you mean updating kohastructure.sql, or something else?
22:18 cait the dbix schema files things
22:18 eythian oh
22:18 eythian no
22:18 eythian they get generated by the RM, I think
22:19 eythian or...something
22:19 eythian I'm not really sure, but I think something like that was the plan
22:19 wizzyrea well that's an interesting "bug that's not technically a bug"
22:20 wizzyrea unsuspended holds don't get on the holds to pull when they come off of unsuspend
22:20 wizzyrea unless you set the report back far enough to capture the date when the hold was originally placed
22:20 wizzyrea I wonder if we need to update the placed date for unsuspended holds to the unsuspend date
22:20 wizzyrea when they come off.
22:22 eythian it's probably reasonable to do that, I would guess.
22:25 cbrannon joined #koha
22:25 wizzyrea or rather the date the hold was unsuspended - not all of them have preset unsuspend dates.
22:27 cait ok
22:27 cait falling asleep on the laptop keyboard doesn't seem like a good plan
22:27 cait good night all
22:27 cait left #koha
22:46 dcook joined #koha
22:49 geek_cl joined #koha
22:50 geek_cl hi guys, is Callum Dickinson arround here ?
22:50 eythian cdickinson: ^
22:50 geek_cl thanks eythian
22:50 geek_cl ping -c1 cdickinson
22:57 dcook Hey eythian, did NZ catch any of this storm that we have here in Sydney?
22:57 eythian it rained a bit last night. I don't think it really counted as a storm
22:58 dcook Cool. I was wondering if I missed out on the warning by being out of the office last week :p
22:59 eythian we had a huge rainstorm earlier in the month, but I don't think it was the same thing. I think we're not quite close enough to share weather very often.
23:00 dcook Mmm, I suppose it is pretty rare, isn't it?
23:00 dcook I think we've caught the tail end of a couple of your storms over the past few years, but nothing too bad
23:01 eythian yeah, the big pacific cyclones will occasionally brush past us on the way somewhere else.
23:01 dcook I suppose I should time my visit for a nice time of year :p
23:01 dcook Not that I'm planning a visit yet..
23:04 eythian jan/feb/into march is usually the best here
23:04 eythian if you want summery, anyway.
23:04 dcook Summery is rather wonderful
23:05 dcook It probably says something that my older sister and I both moved to warmer climates from the arctic fortress of Saskatchewan
23:05 dcook I still think it was mostly coincidence, as I actually didn't mind winter, but summer > winter any day..
23:09 eythian <-- if a tree falls in a forest, does it have an address?
23:10 dcook O_o
23:10 eythian[…]r/all-new-zealand <-- here's the rain at the moment, not really much of anything
23:11 dcook Doesn't look too bad at all
23:11 eythian I wonder what happened to southland, it vanished in the past hour
23:11 dcook Aliens
23:11 dcook They're coming for NZ and Australia first, because we are the future
23:11 eythian probably true
23:11 dcook Here's Sydney's:
23:12 dcook Not as bad as it was earlier I think
23:12 eythian still, looks damp
23:12 eythian we had a few people stuck trying to get back here from Canberra today
23:12 eythian or, last night perhaps
23:13 dcook Oh yeah?
23:13 dcook I have a friend at the airport whose flight just got delayed
23:13 dcook Apparently the airport itself is taking on water as well
23:13 eythian got stuck in Melbourne for 8 hours once because of thunderstorms
23:13 * dcook is feeling pretty good in his leather boots, waterproof pants, and knit jacket.
23:13 dcook Yikes
23:14 dcook I almost got stuck in London for who knows how long because of snowstorms
23:14 dcook I somehow got lucky with that one... there were people living in the airport at that point :S
23:14 dcook It wasn't even that bad of a snowstorm...
23:14 dcook I suppose when you're not used to it or prepared for it, it's a lot worse though
23:17 eythian[…]objectid=11436604 <-- dcook, now may be a bad time for you to visit anyway
23:18 wizzyrea ersh.
23:18 dcook Don't tell me you lost all your maple syrup..
23:19 dcook Oh wow...
23:21 dcook Hmm, that must mean that it's getting closer to the Canadian dollar as well
23:22 dcook Sooner or later all my money will be worth the same :p
23:22 dcook Of course that doesn't fill me with too much optimism :p
23:43 dcook Hmm, who knew stepping through every single function call in a jQuery mouse click would be so tedious...

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