IRC log for #koha, 2012-12-12

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

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

← Previous day | Today | Next day → | Search | Index

koha1