Time  Nick         Message
23:52 rangi        night sekjal
23:51 sekjal       going to get some rest.  night, #koha
23:29 sekjal       better losing those than the biblionumber
23:29 sekjal       anything in the file that exceeds the 1MB limit would just not be indexed... so the last few items, maybe
23:28 Brooke       will it truncate summat else if you swap the caboose with the engine?
23:27 cait         night all
23:20 rangi        ahh
23:20 sekjal       by putting all the 952s at the end
23:20 sekjal       my patch just makes sure the 999$c is within the first 1MB
23:16 rangi        belts and braces
23:15 sekjal       I've already got the patch for the former
23:15 rangi        maybe not easier
23:15 rangi        the later is better
23:14 sekjal       okay, so is it easier to a) alter Koha to handle this rare case, or b) fix Net::Z3950::ZOOM to use connection options?
23:14 bg           ;)
23:14 bg           ok gotta run
23:14 bg           hmmm…  very interesting
23:13 sekjal       1676 items attached in that case
23:13 huginn       New commit(s) kohagit: Bug 6562: Silence runtime error in reserve/request.pl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bb251a484fb9acbce9b162213278d7f5a49fa269> / bug 6538 update letter.pl help file <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=13fd914b086d32c69c190a6fa0279fc2b2054780> / Fix for Bug 6695 - Layout of patron category add/edit form slightly broken <http://git.koha-community.org/gitweb/?p=koh
23:13 bg           ah
23:13 sekjal       the size of the XML record output
23:13 rangi        well theres the issue ;)
23:13 bg           or the size of your record?
23:13 bg           is that the default
23:13 bg           1.2?
23:12 sekjal       1.2 MB
23:12 sekjal       HA
23:05 rangi        you'd think so
23:03 sekjal       shouldn't that be enough, even for a MARCXML file with 1000 item fields?
23:03 sekjal       ... hmmm, but it defaults to 1MB
23:03 sekjal       there is a connection attribute called maximumRecordSize
23:02 sekjal       it doesn't provide an option for invoking ZOOM connection options
23:02 sekjal       it's Net::Z3950::ZOOM
23:02 sekjal       it's not us
23:02 sekjal       I think I may see where the problem is with the many-items biblios
23:02 sekjal       ah ha!
23:00 Brooke       set_default was knob
23:00 sekjal       have a suspension_date or suspension_interval, and then the suspension_reason
23:00 Brooke       oleonard++
22:59 rangi        :)
22:59 sekjal       privilege "CanEnterLibrary"
22:58 Brooke       bells and whistles should go off for debar
22:58 Brooke       yep
22:58 Brooke       I pick both because it's more work for Ian.
22:58 rangi        not just a suspension
22:58 rangi        its used here as 'get the hell out of hte library'
22:58 cait         would be nice to make it use conditions, like overdues or has fines too
22:58 rangi        restricted is more than that, and needs to be retained
22:58 wahanui      it has been said that Friday is It's Friday, Friday Gotta get down on Friday
22:58 Brooke       Friday?
22:57 cait         configurable blocks
22:57 rangi        yeah
22:56 sekjal       and making some kind of suspension flag or date or whatever to temporarily pause those privileges
22:56 Brooke       we can gamify that by making it a ginormous ban hammer.
22:56 sekjal       setting up patron Privileges, like "CanBorrow", "CanRenew", "CanPlaceHold", etc
22:56 sekjal       was yakking about this a little earlier today
22:55 * Brooke     nods.
22:55 rangi        woulda been really annoying if the suspension thing had killed it
22:55 Brooke       it's a few levels down now
22:54 * rangi      is glad you can still do that
22:54 rangi        yup i remember now
22:54 sekjal       there were some recent terminology changes to the templates pushed
22:54 rangi        ta
22:53 sekjal       "restricted"?
22:53 rangi        restricted maybe?
22:53 rangi        is it called something else now?
22:53 sekjal       rangi:  should be able to set that flag still on the borrower detail page
22:53 rangi        can't i do that anymore?
22:53 Brooke       lemme go see if I can figger it
22:53 rangi        but thats what the debar used to be before, before it got hijacked
22:53 Brooke       ;)
22:53 Brooke       was the guard fresh first?
22:52 * rangi      makes up a scenario
22:52 rangi        cos they punched the security guard
22:52 rangi        just to debar someone manually
22:52 rangi        no i dont want that crap
22:52 rangi        you used to be able to do it editing a patron
22:52 cait         have you applied fine in days?
22:52 cait         hm?
22:52 rangi        how the hell do you manually debar someone now?
22:47 cait         hehe
22:46 rangi        that oughta do it ;)
22:46 rangi        use the add multiple copies to add 3000 items
22:46 rangi        get a record
22:46 rangi        should be able to craft one pretty easy eh?
22:46 rangi        hmmm
22:45 sekjal       but the link to the biblio detail page is broken, because there is no biblionumber
22:45 Brooke       if I think long enough, I might shake it out of the olde bean...
22:45 sekjal       the search results appear
22:45 Brooke       i think it was an academic...
22:45 sekjal       I'm finding that even with -x, there are issues
22:45 rangi        i could well be wrong though
22:45 Brooke       it was a serial thing...
22:45 Brooke       someone did a long time ago when animals could talk
22:44 rangi        i thought if we used -x .. we were ok with that?
22:44 Brooke       hmmm
22:44 rangi        not on me
22:44 sekjal       does anyone have a Koha DB with a biblio with so many items that it breaks MARC size restrictions?
22:37 Brooke       whops eaux
22:33 huginn       New commit(s) kohagit: Follow-up to Bug 4868, Improve controls for cloning and deleting subfields <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7b2cd8e636a5b2eda0c405c2198eb09c2c35e22c> / Bug 6690: If multiple issues are received in serials-edit.pl, changing the status... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4e44667cd6737299a0fa524b4d84258dacd2c1c4> / Bug 6727 - Change on exporting and importing csv
22:33 wahanui      i guess Brooke is absolutely convinced
22:33 cait         Brooke?
22:33 cait         and anja wants to see castle charlottenburg
22:33 Brooke       baton mouche ftw
22:32 cait         perhaps a boat tour
22:32 cait         we are planning right now
22:31 rangi        ?
22:31 rangi        what are you doing tomorrow
22:31 rangi        ahh
22:31 cait         but there were too many people
22:31 cait         we wanted to do the television tower(?)
22:28 rangi        :)
22:27 cait         oh, and brandenburger tor
22:27 cait         were at a musical and I hadmy first frozen yoghurt :)
22:27 cait         we did a guided bus tour, visited the dali museum
22:27 rangi        hehe
22:27 cait         nah nice
22:27 cait         big :)
22:23 rangi        hows berlin?
22:23 cait         hi rangi
22:22 rangi        heya cait
22:22 cait         hi Brooke, hi all :)
22:21 Brooke       cait :D
22:18 rhcl         ltr
22:18 Brooke       cheers
22:18 rangi        cya later
22:18 gmcharlt     heading home, laters
22:18 gmcharlt     :)
22:16 Brooke       I thought it was just by numerous performance upgrades with an empty brag log.
22:13 gmcharlt     how to tell that gmcharlt has logged on to your server: check the sh history for "set -o vi"
22:13 gmcharlt     heh
22:12 rhcl         I remember having to adjust to ksh on Sirsi...
22:12 rangi        zsh
22:11 gmcharlt     at least make it tcsh
22:11 gmcharlt     you wound me, sir
22:11 gmcharlt     ouch
22:10 rhcl         I was going to suggest csh instead of sh
22:10 rhcl         hehe
22:10 gmcharlt     rhcl: no worries, it's a good sign that everybody else isn't crazy ;)
22:09 rhcl         Five minutes of total silence. Guess gmcharlt is on his own?
22:03 gmcharlt     hey, how about we rewrite all boot scripts in Perl ... who's with me?!?!
22:03 * Brooke     hands galen a slice of raisin cake.
22:03 Brooke       there there
22:02 Brooke       gmcharlt++
22:02 * gmcharlt   's brain is hurt - I *hate* looking sh's bizarre notion of quoting and conditional statement syntax
22:02 rangi        gmcharlt++
22:02 rangi        yay
22:02 sekjal       thanks, gmcharlt!
22:01 gmcharlt     sekjal: bg: ok, /etc/init.d/git-daemon munged so that git-daemon should start up properly the next time that the box is restarted
22:00 Brooke       It's a sticky thing like the label stuff.
22:00 Brooke       I'm surprised that hasn't been stitched in. It's one of those things.
21:59 rhcl         Brooke: yes, something for time allocation on public computers
21:59 rangi        [off] the best ones usually are
21:59 rhcl         [off] My tech assistant is quite a good programmer, but alarm clock challenged.
21:59 Brooke       you mean like reservation junk?
21:58 rhcl         [off] After this, which is pretty quickly getting to a release point, we really want to take a look at a public access computing solution. Considering Jesse's powerline as a starting point.
21:58 jcamins      Good night, #koha
21:58 jcamins      Time to call it a day.
21:58 rangi        so it does
21:57 gmcharlt     ok, seems happier now
21:57 rangi        for an opinion
21:57 rangi        but you could ask someone like bradley kuhn or someone else at sflc
21:57 rhcl         ack
21:57 rangi        i think probably gplv3+ still
21:56 rhcl         The actual content is all online from commercial/proprietary/copyrighted sources like PBS Kids and Nickelodeon. Perfectly willing to discuss this if desired...
21:56 rangi        sweet
21:55 rhcl         The clients only run a very simple py script which calls everything it needs from the webwerver. That way any changes are made in just one place and updates are very simple and easy.   Uses MySql.
21:54 rangi        right but the client software has to be installed on the client machines right? thus being distributed
21:52 rhcl         We do have a very simple server which serves up the web page used by the clients.
21:52 rangi        would be my choice
21:52 rangi        GPLv3+
21:52 rhcl         Input noted from Brooke. And yes, a bit sloppy but ment 3+.
21:52 gmcharlt     + is the way to go
21:52 rangi        hmm its not something youd use as a SaaS thing eh?
21:52 gmcharlt     there's rarely a good reason to pin to a single GPL version
21:52 jcamins      But I have no opinion, I'm just commenting on the choice of 3 versus 3+.
21:51 jcamins      I'd say 3+ instead of 3.
21:51 Brooke       I say 3. Cause it's bettah.
21:50 rhcl         rangi: we're really doing quite well with our children's computer project. Should we release it as straight GPL 3, skipping the 2+  ?   AGPL?
21:50 Brooke       all PEI schools on Koha++
21:49 rangi        yay! newsletter
21:48 * gmcharlt   starts digging
21:48 rangi        nope, still spazzing out
21:47 gmcharlt     I've bounced it, better now?
21:46 sekjal       okay, git-daemon must not be running right
21:45 wizzyrea     ya
21:44 rangi        yup
21:44 Brooke       0/
21:44 rangi        sup brooke
21:44 sekjal       fetching on git://, right?
21:43 wizzyrea     can't fetch.
21:43 wizzyrea     i have the same problem
21:43 * wizzyrea   checks fetch
21:43 rangi        cant fetch
21:43 rangi        i pushed ok
21:43 rangi        hmm
21:42 aarkerio     gracias otra vez
21:41 sekjal       rangi:  server has resources available, and git-daemon appears to be running
21:40 rangi        http://es.koha-community.org/documentacion/manual-de-koha-3-2-en-espanol/
21:39 rangi        http://es.koha-community.org/ ?
21:39 rangi        oh and have you seen the espanol site?
21:39 aarkerio     rangi, gracias!!
21:38 ketchup      is it safe to come out now?
21:36 rangi        thanks
21:35 sekjal       rangi:  checking
21:35 * magnuse    wishes #koha a peaceful night or other time of the day
21:33 rangi        aarkerio: http://koha-community.org/documentation/3-4-manual-en/  might help
21:32 rangi        fatal: The remote end hung up unexpectedly
21:32 rangi        rorohiko:[git/kcmaster-]:~/git/koha% git fetch
21:32 rangi        sekjal: hmm or not
21:31 rangi        aarkerio: have you seen the manual?
21:31 aarkerio     what is a library/branch ?
21:30 sekjal       rangi: gladly
21:30 rangi        sekjal: thanks for the git fix
21:27 rangi        heh
21:27 jcamins      :D
21:27 jcamins      [off] Who wants to get an offensive quote out of the CEO of S/D?
21:26 jcamins      [off] What we need is a different scandal to distract everyone.
21:26 rangi        yup, and delete the message
21:26 wizzyrea     it is, but we would consider that spam, right?
21:25 rangi        to me, its like s/d advertising symphony on the koha list
21:25 rangi        its a damned if you do, damned if you dont
21:25 wizzyrea     naw, lori responded
21:25 rangi        otoh so does not responding
21:24 wizzyrea     responding gives it power
21:24 wizzyrea     do not give this power.
21:24 wizzyrea     let's hope others do too
21:24 wizzyrea     yep
21:24 rangi        yep ill just leave it at lori's reply
21:24 * jcamins    just didn't know what "unified git repository" meant.
21:24 * jcamins    isn't.
21:23 wizzyrea     do not bite on this.
21:23 wizzyrea     i'm completely serious
21:23 rangi        yeah one big pile of shit
21:23 sekjal       "unified git repository" means no branches
21:23 rangi        i bet they arent, theirs is still html::template pro
21:23 rhcl         rangi can has a flat cookie. and Sanka
21:23 rangi        naw
21:23 jcamins      Does "unified git repository" mean that they're reconciling Koha and LibLime Koha?
21:23 sekjal       too late; Lori's replied
21:23 rangi        otherwise go play on your own list
21:22 rangi        :)
21:22 rangi        how about thanks and will you be submitting patches to Koha?
21:22 wizzyrea     um, best to say thanks and let it die?
21:20 jcamins      That's the intonation I was going for.
21:20 wizzyrea     deep breaths
21:20 rangi        :)
21:20 jcamins      Picture Captain Reynolds from Firefly saying "Huh."
21:19 jcamins      s/was/wasn't
21:19 jcamins      No, that was a question.
21:19 rangi        koha mailing list
21:19 wizzyrea     don't answer!
21:19 * wizzyrea   is afraid
21:19 jcamins      Huh.
21:19 rangi        someone stop me replying to amy
21:19 wizzyrea     !!
21:18 rangi        goddamnit
21:11 rhcl         I'll just send you the whole box. There's only about 6 oz of sugar in each little drop. Exactly what I need.
21:09 wizzyrea     *giggle*
21:09 wizzyrea     only if rhcl gets a successful cookie out of the deal
21:09 wizzyrea     ohsnap
21:09 jcamins      I was just pointing out my suggestion so that I can claim experience for it on chorewars. ;)
21:09 jcamins      No, it's a good idea. ;)
21:09 wizzyrea     sorry
21:09 wizzyrea     i was on the phooooone
21:09 wizzyrea     nm
21:08 wizzyrea     ah
21:08 jcamins      I suggested that way back at the beginning.
21:08 wizzyrea     and forget the lid
21:08 wizzyrea     more like a griddle
21:08 wizzyrea     you might try propping up the front feet :P
21:08 wizzyrea     two blobs and some ran down the middle between them?
21:07 wizzyrea     lol
21:07 rhcl         So next I tried just two side-by-side, and they looked a little like something else.
21:06 rhcl         First batch I put four of these small cookies on the grill, and they all ran together and came out exactly like a pancake.
21:04 jcamins      rhcl: I meant inside. ;)
21:04 jcamins      wizzyrea: intriguing.
21:04 huginn       rhcl: The current temperature in St Joseph, Missouri is 27.9�C (4:03 PM CDT on August 25, 2011). Conditions: Clear. Humidity: 45%. Dew Point: 15.0�C. Pressure: 30.12 in 1019.9 hPa (Steady).
21:04 rhcl         @wunder 64506
21:03 jcamins      If it's not too hot, you could just keep the cookie dough by your keys, and bake them as soon as you get home.
21:02 jcamins      rhcl: how hot is it?
21:01 rhcl         Oh, I'll be here for two more hours
21:01 wizzyrea     jcamins: http://feedproxy.google.com/~r/apartmenttherapy/ohdeedoh/~3/5cuCrTw9NiM/suretoplease-peanut-butter-jelly-ice-box-cookies-154621
21:01 rhcl_away    cookies on George Foreman have decidedly mixed results. The top is so heavy is squeshes 'em really flat and hard to scrape them off the grids
21:01 jcamins      rhcl_away: home.
21:00 rhcl_away    jcamins: when do I leave for where?
21:00 sekjal       git.koha-community.org responding more quickly now
20:57 aarkerio     ok, thanks again
20:56 rangi        its totally up to the rules you set
20:56 rangi        its whatever you set up
20:55 aarkerio     I mean, he must be able to borrow items
20:55 aarkerio     thanks, BTW, what is the "regular" user in Koha?  Student?
20:54 rangi        thanks
20:53 wizzyrea     awesomesauce
20:53 sekjal       on it
20:52 rangi        bg: can you take a look at the git server? its a bywater machine eh?
20:52 wizzyrea     ping sekjal
20:52 rangi        hmm no larryb
20:52 rangi        wizzyrea: yeah i get no response
20:51 rangi        to make sure holds are allowed for those item types
20:51 wizzyrea     re git.koha-community.org, it's very slow, possibly not responding
20:51 rangi        then also check your circulation rules
20:51 rangi        make sure that is on
20:51 rangi        there is one for allowing holds on items on the shelf
20:51 rangi        aarkerio: check your systempreferences
20:50 aarkerio     is a "Library" user
20:49 aarkerio     need I set a "flag" when I add a new Item?
20:48 aarkerio     why?
20:48 aarkerio     http://mononeurona.org/img/imgusers/aarkerio_2265.png
20:48 aarkerio     Hi!! somebody can help me? I have two Items but I can not ask for any of them:
20:46 jcamins      rhcl_away: when do you leave?
20:46 rangi        others having trouble with git.koha-community.org ?
20:45 rhcl_away    The only time I think about it is when I'm here at the library....OK, lemme go try.  (We don't have a toaster oven, but good idea).
20:45 wizzyrea     too*
20:45 wizzyrea     yea, in the toaster oven tho
20:45 jcamins      You'll want to tilt it, though, so the cookies don't slide out (aren't the grills angled?).
20:44 jcamins      rhcl_away: sure.
20:44 rangi        :)
20:44 rangi        why not
20:44 rhcl_away    I keep forgetting to take it home. So. I have a George Foreman grill thinger. Suppose I can bake cookies on that?
20:44 rangi        and its bad?
20:43 rhcl_away    OK, so I bought some cookie dough from somebody here at the lib raising funds for their kids for something or other...
20:42 * oleonard   realizes he's late for quitting time
20:41 rangi        it has to be loud and bassy
20:41 rangi        heh
20:41 oleonard     ...even though I don't get your taste in testing and pushing music.
20:39 * oleonard   cheers on rangi
20:39 rangi        http://soundcloud.com/hirshee/hirshee-vs-dawn-penn-you-dont
20:39 rangi        ok, time to crank some patch testing and pushing music
20:39 jcamins      I thought for a moment it was the recipe in Joy of Cooking, but it turns out that although that recipe is slightly similar, it's not the same thing.
20:38 jcamins      Nor the recipe, for that matter.
20:38 jcamins      We have no idea where the name came from.
20:38 jcamins      The recipe I follow is not shaped or rolled in sugar in any way.
20:37 jcamins      Yeah, those are not the same thing.
20:37 jcamins      I think.
20:37 wizzyrea     and sandy because they're rolled in sugar?
20:37 jcamins      Yeah. Online "sandtart" refers to a different cookie, though.
20:37 wizzyrea     tart bc of the lemon
20:37 wizzyrea     oh those look yummy
20:37 jcamins      3/4 c. or 1 c. butter (the recipe says 1 c., but I think it's wrong), 1-1/4 c. sugar, 1 tsp. vanilla extract, 1 tsp. lemon extract, 1 egg, 2 c. flour, 2 c. chocolate chips.
20:36 * wizzyrea   braces herself
20:36 * wizzyrea   googles sandtarts
20:36 * wizzyrea   imagines something completely different than cookies when she reads that name
20:35 jcamins      Sandtarts.
20:35 wizzyrea     what kind?
20:35 jcamins      And the cookies were delicious.
20:35 wizzyrea     :D
20:35 jcamins      It was glorious.
20:35 jcamins      I baked cookies for the first time all summer yesterday.
20:35 wizzyrea     to build you back up with humor and delicious food
20:35 jcamins      Yes.
20:35 wizzyrea     which is why we often talk about cookies :P
20:35 wizzyrea     they do get worn down
20:34 jcamins      I definitely understand where the stereotype that developers are unfriendly could come from.
20:34 wizzyrea     ^^
20:34 rangi        the more we'll get
20:33 rangi        the more popular it becomes
20:33 rangi        i think its a bit of both
20:33 wizzyrea     I'm thinking it is a cultural/language thing
20:33 jcamins      Has there been a bumper crop of pushy "it doesn't work, fix it now" messages on the mailing list recently, or am I just even grouchier than usual?
20:23 wizzyrea     hee
20:23 jcamins      wizzyrea: with all that QA-ing, I guess sekjal would have to be a caffeine-fueled machine. :)
20:17 wizzyrea     omg, sekjal is a bot?
20:17 huginn       libsysguy1: The current temperature in Ellis Weather Central, Tyler, Texas is 37.2�C (3:17 PM CDT on August 25, 2011). Conditions: Clear. Humidity: 38%. Dew Point: 21.0�C. Pressure: 29.20 in 988.7 hPa (Steady).  Heat advisory in effect until 9 PM CDT this evening... 
20:17 libsysguy1   @wunder 75799
20:16 oleonard     Duh.
20:16 oleonard     He was the son of Curufin, fifth son of Fëanor (son of Finwë and his first wife Míriel) and Nerdanel, and the only known grandchild of Fëanor. Little is said of his deeds during the First Age.
20:15 sekjal       sorry, was doing bot maintenance
20:15 sekjal       whoops
20:14 wizzyrea     celebrimbor?
20:11 rangi        back
20:04 rangi        ok my stop bbiab
20:02 jcamins      Kind of nifty.
20:02 jcamins      Amazon has introduced a Memcached service.
20:01 oleonard     Seeing bugs get fixed makes me inordinately happy.
20:00 rangi        and push all the waiting ones
20:00 * rangi      hopes to knock a few more small bugs off today
19:56 rangi        yay
19:54 sekjal       5866 passed QA
19:41 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
19:41 * oleonard   is sorry cait isn't here to coordinate with on Bug 6458
19:38 huginn       rangi: The current temperature in Wellington, New Zealand is 11.0�C (7:00 AM NZST on August 26, 2011). Conditions: Partly Cloudy. Humidity: 82%. Dew Point: 8.0�C. Pressure: 30.18 in 1022 hPa (Rising).
19:38 rangi        @wunder wellington nz
19:35 rangi        nod
19:34 wizzyrea     (the server itself i'm sure is not crap.)
19:34 wizzyrea     (do note, I say "crap" I mean "slower than production by quite a lot")
19:34 wizzyrea     it's still going
19:34 wizzyrea     over 40s
19:32 wizzyrea     and see what the diff is
19:32 rangi        cool thanks
19:32 wizzyrea     yep, gimme a min
19:32 wizzyrea     imma run it on our production
19:32 rangi        worth a signoff?
19:32 wizzyrea     just for fun
19:32 rangi        woot
19:31 wizzyrea     over*
19:31 wizzyrea     1566 holds olver
19:31 wizzyrea     6 seconds on our crap test server, no timing out
19:30 wizzyrea     yea bg put it on our test server last night I'll check it right now
19:30 rangi        sweet
19:30 wizzyrea     probably, I think it's on our test server, 1s.
19:29 rangi        wizzyrea: do u have time to test that one?
19:29 wizzyrea     back
19:29 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5866 minor, PATCH-Sent, ---, chris, NEW , At larger hold volume, waitingreserves.pl for all libraries times out, can cause generalized slowness
19:29 rangi        Bug 5866
19:29 rangi        Welcome?
19:28 wizzyrea     welcome
18:56 wizzyrea     libsysguy: about?
18:56 * larryb     is back (gone 00:28:36)
18:27 * larryb     is away:
18:09 * slef       ambles off
18:09 wahanui      thanks slef :)
18:09 slef         wahanui: botsnack?
18:09 slef         botsnack :)
18:09 * huginn     reloads and spins the chambers.
18:09 huginn       *BANG* Hey, who put a blank in here?!
18:09 slef         @roulette
18:09 wahanui      turns out there is, like, a template bug too, fixing that now as well
18:09 slef         turns out there?
18:08 wahanui      it has been said that now the world is in balance again
18:08 slef         now the world?
17:51 wahanui      rallying in fast cars is, like, fun
17:51 slef         rallying in fast cars?
17:49 slef         nm
17:49 jcamins      Huh?
17:48 slef         My ISP?
17:47 jcamins      And to make it doubly embarassing (however that's spelled), the question marks were automatically inserted by Javascript.
17:47 slef         ow
17:47 jcamins      Yup.
17:47 slef         OCLC's Viaf?
17:46 jcamins      That's embarrassing.
17:46 jcamins      Viaf can't handle question marks in queries.
17:41 * wizzyrea   gasps
17:41 oleonard     I'm pretty contrary about the movies, but I did like that Balrog.
17:41 wizzyrea     this metaphor has merit.
17:41 wizzyrea     burning with the fire of 1k firefox 1.0 installations
17:41 jcamins      sekjal: movie. I imagine a whip made of IE would be burning in much the way it does in the movie.
17:40 sekjal       s/'//;
17:40 sekjal       jcamins:  Brother's Hildebrandt version, or movie version?
17:40 jcamins      oleonard: hehe.
17:40 wizzyrea     tee hee
17:40 oleonard     I think he means he's currently on fire.
17:40 wizzyrea     horns and all?
17:39 jcamins      wizzyrea: I like to think I look kind of like the Balrog.
17:39 wizzyrea     oh I just made myself laugh.
17:39 * wizzyrea   imagines jcamins with a whip made of old versions of internet explorer
17:39 jcamins      slef: you bet. If you want to ask why something's not working, you'd better be using it exactly the way I told you to. ;)
17:38 wizzyrea     (I got it :))
17:38 wizzyrea     hehe
17:38 * slef       too. That's what the ;-) is about.
17:38 wizzyrea     yes, people should be free to use netscape 1.0
17:38 * wizzyrea   teases. only teasing.
17:38 slef         jcamins: wow, harsh. Screw software freedom, huh? ;-)
17:38 wizzyrea     get back in the kitchen and bake me a pie?
17:37 jcamins      wizzyrea: I sure am.
17:37 wizzyrea     :)
17:37 wizzyrea     jcamins is a ruthless dictator
17:37 wizzyrea     but I think there's some opposition to "yet another thing to run alongside koha"
17:37 wizzyrea     or they could be used together
17:37 wizzyrea     that's what http://code.google.com/userinfuser would do
17:37 wizzyrea     though I love the idea of a plugin.
17:37 wizzyrea     sekjal, in the gamifying wiki post tehre's a link to stack overflow that talks about how they do asnyc achievements (because looking at that amount of comment data realtime would be overwhelming)
17:37 jcamins      I just tell my clients "you must use Firefox or Chrome."
17:36 jcamins      slef: ah, that's not an issue for me.
17:35 slef         jcamins: they should but some people still use AOL, so do you want to bet on it? ;-)
17:35 slef         ok... I'll be in and out all evening.
17:35 jcamins      slef: I'd think browsers and proxies would have to be able to cope?
17:34 rhcl         yep, that's why I will wait--I want to look it over first.
17:34 slef         rhcl: you might want something smaller than 1300 in there, to reduce the pain to non-fatal levels. Also you mainly want to read the Content-Length in the header and junk the rest.
17:33 rhcl         /bin/echo -en "HEAD / HTTP/1.1\r\nHost:localhost\r\nRange:bytes=0-,$(perl -e 'for ($i=1;$i<1300;$i++) { print "5-$i,"; }')5-1300\r\nAccept-Encoding:gzip\r\nConnection:close\r\n\r\n" | nc localhost 80
17:33 rhcl         this afternoon I may do the test mentioned...
17:32 slef         so I'm not sure I'd want to bet against it completely
17:32 slef         jcamins: maybe, maybe not. Koha's virtualhosts also serve files (images, javascript and so on) and some browsers and proxies behave in the funniest ways.
17:31 jcamins      It seems like Koha wouldn't need to serve slices of pages.
17:29 slef         rhcl: that
17:28 oleonard     If you don't allow the self-checkout system to automatically log in does that mean a staff member has to log in manually?
17:27 slef         http://lists.grok.org.uk/pipermail/full-disclosure/attachments/20110820/848b4dca/attachment.obj
17:26 jcamins      slef: I just tried to look up the Apache DoS exploit that you mention, but it would appear that Apache's advisory site is down.
17:26 rhcl         this?  http://apache.slashdot.org/story/11/08/24/2213201/Apache-Warns-Web-Server-Admins-of-DoS-Attack-Tool?utm_source=rss1.0&utm_medium=feed
17:24 slef         oh ok. Has anyone else secured their Koha servers against the just-published apache DoS and did you have any problems doing so? (Yes, we're secured now, but something struck me as a bit odd and I just spent a while without getting to the bottom of it.)
17:19 rhcl         come on slef, we're waiting to go to lunch but none of us can leave until we see your question.  :)
17:14 slef         if no answer in a few, I'll ask then :)
17:14 slef         would like to test with one before I make a fool of myself in public :)
17:14 wizzyrea     (I consider all here "smart kids" so chances are good someone's got the answer I'm seeking)
17:13 wizzyrea     shoot, maybe someone can answer
17:12 slef         hi. Any other sysadmins in?
17:12 sekjal       could have suspended_until field
17:11 wizzyrea     and already in
17:11 wizzyrea     isn't that fine in days?
17:11 rhcl         what about being barred for a given number of days (typically kids for misbehavior), but lifted automatically on a certain date?
17:11 huginn       wizzyrea: The operation succeeded.  Quote #148 added.
17:11 wizzyrea     @quote add <oleonard> sekjal wants EVERYTHING in a matrix! <sekjal> I'm like the Anti-Neo
17:10 sekjal       I'm like the Anti-Neo
17:10 wizzyrea     can you blame him
17:10 sekjal       or a set of configured keys
17:09 sekjal       which is freetext
17:09 sekjal       or, instead of numerics, have suspension_reason
17:09 sekjal       but if they do something that revokes that permission, its bumped to 1
17:09 * larryb     is back (gone 01:13:35)
17:09 oleonard     sekjal wants EVERYTHING in a matrix! ;)
17:09 sekjal       suspension is normally 0, meaning the permission is in effect
17:09 sekjal       table has three columns:  borrowernumber, privilege, suspension
17:08 rhcl         RE "Things that debar should be able to have the debarment lifted automatically"  : we agree
17:08 sekjal       break it out to Patron Privileges:  CanBorrow, CanRenew, CanPlaceHold, etc. etc
17:08 wizzyrea     all good
17:08 rhcl         I'm talking to my TS manager over my shoulder--I don't have personal opinions on this myself...
17:07 wizzyrea     (and she was from NEKLS
17:07 wizzyrea     she talks about overdues
17:07 wizzyrea     rhcl did you see the 2nd to last comment
17:06 wizzyrea     "things" that debar should be able to have the debarment lifted automatically
17:06 rhcl         I have a friend that works for the gvt, and every project they request funding for is related to climate change, because that's where all the grant money is, even though the project may not have that as a primary study objective
17:05 wizzyrea     ok, that then
17:05 rhcl         but it's all in the wording--make it related to overdues and being barred, and we're interested.
17:04 rhcl         same here--we don't charge fines
17:04 oleonard     Similar ends. But harder to get money to spend on something relating to fines, for us.
17:03 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1698 enhancement, P3, ---, chris, NEW , Undebar patron if all items are returned
17:03 oleonard     Bug 1698
17:02 oleonard     (plus the QA contact isn't the bugs list)
17:02 rhcl         However, we're willing to be accommodating as long as the terminology is clear to us.
17:02 oleonard     Ah wait, that's not the bug I'm thinking of!
17:02 wizzyrea     well oleonard in your defense that was only a month ago
17:02 rhcl         We us the term "barred" to mean a patron's account is essentially frozen - no checkouts and no use of the computers until the problem, whatever that may be (as above), is fixed.
17:01 wizzyrea     whew.
17:01 wizzyrea     oh, I did
17:01 wizzyrea     did I not put the message on the bug, that was dumb of me
17:01 wizzyrea     I think you must have missed it
16:59 sekjal       ~borrow
16:59 sekjal       it's being used a little differently now, just to designate that the patron cannot borrower
16:59 sekjal       originally, "debarred" meant more like "vandalized equipment" or "is a physical threat to the librarians"
16:58 oleonard     Or did I assume we were already out of money? :P
16:58 oleonard     Did I not see that NEKLS was seeking co-sponsors, or did I forget?
16:58 rhcl         well, it's just that we're in the beginning of our FY, and I have a little bit of dev money, and somebody will snatch it if I don't spend it.
16:57 oleonard     If we got that "debar explanation" feature in some form you could have the job check to see whether there was a reason entered
16:57 wizzyrea     :P
16:57 wizzyrea     certain types of fees should be marked as "trivial" and others "not trivial"
16:57 * wizzyrea   waves
16:57 oleonard     rhcl: I have the same reservations, as indicated in that bug report
16:56 bg           hi wizzyrea
16:56 wizzyrea     (sorry bg :P)
16:56 rhcl         these people might need to see a staff member to update records or The Director to offer penance
16:56 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2720 enhancement, P3, ---, gmcharlt, NEW , Fines that debar automatically, should undebar automatically when paid.
16:56 wizzyrea     bug 2720
16:56 wizzyrea     bg 2720
16:56 oleonard     The first example is valid rhcl, the second could be handled with gonenoaddress, no?
16:56 wizzyrea     there's a bug open for it
16:56 wizzyrea     oleonard:
16:56 wizzyrea     and actually, we were looking for cosponsors for that
16:55 rhcl         So, <undebar/debar> automatically would do what exactly? For example, we might bar someone who has no fines/overdues, but who has vandalized equipment, or who has a known bad address on record.
16:52 oleonard     I wonder if we have any $ left in the development budget...
16:50 wizzyrea     oleonard: nekls has been wanting that forever
16:50 oleonard     Seems like the kind of thing a developer would brag was 'trivial' to write ;)
16:49 oleonard     Me neither, but it doesn't hurt to ask :)
16:49 jcamins      oleonard: I thought there wasn't one.
16:30 reiveune     bye
16:28 oleonard     Does anyone here know of a script which automatically undebars patrons with no overdues?
16:27 oleonard     libsysguy1: Your email about notifications mentions something you're calling the collection code--we already have collection codes.
16:23 * hdl        don't know
16:23 hdl          debarredcomment
16:22 oleonard     Has it been pushed hdl?
16:22 hdl          oleonard: it is already done...
16:21 jwagner      I dunno.
16:21 jwagner      I've asked my IT people to make sure the module is installed.  But if it's been required for that long, it should have been installed long ago.  I've had this server for a couple of years now.
16:20 sekjal       but it's been a dependency for quite a while, so I don't have any servers where it's not already installed to test this theory
16:19 sekjal       there has been some CAS work recently... would need to look at the 'use' statements to see if it's being called in other, non-CAS parts of the code now
16:19 jwagner      Double hmmmmmm.
16:19 oleonard     jwagner: Yes
16:19 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6775 enhancement, P5, ---, savitra.sirohi, NEW , Allow reason to be specified when debarring
16:19 oleonard     hdl, isn't Bug 6775 something Biblibre was working on?
16:19 jwagner      oleonard, you updated this morning?
16:17 jwagner      Hmmmm.
16:17 oleonard     jwagner: I'm always working off of master and I never got an error about it
16:17 jwagner      Can someone else update a test current head server & see if it works for you?
16:16 jwagner      sounds likely -- there's a call in there to use Authen::CAS::Client;
16:13 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5630 enhancement, PATCH-Sent, ---, paul.poulain, ASSIGNED , CAS improvements
16:13 oleonard     Bug 5630 maybe?
16:12 jcamins      I'm on 3.5.0.4
16:12 * jcamins    hasn't updated to Master in a while.
16:11 jwagner      What has been pushed in the last couple of weeks, anyone know?  Anything related to CAS?
16:10 jcamins      Hm. I've never gotten that error message. It just shows red in the About page.
16:10 jwagner      That's usually an indication of a new module.
16:10 jwagner      When I try to go to the staff URL: Can't locate Authen/CAS/Client.pm in @INC
16:09 jcamins      jwagner: how's it complaining?
16:09 jwagner      Wonder what happened....
16:09 jwagner      Really?  I've been running this system for a couple of years, and as recently as a couple of weeks ago (last time I did a git pull) it never complained.
16:09 jcamins      jwagner: it's been listed since prior to 3.2.
16:08 jwagner      is Authen/CAS/Client.pm a new Perl dependency?  My latest git pull on current head is complaining about it.
15:55 * larryb     is away:
15:50 jcamins      (i.e. not the 3.4.x branch)
15:50 libsysguy1   gotcha
15:50 jcamins      libsysguy1: just use Master for your work.
15:50 libsysguy1   right
15:50 oleonard     Whatever you write won't make it into an official release until 3.6 or later either way
15:50 libsysguy1   haha is there already a branch for 3.6?
15:49 oleonard     Git makes it possible to start your work now
15:49 oleonard     libsysguy1: Don't wait on anything!
15:49 libsysguy1   If I was going to work on notices would it be better to wait on 3.6?
15:49 oleonard     Hooray, two patches pushed.
15:47 Agent_Dani   chris_n: Ah...you're a good bit south of me, then.
15:40 libsysguy1   *crack knuckles* im ready to start working on overdues/notices
15:40 jcamins      Good morning, libsysguy1.
15:38 libsysguy1   morning #Koha
15:36 chris_n      we also are a host county for one of the coastal counties
15:36 oleonard     Are your hatches battened?
15:35 chris_n      rhcl: Irene is projected to make landfall in NC near Jacksonville. I'm about 80-90 miles from there.
15:34 rhcl         chris_n: are you in the path?
15:30 * Agent_Dani will likely be just out of range.
15:29 * chris_n    looks down the barrel of a loaded hurricane :P
15:14 jcamins      Nah, it's an old RLIN record that wasn't loaded into their own catalog.
15:12 rhcl         maybe there's just an end-of-month update waiting to reflect new holdings recently added to their db?
15:12 jcamins      It looks like when they had OCLC do a recon project, they failed to load some of the records.
15:12 rhcl         something more than just a periodic update of their holdings?
15:11 jcamins      Yale does not receive accolades for their thoroughness wrt making sure their holdings in their catalog match their holdings in OCLC.
15:11 huginn       rhcl: slef was last seen in #koha 21 hours, 53 minutes, and 19 seconds ago: <slef> yes, that needs quite a few
15:11 rhcl         @seen slef
15:09 rhcl         No takers, huh? OK, time's up.
15:08 rhcl         So, anybody wanna talk about children's computers?
15:06 jcamins      :)
15:05 rhcl         And of course, I'll want to get a sample printout from their printers...
15:05 rhcl         I know. Independent research. We need some more receipt printers, and I need to go see what Arby's uses.
15:04 rhcl         I'll just call it food and eat it! Course, I'll have to sneak away so nobody knows I'm gone...
15:04 jcamins      rhcl: it's 4:03pm in London- it's a late lunch!
15:02 jwagner      rhcl, call it brunch!
15:02 rhcl         wonders if 10:00am is too early for lunch...
14:48 jcamins      Oops.
14:48 jcamins      Was I "jcamins_1way" overnight?
14:47 jcamins      Good morning, #koha.
13:22 huginn       New commit(s) needsignoff: [Bug 6755] Problems with switching languages <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6755>
12:39 oleonard     Oh well, just killing time before a meeting shortly.
12:39 oleonard     Yeah, that limits my ability to get stuff done.
12:37 magnus_lunch sounds like fun...
12:26 oleonard     ...and possibly whatever port git uses as well?
12:26 oleonard     Once again in a branch where the network admin has blocked IRC ports
12:26 * oleonard   tries again
12:00 raj          thanks magnuse the dirty fix worked for me .. thanks a lot
11:43 Agent_Dani   o/
11:42 huginn       New commit(s) needsignoff: [Bug 6786] False detection of index names in Search; make index names case insensitive <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6786>
11:20 magnuse      \o
11:19 druthb       o/
11:03 raj          ooh it says so :(
11:00 magnuse      hm, not if the error says "MarkIssueReturned" is not exported by the C4::Circulation module
10:59 raj          even to /usr/share/koha/lib/C4/Reserves.pm , am i right?
10:58 magnuse      a quick and dirty fix might be something like adding "MarkIssueReturned" to the list of exported subroutines in C4/Circulation.pm
10:58 raj          i will try to fix it or upgrade to the latest stable one :)
10:57 raj          sure magnuse
10:56 magnuse      that will give you a ton of bugfixes and new features as well
10:56 magnuse      or preferably 3.4.4 which is the most recent stable
10:56 magnuse      if i were you i would at least upgrade to the most recent version of 3.2 - i believe that is 3.2.10
10:55 magnuse      the patch is not attached to the bug...
10:55 raj          looking magnuse
10:54 huginn       04Bug 2006: major, PATCH-Sent, ---, gmcharlt, RESOLVED FIXED, Fines Payment Broken
10:54 magnuse      looks like this issue might have been solved 3 years ago: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2006
10:52 raj          any suggestion magnuse
10:51 raj          BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 25.
10:51 raj          Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 25.
10:51 raj          BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Reserves.pm line 31.
10:51 raj          Compilation failed in require at /usr/share/koha/lib/C4/Reserves.pm line 31.
10:51 raj          BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Accounts.pm line 27.
10:51 raj          Can't continue after import errors at /usr/share/koha/lib/C4/Accounts.pm line 27
10:51 raj          "MarkIssueReturned" is not exported by the C4::Circulation module
10:50 raj          this is the complete error log
10:44 raj          if upgarding is the only solution means we can do. but i prefer to solve this with out upgrading.
10:44 raj          tats ok but we are trying to migrage from 32 bit os to 64 bit and after the fresh installation of the 64 bit koha we have restored the old database. everything works fine now other than the issue while creating the label..
10:42 magnuse      any plans on upgrading?
10:42 magnuse      hm, that's quite old, 3.4 is the current stable
10:42 raj          using 64 bit cent os
10:41 raj          3.02.00.004
10:39 magnuse      what version are you using?
10:39 magnuse      hm, that's a strange error
10:38 raj          this what the error i got
10:35 raj          "MarkIssueReturned" is not exported by the C4::Circulation module
10:20 raj          Software error:
10:20 raj          when i try to create a label it generates the following error..
10:19 raj          i will provide the information now
10:19 raj          thanks magnuse
10:17 magnuse      we won't know if we can help until you have described your problem, raj
10:16 raj          i am getting an issue in koha if anybody can help me please reply..
10:14 * Oak        waves
10:09 raj          rangi you there?
10:08 raj          anybody there?
10:08 raj          hi
07:58 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6772 enhancement, PATCH-Sent, ---, robin, ASSIGNED , Implementation of a recommendations engine
07:58 magnuse      woohoo for bug 6772!
07:45 magnuse      kia ora #koha
07:36 sophie_m     hello #koha
07:32 hdl          hi all
07:15 cait         morning
07:11 francharb    hello
06:57 huginn       New commit(s) needsignoff: [Bug 6772] Implementation of a recommendations engine <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6772>
06:39 wahanui      hola, reiveune
06:39 reiveune     hello
06:37 raj          ??
06:16 raj          any suggestions?
06:16 raj          "MarkIssueReturned" is not exported by the C4::Circulation modu
06:15 raj          when we try to create barcode labels i get the following error.
06:15 raj          hi
04:22 Brooke       bid!
04:11 bg           yup
04:11 Amit_Gupta   bg: Brendan
04:11 Amit_Gupta   heya Brooke
04:11 bg           hi amit
04:10 Brooke       hi Amit
04:10 Amit_Gupta   Brendan there ?
04:10 Amit_Gupta   heya chris
04:08 Oak          hey Brooke :^]
04:08 * Oak        waves
04:07 Brooke       hey oak :D
03:48 libsysguy1   I was afraid of that lol
03:48 rangi        its mostly in a module
03:45 libsysguy1   yeah that is what I thought.  I know that notifications are in at least 3 cron scripts but i haven't really looked anywhere else
03:45 rangi        its a fairly big job
03:44 libsysguy1   on a scale of 1-10 how deep in it am I?
03:44 Brooke       you might also want to put an rfc on the wiki if one isn't there
03:44 libsysguy1   ok will do
03:44 rangi        id email the main koha list, see if other libraries are interested
03:43 libsysguy1   I wasn't really sure where to start with it
03:43 libsysguy1   the bugs list or the rfc wiki?
03:43 rangi        probably better hitting the list with that
03:42 libsysguy1   is there anybody out there interested in teaming up on it?
03:42 libsysguy1   I know that Notifications really needs to be rewritten
03:42 libsysguy1   So I have a random question for anybody that feels up to answering it
03:41 Brooke       0/
03:22 bg           noice
03:22 rangi        creates index, and fixes the perl
03:22 bg           cool
03:22 rangi        k updated patch
03:20 bg           no stopwatch here
03:20 bg           that time about 8 secs
03:19 rangi        will attach updated patch
03:19 rangi        yay!
03:19 bg           maybe less
03:19 bg           yup about 15 secs
03:17 rangi        then try the webpage again
03:17 rangi        my $getborrower = GetMember(borrowernumber => $num->{'borrowernumber'});
03:17 rangi        and replace it with
03:17 rangi        comment that out
03:17 rangi        my $getborrower  = GetMemberDetails( $num->{'borrowernumber'} );
03:16 rangi        there is a line
03:16 rangi        in circ/waitingreserves.pl
03:16 bg           yup shoot it here
03:16 rangi        do you have a sec to test something for me (it works on my 400 items) bg?
03:16 rangi        got a fix
03:16 rangi        yay
03:14 rangi        when all we need is name, phone and email address
03:14 rangi        we are fetching a craptonne of info about the borrower
03:14 rangi        right i see what we are doing
03:12 rangi        yeah
03:12 Brooke       http://www.liveplasma.com/
03:11 eythian      rangi: eventually we should hook this recommendations stuff to work with the star rating stuff.
03:11 rangi        yeah its the looping over each reserve that is the slow bit
03:11 rangi        ah ha
03:10 bg           :)
03:10 Brooke       Move to plaid!
03:09 rangi        ok, well that index will speed it up, but it needs more speed, working on that now :)
03:09 rangi        right so its a function of the number of results returned it seems
03:09 bg           yup took about 45 seconds to load
03:09 rangi        but the only thing different is the query it runs
03:08 Brooke       0/
03:07 rangi        seems that a branch makes it faster, without a branch slower
03:07 bg           let me try it again
03:07 bg           I was in as NO_Library_set
03:07 rangi        yeah
03:07 bg           I selected a branch that time
03:07 rangi        but it took a while still eh?
03:07 bg           I've got 1566 holds over
03:07 bg           ok that time it went through
03:05 rangi        hmm ok ill keep hunting
03:05 bg           still spinning
03:05 rangi        hmm, but it still spinning?
03:05 bg           3 rows all with a time of 0
03:05 bg           no
03:05 rangi        is there a query that has been running for a while there?
03:04 bg           what do you wanna know
03:03 rangi        show full processlist;
03:03 rangi        can you run
03:03 rangi        in mysql
03:03 rangi        right so thats only fixed a bit of it, there must be something else without an index
03:02 bg           well I added back the index and it's sitting there spinning away now
03:02 rangi        hmm if its still spinning it may be that that query is only part of the issue
03:01 bg           let me add the index and see what happens
03:01 bg           still spinning
02:59 bg           ok spinning away
02:59 bg           ah whoops
02:58 rangi        holds awaiting
02:58 bg           wait is this holds queue or holds awaiting
02:58 rangi        but the good news is, it doesnt make it any slower ;)
02:58 bg           well trying it in the staff-side (but my results are only 320)
02:57 rangi        i dunno if you can tell that to flush
02:56 rangi        so hard to test
02:56 rangi        yeah result will be in mysqls query cache now
02:56 bg           yup all NULL now
02:55 bg           ok same result 0.00 - let me try explain
02:55 bg           yup does the trick
02:54 rangi        try that
02:54 rangi        alter table reserves drop index  priorityfoundidx;
02:54 eythian      no, I think just drop
02:54 eythian      or delete
02:54 rangi        ahhh
02:54 eythian      just 'drop' maybe
02:54 bg           nope it's not dropping for me
02:54 * rangi      googles
02:54 rangi        hmm i cant remember the command
02:53 bg           no cigar
02:53 bg           DROP INDEX priorityfoundidx;
02:52 rangi        see if its much slower
02:52 rangi        then try the explain, and just the query
02:52 rangi        drop index priorityfoundidx;
02:52 bg           I can run that fast
02:52 rangi        you should be able to drop it
02:52 bg           heh
02:52 rangi        altho 0.00 is pretty fast :)
02:52 bg           ahhh...
02:52 rangi        :)
02:52 rangi        now we cant tell if it sped it up or not
02:51 rangi        dang
02:51 rangi        ahh
02:51 bg           did that first
02:51 bg           yup
02:51 rangi        so you have already created the index
02:51 rangi        ohh
02:51 bg           key = priorityfoundidx
02:51 rangi        is it using an index now?
02:51 bg           I ran the first
02:50 bg           cool - what do you want to know
02:50 wahanui      rumour has it the first is the command i ran
02:50 rangi        the first
02:50 bg           then the query
02:50 bg           or explain;
02:50 bg           WHERE   priority='0'  AND found='W';
02:50 bg           explain SELECT borrowernumber,reservedate,itemnumber,waitingdate FROM reserves
02:49 rangi        explain then the query
02:49 rangi        can you do this for me
02:49 rangi        hmm
02:49 bg           (0.00 sec)
02:49 bg           1566 in query - seemed pretty fast though
02:48 bg           6768 holds
02:47 rangi        :)
02:47 rangi        their even
02:47 rangi        (there test db maybe)
02:47 rangi        since they reported it
02:47 rangi        how many in nekls?
02:46 rangi        yeah
02:46 bg           for the query
02:46 bg           not big enough though only 139 rows
02:46 bg           0.00 sec
02:46 rangi        if it takes a while, then yep
02:45 rangi        and it will tell you how long it takes
02:45 rangi        just in mysql
02:45 rangi        rule the query in there now
02:45 bg           is that big enough?
02:44 bg           1500 holds in there
02:44 sekjal       night, all
02:44 sekjal       alright, the next thing to make the QA Manager happy is some sleep
02:43 bg           not worried about the patch :)
02:43 bg           yeah that's what I was thinking
02:43 sekjal       that would make a QA Manager VERY happy
02:43 sekjal       record the time it takes before application, the time it takes to actually do the indexing, and the time it takes after
02:43 rangi        yup
02:42 sekjal       wouldn't even have to apply the patch; could just make the change in the DB directly
02:41 bg           the database is getting refreshed this weekend
02:40 bg           maybe vokal test?
02:40 bg           thinking if I have a sample somewhere…
02:40 bg           ah that could be pretty sweet
02:25 rangi        yep
02:23 sekjal       would I could do more, but my eyes are crossing.  time for some rest
02:22 sekjal       but that's a one-time thing
02:22 sekjal       except possible the time to do the database update
02:22 sekjal       I can't see how it could slow anything down
02:21 rangi        it sped it up on mine, but i want to know if that was the only cause of slowness (it was doing an exhaustive search)
02:21 rangi        yeah i need liz or someone with a big db of holds
02:20 sekjal       (easy patch to read)
02:20 sekjal       oooh, that's a free Pass QA if anyone can test and verify that it does indeed reduce slowness on a large hold volume
02:20 Brooke       :) howdy
02:20 rangi        hi brooke
02:19 Brooke       kia ora
02:18 huginn       New commit(s) needsignoff: [Bug 5866] At larger hold volume, waitingreserves.pl for all libraries times out, can cause generalized slowness <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5866>
02:07 mtj          http://xkcd.com/612/
01:24 mtj          ... its great seeing koha installation knowledge spreading around the world
01:20 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5498 minor, PATCH-Sent, ---, oleonard, ASSIGNED , Standardize markup and style of pagination menus
01:20 jenkins_koha oleonard: Follow-up fix for Bug 5498, Standardize markup and style of pagination menus
01:20 jenkins_koha Project Koha_master build #393: STILL UNSTABLE in 44 mn: http://jenkins.koha-community.org/job/Koha_master/393/
01:19 mtj          s/heath/health/
01:19 mtj          and heathnet, nepal++ :)
01:18 mtj          rangi:  wow, great news re: maldives libraries
01:14 * Agent_Dani just got home from class.
01:14 Agent_Dani   \o
01:13 druthb       o/
00:50 rangi        good to see its 3.4.4 :)
00:50 rangi        https://infomalias.wordpress.com/2011/08/23/mla-koha-pilot-project-2011-gaining-momentum/
00:49 rangi        and have fun
00:49 rangi        sleep well
00:49 cait         bye all
00:48 cait         time to sleep - long day tomorrow :)
00:46 rangi        yes
00:46 rangi        wow
00:46 cait         3 euro/hour vs. 2.50 for 24 hours
00:46 rangi        ah ok
00:46 cait         way cheaper
00:46 cait         or yes it has, but using umts
00:46 cait         nope
00:44 rangi        and the hotel has wifi?
00:44 rangi        glad you made to the hotel
00:44 sekjal       hi cait
00:43 cait         hi sekjal
00:43 cait         we had to take a taxi from the station, was too late
00:43 cait         finaly
00:43 cait         hotel
00:41 rangi        where are you now cait ?
00:36 jenkins_koha Starting build 393 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #385 6 j 14 h ago)
00:35 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6602 normal, PATCH-Sent, ---, oleonard, ASSIGNED , Reports dictionary doesn't properly recognize text columns
00:35 jenkins_koha oleonard: Fix for Bug 6602 - Reports dictionary doesn't properly recognize text columns
00:35 jenkins_koha Project Koha_master build #392: STILL UNSTABLE in 44 mn: http://jenkins.koha-community.org/job/Koha_master/392/
00:17 cait         hi again #koha
00:14 huginn       New commit(s) kohagit: Merge remote-tracking branch 'kc/new/bug_5498' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=97005758bb647c49462c9f203f48e94fab0bb308> / Follow-up fix for Bug 5498, Standardize markup and style of pagination menus <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7f884128f67125c542daae77b32108e6cf14a5a5>
00:02 huginn       New commit(s) needsignoff: [Bug 6727] can't import frameworks <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6727>
00:02 huginn       New commit(s) kohagit: Fix for Bug 6602 - Reports dictionary doesn't properly recognize text columns <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=df2a3a9a3cf138bc11e2a39b4aad591d17359830>