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