Time Nick Message 02:26 hertz Hello 02:26 wahanui bonjour, hertz 02:36 hertz Hey whats up 02:37 hertz Is this room dedicated to programming 02:37 hertz ? 02:37 wizzycray Welcome to the #koha IRC chat | Code of conduct - https://koha-community.org/about/policy/code-of-conduct/ | Please use http://paste.koha-community.org for pastes | Installation guide for Koha is https://wiki.koha-community.org/wiki/Debian 02:41 volve hey all, anyone around? I'm still battling this "No biblionumber tag for framework "DCHM" at /usr/share/koha/lib/C4/Biblio.pm line 3093" internal server error on my new install :( 02:44 wizzycray did you delete the 999c from your framework? 02:48 volve wizzycray: nope 02:48 wizzycray do you have it mapped to the biblionumber in koha->marc mappings? 02:48 wizzycray 999c -> biblio.biblionumber 02:49 volve yup :/ 02:49 volve and marc links is happy too 02:50 volve when I poke at the database with `select count(*) from marc_subfield_structure where frameworkcode="DCHM" and kohafield="biblio.biblionumber";` comes back as 0, I'm not sure if that's right though 02:51 wizzycray new or old framework? 02:52 volve Default 02:52 volve not editted 02:52 volve literally a fresh install 02:52 volve clearly something's wonky somewhere, but I'm a newb to Koha so have no idea where to look 02:52 wizzycray well the framework code on a new install for the default framework would be 02:52 wizzycray "" 02:52 wizzycray iirc. 02:52 volve well that's curious 02:53 wizzycray did you import your database from a different Koha? 02:53 volve when I look at the marc frameworks page in intra, there's no code listed as DCHM, oddly 02:53 * wizzycray is not surprised 02:54 volve why are you not surprised? :) 02:54 wizzycray it would seem that possibly you have set framework codes on your records 02:54 wizzycray that don't actually match up to an existent framework 02:54 wizzycray but that's just a guess 02:54 wizzycray if you exported the default framework 02:54 wizzycray created a new framework with the code DCHM 02:54 wizzycray then imported the default framework on top of that 02:54 wizzycray does it magically start working? 02:55 wizzycray it won't hurt, anyway. 02:55 volve I can give it a try 02:56 volve the funny thing is I have no records at all 02:56 wizzycray where do you get the message? 02:56 wahanui i guess the message is self-explanatory 02:56 volve I get this error when trying to add my very first record 02:56 wizzycray your default framework exists? 02:56 volve yes 02:57 wizzycray what version is this? 02:58 volve my repro steps are: Cataloging -> New from Z39.50/SRU -> Title search from 2 targets -> Click "Import" on 1 of the 4 results -> Choose "Book" as Koha item type -> Hit Save -> "Internal Server Error" with log entry about DCHM 02:58 wizzycray yeah but what version 02:58 wizzycray and what server OS/MySQL version 02:59 volve 16.11.02.000 02:59 volve Linux Ubuntu, Mysql 5.5.54 02:59 wizzycray what version of ubuntu? 02:59 * volve double-checks 03:01 volve I think it's 16.04 03:02 volve it's running in a Docker container 03:02 wizzycray Ah 03:02 wizzycray hm. 03:07 volve Indeed. 03:08 volve So why would DCHM be a factor when trying to save a new record if there are no frameworks listed with a DCHM code? 03:08 volve And how can I get them out, ha 03:08 wizzycray I don't know where it's getting DCHM for 03:08 wizzycray from* 03:08 wizzycray is that the name of your library? 03:08 wizzycray or the code? 03:08 wahanui i think the code is kept at git.koha-community.org 03:08 wizzycray shh. 03:09 volve I have no knowledge of what "DCHM" might mean 03:09 volve funnily enough Google found 1 result for this exact error, and pointed me here... 1 month ago 03:09 wizzycray are you logged in as the database user or as a regular user with permissions/ 03:09 volve looking at the channel logs, the person in question magically figured it out with no explanation... 03:10 volve wizzycray: I've tried saving records as both, same error 03:11 volve I think I may have found a reference. The devs that setup this docker image use this github repo: github.com/digibib/koha-docker/ 03:11 volve it's very active 03:11 volve but there's a reference to DCHM buried in there 03:11 volve So I'll dig some more 03:11 volve "<option value="DCHM">Deichman-rammeverk</option>" in one of their patches 03:12 wizzycray was this a docker thing you downloaded from somewhere? 03:13 wizzycray heh 03:13 wizzycray yeah don't use that 03:13 volve they publish their Koha images for Docker to Docker's image Hub - and their scripts do seem to work well 03:13 wizzycray that's great, but it's not core Koha 03:13 wizzycray it's got their stuff in it 03:13 wizzycray which obviously breaks it 03:14 wizzycray is this koha for production or for fun 03:14 volve to be fair, I also did a vanilla Debian install using the official guide and got crazy database errors simply stepping through the install wizard :\ 03:14 wizzycray you'd have better luck getting help with those than with the digibib docker thing 03:14 volve at the step where you choose which sample data you want, everything kept exploding 03:15 wizzycray that was probably mysql 5.7 03:15 wizzycray which (all the sigh) is a known problem 03:15 wizzycray if you just want to play 03:15 volve oh, what version of mysql is preferred then? the guides didn't specify 03:15 wizzycray https://github.com/digibib/kohadevbox this is a much better route 03:16 wizzycray and you get a developer install too. 03:16 volve wizzycray: that's the same devs as the docker image, ha! 03:16 wizzycray but don't run that in production. 03:16 wizzycray yeah, but not really. 03:16 wizzycray they started that, but they don't maintain it to speak of. 03:16 wizzycray community people do 03:16 wizzycray I know it's confusing 03:16 volve oh, odd 03:16 wizzycray @later tell tcohen maybe it's time to move devbox out from under digibib? 03:16 huginn wizzycray: The operation succeeded. 03:17 volve ok, well if I wanted to do a fool-proof production deployment, is there a better guide that has compatible mysql versions and such? 03:17 wizzycray basically, for current versions 03:17 wizzycray either use mariadb, or mysql 5.5 03:17 wizzycray the ubuntu/debian version shouldn't give you too much hassle 03:18 wizzycray generally speaking, the community likes debian 8 03:18 wizzycray debian, generally. 03:19 wizzycray https://wiki.koha-community.org/wiki/Koha_on_Debian this is the most usually and frequently maintained guide 03:19 wizzycray there are lots of blog posts, most of them are wrong in some way. 03:19 wizzycray but not this page, normally. 03:19 volve yeah that's the one I followed, but it doesn't mention mysql versions I don't believe 03:19 wizzycray probably not, the 5.7 thing is quite new. 03:19 volve that's frustrating 03:19 wizzycray yep 03:20 volve any particular mariadb version? 03:20 volve I'm happy to give that another whirl 03:20 wizzycray nope, they haven't implemented the changes that break it in mysql 5.7 03:20 wizzycray (yet) 03:20 wizzycray there is a bug for the 5.7 problems I don't remember the number 03:20 volve ah, ok 03:21 wizzycray https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 03:21 huginn 04Bug 17258: major, P5 - low, ---, gmcharlt, NEW , [OMIBUS] MySQL 5.7 03:21 wizzycray also some suggested work arounds 03:21 volve well thank you wizzycray, I filed an issue for koha-docker, and will give mariadb a go with a fresh debian install 03:22 volve yep, I had to monkey with sql_mode to get past the installer, but at that point there were so many dupes in the database it was not usable and I gave-up, back to the docker situation 03:23 volve happy to hear mariadb will solve it 03:23 * volve gets typing 03:23 wizzycray good luck :) 03:23 wizzycray yeah, if you get yourself into that situation 03:23 wizzycray you can always koha-remove <the name of your instance> 03:23 wizzycray and start again 03:23 wizzycray and/or 03:23 wizzycray sudo koha-mysql <the name of your instance> 03:24 wizzycray drop database koha_the_name_of_your_instance 03:24 wizzycray create database koha_the_name_of_your_instance 03:24 wizzycray i mean, if you've got nothing in it 03:24 wizzycray none of that hurts. 03:24 wizzycray but yeah, mysql 5.7 is a bad deal atm 03:24 wizzycray but we're working on it :) 03:25 volve who updates the Koha_on_Debian guide? I would have loved a mariadb reference or mysql version not ;) 03:25 volve not/note 03:25 wizzycray you can :) 03:25 wizzycray it's a wiki ^.^ 03:26 volve oh hey funny there's a note at the top "Koha does not work well with MySQL 5.7 which is shipped with Ubuntu 16.04. use MariaDB instead." 03:26 wizzycray keke 03:26 volve but not at the actually step for installing mysql, ha 03:26 wizzycray \o/ 03:26 volve so clearly I missed it 03:26 wizzycray it's ok it happens 03:28 volve thanks for your help wizzycray, really appreciate it, hoping to get this deployed to a team of eager folks asap 03:29 wizzycray yep I know that feeling :) 03:29 wizzycray good luck 03:29 volve thanks! 03:29 wizzycray Europe should be waking up soon, should you run into any more problems 03:35 volve right, right. Fun to think that koha-docker is running the Oslo Public Library 03:35 wizzycray they have got their own special sauce 03:36 wizzycray which is cool, but it is hard to support :) 03:36 volve so it would seem :D 03:46 volve odd, `koha-create --create-db foo` says "User foo already exists." 03:46 volve on a brand new install 03:47 volve correction "User foo-koha already exists." 03:47 wizzycray is it the 2nd time you've done it? 03:47 volve nope 03:47 volve I gave it a different name and it's running fine now 03:48 wizzycray well yay :) 03:48 * wizzycray does not know of any bugs with naming things 'foo' in debian 03:49 volve well it wasn't really foo ;) 05:10 irma hi rangi About the Article request function https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14610 05:10 huginn 04Bug 14610: new feature, P5 - low, ---, kyle.m.hall, Pushed to Stable , Add ability to place article requests in Koha 05:10 irma would it help if we wrote the instruction for the Koha Manual 16.11? 05:11 irma nice feature! 05:13 irma @later tell rangi Do you need instructions re Article request for the KC Manual 16.11? 05:13 huginn irma: The operation succeeded. 06:42 josef_moravec morning#koha 06:46 * magnuse waves 06:52 drojf hi #koha 06:56 drojf @wunder berlin, germany 06:56 huginn drojf: The current temperature in Berlin, Berlin, Germany is -6.9°C (7:32 AM CET on February 13, 2017). Conditions: Clear. Humidity: 94%. Dew Point: -8.0°C. Windchill: -7.0°C. Pressure: 30.66 in 1038 hPa (Steady). 06:56 drojf oj 06:57 drojf @wunder marseille, france 06:57 huginn drojf: The current temperature in Marseille, France is 15.0°C (7:30 AM CET on February 13, 2017). Conditions: Overcast. Humidity: 48%. Dew Point: 4.0°C. Pressure: 30.06 in 1018 hPa (Steady). 06:57 drojf woop woop 06:59 liw @wunder helsinki 06:59 huginn liw: The current temperature in Helsinki, Finland is -1.0°C (8:20 AM EET on February 13, 2017). Conditions: Clear. Humidity: 80%. Dew Point: -4.0°C. Windchill: -6.0°C. Pressure: 30.30 in 1026 hPa (Steady). 07:00 drojf hi liw 07:00 liw 07:00 drojf everywhere is warmer than here 07:22 cait @wunder Konstanz 07:22 huginn cait: An error has occurred and has been logged. Please contact this bot's administrator for more information. 07:22 cait hmpf 07:26 magnuse moin drojf cait liw 07:26 magnuse @wunder enbo 07:26 huginn magnuse: An error has occurred and has been logged. Please contact this bot's administrator for more information. 07:26 magnuse @wunder bodø, norway 07:26 huginn magnuse: An error has occurred and has been logged. Please contact this bot's administrator for more information. 07:26 magnuse @wunder boo 07:26 huginn magnuse: An error has occurred and has been logged. Please contact this bot's administrator for more information. 07:26 magnuse :-( 07:27 magnuse drojf: it's about +6C here 07:30 drojf hei magnuse 07:30 drojf nice! 07:30 magnuse yup, all the ice is gone 07:30 magnuse it's safe to walk outside again! 07:31 drojf i wonder if it's safe to walk on the canal close by 07:31 drojf i don't think we had much + lately 07:33 reiveune hello 07:33 wahanui salut, reiveune 07:34 marcelr hi #koha 07:37 drojf hi marcelr 07:37 marcelr hi drojf 07:37 magnuse bonjour reiveune marcelr laurence 07:37 marcelr morning magnuse 07:37 LibraryClaire o/ 07:37 marcelr and LibraryClaire 07:37 wahanui LibraryClaire is the monster under my bed 07:38 laurence hi magnuse 07:38 wahanui kamelÃ¥sÃ¥ 07:38 LibraryClaire hi magnuse 07:38 wahanui kamelÃ¥sÃ¥ 07:38 magnuse guten morgen LibraryClaire 07:45 alex_a bonjour 07:45 wahanui hello, alex_a 07:46 LibraryClaire hi alex_a 07:49 alex_a hello LibraryClaire 09:58 * cait waves 10:08 drojf hi cait 10:24 cait moin drojf 10:58 eythian hi 10:58 wahanui bidet, eythian 10:58 eythian @wunder ams 10:58 huginn eythian: An error has occurred and has been logged. Please contact this bot's administrator for more information. 10:58 eythian @wunder jordaan, ams 10:58 huginn eythian: An error has occurred and has been logged. Please contact this bot's administrator for more information. 10:58 eythian :< 11:33 drojf eythian: no weather for you 11:47 eythian drojf: apparently not. 11:48 drojf @wunder berlin, germany 11:48 huginn drojf: The current temperature in Berlin, Berlin, Germany is -1.8°C (12:08 PM CET on February 13, 2017). Conditions: Clear. Humidity: 89%. Dew Point: -3.0°C. Windchill: -2.0°C. Pressure: 30.66 in 1038 hPa (Steady). 11:48 drojf it's all mine 11:59 eythian give it back! 11:59 eythian @wunder jordaan, ams 11:59 huginn eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 3.3°C (12:49 PM CET on February 13, 2017). Conditions: Clear. Humidity: 74%. Dew Point: -1.0°C. Windchill: 3.0°C. Pressure: 30.39 in 1029 hPa (Steady). 11:59 eythian that's better 12:00 eythian Snow outside is slowly melting 12:03 LibraryClaire @wunder konstany 12:03 huginn LibraryClaire: Error: HTTP Error 404: Not Found 12:03 LibraryClaire stupid keyboards 12:03 LibraryClaire @wunder konstanz 12:03 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is 3.2°C (12:49 PM CET on February 13, 2017). Conditions: Mostly Cloudy. Humidity: 79%. Dew Point: -0.0°C. Windchill: 3.0°C. Pressure: 30.27 in 1025 hPa (Steady). 12:04 eythian hah, 0.1° warmer! 12:26 magnuse @wunder enbo 12:26 huginn magnuse: The current temperature in Bodo Vi, Norway is 6.0°C (1:00 PM CET on February 13, 2017). Conditions: Light Rain. Humidity: 100%. Dew Point: 6.0°C. Pressure: 30.26 in 1025 hPa (Rising). 12:26 magnuse phew 12:27 eythian I think you must have the wrong Norway, magnuse. It's supposed to be -20 all the time there. 12:27 magnuse lulz 12:42 oleonard Hi everyone 12:43 eythian hi oleopard 12:49 drojf hi oleonard 12:49 wahanui hi oleopard 13:34 Guest457 hello 13:34 edveal Hello 13:40 barton morning #koha! 13:40 edveal morning barton 13:46 barton @later tell tcohen something to look at with koha-zebra: zebrasrv has a 1024K default ceiling on record size. This can be increased. We should probably set it in $KOHA_CONF, the same way we set loglevels. 13:46 huginn barton: The operation succeeded. 14:10 kidclamp morning 14:11 marcelr hello kidclamp 14:11 LibraryClaire hi kidclamp 14:16 marcelr drojf: did you test it, or only noting ? 14:17 marcelr no drojf 14:17 wahanui no drojf is afraid you will make me chair 14:17 marcelr o no he is on top 14:17 drojf marcelr: i built a package with master + the patches and used it to upgrade a vm 14:18 drojf so i am fairly certain it fixes it ;) 14:18 marcelr indirect test 14:18 marcelr good 14:18 drojf but i will use it in my vm now which was broken last week 14:18 drojf to confirm 14:25 drojf marcelr: works. are the tests supposed to be done step by step or can i test with the package that has all patches? 14:27 drojf if i understand correctly, i can only test patch 3 and 4 in a regular debian installation 14:41 tcohen morning 14:42 drojf hi tcohen 14:43 tcohen hi drojf 14:44 LibraryClaire hi tcohen 14:44 * tcohen 's car didn't start this morning, bad week start 14:46 cait :( 14:46 tcohen I couldn't be at the new house to open so the guys polished the new floor :-( 14:46 * LibraryClaire 's brain didn't start this morning 14:48 cait tcohen: can you explain the problem? 14:48 * oleonard waves to newly woken up peoples 14:49 tcohen cait: the car's problem? 14:49 tcohen is the injectors :-P 14:56 tcohen @later tell wizzycray I've been thinking about it recently. now that people have interest on it it might be worth talking about that 14:56 huginn tcohen: The operation succeeded. 15:10 * oleonard is curious what tcohen was talking to wizzycray about 15:11 LibraryClaire ultimate stealth message 15:14 tcohen "Sent 11 hours and 25 minutes ago: <wizzycray> maybe it's time to move devbox out from under digibib?" 15:14 LibraryClaire :D 15:14 tcohen she wrote it here earlier 15:25 * tcohen is glad to see interest in kohadevbox and that more people contribute to it 15:29 cait tcohen: was wondering why polishing hte floor was bad :) 15:32 tcohen I had an appointment so they polished it, and I missed it 15:32 cait you wanted to watch them? 15:33 tcohen the house is empty, and no one is there to open the door! 15:33 tcohen it is outside Cordoba 15:33 tcohen far from where I liv 15:33 tcohen e 15:33 eythian if no one is there to open the door, how did they polish it? 15:34 * LibraryClaire slides across shiny polished floor 15:34 cait squeee! 15:34 tcohen no one polished it 15:35 cait (15:46:46) tcohen: I couldn't be at the new house to open so the guys polished the new floor 15:35 cait ;) 15:35 * cait blames tcohen for getting everyone confused 15:36 * LibraryClaire is sad there is no polished floor to slide on 15:36 * tcohen thinks the missing comma makes it clear and you are wrong 15:36 tcohen :-P 15:36 eythian you definitely said multiple times that they polished it :) 15:37 tcohen eythian: probably due to my lack of idiomatic checker 15:37 eythian you should install one 15:38 eythian the particular tense you needed is actually called "the unreal past" apparently. That's a good name. 15:53 tcohen eythian: troll 16:11 LibraryClaire laters #koha 16:12 reiveune bye 16:14 drojf dependencies-- 16:18 cait not me i hope? drojf? 16:18 drojf nope 16:18 drojf catmandu 16:18 wahanui well, catmandu is pretty super awesome 16:19 drojf i think the dependencies of dependencies require perl 5.24 :/ 16:21 cait oh 16:21 cait ouch 16:49 volve hey all, if I have an old framework, but no signs of it in the UI, how can I make sure I nuke it from the database without losing everything else? 17:16 oleonard volve: What do you mean by no signs of it in the UI? 17:17 volve oleonard: turns out that the digibib/koha-docker create a mysql trigger that tries to set frameworkcode to "DCHM" on any new records. I deleted this trigger becauase I don't have any frameworks with code of "DCHM", and all seems well now. I was able to add a record successfully. 17:21 drojf oleonard: are you working with visual diffs for web development? 17:21 oleonard drojf: I don't think I understand your question 17:22 drojf oleonard: i am talking of things like https://github.com/BBC-News/wraith 17:22 oleonard Neat. I've never seen that before. So I guess the answer is no 17:23 drojf heh. ok. my office colleague has been looking into that and i was wondering if it would be useful for koha 17:24 oleonard I suspect we do less cross-browser/cross-platform testing than we should, but I also don't think pixel-perfect matching is necessary 17:24 drojf i was more thinking of things like accidentally breaking the layout 17:29 oleonard drojf: If your colleague ends up trying something like it I'd be interested to hear how it goes 17:35 * cait waves 17:36 tcohen @wunder cordoba, argentina 17:36 huginn tcohen: The current temperature in Cordoba, Argentina is 26.0°C (2:00 PM ART on February 13, 2017). Conditions: Scattered Clouds. Humidity: 39%. Dew Point: 11.0°C. Pressure: 29.95 in 1014 hPa (Falling). 17:51 tcohen drojf: kohadevbox gets Catmandu installed by CPAN on Jessie 17:51 drojf tcohen: yuck 17:51 drojf :P 17:51 tcohen I mean, it is using Perl 5.20 17:52 drojf i think it's the packaging for stretch. i found one dep that did not really need perl 5.24 and works fine with a lower version. i assume that works for others too 17:53 drojf but it's more than i can do today, which is annoying. i thought i could get it done to the point where i set up a test repo 17:53 tcohen when is strech released? 17:54 drojf good question. i think they had freeze already 17:54 drojf but it's debian, so maybe it takes years after that :P 17:55 tcohen so we are still targeting Jessie :-D, good 17:55 drojf yes 17:55 JesseM no targeting me ;P 17:55 drojf i don't think it would be fair to drop jessie now :P 17:55 drojf heh 17:56 tcohen heh 17:57 drojf at least most of it is in stretch now, so it's backporting, not doing all the packaging from scratch 17:57 drojf but i had enough for today 17:57 * drojf heads home 17:58 drojf bye #koha 19:43 cait @wunder Konstanz 19:43 huginn cait: The current temperature in Mainaustraße, Konstanz, Germany is 2.9°C (7:46 PM CET on February 13, 2017). Conditions: Clear. Humidity: 80%. Dew Point: -0.0°C. Windchill: 3.0°C. Pressure: 30.24 in 1024 hPa (Steady). 20:15 eythian @wunder ams 20:15 huginn eythian: The current temperature in Amsterdam, Netherlands is 3.0°C (8:55 PM CET on February 13, 2017). Conditions: Clear. Humidity: 70%. Dew Point: -2.0°C. Windchill: -2.0°C. Pressure: 30.33 in 1027 hPa (Steady). 23:18 oleonard Hi again for this day. 23:19 oleonard Anyone awake? I seek the secret of a root mysql user in kohadevbox. 23:29 cait oleonard: try empty 23:29 cait mysql -u root 23:30 oleonard Cool, thanks cait 23:30 cait np :)