Time Nick Message 23:50 dcook I get the majority of my groceries delivered now. I love not having to go to the grocery store to buy food. 23:50 dcook Mind you, I wonder if libraries are one of those things... 23:50 dcook I love technology but some things you really do want done in person. We do (often) crave social contact. 23:49 dcook I like Nell Hirst's comments about the future being human. 23:49 dcook This reminds me of why I want to keep promoting FOSS amongst all the library folk I know... 23:46 rangi yep 23:46 dcook I imagine cost is also fairly fluid and depends on different factors 23:45 wizzyrea more of a "you would have to ask us" thing 23:45 rangi so thats only a semi secret 23:44 rangi i dont think we force clients to sign an NDA so they cant tell people what stuff cost 23:44 wahanui even that is a little rudimentary 23:44 rangi but even that 23:44 dcook Mmm, that's true 23:44 rangi the only thing would be what we charge perhaps? 23:43 dcook Librarians can be intimidated by jargon and sometimes think the higher the cost, the better the product? 23:43 dcook More over, what trade secrets? 23:43 jcamins "where it doesn't give away trade secrets"? 23:43 dcook I posted my z39.50 authority search on Bugzilla before I even started a backport for our systems 23:42 dcook Exactly 23:42 rangi we dont have trade secrets tho 23:42 rangi yep 23:42 dcook I mean...we fall into the commercial enterprise camp too 23:42 dcook So...they're not generous about sharing... 23:42 dcook "As commercial enterprises, library vendors are very good at gathering data and intelligence about the sector, and generous about sharing, where it doesn't give away trade secrets" 23:40 rangi there ya go :) 23:40 dcook "Without advertising, we wouldn't be able to publish INCITE" 23:40 dcook "Without vendor sponsorship and exhibition booths, conference attendeance would be out of reach for most delegates" 23:36 dcook A day in the life of me is far more Koha intensive :p 23:36 dcook I suppose it is a day in the life of though 23:36 dcook It's too bad Koha only gets mentioned once in Edmund's write-up as well 23:35 dcook :/ 23:34 rangi just that they were going to 23:34 rangi they didnt tell kathryn why they moved it 23:33 rangi but thats just me being cynical after 14 years around the library world :) 23:33 rangi i totally would not put it past being 'oh we dont want to offend the proprietary scummy vendors who give us money' ;-) 23:33 rangi there even 23:33 rangi is their paid advertising in it? :) 23:32 dcook Any idea what changed? 23:32 dcook :o 23:32 rangi orignally it wasn't and was going to include an interview with a couple of koha libraries 23:32 dcook Mmm, yeah 23:32 rangi they stuck it in opinion tho eh? 23:31 dcook Nice writeup in ALIA's Incite by Kathryn Greenhill titled "RFPS and FOSS: It's all about collaboration" 23:30 dcook morning #koha 23:17 jcamins Macaroon. 23:17 * wizzyrea only recently learned these were different things 23:17 wizzyrea macaroons or macarons 23:16 jcamins Unfortunately, I have a cat happily washing himself on my lap. 23:15 jcamins Yum, macaroons! I need to make some. 23:01 druthb :) 23:00 wizzyrea both are excellent, btw. 23:00 * wizzyrea wonders if it matters if it's streaky bacon or shoulder bacon 22:59 druthb wizzyrea: Bacon is the secret of life: http://newsfeed.time.com/2013/05/09/105-year-old-woman-says-bacon-keeps-her-alive/?hpt=hp_bn18 22:40 eythian heh 22:37 wizzyrea wow that didn't take much. 22:37 cait night :) 22:37 cait alright 22:37 druthb wahanui++ 22:37 wahanui go back to bed, cait. 22:37 eythian wahanui: cait 22:37 wahanui cait is qam, not your secretary 22:37 eythian wahanui: cait 22:36 wizzyrea nice try, thanks 22:36 eythian wahanui's escaping rules are pretty dumb 22:36 druthb cait! 22:36 wahanui \ ^o^ /o/ /o\ 22:36 cait YMCA? 22:36 eythian nope, no idea 22:36 cait YMCA 22:36 cait lol 22:36 wahanui \ ^o^ /o/ /o\ 22:36 eythian wahanui: YMCA 22:36 cait YMYA? 22:36 wahanui OK, eythian 22:36 eythian wahanui: YMCA =~ s/#/\/ 22:36 wahanui OK, eythian. 22:36 eythian wahanui: YMCA is <reply> #o/ ^o^ /o/ /o\ 22:36 wahanui eythian: I forgot ymca 22:36 eythian wahanui: forget ymca 22:34 wizzyrea probably because it's silly. 22:34 wizzyrea lol he simply refuses. 22:34 wahanui We're gonna go to the o/ ^o^ /o/ /o\ 22:34 wizzyrea YMCA? 22:34 wizzyrea YMCA is <reply> We're gonna go to the \o/ ^o^ /o/ /o\ 22:34 wahanui wizzyrea: I forgot ymca 22:34 wizzyrea forget YMCA 22:34 wizzyrea there's a trick for regex replacement 22:34 wizzyrea yea naw 22:33 wahanui YMCA is 'o/ ^o^ /o/ /o\ 22:33 wizzyrea YMCA? 22:33 wizzyrea YMCA is '\o/ ^o^ /o/ /o\ 22:33 wahanui wizzyrea: I forgot ymca 22:33 wizzyrea forget YMCA 22:33 druthb '\ ? 22:33 wizzyrea lol. 22:33 wizzyrea eythian, do you have advice there? 22:33 wizzyrea lol nice try though 22:32 jcamins So much for that. 22:32 jcamins Oh well. 22:32 wahanui o/ ^o^ /o/ /o\ 22:32 jcamins ymca? 22:32 wahanui OK, jcamins. 22:32 jcamins wahanui: YMCA is <reply> \o/ ^o^ /o/ /o\ 22:31 wahanui jcamins: I forgot ymca 22:31 jcamins forget ymca 22:31 jcamins Ummm... 22:31 wahanui somebody said ymca was \ ^o^ /o/ /o\ 22:31 jcamins ymca? 22:31 jcamins YMCA is \\o/ ^o^ /o/ /o\ 22:31 wahanui jcamins: I forgot ymca 22:31 jcamins forget ymca 22:31 jcamins YMCA is \o/ ^o^ /o/ /o\ 22:31 wahanui jcamins: I forgot ymca 22:31 jcamins wahanui: forget ymca 22:28 wizzyrea that is made of winning. 22:27 eythian http://theonion.github.io/fartscroll.js/ <-- this should be easy to add to Koha I expect. 22:25 trea heh 22:24 wizzyrea oh boo not quite right wahanui 22:24 wizzyrea yuss. 22:24 wahanui somebody said YMCA was o/ ^o^ /o/ /o\ 22:24 wizzyrea YMCA? 22:24 wizzyrea YMCA is \o/ ^o^ /o/ /o\ 22:23 wizzyrea YMCA? 22:23 eythian an arm fell off at one point 22:23 eythian a bad one, anyway 22:23 eythian it's a cartwheel! 22:23 eythian |o| 22:23 eythian \ 22:23 eythian /°/ 22:22 eythian |°| 22:22 eythian \o\ 22:22 eythian = 22:22 eythian /o/ 22:16 trea o/ 22:16 wizzyrea ah it's workign 22:16 wizzyrea heroo? 22:10 cait hi eythian 22:07 wahanui bonjour, eythian 22:07 eythian hi 21:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6709 normal, P5 - low, ---, bgkriegel, Pushed to Stable , marc21_field_006.xml and marc21_field_008.xml can't be translated. 21:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9358 normal, P5 - low, ---, bgkriegel, Pushed to Stable , Fixed field plugins for MARC21 should be updated for MARC21 update #15 21:03 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 6709 - marc21_field_006.xml and marc21_field_008.xml can't be translated 21:03 jenkins_koha * Chris Cormack: Bug 6709 : Patch for testing translating .xml files 21:03 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 9358 - Followup - Fixed field plugins for MARC21 should be updated for MARC21 update #15 21:03 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 9358 - Fixed field plugins for MARC21 should be updated for MARC21 update #15 21:03 jenkins_koha Project Koha_3.10.x build #115: SUCCESS in 41 min: http://jenkins.koha-community.org/job/Koha_3.10.x/115/ 21:01 cait wb 21:01 rangi back 21:01 wizzyrea I always *knew* gmcharlt was a time lord! 20:53 cait gmcharlt: :) 20:52 trea and don't get me started with the tribbles frameworks. yeesh. 20:52 * gmcharlt remembers the battles yet to come, concerning the TARDIS integration support that will be added to Koha 20:50 cait :) 20:50 trea sure, if you want 20:49 Dyrcona old message from the future.... 10.3.5? :) 20:46 trea old message 20:46 trea bah disregard that 20:45 trea morning #koha - i'm getting an internal server error on a 10.3.5 koha site when modifying 20:22 * rangi heads off to school 20:21 jenkins_koha Starting build #115 for job Koha_3.10.x (previous build: SUCCESS) 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10150 normal, P5 - low, ---, koha-bugs, Pushed to Stable , koha-email-disable error handling 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10044 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Doubled up paging on order receive 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9250 enhancement, P5 - low, ---, robin, Pushed to Stable , Provide commands to allow handling of SIP servers in the packages 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10041 normal, P5 - low, ---, koha-bugs, Pushed to Stable , Provide a koha-translate script to aid package users on installing translations 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10101 normal, P5 - low, ---, chris, RESOLVED FIXED, koha-enable error handling 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10150 - koha-email-disable error handling 20:21 jenkins_koha * Jonathan Druart: Bug 10044: Remove duplicate pagination on the pending orders page. 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10104 normal, P5 - low, ---, chris, RESOLVED FIXED, koha-disable error handling 20:21 jenkins_koha * Magnus Enger: Bug 9250 - Followup to add koha-*-sip commands to koha-common.xml 20:21 jenkins_koha * Robin Sheat: Bug 9250 - [SIGNED-OFF] provide commands to manage the SIP server 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10144 normal, P5 - low, ---, koha-bugs, RESOLVED FIXED, koha-start-zebra error handling 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10041 - Provide a koha-translate script to aid package users on installing translations 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10101 - Follwup: fix param check 20:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10149 normal, P5 - low, ---, koha-bugs, RESOLVED FIXED, koha-restart-zebra error handling 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10101 - make koha-enable more robust 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10104 - Followup: fix param check 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10104 - make koha-disable more robust 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10144 - koha-start-zebra error handling 20:21 jenkins_koha * Tomas Cohen Arazi: Bug 10149 - koha-restart-zebra error handling (rewording) 20:21 jenkins_koha Project Koha_3.10.x build #114: SUCCESS in 42 min: http://jenkins.koha-community.org/job/Koha_3.10.x/114/ 20:17 cait oleonard++ ie-- 20:17 cait :) 20:11 rangi cya oleonard 20:11 oleonard Bye #koha 20:11 * oleonard shakes fist 20:11 oleonard And when I find that guy... 20:11 rangi hmm 20:10 gmcharlt who incremented IE? 19:59 jcamins ^^ wahanui can fill in when huginn fails 19:59 huginn oleonard: Karma for "IE" has been increased 1 time and decreased 86 times for a total karma of -85. 19:59 oleonard @karma IE 19:58 huginn jcamins: unknown tag 952 19:58 wahanui The 952 field is used by Koha to store item data in MARC21 and is described at http://wiki.koha-community.org/wiki/Holdings_data_fields_%289xx%29 19:58 jcamins @marc 952 19:58 huginn rangi: The title and statement of responsibility area of the bibliographic description of a work. [a,b,c,f,g,h,k,n,p,s,6,8] 19:58 rangi @marc 245 19:58 huginn rangi: unknown tag 245a 19:58 rangi @marc 245a 19:58 rangi see 19:58 wahanui I LIKE BASEBALL 19:58 rangi bag? 19:58 rangi dani: we have a few useful bots in here, and some not so useful 19:56 huginn rangi: The current temperature in Wellington, New Zealand is 14.0°C (7:30 AM NZST on May 10, 2013). Conditions: Rain Showers. Humidity: 82%. Dew Point: 11.0°C. Pressure: 29.83 in 1010 hPa (Rising). 19:56 rangi @wunder nzwn 19:56 rangi ahh ha 19:56 jcamins It was a mailing list message. 19:56 jcamins rangi: I found it. 19:56 rangi i dont recall jcamins 19:55 rangi hmm 19:54 * jcamins waves from NYC. 19:54 rangi heya dani from NZ 19:54 jcamins There was a discussion in here about OpenLibrary not doing covers anymore. Does anyone have the link to that article? 19:54 cait hi dani from Germany 19:54 dani from Texas 19:53 dani Good afternoon 19:53 bag :D 19:53 bag dani say hi 19:53 bag rangi: there she is dani ! 19:51 rangi bag: you should tell Danielle to come say hi :) 19:51 wahanui it has been said that logs is http://irc.koha-community.org/irclog/koha/ 19:51 jcamins logs? 19:39 jenkins_koha Starting build #114 for job Koha_3.10.x (previous build: SUCCESS) 19:24 jenkins_koha Nicole C. Engard: update OverdueNoticeBcc 19:24 jenkins_koha Project Koha_Docs build #332: SUCCESS in 15 sec: http://jenkins.koha-community.org/job/Koha_Docs/332/ 19:23 jenkins_koha Starting build #332 for job Koha_Docs (previous build: SUCCESS) 19:23 jenkins_koha Nicole C. Engard: update OverdueNoticeBcc 19:23 jenkins_koha Project Koha_Docs_3.10.x build #44: SUCCESS in 14 sec: http://jenkins.koha-community.org/job/Koha_Docs_3.10.x/44/ 19:23 jenkins_koha Nicole C. Engard: update OverdueNoticeBcc 19:23 jenkins_koha Project Koha_Docs_3.8.x build #35: SUCCESS in 13 sec: http://jenkins.koha-community.org/job/Koha_Docs_3.8.x/35/ 19:23 jenkins_koha Starting build #44 for job Koha_Docs_3.10.x (previous build: SUCCESS) 19:23 jenkins_koha Starting build #35 for job Koha_Docs_3.8.x (previous build: SUCCESS) 18:34 oleonard I've always though the cataloging "plugins" were poorly named because of the end user's inability to plug anything in. 18:28 chris_n seems to be a moving target 18:27 * chris_n has never really been good a pinning a definition on user expectations in any context 18:19 oleonard I don't say that as an argument for being able to upload, just to point out what users expectations of the definition will be 18:19 jcamins oleonard: and on heavily used systems like Wordpress, that makes sense to me. 18:18 oleonard For better or worse that's part of the common definition of plugins 18:17 jcamins Since I'm still not entirely sold on the uploading, that's not part of my definition of what's important about plugins. 18:17 jcamins That's true. 18:16 jcamins I see. 18:16 jcamins Ah. 18:15 magnuse to me there is a big difference between having a system for uploading "code" through the web ui on the one hand and saying "you can add any file you like to this folder" on the other 18:12 jcamins How's that not pluggable? 18:12 magnuse guess our notions are different, then ;-) 18:11 jcamins If you're using Plack, you probably have to restart Plack. 18:11 jcamins Not really. Just create a new file and your new value builder will show up. 18:11 magnuse yeah, but the dropdown is prett fixed 18:11 jcamins You can add as many as you want. 18:11 jcamins Sure there is. Just choose them from a dropdown list. 18:11 magnuse you can choose to enable them, but you can't plug in a new one... 18:10 magnuse except the there is no way to actually "plug in" the old plugins? ;-) 18:09 jcamins magnuse: I don't know, notionally they're the same type of thing. 18:08 magnuse a bit unfortunate that we now use "plugin" for two widely different things? 17:57 * magnuse sets his aim on those 1208 fuzzy strings 16:26 cait but there are similar older reports in bugzilal I think 16:25 cait i am not sure when it changed tho :( as we are pretty behind with updating 16:21 oleonard That changes the story then. Fix regression first, later add the link to see all. 16:20 cait and also controlled by a pref only those you did, your branch did or all 16:20 cait you only see orders you are not done with 16:20 cait it's like this in 3.6 16:20 cait yep 16:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9824 normal, P5 - low, ---, koha, Needs Signoff , Hide basket with no expected items in basqket list by bookseller 16:20 oleonard cait: Bug 9824 fixes a regression? 16:09 * cait waves 15:51 jcamins oleonard++ 15:32 jcamins Since there are not going to be any further string changes in 3.12, of course, I should point out that gmcharlt's judgement is the one that matters. 15:30 oleonard Okay, I defer to your judgement in that case 15:29 jcamins The last time he submitted an entire feature, it was blocked and the result was that an incredibly cool feature is never going to go in at all. 15:29 jcamins oleonard: I have to side with marcelr on that. 15:28 * druthb pouts 15:28 oleonard jcamins: I am grumpy about that preference going in so long before the actual feature has been released. 15:28 jcamins druthb: no. 15:28 jcamins In fact, there's a patch on that path somewhere waiting to be signed off, I think. 15:28 druthb jcamins, can my new feature make it into 3.12? PLEEEEEEase? 15:27 jcamins oleonard: except that's a new feature that marcelr is in the process of submitting. 15:27 khall oleonard needs a cough drop or something ; ) 15:26 khall jcamins, gmcharlt: will do, thanks! 15:26 oleonard *cough* OpacAllowSharingPrivateLists *cough* 15:26 * druthb suggests adding http://theonion.github.io/fartscroll.js/ 15:26 gmcharlt khall: gut reacton, yes, they can go away 15:26 jcamins No point in cluttering the code with features that don't even exist. 15:25 jcamins khall: that'd be gmcharlt's call, but I'd certainly vote for "yes." 15:23 khall apparently they were part of a planned feature that never came to fruition 15:23 khall jcamins, I'm working on an extension to the library groups feature. I'm talked to nicole and she tells me the Properties groups do absolutely nothing, and haven't since their introduction in 3.0. Should I remove them while I'm in there? 15:07 tweetbot [off] twitter: @kmlussier: "Would love to see this for #egils. RT @ByWaterSolution: It's Global Bug Squashing Day in the #KohaILS community: http://t.co/PaMn5OVKvJ" 14:59 tweetbot [off] twitter: @andisugandi: ""@KohaILS: #Kohails 3.10 Upgrade Notes http://t.co/7UOC3Udlpb"" 14:51 jcamins oleonard: on the theme of GBRD, I have one: "record saving code liable to send Release Manager off on murdering rampage." 14:50 jcamins I think I need a higher alcohol content in my tea. 14:48 jcamins Wildly. 14:47 jcamins Unfortunately, somewhere along the line saving an authority and saving a bib were turned into wildly different operations. 14:46 jcamins No matter what type of record it is. 14:46 jcamins At its most basic, saving a record is sticking a blog into the database. 14:45 jcamins Seriously... it's horrifying. 14:44 jcamins oleonard: heh. 14:44 oleonard Just slip a little patch in there before 3.12 jcamins 14:44 * jcamins curses the way we save records. 14:33 jcamins Agreed. 14:33 gmcharlt orders, that is 14:33 gmcharlt hiding closed baskets is a reasonable default, but I can think of a lot of circumstances where acq staff need to delve into older issues 14:33 gmcharlt oleonard: on the face of it, I'd want there to be more visible filtering options 14:30 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9824 normal, P5 - low, ---, koha-bugs, Needs Signoff , Hide basket with no expected items in basqket list by bookseller 14:30 oleonard cait I wonder if you have an opinion about Bug 9824, how librarians will feel about baskets no longer showing up 14:24 jcamins I've been looking at AddAuthority and ModBiblio. They inpsire murderous thoughts in the reptilian portion of my brain. 14:23 jcamins gmcharlt: actually, maybe that's what I need... tea. 14:23 gmcharlt jcamins: yep, it's morning for me --- which happily means COFFEE TIME! 14:23 nengard but i'll be back 14:23 nengard i need to head out 14:23 nengard but i can only test new ones obviously 14:23 nengard oleonard i have other libraries telling me the old ones are gone too 14:20 nengard hmmm 14:20 oleonard gmcharlt: One of my favorites! 14:19 jcamins gmcharlt: it's morning for you already? Ugh... what happened to the morning? 14:19 oleonard nengard: Something must have changed about the way suggestions are stored, because my old suggestions are showing up 14:19 huginn gmcharlt: Quote #41: "owen: Being an ass doesn't qualify as a medical condition ;)" (added by jwagner at 03:13 PM, October 16, 2009) 14:19 gmcharlt @quote random 14:09 nengard :( 14:04 oleonard Yes 14:04 nengard Instead of S = squashing? 14:04 nengard R=reporting ? 14:04 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10223 critical, P5 - low, ---, koha-bugs, NEW , No suggestions showing in 3.10 14:04 nengard bug 10223 14:02 oleonard It's GBRD! 14:02 nengard report coming 14:02 nengard DAMN - I have confirmed a new bug 14:00 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4137 normal, P5 - low, ---, oleonard, NEW , OPACViewOthersSuggestions does not work 14:00 oleonard Bug 4137 14:00 nengard oleonard is there a bug report for that? 13:59 nengard :( 13:58 oleonard nengard: When I saw that OPACViewOthersSuggestions has been broken for three years I threw up my hands and walked away 13:58 nengard hmmm 13:57 oleonard nengard: I noticed weird stuff about suggestions too but I didn't narrow it down 13:55 nengard I have a couple reports of this but no 3.10.5 test bed to confirm 13:55 nengard has anyone noticed in 3.10.5 that purchase suggestions aren't showing in the opac anymore? 13:55 tweetbot [off] twitter: @kohails: "#KohaILS 3.10 Upgrade Notes http://t.co/LSdrhngmmK" 13:30 oleonard OPACFineNoRenewals broken? I can't renew in the OPAC even though my OPACFineNoRenewals pref is blank 13:23 tweetbot [off] twitter: @libriotech: "It's on! http://t.co/7PGbbrZJIR # KohaILS" 13:23 tweetbot [off] twitter: @ByWaterSolution: "It's Global Bug Squashing Day in the #KohaILS community: http://t.co/UoJJJFAdUG Join Us!" 13:20 mtj just about to head to bed oleonard :) 13:17 oleonard mtj: What are you doing awake? 13:17 * magnuse runs off again 13:16 mtj hmm, i might be able to add the #hashtag to my tweetbot... 13:15 oleonard I'll just have to tweet my own horn instead. 13:14 magnuse oleonard: there was something very wrong with the tweets last time, and i have no time to troubleshoot... 12:59 jcamins Ummm... 12:58 Barrc Thanks anyway1 12:58 jcamins Barrc: so much for that idea. 12:58 Barrc jcamins: the really strange problem is that it isn't for every user (should have mentioned that!) only some and only rarely! 12:57 jcamins Barrc: incorrect mapping, pointing the barcode number to borrowernumber or vice versa? 12:56 oleonard Will the GBSD tweet bot be turned on? 12:55 Barrc LDAP woes....anyone guess why a Koha login might authenticate, via LDAP, then drop the Koha user into the wrong patron account!! 12:51 druthb mornin khall! 12:51 khall mornin druthb! 12:50 khall mornin cait! 12:40 cait tricky. 12:39 cait maybe. hm. 12:39 cait may 12:39 cait i was not sure either 12:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5992 enhancement, P5 - low, ---, paul.poulain, NEW , Biblibre various improvements for 3.4 12:39 oleonard I think Bug 5992 should be closed, but what status to use? 12:32 cait that's the right spirit! 12:32 cait :) 12:31 oleonard Yay, it's already GBSD in Kiribati! 09:14 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10033 minor, P5 - low, ---, fridolyn.somers, Pushed to Stable , dangerous query in _koha_modify_item 09:14 jenkins_koha Fridolyn SOMERS: Bug 10033 - dangerous query in _koha_modify_item 09:14 jenkins_koha Project Koha_3.8.x build #312: SUCCESS in 39 min: http://jenkins.koha-community.org/job/Koha_3.8.x/312/ 08:35 jenkins_koha Starting build #312 for job Koha_3.8.x (previous build: SUCCESS) 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10033 minor, P5 - low, ---, fridolyn.somers, Pushed to Stable , dangerous query in _koha_modify_item 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8419 normal, P5 - low, ---, kyle.m.hall, Pushed to Stable , Suspended holds appear on the daily holds queue 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7054 normal, P5 - low, ---, chris, Pushed to Stable , NORMARC: wrong default for 000 position 17 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7055 normal, P5 - low, ---, magnus, Pushed to Stable , NORMARC: Links and defaults for 008 position 15-17 and 35-37 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10097 minor, P5 - low, ---, dcook, Pushed to Stable , Hide framework selection when importing staged authority records 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9957 trivial, P5 - low, ---, oleonard, Pushed to Stable , Missing cancel link on subfield editing page 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9266 normal, P5 - low, ---, chris, Pushed to Stable , Untranslated strings in tags moderation 08:34 jenkins_koha * Fridolyn SOMERS: Bug 10033 - dangerous query in _koha_modify_item 08:34 jenkins_koha * Kyle M Hall: Bug 8419 - Suspended holds appear on the daily holds queue 08:34 jenkins_koha * Magnus Enger: Bug 7054 - NORMARC: Fix default for 000 position 17 08:34 jenkins_koha * Magnus Enger: Bug 7055 - NORMARC: Fix 008 position 15-17 and 35-37 08:34 jenkins_koha * David Cook: Bug 10097 - Hide framework selection when importing staged authority records 08:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10111 minor, P5 - low, ---, oleonard, Pushed to Stable , Layout on basket summary page a bit inconsistent 08:34 jenkins_koha * Owen Leonard: Bug 9957 - Missing cancel link on subfield editing page 08:34 jenkins_koha * Owen Leonard: Bug 9266 - Untranslated strings in tags moderation 08:34 jenkins_koha * Owen Leonard: Bug 10111 - Layout on basket summary page a bit inconsistent 08:34 jenkins_koha Project Koha_3.10.x build #113: SUCCESS in 40 min: http://jenkins.koha-community.org/job/Koha_3.10.x/113/ 07:54 jenkins_koha Starting build #113 for job Koha_3.10.x (previous build: SUCCESS) 07:47 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9957 trivial, P5 - low, ---, oleonard, Pushed to Stable , Missing cancel link on subfield editing page 07:47 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9266 normal, P5 - low, ---, chris, Pushed to Stable , Untranslated strings in tags moderation 07:47 jenkins_koha * Owen Leonard: Bug 9957 - Missing cancel link on subfield editing page 07:47 jenkins_koha * Owen Leonard: Bug 9266 - Untranslated strings in tags moderation 07:47 jenkins_koha Project Koha_3.8.x build #311: SUCCESS in 38 min: http://jenkins.koha-community.org/job/Koha_3.8.x/311/ 07:16 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 normal, P5 - low, ---, bgkriegel, Needs Signoff , Missing fields in MARC21 authority framework 07:16 * dcook needs to remember to look at bug 9826 tomorrow... 07:16 dcook Gentleman and a scholar 07:16 dcook bgkriegel++ 07:16 dcook bgkriegel ++ 07:11 dcook [off] Grr...I had forgotten about RDA in the authority frameworks... 07:09 jenkins_koha Starting build #311 for job Koha_3.8.x (previous build: SUCCESS) 06:50 cait magnuse++ 05:49 dcook (Life without Javascript is...not nice) 05:49 dcook I'm sure it's on the way over here then too 05:44 eythian yeah, we've just started to get winteryness really hitting here in the past week or two. 05:38 dcook I should get in a visit after Kohacon, but October isn't quite the same as May-August 05:38 dcook I think the prolonged autumn here is making it easier to handle all the beautiful photos I'm seeing of Canadian summer right now 05:38 dcook hehe 05:37 eythian it was a good time, and I got to see the weather back home being terrible, as I was sitting working from a back yard :) 05:36 dcook Sounds amazing. Immensely jealous :) 05:35 eythian Edinburgh (for kohacon), Brighton, Marseille, Konstanz, and then floated around the Netherlands for 3 weeks, mostly in Oosterhout and Den Haag. 05:34 dcook Where all did you end up going? 05:34 eythian so there was time to get familar with an area. 05:33 eythian well, it was OK as I was mostly spending a sizable amount of time in each place. 05:33 dcook My last Europe trip was about 3 months as well 05:33 dcook Although I could understand travel fatigue by the end 05:33 eythian it was pretty good :) 05:33 dcook Wow...that must've been great 05:31 eythian 3.5 months 05:31 dcook How long were you gone for? 05:30 eythian but there was a lot of other travelling in the whole trip anyway, so I did get my fill over all. 05:30 eythian Mostly Marseille, though I did get out to around Nemes etc. a bit. 05:29 dcook Did you stay down in Marseille or did you get out and adventure elsewhere as well? 05:29 eythian it was nice and warm 05:29 eythian I recommend summer. 05:28 dcook I would love to go at some point 05:28 eythian yeah 05:28 dcook Mmm, right. Paul did say that was last year.. 05:28 eythian yeah, France 05:28 eythian (the language, that is) 05:28 wahanui French are not. 05:28 dcook French? 05:28 eythian I spent a month there last year, I was almost beginning to get a little bit of a feel for it by the end, but it was still hard work. 05:27 dcook Few days in Switzerland and Belgium as well (which were both lovely), but... 05:27 dcook The plan was to spend about 4-8 months in France, but it was 8 days in the end 05:27 eythian heh 05:27 dcook I signed up to the Koha-Fr newsletters for that reason, but...never manage to read them all :p 05:26 dcook Nice one 05:26 eythian I was going to move there some years ago, until the financial crisis scuppered work visas. So I learnt it before I was to go, and then didn't, so I run my computers etc. in it to reduce the amount of atrophy from non-use. 05:25 dcook I open the same page in different tabs and they're loaded with different document modes. Thanks, IE... 05:25 dcook IE-- 05:25 dcook ;) 05:25 dcook eythian: I've been meaning to ask you...are you originally Dutch, Dutch ancestry, just interested in Dutch, ...? 05:25 dcook In that case... 05:25 dcook I think I follow 05:24 * dcook is googling fiercely 05:22 eythian like a brazillion different declensions. 05:21 eythian yep :) they seem to have taken a lot of the ridiculousness out of German. 05:21 dcook A Dutch girl once told me that Germans thought of Dutch as funny sounding German :p 05:20 eythian ja 05:20 dcook Dutch? 05:20 eythian dcook: no. That's not German, and cait would probably be horrified to hear you say that :) 05:19 mtj hmm, this i didnt know.. -> http://www.groklaw.net/articlebasic.php?story=20040728010339764 05:19 dcook eythian: I've been meaning to ask you...are you originally German, German ancestry, just interested in German, ...? 05:18 dcook :p 05:17 eythian doesn't work at all for me 05:17 eythian iexplorer: opdracht niet gevonden 05:17 eythian $ iexplorer 05:16 dcook IE-- 04:59 eythian http://www.groklaw.net/article.php?story=20130508130401587 <-- It's baaaaack! 04:35 mtj so, yeah… grepping for an old version string in your install-log, is a really flawed way to determine your curent version 04:30 cjh I have never manually ran make in koha, only ever when building packages. 04:29 eythian (in the install log) 04:29 cjh heh 04:29 eythian my dev install claims to be 3.01.something 04:29 eythian well, if you do an install without running the makefile, it won't reflect reality at all. 04:29 eythian the makefile gets it from kohaversion.pl 04:29 cjh oh, so it could be very wrong. 04:28 eythian the install log is produced by the makefile 04:28 eythian no 04:28 cjh is the install log just set from the ouput of updatedatabase.pl? 04:28 mtj lol, touche :D 04:27 eythian one is an install log, the other actual code. 04:27 eythian mtj: that is not the best way, the best way is to look in kohaversion.pl 04:27 cjh mtj: and yeah, install log or check for 'Version' in the system pref table 04:26 cjh mtj: we arent tryingto check the version of koha but to understand what trigger the db upgrades 04:26 dcook Thanks :) 04:26 cjh enjoy :) 04:26 dcook In any case, I'm going to grab a late lunch. Thanks again cjh, mtj, wizzyrea. You're all stars! 04:25 mtj …or am i missing something here? 04:24 mtj hmm, but surely the best way to determine koha's version number, is to simply grep an assumed string in the install log? 04:22 cjh although wizzyrea having never modified it worried me, time to test! 04:19 dcook Thanks for the info, cjh :) 04:19 dcook Hmm, cool 04:19 dcook I follow you now 04:19 dcook Wow, that English barely made sense... 04:19 wizzyrea later :) 04:19 dcook Hence why when you fetch/pull, that's what triggers the update 04:19 mtompset Really. I'm leaving. Have a great day. 04:19 cjh yes 04:19 dcook So when the RM changes the XXX to the actual number...they also change Kohaversion.pl? 04:18 dcook Hmm 04:18 dcook That's the only time I've changed the db in the past 04:18 dcook Yeah, I was thinking that too, mtompset 04:18 mtompset Though, it's if condition needs updating. :) 04:17 mtompset http://wiki.koha-community.org/wiki/System_Preferences 04:17 mtompset Oh, I just thought of something related to the DB upgrades. 04:17 cjh if you had already done all the db upgrades on master, I am not sure what triggers teh upgrade (unless you do it manually or bump the version) 04:17 dcook [off] We Canadians are a bother about versions... 04:17 dcook And they wouldn't change unless triggered by Factor X 04:17 dcook They would be synced with the last upgrade 04:17 dcook Why would you have a higher kohaversion.pl than your DB version? 04:16 dcook If that's the case... 04:16 cjh wizzyrea: yeah, then kohaversion is changed to match it. 04:16 dcook Hmm 04:16 cjh whenever a db upgrade goes through for a non XXX, the the db version is updated. 04:16 wizzyrea when the RM pushes it with the right number 04:16 dcook later mtompset 04:16 mtompset Have a great day (24 hour period). :) 04:15 dcook Only when doing make upgrade? 04:15 dcook But when does the version number in the DB change? 04:15 mtompset Well, I need to get sleep. :) 04:15 wizzyrea and the db updates have xxx in them 04:15 wizzyrea actually, if I am *always* at current master 04:15 dcook Who knew? 04:15 dcook I guess BSG and robots trumps database talk 04:15 dcook yep 04:15 cjh well that escalated quickly. 04:15 wizzyrea gross. 04:14 cjh lol 04:14 wizzyrea ew, human tea 04:14 mtompset nanobots bursting with flavour. :P 04:14 dcook 2.5+ hours of spacey goodness 04:14 cjh they are quite humanoid though, so it could taste ok 04:14 wizzyrea is that like robot rock, because that's really what I want. 04:14 * dcook recently re-watched the pilot with his partner 04:14 wizzyrea MMM robot tea. 04:14 dcook I couldn't help but giggle though 04:14 dcook I know ;) 04:14 wizzyrea :) 04:14 wizzyrea ceylon 04:14 * dcook was out at Manly the other day, and saw a mention of "Cylon tea" on the menu 04:14 wizzyrea I have a git command that updates to latest master every time I checkout a branch for qa 04:13 cjh heh 04:13 wahanui wizzyrea is a Cylon, and they all have plans. 04:13 mtompset wizzyrea? 04:13 dcook Hmm 04:13 cjh it may have been that the branch you checked out (master) had a higher kohaversion.pl than the db you were testing on? 04:12 dcook I've only tested a few patches that change the db but I've never changed my version...and I don't think it's been a problem 04:12 mtompset Here, here... wizzyrea is just *that* good. :) 04:12 dcook wizzyrea: Yeah, that's what I was thinking too 04:11 wizzyrea ... they all seem to work just fine without any mucking about?! 04:11 cjh wizzyrea: you are *that* good at it. 04:11 wizzyrea why is it that I very rarely have to edit anything when I do a db update test 04:11 cjh dcook: yeah 04:10 dcook cjh: Fair enough. Hmm. So you just manually edit kohaversion.pl? 04:10 wizzyrea he did get on once 04:09 cjh dcook: yeah, but I would have to set up the koha environment correctly, I find the web installer much quicker/cleaner (as it is also what the end-user will see when my upgrade applies) 04:08 mtompset [off] Do you ever think Fairies Upgrading Koha Paul will come on IRC? 04:08 dcook cjh: Couldn't you just manually run updatedatabase.pl? 04:07 * wizzyrea giggles 04:07 cjh dcook: and in this case I bump it down as XXX doesnt update the version and I dont wat to be trapped in an infinite upgrade loop 04:07 mtompset [off] OH. YOU. DID-N'T! 04:07 eythian [off] something something automatic upgrades 04:07 wahanui interesting is, like, sometimes good and sometimes bad 04:07 dcook Interesting... 04:06 cjh dcook: koha only runs updatedatabase.pl if the database koha version is lower than that in kohaversion.pl 04:06 dcook I'm surprised that you would need to bump it to trigger it 04:06 mtompset (my guess) 04:06 mtompset bump it back down so the commit doesn't include a changed kohaversion.pl 04:06 mtompset bump it up triggers the update. 04:06 dcook cjh: Why bump it up then bump it back down? 04:05 mtompset That's the if function I was talking about, yes. :) 04:05 mtj not, if (C4::Context->preference("Version") < TransformToNum($DBversion)) {} 04:04 mtj dcoo,k if ( CheckVersion($DBversion) ) {} is the new/improved test 04:04 cjh I place XXX in the version number, bump up my kohaversion by .001, run the web installer and then bump my kohaversion back down again. 04:04 wizzyrea http://2.bp.blogspot.com/-Og7iRm8wnIY/Thxkt5RIjKI/AAAAAAAAAIs/WUPOfWAljTY/s1600/Librarians.jpeg 04:04 wizzyrea as an aside, this is rather humorous 04:03 cjh the xxx will always compare higher (as XXX becomes 999), but in SetVersion XXX will not set the version 04:03 mtompset oooo...ooo... I think I am. :) 04:03 mtj the example block is outdated, too 04:03 dcook mtj: Why's that? 04:03 * dcook just hopes that people are into the idea of z39.50 authority searching 04:03 dcook I suppose I could do an alter statement, then an update statement... 04:03 wizzyrea ooh la la 04:03 mtj ah yes - i see why the page is obsolete now :) 04:03 mtompset Is that books with their bindings and covers taken off? ;) 04:02 dcook wizzyrea: oh you :p 04:02 dcook Ideally, it would be a good idea to change all existing values in that column to bibliographic as well 04:02 wizzyrea kohaporn. hawt. 04:02 eythian We're not? 04:02 eythian I think they just don't run. For testing, I change that value. 04:02 dcook So I need to alter the db column from "description" to "recordtype" 04:02 wizzyrea :P 04:02 wizzyrea you'd think we were talking about porn. 04:02 wizzyrea i mean, I've never had an issue testing things with xxx in them 04:02 wizzyrea XXX sorry 04:02 cjh wizzyrea: it does. 04:02 mtompset perhaps it handles the XXX case nicely. 04:01 dcook Makes sense, testing on master 04:01 mtompset I didn't read the function code. 04:01 wizzyrea for the testers 04:01 wizzyrea it should do something sort of sane with xxx in ther 04:01 dcook Cool 04:01 eythian yeah 04:01 dcook submit meaning post on bugzilla for testing? 04:01 eythian and the RM does what's needed to make it make sense. 04:01 eythian you put 'XXX' in there when you submit it. 04:01 wizzyrea same. 04:01 * dcook avoids touching the db for this reason 04:01 mtompset True enough. You just take a stab at the xxx value on the end. 04:01 * wizzyrea doens't know. always found that annoying. 04:00 wizzyrea for your update? 04:00 eythian they can tweak the value in there. 04:00 mtompset They made a nice function to simplify the if. 04:00 wizzyrea you set the version number to xxx? 04:00 dcook Is it simply not using the If condition? 04:00 * dcook is just curious how you get people to test your DB change without doing the final RM steps 04:00 mtompset The file in question has many "if"s to copy and paste from. :) 04:00 eythian (the page) 03:59 eythian it's also not very nicely written. 03:59 dcook I imagine the RM would do that 03:59 dcook Yeah, that's the thing I was wondering about... 03:58 mtompset Though, mtj, with the patch I'm working on, I didn't use that if comparison. :) 03:23 mtj … and no, i dont know any newer/better page that 03:23 dcook Seems like it. I'm just hoping I don't screw up too badly :p 03:22 mtj fwiw, the page is still pretty relevant 02:56 dcook http://wiki.koha-community.org/wiki/Tutorial_for_Updating_Database_Files is marked as obsolete.. 02:56 dcook Hmm, does anyone know of any current documentation on making patches that update the database? 02:37 mtj i had some in the UK, i've never seen in NZ 02:36 mtj ive only had it once, but it sure made a lasting impression 02:35 wizzyrea I hope not, it's an abomination 02:34 dcook Do t hey sell it outside the US? 02:34 wizzyrea it is gross. 02:34 dcook Maybe as a kid 02:34 dcook I can't say I've had it since...well maybe ever 02:34 dcook mtj: lol 02:34 * wizzyrea hates jif. 02:34 dcook For grs1 indexing at least, me thinks.. 02:34 mtj … was a bizzare feeling to feel the crunch of the sugar crystals, when chewing 02:34 dcook And bib1.att maps the bib-1 attribute to the plaintext index label 02:33 dcook Then records.abs will say which MARC tags belong to which index 02:32 mtj i just couldnt believe how much sugar was in jif peanut butter, the 1st time i ate it 02:31 dcook Or I just spend way too much time looking at zebra config and bib-1 attributes :p 02:30 wizzyrea suppose I should have already known that. 02:30 wizzyrea cool thx 02:29 dcook Yep, Author / 1003 02:29 wizzyrea right ok. 02:29 dcook Depends on what is in...ccl.properties, I suppose 02:28 wizzyrea au zebra searches are author? 02:26 dcook Agreed, wahanui. Agreed. 02:26 wahanui i think lunchtime is a terrible time for a meeting 02:26 dcook Hmm, lunchtime.. 02:26 dcook ta rangi 02:25 * rangi heads off to get kids from school 02:25 dcook recordtype could work 02:25 rangi yup 02:24 dcook Vs opensearch 02:24 dcook Ah, I see 02:24 rangi z3950 02:24 dcook No idea what zed is for 02:24 dcook Which is filled with "zed" 02:24 dcook There already is a type apparently 02:24 wizzyrea type was what I was thinking 02:24 wahanui something is, like, fishy 02:24 rangi or something 02:24 rangi recordtype 02:23 rangi id change the name 02:23 dcook Hell, description isn't even a bad name for that column 02:23 dcook i.e. fill it with a default value of "biblio" and allow people to change it to "auth" to denote authority databases 02:23 rangi yeah rename it 02:23 dcook Rather than adding one in, could I subvert it to my cause? 02:22 dcook I have need of a column in z3950servers... 02:22 dcook Mind you... 02:22 dcook Makes sense to me 02:22 dcook there * 02:22 dcook I was a bit confused for a second that 02:22 rangi fix the db definition 02:22 rangi sorry the latter 02:22 rangi just alter the table 02:21 rangi i lean to the former, since the column is currently not used 02:21 rangi or make it nullable 02:21 dcook Agreed 02:21 rangi we should give it a value 02:21 rangi but its not something we should do anyway, if somethings is set not null 02:21 dcook But that would happen in older versions too 02:21 dcook At a glance, it looks like it's the STRICT_TRANS_TABLES sql mode which is causing the error 02:21 rangi cos oracle are dicks? 02:20 dcook rangi: So why would 5.6.11 cause this error? 02:15 dcook I didn't know you could initiate a commandline client from the MySQL query browser... 02:15 dcook Oh snap... 02:12 dcook lol 02:12 jcamins (P.S. there's a lesson in that: ask smart questions and you should be able to avoid becoming RM) 02:12 dcook night, jcamins 02:12 rangi cya jcamins 02:12 jcamins Good night, #koha. 02:12 jcamins Yikes. 02:11 jcamins And now I'm the Release Manager. 02:11 jcamins I started out asking lots of dumb questions. 02:11 * wizzyrea whispers file bugs on mysql 5.6 02:11 jcamins ^^ exactly 02:11 dcook Basically giving back because people gave to me 02:11 * jcamins decides to get some sleep. 02:11 UbuntuUser Well, thanks again.  I'll see what happens with mysql 5.5 02:11 dcook Or test patches 02:11 dcook But now that I know more, I try to help out others when I can 02:11 rangi http://blog.bigballofwax.co.nz/2008/08/06/write-free-software-and-people-will-send-you-peanut-butter/ <-- see 02:11 dcook Well, I still need help 02:11 dcook UbuntuUser: I started coming here because I needed help 02:10 rangi hehe 02:10 dcook hehe 02:10 wizzyrea does that count? 02:10 * wizzyrea hugs rangi 02:10 rangi :-) 02:10 rangi *hint* 02:10 rangi people give me stuff 02:10 wizzyrea Koha's fun 02:10 jcamins With "like" being a relative term. 02:10 jcamins We like to help. 02:10 UbuntuUser BTW, I've come on to this IRC channel twice...and there are multiple people active on this IRC channel.  ...I'm assuming this isn't your full time job.  Why do you do it? 02:08 UbuntuUser ok.  well I really appreciate the help. 02:08 dcook UbuntuUser: The info I gave you is also from 5.0. I'd listen to rangi ;) 02:07 rangi however it would be great if you ran it like that in testing and filed bugs for any issues you notice in the mysql log 02:07 UbuntuUser Or, there are a lot of modes settings...  Any idea what I should set this to? http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html 02:07 rangi UbuntuUser: for production i would 02:07 wizzyrea at bugs.koha-community.org 02:07 UbuntuUser I'm curious then.  Would it be best if I downgraded my mysql server to 5.5? 02:07 wizzyrea at the very least, file bugs for them :) 02:07 rangi thats what i just said :) 02:06 UbuntuUser I'm fairly certain there are other cases where this sort of this is problematic though.  Not just for adding a z39.50 server. 02:06 rangi patch the .pl 02:06 rangi 2 choices 02:06 rangi tail mysql-err or mysql.log or whatever for a while might not be a bad plan 02:05 rangi so you could send a patch to fix that, and you may well run into a couple more around the place 02:05 rangi its broken on 5.6.x 02:05 jcamins Yep, there it is. 02:05 rangi there you go then 02:04 UbuntuUser mysql> insert into z3950servers (host) values ('fish');  ===> ERROR 1364 (HY000): Field 'description' doesn't have a default value 02:04 rangi if that fails (and it works on my mysql with no description) then yep its a bug that needs to be fixed for newer mysqls 02:03 UbuntuUser That's the result of "SELECT @@GLOBAL.sql_mode;" 02:03 rangi insert into z3950servers (host) values ('fish'); 02:03 rangi can you try that above query? 02:03 UbuntuUser Interesting, I didn't know about the modes.  Here's what my server's mode is set to:  STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 02:03 rangi so its a bug to fix for new versions of mysql 02:02 jcamins Yeah, that's what I was thinking. 02:02 rangi i bet thats where jcamins is going 02:02 dcook Mhm 02:02 rangi i bet that query fails in 5.6.11 02:02 dcook Right 02:02 rangi works just fine 02:02 rangi Query OK, 1 row affected, 1 warning (0.07 sec) 02:02 rangi insert into z3950servers (host) values ('fish'); 02:02 dcook "If strict SQL mode is enabled, an error occurs for transactional tables and the statement is rolled back" 02:02 dcook "If strict mode is not enabled, MySQL sets the column to the implicit default value for the column data type." 02:01 dcook Yeah, I'm looking at that 02:01 wahanui it has been said that that is a good idea. 02:01 rangi that ? 02:01 rangi `description` text NOT NULL, 02:01 rangi tell you 02:01 rangi show create table z3950servers 02:01 UbuntuUser 5.6.11 MySQL Community Server 02:01 rangi dcook: more importantly what does 02:00 UbuntuUser 5.6.11 02:00 jcamins UbuntuUser: 5.5? 5.1? 5.0? 02:00 UbuntuUser latest version of MySQL...running on Windows Server 2012 01:59 dcook rangi: So what is the default value for `description` in your db? 01:59 jcamins UbuntuUser: wait, I have an idea. What version of MySQL? 01:59 dcook Intriguing 01:58 rangi and that line has not changed sine 2011-08-26 01:58 dcook Admittedly, I don't know how a default value would be there, then not be there, then be there again 01:58 UbuntuUser Yes, my copy of kohastructure.sql matches rangi's assessment.  A new DB would be the same as the one I had from the 3.8 upgrade 01:58 dcook Mine are all upgraded from previous versions 01:58 dcook I don't have a database that was made in 3.8 either 01:57 rangi and you said it says its not null 01:57 rangi because it says to make it not null 01:57 dcook If they created an instance of 3.8.x 01:57 dcook rangi: Why's that? 01:56 rangi you recreate it, will be exactly the same 01:56 rangi i pasted the line from kohastructure.sql its set to not null 01:56 rangi yeah but that wont change anything 01:56 UbuntuUser I could.  I don't have any data in my site yet.  I just installed it a couple of days ago. 01:55 rangi don't do that 01:54 UbuntuUser What's the simplest way to generate a new database?  use the scripts to remove the site and add a new one? 01:54 UbuntuUser Keep in mind, this was actually a problem in the 3.8 install 01:54 dcook Indeed 01:53 UbuntuUser Like I said, I can add "description" and give it a value of ''  ... but this error makes me think that something went wrong. 01:53 dcook Hmm, so maybe it is a DB issue after all 01:53 UbuntuUser for the InsertInto, I have ""(host,port,db,userid,password,name,checked,rank,syntax,encoding,timeout) "  -- no "description" 01:52 dcook So go to /usr/share/koha/intranet/cgi-bin/admin/z3950servers.pl and look at line 133 01:51 UbuntuUser yes, sorry.  "line 132ish, nothing is set for description" 01:51 * dcook is looking at that right now as well 01:51 dcook you mean description? 01:50 UbuntuUser but I just checked the latest git version of z3950servers.pl  ... line 132ish, nothing is set for 'default' 01:50 wizzyrea facepalm. 01:50 wizzyrea er in the history 01:50 rangi the revert line is thenext line up 01:50 * wizzyrea just notes it's presence in that file 01:50 wizzyrea no I know 01:50 rangi and had nothing to do with this either :) 01:50 jcamins wizzyrea: yes. 01:50 rangi yep 01:50 wizzyrea interesting, 6554, wasn't that reverted? 01:49 UbuntuUser in other words, default to NULL, but don't allow NULL 01:49 rangi that line i pasted is directly from the kohastructure.sql 01:49 dcook same 01:49 UbuntuUser In my DB, the default value is NULL and NULL is set to no. 01:49 rangi its not null 01:49 UbuntuUser what is the default value?  ''? 01:49 dcook rangi: Are you sure? 01:48 rangi no 01:48 UbuntuUser Is the default value NULL? 01:48 rangi yes 01:48 UbuntuUser is the description column supposed to be there? 01:48 dcook Hmm, but yep...also marked as not null 01:48 dcook My DB says it's default value is NULL 01:48 dcook Wait...you said NOT NULL rangi... 01:47 rangi tahts all i need to know 01:47 rangi if its not null 01:47 UbuntuUser I can paste the results of mysql's 'describe z309servers' if you want. 01:47 rangi (thats in 3.12) 01:47 rangi there's been a few changes 01:47 rangi http://git.koha-community.org/gitweb/?p=koha.git;a=history;f=admin/z3950servers.pl;h=92cc3e59f68315a34d4389e630b33b289e6484fd;hb=978d7a97323447ab4802a42cebb838cfef1a2845 01:46 UbuntuUser Honestly, I used oldstable by mistake 01:46 rangi yep 01:46 rangi `description` text NOT NULL, -- unused in Koha 01:46 wizzyrea though, description in that table has been there for ages 01:46 rangi but its most likely code 01:46 UbuntuUser I was just checking the 3.8 version...unfortunately I don't know now  (It's too far back in my putty buffer...lost it)  I just installed it this past weekend though. 01:45 wizzyrea or a missed database update 01:45 rangi it could be either dcook 01:45 dcook From the sound of it, it does sound like a code issue rather than a DB issue 01:45 dcook What 3.8 version were you using UbuntuUser? 01:45 jcamins A problem with your installation, I think. 01:45 jcamins Nope. 01:45 UbuntuUser Is it a known problem? 01:44 dcook Mhm 01:44 jcamins Oh, if this is an old problem, upgrading isn't going to fix it. 01:44 rangi hmm 01:44 UbuntuUser I did have this same problem with the z39.50 DB table structure before upgrading to 3.10 though.  It was like that when I installed 3.8. 01:43 rangi so its 3.10.5 ? 01:43 dcook rangi: Learn more and more about Ubuntu/Debian installs every day. Sometimes I wonder why anyone would use anything but those OSs 01:43 UbuntuUser apt-get did run the DB upgrades.  No errors logged.  everything looks good. 01:43 rangi but it wont hurt to run it again like jcamins suggests 01:43 rangi dcook: he won't be, apt-get should have run that for him 01:43 UbuntuUser I haven't done anything yet.  First thing I was going to do is to catalog something, hence the desire to add US Congress z39.50 server. 01:43 jcamins UbuntuUser: I think you have to run `sudo koha-upgrade-schema instancename` 01:42 dcook And you weren't prompted to update your database in the admin interface? 01:42 UbuntuUser I have logged into both the public and admin interfaces. 01:42 UbuntuUser I can fix this error easily enough by modifying z3950servers.pl, but it seems weird that I get an error like this so early.  I'm wondering if something may have gone wrong with the install. 01:42 dcook Have you logged into the staff client yet? 01:42 dcook UbuntuUser: When you say that it seems to work great, what do you mean exactly? 01:41 UbuntuUser log:  "z3950servers.pl: DBD::mysql::st execute failed: Field 'description' doesn't have a default value at /usr/share/koha/intranet/cgi-bin/admin/z3950servers.pl line 133" 01:41 UbuntuUser Question... I just installed Koha 3.8, upgraded to Koah 3.10 using apt-get.  Almost everything seems to work great.  But there appears to be a mismatch between the code and schema.  If I try to add a z39.50 server, it doesn't get added.  There's a field called description in the DB table, but the .pl file isn't providing a value.  Here's the error 01:41 dcook The sub "displayServers" is only used in it and a test 01:41 dcook I'm curious...what's the purpose of Koha.pm? 01:04 dcook I did a conference planning course last year though, so I can't blame them for wanting to have time.. 01:04 dcook Wow...that's an early deadline. 01:00 BobB rangi ++ 01:00 rangi right, vala abstract submitted, with 1 day to spare 00:56 dcook Like you said, can't believe it's May. 00:56 dcook It's the first walk we've had time for in a while, but absolutely beautiful day for it on Sunday. 00:55 dcook rangi: That sounds really sweet 00:55 BobB you'd have passed through. that's a nice walk. 00:54 dcook Cool :). I was just up doing the Manly-Spit walk on the weekend, so I guess I would've been up near your neck of the woods near the end 00:53 BobB Not far :) 00:53 rangi http://www.thebigidea.co.nz/work/jobs-opportunities/dance/130228-are-you-maui <-- this is the kinda thing we do 00:53 BobB We're in North Sydney 00:51 dcook BobB: Sure am. Whereabouts are you folk? 00:49 BobB ah, you're in Ultimo aren't you? 00:48 BobB where is your office dcook? 00:48 dcook I guess so, eh? It's been rather nice out 00:48 BobB in mid May. I'm getting worried about next summer :) 00:47 huginn BobB: The current temperature in Sydney, New South Wales is 20.0°C (10:30 AM EST on May 09, 2013). Conditions: Partly Cloudy. Humidity: 56%. Dew Point: 11.0°C. Pressure: 30.42 in 1030 hPa (Steady). 00:47 BobB @wunder Sydney, Australia 00:47 mtj hmm, i have a pending patent on cone-shaped heads (in the cloud) , that may be affected by this new legislation :/ 00:47 huginn BobB: Error: No such location could be found. 00:47 BobB @wunder Sydney New South Wales Australia 00:45 BobB Kiwi's kicking goals again. Australia is far too close to Uncle Sam on these things 00:45 druthb Hi, BobB !:) 00:45 BobB that patent announcement is awesome. 00:45 dcook hey ya BobB 00:44 BobB hi dcook 00:44 BobB hi druthb 00:44 dcook NewZealand++ 00:44 dcook Wait...or maybe not... 00:43 dcook Ah, pinch-to-zoom failed 00:42 dcook http://au.businessinsider.com/apple-ipad-design-patent-2012-11?op=1 00:42 dcook Something about the pinch-zoom as well.. 00:42 * dcook hopes his memory is faulty 00:42 dcook While it's more "hardware" related, I seem to recall Apple having a patent on round corners... 00:41 ibeardslee mtj: very much so 00:41 dcook hey mtj 00:41 dcook Mhm 00:41 mtj ibeardslee, that reads like a little bit of win, to me :) 00:40 mtj hi all 00:38 ibeardslee http://www.iitp.org.nz/news/archives/4547-IT_Professionals_support_removal_of_Software_Patents 00:38 * dcook shrugs 00:37 jcamins I didn't see that. 00:35 ibeardslee Am I a little bit slow reading scroll back about software patents? 00:34 dcook [off] Apparently the "buy" link for the Google Mini isn't working. Silly, Google. 00:34 jcamins Yeah, that's easy. 00:32 dcook I suppose the default could be "biblio" rather than "auth" and that could be done through updatedatabase.pl... 00:32 dcook That would require everyone to update their current z39.50 server info though.. 00:31 dcook ack 00:31 dcook I figuresuppose the most long-term efficient thing is to add another column to the z39.50servers table, 00:30 dcook And tried to import a bib record as an authority record 00:30 dcook And naturally they didn't 00:30 dcook The issue is that I told a tester to just use the databases that said "authorities" in their name 00:29 dcook Nope. Right away :). Still...I'm not sure if it's the best idea. 00:29 dcook Mmm, k 00:29 jcamins Right. 00:29 dcook I meant retrieving from the remote source. You meant retrieving from the reservoir? 00:29 dcook Ahhhh, I think I follow you 00:29 jcamins So, we have the record in the reservoir. 00:28 jcamins Right. 00:28 dcook _after_? 00:28 dcook Fair enough. I could've been clearer :). 00:28 jcamins I thought you meant determining _after_ retrieval. 00:28 jcamins I didn't understand what you meant. 00:27 jcamins Hmm. 00:27 dcook Well, there are potential problems, but that's where I could see it possibly working 00:27 dcook If they're checked immediately after retrieval, I'm not sure that there should be a problem 00:27 dcook When you get your results back from the remote database, they're just raw MARC records 00:26 jcamins Right. 00:26 dcook At some stage 00:25 jcamins But authorities and bibs need to be handled in completely different ways. 00:25 dcook Mm, that's marc21 specific though.. 00:24 dcook Not very efficient, but.. 00:24 dcook If it doesn't, don't pass it into the results listing 00:24 dcook We retrieve a record, if it has a "z" in the 006 position of the leader, pass it to the results (for z39.50 authority searching) 00:24 dcook I'm not sure I follow. 00:23 jcamins No, that's not what I question working. 00:23 dcook In theory, it should, but I'm not sure about in practice 00:22 jcamins dcook: I'm not sure that'll work... 00:21 dcook Authority records should always have a "z" character there, while bibliographic records use a bunch of codes other than "z" to distinguish their bibliographic type 00:20 dcook Z39.50 searches need to take it into account, and I really don't feel like changing the database and redoing a bunch of subs, when it might be easier to just check what type of MARC record we're handling... 00:20 dcook Side note: what do you people think about using the 006 position of the Leader to differentiate between bibliographic and authority records? 00:12 wizzyrea right yea that's the seaweed I was originally thinking of 00:11 jcamins Which is what's called for in seaweed salad. 00:11 jcamins It was awakami or something like that. 00:11 jcamins This wasn't nori. 00:10 wizzyrea in salad. 00:10 wizzyrea oh, yea, nori won't work 00:10 wizzyrea you have to appreciate any writing that can make "bung-based bait-and-switch" sound like legit journalism 00:10 jcamins It was woefully unsuccessful. 00:10 jcamins wizzyrea: I just took the seaweed I had and turned it into a salad. 00:10 wizzyrea Thankfully, "This American Life" didn't uncover any anecdotes of bung-based bait-and-switch practices in America's restaurants. 00:09 wizzyrea mmmmmmmmm yummmy 00:08 eythian http://www.huffingtonpost.com/2013/01/16/imitation-calamari-sliced-pig-rectum_n_2482063.html <-- wizzyrea, you probably shouldn't listen to This American Life then. 00:08 wizzyrea some is honestly not bad. 00:07 * wizzyrea suspects you have gotten into really actually yucky seaweed sald 00:07 jcamins But even rubbery, calamari isn't this bad. 00:06 trea ^ 00:06 wizzyrea if your calamari is rubbery you've done it wrong. 00:06 wizzyrea i love calamari 00:06 mtompset sounds like yucky calamari (squid). 00:01 jcamins And I have not. 00:00 trea it's an acquired taste for certain 00:00 wizzyrea oh it must be the rubbery squeaky kind