Time  Nick            Message
22:50 eythian         Because it's funny
22:50 * eythian       wishes to remind you that the CPAN testing system is called CPANTS
22:36 huginn          eythian: The operation succeeded.
22:36 eythian         @later tell LibraryClaire https://www.mcsweeneys.net/articles/concepts-for-which-i-suspect-the-germans-have-a-single-word
22:06 sdlib           still no change
21:58 sdlib           so is it configured to update after a certain amount of time or is it a manual thing? i think i changed the slips before several months ago and changes went through almost immediately
21:51 sdlib           ok i'll give it a few and see if i get the changes
21:50 bag             sdlib: restarted
21:48 bag             give me about 10 minutes and you should now see your changes
21:48 sdlib           thanks!
21:48 bag             we’ll get someone on that for you
21:48 bag             perfect - yes you’re with us
21:47 sdlib           Grace Balloch
21:46 bag             I can get someone on that right away for you if you’re with bywater sdlib
21:46 bag             which library are you at now sdlib
21:46 kidclamp        have a great weekend #koha
21:46 sdlib           i will find out. thanks!
21:46 bag             cool yeah that’s us
21:45 sdlib           i *think* we go through people called bywater solutions but idk if they do the actual hosting or not
21:45 bag             yes :)
21:45 sdlib           good question. so, basically i find out where koha is hosted for us and if it's something i have access to i restart memcached and if not i ask the people who host it for us to do it.
21:44 bag             yes where is koha hosted for you?
21:44 sdlib           our library's server?
21:43 sdlib           hmm.... i am not sure i have access to that
21:42 bag             from the commandline on your server
21:42 sdlib           what is memchached, where is it, how do i restart it?
21:42 bag             ah SD cool - welcome
21:41 sdlib           south dakota
21:41 sdlib           no
21:41 bag             sdlib: is this san diego law library?
21:40 sdlib           ??
21:40 bag             you probably have to restart memcached
21:36 sdlib           tried to edit 'issue quick slip' (print) and it did nothing, that was 2 hours ago
21:34 sdlib           how long does it take a quick slip update to take effect?
20:43 eythian         It's a crazy world at huge scale.
20:42 * eythian       has moved into the team building the new highly containered Perl infrastructure at work, and is starting to develop Opinions on it.
20:41 eythian         Not impossible.
20:41 eythian         Yeah, the namespacing of instances needs to be moved more into koha itself to solve that.
20:40 eythian         bag: catalyst too (unless things have changed, but I doubt it.)
20:40 mtompset        Have a great day, #koha bag eythian
20:38 bag             can’t wait for ES - then clustering will be loads of fun ;)
20:38 bag             currently zebra is a bit of a limitation in clustering and plack…  you need plack for every instance so you sort of suck up memory…  We need the single plack for multiple instances
20:37 mtompset        That would make me happy. :)
20:37 bag             yeah we do that eythian
20:34 eythian         Well, I'll look at it if I get my system properly designed and built any time soon :)
20:34 mtompset        And yet, no one has signed off for months. :(
20:33 eythian         Hmm, that looks like a problem. That'll hit many people.
20:31 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16690 minor, P5 - low, ---, mtompset, Needs Signoff , Installing DB on remote server fails without *.* permissions
20:31 mtompset        bug 16690
20:31 mtompset        ooo... in that case, do I have a bug for you!
20:31 eythian         My cluster is built of tiny machines
20:31 eythian         Putting everything that can be separated on a different machine.
20:31 mtompset        splitting, as in putting the DB on a different machine?
20:30 eythian         I'm building a cluster, and when I get the infrastructure sorted, I'm going to have a go at splitting koha up to fit in it.
20:30 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17260 major, P5 - low, ---, philippe.blouin, Needs Signoff , updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns
20:30 mtompset        *gasp* I was curious if you could play with bug 17260, as it seems to make the installation process succeed for the Xenial Kohaev box. :)
20:29 eythian         I have no koha dev box at the moment
20:29 mtompset        eythian: You got a Xenial Kohadev box? :)
20:27 mtompset        ""SSL" means "Secure Sockets Layer". This was coined by the inventors of the first versions of the protocol, Netscape (the company was later bought by AOL)." (http://security.stackexchange.com/questions/5126/whats-the-difference-between-ssl-tls-and-https)
20:26 eythian         I should learn about it.
20:26 eythian         But my knowledge isn't great on this.
20:26 eythian         Not at all to my knowledge.
20:25 mtompset        And potential legal issues with Netscape having SSL trademark or something?
20:25 eythian         (I want to say SNI is one of those, but I'm not sure.)
20:24 eythian         You'd be better to look them up, my explanation will be a bit half arsed. The essence is that TLS is similar to, and the successor to, SSL. I think mostly SSL isn't able to do certain things that TLS can.
20:22 mtompset        Okay, eythian edumacate me. TLS != SSL, explain the diff.
20:19 eythian         But wrong to us pedants! Boo! Hiss! ;)
20:18 bag             that was probably my mistake
20:18 bag             I wasn’t sure all the readers understood TLS so I went simple
20:17 bag             :)
20:17 eythian         bag: a correction about your Let's Encrypt press release: you're hopefully using TLS and not SSL.
20:14 huginn          eythian: The operation succeeded.
20:14 eythian         @later tell drojf weirdos: http://www.atlasobscura.com/articles/the-heated-highly-political-roof-war-that-captivated-berlin-before-world-war-ii
19:56 mtompset        Sorry for the heart attack. ;)
19:56 mtompset        That's why.
19:56 mtompset        typo
19:56 mtompset        oops...
19:55 oleonard        Dang.
19:55 mtompset        oleonard: I get a conflict
19:28 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17942 enhancement, P5 - low, ---, oleonard, Needs Signoff , Update style of the web installer with Bootstrap 3
19:28 oleonard        Oh hey look Bug 17942 still needs a signoff.
17:18 * mtompset      curses apparmour and mysql not playing nice.
17:06 wahanui         hi olé onard
17:06 kidclamp        hi oleonard
17:05 oleonard        Hi kidclamp
17:03 huginn          kidclamp: The current temperature in Wilder Street, Hartford, Vermont is 3.4°C (12:02 PM EST on January 27, 2017). Conditions: Overcast. Humidity: 54%. Dew Point: -5.0°C. Windchill: 3.0°C. Pressure: 29.39 in 995 hPa (Falling).
17:03 kidclamp        @wunder 05001
16:46 barton          yaz-client unix:/var/run/koha/switch/bibliosocket:/biblios didn't work either.
16:46 barton          I figured if I left an empty port, the colon would act as a delimiter:
16:45 barton          I tried yaz-client unix:/var/run/koha/switch/bibliosocket /biblios, but that caused unhappiness.
16:44 barton          is there a way of specifying the database to connect to in yaz-client when we're using sockets?
16:44 oleonard        On to 19000
16:43 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18006 enhancement, P5 - low, ---, gmcharlt, NEW , MARC21: Don't show 246 when 1st indicator = 3
16:43 cait            bug 18006
16:43 wahanui         nice is perhaps not as enthusiastic of a word as I meant
16:43 cait            but nice anyway
16:42 cait            not very spectacular :)
16:42 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18000 enhancement, P5 - low, ---, alex.arnaud, Needs Signoff , Add --tablename option to misc/devel/update_dbix_class_files.pl script
16:42 cait            bug 18000
16:42 cait            oh
16:42 barton          I have a yaz-client question -- the syntax for specifying a server, either on the command line or with 'open', is [(tcp|ssl|unix|http)':']host [:port][/base] ... but when connecting to a unix socket, the '/base' part (e.g. /biblios) isn't distinguishable from part of the socket path. yaz-client unix:/var/run/koha/switch/bibliosocket/biblios doesn't work.
16:40 cait            hm think only 3
16:39 cait            or only for 3?
16:39 wahanui         7
16:39 cait            3 and 4?
16:39 cait            is that for indicators 3 and 5?
16:38 cait            that suits me fine actually :)
16:38 cait            ok
16:38 tcohen          that's Jared's understanding
16:34 cait            I'd file a bug then
16:34 cait            is that in the docs somewhere that it should not be shown?
16:34 cait            ah
16:31 tcohen          cait ^^^ that's for you
16:31 tcohen          "
16:31 tcohen          That is a made up example, of course.
16:31 tcohen          246 33 $a Apples and bears
16:31 tcohen          245 10 $a Apples & bears
16:31 tcohen          For example:
16:31 tcohen          "The title entered is searchable but will not be shown.
16:31 * mtompset      grins.
16:31 * tcohen        is parsing the telephatic answer from Jared
16:30 mtompset        I even posted on FB. :P
16:28 tcohen          jcamins
16:28 tcohen          jcamins
16:27 tcohen          jcamins
16:26 * oleonard      sets out a plate of freshly-baked cookies to lure jcamins
16:26 * druthb        invokes the jcamins
16:24 tcohen          need to spell his name three times I think
16:22 mtompset        Oooo.... jcamins the demi-god of cataloguing.
16:21 tcohen          can we invoke jcamins?
16:21 mtompset        But remember, I'm not a librarian, so I know squat in MARC. :)
16:21 mtompset        I would treat 246 like 245's if they could repeat. :)
16:20 mtompset        Oh, 245 isn't repeatable.
16:20 cait            and there is an example of 3 with the second indicator set
16:19 cait            but that's 0 and 1
16:19 cait            hm When displayed/printed as a note, varying forms of titles are usually preceded by                an                introductory term or phrase that is generated as a display constant based on the second                indicator value.
16:19 mtompset        I'm not a librarian, so I don't know.
16:18 mtompset        I'm just reading the link you gave.
16:17 cait            where are you getting this from?
16:17 cait            like a $i?
16:17 mtompset        Where as 1 and 3 -- yes, yes, I got that, but that's not relevant to the context I'm thinking -- must have something saying what kind of title is generated.
16:16 tcohen          3 - 2 = 1
16:16 mtompset        It seems to me that 0 and 2 must always have a second indicator of #.
16:15 mtompset        Okay, re-reading it again... tcohen this is the MARC mess.
16:15 tcohen          mtompset: 1
16:15 cait            no idea
16:14 mtompset        Hmm... what is the difference between 2 and 3, cait?
16:06 * ashimema      wonders if there's popcorn available ;)
16:05 * ashimema      sits back to watch the MARC fight progress
16:04 reiveune        bye
15:45 tcohen          you are the reader this time, sorry
15:45 cait            tcohen: afraid so
15:42 drojf           have a nice weekend #koha
15:40 * drojf         throws MARC at cait
15:40 drojf           MARCfight!
15:36 tcohen1         cait: that's left to the readers interpretation
15:24 cait            "Whether a note and/or an added entry is generated from the field." not sure what that means really
15:24 cait            'no note, added entry'?
15:24 cait            how do you interpret 3?
15:24 cait            looking at indicators for http://www.loc.gov/marc/bibliographic/bd246.html
15:23 mtompset        tcohen: probably not? my kohadevboxes are down.. it will take 3 hours to get them back.
15:19 eythian         I'd just move everything to systemd units myself :)
15:19 eythian         you could put an if catching $?, that's probably not terrible.
15:18 eythian         if you could return $?, then you wouldn't need the && || stuff anyway, you'd just return the value from daemon.
15:17 tcohen          mtompset: you provided a followup for 17467, do u plan to sign it?
15:14 mtompset        Why if? Why not return $?;
15:12 eythian         I'd probably put it in an if for clarity myself.
15:12 eythian         yeah, it's left-associative. So if the daemon call is successful, it returns 0, else returns 1.
15:07 mtompset        ?
15:07 mtompset        So daemon returns non-zero and the && return 0 || return 1 toggles the value to a success (0) or failure (1)
15:07 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17467 enhancement, P5 - low, ---, tomascohen, Needs Signoff , There should be a koha-zebra script to handle Zebra daemons for instances
15:06 tcohen          mtompset: bug 17467
15:05 wahanui         rumour has it beer o'clock is a vital part of the Koha development process
15:05 drojf           beer o'clock
15:05 eythian         it's not nice, but it's legit
15:05 eythian         that's legit
15:05 eythian         ah
15:04 pastebot        "mtompset" at 127.0.0.1 pasted "yuckiness" (15 lines) at http://paste.koha-community.org/285
15:04 mtompset        eythian: koha-start-zebra
15:03 mtompset        just looking at the debian scripts file.
15:03 mtompset        don't recall anything. :)
15:02 tcohen          mtompset: did you sign my patches removing koha-start-zebra already=?
15:02 eythian         no one should ever write return 0 || return 1 I'm sure
15:02 eythian         what is that?
15:01 mtompset        I vaguely recall worrying about that return 0 || return 1 mess.
15:01 mtompset        tcohen: I think it is the koha-start-zebra that is the broken this, not the create.
15:00 Joubu           I guess it's a long standing bug
15:00 Joubu           well, there is 1 check. So if the patron can place 1 hold, he is able to place X holds
14:59 Joubu           So if you are placing several holds in once row, there is no check...
14:59 Joubu           placerequest is added reserve without checking if the patron can still place a hold
14:59 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17978 major, P5 - low, ---, koha-bugs, REOPENED , Circ rules will not limit holds
14:59 Joubu           Is bug 17978 a bug?
14:58 tcohen          we should definitely ship a sample extended configuration file
14:58 tcohen          include_items: 1
14:56 drojf           thanks, will have a look
14:56 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12252 enhancement, P5 - low, ---, robin, CLOSED FIXED, OAI-PMH GetRecord result doesn't include item data
14:56 drojf           i found bug 12252
14:55 tcohen          it is not properly documented
14:55 tcohen          https://perldoc.koha-community.org/opac/oai.html
14:55 tcohen          in extended mode
14:54 tcohen          yes
14:54 drojf           is it possible to get item info in OAI?
14:48 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18005 major, P5 - low, ---, gmcharlt, NEW , Pagination of the search result displayed wrong
14:48 Joubu           bug 18005
14:48 Joubu           josef_moravec: any chances you could take a lookt?
14:47 Joubu           ok confirmed it's bootstrap
14:46 LibraryClaire   Joubu me too
14:45 cait            lucky we pushed early
14:45 Joubu           I get 1 page per line, it's ugly
14:45 Joubu           ha that may be caused by bootstrap3
14:45 cait            can't test right now
14:44 Joubu           master
14:44 Joubu           Is the pagination of the search result broken on the staff interface?
14:29 mtompset        Yep. About to try to track that down.
14:29 tcohen          something changed in the return value for koha-create
14:29 mtompset        When is the last time someone actually tried koha-create on a normal git clone?
14:28 mtompset        Hmmm.. same problem for Jessie.
14:17 mtompset        Hmm... it had a skipping on that step this time. I'll have to check when it is finished.
14:15 tcohen          should make it continue
14:15 tcohen          vagrant xenial provision
14:15 tcohen          mtompset: i got the same
14:14 pastebot        "mtompset" at 127.0.0.1 pasted "Current 'vagrant up xenial' failure" (2 lines) at http://paste.koha-community.org/284
13:41 mtompset        it keeps barfing on koha-common
13:40 mtompset        I can't sudo apt-get upgrade my kohadevbox.
13:40 mtompset        Sorry, different context.
13:40 * mtompset      frowns.
13:40 tcohen          mtompset: for ES 2.x+ we are pulling the Oracle Java runtime
13:39 * LibraryClaire does a Friday dance
13:38 magnuse         \o/
13:37 edveal          Happy Friday!
13:34 mtompset        ^perfer^prefer^
13:33 mtompset        Personally, I'd just perfer a way to install the latest JRE as needed. The whole xenial/!xenial split is too rigid.
13:33 mtompset        I'm just looking at your comment on the kohadevbox issue, tcohen
13:32 tcohen          hi mtompset
13:30 wahanui         salut, edveal
13:30 edveal          Hello
13:24 mtompset        Greetings, #koha.
13:24 huginn          mtompset: tcohen was last seen in #koha 33 minutes and 2 seconds ago: <tcohen> finally!
13:24 mtompset        @seen tcohen
13:23 magnuse         plugins++
13:23 cait            it's helpful when seleting a new plugin you want to use
13:19 cait            plugin popularity - dokuwiki does that
13:18 marcelr         ok thx
13:18 khall           marcelr: pluggability should be for the controlling behavior, not for the action imo. I'm trying to say if the plugin hook could be used to decide if any given hold form field should be required it would make more sense to me. That being said, I'm not opposed to it the way it works atm. I'm wondering if maybe HEA should be able to track installed plugins, that would be useful
13:16 marcelr         yes, so a good reason for a plugin, yes?
13:15 khall           marcelr: as in the change is very very specific, and not general. It decides if one hold field is required, rather than all hold fields in general
13:14 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15545 enhancement, P5 - low, ---, m.de.rooy, Signed Off , Optionally make hold notes required when placing a hold (via Koha::Plugin)
13:14 marcelr         khall: not sure if i understand your comments on bug 15545 about odd behavior
12:54 oleonard        quit
12:54 * oleonard      brb
12:52 cait            :P
12:51 tcohen          finally!
12:50 * cait          loves kohadevbox :)
12:49 oleonard        Oh cool, updated VirtualBox Guest Additions getting installed automatically
12:49 oleonard        :D
12:49 * tcohen        loves superpowers, though
12:48 tcohen          and have a more koha-ish qa workflow
12:48 tcohen          I think it might be time to move kohadevbox into the koha repositories now that some people use it
12:48 tcohen          ha
12:48 oleonard        Sure, thanks for the instructions on filing an issue.
12:47 tcohen          hi oleonard, thanks for taking care of README.md
12:39 * tcohen1       loves to see more people contributing to make kohadevbox better
12:39 tcohen          oleonard++
11:37 khall           sure!
11:37 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15545 enhancement, P5 - low, ---, m.de.rooy, Signed Off , Optionally make hold notes required when placing a hold (via Koha::Plugin)
11:37 Joubu           khall: Hi! Can I get your opinion on bug 15545 please? See last comment
11:10 tcohen          that's why this deserves to be rewritten on top of the REST api IMHO
11:10 tcohen          most issues are related to how tied is the data model to the page structure
11:09 tcohen          Joubu: thanks!
11:09 Joubu           tcohen: I let a comment
11:08 tcohen          Joubu: tell me
11:08 Joubu           tcohen: found a bug, must be trivial to fix
11:00 Joubu           so you won't see all the schema files on git status
11:00 Joubu           alex_a_: it will not modify the timestamp and so the md5sum unless modified
10:58 alex_a_         Never said that there was a bug in DBIx::Class::Schema::Loader
10:58 alex_a_         Joubu: What is fixed in new version of DBIx::Class::Schema::Loader ?
10:57 tcohen          I started with CheckUniqueness
10:57 tcohen          of course
10:56 Joubu           tcohen: is it on your todolist? :D
10:56 Joubu           tcohen: yep, seen your answer :)
10:56 huginn          marcelr: The operation succeeded.
10:56 marcelr         @later tell kidclamp: please try bug 17980 for me
10:55 tcohen          the plan to refactor some controller scripts and templates was left for later on purpose
10:55 tcohen          my work was to resurrect that work
10:55 tcohen          Joubu, regarding 13757
10:55 tcohen          alex_a_: hehe
10:55 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17982 minor, P5 - low, ---, m.de.rooy, Needs Signoff , Fix the use of uniq in sub themelanguage
10:55 marcelr         who is signing off this trivial one: bug 17982
10:53 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20000 could not be retrieved: InvalidBugId
10:53 marcelr         aiming for bug 20000
10:53 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18000 enhancement, P5 - low, ---, alex.arnaud, Needs Signoff , Add --tablename option to misc/devel/update_dbix_class_files.pl script
10:53 marcelr         bug 18000
10:52 alex_a_         -a
10:52 alex_a_         Joubu: we make great a thing by doing many small ones
10:51 Joubu           ashimema: I have explained on 18003 the problem and the different solutions I have in mind. I have also attached an example of why we need it
10:48 Joubu           ashimema: I have brought this discussion last year, it did not interest lot of people
10:48 ashimema        I'm not fully in the loop on why we're worrying about it all right now ;)
10:47 ashimema        but it's a fairly drastic change
10:47 ashimema        we 'could' mark borrowers in the borrowers table as deleted instead of having a deleted_borrowers table at all.. that would maintain integrity?
10:46 Joubu           alex_a_: you could have found a more exiting bug for 18000!
10:43 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 enhancement, P5 - low, ---, gmcharlt, NEW , Should deletedborrowers.borrowernumber be a primary key?
10:43 Joubu           ashimema, and for the record: bug 18003
10:41 drojf           heh huginn is not happy today
10:41 huginn          tcohen: The current temperature in Cordoba, Argentina is 11.0°C (7:00 AM ART on January 27, 2017). Conditions: Clear. Humidity: 88%. Dew Point: 9.0°C. Pressure: 30.18 in 1022 hPa (Steady).
10:41 tcohen          @wunder cordoba, argentina
10:41 tcohen          ok
10:41 huginn          tcohen: Error: HTTP Error 404: Not Found
10:41 tcohen          @wunder ARXX1831
10:41 drojf           yay calls. i did that yesterday, like half the day
10:41 tcohen          ashimema: YAY
10:40 * ashimema      is in his next call
10:40 magnuse         \o/
10:40 huginn          magnuse: The current temperature in Bodo, Norway is 7.0°C (11:20 AM CET on January 27, 2017). Conditions: Scattered Clouds. Humidity: 81%. Dew Point: 4.0°C. Windchill: 2.0°C. Pressure: 29.95 in 1014 hPa (Steady).
10:40 tcohen          hola magnuse drojf and ashimema
10:40 magnuse         @wunder enbo
10:40 magnuse         ¡hola tcohen!
10:40 drojf           hi tcohen and ashimema
10:40 huginn          tcohen: Error: HTTP Error 404: Not Found
10:40 tcohen          @wunder anisacate, argentina
10:39 tcohen          morning
10:35 ashimema        but that sorta feels really nasty too
10:34 ashimema        we 'could' use guid's
10:34 ashimema        I wonder if ribasushi has ever come up against this sort of issue?
10:33 ashimema        ack.. i can't think of a nice way around this then :(
10:32 ashimema        yeah.. that's not nice at all
10:31 Joubu           but that is awful
10:31 Joubu           we could deal with that at code level I guess, and force the borrowernumber when inserting it, if already exist in deletedborrowers
10:30 ashimema        you have to work really hard in postgres to get such a cock up
10:30 ashimema        it's ai is 'safe'
10:30 ashimema        that wouldn't happen in postgres
10:29 ashimema        oh god.. AI is horrible in mysql
10:29 Joubu           AI is Auto Increment
10:29 wahanui         Joubu: I forgot ai
10:29 Joubu           forget AI
10:29 Joubu           auto increment
10:29 Joubu           if mysql is restart and the table is empty, AI is reset
10:29 wahanui         AI is 42, add a patron, will be 42. AI is now 43. Delete it via the cli, AI is still 43
10:29 ashimema        AI?
10:29 ashimema        I thought it was an auto_increment primary key
10:28 Joubu           borrowernumber is the PK, but the fact that it is automatically set by AI will cause this problem
10:28 ashimema        is mysql that bad
10:28 ashimema        after a server reboot
10:28 ashimema        erm
10:28 Joubu           yes, it is
10:28 ashimema        i can totally understand re0using cardnumbers
10:28 ashimema        primary key should be borrowernumber :)
10:27 Joubu           the problematic use case: 1. install Koha, 2. Create a test patron, 3. Delete it. 4. Next day (after server reboot) Create a patron (get the same borrowernumber as the first one), 5. Delete it => boom
10:27 cait            ashimema: cardnumbers - yes, but not borrowernumbers
10:27 cait            no
10:27 * ashimema      thinks he may have seen it.. but can't understand where it came from
10:27 ashimema        how can it happen
10:26 Joubu           I do not want or need, but it can happen
10:26 ashimema        are you thinking people should be able to re-use borrowernumbers once the original user with that number has been deleted
10:26 ashimema        in the deleted_borrowers table
10:26 ashimema        so yeah.. the issue is why wuold you ever need/want duplicate borrowernumbers?
10:25 cait            so have it unique and then the PK definition in the DBIX config?
10:25 cait            without primary?
10:25 cait            could we only set the column to unique?
10:25 cait            in theory... that shouldn't happen
10:22 Joubu           nope, the first matching row!
10:22 Joubu           and the last matching row is picked
10:22 Joubu           but if there are 2, I get a warning: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at t.pl line 584
10:22 Joubu           if there is only 1 matching row, the find works
10:22 Joubu           tried*
10:22 Joubu           ashimema: just try kyle's patch:
10:14 ashimema        back to the why it's not in the db.. I can't remember.. I'll ask a colleague.. I'm sure he had issue with it at some point
10:13 ashimema        so yeah.. khall has suggested what I was suggesting
10:13 ashimema        busy day for calls :(
10:13 ashimema        10 minutes to the next call
10:07 huginn          cait: The operation succeeded.
10:07 cait            @later tell khall ping me when you are around?
10:07 cait            Joubu: ok with me then :)
09:56 Joubu           ok thanks!
09:56 Joubu           What khall suggested to do. It was me that asked if it was not better to have the constraint set at the DB level
09:56 ashimema        will reply proper in a few minutes
09:56 Joubu           https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=59583
09:56 ashimema        in a meeting right now
09:56 ashimema        you just tell it in the resultclass what field your treating as the primary key
09:55 Joubu           if you call ->find on the pk? :)
09:55 Joubu           ashimema: how does dbic handle that?
09:54 Joubu           without the patch (master): checkout|checkin|renew|search cat
09:54 * ashimema      hasn't read all the way back.. but points out you can have a dbic primary key defined that's not actually a real primary key in the database
09:54 Joubu           so with the patch: "syspref | checkout | search cat"
09:53 Joubu           cait: it's checkout indeed, not checkin!
09:52 Joubu           opened this discussion one year ago, nobody cared about
09:52 Joubu           yes I know...
09:51 fridolin        relationnal DB
09:50 fridolin        maybe having deleted data tables is not a good idea in SQL
09:50 fridolin        the row i mean
09:49 fridolin        the new PK will seem useless but there are a lot, just there to id the line
09:49 Joubu           so yes, that sucks
09:49 fridolin        if the borrowernumber is the same boom
09:49 fridolin        yep 5. delete the new patron
09:48 fridolin        i think you must empty RAM
09:48 Joubu           well not boom yet, but when you will delete your first patron
09:48 fridolin        before 4 reboot the server
09:48 Joubu           the problematic use case: 1. install Koha, 2. Create a test patron, 3. Delete it. 4. Next day Create a patron => boom
09:48 fridolin        #KISS
09:48 fridolin        KISS
09:48 fridolin        Joubu: yes but if you must do something for old_issues/reservers, do the same for deleted* no ?
09:47 cait            will it reset the AI then too?
09:47 cait            reading back - what happens when you delete the last borrower added and then restart?
09:46 fridolin        indeed
09:46 Joubu           that's a weird case
09:46 fridolin        the SQL just failes on existing PK
09:46 Joubu           fridolin: so the only case it could happen is if you remove all the patrons of your DB but you have deleted patrons
09:46 fridolin        Joubu: i'm not a DB expert, i just know the AI reset issue can be very hard to detect
09:44 cait            Joubu: i think better have patron and checkout or so
09:44 cait            Joubu: checkin makes no sense for me
09:43 Joubu           I guess it's a... feature
09:43 Joubu           indeed the AI is reset if the table is empty and the dbms is restart
09:40 Joubu           no PK atm
09:40 Joubu           yes but I would make sure it's needed first
09:40 fridolin        how are old_issues and old_reserves ?
09:39 fridolin        then create a new column I-d say : deletedborrowernumber PK AI
09:39 fridolin        Joubu: ahhh always
09:39 Joubu           fridolin: we need a PK for DBIC
09:39 fridolin        and  regular delete of old entries
09:38 fridolin        in the end, deletedborrowers is only for statistics, a simple index on borrowernumber should be enought
09:38 fridolin        i remember it is not the case in Oracle ...
09:38 fridolin        "if the table is empty and the DB is rebooted, the AI is reset?" in MySQL / MariaDB yes im pretty sure
09:37 fridolin        it will rare to empty borrowers table but the case exists
09:37 Joubu           if the table is empty and the DB is rebooted, the AI is reset?
09:36 Joubu           AI is 42, add a patron, will be 42. AI is now 43. Delete it via the cli, AI is still 43
09:36 fridolin        this pb can exist for reserves and issues
09:36 fridolin        but for that the autogenrated must be reset, it happens only when table is empty and database is rebooted
09:36 Joubu           fridolin: how?
09:36 Joubu           As long as we have AI on borrowers.borrowernumber, we should not have twice the same is
09:35 fridolin        if a borrower is deleted there is a chance another new borrower gets the same id
09:35 Joubu           then what is wrong with having deletedborrowers.borrowernumber a primary key, not AI ?
09:34 Joubu           it can be a PK and not AI
09:34 fridolin        the pb is that borrowernumber is autogenrated
09:34 Joubu           fridolin: I do not understand your assertion
09:34 fridolin        yep in theory
09:34 Joubu           Could someone with a big and old DB execute: select count(*) as nb, borrowernumber from deletedborrowers  group by borrowernumber having nb > 1;
09:34 fridolin        Joubu: yes, deleted tables should not have a PK since they are composed of real data that use to have a PK
09:30 Joubu           fridolin: Do you think about a situation to have it?
09:29 Joubu           fridolin: would you know why deletedborrowers.borrowernumber is not a PK?
09:27 Joubu           hi bag!
09:26 bag             hi Joubu
09:09 Joubu           instead of checkout|renew|catalog search
09:09 Joubu           iirc
09:09 Joubu           cait: will be syspref|checkin|catalog search
09:07 eythian         http://devopsreactions.tumblr.com/post/151281670953/trying-the-first-prototype-good-enough
09:07 cait            i am pro syspref search, but we can't make it too crowded up there :)
09:06 cait            which tabs will show after patch is pushed
09:06 huginn          drojf: The operation succeeded.
09:06 drojf           @later tell rangi thanks!
09:04 Joubu           cait: what do you mean?
09:01 huginn          drojf: The current temperature in Berlin, Berlin, Germany is -3.4°C (9:59 AM CET on January 27, 2017). Conditions: Clear. Humidity: 95%. Dew Point: -4.0°C. Windchill: -3.0°C. Pressure: 30.27 in 1025 hPa (Steady).
09:01 drojf           @wunder berlin, germany
09:01 drojf           :'(
09:01 huginn          drojf: An error has occurred and has been logged. Please contact this bot's administrator for more information.
09:01 drojf           @wunder berlin, germany
08:59 cait            Joubu: can we quickly summarize what remains? just looking at the bug
08:31 marcelr         will have a look
08:29 Joubu           The question is: "Do you agree to remove the 'check in' and 'renew' tab from the header search of the administration module and replace them with a 'syspref search' tab which would be the default?"
08:28 Joubu           I'd like to get more opinions before passing QA on it
08:28 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17793 enhancement, P5 - low, ---, aleishaamohia, In Discussion , Make sysprefs search show on all Administration pages
08:28 Joubu           Could some of you answer on bug 17793 comment 16?
08:18 huginn          cait: The current temperature in MainaustraÃ&#376;e, Konstanz, Germany is -2.1°C (9:15 AM CET on January 27, 2017). Conditions: Clear. Humidity: 84%. Dew Point: -4.0°C. Windchill: -2.0°C. Pressure: 30.15 in 1021 hPa (Steady).
08:18 cait            @wunder Konstanz
08:18 cait            morning #koha :)
08:17 LibraryClaire   bonjour Joubu
08:17 Joubu           hi #koha
08:17 LibraryClaire   o/
08:17 fridolin        bag: LibraryClaire : and others : le Bonjour
08:17 LibraryClaire   hi gaetan_B
08:16 LibraryClaire   close... fridolin
08:16 LibraryClaire   hi fridonlin
08:15 bag             aloha gaetan_B
08:15 gaetan_B        hello
08:15 wahanui         fridolin is busy at the moment, I asked him to backport the bug fix
08:15 bag             heya fridolin
08:12 fridolin        hie ther
07:44 wahanui         hola, alex_a
07:44 alex_a          hello
07:41 marcelr         hi drojf
07:40 drojf           hi marcelr
07:40 LibraryClaire   salut reiveune
07:40 marcelr         hi reiveune and LibraryClaire
07:39 LibraryClaire   hey marcelr
07:39 wahanui         kia ora, reiveune
07:39 reiveune        hello
07:39 wahanui         eythian is Time's Person of the Year for 2006.
07:39 marcelr         eythian!
07:39 eythian         Morgen marcelr
07:38 marcelr         hi #koha
07:38 LibraryClaire   I bet the sun is up there
07:38 eythian         In Wellington, I lived above the fog some days.
07:37 * LibraryClaire wonders if it is possible to be higher than the fog
07:35 drojf           but it feels good
07:35 * drojf         can't see anything
07:34 drojf           oh, sun
07:34 LibraryClaire   they come and buy our cheap toilet paper :P
07:33 drojf           also, swiss people do hamsterkauf in konstanz every day. not sure if that is where to go
07:33 drojf           *we
07:33 drojf           no, actually just carry our groceries home in the mouth
07:32 * LibraryClaire moves across the border to Switzerland
07:32 drojf           d
07:32 drojf           we buy all the hamsters and then eat them when the shops are close
07:32 LibraryClaire   i've not heard that phrase before
07:31 magnuse         hamsterkauf - that's funny
07:30 drojf           it's a deep trauma caused by closed shops on sundays i guess
07:30 LibraryClaire   which is funny, cos they should be used to Sundays by now... so surely it's the same :P
07:29 drojf           yay hamsterkauf. like every day before a holiday in germany
07:29 eythian         We've had some serious fog here too lately
07:28 LibraryClaire   sometimes it gets cold enough for the south to have snow. Then all the infrastructure breaks and everyone buys all the bread
07:27 LibraryClaire   british winter is generally just days and days of grey, kind of cold and damp but not mega cold, and some rain
07:27 drojf           hah just wanted to say, it's kind of a british thing, right?
07:27 LibraryClaire   in the UK we just called it winter
07:27 drojf           you live in a foggy place
07:26 LibraryClaire   we haven't had sun for a few days now at least, just thie kind of fog
07:26 drojf           i used all sun yesterday, it's dead now
07:25 eythian         I should wear shorts
07:25 eythian         That'll be a change from -4
07:25 eythian         Huh, 7 today
07:25 * LibraryClaire sunbathes
07:24 eythian         We're supposed to get 10 next week!
07:24 LibraryClaire   I heard rumours we were gonna get plus temps :O
07:24 LibraryClaire   yeah, but hasn't been in the last week or two
07:24 huginn          eythian: The current temperature in Amsterdam, Netherlands is -4.0°C (7:55 AM CET on January 27, 2017). Conditions: Clear. Humidity: 86%. Dew Point: -6.0°C. Windchill: -8.0°C. Pressure: 29.98 in 1015 hPa (Falling).
07:24 eythian         @wunder ams
07:23 drojf           i thought that is the usual
07:23 magnuse         heh
07:23 LibraryClaire   hah, northern Germany is now colder than the south
07:23 drojf           global warming is a lie :P
07:23 magnuse         yeah. we had 8 yesterday
07:23 magnuse         it used to be boo
07:23 drojf           norwegian summer
07:23 bag             ah!!! magnuse knows
07:23 huginn          drojf: The current temperature in Berlin, Berlin, Germany is -4.6°C (8:22 AM CET on January 27, 2017). Conditions: Clear. Humidity: 96%. Dew Point: -5.0°C. Windchill: -5.0°C. Pressure: 30.27 in 1025 hPa (Steady).
07:22 drojf           @wunder berlin, germany
07:22 huginn          magnuse: The current temperature in Bodo, Norway is 5.0°C (7:50 AM CET on January 27, 2017). Conditions: Clear. Humidity: 81%. Dew Point: 2.0°C. Windchill: 1.0°C. Pressure: 29.92 in 1013 hPa (Steady).
07:22 drojf           hei magnuse
07:22 huginn          bag: Error: No such location could be found.
07:22 magnuse         @wunder enbo
07:22 bag             @wunder bod
07:22 bag             ahh I can’t remember the correct one
07:22 huginn          bag: Error: No such location could be found.
07:22 bag             @wunder bodo
07:22 huginn          bag: Error: No such location could be found.
07:22 bag             @wunder boo
07:21 magnuse         bag: knuckles!
07:21 magnuse         guten morgen BüchereiKlara
07:21 bag             magnuse: knuckles
07:21 LibraryClaire   hei magnuse
07:21 magnuse         bag: HI
07:21 * magnuse       waves
07:10 * LibraryClaire burns her mouth on tea
07:06 bag             aloha cait
07:06 * liw           sips the first cuppa
07:05 * LibraryClaire goes to find tea
07:04 LibraryClaire   then she drives off
07:04 huginn          bag: The current temperature in Portland, Oregon is 3.0°C (10:53 PM PST on January 26, 2017). Conditions: Clear. Humidity: 93%. Dew Point: 2.0°C. Pressure: 30.61 in 1036 hPa (Rising).  Winter Weather Advisory in effect until 1 PM PST Wednesday... 
07:04 bag             @wunder pdx
07:04 LibraryClaire   she is here between 7:55 and like five or ten past 8
07:03 bag             that sounds perfect
07:03 bag             hmm.. I need a breakfast person
07:03 huginn          LibraryClaire: The current temperature in MainaustraÃ&#376;e, Konstanz, Germany is -2.1°C (7:57 AM CET on January 27, 2017). Conditions: Clear. Humidity: 84%. Dew Point: -4.0°C. Windchill: -2.0°C. Pressure: 30.15 in 1021 hPa (Steady).
07:03 LibraryClaire   @wunder konstanz
07:02 LibraryClaire   I think
07:02 LibraryClaire   bag: err, Sunday after Easter 23rd ish of April
07:02 LibraryClaire   sorry went to grab breakfast from teh breakfast lady
07:01 huginn          liw: The current temperature in Helsinki, Finland is 0.0°C (8:50 AM EET on January 27, 2017). Conditions: Fog. Humidity: 100%. Dew Point: 0.0°C. Pressure: 30.12 in 1020 hPa (Steady).
07:01 liw             @wunder helsinki
06:57 bag             whens the race date again?
06:56 bag             excellent :)
06:55 LibraryClaire   hpefully will run at the weekend :)
06:55 LibraryClaire   alright thanks, hip seems to not be hurting much now
06:53 bag             how you doing?
06:53 LibraryClaire   aw :(
06:53 bag             hurting ;)
06:53 LibraryClaire   moin drojf
06:53 drojf           hi LibraryClaire
06:53 LibraryClaire   how's the foot?
06:53 LibraryClaire   hey bag
06:53 bag             hi there LibraryClaire
06:53 LibraryClaire   morning #koha
06:53 bag             sweet drojf
06:46 drojf           started backporting stuff for the unstable repo to see what else needs to go in debian first. i hope it's only one more package to submit
06:43 drojf           got the first package into debian for elasticsearch
06:43 drojf           good. lots of work but i hope i can work more on koha again
06:42 bag             how about you drojf ?  how’s things
06:42 bag             :D
06:42 drojf           cool
06:42 bag             good thoughts ;) fundraising for Koha thoughts
06:42 drojf           sounds awesome
06:41 bag             going well :)  I have so many thougts going through my mind - I am in writing things down mode
06:36 drojf           *are
06:36 drojf           how aree things?
06:35 drojf           hi bag
06:34 bag             hiya drojf
06:22 drojf           morning #koha
01:07 dcook           :P
01:06 * kidclamp_away hides the paint from dcook