IRC log for #koha, 2017-03-14

All times shown according to UTC.

Time S Nick Message
00:08 Francesca joined #koha
00:24 JoshB joined #koha
01:18 JoshB joined #koha
01:45 JoshB joined #koha
02:31 irma joined #koha
05:03 JoshB joined #koha
06:38 laurence joined #koha
06:38 laurence left #koha
06:45 cait joined #koha
07:15 LibraryClaire joined #koha
07:24 Scott-CSPL joined #koha
07:38 reiveune joined #koha
07:38 reiveune hello
07:44 gaetan_B joined #koha
07:44 gaetan_B hello
08:00 alex_a joined #koha
08:00 alex_a bonjour
08:09 irma joined #koha
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 AndrewIsh joined #koha
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:23 fridolin joined #koha
08:26 laurence joined #koha
08:31 sophie_m joined #koha
08:56 drojf joined #koha
08:56 drojf hi #koha
08:57 eythian hi drojf
08:57 drojf hi eythian
09:00 paul_p joined #koha
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:19 alex_a joined #koha
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 Francesca joined #koha
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
09:41 Francesca joined #koha
09:43 irma joined #koha
09:52 BobB_ joined #koha
10:00 magnuse moin drojf
10:02 fridolin left #koha
10:07 fridolin joined #koha
10:14 cait joined #koha
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` Bug http://bugs.koha-community.org[…]_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` Bug http://bugs.koha-community.org[…]_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
10:59 irma joined #koha
11:35 meliss joined #koha
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` Bug http://bugs.koha-community.org[…]w_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.
11:52 oleonard joined #koha
12:01 oleonard joined #koha
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:13 kmlussier joined #koha
12:23 Putti joined #koha
12:33 kivilahtio Looks like there is a table 'deletedbiblio_metadata', but where is it populated...
12:38 sophie_m joined #koha
12:41 Dyrcona joined #koha
12:42 vfernandes joined #koha
12:44 tcohen joined #koha
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
12:58 alex_a joined #koha
13:00 Joubu kivilahtio: oops
13:03 kidclamp joined #koha
13:03 JoshB joined #koha
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/[…]60f5c9145e23939a1>
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 oleonard joined #koha
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 francharb joined #koha
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:23 nengard joined #koha
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 NateC joined #koha
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.or[…]on_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:01 kholt joined #koha
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` Bug http://bugs.koha-community.org[…]_bug.cgi?id=18098 enhancement, P5 - low, ---, tomascohen, Signed Off , Add an index with the count of not onloan items
14:35 huginn` Bug http://bugs.koha-community.org[…]_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:43 kchris joined #koha
14:47 Joubu vfernandes: how did you install?
14:47 TGoat joined #koha
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[…]ha_Master_D8/126/
14:51 jenkins kyle: Bug 7143: Replace Santallan by Santellan
14:51 huginn` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7143 trivial, P5 - low, ---, koha-bugs, Needs Signoff , Bug for tracking changes to the about page
14:56 jac joined #koha
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:15 jenkins joined #koha
15:18 cait joined #koha
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:21 rocio joined #koha
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.or[…]ackages#Ubuntu_16.04_and_MySQL_5.7
15:25 kellym joined #koha
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 QueryINSERT 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:36 kellym left #koha
15:49 jbeno joined #koha
15:50 vfernandes Joubu: I'm installing Koha using Docker containers and i've tried several times to reinstall Koha
15:54 sophie_m joined #koha
15:56 sophie_m1 joined #koha
15:58 LibraryClaire left #koha
15:59 sophie_m joined #koha
15:59 fridolin left #koha
16:00 sophie_m joined #koha
16:02 sophie_m1 joined #koha
16:02 sjenson joined #koha
16:04 sophie_m joined #koha
16:11 sophie_m joined #koha
16:22 sophie_m1 joined #koha
16:37 jls joined #koha
16:39 cait joined #koha
16:42 laurence left #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:01 ashimema joined #koha
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:38 tcohen joined #koha
17:39 LibraryClaire joined #koha
17:44 reiveune bye
17:44 reiveune left #koha
17:52 blou joined #koha
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:36 sjenson joined #koha
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 kholt joined #koha
18:41 sjenson does anyone know of a good tutorial which would describe this step?
18:55 kholt joined #koha
19:20 shakalaka joined #koha
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.
19:57 Francesca joined #koha
20:38 hank_bank joined #koha
20:45 magnuse joined #koha
21:15 JoshB left #koha
21:16 edveal left #koha
21:17 JoshB joined #koha
21:54 magnuse joined #koha
22:32 tcohen joined #koha
22:59 Francesca joined #koha
23:00 dilan joined #koha
23:10 ashimema joined #koha
23:37 irma joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary