IRC log for #koha, 2015-02-04

All times shown according to UTC.

Time S Nick Message
00:01 tcohen do i make any sense?
00:05 dcook Well, that's not a multi-elementset really
00:06 dcook As zebra::facet is the element
00:06 dcook But yeah, I getcha
00:07 dcook Makes you wonder what performance would be like to do each facet query separately..
00:07 dcook What happens if one of those facet indexes doens't have anything in it?
00:07 dcook Does it take down the whole query?
00:07 * dcook seems to recall that it might
00:07 dcook Also this tokenization thing is driving me a bit bonkers
00:08 tcohen we currently loop on the defined facet indexes
00:08 tcohen and what i was saying is what you wrote
00:08 tcohen i'm looking at zebra's code
00:08 tcohen to make it skip the one that is not there, instead of aborting
00:14 dcook Mm, that would be great
00:14 dcook And reasonable :)
00:18 NateC joined #koha
00:18 dcook Hmm... some of the rules that we're using in words-icu.xml don't do what we think they do, me thinks
00:25 tcohen which is the fastest Perl XML parser?
00:25 eythian probably something with -xs in the name
00:25 eythian though, I think Lib::XML uses libxml anyway
00:26 eythian XML::LibXML rather
00:26 Dyrcona XML::LibXML is the fastest one that I've used.
00:26 dcook Yeah I think XML::LibXML alreayd uses libxml
00:26 Dyrcona It does.
00:29 tcohen thanks, will give it a try
00:29 tcohen night everyone
00:37 dcook night tcohen
00:37 eythian bye
00:54 rocio left #koha
00:57 dcook This guide doesn't seem to be totally right...[…]rms/general/rules
00:57 dcook "A left curly brace marks the start of a context rule."
00:57 dcook Yet, they show a right curly brace.
00:58 dcook This is kind of neat though:
01:00 eythian wahanui: sneak peak is a stealthy mountain
01:00 wahanui OK, eythian.
01:03 dcook Also:   <transliterate rule="[:Number:] { '-' > '' "/> doesn't replace - with nothing, it replaces - with a '
01:04 dcook Which gets munched up by "  <transform rule="[[:WhiteSpace:][:Punctuation:]] Remove"/>" later on anyway though
02:03 dcook @later tell cait I might have some ideas about why ICU is not doing nice things with parentheses...
02:03 huginn dcook: The operation succeeded.
02:03 dcook Wow... when did it become afternoon? Yikes...
02:07 eythian three hours ago
02:09 dcook Yeah, the light still looks like morning light
02:10 dcook :S
02:10 dcook This Zebra thing is a bit annoying
02:10 dcook I've learned all the things, and I'm convinced that it must be a bug
02:10 dcook tcohen has had good luck contacting Indexdata, but I don't know if anyone else ever has...
02:11 dcook Of course, it doesn't affect people using the Koha packages, since it uses an older version of Zebra
02:11 dcook So I guess that's good
02:11 dcook But what a pain
02:11 wahanui rumour has it a pain is when you find all kind of regressions
02:17 eythian dcook: for now, when jessie comes out it'll be the newer version
02:17 dcook Mmm, right. I was thinking about that this morning.
02:18 dcook That could be bad
02:18 eythian yeah
02:18 eythian solvable, but very annoying
02:18 dcook How is it solvable?
02:19 eythian require people to use indexdata, or something like that.
02:19 eythian well
02:19 eythian assuming they fix it
02:19 dcook Yeah, assuming they fix it
02:19 eythian I was mostly thinking of the case of them fixing it and debian not updating.
02:19 dcook Would that work after installing Zebra from Debian first though?
02:19 eythian probably
02:19 dcook Same
02:19 dcook Hmm
02:19 dcook I guess so eh
02:20 dcook I mean...
02:20 dcook I wonder what the package name is..
02:20 dcook I think it's the same?
02:20 eythian What would be best (from my pov) would be to figure it out with indexdata asap, and report a bug in debian which may cause it to get updated before the release.
02:20 eythian I think so
02:20 * dcook gives thumbs up
02:21 dcook Do you have Koha on any Ubuntu 14.10 installs?
02:21 dcook 14.04 is still using Zebra 2.0.44
02:21 dcook I suppose I could just look this up too..
02:21 dcook Is 14.10 Vivid?
02:21 dcook 2.0.59 :/
02:22 dcook No, Vivid is the one after..
02:22 dcook 14.10... Utopic... still on 2.0.44
02:23 dcook Although April 2015 for 15.04... that's not far away
02:23 dcook Yeah, Jessie also uses 2.0.59
02:24 eythian heh, my only 14.10 install is for the ES demo
02:24 eythian so not a useful test
02:24 dcook Already looked it up anyway. It should be fine :)
02:24 dcook :p
02:24 dcook @later tell tcohen How did you go about contacting Indexdata about the facets? Did you email Adam directly?
02:24 huginn dcook: The operation succeeded.
02:31 dcook I suppose it still only affects ICU users...
02:31 dcook I think we only have one ICU install
02:31 dcook Almost everyone else is on CHR
02:34 eythian doesn't ID have a mailing list or something?
02:35 dcook Yeah, they have heaps
02:36 dcook I signed up for one but haven't been confirmed yet
02:36 dcook I might be able to just send to it, but...
02:36 eythian dcook: do you know anything about tweaking relevancy rankings in zebra, e.g. to make the title more important?
02:36 dcook Yep
02:37 eythian any pointers?
02:37 dcook Sure :)
02:37 dcook I'll get a link
02:37 dcook You have to have QueryWeightedFields on
02:37 dcook And it has to be working, so I think QueryAutoTruncate must be off..
02:37 dcook Balls... at least I used to know this
02:37 dcook Give me a sec
02:38 dcook Ah, yeah, right
02:38 dcook Ok
02:38 dcook So go to "_build_weighted_query"
02:38 eythian ta
02:38 dcook There are rankings for "Title-cover", "ti,ext" and "ti,phr"
02:39 dcook "r1", "r2", "r3" respectively
02:39 dcook So then go to ""
02:39 dcook And just increase the values for those
02:39 dcook r1 9=32
02:39 dcook r2 9=28
02:39 dcook r3 9=26
02:40 dcook "9" is a special Zebra type
02:40 dcook[…]ymodel-zebra.html
02:40 dcook So "9=30" is a weight of 30, "9=20" is a rank of 20, and so on
02:40 eythian I see
02:41 eythian so it might be enough for them to turn on QueryWeightedFields
02:41 dcook Possibly
02:41 dcook Do their search results come back in biblionumber order?
02:43 dcook Hmm, I might be looking at an old version of
02:43 dcook It might not just be QueryAutoTruncate
02:43 dcook I think it's anytime there is truncation
02:43 dcook It will turn off QueryWeightedFields
02:43 dcook :D
02:45 dcook Now what was I doing...
03:05 dcook That moment when you go to paste something into a commit message, and you have absolutely no idea where the text came from...
03:41 ngourlay joined #koha
03:44 mtj hey peeps, has GRS1 been finalyl removed from koha?
03:47 eythian I don't think so
03:47 eythian I think it's planned though
03:48 mtj i see the warnings for GRS. in 3.18.x
03:49 mtj so..perhaps 3.20 might be when GRS gets finally chopped
03:50 mtj all good, i think i answered my own question :)
04:01 dcook Yeah, I think it's scheduled for departure, but that's about it
04:05 chrisvella joined #koha
04:23 dcook Hmm... do Americans write "lightsaber" or "lightsabre"?
04:24 eythian Probably the former
04:24 dcook Probably
04:24 dcook Also
04:24 dcook I mean...
04:24 dcook Don't actually read it
04:25 * dcook doesn't actually want to talk about star wars
04:25 dcook Well, maybe star wars but not Star Wars
04:26 dcook Oh goody, my db is loaded
04:36 dcook Hmm bug 13242 is still causing this guy problems..
04:36 huginn Bug[…]_bug.cgi?id=13242 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Slow checkin for patrons restricted indefinitely
04:39 dcook This looks like a job for Devel::NYTProf...
04:41 dcook nytprof?
04:41 wahanui rumour has it nytprof is just amazing
04:41 dcook nytprof?
04:41 wahanui nytprof is, like, just amazing
04:41 dcook nytprof?
04:41 wahanui nytprof is just amazing
04:41 dcook nytprof is[…]th_Devel::NYTProf
04:41 dcook nytprof?
04:41 wahanui somebody said nytprof was just amazing
04:41 dcook nytprof?
04:41 wahanui nytprof is probably just amazing
04:41 dcook nytprof?
04:41 wahanui nytprof is just amazing
04:41 dcook nytprof is also[…]th_Devel::NYTProf
04:41 wahanui okay, dcook.
04:41 dcook nytprof?
04:41 wahanui i heard nytprof was just amazing
04:41 dcook nytprof?
04:41 wahanui rumour has it nytprof is[…]th_Devel::NYTProf
04:53 dcook Now to interpret the results..
04:57 dcook Ahhh, because I missed part of the fix
05:05 dcook Huzzah
06:20 laurence joined #koha
06:59 cait joined #koha
06:59 cait good morning #koha
07:14 cait left #koha
07:16 rangi evening
07:28 * magnuse waves
07:31 * magnuse starts the day by writing a new contract
07:43 libland /me nods
07:43 libland ops hehe
07:43 paul_p joined #koha
07:43 libland hmm not used to Irssi
07:43 libland Anyway, hey all
07:44 reiveune joined #koha
07:45 reiveune hello
07:48 Viktor joined #koha
07:48 jenkins_koha Starting build #43 for job Koha_3.18.x_U14 (previous build: SUCCESS)
07:48 drojf joined #koha
07:48 magnuse hiya libland paul_p reiveune Viktor drojf
07:49 sophie_m joined #koha
07:49 sophie_m hello #koha
07:49 libland hey sophie_m
07:49 wahanui i guess sophie_m is looking for a .mrc file to import into the catalog
07:49 Viktor Hi magnuse and #koha
07:49 sophie_m thanx wahanui, I've got plenty ;)
07:50 drojf hi #koha
07:50 drojf hei magnuse
07:53 Viktor joined #koha
07:59 sophie_m joined #koha
08:01 alex_a joined #koha
08:02 alex_a bonjour
08:02 libland hey alex_a
08:03 fredericd joined #koha
08:04 cait joined #koha
08:04 magnuse kia ora cait
08:07 libland joined #koha
08:07 libland there we go
08:12 * libland is excited - setting up a Koha for the first time  in this very moment.
08:13 libland I've been tasked to 'get to know Koha'. :)
08:14 libland pleasant task, I believe.
08:14 kivilahtio libland: you bet
08:14 kivilahtio libland: Koha is so cool
08:14 kivilahtio[…]eveloper_handbook
08:15 kivilahtio[…]Coding_Guidelines
08:15 kivilahtio[…]_bz_configuration
08:15 kivilahtio[…]Control_Using_Git
08:15 libland Yes, this will bring so many good things!
08:15 libland brilliance - thanks kivilahtio
08:15 kivilahtio
08:15 kivilahtio
08:15 wahanui are you looking here?
08:15 codavid joined #koha
08:15 kivilahtio
08:15 wahanui are the better stats to optimise
08:16 kivilahtio
08:16 kivilahtio
08:16 magnuse libland: how are you installing? packages?
08:16 kivilahtio or Eclipse EPIC are my weapons of choice
08:16 kivilahtio pick your poison
08:16 kivilahtio those are what I mostly need for my day-to-day stuff
08:17 * libland nods
08:17 kivilahtio
08:17 kivilahtio have fun!
08:17 rangi
08:17 libland kivilahtio: Thanks a lot!
08:17 kivilahtio should get you started
08:17 libland I love Vim.
08:17 libland ;)
08:17 kivilahtio you can use Vim
08:17 rangi also
08:17 kivilahtio actually... funny enough Vim is the tool-of-choice fior the LPI
08:18 libland I guess I'll have to 'get to know' Perl as well in this process
08:18 rangi there are some handy vim config tips on that page, that make editing perl much easier
08:18 libland rangi: Wonderful!
08:19 kivilahtio Also when i did my technology push for Vim, I used a mod-package for Vim. google for "spf13 vim"
08:19 kivilahtio has a ton of stuff for Vim. Too bad I never learned to like Vim, not even the graphical version. Just doesn't beat a proper IDE.
08:20 libland I've been using Vim with Python mainly
08:20 libland I tried to switch to SublimeText, but had to revert back to Vim.
08:21 libland Guess it's because Vim does things it's own ways all the way - and when you get used to that...
08:21 kivilahtio libland: I think so
08:21 libland it's hard to switch
08:22 rangi once you learn the shortcuts, there's nothing faster
08:22 kivilahtio rangi: I agree :)
08:22 libland rangi: Aye, that's how it is.
08:22 rangi the main reason i use it, is cos its on all the servers
08:22 kivilahtio yeah, nano is a bit clumsy
08:22 libland Started to use Vim to be able to work remotely in commandline
08:22 kivilahtio rangi: I just push from my Dev-environment to the servers the code changes
08:23 kivilahtio rangi: I have a centralized vaersion which is replicated to all the shards
08:23 kivilahtio if i make changes downstream and forget about that, then overwrite with upstream version.... bad things happen...
08:23 rangi yep, we do that ... well we roll packages and update them, for code changes
08:24 rangi but sometimes you need to edit a config file or 2
08:24 kivilahtio i use nano, shoot me
08:24 rangi our sysadmins would :)
08:24 rangi well, you wouldn't be able to, nano is purged on the servers
08:24 rangi :)
08:25 kivilahtio luckily I know JUST enough Vi
08:26 libland Oh, this IS exciting: The library I work on is seriously looking into switching the expensive crap system for Koha.
08:27 libland but, guess it won't be a easy road to get there
08:27 libland uh, sorry. English not my native.
08:28 magnuse yay for getting rid of expensive crap! :-)
08:28 libland Indeed
08:28 rangi you are from sweden?
08:29 libland Yes.
08:29 kivilahtio we got an ultimatum from our expensive crap proveder to stop acessing their database
08:29 kivilahtio to migrate another system to our Koha
08:29 rangi libland:[…]ary-chooses-koha/
08:29 rangi ammo
08:29 kivilahtio ammo?
08:29 * libland nods
08:30 libland that's part of the reason I'm in here :)
08:30 rangi kivilahtio: ammo to convince the powers to be, its always easier to not be the first :)
08:30 kivilahtio rangi: tell me about it
08:30 kivilahtio rangi: but we broke the ice
08:30 gaetan_B joined #koha
08:30 libland Gotta go - but bbl!
08:30 libland nice to meet you all
08:30 rangi cya later libland
08:31 kivilahtio rangi: and we are hardly hte first. We always tell that "there are 3000 libraries worldwide using Koha"
08:31 gaetan_B hello
08:31 kivilahtio I just heard it on the IRC :)
08:31 reiveune joined #koha
08:31 kivilahtio gaetan_B: hi
08:31 wahanui kia ora, kivilahtio
08:31 rangi theres about 8000 now
08:31 kivilahtio proooooo
08:31 rangi theres 2000 just in turkey and argentina alone
08:31 kivilahtio rangi: how do you know?
08:31 rangi i know there are 3000ish in libwebcats
08:31 kivilahtio rangi: why I don't see them contributing to the master branch?
08:32 rangi
08:32 kivilahtio rangi: or would it be even a good thing :)
08:32 rangi and that doesnt include any of the turkish, and most of the argentinian ones
08:32 kivilahtio rangi: I fear htere are so many organisations having so different needs that Koha might end up as an onmanageable mess
08:32 kivilahtio luckily we have only improvements, not mess :)
08:33 rangi thats why we have qa teams :)
08:33 rangi we've made it 15 years now :)
08:33 sophie_m joined #koha
08:34 * rangi gets to legitimately claim to doing the first koha library :-)
08:35 kivilahtio rangi: we love you
08:35 fridolin joined #koha
08:38 Joubu hello
08:38 wahanui hola, Joubu
08:39 rangi hi Joubu
08:39 Joubu I arrive during a declaration of love
08:39 rangi heh
08:41 ashimema monring #koha
08:42 ashimema morning.. even
08:43 ashimema your up late aint you rangi
08:45 rangi its not quite 10pm yet
08:46 rangi trying to finish off some stuff while its quiet and the kids are asleep
08:46 ashimema earlier than I thought then.. don't often see you in here this sort of time 'tis all..
08:47 ashimema I'll leave you to it then as your busy.. have a good night :)
08:47 rangi nope
08:47 rangi usually i try and log off in the evenings :)
09:03 rangi @wunder nzwn
09:03 huginn rangi: The current temperature in Wellington, New Zealand is 19.0°C (9:30 PM NZDT on February 04, 2015). Conditions: Partly Cloudy. Humidity: 73%. Dew Point: 14.0°C. Pressure: 29.50 in 999 hPa (Rising).
09:09 magnuse @wunder boo
09:09 huginn magnuse: The current temperature in Bodo, Norway is -8.0°C (9:20 AM CET on February 04, 2015). Conditions: Clear. Humidity: 58%. Dew Point: -15.0°C. Windchill: -18.0°C. Pressure: 29.98 in 1015 hPa (Rising).
09:09 magnuse f'ing windchill
09:09 magnuse @wunder marseille
09:09 huginn magnuse: The current temperature in Saint Victoret, France is 3.3°C (9:59 AM CET on February 04, 2015). Conditions: Partly Cloudy. Humidity: 92%. Dew Point: 2.0°C. Windchill: 3.0°C. Pressure: 29.54 in 1000 hPa (Rising).
09:10 magnuse hm Saint Victoret, France != marseille
09:11 dbs joined #koha
09:17 libland Ok then, let's do this.
09:24 * magnuse cheers libland on from norway
09:25 * libland waves at magnuse from a distant part of Sweden, 'Gotland'.
09:25 Joubu magnuse: it looks close to Marseille :)
09:26 drojf koha is booming in sweden now? :)
09:27 libland drojf: Certainly seems like it!
09:29 otuoma joined #koha
09:29 drojf libland: excellent!
09:30 magnuse yeah, lots of koha action in sweden :-)
09:31 magnuse Joubu: yeah, not too far
09:31 * otuoma slaps chris_n around a bit with a large fishbot
09:32 otuoma left #koha
09:34 Joubu Does someone know if tcohen has found a solution for the zebra facets perf?
09:36 Otuoma joined #koha
09:39 Otuoma Hello, my koha installation downloads a PL file whenever I try to access either the opac or intranet. It is running on Ubuntu 14.04 LTS and the error logs in /var/log/koha/ all seem to be empty. Kindly assist a brother
09:41 rangi an[…]hooting_Ubuntu_14.04
09:41 rangi hmm
09:41 rangi[…]hooting_Ubuntu_14.04
09:41 rangi try that
09:41 rangi the 3rd thing in that troubleshooting section is what you need to do
09:42 rangi Joubu: i think he got distracted by the fact that facets dont work at all in zebra 2.0.59
09:43 Joubu rangi: ok thanks. He pm me "Set FacetMaxCount to 10"
09:43 Joubu but this pref is not used for facets retrieved from zebra
09:44 Otuoma <@rangi> It works like a charm. THANKS A LOT.
09:44 rangi Joubu: when it comes to facets ... this is me
09:45 Joubu it's me when it's zebra related...
09:49 Joubu ha no, the pref is used!
09:54 reiveune1 joined #koha
09:56 Joubu it comes from ZOOM::Record->raw, 2 or 3 sec is spent (per faceted index!) in it
09:57 rangi ahh
09:57 rangi so not zebra itself
09:58 rangi it usually isnt, zebra would be awesome if it was documented .. all our problems come from having no idea how to use it properly
09:58 Joubu no, it seems to come from the line my $facet = $rs->record( 0 )->raw;  in C4::Search::_get_facet_from_result_set
09:58 rangi right
10:00 rangi so thats MARC::Record
10:00 rangi hmm no
10:00 rangi it should be returning xml
10:02 * Joubu is lost in Net::Z3950::ZOOM
10:02 * magnuse gets ready to assemble a rescue squad
10:02 alex_a joined #koha
10:03 Joubu rangi: yes, $facet is a xml string, and quite light, only 20 lines
10:07 rangi i wonder if its worth trying thi
10:07 rangi s
10:07 rangi The record() method returns a ZOOM::Record object representing a record from result-set, whose position is indicated by the argument passed in. This is a zero-based index, so that legitimate values range from zero to $rs->size()-1.
10:07 rangi The record_immediate() API is identical, but it never invokes a network operation, merely returning the record from the ResultSet's cache if it's already there, or an undefined value otherwise. So if you use this method, you must always check the return value.
10:08 rangi so $facet = $rs->record_immediate(0)->raw;
10:09 rangi since we are doing
10:09 rangi return if !defined $facet;
10:11 Joubu $rs->record_immediate(0) returns undef
10:11 rangi darn
10:11 rangi does it at least do it fast? :)
10:12 Joubu yep
10:16 rangi so yeah that does seem to suggest its the ->raw bit that is the slow bit
10:16 reiveune joined #koha
10:16 Joubu rangi: no, it's def the ->record
10:16 Joubu (I split the ligne my $record = $rs->record; my $facet = $record->raw; with a check point time between, and the 3 sec is spent in ->record)
10:17 rangi ah right
10:18 * rangi has to go to sleep, good luck finding it in the maze of perl and C
10:18 Joubu night rangi!
10:18 cait hi libland :)
10:18 cait oh... scrolling broken again.
10:20 cait night rangi... :)
10:21 cait @wunder Reutlingen
10:21 huginn cait: The current temperature in Reutlingen, Roemerschanze, Reutlingen, Germany is -4.9°C (11:21 AM CET on February 04, 2015). Conditions: Light Freezing Fog. Humidity: 77%. Dew Point: -8.0°C. Windchill: -5.0°C. Pressure: 29.77 in 1008 hPa (Steady).
10:23 kivilahtio All you facet-builders. I've got one word for you... Elastic :)
10:28 Joubu hum, you need more words to integrate it into Koha ;)
10:30 magnuse a section detailing config variables that could/should be added to koha-conf.xml might be a nice addition for future elease notes
10:36 kivilahtio Joubu: touché :D
10:37 Joubu any zebra/zoom export around?
10:39 Joubu $rs->size; returns the number of results, so if you search for "d", it's 972k, if I search for "temps modernes", it returns 97
10:40 Joubu in the first case, the max time spent in the calculation facet sub is 3 sec, in the second case, it's 1.27
10:41 Joubu which is logical, I think
10:41 Joubu I should try to use yaz-client
10:48 Joubu 1.4sec with yaz-client...
10:48 Joubu looks like 1M records is a little bit to much
10:49 drojf left #koha
11:01 tcohen joined #koha
11:09 cait Joubu++ :)
11:09 cait hey dro
11:09 cait was going to say hi to drojf...b ut he left. need new glasses i guess.
11:10 tcohen morning
11:11 tcohen @later tell dcook I wrote to, Adam and Mike answered alternatively
11:11 huginn tcohen: The operation succeeded.
11:14 Joubu hi tcohen: I have just finished to fill a bug (bug 13665) with what I did this morning
11:15 huginn Bug[…]_bug.cgi?id=13665 major, P5 - low, ---, gmcharlt, NEW , Retrieve facets from zebra is slow
11:15 cait morning tcohen
11:15 paul_p joined #koha
11:15 ngourlay joined #koha
11:16 khall mornin #koha!
11:16 libland hello khall
11:19 cait libland: you are from sweden?
11:28 codavid left #koha
11:28 khall mornin libland!
11:28 khall mornin cait!
11:30 cait morning khall :)
11:30 libland cait: Yes, I am.
11:30 cait nice :)
11:30 cait are you from the uni?
11:31 cait ah, gotland, sorry, getting confused today
11:31 libland hehe no worries
11:32 libland Though, the library I work at is 50% uni lib (Uppsala)
11:33 cait :)
11:34 cait running off to lunch now - cya around
11:34 libland cya!
11:41 gaetan_B lots of scandinavian interest in Koha lately, this is nice :)
12:00 magnuse it's kinda starting to take off, yeah
12:13 tcohen joined #koha
12:15 tcohen morning, again
12:15 tcohen Joubu: have you seen Template::Plugin::URL, we could use it for safely building URLs
12:16 Joubu tcohen: yes, but we need to change all urls in the code
12:16 tcohen =D
12:17 jwagner joined #koha
12:17 alex_a joined #koha
12:21 tcohen Joubu: I'm loading a 1.5M to try to reproduce
12:21 tcohen i've seen that linear time-size relation regarding the facet size
12:22 Joubu tcohen: do you know if there is a way to retrieve all facets with one query?
12:22 tcohen i talked about that last night
12:22 tcohen we need to patch zebra
12:22 tcohen it doesn't seem difficult
12:22 tcohen i've been playing last night
12:22 tcohen but didn't manage to compile it :-D
12:24 paul_p joined #koha
12:25 tcohen Joubu: try elem zebra::facet::au:0:20,se:0:20,su:0:20
12:25 tcohen you will get the three requested facets values
12:26 tcohen but it will completely fail if one of those isn't initialized
12:26 tcohen ^that's the problem
12:26 tcohen jcamins suggested me to try indexing a "ghost" record with all facets
12:26 tcohen i left it on the TODO area
12:27 Joubu Not sure to understand what is the difference with the current code
12:27 reiveune joined #koha
12:28 Joubu _get_facets_from_zebra loops on the $facets_loop
12:28 Joubu we just have to construct the facet_element in _get_facets_from_zebra and don't loop on facets
12:29 tcohen Joubu: that'd be awesome, but zebra returns an error if one of those facets is not already populated on its db
12:30 tcohen (i.e. is not initialized)
12:31 Joubu tcohen: isn't it what we already do?
12:31 tcohen idiomatic issues i think, let me re-read
12:33 tcohen Joubu: you mean like building elem zebra::facet::au:0:20,se:0:20,su:0:20... and call it only once?
12:34 Joubu no, that what I would like to do
12:34 Joubu atm, we set elem zebra::facet::IDX:0:20
12:35 Joubu but what's happen if the IDX does not exist?
12:35 Joubu we don't check if it exists in the zebra index
12:38 tcohen yes, we don't
12:39 tcohen we just skip the zero-results query
12:39 tcohen which is, I think, ok
12:40 tcohen what we WANT to do is to build a single elementSet with all defined facets (calculated in runtime)
12:40 tcohen like zebra::facet::au:0:20,se:0:20,su:0:20...
12:40 tcohen and have Zebra return all of them, wheter there's one that doesn't have data
12:40 tcohen or not
12:42 Viktor joined #koha
12:44 magnuse Viktor and libland - have you two met?
12:45 Viktor Not quite sure - Gotland?
12:45 magnuse sounds like it
12:45 wahanui somebody said sounds like it was beer o'clock for you dcook? ;)
12:46 Viktor libland - Nice to see other swedes here :) Viktor Sarge over here that works at project manager for Halland (mostly Hylte) and do some smaller coding tasks.
12:48 Viktor Better coders than me: Is the file ending .tmpl finally deprecated now? I had to change an old patch to use .tt to get it working again.
12:49 meliss joined #koha
12:49 Joubu Viktor: yes .tmpl for html::template, .tt for template::toolkit
12:52 reiveune1 joined #koha
12:53 Viktor Thanks Joubu! I thought it was weird when I discovered we were using template::toolkit but things were still named .tmpl and translated into .tt somewhere along the line.
12:55 Joubu Viktor: it should be fixed on 3.18
12:58 Viktor Joubu: Ah so that's why I had to use the sane file ending :) Good.
13:12 reiveune1 left #koha
13:12 reiveune1 joined #koha
13:24 edveal joined #koha
13:25 Dyrcona joined #koha
13:29 cait Joubu: do you know if pending_offline_operations gets emptied out when the operations are no longer pending?
13:33 paul_p joined #koha
13:36 * tcohen thinks Joubu is having lunch
13:39 cait probably
13:39 cait setting up a test
13:46 mimsy joined #koha
13:47 reiveune joined #koha
13:48 NateC joined #koha
13:52 oleonard joined #koha
13:53 carmen joined #koha
14:04 akafred joined #koha
14:09 JoshB joined #koha
14:12 Joubu cait: I don't know
14:12 paul_p joined #koha
14:34 gerundio joined #koha
14:44 carmen joined #koha
14:51 amyjeankearns joined #koha
15:03 cait it#s ok, i found it out
15:16 rocio joined #koha
15:24 talljoy joined #koha
15:33 TGoat joined #koha
15:43 cait deleted after processing them
15:50 paul_p joined #koha
15:54 cait @later tell drojf ping me
15:54 huginn cait: The operation succeeded.
16:05 cait hm is bugzilla dead?
16:21 cait seems ok now
16:21 nengard joined #koha
16:33 rsz_ joined #koha
16:34 rsz_ left #koha
16:47 tcohen cait: I think I busted my ubuntu
16:48 Dyrcona tcohen: You sure your Ubuntu didn't bust itself? ;)
16:48 * Dyrcona commiserates.
16:48 tcohen mysql started raising errors
16:48 tcohen i think it is the hard drive
17:13 drojf joined #koha
17:16 JoshB joined #koha
17:25 fridolin left #koha
17:27 gaetan_B bye
17:27 reiveune bye
17:27 reiveune left #koha
17:45 rsz_ joined #koha
17:47 rsz_ hi, I have done sudo apt-get install koha-common (from[…]buntu_-_packages), I need to point this koha installation(koha-machine) to a pre-existing DB (mysql-machine)(with koha tables setup done), how to proceed?
17:48 rsz_ the problem is my /etc/mysql/koha-common.cnf file is not existing, do I create it?
17:48 rsz_ so how would the koha installation know the mysql server is at a differnt ip ?
17:49 rsz_ I have not installed mysql-server on koha-machine yet.. is it required.. if the db is elsewhere, then how would koha-common.cnf be generated?
17:49 tcohen rsz_: create it
17:50 rsz_ and *not* install mysql-server too ??
17:50 pastebot "tcohen" at pasted "rsz_: like this" (5 lines) at
17:51 rsz_ I have the format for koha-common.cnf, just do not want to mess this fresh install! :-)
17:51 tcohen you wont
17:51 tcohen also
17:51 tcohen set the instance parameters in /etc/koha/passwd
17:52 rsz_ I proceed without installing mysql-server, because I assume in my last attempt, mysql-server created these files!
17:52 tcohen instance_name:db_user:db_passwd:db_name
17:52 rsz_ I am yet to execute koha-create --request-db <library?
17:52 tcohen the workflow for using koha with an external db server is broken, you need to workaround it
17:52 rsz_ I am yet to execute koha-create --request-db <library>
17:53 tcohen exactly
17:53 rsz_ I am trying to overcome the slow response time as of now..
17:53 tcohen we should just use koha-create --use-db --db-host --db-user, etc, right? :-)
17:54 rsz_ I have had success with --request-db in last attempt, but need to redo these steps for colocated servers! :-)
17:55 tcohen fill koha-common.cnf, koha/passwd and create your instances with --request-db
17:55 rsz_ but reinstalling koha is a bit difficult untill you discover apt-get purge! :-)
17:55 tcohen broken workflow, but works
17:55 rsz_ aye aye captain! :-)
17:55 tcohen good luck \o
17:55 rsz_ thanks :-)
17:56 tcohen u r welcome, I'll be around anyway
17:58 rsz_ so, should I do --request-db or create-db with the remote pointing koha-common.cnf ?
17:58 rsz_ I am doubting --request-db as DB is already up & running!!
17:58 * rsz_ is confused!
17:59 tcohen exactly, it is counter-intuitive, hence broken
17:59 tcohen heh
17:59 tcohen use --request-db
17:59 rsz_ ok..
17:59 tcohen it is designed to be used with --populate-db
18:00 tcohen you ommit that step
18:00 tcohen me starts writing a patch so we use --use-db fr this purpose, damn it
18:00 rsz_ ok, right.. now I understand..
18:04 rsz_ I won;t get to /etc/koha/passwd (instance_name:db_user:db_passwd:db_name) untill I --request-db, right?
18:05 tcohen create it
18:30 cait left #koha
18:54 wnickc joined #koha
18:55 laurence left #koha
18:57 tcohen later #koha
18:57 sophie_m joined #koha
19:00 huginn New commit(s) kohagit: Bug 13320: Fix "Tax inc." vs "Tax exc." <[…]81c88ac92c5a3561c> / Bug 13320: Move price calculation from tt to pl <[…]a907b4d95f1bf1d79> / Bug 13599 - Add patron cardnumber to self registration confirmation <[…]b/?p=koha.git;a=c
19:01 cait joined #koha
19:12 gerundio joined #koha
19:19 gglitch joined #koha
19:21 magnuse joined #koha
19:26 gglitch Hi all. I'm a new librarian who's just inherited a small collection using Koha 3.14.01. Weirdly, my predecessor wasn't using Koha for circulation, so I don't now know what's in and out. My idea is to check everything out, then systematically check everything back in, leaving me a clear record of what I don't have in. Does anyone know (a) of a better idea for auditing my collection, or (b) how I can check everything out in Koha, en masse? Thanks very much.
19:26 cait maybe look at the inventory module
19:27 cait to find out what's not in the library
19:27 cait it's under tools
19:27 cait and you can check the manual on different ways of using it
19:30 gglitch Thanks cait - just to be clear, my problem is that the Koha catalog lists everything as checked in, because my predecessor never used it for circulation. I'm looking at the inventory module to see if it can be used to check everything out.
19:31 cait can't be used for that - but it's madeto check waht's on shelf - the rest would be out then
19:31 gglitch Thanks cait.
19:31 cait we can't do 'batch checkouts' from the gui easily... you could create a file using the offline circ format
19:40 JoeLib001 joined #koha
19:40 JoeLib001 Hello again everyone. :-)
19:41 JoeLib001 My Zebra Indexing and in fact all Searches for the Catalog is broken again. The messed up thing is that they were working 100% A ok lat night...
19:41 JoeLib001 *last
19:44 jenkins_koha Project Koha_Master_D7 build #299: UNSTABLE in 42 min: http://jenkins.koha-community.[…]ha_Master_D7/299/
19:44 jenkins_koha * Jonathan Druart: Bug 13544: Make it explicit that getauthtypes returns a hash ref
19:44 jenkins_koha * Kyle M Hall: Bug 13599 - Add patron cardnumber to self registration confirmation
19:44 jenkins_koha * Jonathan Druart: Bug 13320: Move price calculation from tt to pl
19:44 jenkins_koha * Jonathan Druart: Bug 13320: Fix "Tax inc." vs "Tax exc."
19:44 huginn Bug[…]_bug.cgi?id=13544 major, P5 - low, ---, jonathan.druart, Pushed to Master , admin/ does not compile in older perls
19:44 huginn Bug[…]_bug.cgi?id=13599 normal, P5 - low, ---, kyle, Pushed to Master , Add patron cardnumber to self registration confirmation
19:44 huginn Bug[…]_bug.cgi?id=13320 normal, P5 - low, ---, jonathan.druart, Pushed to Master , Some prices calculation are done in template side
19:51 hankbank joined #koha
20:18 gglitch cait: Thanks for your advice about the offline circulation function. This may work for me. Do you happen to know where the offline data is stored? I've searched for a .koc file, but come up empty handed. Is it sqlite data in my browser, or what?
20:19 gglitch (And thanks for the Inventory pointer too)
20:19 rangi morning
20:20 JoeLib001 Hello. :-)
20:22 nengard left #koha
20:29 cait gglitch:[…]ation_file_format
20:34 gglitch Still not seeing the location of the file, but I'm sure I'll find it. Thank you cait.
20:34 cait you'd have to make it
20:34 cait from scratch
20:34 cait with your barcodes
20:34 cait and the borrower you want
20:34 gglitch Ahhh...I see. Thank you.
20:59 JoeLib001 How do I attach a pastebin or what not here?
20:59 JoeLib001 NVm....I am blind...
21:00 pastebot "JoeLib001" at pasted "Suppress Breaking Things?" (10 lines) at
21:00 cait make sure that you have one suppressed record
21:00 cait and that it's indexed
21:00 cait it does always break search when there is none
21:01 cait or turn off opacsuppression and  try if that fixes it
21:01 JoeLib001 Even when it was set as don't hide?
21:01 JoeLib001 It was originally set to Don't hide.
21:01 cait hm then it would not show up in the zebra query
21:02 JoeLib001 Ahh..., I was running a test... XD
21:02 JoeLib001 I'm trying to figure out why I can't search for anything on the catalog.
21:02 JoeLib001 I thought everything was figured out last night 'cause it was working. Now this morning I can't find anything again.
21:03 cait is it still showing hte same error?
21:03 cait which version of zebraid are oyu using?
21:03 JoeLib001 2.0.44
21:04 cait hmm
21:04 JoeLib001 Zebra seems to be running too. When I run the command ps aux | grep zebra
21:06 JoeLib001 I've also restarted Zebra, and Re-Indexed Zebra, and Restarted Zebra again. XD
21:06 cait and suppression is off now?
21:07 JoeLib001 I was hiding records, but I can't see where the option was that I was hiding records.
21:07 cait ?
21:09 JoeLib001 Is the OPAC Suppresion option the only option for hiding records?
21:09 cait there is also opachiddenitems
21:09 cait but it would not break search
21:09 JoeLib001 I thought there was an option to hide them by item type.
21:09 JoeLib001 Ahh...
21:11 JoeLib001 Hmm..., yeah I theoretically shouldn't have any "suppresed" records then.
21:12 JoeLib001 I restarted the server after making sure opac suppression was set to don't hide. Still no joy.
21:12 cait hm
21:12 cait running out of ideas :(
21:13 cait it might be you messed up permissions or something like that
21:13 cait how are you reindexing?
21:13 JoeLib001 sudo koha-rebuild-zebra -f -v koha
21:14 JoeLib001 Would it be a problem, if I changed the zebra.passwd file?
21:15 cait it could be
21:15 cait why would you do that?
21:15 cait and did you change the koha-conf file accordingly?
21:15 JoeLib001 To set a specific user/pass for z39.50 access.
21:15 JoeLib001 All I did was change the user/pass for the Z39.50 stuff in that file.
21:16 cait you probably have non matching passwords now
21:16 cait with the koha-conf.xml file
21:17 JoeLib001 Hmm..., ok. I'll double-check that file.
21:19 JoeLib001 Ok, yeah. I think that's the issue. I'm restarting the server and then will check.
21:19 JoeLib001 Awesome, that fixed it. XD
21:19 JoeLib001 Thanks cait. :-)
21:20 cait glad we figured it out :)
21:53 eythian hi
21:56 JoeLib001 Hello. :-)
21:56 JoeLib001 cait fixed my brain. :-)
21:57 eythian she's probably replaced it with a robot one, but you won't know because it's telling you everything's fine.
21:57 JoeLib001 Hehehe
21:57 JoeLib001 I was having issues with Zebra again this morning.
21:58 JoeLib001 Turns out it's a good idea, if your zebra.passwd matches your koha-conf.xml file...
22:00 eythian that is traditional, yes
22:07 * wizzyrea is happy you figured it out.
22:21 tcohen joined #koha
22:30 cait night all
22:30 wahanui goodnight cait. You'll be back.
22:30 cait left #koha
22:34 wnickc joined #koha
22:37 dcook eythian: I'm glad that I sent that email to Indexdata. Based on the data I gave them, they seem to think it's a big deal, so they've filed the issue and said they'll get back to me :)
22:38 eythian nice
22:38 tcohen dcook++
22:38 rangi hey look, the system works!
22:38 rangi :)
22:39 dcook :D
22:39 dcook I seem to have this memory of someone saying Indexdata weren't responsive, but based on this experience and tcohen's experience with the facets, it seems like they're actually very responsive :)
22:39 dcook If I had more time and knew their source better, I'd even try a patch :p
22:40 tcohen i think i'd depend on their agenda/priorities
22:40 dcook Yeah, no doubt
22:40 dcook Thanks for the later as well, tcohen :)
22:41 rangi i think it helps that you two wrote up really good informative questions/queries
22:42 eythian It's all about the reproduceability
22:43 khall joined #koha
22:43 rangi yup
22:49 * tcohen broke its mysql-server setup, finally installed 5.6 and cannot run the installer
22:50 tcohen there was a bug for that, right?
22:50 jenkins_koha Yippee, build fixed!
22:50 wahanui o/ '`'`'`'`'`'`'`'`'`
22:50 jenkins_koha Project Koha_Master_D7 build #300: FIXED in 41 min: http://jenkins.koha-community.[…]ha_Master_D7/300/
22:51 dcook brb on phone about radioactive cat
22:53 eythian it's now a hulk cat
22:54 dcook Well, he's a ginger, so he can be a red hulk
22:55 dcook rangi/eythian: Yeah, hopefully the email had enough details. I don't think I missed anything, so it should be pretty easy to reproduce.
22:56 dcook tcohen: Sounds vaguely familiar?
22:56 tcohen dcook: fixed it, looking for the bug to provide a patch
22:57 dcook tcohen++
22:58 dcook Where's cait when you need her? She's the ultimate bug finder
22:58 dcook Well, hopefully she's asleep now..
22:59 tcohen anyone attending to marseille?
23:00 tcohen i offer a free beer for the one that finds the bug :-D
23:00 eythian would that I could :)
23:02 tcohen it seems someone mentioned it on the list, but wouldn't fill a bug
23:02 tcohen i can invite you the beer anyway eythian
23:02 eythian I just may not be able to make it.
23:05 dcook Huh...
23:07 pastebot "tcohen" at pasted "Is this kosher?" (5 lines) at
23:10 dcook Not sure about the order of operations, or even if it's called the order of operations
23:11 eythian tcohen: I think that's fine
23:11 magnuse joined #koha
23:12 tcohen thanks eythian, I think I'll set an error code instead of dying heh, but yes, it does the job
23:15 * eythian -> pizza
23:16 dcook Mmm pizza
23:16 * dcook just had breakfast
23:16 dcook But could totally go for lunch...
23:16 dcook And less DOMS
23:16 * dcook is unpleasantly sore
23:20 tcohen now we speak
23:21 tcohen @later tell oleonard how's that work on revamping the installer layout going?
23:21 huginn tcohen: The operation succeeded.
23:23 NateC joined #koha
23:24 dcook ashimema++
23:25 dcook Just noticed bug 12954
23:25 dcook Yikes...

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