Time Nick Message 00:01 wizzyrea well she introduced herself as camille ^.^ 00:03 jcamins Yep, that's her. 00:33 drojf [off] for the kohacon 2014 voting, should there be an email field to fill in (which won't be validated) or something? or do we just take all the clicks that people feel like doing? they could enter fake addresses or real aliases anyway 00:33 wizzyrea what is with the offing! 00:34 drojf [off] i'm a secret guy :P 00:35 drojf [off] and you look weird in the logs for talking to yourself all day :D 00:35 dcook [off] Bahahaha 00:35 wizzyrea I woulnd't look weird if you all weren't obsessed with off. 00:35 wizzyrea why shouldn't the discussion be in the log? 00:35 wizzyrea that kind of ruins the idea of transparency. 00:38 jcamins Yeah, but it also protects Koha from being associated with some rather extreme (and unpopular) attitudes. 00:39 wizzyrea mmm the truth is hard sometimes. 00:40 jcamins It is. But I don't have the right to put it in your mouth. 00:41 wizzyrea well I wasn't specifically referring to the stuff YOU were talking about 00:41 wizzyrea more drojf :P 00:41 wizzyrea and the email question 00:41 dcook :O 00:41 dcook drojf: You've been outed! 00:41 dcook outted? 00:42 dcook outed 00:42 dcook That almost looks like it can't be a real word... 00:42 * dcook is going to remember it for the next time he plays Scrabble though 00:42 wizzyrea I get wanting to not log your unpopular opinions. 00:43 wizzyrea but asking a question about voting probably deserves to be logged. 00:43 wizzyrea because offing looks like you're trying to hide something. 00:44 wizzyrea clearly mine is the unpopular opinion. So I'll just leave you to your offing. 00:45 dcook Actually, I agree with you, wizzyrea 00:45 dcook About it being a question deserving of logging 00:45 dcook Not that your opinion is unpopular :p 00:45 drojf i understand what you're saying and i think you are right. anyway it is almost 3am and it did not help me at all with the actual question so i'll rather go to bed 00:46 dcook Personally, as for the answer to the question, no idea 00:46 wizzyrea yea, idk 00:46 dcook If people want to "cheat", they're going to do it one way or another? 00:46 wizzyrea about the question anyway 00:46 wizzyrea 3am is way too late 00:46 wizzyrea go to bed :) 00:46 drojf full moon :/ 00:47 wizzyrea oh man, yea. good luck. 00:47 wizzyrea i haven't slept well in 3 days now, presumably because of the full moon. 00:47 drojf i was up until 5 or 6 last night 00:47 wizzyrea ^ there is actually some research that shows even if you don't know the moon is full, sleep is disrupted 00:48 wizzyrea or if you can't see the moon. 00:49 drojf i think i saw it for 10 seconds two nights ago. don't know if that is the reason but i guess it would have worked without that like it did not :D 00:49 dcook My wife bought me an $80 pillow. I've been sleeping like a baby. 00:49 dcook Or a baby that sleeps well...which I did...as a baby... 00:49 eythian wahanui: kiwi is http://www.thecivilian.co.nz/prime-minister-eats-kiwi-just-to-make-sure-were-not-missing-out-on-anything/ 00:49 wahanui ...but kiwi is the bird it takes it name from... 00:49 eythian wahanui: kiwi is also http://www.thecivilian.co.nz/prime-minister-eats-kiwi-just-to-make-sure-were-not-missing-out-on-anything/ 00:49 wahanui okay, eythian. 00:49 * dcook didn't know that people thought the full moon disrupted sleep? 00:50 dcook Which is perhaps why it's never disrupted my sleep? 00:50 wizzyrea I have been noticing this my whole life. 00:50 wizzyrea before I even knew it was a thing 00:50 wizzyrea I just thought I didn't sleep well sometimes for no good reason. 00:50 wizzyrea but if I keep track, it happens that I sleep not well more often when there is a full moon. 00:51 dcook Hmm 00:51 wizzyrea it sounds crazy! 00:51 dcook It does sound crazy 00:51 wizzyrea it sounds like pseudoscience! 00:51 dcook Next time I don't sleep well, I'll try to remember to log it 00:51 dcook It's usually back pain 00:51 dcook Or I'm too hot 00:51 wizzyrea there are lots of reasons to not sleep well. 00:52 dcook Possibly emotional stuff but I don't have that many emotions so not that :p 00:52 wizzyrea kek 00:52 * dcook used to have the occasional nightmare during undergrad about not having good enough essays 00:52 drojf i have a long history of bad sleep and if i know it is full moon i blame that. else i blame other things. :D 00:52 dcook hehe 00:53 drojf but i'll give it a try. good night #koha :) 01:30 mtompset okay... I'm still confused... http://paste.koha-community.org/222 -- My debian VM fails, but my ubuntu VM works? 01:31 mtompset Okay... I must have broken something in C4::Circulation somehow?! 01:39 mtompset ARG! 01:39 mtompset The setenv mess. 01:41 dcook That'll get ya 02:08 mtompset YAY! My patch found a bug in a test. 02:08 mtompset my ($usernum, $userid, $usercnum, $userfirstname, $usersurname, $userbranch, $branchname, $userflags, $emailaddress, $branchprinter, $persona)= @_; 02:09 mtompset C4::Context->set_userenv(1,'kmkale' , 1, 'kk1' , 'IMS', 0, 'kmkale@anantcorp.com'); 02:09 mtompset without the shift, IMS is the branchcode. 02:09 mtompset with the shift, 0 is the branchcode. 02:10 mtompset the parameters in the call don't match the parameters in the parameters in the function. 02:11 dcook True that 02:11 dcook Those parameters could be worded a bit nicer too.. 02:12 eythian that's a terrible way of returning a set of values 02:12 mtompset It's C4::Context, what do you expect? :) 02:12 eythian oh, not returning 02:13 eythian providing. 02:13 eythian Still terrible :) 02:13 eythian yeah 02:13 eythian I'd replace it with a hash (though really it should probably be an object or something.) 02:14 dcook Mmm, a hash would be nicer 02:15 mtompset I was just thinking that. 02:15 eythian as a basic guide, I tend to think that if there are more than 3 arguments, you should probably do it some other way. 02:15 eythian situationally dependent, of course. 02:15 dcook Sounds like a good guide 02:15 jcamins hashref, please. 02:15 mtompset because too many parameters makes for harder debugging. 02:16 dcook Yes, totes hashref 02:16 jcamins That's what eythian means by replacing it with a hash, actually. 02:16 eythian hashref is more traditional, yeah. 02:16 mtompset We know... ref is another 3 characters. :P 02:16 dcook I was wondering about hashrefs the other day.. 02:16 eythian well, you can use either, but hashref is more standard. 02:17 dcook So you can have a hash than create a hashref from it 02:17 dcook But you can also define a hashref from the start without having an original hash 02:17 eythian dcook: sure can 02:17 dcook Why is that? 02:17 eythian $hashref = { a => 'b', c => 'd' }; 02:17 dcook Yeah. That. 02:18 eythian %hash = ( a => 'b', c => 'd' ); 02:18 rangi you are making a hash, and a ref to it in one go 02:18 dcook But if it's a reference...does that mean that it makes a hash at the same time as it makes the reference? 02:18 dcook Mmm, k 02:18 rangi both of them make a hash 02:18 eythian oh, I though you were asking a question there 02:18 dcook I figured that had to be the case 02:18 rangi %$hashref 02:18 rangi gets you the hash 02:18 rangi my %hash = %$hashref; 02:18 dcook Yeah, dereferencing hashrefs was...interesting 02:18 dcook When I was first figuring it out 02:18 eythian same as dereferencing anything else 02:18 dcook @$arrayref 02:18 huginn` dcook: I suck 02:19 eythian which isn't always not non-unconfusing. 02:19 dcook lol 02:19 cjh heh 02:19 dcook eythian: I had only ever coded in PHP before Koha. If there are references in PHP, I've never seen 'em :S 02:19 dcook Actually, now when I write in PHP, I miss Perl... 02:19 eythian ah yeah, php hides things like I think. 02:20 wizzyrea which isn't always not non-unconfusing - I had to read this sentence 3 times. 02:20 dcook hehe 02:21 dcook Actually, that totally explains my first encounter with references 02:55 mtompset question: if I have a biblio number of 28, and a biblioitems record matching with biblioitemnumber=28, should I not have an items record with biblionumber=28 or biblioitemnumber=28? 02:56 jcamins mtompset: sure, if your bib has items. 02:56 dcook ^^ 02:57 mtompset and if you delete an item, the items record would basically move to the deleteditems table? 02:58 eythian yeah 02:59 mtompset without touching biblioitems? 03:04 mtompset Is there a way to batch delete biblios with no items? 03:05 eythian not in the UI, but you can make a report that'll find them. 03:05 eythian well, you can delete them using the output of that report. 03:18 dcook Delete them manually? 03:18 dcook mtompset: I think we have a PHP script that clears out bib records with no items 03:18 mtompset Anyways... next question. :) 03:19 dcook Although I think it's a bit dangerous 03:19 wizzyrea eythian: isn't there a script to do that in the migration tools? 03:19 mtompset Okay, I have a patch to fix the calling convention to set_userenv. 03:19 eythian hmm. Maybe. 03:19 wizzyrea I have this weird feeling that there is a tool for that 03:19 eythian there's a lot of scripts in there. 03:19 wizzyrea *nod* I'll check 03:19 mtompset When I fixed this, it busted t/Circulation_barcodedecode.t 03:20 wizzyrea mtompset: http://kohadevreactions.tumblr.com/post/61012696259/fixed-a-bug-introduced-a-bug-kohails 03:20 mtompset The calling convention was right, but the functions parameters (as shown before) were wrong. 03:20 mtompset Do I fix it in the same bug, or a different bug? 03:22 eythian probably as another patch on the same bug 03:24 mtompset so a multipatch fix on the same bug... okay. 03:25 eythian especially if your stuff needs that to work right, but it's probably too small of a thing to warrant its own ticket. 03:30 mtompset How do you git bz 2 commits? 03:30 dcook I think it says in the wiki 03:30 wizzyrea ^ 03:30 wizzyrea towards the bottom 03:31 dcook http://wiki.koha-community.org/wiki/Git_bz_configuration#Attaching_patches 03:31 dcook I think I usually use something like HEAD~1..HEAD 03:32 dcook Although I guess HEAD~1^ would probably work 03:32 * dcook can't remember the particular differences between ~ and ^ in relation to ancestors and such.. 03:33 mtompset And now I am realizing why I like tiny single patches. 03:33 eythian just use HEAD 03:33 eythian or you can do HEAD^.. for the previous two 03:34 eythian ^ just means "previous", so you can do HEAD^^^^ 03:34 eythian oh, or ^3 03:34 dcook What does ~ mean then? 03:35 eythian I don't know it nearly well enough to explain it. 03:36 eythian oh actually 03:36 eythian ^3 would be wrong 03:36 mtompset I just used HEAD, then unobsoleted the original patch. 03:36 mtompset and confirmed it with a git bz apply on a test branch. 03:36 eythian ^ is the first parent, ~2 is the parent's parent. 03:37 eythian so ~2 === ^^ 03:37 eythian but ^2 is the second parent, not the parent's parent. 03:37 mtompset But ^^ looks happier. :) 03:37 dcook Mmm, right, that's it 03:38 dcook So HEAD~2 is head's parent's parent 03:38 eythian yeah 03:38 eythian following the first parent only 03:39 dcook So what would HEAD~^ be? 03:39 dcook Ack 03:39 eythian nothing 03:39 dcook HEAD~2^ 03:39 eythian I think 03:39 jcamins dcook: typo? 03:39 dcook jcamins: :p 03:39 eythian the parent of the second parent 03:39 wizzyrea step-grandparent? 03:39 wizzyrea j/k 03:39 wizzyrea j/k 03:39 wizzyrea j/k 03:39 jcamins wizzyrea: once-removed. 03:39 dcook But HEAD~2^.. is supposed to be a range of 3 patches 03:40 dcook Head, head's parent, head's parent's parent 03:40 wizzyrea step-great-grandparent 03:40 eythian yeah, that sounds about right. 03:40 jcamins Yeah, you're right. Great-grandparents. 03:41 wizzyrea now the word parent looks weird to me 03:41 jcamins Or, great-grandparent. 03:41 eythian no step though, it's not chronological. Many people have two parents. 03:41 jcamins It's just one. 03:42 wizzyrea i know I was being not-funny 03:42 * jcamins laughed. 03:42 wizzyrea har har 03:42 * wizzyrea was imagining this screwed up family 03:42 wizzyrea relations all over the place! 03:42 wizzyrea in every sense of the word "relations 03:42 wizzyrea " 03:43 dcook I was just thinking that, wizzyrea :p 03:43 dcook Oh my... 03:43 eythian https://lh6.googleusercontent.com/-1bWGM1YK_mA/UjtbGDBXNzI/AAAAAAAARcU/wdZdBpKHJZU/s500-no/1235256_661297993903107_233666193_n.jpg <-- wizzyrea 03:43 * dcook has seen some odd Git diagrams... 03:43 wizzyrea ^ like that family 03:43 * dcook loves that image 03:44 eythian except git is just a directed acyclic graph, so that makes it easy. 03:44 dcook It would be tough to find the Doctor situation in Git 03:45 dcook When specifying a range of commits...I think you have to specify the one above the one you're including? 03:45 jcamins dcook: yes. 03:45 jcamins Well... usually. 03:45 dcook So HEAD~2^ would actually be head, head's parent, head's parent's parent, head's parent's parent's parent 03:45 dcook And the range just takes the first three 03:46 dcook Which means the wiki is slightly wrong then 03:46 dcook Well, not in the HEAD~2^ example 03:46 dcook Actually, no 03:46 dcook It's not 03:46 dcook HEAD~2..HEAD, HEAD~commitid..HEAD might be misleading 03:46 dcook But they're not necessarily wrong 03:47 jcamins We have HEAD~2^ on the wiki? 03:48 dcook "If you know you've 3 patches to attach, you can also use HEAD~2^.. to attach the 3 patches at once" 03:49 eythian git bz doesn't require specifying the commit above in general 03:49 eythian git format-patch, however, does. 03:49 eythian I don't know why it's not consistent 03:49 dcook <rev1>..<rev2> 03:49 dcook Include commits that are reachable from <rev2> but exclude those that are reachable from <rev1>. 03:49 dcook But it seems to me that it also excludes <rev1> 03:50 mtompset And that is why I like single patches. Too much HEAD-y stuffs. 03:50 dcook B..C C 03:50 dcook Makes sense I guess 03:50 dcook mtompset: But wouldn't you rather know how it works 03:50 dcook Than limit yourself to single patches? 03:51 wizzyrea HEAD. Relations. It's getting hot in here. 03:51 dcook We haven't even talked about the hunks yet, wizzyrea. Calm down. 03:51 dcook :p 03:51 wizzyrea *snicker* 03:52 mtompset I'd rather it work in a way that is intuitive and obvious. It isn't. 03:52 dcook But don't you enjoy being a master of the arcane and esoteric?! 03:53 mtompset Only occasionally... Not always. 03:53 wizzyrea you probably only need a really good short class on git. 03:53 mtompset Not when I want it to just work. 03:53 wizzyrea then it will just work. 03:53 dcook ^^ 03:54 dcook Git seemed a bit imposing when I first started using it, but it's pretty sweet 03:54 dcook Like wizzyrea is saying, once you get the hang of it, you can rattle off commands without realizing it 03:54 wizzyrea you can also find yourself having 2 hour arguments with it. 03:54 dcook wizzyrea: I'm headed to the beach in 5 minutes :p 03:55 wizzyrea No, Git! NO! 03:55 wizzyrea Bad git! 03:55 dcook Ah, "with" it 03:55 wizzyrea are you now. 03:55 dcook I just meant I'm leaving the discussion.. 03:55 wizzyrea it is decidedly not beach weather here 03:55 dcook Wife got off work early and the boss is letting me out 03:55 wizzyrea @wunder nzwn 03:55 huginn` wizzyrea: The current temperature in Wellington, New Zealand is 16.0°C (3:00 PM NZST on September 20, 2013). Conditions: Scattered Clouds. Humidity: 82%. Dew Point: 13.0°C. Pressure: 29.80 in 1009 hPa (Steady). 03:55 dcook @wunder sydney, australia 03:55 huginn` dcook: The current temperature in Sydney, New South Wales is 22.0°C (1:30 PM EST on September 20, 2013). Conditions: Clear. Humidity: 16%. Dew Point: -5.0°C. Pressure: 29.68 in 1005 hPa (Falling). 03:55 wizzyrea hm, temp is ok 03:55 wizzyrea but the sky is not beachy. 03:55 dcook Too bad my swimmers are in my gym bag 03:56 dcook mashed potato clouds and blue sky 03:56 dcook Hmm, a bit windy though.. 03:57 wizzyrea scattered clouds my ass. Try "touching the treetops" clouds. 03:58 dcook lol 03:58 wizzyrea try "gonna rain at any second" clouds. 04:00 mtompset Interesting pondering: why does reference to one's bottom express disbelief? 04:00 mtompset @wunder l7e 5y5 04:00 huginn` mtompset: The current temperature in Schomberg, Ontario is 16.1°C (12:00 AM EDT on September 20, 2013). Conditions: Clear. Humidity: 91%. Dew Point: 15.0°C. Pressure: 30.01 in 1016 hPa (Steady). 04:00 dcook Hmm 04:02 wizzyrea everyone's butt is broken. It's got a crack in it. 04:02 dcook http://dictionary.cambridge.org/dictionary/british/my-arse 04:03 dcook I like how it says "offensive" under "my arse!" 04:03 dcook Anyway, time to not get sand everywhere 04:03 dcook Ta all 04:03 mtompset Bye, d-- 04:04 mtompset So a crack signifies disbelief? 04:05 * mtompset shrugs, and considers going to bed. 04:12 mtompset Are we supposed to advocate for our bugs on the channel? 04:12 wizzyrea That's fine, but probably a terrible time to :) 04:13 wizzyrea as late friday and most of the rest of the world is in late evening/late night/early morning 04:13 mtompset True... it is likely lunch somewhere. :) 04:13 mtompset I'll wait until 9/23 ;) 04:14 mtompset Have a great day, #koha. 04:14 * mtompset waves bye to wizzyrea. 06:10 * Kaptein_Sabeltann waves 06:12 magnuse awww... http://wiki.koha-community.org/wiki/Kohacon13/Arrivals 06:36 reiveune hello 06:42 magnuse bonjour 06:42 magnuse @wunder boo 06:42 huginn` magnuse: The current temperature in Bodo, Norway is 15.0°C (8:20 AM CEST on September 20, 2013). Conditions: Mostly Cloudy. Humidity: 72%. Dew Point: 10.0°C. Pressure: 29.68 in 1005 hPa (Steady). 06:42 magnuse @wunder marseille 06:42 huginn` magnuse: The current temperature in Marseille, France is 14.0°C (8:30 AM CEST on September 20, 2013). Conditions: Clear. Humidity: 67%. Dew Point: 8.0°C. Pressure: 29.98 in 1015 hPa (Rising). 06:42 magnuse hah! ;-) 06:44 sophie_m yes, but the wind is down today the temperature wil increase magnuse :-) 06:46 magnuse and we can expect lots and lots of rain, so i'm just bragging while i can :-) 06:50 alex_a bonjour 06:50 wahanui what's up, alex_a 07:06 gaetan_B hello! 08:36 drojf good morning #koha 09:16 tweetbot_ [off] @shangueh: "On vient de passer #KohaILS de v3.8.5 à v3.8.17, on essuie les plâtres mais pour le moment rien de grave." 09:43 magnuse has anyone tried importing marcXchange data with bulkmarcimport.pl? 10:06 random_wind Would anyone know if the rebuild_zebra script is redundant in 3.12? 10:06 random_wind I ask because it seems my indexes are updating with running this!? 10:06 random_wind -without running! 10:07 magnuse random_wind: you need that script to update zebra when records are updated 10:07 magnuse how did you install? using the packages? 10:08 random_wind installed from pacakges. My indexes are updating with running this script though - it is strange. 10:08 random_wind add, remove or mod bib/item and it will reflect in Koha 10:08 random_wind opac and staff 10:09 rangi thats because the packages set up rebuild_zebra to run as a cron job 10:09 random_wind only process running is koha-common spawned processes? 10:09 random_wind under which user? 10:09 random_wind No user on the system has any crontab setup 10:09 rangi it wont 10:09 rangi look in /etc/cron.d/koha-common 10:10 random_wind sneaky! 10:10 random_wind at least that explains it! 10:10 random_wind Thanks @rangi 10:11 random_wind although, this seems like an odd thing to do! 10:11 rangi nope 10:12 rangi its a very standard thing to do 10:13 rangi look in /etc/cron.daily you'll see things like apache and logrotate do the same thing 10:14 rangi Packages must not modify the configuration file /etc/crontab, and they must not modify the files in /var/spool/cron/crontabs. 10:14 rangi If a package wants to install a job that has to be executed via cron, it should place a file named as specified in Cron job file names, Section 9.5.1 into one or more of the following directories: 10:14 rangi /etc/cron.hourly /etc/cron.daily /etc/cron.weekly /etc/cron.monthly 10:15 rangi http://www.debian.org/doc/debian-policy/ch-opersys.html 10:15 random_wind It's confusing regarding the permission on the zebra indexes though, isn't it? 10:15 rangi no 10:16 random_wind right. Before packages (using the tar install) Zebra used to have to run as the koha user, not as root. 10:16 random_wind all my zeb indexes are owned by root 10:16 rangi yes but the packages support multiple users 10:16 rangi and multiple sites 10:17 random_wind Sure, I appreciate that. Still not sure I like the permission changes though! 10:17 rangi mine aren't they are owned by the instance owner 10:18 rangi ls -l /var/lib/koha/persona 10:18 rangi drwxr-xr-x 6 persona-koha persona-koha 4096 Jun 10 2012 authorities 10:18 rangi drwxr-xr-x 6 persona-koha persona-koha 4096 Jun 10 2012 biblios 10:18 random_wind instance owner:instance owner ? 10:18 drojf if they are owned by root you broke them already :p 10:18 rangi yep 10:18 random_wind hum.....strange. 10:18 random_wind did a straight forward package install though! 10:18 rangi installed koha-common then did a koha-create right? 10:19 random_wind yeah, as per the docs. 10:19 random_wind Ubuntu 12.10 10:19 rangi not sure what you did, but there is no way they should be owned as root 10:19 rangi koha-rebuild-zebra does sudo -u "$instancename-koha" 10:20 rangi ie, runs as your instance user (for each of your instances) 10:20 random_wind Yeah, that is why I though. Just as an aside. If the cron is run by root how does it assume the instance user to update their files? 10:20 rangi i just pasted how 10:21 rangi what is in /var/lib/koha for you? 10:21 random_wind Nothing, doesn't exist 10:22 rangi so where are your zebra indexes then? 10:22 random_wind Unfortunatley I need to run......however, I am pretty sure (as I would say you are!) that I have done something strange during the install. Thanks for clearing up the cron job! 10:23 rangi heh 10:24 drojf huh? :D 10:24 rangi yeah, i wonder what docs 10:25 drojf i think "that blog" has instructions for 12.10 :/ 10:25 rangi cos if you have no /var/lib/koha ... something odd is going on 10:26 drojf yeah that sounds very strange 10:26 rangi ah well maybe they learnt something about packaging rules at least :) 10:26 drojf heh :D 10:26 rangi right time for sleep 10:26 drojf good night rangi 10:26 * drojf hits the shower 11:13 magnuse kia ora khall 11:26 khall hey magnuse! 11:26 wahanui rumour has it magnuse is afraid that we added another 10000 bugs while he was eating pizza 12:00 rsm =>i need to develop pdf format reports in koha any help?? 12:02 rsm hi there can u help me regarding some pdf reports in koha 12:07 nengard rsm that would be a new feature for Koha - a development is needed. Right now it just generates CSV files or HTML or reports. 12:08 magnuse but you could take the csv, open it in e.g. LibreOffice and produce pdf from that 12:14 rsm ok but can we built a button to generate pdf reports 12:18 oleonard Hi #koha 12:21 nengard rsm anything is possible ... if you develop it or have a developer you can ask to create that feature for you :) 12:22 nengard morning oleonard 12:31 Pablo Hi all! 12:34 Pablo I'm using koha-common, v3.12. I already install (I was expecting to add libkoha-contrib-tamil-perl as dependency) but even I follow wiki instructions, I keep getting: 12:35 Pablo [....] Starting Koha indexing daemon (koha):Invalid --user argument: 'koha.koha' (unknown user koha) 12:35 Pablo Even I use --user INSTANCE-koha, or --conf as man says, or --config or -C as output says 12:36 Pablo of cource service koha-index-daemon start -C /etc/koha/sites/INSTANCE/koha-conf.xml 12:37 Pablo Someone could bypass this error...? 12:38 tweetbot_ [off] @oleonard: "Coming to KohaCon13? Add your travel info here http://t.co/dtAuWheoo4 #KohaILS" 12:41 Pablo Also stoped zebra: koha-stop-zebra INSTANCE 12:45 jcamins Pablo: the instructions on the wiki are wrong. They don't make any sense. 12:45 jcamins Well... I think maybe they make sense if you did a standard install. 12:46 jcamins But if you do a package install or a git install (the more common options, since those are appropriate for production and development, respectively), the instructions won't work. 12:48 Pablo jcamins: So you think I wont be able to enjoy koha-index-deaemon, even I'm using v3.12? :( The strange thing is I can't set the correct user, even I use the --user option... 12:48 jcamins Pablo: it's not quite as easy as the instructions make it sound. 12:49 jcamins Bug 8773 12:49 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8773 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Add per-instance koha-index-daemon in .deb setup 12:49 jcamins ^^ this patch adds a script that works much better. 12:51 jcamins If you don't want to build your own packages (which you could absolutely do!), you could get copy the koha-indexer script out of that. 12:51 jcamins If you look at that script, you'll see it correctly handles users, etc. 12:57 mtompset Greetings, #koha. 13:02 Pablo jcamins: Thank you, I'll try to make it run with that patch, or wait to 3.13 perhaps. Thank you! 13:02 mtompset 3.14 13:03 mtompset Even numbers are releases. 3.13 is the current master. 13:10 tcohen morning #koha 13:16 mtompset Greetings, tcohen. 13:17 mtompset Or should I say tcohen_? 13:17 tcohen who's tcohen_ anyway? 13:18 tcohen what's the meaning of the second date on "arrivals and departures" wiki? 13:19 oleonard The date you added the information 13:19 tcohen thanks oleonard 13:19 oleonard I'm not sure why that is necessary, but I followed the example of the others 13:23 magnuse the date after the name gets added if you "sign" with the magical --~~~~ thingy 13:24 mtompset magical what thingy?! 13:25 * oleonard waves his magic wand ineffectually 13:28 tcohen magical wand? 13:29 oleonard magnuse: What is this magic of which you speak? 13:30 magnuse if you write the string "--~~~~" anywhere in the wiki it will be replaced with your wiki username and the datatime you saved the page 13:30 magnuse s/datatime/date and time/ 13:30 oleonard Magical. 13:31 magnuse yup 13:32 magnuse there is a button for it too 13:32 magnuse second one from the right, when you edit a page 13:33 magnuse "Your signature with timestamp" 13:33 magnuse hooray for bug 7813 13:33 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7813 enhancement, P3, ---, tomascohen, Signed Off , Add ability to delete local cover images 13:37 * magnuse calls it a week and waits impatiently for the time to be right for making pizza 13:42 khall question, what is the Koha SIP2 server expecting as a message terminator? LF, CR, CRLF, or does it not matter? 13:46 * mtompset groans. 13:46 mtompset qw vs. q problem, not an sql syntax problem. 13:56 tcohen @later tell eythian about bug 10624, it must be some typo around, i'll check it 13:56 huginn` tcohen: The operation succeeded. 14:10 slef hi everyone. Anyone had problem with constraint `aqbudgetborrowers_ibfk_2` foreign key (`borrowernumber`) references `borrowers` (`borrowernumber`)? 14:11 slef khall: OTTOMH I can't remember. Looked at the code? 14:11 mtompset Not that I recall. Sorry. 14:11 khall slef: I figured it out. It wasn't Koha, it was me ; ) 14:11 khall I was expecting the wrong record separator 14:11 khall when I thought I was *sending* the wrong one 14:12 slef mtompset: hrm. I'm getting the "ERROR 1005...(errno: 150)" problem on upgrade on one library. 14:15 slef the underlying error is "Cannot resolve table name close to: (`borrowernumber`)" 14:15 slef which is just wrong, as it's pretty obviously borrowers, isn't it? 14:19 slef Hmmm, which list to email about it - koha or koha-devel? 14:27 slef Hey, borrowers in this database is MyISAM. Should it be? Can that break foreign keys? Except I've other tables with the same constraint already :-/ 14:28 oleonard slef: borrowers is InnoDB in my test system, FWIW 14:30 slef oleonard: this library has upgraded from Version: $TheArk including before I worked there. 14:31 slef Anyone remember how to convert a MyISAM table to an InnoDB one? STFW now 14:32 slef ALTER TABLE tablename ORDER BY 'primary_key_column'; ALTER TABLE tablename ENGINE = INNODB; 14:32 oleonard I wonder if it means the database missed an update at some point? 14:32 slef ohhhh please no 14:34 slef oh well after altering borrowers to innodb, it works... now to finish the upgrade... thanks oleonard 14:38 rambutan I'll bet druthb would know all about ISAM 14:39 rambutan that was (is?) one of the db's that Sirsi used 14:50 * mtompset sighs, "I think I must not be looking for the right thing. Can anyone give me an idea on how to equivalently code "SELECT LAST_INSERT_ID('field');" from MySQL into a more ANSI SQL or DB agnostic method? I can't seem to get $dbh->last_insert_id to work even in a simple test case. 14:53 rambutan oleonard: I presume we're on the same flight into RNO (from DEN) 14:53 oleonard Oh yeah? 14:54 rambutan http://wiki.koha-community.org/wiki/Kohacon13/Arrivals#Arrivals 14:54 oleonard UA295? 14:54 rambutan no, I see you're flying in two days later 14:55 rambutan nevermind 14:55 oleonard Yeah, you need to put your arrival in order in the list :) 14:55 rambutan ah, 1 min 14:57 * oleonard isn't on circ desk after all 15:05 rambutan oleonard: I can't read this morning :) we are on the same flight 15:08 paul_p oleonard : I'll try to come to KohaCon with some tapenade (crushed olives, that you liked so much) 15:09 paul_p all = on monday clrh will be back , after 4 months AFK for adding 1 human-being to our world. 15:10 oleonard paul_p: Thanks! And congratulations to clrh! 15:10 * mtompset continues to try to understand last_insert_id. 15:11 mtompset Yes, crongratualtions to clrh. :) 15:11 paul_p mtompset = it's probably easier that to understand one's wife though. Good luck 15:11 paul_p oleonard / mtompset congratulate her on monday, I'm not involved at all with this baby ;-) 15:11 mtompset paul_p: It's easier to use a DB specific solution that try to come up with something generic. 15:12 oleonard rambutan: I wondered what you would find if you wanted to know what I looked like and tried to do a Google image search on my name. I see no pictures of me, but one of magnuse 15:12 rambutan Well, I hadn't thought to google you :) 15:13 rambutan However, at the last USA "kohacon", what did we call it back then, in Wisconsin I think, about 5 years ago.... 15:14 * jcamins knows what oleonard looks like. There's a picture from an old KohaCon. 15:14 rambutan we had arrived at the airport, and were on the shuttle bus to the hotel, and there was a guy on there that I was just sure was gmcharlt, althought I had never seen him before 15:14 rambutan sure enough, it was indeed 15:14 yhager Hi, on our koha 3.10, anything we put in a non-public note (FA framework) does not get saved. It does when I use the default framework. Could this be a bug? 15:17 jcamins yhager: my gut reaction is that you are missing a MARC-to-Koha mapping. 15:18 jcamins we should have more marc? 15:18 jcamins more marc? 15:18 jcamins let's have more marc? 15:19 druthb marc? 15:19 wahanui marc is probably the standard that isn't 15:19 jcamins let's use more marc? 15:19 jcamins let's add more marc? 15:19 jcamins how about no? 15:19 wahanui http://media.moddb.com/images/groups/1/3/2933/collapsing.gif 15:19 jcamins Not the one I was looking for, but that'll do. 15:21 druthb lol 15:22 mtompset druthb: Glad to hear you aren't a pirate anymore. 15:23 druthb :P 15:24 druthb Arr? 15:24 wahanui We're a club of tuneful rovers! We can sing in every clef! We can even hit the high notes! It's just too bad we're tone deaf! A pirate I was meant to be! Trim the sails and roam the sea! 15:24 * druthb chuckles. 15:24 jcamins arrrrr? 15:24 wahanui We're a pack o' scurvy sea-dogs. Have we pity? Not a dram! We all eat roasted garlic... ...then sing from the diaphragm! A pirate I was meant to be! Trim the sails and roam the sea! 15:26 * jcamins wonders how many people recognized the reference. 15:27 mtompset AAAAAA! More incorrect function calls. 15:27 * mtompset grumbles at set_userenv's outdated documentation. 15:27 oleonard Not me jcamins 15:28 jcamins Aww. 15:28 jcamins It's a US-only reference, apparently, so if you don't, probably no one. 15:29 mtompset http://www.youtube.com/watch?v=AawQvD8L_h4 15:29 mtompset Is that it? 15:30 jcamins Yep. 15:31 mtompset Never heard of that. Sorry. 15:31 jcamins One of my roommates in college played that game. 15:34 mtompset *sigh* The error I found is in checkpw in C4::Auth. ARG. 15:35 yhager jcamins: where/how do I add that mapping? 15:35 * oleonard offers jcamins his condolences 15:36 jcamins yhager: Koha-to-MARC mapping in the Administration section. 15:37 jcamins Wait, no, framework editor, sorry. 15:40 * cait waves 15:41 rambutan waves waves 15:44 cait Joubu++ 15:47 yhager jcamins: ok, I'll try. thanks! 15:48 cait Joubu++ again 16:00 druthb cait! Cait! CAIT! 16:00 druthb *waves* 16:01 * cait waves back 16:01 cait hey :) 16:01 cait i am back! 16:01 druthb missed you! 16:16 cait :) 16:19 gaetan_B bye ! 16:26 slef mtompset: CRONgratualtions? 16:28 * oleonard considers trying to resurrect Bug 3469 16:29 * oleonard taps his foot and looks for huginn 16:29 cait bug 3469 16:30 cait and hi oleonard :) 16:30 oleonard http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3469 16:30 nengard that's a good one 16:30 cait oleonard: sounds good 16:30 oleonard Considering out often my staff asks if I know a way to find out what someone's old card number was... 16:30 cait we have been using patron attributes 16:31 cait i tink 16:31 oleonard Putting the old card number into a patron attribute? 16:31 cait yes 16:32 cait a repeatable field, copy the cardnumber and add the date 16:32 cait or something like that 16:32 oleonard Sounds tedious :) 16:32 cait well it works but is not perfect :) 16:33 cait and it doesn't happen that often 16:36 gmcharlt @quote random 16:36 huginn gmcharlt: Quote #195: "jcamins: libsysguy's test plans all involve sandwich-eating. I think he only programs when hungry." (added by wizzyrea at 06:12 PM, March 30, 2012) 16:37 oleonard What was it like on the outside huginn? 16:38 * cait waves at gmcharlt 16:38 * cait is happy to have survived all the big events of this week :) 16:38 gmcharlt hi cait 16:40 druthb libsysguy is *always* hungry. 16:40 druthb I think he's powered by a small singularity. 16:41 druthb speak of the devil. 16:41 * libsysguy heard someone say they had sandwiches 16:41 * libsysguy goes to write a test plan 16:41 druthb Second-floor break room, libsysguy. Rising Roll today. Not too shabby. 16:42 * jcamins has a sandwich. 16:42 oleonard Dang, my second-floor break room only has a week-old newspaper. 16:43 * libsysguy already had a spicy cuban 16:43 druthb ours has a vending machine, too, oleonard, and two refrigerators, and two Keurigs. 16:43 libsysguy jcamins, I heard about your rye sandwiches 16:43 libsysguy ewww 16:43 libsysguy :p 16:44 oleonard I'm cutting out early, #koha. Have a good weekend. 16:44 druthb I thought about the Cuban, libsysguy, but they have a salad I just adore, so I got that instead. 16:46 libsysguy I'll probably regret the cuban during my workout today 16:47 libsysguy oh hey, today is a rest day 16:47 libsysguy hbt 17:23 cait @wunder Konstanz 17:23 huginn cait: The current temperature in Konstanz, Germany is 16.0°C (7:00 PM CEST on September 20, 2013). Conditions: Partly Cloudy. Humidity: 56%. Dew Point: 10.0°C. Pressure: 30.12 in 1020 hPa (Rising). 17:24 tweetbot_ [off] @gmcharlt: "And now doing the "first-time code contributor to #KohaILS" happy dance." 17:24 druthb @wunder 77098 17:24 huginn druthb: The current temperature in Greenway Plaza, Houston, Texas is 27.8°C (12:24 PM CDT on September 20, 2013). Conditions: Mostly Cloudy. Humidity: 90%. Dew Point: 26.0°C. Pressure: 29.78 in 1008 hPa (Steady). 17:25 rambutan @wunder 64507 17:25 huginn rambutan: The current temperature in Wyatt Park, St Joseph, Missouri is 18.7°C (12:25 PM CDT on September 20, 2013). Conditions: Clear. Humidity: 55%. Dew Point: 9.0°C. Pressure: 30.05 in 1017 hPa (Falling). 17:26 druthb We're supposed to be getting some serious rainfall tonight and tomorrow. 17:26 rambutan We got a good rain yesterday 17:26 druthb We got a bit overnight, but the hammer's supposed to hit late this afternoon. 17:27 rambutan is there a tropical storm in the gulf? I haven't heard 17:27 druthb I'm thinking I'm gonna hole up all day tomorrow. 17:27 druthb There's an area of very low pressure over the Gulf of Campeche, but it's not yet a depression. 17:27 druthb The front we've got coming in will keep it away from the TX coast. 17:27 rambutan manuel I think 17:28 mtompset yes, yes, slef. I made a typo. 17:28 huginn New commit(s) kohagit: Bug 10894: Add ID to main address in member entry form <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ace550530550ba72b93f34b446e681ab72024f8c> 17:28 * mtompset removes his chauffeur's hat. 17:28 druthb Manuel is on the *west* coast (Pacific). It hammered Acapulco. 17:28 rambutan http://www.accuweather.com/en/weather-news/jerry-may-form-drench-texas/17896415 17:29 rambutan "Tropical Moisture From Gulf, Manuel to Soak Texas" 17:29 jenkins_koha Starting build #110 for job master_maria (previous build: SUCCESS) 17:33 jenkins_koha Starting build #1427 for job Koha_master (previous build: SUCCESS) 17:38 huginn New commit(s) kohagit: Bug 10915: (QA followup) warn if cannot read history.txt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=45b85a700fcb4c9db07ec0bd13ecd8463696c4c2> / Bug 10915: fix About->timeline breakage on incompletely upgraded Koha <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3ae471a352fa2b00782c29c5c40f39db04fe510a> 17:42 tweetbot_ [off] @KohaILS: "#KohaILS [Koha-patches] [PATCH] Bug 10924 - Contact note not updating via opac http://t.co/ey5cCSQZzZ" 17:42 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10924 normal, P5 - low, ---, oleonard, Needs Signoff , Contact note not updating via opac 17:45 mtompset *sigh* We don't change flags so often, do we? (a couple Auth.pm and InstallAuth.pm set_userenv function calls were off by one parameter) 17:55 cait drojf! 17:55 drojf cait! :) 17:56 druthb drojf! 17:57 drojf druthb! :) 17:59 druthb :D 17:59 druthb My favorite Germans are here! 17:59 druthb Germs? 17:59 wahanui hmmm... Germs is http://i.imgur.com/5UfhT.jpg 17:59 druthb Germany? 17:59 wahanui well, Germany is very cool 17:59 druthb :P 18:00 cait :) 18:04 drojf i'd call it cold :P 18:04 * cait nods 18:05 nengard has anyone used the html5media embed recently? 18:05 nengard It worked for me back when it was put in - but i'm trying it now and it's not working for me in 3.12.4 18:05 nengard not sure if it's me 18:05 nengard or a bug 18:06 jcamins nengard: I tested it fairly recently. 18:06 jcamins I had trouble getting it to work because I had the media type wrong. 18:07 nengard k so i put the link in the 856 and enabled the preference and the media type in preference 18:07 nengard what media type did you use that was wrong? 18:07 jcamins It has to be video/ogg instead of video/[something]+ogg, which is what I did at first. Or something like that. 18:07 nengard i tried mov 18:07 nengard then used zamzar to make it an ogg 18:07 nengard they only have one off option 18:07 nengard ogg 18:08 jcamins Sorry, it's not the media type of the file that was the problem. 18:08 jcamins It was the media type I entered into the record. 18:08 nengard oh - that's the part i'm missing 18:08 nengard the media type on the record!! 18:08 jcamins There are two ways to specify every MIME type, and I chose the wrong one. 18:08 nengard where do I put that? 18:08 nengard and I need to update the manual too 18:08 jcamins Or, at least, two ways to specify some MIME types. 18:08 jcamins I don't recall. 18:08 jcamins I think it might be in the release notes. 18:08 cait drojf? 18:08 wahanui hmmm... drojf is from Germany and developing Koha on a raspberry pi! 18:16 jenkins_koha Project master_maria build #110: SUCCESS in 46 min: http://jenkins.koha-community.org/job/master_maria/110/ 18:16 jenkins_koha * David Roberts: Bug 10894: Add ID to main address in member entry form 18:16 jenkins_koha * Mason James: Bug 10915: fix About->timeline breakage on incompletely upgraded Koha 18:16 jenkins_koha * Tomas Cohen Arazi: Bug 10915: (QA followup) warn if cannot read history.txt 18:16 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10894 enhancement, P5 - low, ---, colin.campbell, Pushed to Master , ID required for mainaddress fieldset in create new patron 18:16 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10915 normal, P5 - low, ---, mtj, Pushed to Master , about->timeline broken on upgraded Koha 18:21 nengard jcamins how do you enter the mime type? is it type='video/mp4; codecs="avc1.42E01E, mp4a.40.2"' or just video/mp4 ? The wiki isn't clear and since you got it to work 18:24 jcamins I think it's video/mp4 19:04 jenkins_koha Project Koha_master build #1427: SUCCESS in 1 hr 30 min: http://jenkins.koha-community.org/job/Koha_master/1427/ 19:04 jenkins_koha * David Roberts: Bug 10894: Add ID to main address in member entry form 19:04 jenkins_koha * Mason James: Bug 10915: fix About->timeline breakage on incompletely upgraded Koha 19:04 jenkins_koha * Tomas Cohen Arazi: Bug 10915: (QA followup) warn if cannot read history.txt 19:04 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10894 enhancement, P5 - low, ---, colin.campbell, Pushed to Master , ID required for mainaddress fieldset in create new patron 19:04 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10915 normal, P5 - low, ---, mtj, Pushed to Master , about->timeline broken on upgraded Koha 19:35 nengard isn't there a bug for item types not showing on the purchase suggestion form? 19:36 cait yes 19:36 cait the problem is in advancedsearchtype definitions 19:36 cait when we changed that to multiple 19:37 nengard well the bug is back 19:37 nengard do you know the number? 19:38 nengard found it i think 19:54 * mtompset puts on his chauffeur's hat again. 19:55 mtompset Have a great day, #koha. 20:49 rangi hmmm 20:49 cait hm? 20:49 cait hi rangi 20:49 rambutan the Koha docker thing is pretty cool. 20:49 rambutan https://index.docker.io/u/jbfink/koha/ playing with it now 20:49 rangi yeah it is 20:50 rangi my script now tries to apply the dependencies too 20:51 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7684#c66 20:51 huginn 04Bug 7684: normal, P5 - low, ---, jonathan.druart, Needs Signoff , inventory : datatable fix actions etc. 20:51 rangi which helps find issues like that 20:52 cait :) 20:52 cait rangi++ 20:55 rangi hmm also we are 1 km ahead of team oracle 20:55 cait yay :) 20:55 rangi but now racing the clock, if we dont finish in time, the fact that we utterly thrashed them, means nothing 20:55 rangi and have to race again 20:55 rangi dumb 20:56 cait oh 20:56 * druthb feels a little guilty saying that she's glad NZ is whipping Oracle Team USA in the America's Cup like they're red-headed stepchildren…but not much. 20:57 rangi we arent gonna make it :( 20:57 rangi gonna have to race again 20:57 cait :( 20:57 rangi got like 3 mins 20:57 rangi druthb: its always fun to make larry ellison cry 20:57 druthb Aw, darn, have to give them another sound thrashing. Aw, shucks. 20:58 druthb I'm headed out for the weekend. Take care, everyone. :) 21:01 rangi well that sucked 21:16 jcamins Whoah... 21:16 jcamins has anyone else noticed that the tabs on the 3.12 OPAC support keyboard navigation? 21:20 cait i think someone said something about that 21:20 jcamins Oh, well, first time I noticed it. 21:21 jcamins The staff client changes I of course noticed. 21:28 jcamins Aww, man, I missed a Twitter conversation about what I was working on last week! 21:33 rangi right, racing again 21:33 rangi bit more wind now 21:34 cait fingers crossed 21:34 rangi boats are doing 30 knots already 21:34 rangi (thats like 60kmph) 21:35 rambutan rangi: are you watching something on the internet? share link? 21:37 rangi on the tv 21:37 rangi not sure if tehre is a feed in the US im sure the tvnz live stream will be geoblocked 21:38 rangi https://www.youtube.com/americascup 21:38 rangi dunno if there is live here 21:38 rangi https://www.youtube.com/watch?v=vmbRX6EQ5Tg <-- live 21:39 rangi crapsticks oracle leading 21:39 cait boo 21:40 rangi evening up 21:40 rangi tense 21:40 rangi rambutan: did that link work for you? 21:40 rambutan nope, blocked 21:41 rambutan I'll read about it later.