Time  Nick          Message
02:23 eythian       wizzyrea: is having an entry in both 100 and 110 considered incorrect?
02:23 eythian       I thought someone told me it was, but I'm seeing it in some data.
02:24 eythian       On the other hand, I probably don't care overly much.
02:24 wizzyrea      hm.
02:24 wizzyrea      I feel like you could have both
02:24 wizzyrea      hmmm loc it would seem wants one or the other.
02:25 eythian       OK cool
02:25 eythian       I'm calling this data invalid and ignoring the slightly weird case it causes then
03:01 eythian       wahanui: drama llama is <reply>http://i.imgur.com/9UgxHdD.jpg
03:01 wahanui       OK, eythian.
03:01 * eythian     saves for future use
03:11 * Francesca   is frustrated
03:20 eythian       wahanui: wizzyrea is also <reply>lizardrea
03:20 wahanui       okay, eythian.
03:20 wizzyrea      lol
03:25 * wizzyrea    nods
03:57 dcook         For evidence that dcook likes a good rant, check out bug 11297
03:57 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11297 enhancement, P5 - low, ---, maxime.beaulieu, Signed Off , Add support for custom PQF attributes for Z39.50 server searches.
03:57 dcook         Also for evidence that dcook sometimes changes his mind about things ;)
03:58 dcook         @later tell eythian awesome that you fixed your flights :)
03:58 huginn        dcook: The operation succeeded.
03:58 eythian       I'm still here
03:58 dcook         :D
03:58 dcook         I totally missed the fact that they reserved a block of rooms...
03:58 dcook         I figured since last year accomodation was survival of the fittest that this year it wouldn't be organized either...
03:58 eythian       I got one of them
03:58 dcook         I got one of the few remaining rooms that weren't part of the block
03:59 eythian       doh
03:59 eythian       I presume the block ones were cheaper?
03:59 eythian       I'm not sure
03:59 dcook         Yeah, the block ones were cheaper
03:59 dcook         I think we bought a flexible reservation though, so if something bad did happen I could bail at the last moment like last time
04:00 dcook         Although baby's heartbeat seemed strong this morning :)
04:01 dcook         I had a huge rant about PQF on bugzilla once upon a time but I can't remember what issue it was...
04:01 dcook         Or do I..
04:01 dcook         It had to do with the OPAC..
04:02 dcook         OpacSuppresion I think..
04:02 dcook         bug 10542 Bam!
04:02 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10542 critical, P1 - high, ---, martin.renvoize, CLOSED FIXED, QueryParser + OpacSuppression doesn't allow search in 'all libraries'
04:02 dcook         Of course, my esoteric knowledge of Z39.50, PQF, and Zebra might go out with window when ElasticSearch takes over ;)
04:03 eythian       I like to think ES is much more sane
04:03 dcook         I like to think so too
04:08 cdickinson    beer o'clock
04:08 wahanui       beer o'clock is a vital part of the Koha development process.
04:08 cdickinson    the bell hasn't rung yet
04:08 aleisha       wait for the ding
04:08 cdickinson    that's also the sound for tequila o'clock
04:09 Francesca     consult the printer
04:09 cdickinson    it says it's low on black toner
04:09 * Francesca   facepalms
04:09 wahanui       http://buikitty.files.wordpress.com/2012/02/20120202-094434.jpg
04:09 Francesca     who taught him that? its gold
06:16 * magnuse     waves
06:34 fridolin      hie
06:34 marcelr       hi #koha fridolin
06:51 reiveune      hello
06:55 alex_a        bonjour
06:58 Joubu         hi
06:58 wahanui       hey, Joubu
07:01 Joubu         xarragon_: Are you around?
07:02 Joubu         @later tell xarragon_ Did you manage to deal with your TestBuilder issue?
07:02 huginn        Joubu: The operation succeeded.
07:25 xarragon_     Joubu: Well I simply removed the constraint.
07:27 Joubu         no really a good idea I suppose :)
07:27 Joubu         not*
07:58 MichaelZ_UNNC Hello everybody
08:08 magnuse       hm, i'm getting "$ sudo koha-stop-zebra x" --> "Zebra already stopped for instance x" when zebra is in fact running. i thought eythian had a fix for that but now i can't find it. anyone got a clue?
08:59 cait          morning #koha
09:00 marcelr       hi cait
09:00 cait          hi marcelr :)
09:01 magnuse       morning?
09:01 cait          morning magnuse :)
09:16 sophie_m      hello
09:16 wahanui       niihau, sophie_m
09:17 sophie_m      can someone tell me when 3.18.11 will be ready ?
09:17 cait          sophie_m: i saw liz was pushing patches, but you'd have to ask her about the release date i think
09:20 sophie_m      thank you cait, liz not around
09:21 cait          yeah, nz is hard to catch for us - maybe email?
09:21 sophie_m      yes cait, done, thanks
09:33 cait          hi paul_p
09:34 paul_p        hi cait & others.
09:38 * Francesca   waves
10:51 mtj           bug 14361 magnuse?
10:51 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14361 major, P3, ---, benjamin.rokseth, Pushed to Stable , koha-restart-zebra fails and probably breaks upgrade
10:54 magnuse       mtj: possibly! i'll see if the upgrade to 3.20.4 fixes it, but i'm waiting another week for that
11:50 drojf         hi #koha
12:06 drojf         the new 3.18 is not out yet, is it?
12:07 cait          i don't think so, sophie_m asked about it earier as well
12:07 cait          and hi drojf ;)
12:08 drojf         ok then i'll send an email only for 3.10 to the german list :)
12:10 cait          3.10?
12:10 wahanui       3.10 is Koha 3.10 was released 23 November 2012
12:14 drojf         3.20
12:14 drojf         heh
12:14 drojf         i hope i wrote 3.20 in the email :D
12:15 cait          you are always so 'fleissig'
12:15 cait          that's only in quotes because german - I meant it nicely :)
12:22 drojf         i am? :)
12:22 drojf         i feel lazy most of the time
12:22 drojf         :P
12:33 drojf         elasticsearch?
12:33 wahanui       i heard elasticsearch was mosying along. I really ought to break out the bits I've had to build to support it, like Koha::Biblio and such.
12:35 drojf         if i want to play with ES, should i still use the catalyst repo? or what is on the bug on BZ?
12:36 cait          there is abug and it links to the branch i think
12:36 cait          or the rfc in the wiki
12:36 cait          hopefully linking both to the same branch
12:38 drojf         yes i have the link
12:38 drojf         lol
12:38 Joubu         drojf: use the catalyst/elastic_search branch
12:39 drojf         http://git.catalyst.net.nz/gw?p=koha.git;a=shortlog;h=refs/heads/elastic_search
12:39 * cait        waves at Joubu
12:40 xarragon_     Hmm, so I essentially need to turn a dbix resultset to and from json. Would it be reasonable to put that inside a Koha::Object class pair?
12:41 xarragon_     And then just add like.. Koha::MyStuff::Foobar class with a to_json and from_json methods.
12:41 xarragon_     It would be a collection of rows, so I guess it would go in the plural, "Foobars" class?
12:43 tcohen        morning
12:43 drojf         thanks cait and Joubu
12:43 drojf         hi tcohen
12:44 tcohen        hi drojf Joubu cait
12:56 tcohen        jajm: around?
12:56 jajm          tcohen, hi
12:57 tcohen        i didn't succeed running the api on plack with the packages plack.psgi file
12:57 tcohen        i created a followup for the tests to make them independent on the existing data
12:58 * ashimema    thinks if it's at all possible we should run mojo stuff on a mojo server.. hypnotoad for instance.. as it gives us event loops and other mojo clever stuffs without any extra work on our part
12:58 * ashimema    does also udnerstand why were trying to use plack for all
13:04 tcohen        ashimema: we cannot reach a consensus on the use of mojo, zero feedback on the plack integration... how do u think it would work if we even proposed to use a different server?
13:06 tcohen        ashimema: and I think we can do it, but first steps first
13:06 ashimema      I agree.. lets get it working on plack first..
13:07 ashimema      has anyone ventured to ask the Mojo guys how they might do what we're trying to do?
13:08 tcohen        ashimema: i tried a couple days ago
13:08 ashimema      ah.. take it you didn't get much joy from it then
13:08 ashimema      :9
13:09 xarragon_     Speaking of caching, are dev installations supposed to run slower than normal installs?
13:09 tcohen        ehh
13:09 ashimema      not that I know of xarragon_
13:09 tcohen        ashimema: no answer heh
13:10 xarragon_     Because on a modern i5 laptop with an SSD opac-main takes about 2 seconds.. A bit less with memcached but still slow.
13:11 ashimema      really..
13:11 wahanui       i heard really was more trouble than she's worth.
13:11 drojf         oh i'm cloning into a wheezy-vm. is jessie required for the ES-branch or will it work on wheezy too?
13:12 drojf         i guess i will find out eventually ;)
13:13 ashimema      not tired it drojf..
13:13 ashimema      fingers crossed it works for you
13:14 drojf         "Oh, and this requires Debian Jessie, as most of the old dependencies made it into there." well no i am almost there so i will try anyway ;)
13:14 drojf         *now
13:15 tcohen        drojf: just use the damn vagrant up jessie thing :-P
13:15 xarragon_     I have no idea what you're all doing, but if it is Perl module deps you are talking about, setting up a separate cpan install for Koha is pretty easy.
13:15 drojf         later :D
13:16 ashimema      :)
13:16 ashimema      catron + plenv = <B
13:18 drojf         no thats not gonna work
14:26 drojf         Content Warning: The information presented in this chapter is for your interest
14:26 drojf         lol
14:26 drojf         i sure hope so
15:01 reiveune      bye
15:02 huginn        New commit(s) kohagit: Bug 14505: single quotes in journal number cause print routing list window to not... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d222e6ec21c5d2aea03d839cd82050ca6437f0d4> / Bug 14217: Add 'condition' attribute for DOM index definition <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5d46dbf3e938fbc80436a263cdc417cd798e0ab4> / Bug 14873: Remove C4::Dates from reserve/request.pl <http://gi
15:04 nitz0         hi people
15:23 drojf         i know it's not the purpose of elasticsearch in koha, but couldn't we in theory throw everything in there instead of SQL?
15:26 drojf         (and wouldn't that be a lot of fun refactoring? :D)
15:27 liw           out of idle curiosity: how much data is there in a Koha database for a medium sized library? i.e., how big is an SQL dump for backups?
15:36 jcamins       drojf: ES doesn't really go in for ACID-compliance.
15:38 Joubu         drojf: That could be done for some entities, patrons for instance
15:38 Joubu         Have to go, good week-end!
15:38 drojf         Joubu: patrons was actually the first thing i was thinking of
15:39 drojf         you too
15:39 drojf         the good weekend, i mean :)
15:40 drojf         jcamins: but when i learn ES now, i want to use it for everything!
16:46 ashimema      that would be nice drojf
16:47 ashimema      there's nothing really stopping us from indexing stuff elsewhere..
16:47 ashimema      though would only be worthwhile if we actually feel retrieval from one index is faster/better from one indexer compared to another
17:19 tcohen        jcamins: Koha doesn't use transaction, does it?
17:22 nitz0         bug 1861
17:22 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1861 normal, P4, ---, kyle, RESOLVED FIXED, Unique patrons logins not (totally) enforced
17:26 tcohen        hi nitz0
17:28 nitz0         hi tcohen
17:28 tcohen        whatsup?
17:32 nitz0         daily mysqldump and restore. Just testing. I read, while I was running koha-upgrade-schema, that it seems to be duplicated users login.
17:33 nitz0         Upgrade to done (Bug 1861 - Unique patrons logins not (totally) enforced) FAILED!
17:33 huginn        04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1861 normal, P4, ---, kyle, RESOLVED FIXED, Unique patrons logins not (totally) enforced
17:33 nitz0         Your database has users with duplicate user logins. etc
17:34 tcohen        yeap, you should fix them, and run the alter table after that
17:36 nitz0         the work is manually, right?
17:36 tcohen        nitz0: something like this might help
17:36 tcohen        SELECT surname,firstname,email,cardnumber,userid,borrowernumber FROM borrowers WHERE userid IS NULL OR userid="";
17:37 tcohen        because that is the cause of duplicates (mostly) on my dbs
17:38 tcohen        nitz0: also this SELECT userid FROM (SELECT userid,COUNT(userid) AS the_count FROM borrowers GROUP BY userid) a WHERE the_count > 1
17:39 jcamins       tcohen: no, but we do use MySQL's consistency and durability guarantees.
17:41 nitz0         ok tcohen, thx.
17:52 nitz0         tcohen : the first sql shows 1526 results.
17:53 tcohen        nitz0: that means you are not providing your patrons with logins
17:53 tcohen        just put their emails there
17:54 tcohen        like UPDATE borrowers SET userid=email WHERE (userid='' OR userid IS NULL) AND email<>'';
18:10 nitz0         ready, fixed userid=cardnumber because not all users have email.
18:10 nitz0         noy ALTER TABLE?
18:11 tcohen        it's in the upgrade logs
18:11 nitz0         thx
18:12 tcohen        ALTER TABLE borrowers DROP INDEX userid, ADD UNIQUE userid (userid)
18:17 nitz0         good, thx again. finished.
18:19 tcohen        nitz0: glad to hear. it is always great to start the weekend with a win
18:43 huginn        New commit(s) kohagit: Bug 14883: Librarians are not warned if patron is restricted when placing holds <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e8182991804b591dc1730e46da343495af377d2f> / Bug 14882: Librarians are not warned if patron owe more than maxoutstanding when... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d46c13248741dc76e2e371d297a311f6143f459e> / Bug 14710: Make the export checkout list expo
18:53 tcohen        bye
18:53 tcohen        have a nice weekend
19:13 barton        @seen Joubu
19:13 huginn        barton: Joubu was last seen in #koha 3 hours, 35 minutes, and 22 seconds ago: <Joubu> Have to go, good week-end!
19:14 barton        ah, durn.
19:47 tcohen        hi
20:18 tcohen        khall_away: maybe it depends on how slow is the mysql server you are testing against?
21:28 nitz0         well people, bye all. thx allways.
21:34 tcohen        http://snag.gy/73yJf.jpg
21:34 tcohen        oops
21:56 tcohen        bye everyone