IRC log for #koha, 2012-12-12

All times shown according to UTC.

Time S Nick Message
00:05 Irma joined #koha
00:06 BobB joined #koha
01:10 drojf1 joined #koha
01:20 tcohen joined #koha
01:26 eythian anyone have a copy of the group photo from KohaCon in Edinburgh?
01:27 wizzyrea i am CERTAIN it is on a website somewhere - maybe even koha-community.org
01:27 eythian ah yep, found it
01:27 wizzyrea sweet :)
01:27 eythian wahanui: kohacon
01:27 wahanui eythian: what?
01:27 eythian wahanui: kohacon photo
01:27 wahanui eythian: excuse me?
01:27 eythian wahanui: kohacon photo is http://www.flickr.com/photos/nengard/7162934703/
01:27 wahanui OK, eythian.
01:29 jcamins_away wizzyrea++
01:33 drojf1 joined #koha
01:45 wizzyrea what'd I do
01:45 wizzyrea >.>
01:45 wizzyrea <.<
01:45 jcamins The patch.
01:45 wahanui rumour has it the patch is pretty old now, good luck
01:45 wizzyrea OH
01:45 wizzyrea well yes :)
01:45 wizzyrea i'm still sorting out the last part of that.
01:45 wizzyrea (barcode)
01:46 wizzyrea because that still submits the form wrongly
01:46 drojf1 joined #koha
01:46 wizzyrea but whatever.
02:42 jcamins Awesome!
02:42 jcamins When I intentionally misconfigure QP, I get lousy search results, but no horrible error messages.
02:56 jcamins Uploaded.
03:02 jcamins Okay, folks. Come and get it while it's hot!
03:02 jcamins QueryParser!
03:02 jcamins Bug 9239!
03:02 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9239 enhancement, P5 - low, ---, jcamins, ASSIGNED , Koha should share Evergreen's QueryParser module for parsing queries
03:03 wizzyrea ooo!
03:04 jcamins Try it, you'll like it!
03:04 jcamins And while you're at it, sign off on bug 9183.
03:04 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9183 normal, P5 - low, ---, jcamins, Signed Off , C4::Search should only have one ZOOM event loop
03:04 jcamins Oh, it's already signed off.
03:08 * wizzyrea makes a mad face at bugzilla
03:56 mtj hey peepz, anyone about for a random foreign-key brain-slap… ?
03:57 eythian wahanui: ask
03:57 wahanui Don't ask to ask, just ask.
03:57 mtj i think ive found the cause of this bug 8471
03:57 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8471 trivial, P5 - low, ---, gmcharlt, NEW , loading an sql file into mysql, often fails when loading the 'letter' table
03:57 eythian :)
03:57 eythian oh hey, that'd be good.
03:57 eythian that one always bugs me
03:58 mtj it's poss. a glitchy fk constraint in mysql-struct.sql
03:58 mtj heres a fix -> http://git.kohaaloha.com/?p=he[…]aa417b89cb0adac03
03:59 mtj the 'branchcode' column refered too, in the FK constraint does not exist?
04:00 mtj so, thats my hunch… i was curious on someone elses opinionion
04:03 mtj so, if you load /installer/data/mysql/kohastructure.sql into a db, then a koha.sql - you get that error
04:03 eythian I'm surprised it lets the FK be created in the first place then
04:03 mtj $ mysql koha < /installer/data/mysql/kohastructure.sql
04:03 eythian ah
04:03 eythian yeah, that sounds quite plausible
04:03 mtj $ mysql koha < ./my-koha.sql
04:03 mtj ERROR 1005 (HY000) at line 3237: Can't create table 'koha.letter' (errno: 150)
04:04 mtj but, after applying the patch… no error
04:04 eythian tricky
04:04 eythian when you submit a patch, document the hell out of it giving examples of error messages. I've spent a bit of time googling that error to figure it out without success.
04:04 wajasu http://schema.koha-community.o[…]e_transports.html
04:06 mtj wajasu, aaah perfect :)
04:07 mtj the 'letter' table contains no 'branchcode' column, so its a glitchy FK
04:08 mtj eythian, hell yeah, ive spent a buncha time too :/
04:08 eythian it does contain the branchcode column in the schema link
04:09 wajasu note: Generated by SchemaSpy on Fri Sep 28 09:20 NZST 2012
04:09 wajasu so maybe we should ask rangi to regenerate it since the release.
04:10 mtj i wonder if we (aka rangi) could get SchemaSpy to do a nightly cron refresh?
04:11 mtj does the refresh take so long, that its a no-go?
04:12 eythian dunno, not particularly wrong as far as I know
04:12 eythian *long
04:12 wajasu i've run it and it churns for about 10 to 20 minutes i recall.
04:12 mtj re: 8471, i guess i might need to look for other references to letter.branchcode
04:13 mtj is the fix... correct the FK , or add the missing 'branchcode' column?!
04:15 mtj rangi, what you think? re: SchemaSpy nighly cron
04:16 wajasu if the branchcode was recently removed, maybe the schemspy is out of date.  i would look at the git history to see who might have changed the structure/contstraint.
04:18 mtj bah, letter.branchcode *does* exist after all
04:18 mtj http://schema.koha-community.o[…]ables/letter.html
04:19 eythian it's not a new bug, it's been there for a long time
04:21 mtj yeah, it has indeed :/
04:22 wajasu well, it seems as if letters are sent cross-branch, where it might have been per-branch before?
04:23 mtj its such a random bug to reproduce even
04:24 mtj 'show engine innodb status' seems to show that its the 'message_transports_ibfk_3' constraint, that its barfing on
04:27 wajasu if they removed the constraint for the branchcode, chances are you will get the error when just  module and code are specified.
04:27 wajasu for a DB that has the prior dataset.
04:28 wajasu i suspect the branchcode is to track from which branch the letter  was sent,
04:29 wajasu and there are probably notices that get sent with no specfic branchcode (needed for some reason)
04:34 mtj hmm, i think the problem for me is that, im attempting to load an old 3.6 db, after a new 3.8 or master db
04:38 mtj ok, wow… ^^ that theory seems to be correct! :)
04:40 mtj attempting to load in an old koha-3.6 db, after a koha-3.8 db, causes the 'Can't create table 'koha.letter' error
04:41 eythian hmm OK. maybe that's why I haven't noticed it for a while. Though I haven't been doing a lot of database loading anyway
04:41 mtj … because the existing koha-3.8 db has some constraints/FKs that dont exist in the older 3.6 db
04:42 mtj so, good news is - that seems to be the cause
04:42 eythian I have a 'delete everything' script that makes sure everything has been deleted that I tend to use.
04:42 mtj bad news is… how to fix that?
04:42 mtj the 'drop db koha; create db koha' seems to be the quick-fix
04:43 wajasu http://git.koha-community.org/[…]bc76efa3cc9cc00d7
04:46 wajasu maybe if your db has one branch, you can update the table with its branchcode, then dump it and load it.
04:48 mtj its also bizare that the 'message_transports_ibfk_3' constraint is the *only* one that fails
04:48 mtj if you delete it from the .sql file, the load is successful
04:48 wajasu is the branchcode nullable in your older version?
04:49 Manderson Hey, so I have a modified version of koha-zebra-ctl.sh that works with Redhat. I am making reference to it in my wiki page, but not quite sure that the wiki is the best place for it. Any ideas where I should put this?
04:51 mtj Manderson, the wiki is probably a good start - but consider logging a bug, and sending it as a patch?
04:52 mtj wajasu, letter.branchcode doesnt exist in my old (3.6.4) db
04:52 wajasu i know what you need to do.
04:53 wajasu if your old db is a scrtach owrk db, try to alter the table to add branchcode     http://git.koha-community.org/[…]cc9cc00d7#patch18
04:54 wajasu and that update all the rows with your branchcode.   then dump the table.
04:54 wajasu then load it in the new db.
04:55 mtj wajasu, what will that prove?
04:56 wajasu oh yeah.  you aren't trying to migrate.
04:57 wajasu you are trying to fix the bug.
04:58 wajasu well, then write a migration script, to do just that (fine for one branch case), or write instructions for one who migrates and attach it to the bug.
04:59 wajasu i guess no update script was done.
05:00 mtj hmm, you are missing the problem
05:00 wajasu yeah.
05:01 mtj the problem is… loading a sql file into mysql sometime fails
05:01 mtj $ mysql koha < ./my_koha.sql
05:02 wajasu i suspect it fails because the old version letters table data doesn't have any branchcode column at all.  so the contraint fails.
05:02 mtj yep, something like that :)
05:03 eythian tbh, it'll only be a problem while we're going back and forth across a particular version boundry, eventually it should become less of an issue as we have fewer 3.6 installations to deal with
05:03 wajasu so we have to manufacture the column.
05:04 mtj i would have thought mysql would have 'disabled' those FK checks, when loading a dumped .sql file
05:04 eythian is there an instruction for that in the dump?
05:04 mtj SET foreign_key_checks = 0;    SET foreign_key_checks = 1; etc...
05:05 eythian but is it in there?
05:05 wajasu the issue i see is that 3.6 and prior does support multiple branches.  so only if they ran as one branch could we populate the column based on that.
05:05 mtj yeah, theres usually a bunch of those instructions, at the top/bottom of a dumped .sql file
05:06 eythian /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
05:07 eythian though I don't know if that's a real comment or some strange mysql thing
05:07 thd-away joined #koha
05:08 wajasu you might get away with suspending checks, if we don't edit the record.   but you could even check to see if upon an edit/save, that we supply the branchcode.
05:08 wajasu i've only seen letters as output  (read for mail, etc).
05:09 eythian editing records isn't an issue if you're trying to replace it
05:09 wajasu are there the generated letters? or templates?
05:09 eythian it doesn't matter
05:09 wajasu ok
05:09 eythian the problem is you want to delete the table and recreate it and you can't
05:10 mtj eythian, ^^ yep - ive got those 'SET @OLD_FOREIGN_KEY_CHECKS' lines in my files, too
05:15 mtj adding the following to the start of the .sql , fixes the load error
05:15 mtj DROP database IF EXISTS `head`;
05:15 mtj create database `head`;
05:15 mtj use `head`;
05:15 wajasu i recently dumped, a 3.0x koha into 3.10 and didn't get any complaints. my branchcodes are not set.
05:16 mtj wajasu, the problem seems to be loading an older version, after an newer version
05:16 eythian in particular, loading over the top of an existing one
05:16 mtj so, load a 3.10, then load your 3.0...
05:16 wajasu ahh
05:16 eythian mtj: of course those statements will fix it, they delete everything.
05:16 eythian but we can't have that
05:17 mtj yeah, i kinda stated the obvious
05:18 wajasu copy the newer into a temp table, load the older, then add the newer.  maybe?
05:18 mtj anyhoo, as eythian  said, its now a knownish problem, with a workaround
05:19 mtj i though i was going to nail that bug!, but … not to be :)
05:23 eythian wajasu: you don't have control over anything like that, you're loading a database dump
05:24 cjh joined #koha
05:25 trea1 joined #koha
05:28 cjh joined #koha
05:35 mtj wajasu, fyi: heres my comment on the bug -> http://bugs.koha-community.org[…]ug.cgi?id=8471#c2
05:35 huginn Bug 8471: trivial, P5 - low, ---, gmcharlt, NEW , loading an sql file into mysql, often fails when loading the 'letter' table
06:04 fredy_ joined #koha
06:38 laurence joined #koha
06:45 sophie_m joined #koha
06:49 cait joined #koha
07:10 rangi http://instagram.com/p/TIKH3posO3/ thats about 100m from my house
07:11 cait oooh
07:11 cait nice
07:14 alex_a_ bonjour cait
07:14 alex_a_ bonjour rangi
07:14 rangi hi alex_a_
07:16 cait hi alex_a_
07:28 lds joined #koha
07:28 Irma joined #koha
07:32 paul_p joined #koha
07:40 reiveune joined #koha
07:41 reiveune hello
07:41 wahanui what's up, reiveune
07:48 julian_m joined #koha
08:08 rangi hi reiveune
08:08 reiveune hi rangi
08:13 gaetan_B joined #koha
08:13 gaetan_B hello
08:15 kf joined #koha
08:17 kf good morning #koha
08:19 clrh helo
08:21 kf hi clrh
08:22 rangi hi kf, gaetan_B and clrh
08:22 clrh hello kf and rangi
08:22 clrh :)
08:22 kf :)
08:22 kf konstanz is covered in snow, how is the weather in marseille?
08:51 kf @wunder marseille
08:51 huginn kf: The current temperature in Marseille, France is 0.0°C (9:30 AM CET on December 12, 2012). Conditions: Scattered Clouds. Humidity: 80%. Dew Point: -3.0°C. Pressure: 30.09 in 1019 hPa (Steady).
08:51 rangi @wunder nzwn
08:51 huginn rangi: The current temperature in Wellington, New Zealand is 18.0°C (9:00 PM NZDT on December 12, 2012). Conditions: Partly Cloudy. Humidity: 64%. Dew Point: 11.0°C. Pressure: 30.21 in 1023 hPa (Steady).
08:51 rangi its too hot
08:52 rangi 18 is yuck for sleeping
08:55 magnuse @wunder boo
08:55 huginn magnuse: The current temperature in Bodo, Norway is -4.0°C (9:20 AM CET on December 12, 2012). Conditions: Clear. Humidity: 54%. Dew Point: -12.0°C. Windchill: -12.0°C. Pressure: 30.09 in 1019 hPa (Steady).
08:55 magnuse @wunder arguineguin
08:55 huginn magnuse: Error: No such location could be found.
08:55 magnuse @wunder las palmas
08:55 huginn magnuse: Error: No such location could be found.
08:55 magnuse @wunder las palmas, spain
08:55 huginn magnuse: Error: No such location could be found.
08:55 magnuse pft
08:56 * magnuse travels south today
08:56 rangi cool
08:56 rangi for work?
09:01 rangi i forgot how pretty the rijksmuseum catalogue is
09:01 rangi http://library.rijksmuseum.nl/[…]-search.pl?q=fish
09:01 rangi marcelr++
09:03 magnuse wow, that is an awesome opac!
09:04 kf totally is
09:04 kf I love the itemtype selected on advanced search
09:04 kf marcelr++
09:05 kf magnuse: have a good holiday
09:05 magnuse marcelr++
09:05 magnuse kf: thanks
09:06 rangi magnuse: yay have fun!
09:06 magnuse rangi: thanks!
09:09 drojf @wunder berlin, germany
09:09 huginn drojf: The current temperature in Prenzlauer Berg, Berlin, Germany is -2.6°C (9:43 AM CET on December 12, 2012). Conditions: Light Freezing Fog. Humidity: 73%. Dew Point: -7.0°C. Windchill: -5.0°C. Pressure: 30.12 in 1020 hPa (Steady).
09:10 kf morning drojf
09:10 rangi hi drojf
09:10 drojf morning kf and rangi :)
09:11 drojf wish i could work from bed
09:12 drojf kf: have you tried bug 4906?
09:12 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4906 enhancement, P5 - low, ---, katrin.fischer, Signed Off , Problem with grace period calculation and fine intervals >1
09:12 drojf or looked at it, regarding paul_p's comment
09:13 drojf i gave a version of 3.8.7+4906 to wildau for testing
09:14 kf drojf: not yet, requires some good test cases I think
09:14 kf oh interesting
09:14 wahanui i think interesting is sometimes good and sometimes bad
09:15 kf I had chatted with khall about it before he send in the patch
09:15 kf but then I got covered with lots of other things :(
09:15 kf not sure the description on the patch is accurate - I would like to test and see how it works
09:15 kf we had talked about the formula and it might work for our problem, just not sure
09:17 drojf i don't have any experience with fines because we don't have any, but the bug sounds like a problem wildau was having. i suppose they will see if it fixes it for them
09:18 kf bit hard to test in production maybe... well a good test, but hard if something is still off
09:18 kf and it might work for one confguration and not for another
09:19 drojf that is also where the question about database numbering came from. for the test version i just used the next db revision number now, but i don't know if that is a good idea for a production system
09:21 kf you will hae to be careful on update
09:21 kf resetting the version by 1 before you run it - in the database
09:21 kf I think
09:22 drojf ah yes, that sounds like a good idea
09:22 drojf isn't there even a syspref with the number? i thought there was but could not find it last night
09:23 kf local use tab :)
09:23 drojf ah, the one i never look at :) thanks
09:23 kf yeah, I recently 'rediscovered' it
09:25 drojf but that number is not what it should be for that instance, it's just 3.0807000
09:26 kf oh?
09:26 kf and what does about say?
09:27 kf ah
09:27 drojf the same, i was wondering about that last night
09:27 kf maybe they didn't apply it
09:27 kf or reset it
09:27 drojf hm. i only checked if the syspref is there
09:28 drojf maybe the db stuff isn't ^^
09:28 kf it's not bad actually
09:28 kf I think if you turn it on/off the pref might get created
09:37 drojf i will find about that later :)
09:37 drojf find out
09:38 kf if you have access to reports you can check
09:43 lms joined #koha
09:44 drojf it's not in my updatedatabase file. i guess something went wrong there
09:45 drojf ah, it is, wrong ssh session, wrong koha ;)
09:49 kf lol
09:50 drojf did it manually and got a duplicate entry error for the grace syspref. i suppose that means you were right about the db entry getting created when changing the pref
10:05 vfernandes joined #koha
10:07 vfernandes hi :)
10:07 kf drojf: yay ;)
10:08 kf hi vfernandes
10:08 vfernandes koha translate interface is damn slow :/
10:08 drojf vfernandes: it's being worked on
10:08 kf vfernandes: it will move to a new server soon
10:11 vfernandes humm nice :)
10:21 gerundio joined #koha
10:29 BobB joined #koha
10:35 kf hm
10:35 kf can't log into the koha wiki...
10:35 kf is it me or something with the wiki?
10:54 * kf gives up
10:58 magnuse kf: works for me
11:00 drojf joined #koha
11:01 clrh tweetbot`: just repeat #kohails hashtag ?
11:03 drojf clrh: that's what i think
11:03 drojf try it ;)
11:07 thd-away` joined #koha
11:22 kf gmcharlt: around?
11:24 kf @later tell gmcharlt I got problems logging into the wiki - I tried sending myself a new password, but that doesn't work too - maybe you can use some magic?
11:24 huginn kf: The operation succeeded.
11:24 kf :(
12:06 tcohen joined #koha
12:18 magnuse have fun, #koha!
12:28 jwagner joined #koha
12:33 jcamins vfernandes: around?
12:33 nengard joined #koha
12:34 tcohen joined #koha
12:40 jcamins Hmmm...
12:40 jcamins Could someone please try deleting an authorized value?
12:49 jcamins Also, could someone please confirm that it is possible to check out books with the web-based SCO still?
12:51 paul_p joined #koha
12:51 tcohen mornin #koha
12:52 jcamins paul_p: does the web-based SCO work for you under Plack?
12:53 jcamins Ah-ha.
12:53 jcamins The selfcheck must have superlibrarian privileges.
12:54 paul_p jcamins well, I tested with an account with superlibrarian privileges, it's true (and with plack)
12:54 * paul_p at a meeting with our greek partners
12:55 ericar joined #koha
12:56 H joined #koha
13:08 * jcamins stops reviewing patches for pushing.
13:09 NateC joined #koha
13:10 tcohen why jcamins? whhhhhhyyyyy?
13:10 kf jcamins: because he has a life outside koha... maybe
13:10 kf and that was for tcohen :P
13:11 tcohen :-P
13:13 huginn New commit(s) kohagit: Bug 9101: Add REPORT_GROUP to sample data <http://git.koha-community.org/[…]0897d7279337e9b16> / Bug 9033: Wide character error in runreport.pl <http://git.koha-community.org/[…]0137a58fa58290b1c> / Bug 9033 - Wide character error in runreport.pl <http://git.koha-community.org/[…]mitdiff;h=4294869
13:14 jenkins_koha Starting build #975 for job Koha_master (previous build: FIXED)
13:15 jcamins tcohen: because I am easily annoyed in the morning, and only one patch out of the five I reviewed was not dubious.
13:16 tcohen ouch
13:16 kf you pushed my patch? :P
13:16 * tcohen thinks we need to feed the RM with super-charged coffee in the morning
13:17 kf I think feeding him with well tested patches that are not dubious could work too :)
13:17 jcamins kf: yes, that's the only one.
13:17 jcamins Well, no, I also pushed bug 9033, but that patch didn't fix the problem it purported to, it just made it less broken.
13:17 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9033 normal, P5 - low, ---, kyle, Pushed to Master , Wide character error in runreport.pl
13:19 H Hey all
13:19 kf bug 9144
13:19 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9144 trivial, P1 - high, ---, vfernandes, Passed QA , bulkmarcimport.pl - Problem identifying errors
13:20 tcohen H: bug 9267
13:20 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9267 normal, P5 - low, ---, tomascohen, Needs Signoff , Ubuntu 12.04 install docs broken
13:20 H is that me ? ;)
13:21 H ah indeed
13:21 H reeding it
13:25 H if my library is online i post the url ... still have to do the webinstall and the data import (at the moment i cant at the server ip adres in my browser did mail the network people here (apache is installed (hopefully i did it correct)))
13:26 oleonard joined #koha
13:28 oleonard Hi #koha
13:29 H wave
13:29 * jcamins grumbles.
13:29 jcamins jcamins?
13:29 wahanui i guess jcamins is brilliant
13:29 jcamins Huh?
13:29 jcamins jcamins?
13:29 wahanui you are brilliant
13:29 jcamins jcamins?
13:29 wahanui well, jcamins is brilliant
13:29 jcamins jcamins?
13:29 wahanui you are very, very irascible.
13:29 jcamins There we go.
13:30 kf why don't we have a timestamp in deleteditems? :(
13:30 oleonard So, has anyone ever seen an authorized value image appear in the OPAC search results? And I'm not talking about item type images.
13:30 oleonard git blame says this code is from 2008, and I don't remember ever seeing it in action.
13:31 jcamins Ooh! A puzzle!
13:32 jcamins oleonard: I have not, if we're not talking about item types.
13:33 kf oleonard: never tried it
13:33 jcamins Could someone please try deleting an authorized value, while we're on the subject?
13:34 oleonard Sure
13:34 kf oleonard++
13:34 jcamins Thanks.
13:35 oleonard Seems to work fine jcamins
13:35 jcamins Hm.
13:35 jcamins Guess it's a combination of DEBUG and/or Plack.
13:36 talljoy joined #koha
13:43 gerundio joined #koha
13:44 jcamins Okay, patched.
13:45 lds joined #koha
13:54 lds1 joined #koha
13:56 francharb joined #koha
13:57 francharb hi
14:00 oleonard SMU++ # I'm glad they're back with real Koha
14:00 khall hey all, does anyone know if it's possible to search MARC leader information via zebra?
14:01 jcamins khall: I actually do not.
14:01 kf yes
14:01 kf bib-level is an example
14:01 kf if I am not mistaken totally
14:02 kf hm I might be, always confuse all the controlfields :(
14:02 khall indeed, bib level is 07 of the leader!
14:02 kf oh thx
14:02 kf I got worreid :)
14:02 khall thanks! I'll go poke around the zebra configuration files and see what I find
14:03 kf oleonard: do you know when they switched?
14:03 oleonard it wasn't too long ago I think
14:03 jcamins Yeah, you just put it in the <marc:record> template.
14:04 kf jcamins: for dom?
14:05 jcamins Right.
14:05 kf really have to look at those configuration files sometime :)
14:05 kf they sound like fun
14:05 jcamins http://www.indexdata.com/zebra[…]-domxml-conf.html
14:05 jcamins I like the last example in 3.3.
14:05 oleonard kf: http://bywatersolutions.com/20[…]ywater-solutions/
14:05 drojf that are not the grs-1 guts of a zebra for sure ;)
14:06 jcamins You may find it somewhat less hysterically funny than I do, of course.
14:06 khall kf: where would one search on bib-level? I don't see that in the advanced search
14:06 kf ... which has      opportunities for great power and wizardry as well as grande      disaster.
14:06 jcamins khall: it's used in analytic tracings.
14:06 kf khall: it has not been implemented there yet... see
14:06 khall gotcha, over my head
14:07 * khall needs to get his mls
14:07 kf khall: you can limit to serials using it
14:07 kf look at the advanced search at the link :)
14:07 druthb @quote add  kf: ... which has opportunities for great power and wizardry as well as grande disaster.
14:07 huginn druthb: The operation succeeded.  Quote #223 added.
14:07 kf lol
14:07 kf I quoted the zebra documentation jcamins pointed to
14:08 kf I am not poetic like that :)
14:17 vfernandes sorry jcamins_away, I was out for lunch
14:21 libsysguy joined #koha
14:23 jenkins_koha Project Koha_master build #975: UNSTABLE in 1 hr 8 min: http://jenkins.koha-community.[…]/Koha_master/975/
14:23 jenkins_koha * kyle: Bug 9033 - Wide character error in runreport.pl
14:23 jenkins_koha * julian.maurice: Bug 9033: Wide character error in runreport.pl
14:23 jenkins_koha * Katrin.Fischer.83: Bug 9101: Add REPORT_GROUP to sample data
14:23 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9033 normal, P5 - low, ---, kyle, Pushed to Master , Wide character error in runreport.pl
14:23 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9101 enhancement, P5 - low, ---, katrin.fischer, Pushed to Master , Add REPORT_GROUP to authorised values sample data
14:33 maximep joined #koha
14:44 oleonard Well what do you know, the authorised value display in OPAC results worked a long time ago
14:46 JesseM joined #koha
14:49 francharb` joined #koha
15:09 lds joined #koha
15:13 drojf seeing the sponsoring information, does hourly loans work with fines nowadays?
15:13 kf I think the work around is probably to have the fine script running often
15:13 kf ?
15:17 libsysguy drojf it really depends on the day of the week
15:17 libsysguy it seems like its broken more than its working
15:18 drojf i'm so glad we don't have fines :P
15:21 * oleonard too
15:25 ericar left #koha
15:26 kf we have fines, but not hourly
15:26 kf but fine syntax in notices is broken too... *sigh*
15:29 kf gmcharlt?
15:29 wahanui somebody said gmcharlt was an expert in all things library technology.
15:30 gmcharlt kf: hmm?
15:30 kf oh you are here
15:30 kf sec just saving
15:31 kf I can not log into the wiki any longer
15:31 kf and have no idea why :(
15:32 kf it always says wrong passwort, even for the temporary password it send me
15:32 gmcharlt your account is Kfischer?
15:32 kf yep
15:44 Manderson1 joined #koha
16:07 rambutan joined #koha
16:18 reiveune bye
16:18 reiveune left #koha
16:21 jcamins Awww!
16:21 jcamins My client's little kitten just ran across the room, tripped over the door frame, discover s/he couldn't get any traction on tile, and slid into a heap against a wall.
16:22 druthb awr!
16:22 jcamins S/he is now somewhere else complaining loudly.
16:23 jcamins That time it tripped over the doorframe but recovered enough to not go flying.
16:50 gmcharlt @later tell cait ok, you should be able to log in now; MediaWiki was hanging on to old cached versions of user objects for some reason
16:50 huginn gmcharlt: The operation succeeded.
17:00 paul_p joined #koha
17:01 melia joined #koha
17:07 oleonard I don't think I've ever written so much test plan for a 4-line correction (Bug 9276)
17:07 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9276 normal, P5 - low, ---, oleonard, Needs Signoff , Display of biblio-level authorized values on OPAC search results broken
17:07 thd-away joined #koha
17:07 oleonard I didn't set out to correct a feature I didn't know existed and didn't want to use, I was just trying to validate the damn template.
17:09 mib_okkapv joined #koha
17:09 mib_okkapv hello
17:09 oleonard Hi mib_okkapv
17:09 mib_okkapv I would like to know how to show or hide tags... ? :)
17:09 jcamins oleonard: it's a cool feature, though!
17:10 jcamins One which I will make a point of finding a use for so that you can feel your time was well-spent.
17:10 oleonard mib_okkapv: In what context?
17:12 mib_okkapv in the cataloguing of create new records :)
17:12 oleonard mib_okkapv: Check the documentation on editing MARC frameworks
17:12 mib_okkapv for example I have 50 tags but I would like to use only 30 tags
17:13 jcamins mib_okkapv: http://manual.koha-community.o[…]marcbibframeworks
17:13 jcamins Search for "hidden"
17:13 wahanui joined #koha
17:13 jcamins It's about a quarter of the way down the page.
17:13 jcamins wahanui: fortune?
17:13 wahanui no idea, jcamins
17:13 jcamins @fortune
17:13 huginn jcamins: Your goose is cooked. (Your current chick is burned up too!)
17:14 mib_okkapv ok thank you I am looking for i cannot use i will ask again thank you
17:14 mib_okkapv :)
17:15 libsysguy joined #koha
17:22 laurence left #koha
17:22 mib_okkapv MARC frameworks › BKS framework structure › Tag 001 subfield structure › Edit subfields constraints > Managed in tab >1
17:25 talljoy1 joined #koha
17:27 mib_okkapv is this right?
17:28 jcamins mib_okkapv: what are you trying to do?
17:28 jcamins If you want to change what tab the 001 field is displayed in, then yes.
17:28 jcamins Otherwise, no.
17:29 mib_okkapv mmmm ok :) but if the 40 field i would like to display? once created in the framework
17:30 mib_okkapv for example...
17:30 jcamins Then you change the visibility, as in the manual I sent you a link to.
17:32 talljoy2 joined #koha
17:33 mib_okkapv MARC frameworks › Books, Booklets, Workbooks (BKS) › Modify tag 040 > Authorized value ?
17:34 mib_okkapv I guess
17:34 jcamins No, "Hidden"
17:34 jcamins There's a screenshot in the manual, I think.
17:37 mib_okkapv BKS framework structure › Tag 038 subfield structure › Edit subfields constraints > Advanced constraints > hidden :)
17:37 jcamins Exactly.
17:38 mib_okkapv ahh i got it change the subfield tags to show the fields :)
17:38 mib_okkapv thankkkkkkkkk youuuuuuuuuuu :)
17:38 jcamins :)
17:39 mib_okkapv i am starting learning koha but i dont know where to start i used winisis
17:39 mib_okkapv the video tutoriales of bywater it is a right place to start?
17:40 oleonard Yes mib_okkapv, that's a good resource
17:42 mib_okkapv ok :) besides do you know where is a documentation of the koha structures?
17:42 mib_okkapv technical information about the ILS?
17:42 cait joined #koha
17:43 jcamins mib_okkapv: what do you mean?
17:44 * cait waves
17:44 jcamins There is not really any overarching "technical guide."
17:44 cait gmcharlt++
17:44 cait @later tell gmcharlt - works now :) many thanks!
17:44 huginn cait: The operation succeeded.
17:45 mib_okkapv @ i see , books? manuals? tesis?
17:45 huginn mib_okkapv: I suck
17:46 jcamins mib_okkapv: the manual you have a link to.
17:46 jcamins The wiki is full of useful information.
17:46 jcamins wiki?
17:46 wahanui wiki is http://wiki.koha-community.org
17:46 mib_okkapv yes i see... :(
17:47 mib_okkapv well thank you for the time spend :)
17:47 mib_okkapv I will apreciate it
17:47 jcamins If you're interested in the database structures, there's a thingy for that.
17:47 jcamins schema?
17:47 wahanui well, schema is tracked in git. or found at http://schema.koha-community.org
17:47 jcamins (I don't know what to call it)
17:47 jcamins And, of course, since Koha is open source the best thing you can do if you want to know how it works is look at the code!
17:47 jcamins git?
17:47 wahanui well, git is http://wiki.koha-community.org[…]Control_Using_Git
17:48 mib_okkapv yes the schema I got it but the information about modules, connections, etc etc
17:48 jcamins First question?
17:48 wahanui "What are you trying to do?" or "What is the goal?"
17:49 mib_okkapv understand how it works at the glance :(
17:50 mib_okkapv how many kinds of type of archives exists? for example is a goal :)
17:50 jcamins How what works?
17:50 oleonard You can't tell at a glace how the whole thing works, there are too many parts
17:51 jcamins Koha comprises over eight hundred lines of code.
17:51 jcamins *eight hundred thousand
17:51 mib_okkapv :(
17:51 jcamins Eight hundred isn't very many at all.
17:51 mib_okkapv its is a huge for me
17:51 jcamins It is capable of running pretty much any type of library, from a personal library with 200 books to a national library with 8 million.
17:52 mib_okkapv I understand cds/isis structures very well
17:53 jcamins I think possibly you need to adjust your expectations.
17:53 jcamins I think I can speak for the original author of Koha when I say that *no one* knows how every part of Koha works perfectly.
17:54 NateC joined #koha
17:54 mib_okkapv mmm I see
17:55 mib_okkapv but just at glace..
17:55 mib_okkapv how works the parts
17:55 mib_okkapv itselfs each parts
17:56 jcamins I can't answer that question because to me that's like asking "how does Linux work at a glance?"
17:56 mib_okkapv jajaja yes i understand...
17:57 jcamins The best answer I could give you for "how does Linux work at a glance?" is "there's a kernel, which is central, and then there are a lot of other things that work together so that you can use your computer."
17:57 jcamins For Koha, I could say "there's a lot of code that runs on a server, data is stored in a database, searches are done using an external system called Zebra, and the user uses a web browser to manage their library."
17:58 jcamins But you didn't need me to tell you that, because you already know all these things from reading the "What is Koha?" page on the website.
17:58 mib_okkapv and the main part of code is perl done
17:58 jcamins Yes.
17:58 khall I can't install Koha from master atm, I get this in Step 3: ERROR 1166 (42000) at line 1871: Incorrect column name 'closed '
17:58 jcamins khall: there's a patch for that which requires sign-off.
17:59 khall whats the bug #?
17:59 wahanui i heard the bug # was there
17:59 jcamins I'm looking now.
17:59 jcamins Bug 9246.
17:59 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9246 blocker, P5 - low, ---, veron, Signed Off , Upon running koha installer, mysql "Error 1166 at line 1871: Incorrect column name 'closed" appears and crashes install.
17:59 jcamins Oh, wait, it's signed off!
17:59 jcamins QA team! QA 9246!
18:02 cait remind me in half an hour?
18:02 mib_okkapv ok thank you @jcamins
18:02 jcamins Hm. We don't have a reminder feature, do we?
18:02 mib_okkapv for the time ...........i will be in touch ;)
18:03 rangi Morning
18:03 wahanui hmmm... Morning is a state of mind. or whenever the cat wants breakfast.
18:05 rambutan a brief, off-topic note that Ravi Shankar has died...
18:08 jcamins cait: you are reprieved.
18:27 rangi @wunder nzwn
18:27 huginn rangi: The current temperature in Wellington, New Zealand is 14.0°C (7:00 AM NZDT on December 13, 2012). Conditions: Clear. Humidity: 82%. Dew Point: 11.0°C. Pressure: 30.21 in 1023 hPa (Steady).
18:27 * jcamins finishes up.
18:54 trea joined #koha
19:35 chris_n nasty bug
19:38 oleonard ?
19:49 rambutan joined #koha
19:56 cait chris_n: which one are you looking at?
19:57 chris_n 9246
19:57 oleonard Bug 9246?
19:57 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9246 blocker, P5 - low, ---, veron, Passed QA , Upon running koha installer, mysql "Error 1166 at line 1871: Incorrect column name 'closed" appears and crashes install.
19:59 wizzyrea i looked in the manual, but I didn't see a definitive answer - does koha have a mechanism to search "title begins with"
20:00 wizzyrea i found ti,first-in-subfield=<search>
20:00 wizzyrea but I can't seem to make it works
20:03 wizzyrea work*
20:15 jenkins_koha Starting build #31 for job Koha_3.10.x (previous build: SUCCESS)
20:29 ericar joined #koha
20:29 ericar left #koha
20:31 jcamins_away wizzyrea: if first-in-subfield doesn't meet your needs, you could try startswithnt.
20:32 wizzyrea well I couldn't get it to work - maybe I was doing it wrong?
20:32 jcamins I'm not sure either works.
20:33 wizzyrea how would you use startswithnt
20:33 wizzyrea ti,startswithnt=<whatever>
20:34 wizzyrea oh oh actually - it does work
20:34 wizzyrea < user error
20:34 wizzyrea rangi++
20:35 jcamins Full disclosure: that doesn't actually do what you think it does.
20:35 wizzyrea well it gets pretty darn close
20:35 jcamins Yeah, it should be close enough.
20:35 wizzyrea but, you may explain if you like :)
20:35 oleonard Yes please
20:36 wizzyrea for the log it's ccl=ti,first-in-subfield=<whatever>
20:38 jcamins The problem is that first-in-subfield is mapped internally to first-in-field, which in turn is mapped to wordlist + doesn't have anything preceding it in the field that's being indexed.
20:38 jcamins So _how_ we add fields to the index impacts what is considered first-in-subfield.
20:39 wizzyrea so title is probably more or less ok - other fields might not be so ok
20:39 jcamins Right.
20:39 wizzyrea like su,first-in-subfield might be confusing
20:39 jcamins Exactly.
20:39 wizzyrea (or something)
20:40 jcamins That's actually the example I was thinking of.
20:40 wizzyrea right, easy enough to pass on
20:40 wizzyrea hehe
20:40 wizzyrea the question was
20:40 wizzyrea "can I search 'title begins with'"
20:40 wizzyrea the answer is, apparently, with gymnastics, yes
20:40 jcamins Then, yes, that should do it.
20:40 wizzyrea "with gymnastics"
20:40 wizzyrea :)
20:41 paul_p joined #koha
20:41 jcamins Of course, because I live to make things difficult, I should point out that if they use 505 fields extensively, they may get unexpected results.
20:41 jcamins Ooh!
20:41 jcamins I know how to fix it.
20:41 jcamins ccl=Title-cover,first-in-subfield=whatever
20:42 wizzyrea I would have to ask eythian about the fields this particular library
20:42 oleonard And how does one perform that search?
20:42 wizzyrea uses
20:42 wizzyrea type it into the search box
20:42 wizzyrea :)
20:42 wizzyrea (all of it)
20:43 oleonard Wow, closest thing to a browse search I've ever seen in Koha
20:44 rangi theres lots we can do with zebra, its just C4::Search won't let us .. so yay for jcamins rewrite!
20:44 jcamins On the subject of which, bug 9239 isn't ready for sign off, but it *is* ready for testing!
20:44 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9239 enhancement, P5 - low, ---, jcamins, ASSIGNED , Koha should share Evergreen's QueryParser module for parsing queries
20:46 wizzyrea YAY for the rewrite!
20:47 jcamins I am ten chapters into the play-by-play recounting of the Battle of Waterloo.
20:47 oleonard It's a little early to be trying to fall asleep jcamins
20:48 wizzyrea ^^^^
20:48 jcamins oleonard: I have already finished four other books trying to get through this section in Les Miserables.
20:48 * wizzyrea laughs
20:48 cait :)
20:49 jcamins Okay...
20:49 jcamins I must strategize.
20:50 jcamins I am still seven baked goods short of done with holiday baking, and I have a surprise holiday party this evening.
20:50 cait a surprise party?
20:50 jcamins (thankfully I don't need the baked goods *for* the holiday party)
20:50 jcamins No, a surprise holiday party.
20:50 wizzyrea Pavlova. It can finish while you are at the party.
20:51 cait wh ois surprised?
20:51 wizzyrea i think jcamins
20:51 wizzyrea is surprised at the existence of the party
20:51 jcamins Yes.
20:51 cait ah hm
20:52 jcamins I also have the neediest cat *ever*.
20:52 cait heh
20:53 JesseM left #koha
20:58 jenkins_koha Project Koha_3.10.x build #31: SUCCESS in 43 min: http://jenkins.koha-community.[…]b/Koha_3.10.x/31/
20:58 jenkins_koha * kyle: Bug 9033 - Wide character error in runreport.pl
20:58 jenkins_koha * julian.maurice: Bug 9033: Wide character error in runreport.pl
20:58 jenkins_koha * Katrin.Fischer.83: Bug 9101: Add REPORT_GROUP to sample data
20:58 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9033 normal, P5 - low, ---, kyle, Pushed to Stable , Wide character error in runreport.pl
20:58 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9101 enhancement, P5 - low, ---, katrin.fischer, Pushed to Stable , Add REPORT_GROUP to authorised values sample data
21:00 jcamins I just bought five pounds of flour a few weeks ago.
21:00 jcamins Why am I already out?
21:01 cait because it's pre christmas time?
21:01 cait myshkin ate it?
21:02 jcamins The holidays, I think.
21:03 jcamins Also, remember how I said buying 10lbs of flour was a mistake because I'd be out before I knew it?
21:03 jcamins I was right.
21:04 rangi heh
21:09 * jcamins uses his knowledge of the art of tessellation to spread club crackers on his baking sheets.
21:13 wizzyrea oh are you making the toffee things
21:13 cait toffee?
21:13 * wizzyrea wonders how much flour is in jcamins' computer
21:13 cait heh
21:14 wizzyrea you pour hot toffee over crackers
21:14 wizzyrea and it makes this yummy cracker-candy thing
21:14 cait oooh
21:14 cait yum
21:14 jcamins Yes I am.
21:15 jcamins And none... I just put my keyboard cover on. :P
21:15 cait jcamins: do you ship to germany? :)
21:15 druthb he's been known to *deliver* to Kansas.  That's what I'm hoping for.
21:16 jcamins Problem...
21:16 wahanui problem is it's human beings doing it. Rebuild your indexes.
21:16 jcamins The recipe called for 1 stick of butter, 1 cup sugar.
21:16 jcamins I doubled it.
21:16 jcamins There's waaaaay too much butter.
21:16 * jcamins adds more sugar.
21:17 Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software http://koha-community.org The next general meeting is 9 January 2013, at 10:00 UTC
21:27 oleonard I created a wiki page for the next meeting since no one else had: http://wiki.koha-community.org[…]g,_9_January_2013
21:28 oleonard I copied the basic agenda and left in the GPLv3+ vote item, please correct or amend
21:28 rangi thanks
21:31 jcamins We already voted on the GPLv3+ issue, thank goodness.
21:31 oleonard Oh did we resolve that? I thought something had been pushed to the next meeting
21:32 jcamins We did, despite the efforts of some people to waste everyone's time.
21:33 eythian hi
21:33 cait hi eythian
21:33 * jcamins was not referring to eythian.
21:33 eythian heh
21:35 rambutan Tessellation is the process of creating a two-dimensional plane using the repetition of a geometric shape with no overlaps and no gaps.
21:36 eythian rambutan: on that note, the Escher museum in Den Haag is really quite cool.
21:37 rambutan You know eythian, I was just thinking about the Escher museum when you mentioned that.
21:37 rambutan where is Den Haag?
21:38 eythian I spent about 3 or 4 hours there when I was last in Den Haag
21:38 eythian in the Netherlands
21:38 rambutan ah, of course
21:40 rambutan The Escher Museum (Escher in het Paleis, Escher in the Palace) is a museum in The Hague, Netherlands, featuring the works of the Dutch graphical artist M. C. Escher.
21:40 rambutan And now I make the connection between tessellation and the Escher Museum.
21:41 rambutan citation: https://en.wikipedia.org/wiki/Escher_Museum
21:45 nengard left #koha
21:51 jcamins I always forget how long that takes.
21:51 jcamins One pan isn't that time-consuming.
21:51 jcamins But the amount of time required increases exponentially.
21:52 rangi http://www.cafepress.com/koha12.751374936
21:52 rangi the perfect xmas gift
21:52 rangi heh
21:55 jcamins Four pans of saltine toffee bark!
21:59 jcamins Of course, foreshortening makes it look like those pans are all deeper than they are wide, when in fact the opposite is true.
22:00 jcamins Indeed, less than half the toffee bark is visible in that photo.
22:03 BobB joined #koha
22:12 cait jcamins: posting those photos is a little mean, don't you think? :)
22:13 jcamins cait: ummm...
22:13 jcamins tough.
22:13 jcamins :P
22:14 tcohen joined #koha
22:40 NateC left #koha
22:44 talljoy2 jcamins: is there any known issue for dom indexing and icu-chains?  linker appears to not work correctly when those two are used.
22:44 wizzyrea jcamins: ty for the help with ccl
22:45 jcamins talljoy2: not to my knowledge. It works for me.
22:45 talljoy2 curious.  we had a fail with it.
22:45 talljoy2 could be one off.  i need to find a smaller database to test it on than the monster i have currently.  heh
22:48 rambutan joined #koha
22:55 maximep left #koha
22:59 tcohen joined #koha
23:06 rambutan left #koha
23:07 thd-away` joined #koha
23:16 tcohen hi rangi
23:16 papa joined #koha
23:16 tcohen what git feature would u #koha highlight?
23:17 jcamins tcohen: what do you mean?
23:17 tcohen i'm giving an intro to using git tomorrow
23:17 tcohen for my 30+ coleages
23:17 tcohen i love rebasing -i
23:17 tcohen and git mergetool
23:17 jcamins git rebase -i, definitely.
23:17 tcohen exactly
23:18 tcohen i'll talk about the super git-bz tool
23:18 tcohen as an example of extensibility
23:19 tcohen i've never cherry-picked thuo
23:19 jcamins Git cherry-pick is slightly less useful for most people.
23:19 tcohen is a RM thing right?
23:19 jcamins RMaint.
23:20 tcohen right
23:20 jcamins RM never cherry-picks.
23:20 jcamins git bisect is useful.
23:20 cait git bisect is cool too
23:20 tcohen what do u use for solving merge conflicts?
23:21 cait jinx ;)
23:21 jcamins My razor-sharp mind. :P
23:21 tcohen kdiff3?
23:21 tcohen kompare?
23:21 jcamins vim.
23:21 tcohen vimdiff
23:21 jcamins No, just vim.
23:22 tcohen you mean by hand
23:22 jcamins Right.
23:22 tcohen me too, but i've studied using those tools
23:22 tcohen to convince people
23:23 tcohen we are moving from trac+svn to redmine+gitolite+git
23:23 tcohen i'll explain git-svn for migration
23:25 tcohen can anyone give a short explanatio of bisect?
23:27 jcamins I can't figure out bug 9275.
23:27 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9275 trivial, P5 - low, ---, rominaracca, Passed QA , Missing '<' closing pharagraph tag
23:27 tcohen OH! git bisect + unit tests ;)
23:27 jcamins Where's the problem?
23:27 wahanui it has been said that the problem is it's human beings doing it. Rebuild your indexes.
23:28 tcohen s/,/</ ?
23:28 jcamins Right, I see that there is a problem, but I don't see it in the interface.
23:29 tcohen in the autorithy help section?
23:29 jcamins Oh, *edit* page.
23:29 jcamins Thanks.
23:31 tcohen how do u go backwards using bisect? is it done when bisect bad is issued?
23:31 cait left #koha
23:31 jcamins I've never been any good at it, unfortunately.
23:32 tcohen ok
23:34 tcohen thanks for your oppinion jcamins
23:34 tcohen i'll see what can i do with LibreOficce about this
23:34 tcohen :-(
23:35 jcamins tcohen: rangi does really good instructions for using git bisect.
23:35 tcohen hmm, i guess i'll try later then
23:44 tcohen rangi fully backs test-driven development
23:44 jenkins_koha Starting build #976 for job Koha_master (previous build: UNSTABLE -- last SUCCESS #974 1 day 3 hr ago)
23:45 jcamins Yes.
23:45 jcamins Wait, why is master unstable?
23:45 jcamins Why didn't I get notification of that?
23:45 tcohen now i've read about bisect, I'm sure he will know a lot about it!
23:45 jcamins Oh, daily quotes.
23:51 huginn New commit(s) kohagit: Bug 9275 follow-up: Add Romina Racca to history <http://git.koha-community.org/[…]42fd3e14ffdd12f9a> / Bug 9275 Missing '<' closing pharagraph tag <http://git.koha-community.org/[…]5a5eb9b118635bc9e> / Bug 9246: Koha installer crash with mysql error <http://git.koha-community.org/[…]commitdiff;h=ca47
23:53 sophie_m left #koha

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