Time Nick Message 01:06 * kidclamp_away hides the paint from dcook 01:07 dcook :P 06:22 drojf morning #koha 06:34 bag hiya drojf 06:35 drojf hi bag 06:36 drojf how aree things? 06:36 drojf *are 06:41 bag going well :) I have so many thougts going through my mind - I am in writing things down mode 06:42 drojf sounds awesome 06:42 bag good thoughts ;) fundraising for Koha thoughts 06:42 drojf cool 06:42 bag :D 06:42 bag how about you drojf ? how’s things 06:43 drojf good. lots of work but i hope i can work more on koha again 06:43 drojf got the first package into debian for elasticsearch 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:53 bag sweet drojf 06:53 LibraryClaire morning #koha 06:53 bag hi there LibraryClaire 06:53 LibraryClaire hey bag 06:53 LibraryClaire how's the foot? 06:53 drojf hi LibraryClaire 06:53 LibraryClaire moin drojf 06:53 bag hurting ;) 06:53 LibraryClaire aw :( 06:53 bag how you doing? 06:55 LibraryClaire alright thanks, hip seems to not be hurting much now 06:55 LibraryClaire hpefully will run at the weekend :) 06:56 bag excellent :) 06:57 bag whens the race date again? 07:01 liw @wunder helsinki 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:02 LibraryClaire sorry went to grab breakfast from teh breakfast lady 07:02 LibraryClaire bag: err, Sunday after Easter 23rd ish of April 07:02 LibraryClaire I think 07:03 LibraryClaire @wunder konstanz 07:03 huginn LibraryClaire: The current temperature in Mainaustraß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 bag hmm.. I need a breakfast person 07:03 bag that sounds perfect 07:04 LibraryClaire she is here between 7:55 and like five or ten past 8 07:04 bag @wunder pdx 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 LibraryClaire then she drives off 07:05 * LibraryClaire goes to find tea 07:06 * liw sips the first cuppa 07:06 bag aloha cait 07:10 * LibraryClaire burns her mouth on tea 07:21 * magnuse waves 07:21 magnuse bag: HI 07:21 LibraryClaire hei magnuse 07:21 bag magnuse: knuckles 07:21 magnuse guten morgen BüchereiKlara 07:21 magnuse bag: knuckles! 07:22 bag @wunder boo 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 ahh I can’t remember the correct one 07:22 bag @wunder bod 07:22 magnuse @wunder enbo 07:22 huginn bag: Error: No such location could be found. 07:22 drojf hei magnuse 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 @wunder berlin, germany 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:23 bag ah!!! magnuse knows 07:23 drojf norwegian summer 07:23 magnuse it used to be boo 07:23 magnuse yeah. we had 8 yesterday 07:23 drojf global warming is a lie :P 07:23 LibraryClaire hah, northern Germany is now colder than the south 07:23 magnuse heh 07:23 drojf i thought that is the usual 07:24 eythian @wunder ams 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 LibraryClaire yeah, but hasn't been in the last week or two 07:24 LibraryClaire I heard rumours we were gonna get plus temps :O 07:24 eythian We're supposed to get 10 next week! 07:25 * LibraryClaire sunbathes 07:25 eythian Huh, 7 today 07:25 eythian That'll be a change from -4 07:25 eythian I should wear shorts 07:26 drojf i used all sun yesterday, it's dead now 07:26 LibraryClaire we haven't had sun for a few days now at least, just thie kind of fog 07:27 drojf you live in a foggy place 07:27 LibraryClaire in the UK we just called it winter 07:27 drojf hah just wanted to say, it's kind of a british thing, right? 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: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:29 eythian We've had some serious fog here too lately 07:29 drojf yay hamsterkauf. like every day before a holiday in germany 07:30 LibraryClaire which is funny, cos they should be used to Sundays by now... so surely it's the same :P 07:30 drojf it's a deep trauma caused by closed shops on sundays i guess 07:31 magnuse hamsterkauf - that's funny 07:32 LibraryClaire i've not heard that phrase before 07:32 drojf we buy all the hamsters and then eat them when the shops are close 07:32 drojf d 07:32 * LibraryClaire moves across the border to Switzerland 07:33 drojf no, actually just carry our groceries home in the mouth 07:33 drojf *we 07:33 drojf also, swiss people do hamsterkauf in konstanz every day. not sure if that is where to go 07:34 LibraryClaire they come and buy our cheap toilet paper :P 07:34 drojf oh, sun 07:35 * drojf can't see anything 07:35 drojf but it feels good 07:37 * LibraryClaire wonders if it is possible to be higher than the fog 07:38 eythian In Wellington, I lived above the fog some days. 07:38 LibraryClaire I bet the sun is up there 07:38 marcelr hi #koha 07:39 eythian Morgen marcelr 07:39 marcelr eythian! 07:39 wahanui eythian is Time's Person of the Year for 2006. 07:39 reiveune hello 07:39 wahanui kia ora, reiveune 07:39 LibraryClaire hey marcelr 07:40 marcelr hi reiveune and LibraryClaire 07:40 LibraryClaire salut reiveune 07:40 drojf hi marcelr 07:41 marcelr hi drojf 07:44 alex_a hello 07:44 wahanui hola, alex_a 08:12 fridolin hie ther 08:15 bag heya fridolin 08:15 wahanui fridolin is busy at the moment, I asked him to backport the bug fix 08:15 gaetan_B hello 08:15 bag aloha gaetan_B 08:16 LibraryClaire hi fridonlin 08:16 LibraryClaire close... fridolin 08:17 LibraryClaire hi gaetan_B 08:17 fridolin bag: LibraryClaire : and others : le Bonjour 08:17 LibraryClaire o/ 08:17 Joubu hi #koha 08:17 LibraryClaire bonjour Joubu 08:18 cait morning #koha :) 08:18 cait @wunder Konstanz 08:18 huginn cait: The current temperature in Mainaustraß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:28 Joubu Could some of you answer on bug 17793 comment 16? 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 I'd like to get more opinions before passing QA on it 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:31 marcelr will have a look 08:59 cait Joubu: can we quickly summarize what remains? just looking at the bug 09:01 drojf @wunder berlin, germany 09:01 huginn drojf: An error has occurred and has been logged. Please contact this bot's administrator for more information. 09:01 drojf :'( 09:01 drojf @wunder berlin, germany 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:04 Joubu cait: what do you mean? 09:06 drojf @later tell rangi thanks! 09:06 huginn drojf: The operation succeeded. 09:06 cait which tabs will show after patch is pushed 09:07 cait i am pro syspref search, but we can't make it too crowded up there :) 09:07 eythian http://devopsreactions.tumblr.com/post/151281670953/trying-the-first-prototype-good-enough 09:09 Joubu cait: will be syspref|checkin|catalog search 09:09 Joubu iirc 09:09 Joubu instead of checkout|renew|catalog search 09:26 bag hi Joubu 09:27 Joubu hi bag! 09:29 Joubu fridolin: would you know why deletedborrowers.borrowernumber is not a PK? 09:30 Joubu fridolin: Do you think about a situation to have it? 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: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 yep in theory 09:34 Joubu fridolin: I do not understand your assertion 09:34 fridolin the pb is that borrowernumber is autogenrated 09:34 Joubu it can be a PK and not AI 09:35 Joubu then what is wrong with having deletedborrowers.borrowernumber a primary key, not AI ? 09:35 fridolin if a borrower is deleted there is a chance another new borrower gets the same id 09:36 Joubu As long as we have AI on borrowers.borrowernumber, we should not have twice the same is 09:36 Joubu fridolin: how? 09:36 fridolin but for that the autogenrated must be reset, it happens only when table is empty and database is rebooted 09:36 fridolin this pb can exist for reserves and issues 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:37 Joubu if the table is empty and the DB is rebooted, the AI is reset? 09:37 fridolin it will rare to empty borrowers table but the case exists 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:38 fridolin i remember it is not the case in Oracle ... 09:38 fridolin in the end, deletedborrowers is only for statistics, a simple index on borrowernumber should be enought 09:39 fridolin and regular delete of old entries 09:39 Joubu fridolin: we need a PK for DBIC 09:39 fridolin Joubu: ahhh always 09:39 fridolin then create a new column I-d say : deletedborrowernumber PK AI 09:40 fridolin how are old_issues and old_reserves ? 09:40 Joubu yes but I would make sure it's needed first 09:40 Joubu no PK atm 09:43 Joubu indeed the AI is reset if the table is empty and the dbms is restart 09:43 Joubu I guess it's a... feature 09:44 cait Joubu: checkin makes no sense for me 09:44 cait Joubu: i think better have patron and checkout or so 09:46 fridolin Joubu: i'm not a DB expert, i just know the AI reset issue can be very hard to detect 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 the SQL just failes on existing PK 09:46 Joubu that's a weird case 09:46 fridolin indeed 09:47 cait reading back - what happens when you delete the last borrower added and then restart? 09:47 cait will it reset the AI then too? 09:48 fridolin Joubu: yes but if you must do something for old_issues/reservers, do the same for deleted* no ? 09:48 fridolin KISS 09:48 fridolin #KISS 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 before 4 reboot the server 09:48 Joubu well not boom yet, but when you will delete your first patron 09:48 fridolin i think you must empty RAM 09:49 fridolin yep 5. delete the new patron 09:49 fridolin if the borrowernumber is the same boom 09:49 Joubu so yes, that sucks 09:49 fridolin the new PK will seem useless but there are a lot, just there to id the line 09:50 fridolin the row i mean 09:50 fridolin maybe having deleted data tables is not a good idea in SQL 09:51 fridolin relationnal DB 09:52 Joubu yes I know... 09:52 Joubu opened this discussion one year ago, nobody cared about 09:53 Joubu cait: it's checkout indeed, not checkin! 09:54 Joubu so with the patch: "syspref | checkout | 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 without the patch (master): checkout|checkin|renew|search cat 09:55 Joubu ashimema: how does dbic handle that? 09:55 Joubu if you call ->find on the pk? :) 09:56 ashimema you just tell it in the resultclass what field your treating as the primary key 09:56 ashimema in a meeting right now 09:56 Joubu https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=59583 09:56 ashimema will reply proper in a few minutes 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 Joubu ok thanks! 10:07 cait Joubu: ok with me then :) 10:07 cait @later tell khall ping me when you are around? 10:07 huginn cait: The operation succeeded. 10:13 ashimema 10 minutes to the next call 10:13 ashimema busy day for calls :( 10:13 ashimema so yeah.. khall has suggested what I was suggesting 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:22 Joubu ashimema: just try kyle's patch: 10:22 Joubu tried* 10:22 Joubu if there is only 1 matching row, the find works 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 and the last matching row is picked 10:22 Joubu nope, the first matching row! 10:25 cait in theory... that shouldn't happen 10:25 cait could we only set the column to unique? 10:25 cait without primary? 10:25 cait so have it unique and then the PK definition in the DBIX config? 10:26 ashimema so yeah.. the issue is why wuold you ever need/want duplicate borrowernumbers? 10:26 ashimema in the deleted_borrowers table 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 Joubu I do not want or need, but it can happen 10:27 ashimema how can it happen 10:27 * ashimema thinks he may have seen it.. but can't understand where it came from 10:27 cait no 10:27 cait ashimema: cardnumbers - yes, but not borrowernumbers 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:28 ashimema primary key should be borrowernumber :) 10:28 ashimema i can totally understand re0using cardnumbers 10:28 Joubu yes, it is 10:28 ashimema erm 10:28 ashimema after a server reboot 10:28 ashimema is mysql that bad 10:28 Joubu borrowernumber is the PK, but the fact that it is automatically set by AI will cause this problem 10:29 ashimema I thought it was an auto_increment primary key 10:29 ashimema AI? 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 Joubu if mysql is restart and the table is empty, AI is reset 10:29 Joubu auto increment 10:29 Joubu forget AI 10:29 wahanui Joubu: I forgot ai 10:29 Joubu AI is Auto Increment 10:29 ashimema oh god.. AI is horrible in mysql 10:30 ashimema that wouldn't happen in postgres 10:30 ashimema it's ai is 'safe' 10:30 ashimema you have to work really hard in postgres to get such a cock up 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:31 Joubu but that is awful 10:32 ashimema yeah.. that's not nice at all 10:33 ashimema ack.. i can't think of a nice way around this then :( 10:34 ashimema I wonder if ribasushi has ever come up against this sort of issue? 10:34 ashimema we 'could' use guid's 10:35 ashimema but that sorta feels really nasty too 10:39 tcohen morning 10:40 tcohen @wunder anisacate, argentina 10:40 huginn tcohen: Error: HTTP Error 404: Not Found 10:40 drojf hi tcohen and ashimema 10:40 magnuse ¡hola tcohen! 10:40 magnuse @wunder enbo 10:40 tcohen hola magnuse drojf and ashimema 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 magnuse \o/ 10:40 * ashimema is in his next call 10:41 tcohen ashimema: YAY 10:41 drojf yay calls. i did that yesterday, like half the day 10:41 tcohen @wunder ARXX1831 10:41 huginn tcohen: Error: HTTP Error 404: Not Found 10:41 tcohen ok 10:41 tcohen @wunder cordoba, argentina 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 drojf heh huginn is not happy today 10:43 Joubu ashimema, and for the record: bug 18003 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:46 Joubu alex_a_: you could have found a more exiting bug for 18000! 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:47 ashimema but it's a fairly drastic change 10:48 ashimema I'm not fully in the loop on why we're worrying about it all right now ;) 10:48 Joubu ashimema: I have brought this discussion last year, it did not interest lot of people 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:52 alex_a_ Joubu: we make great a thing by doing many small ones 10:52 alex_a_ -a 10:53 marcelr bug 18000 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 aiming for bug 20000 10:53 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20000 could not be retrieved: InvalidBugId 10:55 marcelr who is signing off this trivial one: bug 17982 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 tcohen alex_a_: hehe 10:55 tcohen Joubu, regarding 13757 10:55 tcohen my work was to resurrect that work 10:55 tcohen the plan to refactor some controller scripts and templates was left for later on purpose 10:56 marcelr @later tell kidclamp: please try bug 17980 for me 10:56 huginn marcelr: The operation succeeded. 10:56 Joubu tcohen: yep, seen your answer :) 10:56 Joubu tcohen: is it on your todolist? :D 10:57 tcohen of course 10:57 tcohen I started with CheckUniqueness 10:58 alex_a_ Joubu: What is fixed in new version of DBIx::Class::Schema::Loader ? 10:58 alex_a_ Never said that there was a bug in DBIx::Class::Schema::Loader 11:00 Joubu alex_a_: it will not modify the timestamp and so the md5sum unless modified 11:00 Joubu so you won't see all the schema files on git status 11:08 Joubu tcohen: found a bug, must be trivial to fix 11:08 tcohen Joubu: tell me 11:09 Joubu tcohen: I let a comment 11:09 tcohen Joubu: thanks! 11:10 tcohen most issues are related to how tied is the data model to the page structure 11:10 tcohen that's why this deserves to be rewritten on top of the REST api IMHO 11:37 Joubu khall: Hi! Can I get your opinion on bug 15545 please? See last comment 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 khall sure! 12:39 tcohen oleonard++ 12:39 * tcohen1 loves to see more people contributing to make kohadevbox better 12:47 tcohen hi oleonard, thanks for taking care of README.md 12:48 oleonard Sure, thanks for the instructions on filing an issue. 12:48 tcohen ha 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 and have a more koha-ish qa workflow 12:49 * tcohen loves superpowers, though 12:49 oleonard :D 12:49 oleonard Oh cool, updated VirtualBox Guest Additions getting installed automatically 12:50 * cait loves kohadevbox :) 12:51 tcohen finally! 12:52 cait :P 12:54 * oleonard brb 12:54 oleonard quit 13:14 marcelr khall: not sure if i understand your comments on bug 15545 about odd behavior 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: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:16 marcelr yes, so a good reason for a plugin, yes? 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:18 marcelr ok thx 13:19 cait plugin popularity - dokuwiki does that 13:23 cait it's helpful when seleting a new plugin you want to use 13:23 magnuse plugins++ 13:24 mtompset @seen tcohen 13:24 huginn mtompset: tcohen was last seen in #koha 33 minutes and 2 seconds ago: <tcohen> finally! 13:24 mtompset Greetings, #koha. 13:30 edveal Hello 13:30 wahanui salut, edveal 13:32 tcohen hi mtompset 13:33 mtompset I'm just looking at your comment on the kohadevbox issue, tcohen 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:34 mtompset ^perfer^prefer^ 13:37 edveal Happy Friday! 13:38 magnuse \o/ 13:39 * LibraryClaire does a Friday dance 13:40 tcohen mtompset: for ES 2.x+ we are pulling the Oracle Java runtime 13:40 * mtompset frowns. 13:40 mtompset Sorry, different context. 13:40 mtompset I can't sudo apt-get upgrade my kohadevbox. 13:41 mtompset it keeps barfing on koha-common 14:14 pastebot "mtompset" at 127.0.0.1 pasted "Current 'vagrant up xenial' failure" (2 lines) at http://paste.koha-community.org/284 14:15 tcohen mtompset: i got the same 14:15 tcohen vagrant xenial provision 14:15 tcohen should make it continue 14:17 mtompset Hmm... it had a skipping on that step this time. I'll have to check when it is finished. 14:28 mtompset Hmmm.. same problem for Jessie. 14:29 mtompset When is the last time someone actually tried koha-create on a normal git clone? 14:29 tcohen something changed in the return value for koha-create 14:29 mtompset Yep. About to try to track that down. 14:44 Joubu Is the pagination of the search result broken on the staff interface? 14:44 Joubu master 14:45 cait can't test right now 14:45 Joubu ha that may be caused by bootstrap3 14:45 Joubu I get 1 page per line, it's ugly 14:45 cait lucky we pushed early 14:46 LibraryClaire Joubu me too 14:47 Joubu ok confirmed it's bootstrap 14:48 Joubu josef_moravec: any chances you could take a lookt? 14:48 Joubu bug 18005 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:54 drojf is it possible to get item info in OAI? 14:54 tcohen yes 14:55 tcohen in extended mode 14:55 tcohen https://perldoc.koha-community.org/opac/oai.html 14:55 tcohen it is not properly documented 14:56 drojf i found bug 12252 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 thanks, will have a look 14:58 tcohen include_items: 1 14:58 tcohen we should definitely ship a sample extended configuration file 14:59 Joubu Is bug 17978 a bug? 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 placerequest is added reserve without checking if the patron can still place a hold 14:59 Joubu So if you are placing several holds in once row, there is no check... 15:00 Joubu well, there is 1 check. So if the patron can place 1 hold, he is able to place X holds 15:00 Joubu I guess it's a long standing bug 15:01 mtompset tcohen: I think it is the koha-start-zebra that is the broken this, not the create. 15:01 mtompset I vaguely recall worrying about that return 0 || return 1 mess. 15:02 eythian what is that? 15:02 eythian no one should ever write return 0 || return 1 I'm sure 15:02 tcohen mtompset: did you sign my patches removing koha-start-zebra already=? 15:03 mtompset don't recall anything. :) 15:03 mtompset just looking at the debian scripts file. 15:04 mtompset eythian: koha-start-zebra 15:04 pastebot "mtompset" at 127.0.0.1 pasted "yuckiness" (15 lines) at http://paste.koha-community.org/285 15:05 eythian ah 15:05 eythian that's legit 15:05 eythian it's not nice, but it's legit 15:05 drojf beer o'clock 15:05 wahanui rumour has it beer o'clock is a vital part of the Koha development process 15:06 tcohen mtompset: bug 17467 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: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 mtompset ? 15:12 eythian yeah, it's left-associative. So if the daemon call is successful, it returns 0, else returns 1. 15:12 eythian I'd probably put it in an if for clarity myself. 15:14 mtompset Why if? Why not return $?; 15:17 tcohen mtompset: you provided a followup for 17467, do u plan to sign it? 15:18 eythian if you could return $?, then you wouldn't need the && || stuff anyway, you'd just return the value from daemon. 15:19 eythian you could put an if catching $?, that's probably not terrible. 15:19 eythian I'd just move everything to systemd units myself :) 15:23 mtompset tcohen: probably not? my kohadevboxes are down.. it will take 3 hours to get them back. 15:24 cait looking at indicators for http://www.loc.gov/marc/bibliographic/bd246.html 15:24 cait how do you interpret 3? 15:24 cait 'no note, added entry'? 15:24 cait "Whether a note and/or an added entry is generated from the field." not sure what that means really 15:36 tcohen1 cait: that's left to the readers interpretation 15:40 drojf MARCfight! 15:40 * drojf throws MARC at cait 15:42 drojf have a nice weekend #koha 15:45 cait tcohen: afraid so 15:45 tcohen you are the reader this time, sorry 16:04 reiveune bye 16:05 * ashimema sits back to watch the MARC fight progress 16:06 * ashimema wonders if there's popcorn available ;) 16:14 mtompset Hmm... what is the difference between 2 and 3, cait? 16:15 cait no idea 16:15 tcohen mtompset: 1 16:15 mtompset Okay, re-reading it again... tcohen this is the MARC mess. 16:16 mtompset It seems to me that 0 and 2 must always have a second indicator of #. 16:16 tcohen 3 - 2 = 1 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:17 cait like a $i? 16:17 cait where are you getting this from? 16:18 mtompset I'm just reading the link you gave. 16:19 mtompset I'm not a librarian, so I don't know. 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 cait but that's 0 and 1 16:20 cait and there is an example of 3 with the second indicator set 16:20 mtompset Oh, 245 isn't repeatable. 16:21 mtompset I would treat 246 like 245's if they could repeat. :) 16:21 mtompset But remember, I'm not a librarian, so I know squat in MARC. :) 16:21 tcohen can we invoke jcamins? 16:22 mtompset Oooo.... jcamins the demi-god of cataloguing. 16:24 tcohen need to spell his name three times I think 16:26 * druthb invokes the jcamins 16:26 * oleonard sets out a plate of freshly-baked cookies to lure jcamins 16:27 tcohen jcamins 16:28 tcohen jcamins 16:28 tcohen jcamins 16:30 mtompset I even posted on FB. :P 16:31 * tcohen is parsing the telephatic answer from Jared 16:31 * mtompset grins. 16:31 tcohen "The title entered is searchable but will not be shown. 16:31 tcohen For example: 16:31 tcohen 245 10 $a Apples & bears 16:31 tcohen 246 33 $a Apples and bears 16:31 tcohen That is a made up example, of course. 16:31 tcohen " 16:31 tcohen cait ^^^ that's for you 16:34 cait ah 16:34 cait is that in the docs somewhere that it should not be shown? 16:34 cait I'd file a bug then 16:38 tcohen that's Jared's understanding 16:38 cait ok 16:38 cait that suits me fine actually :) 16:39 cait is that for indicators 3 and 5? 16:39 cait 3 and 4? 16:39 wahanui 7 16:39 cait or only for 3? 16:40 cait hm think only 3 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:42 cait oh 16:42 cait bug 18000 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 not very spectacular :) 16:43 cait but nice anyway 16:43 wahanui nice is perhaps not as enthusiastic of a word as I meant 16:43 cait bug 18006 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:44 oleonard On to 19000 16:44 barton is there a way of specifying the database to connect to in yaz-client when we're using sockets? 16:45 barton I tried yaz-client unix:/var/run/koha/switch/bibliosocket /biblios, but that caused unhappiness. 16:46 barton I figured if I left an empty port, the colon would act as a delimiter: 16:46 barton yaz-client unix:/var/run/koha/switch/bibliosocket:/biblios didn't work either. 17:03 kidclamp @wunder 05001 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:05 oleonard Hi kidclamp 17:06 kidclamp hi oleonard 17:06 wahanui hi olé onard 17:18 * mtompset curses apparmour and mysql not playing nice. 19:28 oleonard Oh hey look Bug 17942 still needs a signoff. 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:55 mtompset oleonard: I get a conflict 19:55 oleonard Dang. 19:56 mtompset oops... 19:56 mtompset typo 19:56 mtompset That's why. 19:56 mtompset Sorry for the heart attack. ;) 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 20:14 huginn eythian: The operation succeeded. 20:17 eythian bag: a correction about your Let's Encrypt press release: you're hopefully using TLS and not SSL. 20:17 bag :) 20:18 bag I wasn’t sure all the readers understood TLS so I went simple 20:18 bag that was probably my mistake 20:19 eythian But wrong to us pedants! Boo! Hiss! ;) 20:22 mtompset Okay, eythian edumacate me. TLS != SSL, explain the diff. 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:25 eythian (I want to say SNI is one of those, but I'm not sure.) 20:25 mtompset And potential legal issues with Netscape having SSL trademark or something? 20:26 eythian Not at all to my knowledge. 20:26 eythian But my knowledge isn't great on this. 20:26 eythian I should learn about it. 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:29 mtompset eythian: You got a Xenial Kohadev box? :) 20:29 eythian I have no koha dev box at the moment 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: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 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:31 mtompset splitting, as in putting the DB on a different machine? 20:31 eythian Putting everything that can be separated on a different machine. 20:31 eythian My cluster is built of tiny machines 20:31 mtompset ooo... in that case, do I have a bug for you! 20:31 mtompset bug 16690 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:33 eythian Hmm, that looks like a problem. That'll hit many people. 20:34 mtompset And yet, no one has signed off for months. :( 20:34 eythian Well, I'll look at it if I get my system properly designed and built any time soon :) 20:37 bag yeah we do that eythian 20:37 mtompset That would make me happy. :) 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:38 bag can’t wait for ES - then clustering will be loads of fun ;) 20:40 mtompset Have a great day, #koha bag eythian 20:40 eythian bag: catalyst too (unless things have changed, but I doubt it.) 20:41 eythian Yeah, the namespacing of instances needs to be moved more into koha itself to solve that. 20:41 eythian Not impossible. 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:43 eythian It's a crazy world at huge scale. 21:34 sdlib how long does it take a quick slip update to take effect? 21:36 sdlib tried to edit 'issue quick slip' (print) and it did nothing, that was 2 hours ago 21:40 bag you probably have to restart memcached 21:40 sdlib ?? 21:41 bag sdlib: is this san diego law library? 21:41 sdlib no 21:41 sdlib south dakota 21:42 bag ah SD cool - welcome 21:42 sdlib what is memchached, where is it, how do i restart it? 21:42 bag from the commandline on your server 21:43 sdlib hmm.... i am not sure i have access to that 21:44 sdlib our library's server? 21:44 bag yes where is koha hosted for you? 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:45 bag yes :) 21:45 sdlib i *think* we go through people called bywater solutions but idk if they do the actual hosting or not 21:46 bag cool yeah that’s us 21:46 sdlib i will find out. thanks! 21:46 kidclamp have a great weekend #koha 21:46 bag which library are you at now sdlib 21:46 bag I can get someone on that right away for you if you’re with bywater sdlib 21:47 sdlib Grace Balloch 21:48 bag perfect - yes you’re with us 21:48 bag we’ll get someone on that for you 21:48 sdlib thanks! 21:48 bag give me about 10 minutes and you should now see your changes 21:50 bag sdlib: restarted 21:51 sdlib ok i'll give it a few and see if i get the changes 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 22:06 sdlib still no change 22:36 eythian @later tell LibraryClaire https://www.mcsweeneys.net/articles/concepts-for-which-i-suspect-the-germans-have-a-single-word 22:36 huginn eythian: The operation succeeded. 22:50 * eythian wishes to remind you that the CPAN testing system is called CPANTS 22:50 eythian Because it's funny