IRC log for #koha, 2013-09-12

All times shown according to UTC.

Time S Nick Message
00:07 * dcook 's got nothing
00:08 dcook I need to wash the pot my wife made lemon curd in?
00:08 jcamins Hehe.
00:08 * jcamins will make it up as he goes along.
00:21 * dcook is looking forward to jcamins' Kohacon baking
00:21 dcook Just over a month...
00:33 jcamins The custard looks like uncooked custard.
00:33 jcamins I figure that's a promising start.
00:43 * dcook thumbs up
00:43 dcook I'm not sure why I'm encouraging you
00:43 dcook I'm starving now and it's only 10:40am
00:46 jcamins Starting to set.
01:00 jcamins Very tasty.
01:01 dcook \o/
01:09 jcamins I'm quite impressed by the custard. I wasn't actually anticipating it coming out.
01:09 mtompset jcamins:[…]/NanaimoBars.html
01:09 mtompset I figured I had to suggest something Canadian. ;)
01:10 jcamins I don't really like layer desserts.
01:11 dcook I think Nanaimo Bar is a Canadian name. I think they have that dessert in the US with another name
01:12 * dcook isn't too fussed on them either
01:12 dcook A poutine burrito on the other hand...
01:22 dcook There comes a time when reading documentation gets you nowhere and you just need to try a thing out...
01:23 jcamins That is very true.
01:24 dcook It might also be that I didn't read the documentation close enough
01:25 jcamins You'll need to try either way. :P
01:25 dcook Yep, hehe
01:25 dcook I'd like to actually understand this crosswalk plugin mechanism but whatever...if it works that's the most important thing
01:25 mtompset crosswalk plugin?
01:25 dcook Dspace
01:26 dcook Looking at setting up custom crosswalks for the DSpace OAI-PMH server
01:27 dcook So that I can import the best info from DSpace to Koha
01:27 dcook Err export
01:28 dcook Also so that the Australian discovery service Trove can properly harvest from DSpace as well
01:28 dcook You'd think that I would dream about metadata and OAI-PMH these days...
01:28 dcook I sort of love it though
01:29 * dcook actually had strange dreams where Australia resembled Italy and people transformed into monsters in the dark
01:29 dcook Beautiful views ;)
01:29 eythian the last part is actually true
01:29 dcook Mmm, good point
01:49 kathryn_ joined #koha
02:30 mtompset okay... I'm having a problem with a rolled package. :(
02:31 mtompset Hmm... I didn't uninstall properly perhaps?
02:33 eythian I have no idea.
02:34 mtompset I totally uninstalled everything, and then installed the package and got no errors.
02:34 mtompset But if I have a koha-common instance installed, I get a whack load of errors.
02:34 eythian I don't know what the errors are.
02:35 mtompset DBD::mysql::db selectrow_array failed: Table 'koha_memctest.systempreferences' doesn't exist at /usr/share/koha/lib/C4/ line 562.
02:35 mtompset Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/ins​taller/data/mysql/ line 75.
02:35 jcamins That's because you never set up the instance.
02:35 mtompset That's just a snippet of them.
02:35 eythian yeah, that's expected.
02:36 jcamins I expect you have about... 800?
02:36 jcamins Something like that.
02:36 eythian We should have updatedatabase catch that.
02:36 jcamins We should.
02:36 mtompset >1200
02:36 jcamins Whatever.
02:36 jcamins A large number. Large enough that I didn't bother counting. :)
02:42 mtompset Should the port number be parsed, in your opinion, for bug 10733?
02:42 huginn` Bug[…]_bug.cgi?id=10733 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Memcached on package installs
02:43 jcamins I'd think, unfortunately, probably not.
02:43 jcamins Unless we're tokenizing it at some point, we can't really do any sort of sanity checking.
03:10 mtompset Hmm... if I use a parameter which implies another parameter should be used, should an error message be given, or should weird configuration be generated?
03:11 mtompset eg. sudo koha-create --create-db memctest3 --memcached-servers "machinea:911"  -- this generates blank configuration variables.
03:11 eythian what is blank?
03:11 eythian most things have sensible defaults
03:12 mtompset the server name, which is expected to be blank, because --use-memcached wasn't set.
03:12 eythian it shouldn't let your system get into a weird state, whether that's through defaults or errors.
03:12 eythian in that case I'd error out
03:12 eythian "can't use --memcached-servers without --use-memcache" or something
03:13 eythian as it indicates someone made a mistake somewhere.
03:13 jcamins What's the weird configuration that is being generated?
03:13 mtompset weird isn't generated.
03:13 eythian oh, so valid but not matching the options?
03:13 mtompset blank is, but weird should be, if no error is given.
03:13 eythian I'd throw an error if command line options don't make sense.
03:14 jcamins To me, your command line seems reasonable, if we are allowing the user to enable/disable memcached using a script. If we are not, then the script should just throw an error.
03:14 jcamins The second "the script" in that sentence refers to koha-create.
03:14 pastebot "mtompset" at pasted "test case: sudo koha-create --create-db memctest3 --memcached-servers "machinea:911"" (8 lines) at
03:15 eythian So, if --use-memcache was provided, they'd be filled in?
03:16 mtompset Correctly and as expected.
03:16 eythian then I'd throw an error, otherwise people will wonder why it's not working
03:40 mtompset Okay, commented on the bug with my test cases used. :)
03:54 mtompset I guess I didn't get my first sign off ever. :(
03:56 eythian well, you could always sign off on the first one and make a followup to fix it.
04:06 mtompset It's late. I'm not awake enough to do it.
04:06 mtompset Long day today.
04:06 mtompset But thanks for that suggestion. I may do that on another day.
04:07 mtompset Have a great day (24 hour period), #koha.
04:43 cait joined #koha
04:53 * dcook waves to cait
04:53 * cait waves to dcook
04:53 eythian hi cait
04:54 cait hi eythian :)
05:22 druthb o/
05:23 cait hi druthb :)
05:23 druthb hi.
05:24 cait shouldn't you be sleeping?
05:25 druthb probably, but I'm not, so meh.
05:25 cait meh.
05:25 * cait gives druthb some milk with honey
05:25 * druthb sips.
05:32 * dcook counts how many times he's had to restart Tomcat today...
05:33 cait ah tomcat...
05:33 * cait sends cookies
05:34 dcook Thanks :)
05:34 dcook Mmm cookies
05:34 dcook I finally figured it all out :)
05:35 dcook With Dspace that is
05:35 dcook Not life the universe and everything
05:41 cait it's a start :)
05:41 dcook hehe
05:42 dcook It certainly is :)
05:42 dcook I think I have an idea how to implement the Java transform that the University of Montreal sent me as well..
05:42 dcook Although I think I'd prefer XSLT...
05:46 cait java transform??
05:46 dcook Java crosswalk, I mean
05:46 dcook It's a Java class that converts the qualified Dublin Core in Dspace into MARC21 :)
05:47 cait ok
05:47 cait but why java??
05:47 dcook Dspace is written in Java :/
05:47 cait hm that explains a few things
05:47 dcook lol
05:47 dcook No doubt..
06:07 sophie_m joined #koha
06:32 reiveune hello
06:32 wahanui que tal, reiveune
06:32 cait hm ok, it just started raining again
06:32 cait grr.
06:38 cait bbl
06:38 cait left #koha
06:56 paul_p joined #koha
06:56 alex_a joined #koha
06:58 paul_p hello #koha
06:58 gaetan_B joined #koha
06:58 dcook salut paul_p et alex_a et gaetan_B
06:58 paul_p kf/cait not here ? surprising !
06:58 dcook I originally started that as just paul_p :p
06:58 dcook Ah, kf is on the way
06:58 dcook It's raining ;)
06:58 gaetan_B hello all :)
06:59 alex_a salur dcook
07:02 lds joined #koha
07:10 dcook \o/
07:10 dcook Got AgriOcean Dspace exporting using custom XSLTs...
07:10 dcook DC MARC21...
07:11 * dcook heads out while the sun is still up
07:11 dcook night all
07:11 wahanui goodnight dcook. You'll be back.
07:29 paul_p joined #koha
07:32 kf joined #koha
07:32 kf good morning #koha .)
07:32 kf :)
07:32 kf hm someone around who could point out the qa sprint in motd?
07:35 samueld joined #koha
07:35 samueld hi everybody
07:35 kf hi samueld :)
07:38 samueld i've a sql question: is it possible to modify the name of a categorycode. There's a problem with one in our db. I would like "employee" instead of "EMPLOYE".
07:39 kf you can modify the description
07:39 kf but not the code
07:39 kf the codes are internal
07:39 kf and they will always be upper case
07:39 kf because they are codes - not to be seen by the end user
07:39 kf you will have to add a new patron category and move your patrons over
07:40 kf it's the safest way - then you will have to add new configuration for your catecory - circulation rules, notice triggers, etc.
07:40 kf that's the reason you can't change it - it's referenced in other tables, so too dangerous
07:40 samueld ok, that's for why i've problem for matching categories with categories of our ldap
07:41 kf samueld: hm, i am not sure it should be aproblem - don't you tell it what you get and what to translate it to?
07:43 samueld we have sql error and i think the problem is that in one side (koha), i've a categorycode "EMPLOYE" and in the other side , i've "employee"
07:43 kf i think it's a question of your ldap confguration
07:45 rangi hmm the oldest bug in the signed off queue, i cant qa, its a catalyst one
07:45 rangi bug 10365
07:45 huginn` Bug[…]_bug.cgi?id=10365 enhancement, P5 - low, ---, chrish, Signed Off , Using published date on routing slips
07:45 kf yeah, i looked at that - but have to figure out the meaning of the different date fields myself first
07:47 rangi ill look at bug 9372 then
07:47 huginn` Bug[…]w_bug.cgi?id=9372 enhancement, P5 - low, ---, sophie.meynieux, Signed Off , Automatic carriage return in message_queue where content_type is html
07:48 kf cool - i will try to up 10365 on my list
07:48 rangi anythign is better than looking at c files
07:48 kf hehe
07:49 kf maybe you can add a bit to the wiki too?[…]-12_QA_Sprint_day - the idea was to show some activity
07:49 rangi k
07:50 Topic for #koha is now It's QA sprint day[…]-12_QA_Sprint_day
07:50 kf thx :)
07:52 rangi oh this one is pretty easy
07:53 * rangi sets up some overdues
07:57 kf ah before i forget
07:58 kf rangi++ # teaching me how to use git rebase --onto :)
07:59 gerundio joined #koha
08:02 rangi you wanna know something even cooler?
08:02 rangi[…]r-test-suite.html
08:03 rangi its not just for warns too
08:03 rangi got something that breaks a test
08:03 rangi do this
08:03 rangi git bisect run prove -l t/some/test.t
08:03 rangi and it will find the commit that cause the test to fail
08:03 rangi automagically
08:04 kf automagic!
08:04 rangi git bisect run
08:04 rangi is awesomesauce
08:06 kf agreed :)
09:40 kf rangi++
11:30 jwagner joined #koha
11:32 Viktor joined #koha
11:34 Viktor Hi #koha!
11:35 kivilahtio Ki ora #Koha!
11:36 NateC joined #koha
11:37 Viktor I have a bunch of libraries here in Sweden who want's to go visiting other libraries (in Europe I think) who has been running Koha for a while. Do you have any recommendations?
11:37 Viktor They are thinking of migrating to Koha and have taken an interest in our migration.
11:39 kivilahtio Do you have any more recent virtual appliances for Koha than the 3.8 I found here?[…]irtual-appliance/
11:39 kivilahtio I would really much like to test Koha with records, patrons, items, serials etc already in-db
11:40 kivilahtio I could ofc migrate up to v3.12 but that might be a tad hard
11:48 drnoe joined #koha
11:49 Dyrcona joined #koha
11:51 kf kivilahtio: look at doing a migration from scratch - i think it would be worthwhile
11:51 kf packages?
11:51 wahanui packages is at
11:52 kf and it's really easy with the packages
11:52 kivilahtio kf: Already did that, but I need example data
11:52 kf Viktor: i am not sure if one of our libraries would be able to host - and we only have special and academic - what are you looking for?
11:52 kf kivilahtio: there is some example data, but not for everything
11:53 kivilahtio kf: I don't want to write migration scripts for our data as I have a feeling there is a precofnigured and populated Koha demo virtual image lying around somewhere
11:53 kf we have some sample data, but not items and records
11:53 Viktor kf: Mainly they are interested in libraries that has been up and running for a while
11:53 kf if you run the web installer you can install patrons and the like and there are sql files for that, so you can also load them after installing
11:53 Viktor kf And it's public libraries.
11:53 kf hm
11:54 Viktor kf I've been browsing Lib-web-cats, but it's not all that easy to search for both Koha and geographic region.
11:54 collum joined #koha
11:54 kf Viktor: do you have an account at libwebcasts?
11:54 kf lib-web-cats?
11:54 wahanui hmmm... lib-web-cats is a good source, but to limit my search to koha and school library you need to get a free account :(
11:54 kf the advanced search can do that, but you need a login
11:55 Viktor kf I see - I'll look into it.
12:01 meliss joined #koha
12:09 mtompset joined #koha
12:10 mtompset druthb_away: Oh... you're away. :(
12:10 nengard joined #koha
12:12 Viktor Thanks kf I found it and had a look around. Still not easy but better :)
12:16 kf yw :)
12:28 laurence joined #koha
12:34 oleonard joined #koha
12:35 oleonard Hi #koha
12:37 khall is Joubu around?
12:50 * oleonard Meeting; bbl
12:52 kf hi khall
12:52 khall hey kf!
12:54 Joubu hi #koha
12:54 Joubu khall: yep :)
12:54 Joubu sorry, really busy this morning
12:54 khall I see you already replied to my questions, thanks!
12:54 kf khall: you are aware that i have been qaing that one for days? ;)
12:55 talljoy joined #koha
12:56 khall ahh, I see. I started another bug that depends on this one, and just had a couple qa relevant questions. I didn't change the status did I?
12:57 kf nope
12:57 kf just wanted to say i am already on that one
12:57 xekhz joined #koha
12:57 kf and the second comment is a good one :) i thought about that last night
12:57 xekhz hello ppl
12:57 kf hi xekhz
12:57 xekhz is this the correct place
12:57 xekhz to report a bug ?
12:58 kf we can try and help you to figure out if what you see is a bug
12:58 kf or a configuration issue or whatever
12:58 xekhz ok, i will try to explain
12:58 kf logging bugs should be done in bugzilla
12:58 kf bugzilla?
12:58 wahanui bugzilla is found at
12:58 xekhz[…]_bug.cgi?id=10828
12:58 huginn` Bug 10828: enhancement, P1 - high, ---, cnighswonger, NEW , Label creator returns empty pdf, xml or csv file
12:58 xekhz i have posted the bug here and the solution i have found
12:59 xekhz i dont know if it correct or not,
12:59 xekhz it works. i would apretiate any  input in this bug
12:59 kf hm yes, i was not sure i understood that one - was the file missing or did you update it with a newer one?
13:00 xekhz i updated it with an old one
13:00 xekhz from my prior instalation,
13:00 xekhz it copy the file from version 3.06.04
13:00 xekhz to version 3.12.02 and it worked
13:01 xekhz but the file in version 3.06.04 was from package koha-common...deb
13:01 kf i think we'd need to look at the diff to see why it fixed that
13:01 xekhz and the file from version 3.12.02 was in the koha.tar.gz
13:01 xekhz dowloaded from the koha website
13:01 kf there has been another report about problems with label printing and how the numbers are split
13:02 kf ping chris_n
13:02 xekhz i have tried to find out why, i the items hash are return empty on execution from
13:03 kf yeah i think we have to find the source of the problem
13:03 kf i can't look for it right now, but reporting everything you know on the bug is the best you can do right now I think and that looks good to me
13:03 meliss joined #koha
13:03 xekhz ok, i will keep reporting :)
13:06 khall qa suggestion:[…]_bug.cgi?id=10820
13:06 huginn` Bug 10820: minor, P5 - low, ---, kyle, Signed Off , Lost items on search results don't jive with record details
13:06 Joubu kf, khall: I will provide a followup and rebased patches for bug 8015
13:06 huginn` Bug[…]w_bug.cgi?id=8015 new feature, P4, ---, kyle.m.hall, Failed QA , Add MARC Modifications Templates
13:06 druthb o/
13:06 khall excellent!
13:07 khall g'day druthb!
13:08 druthb g'day.
13:13 tcohen joined #koha
13:46 maximep joined #koha
13:49 kf Joubu: thx!
13:49 kf and khall++ :)
13:49 kf the qa list on the wiki fills up a bit :)
13:49 kf[…]-12_QA_Sprint_day
13:55 BigRig joined #koha
14:02 kf Joubu++ :)
14:29 ebegin joined #koha
14:35 kf khall: interesting - did you shift refresh?
14:36 khall yes, I cleared my cache
14:36 kf could you try something?
14:36 kf there is a pref for currency format
14:36 kf doest hat make a difference?
14:36 kf khall: any javascript errors? and doy ou have the numeric values in the html table? (that's the change, similar to hw we handle dates)
14:37 khall CurrencyFormat doesn't change the behavior
14:44 kf if you look at the source, are the numeric values in the table?
14:44 kf it really worked for me. hm.
14:44 khall I feel like I'm missing a patch, where does formatted_budget_amount come from?
14:44 kf shoudl all be on this bug
14:44 khall 08:17 ~/kohaclone (bug8015-qa *$%|AM u+12)$ git grep formatted_budget_amount
14:44 khall koha-tmpl/intranet-tmpl/prog/e​n/modules/acqui/                <td class="data"><span title="[% loop_budge.budget_amount %]">[% loop_budge.formatted_budget_amount %]</spankoha-tmpl/intranet-tmpl/pr​og/en/modules/acqui/                <td class="data"><span title="[% loop_budge.budget_amount %]">[% loop_budge.formatted_budget_amount %]</span
14:45 kf can you give me the bug number?
14:45 khall not what I meant to post
14:45 khall 08:17 ~/kohaclone (bug8015-qa *$%|AM u+12)$ git grep formatted_budget_amount
14:45 khall koha-tmpl/intranet-tmpl/prog/e​n/modules/acqui/                <td class="data"><span title="[% loop_budge.budget_amount %]">[% loop_budge.formatted_budget_amount %]</spankoha-tmpl/intranet-tmpl/pr​og/en/modules/acqui/                <td class="data"><span title="[% loop_budge.budget_amount %]">[% loop_budge.formatted_budget_amount %]</span
14:45 kf accidentally deleted the mail already
14:45 khall 10792
14:45 kf it hsould be 2 patches
14:45 khall there's only one on the bug
14:45 kf ah no, actually one
14:45 kf gmcharlt didn't do a follow up
14:45 kf puzzled
14:46 kf i must have messed up something
14:46 kf this patch doesn't look complete
14:46 khall yeah, the previous one looks much different
14:46 kf can you try this one?
14:47 kf i just uploaded the wrng patch i guess :(
14:47 khall confirmed, that one works!
14:48 khall can you re-sign, then I qa?
14:49 kf not right now :(
14:49 kf I'd be ok if you added my sign off in that case - because i am quite sure i tested the complete patch and just messed up something in my branch before uploading
14:49 khall OK, CAN DO!
14:49 * khall didn't mean to yell ; )
14:49 kf :)
14:56 oleonard joined #koha
14:57 oleonard Hi again #koha
15:19 rambutan ping jcamins
15:20 kf hi oleonard :)
15:21 * oleonard is glad to know some people are alive
15:21 kf why wouldn't we?
15:21 jcamins Hello.
15:21 rambutan hey...
15:22 rambutan in the offline module, "download records" calls 'server:8080/cgi-bin/koha-oc/circ/'
15:22 oleonard kf: Just the quiet
15:23 rambutan this morning that's refusing to download any records, the spinner just sits there and spins
15:23 rambutan any ideas?
15:23 wahanui any ideas are welcome :)
15:24 rambutan Thats on linux mint which worked last night and on XP, both using FF 23.x
15:24 rambutan and on opensuse using FF 23.x
15:25 jcamins Does server:8080 actually match your server?
15:25 rambutan no, I've taken out the IP of course for high security obfuscation
15:26 jcamins I mean, does what it say match what it should say?
15:26 jcamins *says
15:27 rambutan the link (with the IP) is correct -- the path to that file is correct, and the file is there and appears intact.
15:28 rambutan uhhh, stand by one sec....
15:29 rambutan yep, nope, that's right
15:30 rambutan we get the "loading records, please wait", then spin spin spin
15:30 jcamins Lemme just check that I didn't get a path switched.
15:30 rambutan yea, I'm looking for that too -- "cgi-bin" maybe?
15:32 oleonard Joubu++ # for Bug 10856
15:32 huginn` Bug[…]_bug.cgi?id=10856 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Improve the previous and next items on the shelf browser
15:32 rambutan this is using the new file, BTW
15:32 jcamins rambutan: is there any javascript error in the console?
15:33 rambutan correction,
15:33 jcamins Oh, wait, it's looking for
15:34 jcamins And just to confirm, you logged out and logged back in to Koha?
15:49 chris_n kf: here momentarily
15:56 * mtompset takes a gasp of breath, before heading back into the crazy schedule!
15:59 * chris_n works on feeding himself a salad between keystrokes
16:00 smeagol joined #koha
16:00 smeagol Hi Brendan..can we do a screen session this afternoon?
16:05 paul_p kf = I really really really planned to dedicate my day to QAing. But many many phone calls, urgent mails, invoice to sent today-not-tomorrow, ... it's 6PM, and I QAed no patches :(((( It's really sad...
16:10 reiveune bye
16:10 reiveune left #koha
16:11 laurence left #koha
16:19 chris_n kf: if the call number splitting issues are related to LCCN they will probably have to wait for a fix for the underlying library used in 3.10.9 and above
16:19 chris_n otherwise, please open a new bug for them
16:20 bag morning all
16:23 kf chris_n: ?
16:24 kf chris_n: someone asked about the label printing - i think it was not related
16:24 kf chris_n: but i think we are seeing the same behaviour here actually, i will see if there is a file missing
16:25 meliss joined #koha
16:25 oleonard Good morning bag
16:25 kf hi bag
16:25 bag hey oleonard and kf
16:32 chris_n kf: are you referring to bug 10828?
16:32 huginn` Bug[…]_bug.cgi?id=10828 enhancement, P1 - high, ---, cnighswonger, NEW , Label creator returns empty pdf, xml or csv file
16:32 chris_n if so, I think that is a package bug or some such
16:33 kf i am not sur i understand the notes correctly - if he overwrote the file from another version or if it wasn't there
16:33 kf did you happen to test in 3.12 recently if it works right?
16:33 kf I have a report from a library, but haven't got around to really testing it out yet
16:34 chris_n all of the tests I ran for the LCCN bug used and worked as expected
16:34 chris_n I have not actually produced any pdf's from 3.12 recently
16:35 chris_n but I do note that has contents in the repo, so I suspect something else went wrong to produce empty files on his system
16:35 chris_n errr
16:36 chris_n maybe I'm not understanding the notes either
16:36 chris_n I guess it is the empty pdf he is referring to in his last post
16:37 chris_n at any rate it looks like he installed the koha-common package and things started working
16:37 * chris_n has to run
16:38 mtompset Run ,forest, run! ;)
16:38 chris_n please annotate the bug if it turns out that you have the same issue
16:38 chris_n mtompset: ;-)
16:39 xekhz left #koha
16:40 * oleonard wonders wtf that parting quote meant
16:40 kf chris_n: i will... just a bit short of time right now :)
16:41 chris_n oleonard:[…]un-i-don-t-get-it
16:41 * chris_n is gone for real this time :)
16:42 mtompset No, I think oleonard was wondering about the HHGTTG quote.
16:42 oleonard Oh that's from HHGTTG? *whew*
16:43 mtompset[…]alaxy#Chapter_7_3
16:44 mtompset It's from "So long, and thanks for all the fish"
16:44 mtompset An appropriate exit message, I think. :)
16:45 * druthb stands up, yells "42!" and sits back down sheepishly.
16:45 * mtompset claps his hands like on a game show, "Good answer! Good answer!"
16:45 gmcharlt but ... but ... what's the question?
16:53 druthb :P
16:54 gaetan_B bye !
17:02 * magnuse waves
17:07 oleonard Hi magnuse
17:07 magnuse kia ora oleonard
17:08 magnuse the new theme in yet?
17:09 mtompset Greetings, magnuse. :)
17:09 magnuse hiya mtompset
17:10 magnuse and what does the fox say?
17:10 wahanui
17:10 magnuse moahahah
17:10 oleonard magnuse: Did you sign off on it yet? ;)
17:11 magnuse oleonard: um, no not yet ;-)
17:13 * oleonard is stubbornly refusing to watch that video, whatever it is.
17:14 kf oleonard: but but but... what does the fox say?
17:18 jcamins We should ask wahanui.
17:18 jcamins wahanui: what does the fox say?
17:18 wahanui
17:21 mtompset At least it is way better than Crazy Frog (
17:21 tcohen hi #koha
17:22 mtompset Greetings, tcohen. :)
17:24 magnuse oleonard: i have been busy screwing up the migration for viktor...
17:25 oleonard Well, what's important is that you're being productive :)
17:25 kf how did it go?
17:25 kf oleonard++
17:25 kf #optimism :)
17:27 magnuse hehe
17:27 magnuse still some kinks to iron out
17:28 magnuse we were unsure about what to base the home-/holdingbranch info on, and we chose the wrong one
17:28 jcamins Speaking of ironing, I need to do some ironing tonight.
17:28 magnuse and i left out a couple of columns when i populated the reserves table
17:28 magnuse jcamins: luck you :-)
17:30 * mtompset smirks, "Interesting typo."
17:30 magnuse ?
17:31 mtompset magnuse: Are you a touch typist?
17:31 magnuse yes, in the sense that i touch the keyboard when i type :-)
17:31 * magnuse missed the meeting - gah!
17:32 mtompset Yes, it was yesterday.
17:33 magnuse i thought i would make it, but things take too much time...
17:35 kf left #koha
17:36 mtompset khall: What are the MySQLisms in the Koha::Sequence?
17:36 mtompset is SUBSTR a MySQLism?
17:37 oleonard where's mbalmer when you need him?
17:37 khall mtompset: you documented that reset_everything and get_next_value use mysql'isms. Is the no longer the case?
17:38 mtompset Haven't looked at the code in a long time, I'll re-check.
17:39 mtompset Yes, SUBSTR is a MySQLism.
17:40 jcamins Oh man. It's *black* out.
17:42 mtompset LAST_INSERT_ID() is the other MySQLism.
17:42 oleonard jcamins: Storm?
17:42 wahanui i guess Storm is named Joachim?
17:42 jcamins oleonard: yep.
17:45 oleonard Is it named Joachim?
17:49 jcamins I think it might be. That's what wahanui says, anyway.
18:07 cait joined #koha
18:10 mtompset ARG! CAST(blah as UNSIGNED) is a MySQLism?!
18:10 * mtompset grumbles about data types.
18:31 cait khall++
18:36 * magnuse wonders how a book kan be "on loan to x" and "available" at the same time...
18:37 cait hm something with the status i guess
18:37 cait where doe sit show what?
18:37 cait do you have set the due date in the item?
18:38 magnuse not sure yet
18:39 magnuse in the opac it shows as on loan, but in the intranet it says "available" as well
18:40 tcohen reload the page magnuse :-P
18:42 magnuse tcohen: ?
18:47 magnuse hm, it might be missing a value for items.onloan
18:50 tcohen items.onloan?
18:50 wahanui items.onloan is NULL
18:52 magnuse according to http://schema.koha-community.o[…]tables/items.html "[onloan] defines if item is checked out (NULL for not checked out, and checkout date for checked out)"
18:52 tcohen is it migrated data?
18:52 magnuse looks more like it holds the due date, though
18:52 tcohen otherwise you might have found a bug (koha not setting the date there)
18:52 magnuse tcohen: yup, guily!
18:52 magnuse s/guily/guilty/
18:54 tcohen problem solved then :-D
18:58 magnuse yup
18:58 magnuse not sure it is good db design to have the due date in the items table, though...
19:00 cait magnuse: it's becuse of indexing
19:01 magnuse ah, of course
19:01 cait the availability information is built from that
19:02 cait been there too ;)
19:07 magnuse for the record: update items, issues SET items.onloan = issues.date_due where items.itemnumber = issues.itemnumber;
19:09 magnuse ...and re-index
19:09 cait yep that looks about right :)
19:11 magnuse :-)
19:11 cait any more problems? :)
19:12 magnuse yup, but they will have to wait, i think :-)
19:21 talljoy1 joined #koha
19:22 magnuse nah, i'll try one more, cait
19:22 cait hm?
19:22 magnuse i'll try one more problem with my migrated data
19:23 * druthb perks.    Migration?
19:26 magnuse hehe
19:26 magnuse druthb: you would have been ashamed of me...
19:27 * magnuse gets a picture of a circus horse smelling sawdust in his head
19:29 cait lol
19:29 cait a cute circus horse of course?
19:29 magnuse but of course!
19:30 magnuse oh my, i have itemnumbers that occur twice in the issues table...
19:31 magnuse and also borrowernumber = NULL in the issues table,,,
19:33 cait hm that's not ideal
19:33 cait can you see how it happened?
19:34 magnuse not really
19:34 magnuse i might have imported it like that, because i did not check the data from the old system thorougly
19:35 magnuse (always easier to blame someone else, innit? :-)
19:37 magnuse also some issues where the itemnumber is null
19:37 magnuse those aren't very useful, are they now?
19:46 meliss joined #koha
19:46 cait hm probably not
19:49 cait gmcharlt++ :)
19:50 cait bgkriegel++
19:51 cait hm twitter down?
19:55 magnuse @isitdown
19:55 huginn` magnuse: downloading the Perl source
19:56 magnuse nm
20:02 magnuse oops, we need to have another gbsd soonish
20:08 magnuse have fun #koha
20:18 NateC joined #koha
20:36 drnoe_away left #koha
22:07 bag @seen kf
22:07 huginn` bag: kf was last seen in #koha 4 hours, 42 minutes, and 33 seconds ago: <kf> #optimism :)
22:08 bag working on QA'ing bug 9299 just being careful :)
22:08 huginn` Bug[…]w_bug.cgi?id=9299 major, P3, ---, nunyo, Signed Off , for loop in requires an extended patron attribute to be set or LDAP logins fail
22:08 cait bag++ :)
22:09 cait i will do some more tomorrow morning - long day today, but i checked, it's until short before noon tomorrow :)
22:09 bag ah you are cait and not kf :P
22:09 cait yep
22:10 cait want to add to our list? :)[…]-12_QA_Sprint_day
22:13 twirlip_ joined #koha
22:26 eythian hi
22:26 cait hi :)
22:28 cait @wunder Konstanz
22:28 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 10.8°C (12:25 AM CEST on September 13, 2013). Conditions: Rain. Humidity: 93%. Dew Point: 10.0°C. Pressure: 30.18 in 1022 hPa (Steady).
22:28 cait brr
22:28 bag @wunder 93102
22:28 huginn` bag: The current temperature in Westside, Santa Barbara, California is 26.1°C (3:28 PM PDT on September 12, 2013). Conditions: Clear. Humidity: 52%. Dew Point: 16.0°C. Pressure: 29.87 in 1012 hPa (Falling).
22:29 cait brb
22:29 wizzyrea @wunder nzwn
22:29 huginn` wizzyrea: The current temperature in Wellington, New Zealand is 14.0°C (10:00 AM NZST on September 13, 2013). Conditions: Clear. Humidity: 48%. Dew Point: 3.0°C. Pressure: 29.74 in 1007 hPa (Steady).
22:29 wizzyrea hm nice
22:38 cait lots nicer than here :)
22:40 cait good night all :)
22:40 cait left #koha
22:46 maximep @wunder cyqb
22:46 huginn` maximep: The current temperature in lac st-charles, quebec city, Quebec is 19.4°C (6:46 PM EDT on September 12, 2013). Conditions: Overcast. Humidity: 92%. Dew Point: 18.0°C. Pressure: 29.65 in 1004 hPa (Falling).
22:47 maximep still incredibly hot and humid :/
23:30 papa joined #koha
23:34 maximep left #koha
23:37 dcook joined #koha
23:54 eythian wahanui: george lucas is also george lupus
23:54 wahanui OK, eythian.
23:55 mtompset @seen papa
23:55 huginn` mtompset: papa was last seen in #koha 2 weeks, 3 days, 16 hours, 26 minutes, and 13 seconds ago: <papa> gotta go, have a nice day all of you
23:56 papa no way
23:56 eythian yes way
23:56 mtompset maybe way? :P
23:56 dcook make way?
23:56 mtompset dcook++ # better pun!
23:57 mtompset papa, I just noticed the bug you signed off doesn't apply anymore, and I figured I should rebase it, before QA complains about it not applying.
23:57 papa sure
23:57 mtompset If I put up the rebased patch, will you sign it off again?

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