Time Nick Message 21:56 tcohen bye everyone 21:34 tcohen oops 21:34 tcohen http://snag.gy/73yJf.jpg 21:28 nitz0 well people, bye all. thx allways. 20:18 tcohen khall_away: maybe it depends on how slow is the mysql server you are testing against? 19:47 tcohen hi 19:14 barton ah, durn. 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:13 barton @seen Joubu 18:53 tcohen have a nice weekend 18:53 tcohen bye 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:19 tcohen nitz0: glad to hear. it is always great to start the weekend with a win 18:17 nitz0 good, thx again. finished. 18:12 tcohen ALTER TABLE borrowers DROP INDEX userid, ADD UNIQUE userid (userid) 18:11 nitz0 thx 18:11 tcohen it's in the upgrade logs 18:10 nitz0 noy ALTER TABLE? 18:10 nitz0 ready, fixed userid=cardnumber because not all users have email. 17:54 tcohen like UPDATE borrowers SET userid=email WHERE (userid='' OR userid IS NULL) AND email<>''; 17:53 tcohen just put their emails there 17:53 tcohen nitz0: that means you are not providing your patrons with logins 17:52 nitz0 tcohen : the first sql shows 1526 results. 17:41 nitz0 ok tcohen, thx. 17:39 jcamins tcohen: no, but we do use MySQL's consistency and durability guarantees. 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:37 tcohen because that is the cause of duplicates (mostly) on my dbs 17:36 tcohen SELECT surname,firstname,email,cardnumber,userid,borrowernumber FROM borrowers WHERE userid IS NULL OR userid=""; 17:36 tcohen nitz0: something like this might help 17:36 nitz0 the work is manually, right? 17:34 tcohen yeap, you should fix them, and run the alter table after that 17:33 nitz0 Your database has users with duplicate user logins. etc 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 Upgrade to 3.19.00.003 done (Bug 1861 - Unique patrons logins not (totally) enforced) FAILED! 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:28 tcohen whatsup? 17:28 nitz0 hi tcohen 17:26 tcohen hi nitz0 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:22 nitz0 bug 1861 17:19 tcohen jcamins: Koha doesn't use transaction, does it? 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 16:47 ashimema there's nothing really stopping us from indexing stuff elsewhere.. 16:46 ashimema that would be nice drojf 15:40 drojf jcamins: but when i learn ES now, i want to use it for everything! 15:39 drojf the good weekend, i mean :) 15:39 drojf you too 15:38 drojf Joubu: patrons was actually the first thing i was thinking of 15:38 Joubu Have to go, good week-end! 15:38 Joubu drojf: That could be done for some entities, patrons for instance 15:36 jcamins drojf: ES doesn't really go in for ACID-compliance. 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:26 drojf (and wouldn't that be a lot of fun refactoring? :D) 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:04 nitz0 hi people 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:01 reiveune bye 14:26 drojf i sure hope so 14:26 drojf lol 14:26 drojf Content Warning: The information presented in this chapter is for your interest 13:18 drojf no thats not gonna work 13:16 ashimema catron + plenv = <B 13:16 ashimema :) 13:15 drojf later :D 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 tcohen drojf: just use the damn vagrant up jessie thing :-P 13:14 drojf *now 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:13 ashimema fingers crossed it works for you 13:13 ashimema not tired it drojf.. 13:12 drojf i guess i will find out eventually ;) 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:11 wahanui i heard really was more trouble than she's worth. 13:11 ashimema really.. 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:09 tcohen ashimema: no answer heh 13:09 ashimema not that I know of xarragon_ 13:09 tcohen ehh 13:09 xarragon_ Speaking of caching, are dev installations supposed to run slower than normal installs? 13:08 ashimema :9 13:08 ashimema ah.. take it you didn't get much joy from it then 13:08 tcohen ashimema: i tried a couple days ago 13:07 ashimema has anyone ventured to ask the Mojo guys how they might do what we're trying to do? 13:06 ashimema I agree.. lets get it working on plack first.. 13:06 tcohen ashimema: and I think we can do it, but first steps first 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? 12:58 * ashimema does also udnerstand why were trying to use plack for all 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:57 tcohen i created a followup for the tests to make them independent on the existing data 12:57 tcohen i didn't succeed running the api on plack with the packages plack.psgi file 12:56 jajm tcohen, hi 12:56 tcohen jajm: around? 12:44 tcohen hi drojf Joubu cait 12:43 drojf hi tcohen 12:43 drojf thanks cait and Joubu 12:43 tcohen morning 12:41 xarragon_ It would be a collection of rows, so I guess it would go in the plural, "Foobars" class? 12:41 xarragon_ And then just add like.. Koha::MyStuff::Foobar class with a to_json and from_json methods. 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:39 * cait waves at Joubu 12:39 drojf http://git.catalyst.net.nz/gw?p=koha.git;a=shortlog;h=refs/heads/elastic_search 12:38 Joubu drojf: use the catalyst/elastic_search branch 12:38 drojf lol 12:38 drojf yes i have the link 12:36 cait hopefully linking both to the same branch 12:36 cait or the rfc in the wiki 12:36 cait there is abug and it links to the branch i think 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: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:33 drojf elasticsearch? 12:22 drojf :P 12:22 drojf i feel lazy most of the time 12:22 drojf i am? :) 12:15 cait that's only in quotes because german - I meant it nicely :) 12:15 cait you are always so 'fleissig' 12:14 drojf i hope i wrote 3.20 in the email :D 12:14 drojf heh 12:14 drojf 3.20 12:10 wahanui 3.10 is Koha 3.10 was released 23 November 2012 12:10 cait 3.10? 12:08 drojf ok then i'll send an email only for 3.10 to the german list :) 12:07 cait and hi drojf ;) 12:07 cait i don't think so, sophie_m asked about it earier as well 12:06 drojf the new 3.18 is not out yet, is it? 11:50 drojf hi #koha 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 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:51 mtj bug 14361 magnuse? 09:38 * Francesca waves 09:34 paul_p hi cait & others. 09:33 cait hi paul_p 09:21 sophie_m yes cait, done, thanks 09:21 cait yeah, nz is hard to catch for us - maybe email? 09:20 sophie_m thank you cait, liz not around 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:17 sophie_m can someone tell me when 3.18.11 will be ready ? 09:16 wahanui niihau, sophie_m 09:16 sophie_m hello 09:01 cait morning magnuse :) 09:01 magnuse morning? 09:00 cait hi marcelr :) 09:00 marcelr hi cait 08:59 cait morning #koha 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? 07:58 MichaelZ_UNNC Hello everybody 07:27 Joubu not* 07:27 Joubu no really a good idea I suppose :) 07:25 xarragon_ Joubu: Well I simply removed the constraint. 07:02 huginn Joubu: The operation succeeded. 07:02 Joubu @later tell xarragon_ Did you manage to deal with your TestBuilder issue? 07:01 Joubu xarragon_: Are you around? 06:58 wahanui hey, Joubu 06:58 Joubu hi 06:55 alex_a bonjour 06:51 reiveune hello 06:34 marcelr hi #koha fridolin 06:34 fridolin hie 06:16 * magnuse waves 04:09 Francesca who taught him that? its gold 04:09 wahanui http://buikitty.files.wordpress.com/2012/02/20120202-094434.jpg 04:09 * Francesca facepalms 04:09 cdickinson it says it's low on black toner 04:09 Francesca consult the printer 04:08 cdickinson that's also the sound for tequila o'clock 04:08 aleisha wait for the ding 04:08 cdickinson the bell hasn't rung yet 04:08 wahanui beer o'clock is a vital part of the Koha development process. 04:08 cdickinson beer o'clock 04:03 dcook I like to think so too 04:03 eythian I like to think ES is much more sane 04:02 dcook Of course, my esoteric knowledge of Z39.50, PQF, and Zebra might go out with window when ElasticSearch takes over ;) 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 bug 10542 Bam! 04:02 dcook OpacSuppresion I think.. 04:01 dcook It had to do with the OPAC.. 04:01 dcook Or do I.. 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:00 dcook Although baby's heartbeat seemed strong this morning :) 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 03:59 dcook Yeah, the block ones were cheaper 03:59 eythian I'm not sure 03:59 eythian I presume the block ones were cheaper? 03:59 eythian doh 03:58 dcook I got one of the few remaining rooms that weren't part of the block 03:58 eythian I got one of them 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 dcook I totally missed the fact that they reserved a block of rooms... 03:58 dcook :D 03:58 eythian I'm still here 03:58 huginn dcook: The operation succeeded. 03:58 dcook @later tell eythian awesome that you fixed your flights :) 03:57 dcook Also for evidence that dcook sometimes changes his mind about things ;) 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 For evidence that dcook likes a good rant, check out bug 11297 03:25 * wizzyrea nods 03:20 wizzyrea lol 03:20 wahanui okay, eythian. 03:20 eythian wahanui: wizzyrea is also <reply>lizardrea 03:11 * Francesca is frustrated 03:01 * eythian saves for future use 03:01 wahanui OK, eythian. 03:01 eythian wahanui: drama llama is <reply>http://i.imgur.com/9UgxHdD.jpg 02:25 eythian I'm calling this data invalid and ignoring the slightly weird case it causes then 02:25 eythian OK cool 02:24 wizzyrea hmmm loc it would seem wants one or the other. 02:24 wizzyrea I feel like you could have both 02:24 wizzyrea hm. 02:24 eythian On the other hand, I probably don't care overly much. 02:23 eythian I thought someone told me it was, but I'm seeing it in some data. 02:23 eythian wizzyrea: is having an entry in both 100 and 110 considered incorrect?