Time Nick Message 00:43 mtompset @seen rangi 00:43 huginn mtompset: rangi was last seen in #koha 6 days, 3 hours, 20 minutes, and 25 seconds ago: <rangi> back, that took a lot longer than expected 00:44 mtompset @seen aleisha 00:44 huginn mtompset: aleisha was last seen in #koha 2 weeks, 1 day, 1 hour, 22 minutes, and 22 seconds ago: <aleisha> thanks cait 00:45 mtompset @seen josef_moravec 00:45 huginn mtompset: josef_moravec was last seen in #koha 11 hours, 38 minutes, and 26 seconds ago: <josef_moravec> by #koha 01:00 mtompset Well, I guess 4 commits from 27 is squashed enough. :) 01:04 wizzyrea mtompset: nz holiday season ^.^ 01:05 mtompset I saw the times, and figured as much. 01:06 mtompset wizzyrea: So how did/are you spend/ing the holidays? 01:07 wizzyrea in the sun, with my fam (kid, dog, hubs) eating ham and taking naps :) 01:13 mtompset As compared to my freezing cold winter wonderland and feasting on diet approved food. :) 01:14 mtompset But lots of family and more sleep for sure. :) 01:24 wizzyrea summer xmas is where it's at ;) 01:47 mtompset The holidays are where the family is. So, I'll take it regardless of seasonal weather. As long as I have my wife and son around. :) 01:48 mtompset Please Filipinos rock Christmas starting as early as September 1. :) 01:55 wizzyrea keke 03:37 mtompset Happy New Year, wizzyrea_ aleisha :) 03:38 mtompset Have a good day (24 hour period) and a happy new year, #koha wizzyrea_ aleisha :) 06:56 magnuse ~~~ 07:40 reiveune hello 07:40 wahanui salut, reiveune 07:51 fridolin hi ther 08:08 josef_moravec hello #koha 08:09 gaetan_B hello 08:17 matts hello #koha, happy new year :) 09:33 cait hi all 09:34 josef_moravec hi cait 09:36 cait hi josef_moravec 09:36 cait taking a look at the patron form 09:36 cait the email validation seems to be broken and passwords are suddenly mandatory 09:36 cait even if not marked as such :( 09:37 cait was checking the report from the mailing list 09:37 cait i don't think any of that was intentional? 09:44 josef_moravec added by bug 18298 09:44 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18298 new feature, P5 - low, ---, jonathan.druart, Pushed to Master , Allow enforcing password complexity 09:48 josef_moravec looks like in opac it checks if mandatory, but in staff it is always required... 09:48 cait i am filing bugs 09:49 cait bug 19907 09:49 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, koha-bugs, NEW , Email validation on patron add/edit not working 09:49 cait bug 19908 09:49 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, koha-bugs, NEW , Password should not be mandatory 09:51 cait not sure what happened to the email validation - it appears ok in administration and there is no javascript error on the page 09:51 cait btw josef_moravec++ thx for being such a qa master :) 09:53 josef_moravec cait: I am not master, I am still learning ;) 09:53 josef_moravec cait: there are some really hard patches in NQA queue, need to learn hard :D 09:55 cait yeah true 09:56 cait but you are ahead of me :) 09:56 cait i spent yesterday fixing my kohadevbox, will hopefully get a bit further today :) 09:56 josef_moravec sometimes could be tricky, I know ;) 11:01 saa we have some records which we need to update in koha with status written can we know in excel file which tags we need to add to get this status correctly updated when we do marc import which tags are essential while creating mrc file 11:01 saa written off 11:02 josef_moravec Hi saa 11:02 saa we wish to add status as written off for all the titles in excel 11:02 josef_moravec It depends on you mappings 11:03 josef_moravec by default it is 952$0 11:03 saa i just need to knw which tags can be used so that all these titles will have status as written off after data import 11:03 josef_moravec see here the default item field mappings https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) 11:03 saa i used this but after import no item is added only record is added 11:04 saa 952$7 is also required or not 11:04 josef_moravec and do you have defined right library codes? 11:04 josef_moravec do you use default biblio framework they come with koha? 11:05 saa yes 11:06 josef_moravec for anybody interested in testing ;) bug 19908 11:06 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, josef.moravec, Needs Signoff , Password should not be mandatory 11:11 josef_moravec saa: you can look at the marc record on manage staged records page for ensure they looks OK 11:11 josef_moravec What about the library codes? Do you have same codes in homebranch field of imported data and in koha? 11:14 saa yes 11:14 saa they are same 11:15 saa here is are the tags i mapped 3, 040$c, 952$a, 952$b 245$a 942$c, 952$y 952$0 952$p 952$C 952$z 11:18 josef_moravec what is 952$C ? shouldn't it be small "c"? 11:18 saa yes it is small 11:18 josef_moravec ok 11:19 saa why is it nt updating items but only showing records 11:19 saa i cleaned earlier batch which was imported 11:19 saa do i need to do anything from terminal reindex clean batch 11:22 josef_moravec no, items in catalogue should be visible - and if it all works as expected, the records ar indexed in zebra during import 11:24 josef_moravec bug 19907 11:24 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, josef.moravec, Needs Signoff , Email validation on patron add/edit not working 12:23 tcohen hi 12:23 wahanui bidet, tcohen 12:24 tcohen @wunder cordoba, argentina 12:24 huginn tcohen: Error: No such location could be found. 12:48 oleonard Hi all 13:01 magnuse kia ora oleonard 13:02 oleonard Hi magnuse. I submitted a patch updating the NORMARC editor plugins. I hope I didn't mess it up. 13:40 oleonard Joubu around? 13:40 Joubu hi oleonard 13:40 wahanui hi dear loon 13:40 oleonard Hi, about your comment on Bug 19560 -- changing the GET to POST for the delete action 13:40 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19560 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Unable to delete library when branchcode contains special characters 13:41 oleonard It was not strictly necessary to fix the bug, obviously, so I can rework it. I was taught that as a general rule "destructive" actions should use POST 13:43 Joubu oleonard: I have no idea why I wrote that actually 13:44 Joubu https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=70162 13:44 Joubu it was because of this ^ 13:45 Joubu oleonard: I think you can forget this comment for now :) 13:49 magnuse kia ora nengard 13:49 nengard happy new year magnuse 13:50 magnuse oleonard: kewl! but our national library says normarc will be put to death this year, so please don't waste too much time on it :-) 13:50 magnuse straight back atcha nengard! 13:51 oleonard magnuse: One MARC format down, how many to go? 13:51 magnuse oleonard: see also bug 18984 13:51 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18984 enhancement, P5 - low, ---, magnus, NEW , Remove support for NORMARC 13:51 magnuse too many! 13:52 oleonard @wunder 45701 13:52 huginn oleonard: Error: No such location could be found. 13:52 oleonard I miss huginn's weather reports!! 13:53 oleonard I want to know in an instant how much colder it is here than it is where magnuse is! 13:54 magnuse oleonard: https://www.yr.no/place/Norway/Nordland/Bod%C3%B8/Joveien/ 13:54 fridolin magnuse: whouuu big change, maybe UNIMARC will fall some day ;) 13:54 * cait waves 13:54 cait back - wet and all... now the sun is shining. of course. 13:54 oleonard magnuse: https://www.wunderground.com/weather/us/oh/nelsonville/39.4594032%2C-82.23115349999999 13:56 fridolin 17°C here 13:56 fridolin B) 13:57 kidclamp -19°C here 13:57 kidclamp almost the opposite 13:58 magnuse kidclamp: that is cooold! 13:58 magnuse (especially if there is wind and humidity too) 13:59 kidclamp but a high of -4, so have that to look forward to 14:00 cait we got a loooot of wind, not super cold tho 14:02 magnuse cait: as in roofs blowing off houses and such? 14:02 cait almost 14:08 * LeeJ waves 14:08 LeeJ hi #koha 14:46 cait hey all, can we get sign offs for bug 19906 and bug 19907 please? 14:46 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19906 enhancement, P5 - low, ---, oleonard, Needs Signoff , Move template JavaScript to the footer: NORMARC editor plugins 14:46 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, josef.moravec, Needs Signoff , Email validation on patron add/edit not working 14:46 cait hm 14:46 cait the first was wrong 14:46 cait 19908 14:47 cait bug 19908 14:47 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, josef.moravec, Needs Signoff , Password should not be mandatory 14:47 cait broken behaviour when adding patrons on stable branches... 15:31 Joubu David Gustafsson, around? 15:36 reiveune bye 17:08 josef_moravec bye #koha 17:58 tcohen gnucifer 17:58 tcohen ? 18:31 greenjimll cait: as bug 19908 seems to have a problem with second entry of the password, should testing of bug 19907 wait (as it depends on 19908)? 18:31 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19908 critical, P5 - low, ---, josef.moravec, Failed QA , Password should not be mandatory 18:31 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19907 normal, P5 - low, ---, josef.moravec, Needs Signoff , Email validation on patron add/edit not working 18:36 Joubu greenjimll: yes 18:37 greenjimll OK, I'll stop playing with it. :-) 18:52 bag hiya all 18:53 sen hiya bag 18:53 LeeJ hi bag 18:54 bag heya! 18:54 LeeJ bag: happy new year 18:54 bag happy new year! Or in german - Gutes Neues Jahr! 18:54 * bag just learned that from cait 18:56 LeeJ #funfactoftheday 18:57 cait hehe :) 19:04 magnuse bag: HI 19:04 wahanui bonjour, magnuse 19:05 bag magnuse: knuckles!!! 19:05 magnuse yeah! 19:23 mtompset Greetings, #koha. 19:24 bag hi mtompset 19:24 mtompset Anyone recall a bugzilla patch related to "DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails at /usr/share/perl5/DBIx/RunSQL.pm line 273." on a web install after dumping the kohadevbox db? 19:29 mtompset Attempting a reset_all 19:31 mtompset nevermind... found a bug in a my rebase.... I think that might be it. 19:43 LeeJ hi mtompset 19:48 mtompset Greetings, LeeJ 19:48 mtompset Happy New Year, if I haven't wished it to you already. :) 20:02 pastebot "mtompset" at 127.0.0.1 pasted "tcohen: Is this installed by default on the kohadevbox?" (1 line) at http://paste.koha-community.org/122 20:07 LeeJ mtompset: no..whenever I spin up a fresh devbox I always have to install it 20:08 mtompset Sounds like an issue for the kohadevbox 20:08 cait it's not usually installed 20:08 cait might be more 'realistic'? 20:09 Joubu version of this module has been upgraded recently 20:09 Joubu WebService::ILS::OverDrive I mean 20:09 LeeJ cait: well out of a fresh spin up, the full tests fail on Patrons/OverDrive 20:09 Joubu LeeJ: cpanm WebService::ILS::OverDrive 20:10 LeeJ Joubu: I know :) just something I noticed in fresh boxes 20:10 LeeJ Joubu: happy new year btw 20:11 mtompset I take a longer route: cpan2deb WebService::ILS::OverDrive and then sudo dpkg -i libwebservice-ils-perl_0.17-1_all.deb 20:12 Joubu yes definitely better 20:12 mtompset Yes, Bonne Année! 20:13 mtompset I like the fact that if it ever hits default repos, then it will upgrade without my intervention. :) 20:17 rangi hmm i dont think i like release, i think i like released 20:17 rangi ahh i see Joubu has already covered that 20:18 cait ah, did I get it wrong? 20:18 rangi released makes sense 20:18 rangi Announcing the Koha 16.11.15 release 20:18 rangi would too 20:18 cait still says release here? https://koha-community.org/ 20:18 rangi mine will say released 20:18 cait the emails said released 20:18 rangi yeah 20:19 rangi released is more grammatically correct 20:19 cait ok, i will change the wiki 20:19 rangi thanks 20:19 cait Joubu: ^ 20:20 Joubu rangi: The email subjects say "Koha XXX released", but the url and blog post title say "release" 20:21 rangi yep, we should standardise on released 20:21 Joubu we could change, but will need to redirect 20:21 rangi leave it for now 20:21 rangi just in future 20:21 Joubu k 20:23 rangi LeeJ: are you about? 20:23 LeeJ rangi: mhm 20:24 rangi what's your gitlab username? 20:24 LeeJ uhh..one sec 20:25 LeeJ rangi: looks to be ldjamison 20:26 rangi you should get an email in a min or so 20:27 LeeJ rangi: okay! 20:28 LeeJ rangi: hari hou tau btw :) 20:28 magnuse oops, i made a plugin for showing counters of things going on in the library: https://counters.test.bibkat.no/ work in progress... 20:28 cait :) 20:28 rangi LeeJ: https://gitlab.com/koha-community-devs-users/kohadocs you should now have master access 20:28 rangi LeeJ: ngÄ mihi o tau hou ki a koe hoki 20:29 rangi LeeJ: in te reo mÄori adjectives always come after the noun, so tau hou, not hou tau (useless trivia for the day) 20:29 cait :) 20:29 cait like spanish i think? 20:30 rangi magnuse: very cool! 20:30 rangi magnuse: did i show you grafana yet? 20:30 LeeJ magnuse++ 20:30 cait magnuse: make sure to add it to the wiki :) 20:31 magnuse rangi: grafana - don't think so 20:31 magnuse thanks 20:31 cait magnuse: where d o the counts show? 20:31 LeeJ cait: click the link in the middle 20:31 magnuse there is a bold link to them on the front page 20:32 magnuse you could put that up on a screen in the library or something 20:32 cait oh ooops 20:32 cait neat :) 20:32 * LeeJ is excited to have magnuse working on plugins with the rest of us crazy folks :D 20:33 magnuse yeah, i'm pretty excited by the plugins :-) 20:34 * mtompset scrolled back and looked at links. 20:34 rangi magnuse: https://grafana.com/ 20:34 mtompset Released is better. "Koha YY.MM.RR Released" 20:35 mtompset (I capitalized, because it seems like a title to me) 20:35 rangi magnuse: it can hook straight into the db 20:35 magnuse rangi: ah yes, i have been playing a bit with that. 20:35 magnuse oh, cool? 20:36 rangi yeah so you can have a dashboard that real time reports from the db 20:36 magnuse i have been using prometheus and parts of the elastic stack (beats etc) 20:36 magnuse Very Cool! 20:36 magnuse any special tricks for talking to mysql/maria? 20:36 LeeJ magnuse: it's so pretty :') 20:36 rangi nope 20:37 rangi http://mit-admin.mykoha.co.nz:8080/superset/dashboard/koha/ 20:37 LeeJ magnuse: I've been afk from here for a while because I've been working on a plugin myself...it's an addiction but a useful one at that :) 20:37 rangi http://mit-admin.mykoha.co.nz:8080/databaseview/show/2 20:38 cait requires login 20:38 rangi yep 20:38 magnuse superset != gafana? 20:38 magnuse *grafana 20:39 rangi yup 20:39 rangi oh i lie 20:39 rangi no superset is better :) superset is the one airbnb made 20:39 rangi i did have grafana 20:39 rangi http://airbnb.io/projects/superset/ 20:40 rangi i switched to superset because you can set it up to talk to the db really easy 20:40 rangi and with the SQL Lab 20:40 rangi you can pretty much cut and paste any of our reports 20:41 cait hm but you have to allow a third party thing sql access? 20:41 rangi its not third party 20:41 cait oh you can run it yourself? 20:41 rangi its sitting on the same server 20:41 cait that's cool then :) 20:41 rangi yes 20:42 cait could it be used for multiple instances? 20:42 rangi yes 20:42 rangi you can have multiple databases defined 20:42 * magnuse wants to explore superset 20:43 rangi and can give users access to certain ones 20:43 cait neat 20:43 cait what about the reports? 20:43 rangi what reports? 20:43 wahanui reports is probably http://wiki.koha-community.org/wiki/SQL_Reports_Library 20:43 rangi http://mit-admin.mykoha.co.nz:8080/superset/sqllab 20:43 rangi there? 20:43 wahanui it has been said that there is one... but i don't know it 20:44 cait set up one sql for multiple 20:44 rangi search across multiple db at once? 20:44 rangi or have a dashboard that displays them all? 20:44 rangi the second one, yep, easy 20:44 rangi the first one, nope, that would be madness 20:45 rangi you create slices, then you can add them to your dashboard 20:45 cait just add one report accessible to multiple 20:45 cait for their own db :) 20:45 rangi you'd have to create one per dbd 20:45 cait ah ok 20:45 cait maybe could be done with a script or so 20:45 rangi because they could only see theirs 20:52 Joubu @later tell oleonard for 19243 I actually need an id like delete_$branchcode on the submit button to find it easily, would it make sense to you? 20:52 huginn Joubu: The operation succeeded. 20:57 Joubu @later tell tcohen koha-testing-docker, COVERAGE check is still missing on 16.11 20:57 huginn Joubu: The operation succeeded. 20:58 Joubu @later tell tcohen maybe we said we do not care last time we talked about! 20:58 huginn Joubu: The operation succeeded. 21:17 eythian cait: http://www.bbc.com/travel/story/20180102-how-sausage-flavours-the-german-language 21:32 jenkins Project Koha_16.11_D8 build #95: SUCCESS in 2 hr 4 min: https://jenkins.koha-community.org/job/Koha_16.11_D8/95/ 21:32 jenkins * Jonathan Druart: Bug 19568: Escape url params with url filter - opac-opensearch.tt 21:32 jenkins * Jonathan Druart: Bug 19569: Set X-Frame-Options=SAMEORIGIN - opac-showmarc.ok 21:32 jenkins * Jonathan Druart: Bug 19570: Add autocomplete='off' for login forms at the opac 21:32 jenkins * mtompset: Bug 19570: Add autocomplete to opac-main as well 21:32 jenkins * kyle: Bug 19319: Reflected XSS Vulnerability in opac-MARCdetail.pl 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19568 is not accessible. 21:32 jenkins * m.de.rooy: Bug 19319: (QA follow-up) Biblionumber leftovers in opac-detail.tt 21:32 jenkins * Jonathan Druart: Bug 19319: Only fetch the record if it exists 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19569 is not accessible. 21:32 jenkins * amit.gupta: Bug 19611: Fix XSS Flaws in supplier.pl 21:32 jenkins * amit.gupta: Bug 19612: Fix XSS in members/memberentry.pl 21:32 jenkins * amit.gupta: Bug 19614: Fix XSS in members/pay.pl 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19570 is not accessible. 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19319 is not accessible. 21:32 jenkins * katrin.fischer: Bug 19796 - Fix doubled up subscription info on OPAC detail page 21:32 jenkins * chrisc: Bumping version number for 16.11.15 release 21:32 jenkins * root: Translation updates for Koha 16.11.15 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19611 is not accessible. 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19612 is not accessible. 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19614 is not accessible. 21:32 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19796 trivial, P5 - low, ---, katrin.fischer, Pushed to Stable , [16.11] Subscription info appears doubled up on OPAC detail page 21:32 cait eythian: you seem strangely obsessed with things german 22:06 JesseM wonder06614 22:06 bag I think it’s wunder 22:06 bag wunder 06614 22:07 bag @wunder 06614 22:07 huginn bag: Error: HTTP Error 404: Not Found 22:07 bag ooohhh JesseM broke it! 22:07 cait it's not been working for a while 22:07 cait :( 22:07 JesseM :( 22:07 bag darn JesseM broke it that long ago? 22:08 bag JesseM++ 22:08 JesseM lol 22:08 cait hm guess so :) 23:35 jenkins Project Koha_16.11_D8 build #96: SUCCESS in 2 hr 2 min: https://jenkins.koha-community.org/job/Koha_16.11_D8/96/ 23:35 jenkins * gonzalez: Translation updates for Koha 16.11.15 23:35 jenkins * chrisc: Release notes for 16.11.15 23:35 mtompset @wunder toronto 23:35 huginn mtompset: Error: HTTP Error 404: Not Found