Time Nick Message 07:38 reiveune hello 07:44 gaetan_B hello 08:00 alex_a bonjour 08:17 eythian hi 08:18 eythian @wunder ams 08:18 huginn` eythian: The current temperature in Amsterdam, Netherlands is 8.0°C (8:55 AM CET on March 14, 2017). Conditions: Clear. Humidity: 87%. Dew Point: 6.0°C. Windchill: 6.0°C. Pressure: 30.42 in 1030 hPa (Steady). 08:18 LibraryClaire @wunder konstanz 08:18 huginn` LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is 6.5°C (9:15 AM CET on March 14, 2017). Conditions: Clear. Humidity: 83%. Dew Point: 4.0°C. Windchill: 7.0°C. Pressure: 30.48 in 1032 hPa (Steady). 08:21 * magnuse waves 08:21 magnuse @wunder enbo 08:21 huginn` magnuse: The current temperature in Bodo, Norway is 6.0°C (8:50 AM CET on March 14, 2017). Conditions: Mostly Cloudy. Humidity: 70%. Dew Point: 1.0°C. Windchill: 2.0°C. Pressure: 29.33 in 993 hPa (Steady). 08:21 magnuse summery! 08:56 drojf hi #koha 08:57 eythian hi drojf 08:57 drojf hi eythian 09:05 drojf @wunder berlin, germany 09:05 huginn` drojf: The current temperature in Berlin, Berlin, Germany is 5.3°C (10:00 AM CET on March 14, 2017). Conditions: Overcast. Humidity: 88%. Dew Point: 3.0°C. Windchill: 5.0°C. Pressure: 30.39 in 1029 hPa (Steady). 09:05 drojf @wunder txl 09:05 huginn` drojf: The current temperature in Rue du Capitaine Jean Maridor, Berlin, Germany is 4.8°C (9:51 AM CET on March 14, 2017). Conditions: Mostly Cloudy. Humidity: 88%. Dew Point: 3.0°C. Windchill: 5.0°C. Pressure: 30.39 in 1029 hPa (Steady). 09:08 magnuse @wunder enbo 09:08 huginn` magnuse: The current temperature in Bodo Vi, Norway is 7.0°C (10:00 AM CET on March 14, 2017). Conditions: Partly Cloudy. Humidity: 59%. Dew Point: 1.0°C. Pressure: 29.26 in 991 hPa (Falling). 09:10 drojf hei magnuse 09:20 fridolin drojf: hie there, do you have a sec for me ? 09:21 fridolin I have added repo https://apt.abunchofthings.net/koha-nightly but i cant update it 09:23 drojf fridolin: what happens when you try? 09:24 eythian drojf: that's my line 09:24 fridolin drojf: ah thanks : E: The repository 'https://apt.abunchofthings.net/koha-nightly unstable Release' is not signed. 09:24 fridolin N: Updating from such a repository can't be done securely, and is therefore disabled by default. 09:25 drojf ah 09:25 drojf you can add [trusted=yes] to the deb line 09:25 drojf deb [trusted=yes] https://apt.abunchofthings.net/koha-nightly unstable main 09:25 drojf i think thats the way 09:26 fridolin ah i test 09:26 fridolin drojf: it wooooooooorks 09:26 drojf woohoo 09:26 fridolin thanks a lot 09:26 drojf i should put a not on the page 09:26 fridolin we are preparing sandboxes for HF 09:26 drojf cool 10:00 magnuse moin drojf 10:28 eythian @later tell rangi https://www.youtube.com/watch?v=DFM140rju4k 10:28 huginn` eythian: The operation succeeded. 10:32 cait is there anything urgent that should be included in 16.11.05? 10:33 eythian that video. 10:41 magnuse cait: there is a bug report i have been meaning to check out 10:41 magnuse one sec 10:43 magnuse bug 17985 10:43 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17985 normal, P5 - low, ---, koha-bugs, NEW , Hold request fails if only item in transit 10:44 magnuse no, not that one 10:44 magnuse cait: bug 17940 10:44 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17940 critical, P5 - low, ---, jonathan.druart, Pushed to Stable , Holds not going to waiting state after having been transferred 10:44 magnuse ah, pushed to stable. never mind! 10:45 cait :) 10:45 cait everything from master but 2-3 patches i still have to look at has been reviewed and pushed 10:45 cait we will have string freeze tomorrow 10:46 magnuse cait++ 10:46 * magnuse should translate... 10:46 cait yep you should :) 10:46 cait but not quite yet, wait another day or wo 10:46 cait two 10:47 magnuse yup 10:47 magnuse i will probably wait too long... 10:48 magnuse i want to hack up something RDFy for y'all to look at during the hackfest 11:35 cait khall: can you please push the tiny patch on bug 7143? correction of a dev's nam 11:35 cait e 11:35 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7143 trivial, P5 - low, ---, koha-bugs, Passed QA , Bug for tracking changes to the about page 11:36 cait @later tell Joubu can you please take a look at my coment on bug 17951? 11:36 huginn` cait: The operation succeeded. 12:04 kivilahtio biblio_metadata++ 12:04 kivilahtio One note though 12:05 kivilahtio the MARCXML is lost when the biblio is deleted because of a CASCADE FOREIGN KEY -constraint in the biblio_metadata-table from biblio-table 12:05 kivilahtio previously the marcxml was preserved in the oldbiblioitems-table 12:06 kivilahtio this is a challenge for gathering statistics 12:06 kivilahtio for example item has been ordered, received, and removed from collection during the statistics period 12:06 kivilahtio information in marcxml is needed to accurately categorize the item 12:06 kivilahtio ... 12:08 kivilahtio we can just cut the CASCADE from our DB but this might be a bigger issue 12:08 kivilahtio for some libraries with peculiar annual staistical gathering needs (like us) 12:08 kivilahtio who might not realize the change 12:33 kivilahtio Looks like there is a table 'deletedbiblio_metadata', but where is it populated... 12:45 tcohen morning 12:46 kivilahtio morning 12:47 kivilahtio tcohen: where is deletedbiblio_metadata created when a biblio is deleted? 12:49 tcohen kivilahtio: i haven't looked at that code yet 12:49 tcohen ask joubu 12:49 kivilahtio Joubu: where is deletedbiblio_metadata created when a biblio is deleted? 12:57 kivilahtio hmm, better to look with Koha::Biblio::Metadata to find the way instead of biblio_metadata 13:00 Joubu kivilahtio: oops 13:04 kivilahtio Joubu: looks like it 13:04 huginn` New commit(s) kohagit: Bug 7143: Replace Santallan by Santellan <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=13de29ad4465b964e37d4f460f5c9145e23939a1> 13:05 kivilahtio Joubu: will you provide a followup or will I? 13:06 Joubu kivilahtio: if you can, please do 13:06 kivilahtio Joubu: ok 13:06 Joubu kivilahtio: set the status 'critical' and cc me 13:07 kivilahtio ok 13:07 Joubu kivilahtio: not sure what's the best actually 13:07 kivilahtio Joubu: set status to 'me' and cc 'critical'? 13:08 kivilahtio I had the mostests horrible stomach diarrhea whatever this weekend, phew 13:08 kivilahtio I am barely alive 13:08 Joubu happy to know 13:08 kivilahtio yeah 13:08 kivilahtio It comes with the kids 13:08 kivilahtio erm kid 13:08 tcohen yay! diarrhea! 13:09 tcohen however it is written! 13:09 Joubu ha but I created the table actually, 'just' not filling it when deleting 13:09 tcohen spelled 13:09 kivilahtio havent had 38.7 degrees celsius temperature in a decades 13:09 kivilahtio considering the global economic situation 38.7 is not that bad :) 13:17 vfernandes hi #koha 13:17 kivilahtio hiii 13:17 vfernandes can anyone help me on a encoding problem? 13:18 vfernandes i'm doing a fresh koha install and the languages descriptions have some encoding problems 13:19 vfernandes removing the line which enables mysql_enable_utf8 on C4::Installer the languages appears correctly 13:19 vfernandes all mysql variables are in utf8 13:22 kivilahtio Joubu: also. In Koha there once was a great idea that one biblio-entry can have multiple biblioitems 13:22 kivilahtio and the marcxml was tied to the biblioitems-table 13:22 kivilahtio this is a nice idea, but nobdy really cared for it and now biblionumber and biblioitemnumber are used interchangeably 13:23 kivilahtio except when they get out of sync during a data migration 13:23 kivilahtio then things start to work really interestingly 13:23 kivilahtio but the point is 13:23 Joubu vfernandes: check the charset and collate of your tables 13:23 kivilahtio biblio_metadata has a biblionumber-column 13:24 kivilahtio shouldn't it have a biblioitemnumber-column, just for old time's sake? 13:24 Joubu IIRC if you have biblionumber != biblioitemnumber you are going to get wrong things 13:25 kivilahtio yes 13:25 kivilahtio this is bug afaik 13:25 kivilahtio but so we respect the legacy and maybe make it easier to migrate to FRBR (BibFrame etc) 13:26 kivilahtio I can mash the change to biblioitemnumber-column in the mix 13:26 vfernandes Joubu: collation = utf8_unicode_ci 13:26 vfernandes charset = utf8 13:27 Joubu kivilahtio: you are coping biblionumber, so it does not make sense to call it biblioitemnumber 13:27 Joubu s/you/we 13:27 Joubu copying 13:27 kivilahtio Joubu: my suggestion is to copy biblioitemnumber 13:27 kivilahtio Joubu: in the biblioitems-table we had marcxml. primary keyed with biblioitemnumber 13:27 Joubu definitely not on the same bug report if you want to do it 13:27 kivilahtio marcxml was moved to biblio_metadata 13:28 Joubu but biblionumber should be a key as well 13:28 Joubu unique key I meant 13:28 kivilahtio hmm 13:28 kivilahtio well it would make things easier 13:28 kivilahtio and storing a couple million extra int(11) in DB wont make any difference 13:29 francharb hello #koha 13:29 francharb quick question 13:29 francharb We are working on the manual translation 13:29 francharb koha 16.05 13:30 Joubu vfernandes: do you have encoding problems after the install is finished? 13:30 francharb when I translate the manual.xml from the git 13:30 francharb some strings are not translated 13:30 francharb but they are translated in the po files 13:31 francharb does anyone know how to fix this ? 13:31 vfernandes after running web installer, for example portuguese language description is "Português" instead of "Português" 13:31 Joubu vfernandes: where? 13:33 francharb I use msgcat to concat all po files, msgfmt to generate the mo file, then itstool to translate 13:35 Joubu make html? 13:37 francharb I noticed my problem comes when I generate the html from the xml. I use the docbook xsl 13:38 francharb Any suggestion? 13:38 Joubu launch `make html` 13:39 francharb Joubu, tu me parles ? 13:40 Joubu yep 13:40 francharb thanks 13:41 francharb from where ? 13:41 francharb is it a koha shortcut ? 13:41 Joubu from the kohadocs repo 13:42 francharb ok but it's a shortcut for sphynx 13:42 francharb which doesnt' work for this version 13:42 Joubu we are talking about the manual, not Koha, right? 13:42 francharb yes 13:43 francharb but rangi already briefed me about this. It's for the last version of the manual. I think he is going "backport" the 16.11 manual 13:43 francharb but we use the 16.05 13:43 Joubu read the REAME 13:44 Joubu :D 13:44 Joubu I am kidding, the REAME is "Adding Kohadocs"... 13:44 Joubu Read that page? https://wiki.koha-community.org/wiki/Maintaining_man_pages_for_koha-common_as_DocBook_RFC 13:45 Joubu Are you sure you do not want to work on the most recent version of the docs? 13:45 Joubu You are going to learn an obsoleted way to do 13:46 francharb That's what our clients use 13:46 francharb so... 13:49 francharb Thanks Joubu. I read this a while ago but I just realised that I was using a different xslt. I'm going to test again! 13:49 francharb Thanks! 13:58 francharb Joubu, it works! YOU MADE MY DAY!!! 14:17 vfernandes Joubu: in the language_description table 14:18 Joubu vfernandes: do you see encoding problems on the interface? 14:19 Joubu vfernandes: how did you install? 14:19 vfernandes yes, for example in the i18n tab of the admin 14:19 kivilahtio Joubu: Why there even is a separate deletedbiblio_metadata-table? 14:19 kivilahtio there wont be a primary key collission 14:20 kivilahtio both the biblio and deletedbiblio-tables can pull from the same tale biblio_metadata 14:20 kivilahtio I guess it is nice this way due to the FOREIGN KEY-constraints 14:20 kivilahtio just thinking 14:22 Joubu yes, pk collission is possible 14:30 tcohen @later tell marcelr are you going to QA bug 18208? 14:30 huginn` tcohen: The operation succeeded. 14:32 kivilahtio Joubu: tcohen: Do you know anything about Koha::MetadataRecord? Why there is Koha::Biblio::Metadata as well? 14:33 tcohen kivilahtio: yes 14:33 tcohen i think they kind of overlap 14:34 tcohen but K::MR is not wrapping db rows 14:34 tcohen they could be merged at some point 14:34 kivilahtio ok 14:35 vfernandes Joubu: turning on the mysql logs the queries are arriving with wrong enconding 14:35 vfernandes so it's something on the application side 14:35 vfernandes the C4::Installer uses DBIx::RunSQL 14:35 tcohen bug 18098 and bug 18208 are a good approach IMHO 14:35 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18098 enhancement, P5 - low, ---, tomascohen, Signed Off , Add an index with the count of not onloan items 14:35 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18208 enhancement, P5 - low, ---, tomascohen, Signed Off , Add RecordProcessor filter to inject not onloan count to MARC records 14:35 tcohen pleease QA them 14:36 vfernandes subtag_registry.sql is correctly encoded 14:38 Joubu yes Koha::Biblio::Metadata is just Koha::object-based 14:39 Joubu vfernandes: sorry, too much lag and you answer only half of the questions, cannot help more 14:41 vfernandes thanks anyway... but which question I didn't ask? 14:47 Joubu vfernandes: how did you install? 14:48 Joubu is it a dev install, with kohadevbox? debian/ubuntu using package? 14:48 Joubu if the characters are not correctly encoded in the tables, you should reinstall, something went wrong 14:51 jenkins Project Koha_Master_D8 build #126: STILL UNSTABLE in 1 hr 38 min: https://jenkins.koha-community.org/job/Koha_Master_D8/126/ 14:51 jenkins kyle: Bug 7143: Replace Santallan by Santellan 14:51 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7143 trivial, P5 - low, ---, koha-bugs, Needs Signoff , Bug for tracking changes to the about page 14:58 vfernandes directly from tar.gz downloaded from koha-community 14:59 vfernandes not from debian packages 15:01 vfernandes there something wrong with DBD::mysql or DBI 15:02 vfernandes turning mysql logs and DBIx::RunSQL verbose on: the queries are being readed from file correctly but arrives to mysql with double encoding 15:02 vfernandes removing the line $self->{'dbh'}->{'mysql_enable_utf8'}=1; on C4::Installer everything works fine 15:04 Joubu vfernandes: if you thinkn it's a bug, please open a new bug report 15:05 vfernandes I don't think it's a bug 15:05 vfernandes it's something related with this installation 15:05 vfernandes but I don't know what... 15:18 * druthb blames cait 15:18 cait huh? 15:18 cait what for? 15:18 druthb cait++ # taking the blame 15:18 * druthb looks innocent. 15:22 Joubu vfernandes: what version are you using? 15:23 vfernandes 16.11 15:24 vfernandes 16.11.01 15:24 vfernandes MySQL 5.7.16 15:24 Joubu strict mode disabled? 15:25 Joubu https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 15:26 vfernandes yes... 15:26 vfernandes sql-mode= in my.cnf 15:28 vfernandes before execute method, i get the following log: INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pt', 'language', 'pt', 'Português') 15:29 vfernandes mysql log: 2017-03-14T15:27:19.243573Z 63 Query INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pt', 'language', 'pt', 'Português') 15:31 Joubu Hum, that's weird. I have no idea where it could come from 15:31 Joubu But I would not continue without the line you removed 15:32 Joubu did you try to reinstall Koha? 15:32 Joubu Why do not you use the packages? 15:50 vfernandes Joubu: I'm installing Koha using Docker containers and i've tried several times to reinstall Koha 16:56 cait fyi: I've sent he email to bgkriegel for updating the po files - we are string frozen now on 16.11.x 16:58 oleonard If anyone is using kohadevbox on Windows (only me, right?) don't upgrade VirtualBox. There's a bug which affects Vagrant. 17:19 kidclamp @later tell CrispyBran <oleonard> If anyone is using kohadevbox on Windows (only me, right?) don't upgrade VirtualBox. There's a bug which affects Vagrant. 17:19 huginn` kidclamp: The operation succeeded. 17:20 kidclamp @later tell kchris <oleonard> If anyone is using kohadevbox on Windows (only me, right?) don't upgrade VirtualBox. There's a bug which affects Vagrant. 17:20 huginn` kidclamp: The operation succeeded. 17:20 kidclamp that's all I know of oleonard 17:44 reiveune bye 17:52 blou weather 17:52 francharb @weather 17:52 huginn` francharb: (weather <US zip code | US/Canada city, state | Foreign city, country>) -- Returns the approximate weather conditions for a given city. 17:52 blou @weather h2r2y6 17:52 huginn` blou: The current temperature in Elmo Rooftop Terrace, Westmount, Westmount, Quebec is -9.1°C (1:52 PM EDT on March 14, 2017). Conditions: . Humidity: 85%. Dew Point: -12.0°C. Windchill: -15.0°C. Pressure: 30.21 in 1023 hPa (Falling). 18:01 druthb @wunder 77098 18:01 huginn` druthb: The current temperature in Montrose, Houston, Texas is 15.1°C (12:52 PM CDT on March 14, 2017). Conditions: Clear. Humidity: 43%. Dew Point: 2.0°C. Pressure: 30.25 in 1024 hPa (Rising). 18:01 druthb #LifeInTheTropics 18:02 eythian No such channel, druthb 18:02 druthb :P 18:40 sjenson Greetings all. I am trying to figure out a detail about cataloguing in Koha. Most of the items have been copied catalogued into the system which is helpful. However, when I try to create a MARC record, I cannot find the subjects that should already be in the systems, eg. Space Exploration. 18:41 sjenson does anyone know of a good tutorial which would describe this step? 19:24 eythian sjenson: you're in the quiet time when Europeans are in the pub and Australasia is having breakfast. Hang around and you'll probably get a reply :) 19:25 sjenson thanks. I was thinking of sending it out to the list-serv too. 19:25 eythian sjenson: also, you probably need authority records. 19:25 eythian That's also a worthwhile option. 19:26 sjenson are authority records imported when you import a MARC record from a Z39 server? 19:26 eythian No, they're a separate thing 19:27 eythian However, they can be auto generated, there's a syspref for it 19:27 eythian I'd ask jcamins if i were you, i can't remember the details. Also, I'm in Europe so at the pub :) 19:30 sjenson eythian: I have a few more hours before I can get down to the local pub, so I am a bit jealous. 19:32 sjenson eythian, thanks for your help. I will start googling the information I need.