Time Nick Message
19:32 sjenson eythian, thanks for your help. I will start googling the information I need.
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: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:27 eythian However, they can be auto generated, there's a syspref for it
19:26 eythian No, they're a separate thing
19:26 sjenson are authority records imported when you import a MARC record from a Z39 server?
19:25 eythian That's also a worthwhile option.
19:25 eythian sjenson: also, you probably need authority records.
19:25 sjenson thanks. I was thinking of sending it out to the list-serv too.
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 :)
18:41 sjenson does anyone know of a good tutorial which would describe this step?
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:02 druthb :P
18:02 eythian No such channel, druthb
18:01 druthb #LifeInTheTropics
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 @wunder 77098
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).
17:52 blou @weather h2r2y6
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 francharb @weather
17:52 blou weather
17:44 reiveune bye
17:20 kidclamp that's all I know of oleonard
17:20 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:19 huginn` kidclamp: The operation succeeded.
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.
16:58 oleonard If anyone is using kohadevbox on Windows (only me, right?) don't upgrade VirtualBox. There's a bug which affects Vagrant.
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
15:50 vfernandes Joubu: I'm installing Koha using Docker containers and i've tried several times to reinstall Koha
15:32 Joubu Why do not you use the packages?
15:32 Joubu did you try to reinstall Koha?
15:31 Joubu But I would not continue without the line you removed
15:31 Joubu Hum, that's weird. I have no idea where it could come from
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: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:26 vfernandes sql-mode= in my.cnf
15:26 vfernandes yes...
15:25 Joubu https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7
15:24 Joubu strict mode disabled?
15:24 vfernandes MySQL 5.7.16
15:24 vfernandes 16.11.01
15:23 vfernandes 16.11
15:22 Joubu vfernandes: what version are you using?
15:18 * druthb looks innocent.
15:18 druthb cait++ # taking the blame
15:18 cait what for?
15:18 cait huh?
15:18 * druthb blames cait
15:05 vfernandes but I don't know what...
15:05 vfernandes it's something related with this installation
15:05 vfernandes I don't think it's a bug
15:04 Joubu vfernandes: if you thinkn it's a bug, please open a new bug report
15:02 vfernandes removing the line $self->{'dbh'}->{'mysql_enable_utf8'}=1; on C4::Installer everything works fine
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:01 vfernandes there something wrong with DBD::mysql or DBI
14:59 vfernandes not from debian packages
14:58 vfernandes directly from tar.gz downloaded from koha-community
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:51 jenkins kyle: Bug 7143: Replace Santallan by Santellan
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:48 Joubu if the characters are not correctly encoded in the tables, you should reinstall, something went wrong
14:48 Joubu is it a dev install, with kohadevbox? debian/ubuntu using package?
14:47 Joubu vfernandes: how did you install?
14:41 vfernandes thanks anyway... but which question I didn't ask?
14:39 Joubu vfernandes: sorry, too much lag and you answer only half of the questions, cannot help more
14:38 Joubu yes Koha::Biblio::Metadata is just Koha::object-based
14:36 vfernandes subtag_registry.sql is correctly encoded
14:35 tcohen pleease QA them
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 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 tcohen bug 18098 and bug 18208 are a good approach IMHO
14:35 vfernandes the C4::Installer uses DBIx::RunSQL
14:35 vfernandes so it's something on the application side
14:35 vfernandes Joubu: turning on the mysql logs the queries are arriving with wrong enconding
14:34 kivilahtio ok
14:34 tcohen they could be merged at some point
14:34 tcohen but K::MR is not wrapping db rows
14:33 tcohen i think they kind of overlap
14:33 tcohen kivilahtio: yes
14:32 kivilahtio Joubu: tcohen: Do you know anything about Koha::MetadataRecord? Why there is Koha::Biblio::Metadata as well?
14:30 huginn` tcohen: The operation succeeded.
14:30 tcohen @later tell marcelr are you going to QA bug 18208?
14:22 Joubu yes, pk collission is possible
14:20 kivilahtio just thinking
14:20 kivilahtio I guess it is nice this way due to the FOREIGN KEY-constraints
14:20 kivilahtio both the biblio and deletedbiblio-tables can pull from the same tale biblio_metadata
14:19 kivilahtio there wont be a primary key collission
14:19 kivilahtio Joubu: Why there even is a separate deletedbiblio_metadata-table?
14:19 vfernandes yes, for example in the i18n tab of the admin
14:19 Joubu vfernandes: how did you install?
14:18 Joubu vfernandes: do you see encoding problems on the interface?
14:17 vfernandes Joubu: in the language_description table
13:58 francharb Joubu, it works! YOU MADE MY DAY!!!
13:49 francharb Thanks!
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:46 francharb so...
13:46 francharb That's what our clients use
13:45 Joubu You are going to learn an obsoleted way to do
13:45 Joubu Are you sure you do not want to work on the most recent version of the docs?
13:44 Joubu Read that page? https://wiki.koha-community.org/wiki/Maintaining_man_pages_for_koha-common_as_DocBook_RFC
13:44 Joubu I am kidding, the REAME is "Adding Kohadocs"...
13:44 Joubu :D
13:43 Joubu read the REAME
13:43 francharb but we use the 16.05
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:42 francharb yes
13:42 Joubu we are talking about the manual, not Koha, right?
13:42 francharb which doesnt' work for this version
13:42 francharb ok but it's a shortcut for sphynx
13:41 Joubu from the kohadocs repo
13:41 francharb is it a koha shortcut ?
13:41 francharb from where ?
13:40 francharb thanks
13:40 Joubu yep
13:39 francharb Joubu, tu me parles ?
13:38 Joubu launch `make html`
13:38 francharb Any suggestion?
13:37 francharb I noticed my problem comes when I generate the html from the xml. I use the docbook xsl
13:35 Joubu make html?
13:33 francharb I use msgcat to concat all po files, msgfmt to generate the mo file, then itstool to translate
13:31 Joubu vfernandes: where?
13:31 vfernandes after running web installer, for example portuguese language description is "Português" instead of "Português"
13:31 francharb does anyone know how to fix this ?
13:30 francharb but they are translated in the po files
13:30 francharb some strings are not translated
13:30 francharb when I translate the manual.xml from the git
13:30 Joubu vfernandes: do you have encoding problems after the install is finished?
13:29 francharb koha 16.05
13:29 francharb We are working on the manual translation
13:29 francharb quick question
13:29 francharb hello #koha
13:28 kivilahtio and storing a couple million extra int(11) in DB wont make any difference
13:28 kivilahtio well it would make things easier
13:28 kivilahtio hmm
13:28 Joubu unique key I meant
13:28 Joubu but biblionumber should be a key as well
13:27 kivilahtio marcxml was moved to biblio_metadata
13:27 Joubu definitely not on the same bug report if you want to do it
13:27 kivilahtio Joubu: in the biblioitems-table we had marcxml. primary keyed with biblioitemnumber
13:27 kivilahtio Joubu: my suggestion is to copy biblioitemnumber
13:27 Joubu copying
13:27 Joubu s/you/we
13:27 Joubu kivilahtio: you are coping biblionumber, so it does not make sense to call it biblioitemnumber
13:26 vfernandes charset = utf8
13:26 vfernandes Joubu: collation = utf8_unicode_ci
13:26 kivilahtio I can mash the change to biblioitemnumber-column in the mix
13:25 kivilahtio but so we respect the legacy and maybe make it easier to migrate to FRBR (BibFrame etc)
13:25 kivilahtio this is bug afaik
13:25 kivilahtio yes
13:24 Joubu IIRC if you have biblionumber != biblioitemnumber you are going to get wrong things
13:24 kivilahtio shouldn't it have a biblioitemnumber-column, just for old time's sake?
13:23 kivilahtio biblio_metadata has a biblionumber-column
13:23 Joubu vfernandes: check the charset and collate of your tables
13:23 kivilahtio but the point is
13:23 kivilahtio then things start to work really interestingly
13:23 kivilahtio except when they get out of sync during a data migration
13:22 kivilahtio this is a nice idea, but nobdy really cared for it and now biblionumber and biblioitemnumber are used interchangeably
13:22 kivilahtio and the marcxml was tied to the biblioitems-table
13:22 kivilahtio Joubu: also. In Koha there once was a great idea that one biblio-entry can have multiple biblioitems
13:19 vfernandes all mysql variables are in utf8
13:19 vfernandes removing the line which enables mysql_enable_utf8 on C4::Installer the languages appears correctly
13:18 vfernandes i'm doing a fresh koha install and the languages descriptions have some encoding problems
13:17 vfernandes can anyone help me on a encoding problem?
13:17 kivilahtio hiii
13:17 vfernandes hi #koha
13:09 kivilahtio considering the global economic situation 38.7 is not that bad :)
13:09 kivilahtio havent had 38.7 degrees celsius temperature in a decades
13:09 tcohen spelled
13:09 Joubu ha but I created the table actually, 'just' not filling it when deleting
13:09 tcohen however it is written!
13:08 tcohen yay! diarrhea!
13:08 kivilahtio erm kid
13:08 kivilahtio It comes with the kids
13:08 kivilahtio yeah
13:08 Joubu happy to know
13:08 kivilahtio I am barely alive
13:08 kivilahtio I had the mostests horrible stomach diarrhea whatever this weekend, phew
13:07 kivilahtio Joubu: set status to 'me' and cc 'critical'?
13:07 Joubu kivilahtio: not sure what's the best actually
13:07 kivilahtio ok
13:06 Joubu kivilahtio: set the status 'critical' and cc me
13:06 kivilahtio Joubu: ok
13:06 Joubu kivilahtio: if you can, please do
13:05 kivilahtio Joubu: will you provide a followup or will I?
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:04 kivilahtio Joubu: looks like it
13:00 Joubu kivilahtio: oops
12:57 kivilahtio hmm, better to look with Koha::Biblio::Metadata to find the way instead of biblio_metadata
12:49 kivilahtio Joubu: where is deletedbiblio_metadata created when a biblio is deleted?
12:49 tcohen ask joubu
12:49 tcohen kivilahtio: i haven't looked at that code yet
12:47 kivilahtio tcohen: where is deletedbiblio_metadata created when a biblio is deleted?
12:46 kivilahtio morning
12:45 tcohen morning
12:33 kivilahtio Looks like there is a table 'deletedbiblio_metadata', but where is it populated...
12:08 kivilahtio who might not realize the change
12:08 kivilahtio for some libraries with peculiar annual staistical gathering needs (like us)
12:08 kivilahtio we can just cut the CASCADE from our DB but this might be a bigger issue
12:06 kivilahtio ...
12:06 kivilahtio information in marcxml is needed to accurately categorize the item
12:06 kivilahtio for example item has been ordered, received, and removed from collection during the statistics period
12:06 kivilahtio this is a challenge for gathering statistics
12:05 kivilahtio previously the marcxml was preserved in the oldbiblioitems-table
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:04 kivilahtio One note though
12:04 kivilahtio biblio_metadata++
11:36 huginn` cait: The operation succeeded.
11:36 cait @later tell Joubu can you please take a look at my coment on bug 17951?
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:35 cait e
11:35 cait khall: can you please push the tiny patch on bug 7143? correction of a dev's nam
10:48 magnuse i want to hack up something RDFy for y'all to look at during the hackfest
10:47 magnuse i will probably wait too long...
10:47 magnuse yup
10:46 cait two
10:46 cait but not quite yet, wait another day or wo
10:46 cait yep you should :)
10:46 * magnuse should translate...
10:46 magnuse cait++
10:45 cait we will have string freeze tomorrow
10:45 cait everything from master but 2-3 patches i still have to look at has been reviewed and pushed
10:45 cait :)
10:44 magnuse ah, pushed to stable. never mind!
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 cait: bug 17940
10:44 magnuse no, not that one
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:43 magnuse bug 17985
10:41 magnuse one sec
10:41 magnuse cait: there is a bug report i have been meaning to check out
10:33 eythian that video.
10:32 cait is there anything urgent that should be included in 16.11.05?
10:28 huginn` eythian: The operation succeeded.
10:28 eythian @later tell rangi https://www.youtube.com/watch?v=DFM140rju4k
10:00 magnuse moin drojf
09:26 drojf cool
09:26 fridolin we are preparing sandboxes for HF
09:26 drojf i should put a not on the page
09:26 fridolin thanks a lot
09:26 drojf woohoo
09:26 fridolin drojf: it wooooooooorks
09:26 fridolin ah i test
09:25 drojf i think thats the way
09:25 drojf deb [trusted=yes] https://apt.abunchofthings.net/koha-nightly unstable main
09:25 drojf you can add [trusted=yes] to the deb line
09:25 drojf ah
09:24 fridolin N: Updating from such a repository can't be done securely, and is therefore disabled by default.
09:24 fridolin drojf: ah thanks : E: The repository 'https://apt.abunchofthings.net/koha-nightly unstable Release' is not signed.
09:24 eythian drojf: that's my line
09:23 drojf fridolin: what happens when you try?
09:21 fridolin I have added repo https://apt.abunchofthings.net/koha-nightly but i cant update it
09:20 fridolin drojf: hie there, do you have a sec for me ?
09:10 drojf hei magnuse
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:08 magnuse @wunder enbo
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:05 drojf @wunder txl
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 berlin, germany
08:57 drojf hi eythian
08:57 eythian hi drojf
08:56 drojf hi #koha
08:21 magnuse summery!
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 @wunder enbo
08:21 * magnuse waves
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:18 LibraryClaire @wunder konstanz
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 eythian @wunder ams
08:17 eythian hi
08:00 alex_a bonjour
07:44 gaetan_B hello
07:38 reiveune hello