Time 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, ccl.properties. 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: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 talljoy eh? 00:20 dcook Also topical: http://www.bloomberg.com/bw/articles/2013-01-02/the-great-canadian-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.wordpress.com/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, http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14031 00:42 huginn` 04Bug 14031: enhancement, P5 - low, ---, gmcharlt, Needs Signoff , Itemnumber should be a numeric search in ccl.properties 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: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 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 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 http://i.imgur.com/a7UAm7j.gifv 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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 >.< 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 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13943 05:49 huginn` 04Bug 13943: normal, P5 - low, ---, gmcharlt, NEW , Cancelling the deletion process of an item deletes item anyway 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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: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 hello 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:51 alex_a bonjour 06:51 drojf morning #koha 06:58 magnuse hiya alex_a and drojf 06:58 indradg good afternoon #koha 06:58 magnuse hiya indradg 06:58 * indradg waves at magnuse 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:05 magnuse kia ora cait 07:05 cait hi magnuse 07:07 dcook storm's a brewing... 07:07 dcook ciao all 07:09 indradg hi cait 07:14 gaetan_B hello 07:14 wahanui hey, gaetan_B 07:17 Joubu Hello #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? 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: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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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 ;) 09:08 magnuse wow, what is that patch touching every .pl file? 09:11 magnuse ah, bug 9978 09:11 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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 10:01 pastebot "gerundio" at 193.136.124.225 pasted "Date::Calc::PP::Add_Delta_YM(): Date::Calc::Add_Delta_YM(): not a valid date at /usr/share/koha/lib/C4/Serials.pm line 2607" (17 lines) at http://paste.koha-community.org/50 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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/Serials.pm is "0000-00-00" 10:08 gerundio cait, both startdate and enddate for the given subscription have values 10:09 pastebot "gerundio" at 193.136.124.225 pasted "Subscription date values" (59 lines) at http://paste.koha-community.org/51 10:09 gerundio cait, what do you think about it given those records? 10:11 pastebot "mveron" at 127.0.0.1 pasted "For cait: snippet to move the 'serial receive' link out of the pull down" (3 lines) at http://paste.koha-community.org/52 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 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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-detail.pl?subscriptionid=525 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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 http://paste.koha-community.org/50 10:43 gerundio you'll see "Date::Calc::PP::Add_Delta_YM(0000, 00, 00, 0, 1) called at /usr/share/koha/lib/C4/Serials.pm 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 127.0.0.1 pasted "gerundio: proposed patch for your issue" (20 lines) at http://paste.koha-community.org/54 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 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:17 pastebot "mveron" at 127.0.0.1 pasted "Some more CSS for cait" (23 lines) at http://paste.koha-community.org/55 11:18 pastebot "mveron" at 127.0.0.1 pasted "Some more CSS for cait" (23 lines) at http://paste.koha-community.org/56 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:41 * barton waves the morning wave. 12:16 tcohen morning 12:16 magnuse ¡hola tcohen! 12:18 magnuse tcohen: i wanted to test your patch for bug 14006, but zebra is doing strange things,,, 12:18 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14006 normal, P5 - low, ---, nengard, Needs Signoff , about.pl 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:36 pastebot "magnuse" at 127.0.0.1 pasted "My Zebra Weirdness of the day" (26 lines) at http://paste.koha-community.org/57 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 http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC 12:43 tcohen hi paul_p 12:43 tcohen ! 12:44 paul_p hi tcohen 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 paste.koha-community.org 12:48 pastebot "misilot" at 127.0.0.1 pasted "035a of deleted bibliographic records" (11 lines) at http://paste.koha-community.org/58 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 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13109 major, P3, ---, mtj, Passed QA , Serial failure for received and general viewing 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: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: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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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:49 tcohen Joubu, khall: http://jenkins.koha-community.org/job/Koha_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` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13889 enhancement, P5 - low, ---, veron, Signed Off , Add information about cron jobs to system log 14:14 khall tcohen: same for me, it all passes 14:14 paul_p who can update koha-community.org ? 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 = http://vaarakirjastot.fi/web/english/koha-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 3.19.00.026 doesn't show this problems 14:29 tcohen (same for a clean DB) 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 172.16.248.212 pasted "Joubu" (91 lines) at http://paste.koha-community.org/59 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:47 Joubu tcohen: I use the db generated by bug 10337 14:47 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_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 == updatedb.pl + 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` 04Bug http://bugs.koha-community.org/bugzilla3/show_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: http://bugs.koha-community.org/bugzilla3/attachment.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 cait drojf++ good testing 15:05 paul_p cait = can you edit koha-community.org ? 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 http://vaarakirjastot.fi/koha-seminar-finland ? (may 21 & 22) 15:15 gaetan_B1 bye 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 17:00 huginn` New commit(s) kohagit: Bug 13998: (RM followup) tests expect data on the database <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1c88c819a453113dc36f08f5d9c50d4a890346db> / Bug 10131: Add a fallback if the pref search is not a valid regex <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=65cb0f5be636a15387a3996c32da051d4114719e> 18:13 chris_n yet another reason for FOSS: http://jalopnik.com/carmakers-want-to-make-working-on-your-car-illegal-beca-1699132210 18:14 chris_n so what if I want to run koha on my car's ecu.... 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: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P1 - high, ---, dcook, ASSIGNED , Build OAI-PMH Harvesting Client 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 @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++ 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 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: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 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: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 http://goo.gl/maps/zp4G1 <-- if a tree falls in a forest, does it have an address? 23:10 dcook O_o 23:10 eythian http://www.metservice.com/maps-radar/rain-radar/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: http://www.bom.gov.au/products/IDR713.loop.shtml 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 http://www.nzherald.co.nz/business/news/article.cfm?c_id=3&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...