Time  Nick          Message
00:08 jenkins_koha  Yippee, build fixed!
00:08 wahanui       o/ '`'`'`'`'`'`'`'`'`
00:08 jenkins_koha  Project Koha_master build #1673: FIXED in 2 hr 22 min: http://jenkins.koha-community.org/job/Koha_master/1673/
00:08 jenkins_koha  Owen Leonard: Bug 11671 - Restructure patron lists add form for improved usability
00:08 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11671 enhancement, P5 - low, ---, oleonard, Pushed to Master , Restructure patron lists add form for improved usability
01:02 wizzyrea      syspref changes are tracked in the actionlogs
01:03 wizzyrea      eythian^
01:04 wizzyrea      oh nm that wasn't your question
01:23 jmsasse       Hello community.
01:24 wizzyrea      sup sasse
01:25 jmsasse       A great thawing. Not fast enough but it's a start.
01:27 jmsasse       If someone adds a block to a bz item, what does that mean.
01:30 jmsasse       Also, has gmcharlt announced feature and string freeze dates yet?
01:30 jmsasse       Foe 3.16, that is.
01:31 rangi         if its blocks, that mean the patches on the other bug depend on this one
01:31 rangi         if its depends, it depends on the patches from another bug
01:36 jmsasse       OK, thanks rangi.
01:47 jmsasse       rangi, got a minute to discuss permissions?
01:50 bag           hola jmsasse and mr rangi
01:50 bag           permissions jmsasse ?
01:50 eythian       hey bag
01:51 bag           you eythian - great day to you dood
01:51 bag           yo* even :P
01:51 jmsasse       hello bag
01:52 jmsasse       bag, 3.14 seems to have introduced some redundancy in staff permissions.
01:54 jmsasse       set permissions (permissions) vs. (staffaccess)
01:54 jmsasse       these appear to do the same thing.
01:58 bag           I think they do - do seperate things - like one allows you to even log into the staff side and the other allows you to be able to set staff permissions
02:02 wizzyrea      ^
02:03 wizzyrea      anybody heard of extreme slowness related to the new restrictions engine?
02:03 bag           yes wizzyrea
02:03 wahanui       wizzyrea is, like, silly
02:03 wizzyrea      is there a bug?
02:03 wizzyrea      also hi bag ;)
02:03 bag           we saw it pop up last week
02:03 bag           and we're still trying to test it
02:03 bag           larryb spottted it
02:03 wizzyrea      3.14.04?
02:03 bag           I don't know it he created the ticket yet
02:04 bag           yes ma'am 3.14.04
02:04 wizzyrea      bother.
02:04 wizzyrea      thank you :)
02:04 bag           like 30+ seconds for those with restrictions
02:04 dcook         "new restrictions engine"?
02:04 wizzyrea      yeah it's quite extreme
02:04 wizzyrea      must be something new in 04 though
02:04 wizzyrea      I don't think it was happening in 03
02:04 wizzyrea      so that's useful
02:05 bag           wizzyrea: it you create the bug - I'll alert larryb to it and maybe he can add some of his findings
02:07 jmsasse       I'm looking at demos of 3.14.01, 3.15, and my 3.12.10 and seeing very different things in set permissions.
02:08 jmsasse       yeah, what is the "new restrictions engine"?
02:10 wizzyrea      the way restrictions on borrowers are handled is different now, you can now have multiple restrictions, with user defined reasons.
02:20 dcook         "is jerk"
02:20 dcook         I like it :D
02:21 dcook         Too bad about the slow down :(
02:26 rangi         how do we have a new feature in a maintenance release?
02:29 rangi         ah no, that came in in 3.14.0 the multiple debarred thing?
02:34 jmsasse       Is marijuana legal in NZ?
02:34 rangi         no
02:34 wizzyrea      yep, regarding the multiple debarred
02:34 wizzyrea      was in 3.14.0 but seems like it's just gotten slow in .04
02:35 wizzyrea      the only thing that seems remotely relevant are new indexes on the borrowers table
02:35 wizzyrea      but...
02:35 bag           we've seen the same thing as wizzyrea
02:35 jmsasse       Those boys in Colorado are serving up some serious buds.
02:36 jmsasse       I saw a documentary.
02:36 jmsasse       Just sayin'
02:37 rangi         run the query with explain, it will tell you
02:38 wizzyrea      ^ was my next step
02:38 rangi         normally new indexes dont slow down selects tho, just updates/inserts
02:39 jmsasse       Um, I'm hoping next months bywater update is not to 3.14.04
02:41 jmsasse       :-)
02:45 rangi         wizzyrea: the indexes were added in 3.14.3 ?
02:50 bag           jmsasse: it will be 3.14.5
02:50 bag           hopefully
02:52 rangi         I suspect it has the same issue, as it was released yesterday
02:53 bag           yup
02:53 bag           the good thing is that not many are "using"the double restriction yet
02:54 bag           so we've only got a very small sample - very small of the problem
02:54 bag           larry's got a bunch of notes on it
02:54 bag           I'm seeing if I can find them now
02:54 bag           but he lost internet for most of today...  so he was out of commision
02:55 wizzyrea      oh stink for him.
02:56 wizzyrea      well we have at least 2 instances of it now
02:58 jmsasse       (putting on my serious hat) staff patron permissions are a big deal
02:59 jmsasse       IndependentBranches syspref is too restrictive
02:59 dcook         Couldn't agree more, jmsasse
03:00 wizzyrea      @quote get 123
03:00 wahanui       http://xkcd.com/1172/
03:00 huginn        wizzyrea: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011)
03:01 bag           is it just weird that quote is the most useful one and it's the easier to remember.... 123...
03:01 bag           like rangi were you saving that - for the 123rd quote?
03:02 bag           anyways worked out well :)
03:02 wizzyrea      just lucky :)
03:02 wizzyrea      @quote get 245
03:02 huginn        wizzyrea: Quote #245: "<jcamins> Noooooooooooo!!!! wahanui! Cut down in the prime of life!" (added by gmcharlt at 11:07 PM, May 02, 2013)
03:02 wizzyrea      @quote get 234
03:02 huginn        wizzyrea: Quote #234: "<oleonard> I was just reading the logs because I didn't know where else to go to find out what to do with an extra half an avacado" (added by slef at 12:59 AM, March 01, 2013)
03:02 bag           HA
03:03 bag           @quote get max-num
03:03 huginn        bag: Error: 'max-num' is not a valid id.
03:03 eythian       @quote help
03:03 huginn        eythian: I'll give you the answer as soon as RDA is ready
03:03 eythian       @quote
03:03 huginn        eythian: I'll give you the answer as soon as RDA is ready
03:03 eythian       @quote get
03:03 huginn        eythian: (quote get [<channel>] <id>) -- Gets the quote with id <id> from the quote database for <channel>. <channel> is only necessary if the message isn't sent in the channel itself.
03:03 dcook         lol, love #234
03:03 * dcook       wishes that his timezone was closer to oleonard's :(
03:04 dcook         Or vice versa. Get to the west coast Leonards!
03:04 * dcook       wishes that you could symlink geographic locations...
03:04 wizzyrea      @quote help
03:04 huginn        wizzyrea: I'll give you the answer just as soon as RDA is ready
03:04 wizzyrea      hrmph.
03:05 bag           @help quote
03:05 huginn        bag: Error: There is no command "quote".
03:06 bag           @quote get #bywater 12
03:06 huginn        bag: Error: There is no Quote with id #12 in my database for #bywater.
03:06 bag           :P
03:06 jmsasse       I only live by Arnold quotes
03:09 dcook         Hey, Benedict, or Schwarzenegger, jmsasse?
03:12 jmsasse       The governor of California, of course
03:14 jmsasse       "Conan, what is best in life?"
03:15 jmsasse       "Crush your enemies, see them driven before you, and to hear the lamentations of their women"
03:22 jmsasse       Words to live by, people, words to live by.
05:27 dcook         +ok($keycount2==0,'The YOLO framework does not exist.');
05:27 dcook         mtompset (wherever you are): That is rather amusing
06:04 cait          bgkriegel++
06:04 eythian       hi cait
06:04 cait          hi eythian :)
06:04 cait          still around?
06:08 eythian       for now, just writing some emails before I go.
06:12 cait          ah
06:12 cait          so have anice evening :)
06:14 eythian       will do, ta :)
06:46 dcook         Hmm, I think I just noticed a flaw in advance_notices
06:46 dcook         Or the issues table
06:46 wahanui       somebody said the issues table was not used on displaying item.
06:46 dcook         or all the things
06:47 dcook         By default, advance_notices shows "issue_date" :S
06:47 dcook         You can change this to due_date, but if you're renewing an item...it won't show lastrenewdate, it will show due_date
06:49 dcook         Unless there is a bug and due_date should match lastrenewdate...
06:50 cait          ?
06:50 cait          lastreneweddate is the date of the renewal - do you mean that?
06:50 cait          different from due date
06:50 dcook         Wait, the numbers are merging together...lol
06:52 dcook         You can ignore everything I just said :)
06:52 dcook         Although advance_notice does default to issue_date when it should probably use due_date instead by default...
07:12 dcook         night all
07:12 wahanui       goodnight dcook. You'll be back.
07:12 dcook         Uncle David is going to go enjoy his evening thinking up presents to send his nephew in America. Not sure a boomerang is infant appropriate, but I'm sure I'll think of something.
07:13 cait          :)
07:13 cait          cangaroo?
07:16 * magnuse     waves
07:20 magnuse       bonjour sophie_m - you are early!
07:20 sophie_m      hello magnuse
07:21 sophie_m      I'm not really there, I don't work on thursdays, but I connect to read after
07:22 magnuse       ah, cool :-)
07:26 rangi         evening
07:27 magnuse       kia ora rangi
07:27 cait          hi rangi
07:33 * magnuse     wonders if the "use koha under plack for one day in production" experiment will blow up spectacularly or just silently succeed
07:35 rangi         did you fix zconn ?
07:35 rangi         searches will definitely randomly fail unless you have
07:36 rangi         and you wont notice
07:36 rangi         unless it fails for you
07:36 marcelr       hi #koha
07:36 rangi         because it doesnt log the failure
07:36 rangi         just says no results found
07:40 magnuse       ah no, i did not do that, yet
07:40 reiveune      hello
07:40 wahanui       hi, reiveune
07:41 rangi         eythian found a couple more bugs, but thats about the nastiest one
07:42 magnuse       known bugs > unknown bugs
07:57 alex_a        bonjour
08:04 magnuse       rangi: i forget - is it this patch? http://git.catalyst.net.nz/gw?p=koha.git;a=commitdiff;h=459c750e4b0aa0fe5dba601e423e78070383b97b;hp=2c9581f75fdb1f76e60c83f86e253cb4dfe04597
08:05 rangi         yep
08:06 rangi         thats a slapdash  fix
08:07 magnuse       ...and it's really just commenting stuff out?
08:07 rangi         yep
08:07 rangi         so that it makes a new connection for each search
08:07 magnuse       ah yes, you said it reconnect for each search
08:07 * magnuse     seems to remember now :-)
08:07 rangi         (which is what happends under cgi anyway)
08:08 magnuse       yeah
08:08 magnuse       and it fixes both intranet and opac, since it is in C4/Context.pm?
08:08 rangi         yep
08:11 fridolin      hie all
08:11 magnuse       bonjour fridolin
08:12 fridolin      hie magnuse
08:12 fridolin      nice weather here in Nîmes, blue sky
08:13 magnuse       @wunder nimes
08:13 huginn        magnuse: Error: No such location could be found.
08:13 magnuse       @wunder nimes, france
08:13 huginn        magnuse: Error: No such location could be found.
08:13 magnuse       @wunder boo
08:13 huginn        magnuse: The current temperature in Bodo, Norway is 5.0°C (8:50 AM CET on March 27, 2014). Conditions: Mostly Cloudy. Humidity: 87%. Dew Point: 3.0°C. Pressure: 30.42 in 1030 hPa (Steady).
08:18 huginn        GERMS!!!!
08:18 wahanui       i heard germs was http://i.imgur.com/5UfhT.jpg
08:20 magnuse       kia ora cait and paul_p
08:20 cait          hi magnuse and paul_p
08:20 magnuse       rangi: and if the zconn fails you will just get 0 hits? i think i saw that once yesterday
08:20 rangi         exactly
08:23 cait          bug 8908
08:23 wahanui       bug 8908 is where I reported it, but I don't see a patch.
08:23 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8908 normal, P5 - low, ---, gmcharlt, NEW , Starman/Plack hangs when faced with zombie Zebra
08:23 cait          is that the bug?
08:23 magnuse       hm, is that the same thing?
08:23 magnuse       i don't think so
08:25 cait          i don't knwo :)
08:25 cait          i just fell over it
08:25 magnuse       rangi?
08:25 wahanui       I LIKE ALMONDS! HAVE SOME NUTS!
08:25 magnuse       hehe
08:28 rangi         nope
08:28 rangi         different bug
08:29 cait          something for eythian maybe?
08:29 magnuse       ah
08:29 rangi         this doesnt leave the browser spinning
08:30 rangi         and it doesnt need a zombie process
08:34 magnuse       as far as i can see there is no bug for the zconn thing
08:34 * magnuse     will report one
08:38 magnuse       bug 12005
08:38 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12005 major, P5 - low, ---, gmcharlt, NEW , Zebra searches sometimes fail silently under Plack
08:51 ashimema      plack testing is really moving again now..
08:51 ashimema      that's great to see
08:51 ashimema      magnuse++
08:51 magnuse       Viktor reports an "kCFErrorDomainCFNetwork error 303" error when he tries to access koha running under plack with safari on a mac. anyone else seen that?
08:52 * magnuse     is trying to push plack support forwards
08:53 rangi         does he get that message in the brwser, cos that sounds like a client side error
08:54 rangi         and plack is behind a proper webserver like nginx or apache2 eh?
08:55 magnuse       yeah, in the browser
08:55 * cait        loves to see the cooperation on this and the zebra facets :)
08:55 cait          andn ow... i have a meeting
08:55 magnuse       the opac is baing proxied by apache
08:56 magnuse       staff is not behind a webserver for this test
08:56 rangi         yeah id never do that
08:56 rangi         just fyi
08:57 magnuse       yeah, this is sort of a quick and dirty test day, because they are desperate for more speed...
08:58 rangi         where is the error coming from staff or public interface?
08:59 magnuse       not sure, i've asked viktor to clarify
09:02 magnuse       the main library opens now...
09:06 rangi         good luck .. if you get more network type errors i would put the staff side behind a webserver
09:06 * rangi       is going to sleep
09:07 magnuse       i'll remember that advice - sleep well!
09:15 atheia        Morning koha!
09:26 magnuse       hiya atheia
09:54 magnuse       opl doing cool stuff: http://vimeo.com/68687814 powered by rdf
10:01 cait          hi ateh
10:01 cait          hi atheia even
10:01 atheia        :-)
10:01 atheia        good morning
10:03 gaetan_B      hello
10:03 gaetan_B      in marc21, the biblionumber is linked to 999$c, but according to the standard it should be in field 001
10:03 gaetan_B      is it a problem to change this setting ?
10:05 cait          yes
10:05 gaetan_B      hm
10:05 cait          well it might work, but it might blow up badly
10:05 gaetan_B      so a library that want sto have this consistent has to enter it manually in 001 i guess
10:05 cait          and you'd have to change the index as well
10:05 gaetan_B      changing the index would be ok
10:05 gaetan_B      but i am afraid of the blow up :D
10:05 cait          and for us it would not work - because we have a 001 from the union catalog
10:06 cait          that could be moved around... but not a quick and easy thing
10:06 cait          the bilbionumber is such a central thing... i would be worried about side effects
10:06 cait          but hard to tell
10:14 magnuse       gaetan_B: see also bug 9921
10:14 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9921 enhancement, P5 - low, ---, nunyo, In Discussion , Make it possible to force 001 = biblionumber
10:15 gaetan_B      thanks magnuse, such a long in discussion bug for this point strongly indicates i should leave it as it is !!
10:16 magnuse       maybe... :-)
10:25 cait          Joubu++
10:50 cait          wifi--
10:51 drojf         hi #koha
10:51 cait          hi drojf
10:51 cait          @karma wifi
10:51 huginn        cait: Karma for "wifi" has been increased 0 times and decreased 1 time for a total karma of -1.
10:51 drojf         hi cait
10:52 drojf         :D
10:52 drojf         had to reboot for other reasons ;)
10:52 cait          ah, it still won't hurt
10:52 drojf         nope. i am connected to that particular wifi right now, it will be of use later ;)
11:52 barton        good morning #koha!
11:54 cait          hi barton
11:54 barton        morning cait!
11:55 barton        morning meliss!
11:55 meliss        good morning barton
11:56 barton        morning natec!
11:56 NateC         mornign barton!
11:56 NateC         morning #koha!
11:56 * barton      thinks that we might as well do our morning introductions in #koha ;-)
11:57 NateC         i like it
11:57 cait          hi NateC :)
11:57 NateC         hey cait!
11:57 NateC         its like 30 degrees here I'm so ready for spring
11:58 barton        I hear you there, natec!
11:59 cait          @wunder Konstanz
11:59 huginn        cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 8.4°C (12:55 PM CET on March 27, 2014). Conditions: Clear. Humidity: 71%. Dew Point: 3.0°C. Windchill: 8.0°C. Pressure: 29.80 in 1009 hPa (Steady).
11:59 cait          not 30 celsius, right?
11:59 NateC         no 30 F
11:59 meliss        my thermometer says it's currently 17 F
11:59 barton        cait, *definitely* correct.
11:59 NateC         really? damn it must be that here then
11:59 meliss        if not colder natec
12:00 NateC         @weather 06896
12:00 huginn        NateC: The current temperature in Redding, Connecticut is -5.5°C (8:00 AM EDT on March 27, 2014). Conditions: Clear. Humidity: 64%. Dew Point: -11.0°C. Windchill: -6.0°C. Pressure: 30.39 in 1029 hPa (Rising).
12:01 NateC         far from optimal
12:02 barton        that's the one thing I never got the hang of in metric... I can handle metric lengths and volumes and such, but temp. is such an intuitive thing... I know what 70F feels like, but I don't have a feeling for anything other than 0C.
12:04 NateC         yeah when we were in NZ for a month i started to get the swing of it but now its lost
12:04 * cait        doesn't have any feelings for fahrenheit
12:04 NateC         i guess i need to go back!
12:04 cait          true :)
12:05 * barton      likes chris_n's quit message.
12:06 barton        temp conversion is hard to do in your head...
12:06 magnuse       @wunder boo
12:06 huginn        magnuse: The current temperature in Bodo Vi, Norway is 6.0°C (1:00 PM CET on March 27, 2014). Conditions: Partly Cloudy. Humidity: 75%. Dew Point: 3.0°C. Pressure: 30.45 in 1031 hPa (Rising).
12:07 barton        @wunder lou
12:07 huginn        barton: The current temperature in Louisville Bowman, Kentucky is 3.0°C (7:53 AM EDT on March 27, 2014). Conditions: Overcast. Humidity: 47%. Dew Point: -7.0°C. Windchill: 0.0°C. Pressure: 30.14 in 1020 hPa (Falling).
12:07 barton        hey, it worked!
12:08 * barton      wonders if anyone else saw the dbus errors...
12:12 barton        chris_n: I liked your 'Coyote finally caught me' message. :-)
12:15 oleonard      Hi #koha
12:15 barton        morning oleonard!
12:17 oleonard      Hi barton, those librarians keeping you busy?
12:17 barton        heh.
12:18 barton        so many librarians, so little time ;-)
12:25 nlegrand      Oi!
12:27 magnuse       oy!
12:30 barton        oy oy oy.
12:32 barton        morning nengard!
12:32 nlegrand      ^^
12:32 magnuse       howdy nengard
12:32 nengard       hola
12:32 nengard       :)
12:35 barton        morning jessem!
12:36 JesseM        Morning Barton
12:38 NateC         morning edveal!
12:38 edveal        morning all
12:41 cait          hi edveal and JesseM :)
12:42 edveal        hi cait
12:49 oleonard      gmcharlt are you still interested in investigating bug 11702 or is it a moot point now?
12:49 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11702 normal, P5 - low, ---, oleonard, RESOLVED DUPLICATE, Can't specify date for automatic resumption of suspended hold
12:56 JesseM        Hi cait
13:05 NateC         oleonard did you guys get hit with the snow?
13:06 oleonard      We got a little bit on Tuesday, just enough to make us all feel depressed but not enough to stick.
13:06 NateC         heh
13:06 oleonard      NateC: You?
13:06 wahanui       You are not the first to ask that question
13:06 NateC         nope just crazy wind
13:07 NateC         and really cold temps
13:07 NateC         i had a 30 ft tree fall across the driveway yesterday
13:07 oleonard      Yikes
13:07 NateC         yeah and I had nothing but a hand saw and a Jeep with a plow to clear it
13:07 NateC         it was interesting
13:08 oleonard      Yeah but I bet you felt really manly doing it.
13:08 NateC         that i did
13:08 NateC         i felt like i was on the show Ax Men
13:08 NateC         i even grew a beard for it :)
13:09 oleonard      :D
13:09 NateC         but i really need to buy a chainsaw now...
13:10 oleonard      My father-in-law went to buy a chainsaw and they told him he didn't want a chainsaw--they're too dangerous.
13:11 NateC         HA
13:11 NateC         ince
13:11 NateC         nice
13:12 oleonard      Of course he may just look like someone who's likely to accidentally kill himself with a chainsaw ;)
13:15 NateC         yeah id probably fall into that category too
13:17 oleonard      Not with that beard.
13:59 * magnuse     has an electrical chainsaw - does that count?
14:03 francharb     hi
14:04 rhcl          morning
14:04 rhcl          @wunder 64507
14:04 huginn        rhcl: The current temperature in St Joseph, Missouri is 12.1°C (9:00 AM CDT on March 27, 2014). Conditions: Overcast. Humidity: 67%. Dew Point: 6.0°C. Pressure: 29.44 in 997 hPa (Falling).
14:08 cait          marcelr++
14:08 cait          css--
14:09 oleonard      :P
14:20 magnuse       feels like i'm missing something obvious here... how do i a print a check in receipt?
14:23 ashimema      css-- ?
14:25 oleonard      I'm sure she didn't mean it ashimema.
14:25 * oleonard    comforts css
14:25 gerundio      hi, good afternoon
14:26 gerundio      anyone around to help me understand authorities in Koha and how to set them up?
14:26 magnuse       @karma css
14:26 huginn        magnuse: Karma for "css" has been increased 0 times and decreased 2 times for a total karma of -2.
14:27 * oleonard    hands cait all his old <font> and <table> tags, with a few spacer gifs thrown in.
14:27 magnuse       gerundio: not me, but have you looked at http://manual.koha-community.org/3.14/en/catauthorities.html ?
14:27 magnuse       ooh, space gifs!
14:28 gerundio      magnuse, I have
14:29 gerundio      I don't have any knowledge of authorities whatsoever, so I have some basic doubts
14:29 gerundio      the way I see it, the information for our authorities is already in our biblio records
14:30 gerundio      I was asked to populate author and subject authorities
14:30 gerundio      in there any way to import authorities from the biblio records?
14:30 ashimema      ooh.. oleanard.  Happen to know if there's a way to re-order datatables upon intial page load via IntranetUserJS syspref?
14:30 gerundio      maybe I'm completely off here, let me know if I am
14:30 ashimema      oleonard.. even
14:31 magnuse       gerundio: i think there is, but i have never used them
14:31 ashimema      a is nowhere near o on my keyboard.. how did that typo creep in
14:31 oleonard      ashimema: I have never tried that.
14:31 magnuse       tabcomplete++
14:32 oleonard      ashimema: The DataTables documentation does include examples of triggering a sort through alternate means, so that might be a place to start.
14:32 ashimema      I try to do as little template customisation as possible now.. those css and js sysprefs are awesome.
14:33 ashimema      cool.. I'll have a bash at it..
14:33 ashimema      maybe even add it to the wiki if I work it out.
14:34 oleonard      At least I thought I saw that in the docs, now I don't. Might take some Googling.
14:46 huginn        New commit(s) kohagit: Bug 11906: ensure that Koha::Database uses UTF8 mode when connecting to databases <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=05a6beba9f023f87d3355b6e72f35b220cd691b0> / Bug 11906: regression test for using DBIC to store & fetch UTF8 strings <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b21d16ca75bb40371773d3008fcb06c67200ab36>
14:49 cait          lol
14:49 cait          thx
14:49 cait          just trying to make a koha opac look like another website
14:49 cait          ... and it's trickx
15:00 jenkins_koha  Starting build #1674 for job Koha_master (previous build: FIXED)
15:03 cait          hah! IE and firefox look the same!
15:34 cait          yui--
15:35 oleonard      I'll join that pile-on
15:35 oleonard      yui--
15:39 cait          *sigh*
15:39 cait          my navigtion keeps showing up in weird places - opacnav
15:40 cait          and the facets...
15:40 wahanui       the facets are drawn from the records in the search results and are being worked on in bug 11232:  http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11232
15:40 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11232 new feature, P5 - low, ---, gmcharlt, NEW , Retrieve facets from Zebra
15:40 huginn        04Bug 11232: new feature, P5 - low, ---, gmcharlt, NEW , Retrieve facets from Zebra
15:41 jenkins_koha  Starting build #400 for job master_maria (previous build: SUCCESS)
15:53 drojf         i am getting an endless loop of updatedatabase.pl upgrading to 3.15.00.026, web installer asking to upgrade from 3.15.00.025 to 3.15.00.026 and so on. any ideas why that is happening? (i had the same with my own package of 3.12.12 while 3.12.11 works fine)
15:54 drojf         (must have been a different database number for 3.12, don't remember it though)
15:58 cait          an XX left in the pdatedatabase?
15:59 cait          or a 13 instead of a 15?
16:09 atheia        Off the top of your heads, does anyone know a nice reference set of unit tests that I could use to get an idea of good standards?
16:09 cait          hmm not sure it's ice, but reserves.t has grown a bit recently
16:09 atheia        Fab, I'll check that out for starters :)
16:09 cait          i think you want to make sure it uses transactions if it's a db_dependent one
16:10 cait          i think we haven't cleaned up all yet
16:15 cait          oleonard++
16:20 bag           morning all you alls
16:26 gaetan_B      bye !
16:34 bag           hey meliss
16:34 bag           you on the phone?
16:34 bag           can we skype
16:34 meliss        sure
16:36 bag           thanks meliss
16:36 bag           singing in meliss
16:37 meliss        singing?
16:37 bag           HA!!!
16:37 bag           :P
16:38 jenkins_koha  Project master_maria build #400: SUCCESS in 58 min: http://jenkins.koha-community.org/job/master_maria/400/
16:38 jenkins_koha  * Galen Charlton: Bug 11906: regression test for using DBIC to store & fetch UTF8 strings
16:38 jenkins_koha  * Galen Charlton: Bug 11906: ensure that Koha::Database uses UTF8 mode when connecting to databases
16:38 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11906 normal, P5 - low, ---, koha-bugs, Pushed to Master , Bad display of utf-8 chars in Patron lists (Datatable)
16:40 reiveune      bye
17:01 jenkins_koha  Project Koha_master build #1674: SUCCESS in 2 hr 3 min: http://jenkins.koha-community.org/job/Koha_master/1674/
17:01 jenkins_koha  * Galen Charlton: Bug 11906: regression test for using DBIC to store & fetch UTF8 strings
17:01 jenkins_koha  * Galen Charlton: Bug 11906: ensure that Koha::Database uses UTF8 mode when connecting to databases
17:01 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11906 normal, P5 - low, ---, koha-bugs, Pushed to Master , Bad display of utf-8 chars in Patron lists (Datatable)
17:06 pianohacker   hallo
17:11 rhcl          hola pianohacker
17:12 pianohacker   hi rhcl
17:27 atheia        'allo pianohacker
17:27 pianohacker   Hi alex! :)
17:30 cait          hi pianohacker :)
17:30 pianohacker   hi cait
17:33 mtompset      Greetings, #koha.
17:33 mtompset      oleonard++ # thanks for the catch on bug 7567.
17:33 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7567 enhancement, P3, ---, mtompset, Passed QA , News by Library: refactor, enhance, and fix
17:36 mtompset      Split?
17:36 * wahanui     will provide the bananas!
18:03 mtompset      dcook: You didn't publish your comments.
18:03 mtompset      (bug 11592)
18:03 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11592 normal, P5 - low, ---, mtompset, Passed QA , opac scripts do not respect MARC tag visibility
18:35 magnuse       how do i recognize a zombie zebra, if i meet one?
18:36 rangi         server up, not answering any connections
18:36 rangi         i havent bumped into one
18:36 magnuse       ref bug 8908
18:36 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8908 normal, P5 - low, ---, gmcharlt, NEW , Starman/Plack hangs when faced with zombie Zebra
18:36 rangi         how'd the experiment go?
18:36 jcamins       magnuse: ps says 'Z'
18:37 jcamins       Or maybe it's top that says 'Z'
18:37 jcamins       One of them.
18:37 wahanui       one of them is bound to have a good idea ;)
18:37 bag           @seen johnc
18:37 huginn        bag: I have not seen johnc.
18:37 pastebot      "magnuse" at 127.0.0.1 pasted "a heard of zebras after running with plack in production for a day" (9 lines) at http://paste.koha-community.org/190
18:38 bag           hmm I forgot his irc name
18:38 Dyrcona       jcamins: Think they'll both say Z depending on options.
18:38 magnuse       bag: HI
18:38 wahanui       bidet, magnuse
18:38 jcamins       Dyrcona: ah, that's why I was confused.
18:39 rangi         magnuse: and that's with the patch fixing zconn?
18:39 bag           magnuse: HI
18:39 magnuse       rangi: yes
18:39 bag           @seen crockett
18:39 huginn        bag: I have not seen crockett.
18:39 rangi         interesting, looks like something in the staff side then
18:39 bag           @seen jcrockett
18:39 huginn        bag: I have not seen jcrockett.
18:39 magnuse       <defunct> looks suspicious?
18:39 rangi         library.nzica.com has been running under plack for months now
18:40 rangi         (opac only)
18:40 jcamins       magnuse: yeah, the <defunct> one is a zombie.
18:40 rangi         we dont end up with a bunch of zebra
18:40 magnuse       i had nagios reporting more zebras than expected
18:41 magnuse       so something is happening there
18:41 bag           yeah we've had washoe running opac starman for awhile now too - the only problem we have is with the rss rewrite
18:41 bag           rangi: is that with apache2 or nginx?
18:41 rangi         apache2
18:41 jcamins       Apparently the reason I encountered that bug is that I had manually run Zebra rather than using the daemon script for some reason.
18:41 rangi         cos its doing the staff side normally too
18:42 rangi         magnuse: it will spawn more zebras as things connect, but they should go away
18:44 magnuse       i think they have been coming and going, but maybe lingering a bit before going away
18:44 rangi         that makes sense, timing out
18:45 rangi         this is why having yaz-proxy between koha and zebra would make this a lot nicer
18:45 rangi         eythian is going to be looking into this i think
18:45 magnuse       eythian++
18:45 bag           eythian++
18:47 cait          magnuse: what did they say about performance?
18:48 bag           sorry a little late to the convo - magnuse "i had nagios reporting more zebras than expected"  was that the -z zebras?
18:48 magnuse       cait: "check in was fast, check out quite fast"
18:49 magnuse       bag: probably
18:49 magnuse       well, a couple times i have seen this: 1049     14139  0.0  0.0      0     0 ?        Z    13:31   0:04 [zebrasrv] <defunct>
18:49 rangi         checkout does too much
18:49 rangi         thats a pet peeve of mine
18:49 rangi         all done to librarians who hate clicking
18:50 magnuse       (as part of output from "ps aux | grep zebrasrv")
18:50 rangi         down even
18:50 bag           checkout does do too much - but we can always add more right :P
18:50 mtompset      Should you even have a heard of zebras?
18:50 bag           heh just kidding
18:50 rangi         'you must put everything on this one screen cos i grew up with crappy ils software and you must replicate it'
18:50 bag           magnuse: we use flock on zebra -z
18:50 bag           maybe that would help?
18:50 magnuse       but there was more of these than i expected: 1049     17770  0.0  0.3 100336  6652 ?        S    19:33   0:00 zebrasrv -v none,fatal,warn -f /etc/koha/sites/hylte2/koha-conf.xml (which looks like a healthy zebra to me)
18:51 bag           or I'm missing the point (which happens)
18:51 magnuse       bag: a flock of zebras?
18:51 * magnuse     has no clue what flock is
18:51 rangi         magnuse: there will be more
18:51 mtompset      magnuse: It's daemon that spawns it, so I don't think the problem is zebra.
18:51 * bag         hears the lovely music of a flock of zebras
18:51 rangi         because the perl doesnt die
18:51 rangi         so have to wait for the timeouts
18:51 magnuse       perl will never die!
18:52 magnuse       yeah, that seems to make sense
18:52 rangi         instead of the connection being torn down when perl process ends
18:52 rangi         its mostly harmless, just messy
18:52 bag           magnuse: iirc http://perldoc.perl.org/functions/flock.html
18:52 mtompset      oh, because the perl is waiting on a Zconn that never returns?
18:53 cait          magnuse: now i am confused, which was faster?
18:53 rangi         checkin cait
18:53 magnuse       cait: plack was fast!
18:54 cait          that makes sense :)
18:54 * cait        goes to put groceries away
18:54 magnuse       they felt the speedup on checkin was better than on checkout
18:54 bag           magnuse: you should add this too Bug 11703
18:54 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11703 enhancement, P5 - low, ---, kyle, Signed Off , Convert checkouts table to ajax datatable
18:54 bag           and see if that speeds up even more
18:55 rangi         id test that pretty hard in staging first
18:55 rangi         you want to be sure you dont somehow miss a checkout
18:55 bag           I have no clue - haven't tested that with plack
18:56 rangi         but it should be a good speedup in cgi and plack
18:56 magnuse       bag: it probably will, but i don't have the time to do much experimenting right now
18:57 bag           time I wish I had it too :)
18:57 magnuse       :-)
18:57 bag           @tell magnuse HI
18:58 magnuse       @later tell bag: HI
18:58 huginn        magnuse: The operation succeeded.
18:59 bag           @notes
18:59 huginn        bag: I currently have notes waiting for #koha, bag:, bgkriegel, bgkriegel:, Brooke:, cait,, cait., cait:, ccurry, chris_c, chris_n,, chris_n:, christ, cindy, Culiforg:, dcook,, dpavlin:, drofj, drojf:, druthb_away, druthb_away:, eythian:, Genji:, gmcharlt:, hackfesters, hdl:, hdl_laptop:, http://www.ub.uni-dortmund.de/listen/inetbib/msg48204.html, jcamins:, juan-siera, kf,, khall, khall:, khall_away, km_kale, (1 more message)
19:00 bag           @notes bag:
19:00 huginn        bag: Sent 1 minute ago: <magnuse> HI
19:00 bag           @notes help
19:00 huginn        bag: Error: I have no notes for that nick.
19:03 magnuse       hiya francharb
19:08 francharb     o/ magnuse
19:09 cait          @notes cait,,
19:09 huginn        cait: Error: I have no notes for that nick.
19:09 cait          @notes cait,
19:09 huginn        cait: Sent 2 years, 13 weeks, 1 day, 2 hours, and 6 minutes ago: <Oak> sent you mail :) as usual, check your spam folder. and Sent 4 weeks, 1 day, 10 hours, and 57 minutes ago: <ashimema> any idea's why bug 8962 got left behind.. I'm looking to do similar, but wondered whether the history meant anything.
19:10 cait          @notes cait
19:10 huginn        cait: Error: I have no notes for that nick.
19:10 cait          @notes cait:
19:10 huginn        cait: Sent 1 year, 20 weeks, 0 days, 0 hours, and 50 minutes ago: <magnuse> the sushi wasn't any good anywat ;-), Sent 1 year, 19 weeks, 6 days, 10 hours, and 21 minutes ago: <magnuse> looks like my permissions for nb-NO 3.10 are still not quite right, and Sent 9 weeks, 1 day, 11 hours, and 48 minutes ago: <dcook> Yep
19:10 cait          @notes cait.
19:10 huginn        cait: Sent 1 week, 2 days, 5 hours, and 12 minutes ago: <mtompset> Thanks for the clarification.
19:22 mtompset      That was probably with respect to the one line of code that was wrong on that one patch. :)
19:22 mtompset      The one I haven't tested, because I have to do retro-testing to properly test it.
19:23 mtompset      And that takes extra time.
19:23 mtompset      which is why I suggested axing the fix to history.
19:25 rangi         ok, off to take the kids to school
20:03 talljoy       back
20:14 wizzyrea      more like "you must put everything on one scream because this daycare mom with 15 children can't be away from my desk fast enough"
20:14 wizzyrea      scream. that's a freudian slip.
20:17 jcamins       wizzyrea: huh? I think there must be some bizarre and interesting context for that statement.
20:17 wizzyrea      screen.
20:17 jcamins       Ohhh.
20:17 jcamins       Right.
20:18 * jcamins     is disappointed.
20:18 jcamins       It was so much better without context.
20:18 jcamins       Completely right either way, of course.
20:26 wizzyrea      heheh
20:39 cait          ok
20:39 cait          say i was doing this 2 day koha workshop for librarians
20:39 cait          ... what would be fun doing with them?
20:43 cait          nothing? :)
21:10 eythian       hi
21:10 wahanui       salut, eythian
21:10 eythian       @notes eythian:
21:10 huginn        eythian: Sent 2 years, 48 weeks, 2 days, 6 hours, and 39 minutes ago: <cait> forget everything before and answer that question: Is there a bug for the accounting rewrite to which I can link bugs as 2696 Fine payments should show whatwas paid for, Sent 1 year, 9 weeks, 1 day, 0 hours, and 48 minutes ago: <magnuse> kia ora! any news on the funding for the images from multiple sources thing? just curious... :-), (3 more messages)
21:10 eythian       @notes
21:10 huginn        eythian: I currently have notes waiting for #koha, bag:, bgkriegel, bgkriegel:, Brooke:, cait,, cait., cait:, ccurry, chris_c, chris_n,, chris_n:, christ, cindy, Culiforg:, dcook,, dpavlin:, drofj, drojf:, druthb_away, druthb_away:, eythian:, Genji:, gmcharlt:, hackfesters, hdl:, hdl_laptop:, http://www.ub.uni-dortmund.de/listen/inetbib/msg48204.html, jcamins:, juan-siera, kf,, khall, khall:, khall_away, (1 more message)
21:10 eythian       @notes help
21:10 huginn        eythian: Error: I have no notes for that nick.
21:11 eythian       I want to see my three other messages :/
21:11 cait          hm
21:11 cait          it didn't change after delivering the notices
21:11 bag           eythian: it's @more
21:12 bag           cait that's cause the note is really for user = eythian: not eythian
21:12 bag           @notes
21:12 huginn        bag: I currently have notes waiting for #koha, bag:, bgkriegel, bgkriegel:, Brooke:, cait,, cait., cait:, ccurry, chris_c, chris_n,, chris_n:, christ, cindy, Culiforg:, dcook,, dpavlin:, drofj, drojf:, druthb_away, druthb_away:, eythian:, Genji:, gmcharlt:, hackfesters, hdl:, hdl_laptop:, http://www.ub.uni-dortmund.de/listen/inetbib/msg48204.html, jcamins:, juan-siera, kf,, khall, khall:, khall_away, km_kale, (1 more message)
21:12 bag           @more
21:12 huginn        bag: kmkale:, kyleh, LadyNight32, lducos, magnus, magnus_waffles, manguse, member:libsysguy, mtj:, mtompset:, mtompsett,, mveron, NCAR, nenegard, nengard:, nicole, Oak, Oak:, oleonard:, owen:, paul_p,, paul_p:, rangi:, santy,, Schuster:, sekjal:, seneca:, sjeffrey, slef:, tchoen, tcohen:, thd-away, Viktor:, whoever, wizzrea, wizzyrea,, and wizzyrea:.
21:13 bag           @notes eythian
21:13 huginn        bag: Error: I have no notes for that nick.
21:13 nengard       eeek ... and i forget how to find those
21:13 bag           @notes eythian:
21:13 huginn        bag: Sent 2 years, 48 weeks, 2 days, 6 hours, and 42 minutes ago: <cait> forget everything before and answer that question: Is there a bug for the accounting rewrite to which I can link bugs as 2696 Fine payments should show whatwas paid for, Sent 1 year, 9 weeks, 1 day, 0 hours, and 51 minutes ago: <magnuse> kia ora! any news on the funding for the images from multiple sources thing? just curious... :-), Sent 1 (3 more messages)
21:13 nengard       @notes nengard:
21:13 huginn        nengard: Sent 4 years, 6 weeks, 0 days, 20 hours, and 42 minutes ago: <chris_n> I submitted a patch for the docbook documentation correcting some invalid markup
21:13 bag           @more
21:13 huginn        bag: year, 1 week, 0 days, 10 hours, and 27 minutes ago: <magnuse> do you happen to have any opinions on Bug 9749?, Sent 1 year, 0 weeks, 6 days, 4 hours, and 46 minutes ago: <magnuse> if you should happen to feel like fixing bug 9890 i'll sign off in ~15 hours :-), Sent 50 weeks, 1 day, 14 hours, and 35 minutes ago: <magnuse> i did not report a bug for the version in build-git-snapshot, i just added it as a (2 more messages)
21:13 nengard       2 YEARS???
21:13 bag           @more
21:13 huginn        bag: comment on some other bug, Sent 50 weeks, 1 day, 14 hours, and 28 minutes ago: <magnuse> my original comment was on http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9918, Sent 48 weeks, 5 days, 23 hours, and 45 minutes ago: <tcohen> take a look at bug 10084, and Sent 48 weeks, 0 days, 8 hours, and 23 minutes ago: <tcohen> we could do smth like for lang in $(koha-translate --list) ; do koha-translate (1 more message)
21:13 bag           @more
21:13 huginn        bag: --update $lang ; done during the packages update
21:14 eythian       handy
21:14 eythian       magnuse is the main offender :)
21:33 magnuse       huh?
21:34 eythian       at leaving messages for 'eythian:' rather than 'eythian' :)
21:35 magnuse       ah
21:35 magnuse       oops
21:36 eythian       http://www.biblibre.com/en/tags/did-you-know <-- hey, this is pretty good.
21:36 eythian       might have to point that out to some of our libraries.
21:38 bag           ah there he is JohnC
21:38 bag           what's up man
21:39 bag           hey JohnC do you have skype in your office
21:39 bag           heya nancyk
21:39 nancyk        Hi
21:39 * cait        waves
21:39 bag           hiya cait
21:40 cait          hi bag :)
21:50 bag           ah JohnC came and left
21:51 bag           ah is that john__ = john crockett
22:30 pianohacker   hi cait
22:38 wajasu        is there such a thing as a syspref that is "hidden" from the staff editor?  so one could write YAML config there with some custom UI.
22:38 eythian       I don't _think_ so.
22:39 pianohacker   wajasu: What do you mean by the second part?
22:39 wizzyrea      bag, perchance on your very slow borrowers with restrictions
22:40 wizzyrea      do they have expiration dates set?
22:41 wajasu        i was thinking that msaby's facet config UI for YAML could be put in that table.  the custom UI would be "secure" and not "free form YAML"
22:41 pianohacker   wajasu: If you don't have a systempreference in the YAML, it'll just show up in the local use tab
22:42 pianohacker   wajasu: The most robust option would be either putting it in a separate table with its own admin screen, or adding it as a syspref type to preferences.tt (if the config screen isn't too large)
22:43 pianohacker   wajasu: Having it in the systempreferences table prevents you from later specializing the facets by branch, unfortunately
22:43 bag           hey wizzyrea larryb was the main man
22:43 bag           he's popped into channel here - but I think he's on the phone at the same time
22:43 wajasu        brainstorming for bug 10891 and bug 11232 (see comment #31)
22:43 wizzyrea      ah right
22:43 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10891 enhancement, P3, ---, gmcharlt, NEW , Make facets customisable
22:43 dcook         wajasu: The issue with facet config (using Zebra facets) is that not all facets will be set up correctly without massive changes to the Zebra indexing config
22:43 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11232 new feature, P5 - low, ---, gmcharlt, NEW , Retrieve facets from Zebra
22:44 bag           so he maybe slow to answer your questions wizzyrea
22:44 wizzyrea      is he still about or gone for the day?
22:44 * dcook       hopes the building isn't burning down...
22:45 larryb        sorry, I'm off the phone now.
22:45 pianohacker   wajasu: Ah, thanks. What are your concerns with security, if I might ask?
22:46 wajasu        security - i was thinking of bgu 10891 comment 1
22:47 pianohacker   ahhh kk thanks
22:47 eythian       the syspref aspect of that isn't the key part
22:48 wizzyrea      hi larryb
22:48 wizzyrea      on your very slow borrowers with restrictions
22:48 larryb        hey wizzyrea
22:48 wahanui       wizzyrea is a Cylon, and they all have plans.
22:48 wizzyrea      do they happen to have debarred dates way in the future, like 9999?
22:48 larryb        I can't recall for sure, but that may have been the case
22:49 larryb        you aren't going to ask me to remember who that was, are you? I've slept since then
22:49 wizzyrea      You can't actually do that in the interface, and sane close dates don't make it slow
22:49 wizzyrea      nope
22:49 larryb        define "sane". within 10, 20, 50 years?
22:50 cait          larryb: if you leave it empty it#s best for indefinite
22:50 wizzyrea      sane as far as the interface will let you pick in the date picker, which this year is 2024
22:50 larryb        thank you wizzyrea and cait. I will test both of those options see if things improve
22:50 eythian       cait: still, that case should be handled in a way that doesn't make everything really slow.
22:50 wizzyrea      I think that the updatedatabase, when converting old restrictions
22:51 wizzyrea      set it at 9999 (I haven't confirmed)
22:51 cait          i think there is a bug
22:51 wizzyrea      and when it goes to do date math on that very distant date it takes for. ev. er.
22:51 cait          it was converted wrongly and should be empty
22:51 wizzyrea      there is definitely a bug.
22:51 cait          if i recall correctly
22:51 eythian       maybe it does something dumb like loop through every day until then
22:51 wizzyrea      it also should not do that
22:51 wizzyrea      ^^
22:51 eythian       cait: then there are two bugs
22:51 cait          let me find it
22:52 cait          bug 11846
22:52 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11846 major, P5 - low, ---, gmcharlt, Needs Signoff , Correct database update for debarments with 9999-12-31
22:52 wizzyrea      cool
22:52 cait          "Set as major because it creates an heavy load on pages displaying this infinite date (using the TT plugin KohaDates)."
22:52 cait          sounds like a candidate
22:53 wizzyrea      yea def
22:53 wizzyrea      we shoudl fix kohadates.
22:53 wizzyrea      as well.
22:53 wizzyrea      so it does not do that.
22:53 eythian       yeah
22:53 eythian       because it's probably still taking longer than it needs to on more sensible dates anyway
22:53 wajasu        dcook: can you comment on bgu 11232 comment #31.   i think if we write a UI for facet config, upon save we could generate enriched index configs that are xml included with fallback.
22:58 dcook         I think that you could've written the comment better :p
22:58 * talljoy     jumps in late to the debarment talk
22:59 dcook         It's a bit vague and has too many competing ideas. I think I understand what you're saying but most people probably won't.
22:59 larryb        wizzyrea, I went back to our site (I remembered) and changed the debarred field to 2022-12-31. Unfortunately that does not seem to have resolved the slow load.
22:59 dcook         As for the idea...
22:59 wizzyrea      I would try removing the date entirely
22:59 larryb        okay
22:59 larryb        NULL or blank?
22:59 dcook         wajasu: Actually, I have no idea what you're talking about in this comment
23:00 dcook         Some parts yes, some parts no
23:00 eythian       yeah, I suspect something really broken is happening in the date comparison.
23:00 wizzyrea      null should work
23:00 larryb        tnhx
23:01 dcook         On an unrelated note, I love tasty pastry
23:01 wizzyrea      don't we all.
23:02 dcook         Probably. But I just ate two and felt the need to share ;)
23:02 larryb        hmm that's odd. It still took 30+ seconds to load, the restriction message no longer shows on the detail page, but the Restriction tab is still showing a date of 12/31/9999
23:02 cait          that's the old default date - i think it might be right... not sure
23:03 mtompset      @note mtompset
23:03 huginn        mtompset: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command).
23:03 cait          hm but should show? *confused*
23:03 cait          did you change both?
23:03 mtompset      @notes
23:03 huginn        mtompset: I currently have notes waiting for #koha, bag:, bgkriegel, bgkriegel:, Brooke:, cait,, cait., cait:, ccurry, chris_c, chris_n,, chris_n:, christ, cindy, Culiforg:, dcook,, dpavlin:, drofj, drojf:, druthb_away, druthb_away:, eythian:, Genji:, gmcharlt:, hackfesters, hdl:, hdl_laptop:, http://www.ub.uni-dortmund.de/listen/inetbib/msg48204.html, jcamins:, juan-siera, kf,, khall, khall:, khall_away, (1 more message)
23:03 cait          borrower_debarments and borrowers.debarred?
23:03 mtompset      @notes mtompset
23:03 huginn        mtompset: Error: I have no notes for that nick.
23:04 larryb        not cait, I only changed borrowers.debarrred
23:04 larryb        let me look at borrower_debarments
23:04 cait          might be named a bit differently
23:04 larryb        no, that's it
23:04 cait          ah cool
23:05 larryb        Ah yes, it's 9999-12-31 in borrower_debarments, let me change that to NULL as well
23:05 mtompset      that reminds me of a bug someone was working on.
23:06 mtompset      bug 11846
23:06 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11846 major, P5 - low, ---, gmcharlt, Needs Signoff , Correct database update for debarments with 9999-12-31
23:07 larryb        cait wizzyrea that did it. the patron loaded in < 4 secs. However, the red "restricted" message is still gone. Do I need an actual date in there?
23:07 mtompset      NULL means debarred indefinitely.
23:07 mtompset      a date means debarred until then.
23:08 larryb        understood, but I think our library would object that the red restricted message is gone from right under the borrower name.
23:08 larryb        that went away when I set borrower.debarred to null
23:08 cait          hm it should be there i think
23:09 bag           yeah the green one is gone too
23:09 cait          larryb: maybe try something on a borrower
23:09 bag           :P
23:09 cait          debar a borrower from the gui
23:09 cait          leave the date empty
23:09 cait          only check the debarred
23:09 cait          and compar how it looks
23:09 cait          compare
23:09 wajasu        dcook: we would have a UI that reads facet config from YAML/JSON, whatever.  The index names to choose from in a dropdown are populated from the biblios-koha-indexdefs.xml. Upon save, we add the index:0 xml fragments, and write out biblios-koha-indexdefs-faceted.xml.  Then use xsltproc to generate biblio-zebra-indexdefs-faceted.xsl, and thus retreival-info-bib-grs1-faceted.xml.  Our...
23:09 wajasu        ...koha_conf.xml  can have an xml include for that retriieval file.  So the next zebraidx will have index : 0.  And the search zebra facet queries would be driven off of the YAML/JSON.
23:12 larryb        cait that revealed it.
23:12 cait          hi mario :)
23:12 larryb        here's what happening. when you debar with no date, the borrower_debarments expiration is NULL but the borrower.debarred field is 9999-12-31
23:12 mario         hey cait
23:13 cait          larryb: there you go :) you can blame kyle for that ;)
23:13 cait          but it made sense, it's like it used to work, guess he didn't want to change it
23:13 larryb        so 9999-12-31 is okay in borrowers, but it's NOT in borrower_debarments
23:13 bag           khall++  #for the baby
23:14 dcook         wajasu: GRS1 doesn't use XML for its config.
23:14 dcook         wajasu: At least it didn't used to...maybe I'll have to look at that again.
23:14 cait          larryb: hope it also fixes your page load
23:15 * cait        keeps finers crossed
23:15 larryb        it did for this slow patron
23:15 larryb        loaded in 4 secs
23:15 dcook         wajasu: Of course, doing a facet search will fail everytime before a re-index, but that's why you mention trying each facet separately if a all-facet query failed
23:15 larryb        let me change another to be sure
23:15 dcook         Maybe
23:15 bag           dcook: GRS1 doesn't use xml
23:15 dcook         bag: Good, so I'm not crazy :)
23:16 dcook         I wonder what this marc21-retrieval-info-bib-grs1.xml file is..
23:16 bag           never thought of you as being crazy dcook
23:17 dcook         bag: This file: retrieval-info-bib-grs1.xml also seems out of place..
23:17 larryb        WooHoo. Yes. Removing the date from borrower_debarments.expiration is what corrects the slow load
23:17 bag           hmm dcook I wonder if that's being used at all
23:18 eythian       ideally, fixing whatever makes the date comparison so slow should really be what's corrected.
23:18 bag           dcook: maybe that has something to do with Z3950?
23:18 bag           eythian++
23:18 dcook         wajasu: GRS1 uses record.abs instead of an .xml file
23:18 dcook         wajasu: Mind you, I think GRS1 is being deprecated soon so it might not matter.
23:19 dcook         bag: No idea :S. gmcharlt might know.
23:20 dcook         This looks like a job for git blame..
23:21 pianohacker   @karma karma
23:21 huginn        pianohacker: Highest karma: "gmcharlt" (56), "cait" (46), and "oleonard" (39).  Lowest karma: "windchill" (-3), "yui" (-2), and "css" (-2).  You (pianohacker) are ranked 18 out of 140.
23:21 pianohacker   karma++
23:21 bag           @karma karma karma
23:21 huginn        bag: Highest karma: "gmcharlt" (56), "cait" (46), and "oleonard" (39).  Lowest karma: "windchill" (-3), "yui" (-2), and "css" (-2).  You (bag) are ranked 15 out of 141.
23:22 bag           doesn't work here either pianohacker
23:22 dcook         bug 7818
23:22 bag           silly bot
23:22 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7818 critical, P1 - high, ---, robin, CLOSED FIXED, support DOM mode for Zebra indexing of bibliographic records
23:22 pianohacker   curses, we've been foiled again
23:22 dcook         @karma eythian
23:22 huginn        dcook: Karma for "eythian" has been increased 35 times and decreased 1 time for a total karma of 34.
23:22 * dcook       thinks he's increasing eythian's karma about every day :p
23:22 dcook         @karma
23:22 huginn        dcook: Highest karma: "gmcharlt" (56), "cait" (46), and "oleonard" (39).  Lowest karma: "windchill" (-3), "yui" (-2), and "css" (-2).  You (dcook) are ranked 22 out of 141.
23:22 pianohacker   did it get reset?
23:23 dcook         Beginning of the year, me thinks
23:23 dcook         You didn't see the epic thread?
23:23 pianohacker   no I didn't, actually
23:23 dcook         Probably for the best :p
23:24 pianohacker   dcook: ... what happened?
23:26 larryb        thank you #koha. you have helped us fix 20K + borrower problems
23:27 dcook         pianohacker: I can't actually recall anymore :/
23:27 pianohacker   but how will I know about the delicious
23:27 pianohacker   #koha drama?
23:27 dcook         lol
23:27 bag           @karma bag
23:27 huginn        bag: Karma for "bag" has been increased 12 times and decreased 0 times for a total karma of 12.
23:28 larryb        @wizzyrea++
23:28 mtompset      css is -2?!
23:28 huginn        larryb: I've exhausted my database of quotes
23:28 larryb        @cait++
23:28 bag           well thank you all who have given me kind karma's back at all of you alls
23:28 huginn        larryb: I suck
23:28 larryb        wizzyrea++
23:28 pianohacker   bag--
23:28 mtompset      pianohacker: It did get reset.
23:28 larryb        cait++
23:28 dcook         lol
23:28 pianohacker   11 is a nicer number
23:29 larryb        that's better
23:29 cait          :) thx larryb++ bag++
23:29 bag           hey I'm prime again - I can love that pianohacker
23:29 mtompset      prime numbers are always nicer. :)
23:29 bag           pianohacker++
23:29 pianohacker   woot woot
23:29 cait          oups
23:29 bag           oh well cait - you're still pretty damn rad
23:29 mtompset      @karma pianohacker
23:29 huginn        mtompset: Karma for "pianohacker" has been increased 7 times and decreased 0 times for a total karma of 7.
23:29 pianohacker   I need to pick up the pace since the reset!
23:29 dcook         @karma dcook
23:29 huginn        dcook: Karma for "dcook" has been increased 5 times and decreased 0 times for a total karma of 5.
23:29 dcook         high five!
23:30 bag           @karma bag #who gave me the karmas?
23:30 huginn        bag: bag #who gave me the karmas? has neutral karma.
23:30 bag           HA
23:30 bag           @karma bag --list
23:30 huginn        bag: bag --list has neutral karma.
23:30 pianohacker   ah, huginn, the ol' dumb raven
23:30 pianohacker   as opposed to wahanui, the cocaine-powered raven
23:31 mtompset      Does that mean wahanui will be Toronto's next mayor? ;)
23:31 dcook         pianohacker: If I recall correctly, I think there was some discontent about the stratification of karma, so the people with the most decided to renounce their karmic awesomeness to restore balance to the force.
23:31 dcook         Of course, they are awesome, so their karma will be regained anyway.
23:31 pianohacker   mtompset: nah, too coherent
23:31 pianohacker   dcook: Ah okay :)
23:31 bag           windows--
23:31 dcook         ie--
23:32 bag           M$--
23:32 mtompset      which version, bag?
23:32 dcook         Oh yeah...that reminds me to do a shout out for SLUG on twitter...
23:32 bag           windows_all--
23:32 pianohacker   Now that the previous productive conversation has been *completely* derailed, I'm out of here
23:32 dcook         lol
23:32 pianohacker   mtompset: one less than it was before
23:32 * pianohacker bows
23:32 bag           later pianohacker BE WELL
23:32 bag           oh I wonder if I got that in - in time
23:32 mtompset      people_who_use_windows_xp_past_april_8--
23:33 talljoy       lol
23:33 mtompset      html2++ # old school is always best. :P
23:34 bag           people_who_use_windows_xp_past_april_8--
23:44 wizzyrea      heh
23:45 bag           hey druthb
23:45 bag           by druthb_away
23:45 bag           bye*
23:49 eythian       C++
23:49 mario         bye