Time Nick Message
00:18 kulps Hey folks, I'm looking for suggestions on well populated z39.50 servers
00:19 kulps I've run in to a few books that the library of congress and library and archives of canada arent able to find
00:21 eythian British National Library would be something else worth adding.
00:22 kulps Thanks
00:22 kulps I'm adding canadian targets
00:22 kulps but
00:23 kulps still not finding the books
00:24 eythian It's reasonable for them not to if it's not a Canadian book.
00:25 kulps yeah
00:25 eythian some of the free ones have a more restricted set, and you pay more for the full one (NLNZ is like that, for example)
00:25 kulps it's a weird copy of harry potter, but at the same time, it's still a copy of harry potter, I had high hopes it would be found
00:37 jenkins_koha Starting build 44 for job Koha_3.4.x (previous build: SUCCESS)
00:42 kulps as I'm looking through these lists I'm seeing the same database names over and over again
00:42 kulps do public libraries often share databases?
00:42 rangi no
00:43 rangi usually its the name of the ils software they are using
00:43 rangi they arent the same database at all, unless they are on the same host too ;)
00:45 kulps ahhh
00:45 kulps that makes good sense
00:46 kulps so Horizn, Unicorn
00:46 kulps it seems weird not to name your library DB
00:46 rangi yup, proprietary ils's
00:46 kulps hmmm
00:46 rangi ilses ?
00:46 eythian ILS's
00:46 rangi dunno what the plural of that is
00:47 eythian it's OK to use an apostrophe for plurals on acronyms
00:47 eythian (and numbers, e.g. 1930's)
00:47 kulps I'm starting to get discouraged, I have 10 public libraries from the US and Canada and both national archives but for some reason, this isbn is not returned. Amazon finds it though...
00:48 kulps is that a lot to search through or pretty normal
00:48 eythian it's a lot, but it might be they're not ones that tend to index the more obscure ones.
00:49 eythian or, maybe they're only giving you ones that they actually have, rather than a full catalogue.
00:51 kulps part of the issue I think might be that this is a box set, the box has an ISBN, but so does each book.
00:51 eythian ah, could be
00:51 kulps How should I treat this in a collection
00:51 kulps not every person would check out the set, right?
00:51 eythian analytics
00:51 wahanui the 773$w field contains the value of the 001 field of the parent record. Also, MARC sucks.
00:51 kulps so I thought each book would be scanned
00:52 eythian although, analytics is more for finding collections
00:52 eythian rather than allowing one to be issued and thereby issuing all the children too.
00:52 eythian wahanui: marc
00:52 wahanui well, marc is the standard that isn't
00:52 eythian wahanui: literal marc
00:52 wahanui eythian: marc =is= the standard that isn't
00:53 kulps 773?
00:53 kulps my default framework jumps from 760 to 796
00:53 eythian no wahanui, marc is the standard that isn't|<reply>http://marc-must-die.info|<reply>The MARC specs live at http://www.loc.gov/marc/bibliographic/ - abandon hope all ye who enter here.
00:53 wahanui okay, eythian.
00:55 eythian kulps: I think it's in the frameworks I've used.
00:56 kulps I was kind of expecting a joke to come from it, actually
00:56 kulps akin to "There's no place like 127.0.0.1"
00:56 kulps or something
00:56 kulps :)
01:06 libsysguy hey raingi...I can't really find anywhere in CalcFine that could be wrong
01:06 libsysguy maybe its in the days_between function instead?
01:06 rangi i still think its rules
01:07 rangi in order for days overdue to be 0
01:07 rangi then
01:07 rangi return ($amount, $data->{chargename}, $days_minus_grace)
01:07 rangi days_minus_grace = 0
01:07 rangi which means that
01:07 rangi my $days_minus_grace = $chargeable_units - $data->{firstremind}; == 0
01:07 rangi which means that
01:07 rangi if ($data->{'chargeperiod'} && $days_minus_grace ) {
01:08 rangi is false
01:08 rangi which means
01:08 rangi $amount = int($chargeable_units / $data->{'chargeperiod'}) * $data->{'fine'}; is never done
01:08 rangi hence $amount is 0 too
01:08 libsysguy hmm
01:09 rangi chargeperiod is 1 eh?
01:09 libsysguy yes it is
01:09 rangi and theres not some other rule thats getting used instead
01:10 libsysguy Faculty Member,Interlibrary Loan Item,25,21,days,None defined,2.00,1,0,0,0,0,0.000000
01:10 libsysguy is what I have for that rule type
01:11 rangi all i can suggest is putting in some warns in CalcFine
01:11 rangi to check exactly what rule is being used
01:11 libsysguy wait a secont
01:11 rangi something is making $days_minus_grace be 0
01:11 libsysguy i was just looking at that item in the db
01:11 libsysguy there is no itemtype set....
01:12 rangi ahhh ha
01:12 libsysguy see...this is what makes me crazy about my librarians
01:12 rangi it will be matching a different rule then most likely
01:12 libsysguy they are always complaining that Koha is broken...but they input the broken data
01:12 libsysguy GGGRRRRRR
01:12 rangi probably the default/default
01:14 libsysguy yeah probably so...
01:14 libsysguy thanks for the help rangi
01:14 libsysguy rangi++
01:14 rangi no worries
01:14 rangi if i was you
01:14 rangi id do a check of the db
01:14 libsysguy I am about to do that
01:14 rangi see how many items dont have an itemtype
01:15 rangi cool
01:15 rangi im gonna get some lunch
01:15 libsysguy I just called my boss and told her we were going to do a full sweep
01:15 libsysguy lol alright man
01:15 libsysguy later
01:18 libsysguy when you get back....I just happened to notice...itemtype isn't set in statistics but itype is set in items...do you know where the circ rule pulls from?
01:19 jenkins_koha Project Koha_3.4.x build #44: SUCCESS in 41 mn: http://jenkins.koha-community.org/job/Koha_3.4.x/44/
01:19 jenkins_koha robin: Bug 6129 - [3.4.x] this adds an ISSN to serialssolutions URLs
01:19 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6129 enhancement, PATCH-Sent, ---, srdjan, ASSIGNED , ISSN url param for serialssolutions.com
02:57 rangi itype in items
02:57 rangi or itemtype in biblioitems
02:57 rangi depending on what you have set in systempreferences
02:57 rangi most likely itype
02:58 * rangi presumes he will read the logs ;)
02:58 cait morning #koha
02:58 eythian Hi cait
03:08 cait morning eythian
03:08 eythian hello
03:09 rangi hey cait, up early again
03:09 cait yeah, workshop today
03:09 cait train leaves ealry
03:24 kmkale Namaskar #koha
03:25 cait bye #koha
04:03 huginn New commit(s) needsignoff: [Bug 3966] receiving items should allow for entering barcode <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3966>
04:29 bg NateC?
04:29 wahanui I LIKE SPACE!
04:29 bg YAY!
04:30 wizzyrea rangi?
04:30 wahanui I LIKE ALMONDS! HAVE SOME NUTS! or at work
04:30 libsysguy libsysguy?
04:30 wahanui i think libsysguy is Koha's hottest developer or partying with swedes on his deck
04:30 wizzyrea rpf;
04:30 wizzyrea rofl
04:30 wizzyrea lulz
04:30 bg wizzyrea?
04:30 wizzyrea HA
04:31 wizzyrea pwnt
04:31 bg heh
04:31 rangi hehe
04:31 bg mtj?
04:31 wahanui DeM KraZy NutZ!!
04:31 libsysguy ^^ hehe
04:31 bg that's the best
04:31 wizzyrea bg?
04:31 wahanui I LIKE BREAKFAST BURRITOS AND I LOVE BASEBALL
04:31 wizzyrea yay1
04:32 wizzyrea there now I can see my keys
04:32 wizzyrea phew
04:32 rangi http://www.youtube.com/watch?v=GZiAAi7GZIA
04:32 bg you can see your keys? are you drunk at a bar and can't drive home?
04:32 wizzyrea no silly it's dark in here and now my keys are glowing
04:33 wizzyrea so I can see them
04:33 wizzyrea because i'm blind
04:33 wizzyrea and stuff
04:33 bg you've got keys that can glowe?
04:33 wizzyrea never mind
04:33 wizzyrea yea, don't you?
04:33 eythian I also have glowing keys. It's handy
04:33 bg my keys don't glow
04:33 wizzyrea ^^
04:33 wizzyrea don't you have a mac?
04:33 bg they only start the car :(
04:33 wizzyrea oh lordie
04:33 rangi and a nice car it is too
04:33 bg sometimes they open the door
04:34 eythian or rather, I have a glowing thing on my keyring.
04:34 wizzyrea all right you literalists
04:35 rangi well namibia got spanked
04:36 wizzyrea kinky
04:36 rangi next up, tonga vs canada
04:36 wizzyrea you get her number?
04:36 wizzyrea i tease
04:36 rangi wtf are canada even doing here?
04:36 wizzyrea rofl
04:38 rangi http://www.youtube.com/watch?v=HPupEn4D5tg
04:41 wizzyrea heeh
04:41 rangi http://www.youtube.com/watch?v=DiqpvPlD-Q0
04:41 rangi this one is good from about 1.20 on
04:41 wizzyrea I like tuhtles
04:41 rangi with the sounds of the teams
04:42 rangi i like the USA sound :)
04:42 wizzyrea oh this can only end badly
04:42 rangi but canada is the best, followed closely by scotland
04:42 rangi (1.05 it starts)
04:43 wizzyrea hahaha
04:44 wizzyrea scotland is pretty wicked too
04:44 * wizzyrea will have nightmares now
04:44 rangi hehe yeah
04:44 wizzyrea "I see ginger people..."
04:45 rangi usa v russia tomorrow should be a good one
04:45 wizzyrea Eff ya!
05:25 Oak hello #koha
06:10 alex_a hello
06:10 wahanui1 bonjour, alex_a
06:47 francharb hello
07:03 magnuse kia ora #koha
07:05 eythian hi magnuse. Having a quick go at generating those man pages
07:05 eythian I'll know soon if it worked, or if I'm understanding something wrong :)
07:06 magnuse yay!
07:06 magnuse eythian++
07:07 magnuse eythian: talking of which... any chance anyone will have another go at the l10n stuff for the packages in time for the deadlines?
07:07 eythian Not sure if package.install runs before or after debian/rules during build, so that's got a 50% chance of working.
07:07 eythian hmm, I'll see what Srdjan's up to tomorrow. He may be free to look at it.
07:08 magnuse yay
07:09 magnuse one thing i was wondering about: the original man page for koha-create was .8
07:09 magnuse according to this http://en.wikipedia.org/wiki/Man_page#Manual_sections 8 is for "System administration commands and daemons" is that right?
07:09 eythian yep.
07:09 eythian The same reason it's in sbin
07:10 eythian and needs to be run with sudo
07:10 magnuse ah, ok
07:10 magnuse cool
07:14 eythian /bin/sh: xsltproc: not found
07:14 eythian rats
07:15 magnuse kia ora paul_p
07:15 paul_p hello magnuse !
07:15 Oak magnuse
07:15 eythian oh, I see what I did there. Scilly me.
07:15 magnuse Oak
07:16 Oak greetingns francharb, sophie_m, paul_p, eythian :))
07:16 eythian hi
07:16 wahanui1 hello, eythian
07:16 sophie_m hi 0ak and #koha
07:16 * paul_p worked very late yesterday to investigate performance in Koha. I've suggestion to improve speed by 30% (mail to koha-devel soon)
07:16 francharb hello all
07:16 Oak paul_p++
07:17 magnuse paul_p++
07:17 Oak eythian++
07:17 Oak God bless you all
07:24 * eythian tries building this again, with the dependencies done right this time hopefully.
07:25 magnuse fingers crossed!
07:35 eythian erk, that failed for inexplicable reasons.
07:35 magnuse ouch
07:36 eythian pbuilder didn't like me adding stuff to the build-depends
07:36 magnuse shame on pbuilder, then!
07:36 eythian I wonder why...
07:47 eythian ah well, have to go. Will have to try to fix it tomorrow.
07:47 Oak later eythian :)
07:47 eythian bye
07:52 kulps Hey folks, is anyone around?
07:58 magnuse kulps: some ;-)
08:01 kulps it could be that its late, or that I've now installed koha 5 times in 4 days but I have a fresh install that's been my smoothest yet
08:01 kulps I get the admin console, no problem
08:01 magnuse yay
08:01 kulps but the OPAC wont load
08:01 magnuse ouch
08:01 kulps I'm sure its dreafully simple
08:01 kulps but i just get the default apache page
08:01 magnuse get any error messages in the apache logs?
08:02 magnuse ah, that might be the default site masking it
08:02 kulps no, I'm pretty sure its a config issure
08:02 kulps I tried to change to ports to test for that
08:02 kulps but I dont know if I did it right
08:02 magnuse try "sudo a2dissite default" then reload apache
08:02 magnuse (unless you are actually using the default site for something, of course)
08:03 kulps (I did remember to add a listening port for 8080, which is good, minor progress is being made by my memory)
08:03 kulps nope
08:03 kulps default can go
08:03 magnuse i'd try that
08:04 kulps hmm
08:04 kulps still getting the default
08:04 kulps even after the reload
08:04 magnuse hm, that's not so good...
08:05 kulps I'm trying to compare it with my working install
08:05 kulps it all looks good
08:05 Oak hm, i don't think Password reminder at http://lists.koha-community.org/cgi-bin/mailman/options/koha-devel works
08:05 Oak waiting for an hour now
08:06 Oak nothing in spam either
08:07 kulps magnuse, there are only so many conf files that would act against the OPAC, right?
08:08 magnuse kulps: yeah, there are the ones in /etc/apache2/sites-enabled
08:08 kulps I'm thinking /etc/apach2/sites-available/lib (lib being my instance)
08:08 magnuse then there are some in /etc/apache2
08:08 magnuse like ports.conf
08:09 kulps wait
08:09 kulps wait
08:09 kulps hmmm
08:10 kulps no
08:10 kulps hmmm
08:10 kulps thought it was in ports
08:10 kulps but no
08:11 magnuse lib is the only site in /etc/apach2/sites-enabled/ ?
08:12 kulps yes
08:13 kulps in my working instance under sites-enabled/koha (the working instance) I see this "ServerName koha.mydomain.co.nz"
08:13 kulps but on the broken instance I see this "ServerName libents-lib-001"
08:14 kulps I dont think this would cause trouble
08:14 kulps and it's working for the admin console
08:14 kulps ...
08:14 kulps ...
08:14 kulps arg.
08:14 kulps arg arg.
08:14 kulps magnuse sorry to take your time
08:15 kulps lesson learned
08:15 kulps clear browser cache when things should be fixed.
08:15 huginn New commit(s) kohagit: Bug 6368: unimarc_field_4XX plugin does not work with new templates - corrected <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=47aee699afbb4ad8aebc84e023a0e5c7fd441ec9>
08:16 magnuse kulps: hehe :-)
08:18 kulps brutal
08:18 kulps but
08:18 kulps I now have 2 working installs
08:18 kulps which is neat
08:18 magnuse yay
08:18 kulps and this one was really fast to get working
08:18 magnuse the more often you do it the better you get :-)
08:19 kulps I'm not sure how many more times I'll get to do it
08:20 kulps depending if other hackerspaces are interested in cataloging their libraries
08:20 magnuse you're working for a hackerspace?
08:20 * Oak googles hackerspace
08:21 kulps Yep
08:21 kulps It's neat to do my own library
08:21 kulps but the spaces library might actually see transactions
08:22 kulps HA!
08:22 kulps members.ents.ca
08:22 kulps I'm sure theres a bunch of security issues I just introduced
08:22 kulps but
08:22 magnuse yay
08:22 kulps our OPAC is running live off a vm at the space
08:22 magnuse how cool is that?!?
08:22 kulps you can search for our only entry "windows"
08:22 jenkins_koha Starting build 413 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #385 26 j ago)
08:23 kulps it's a book I have on loan right now, so it was easy to add
08:23 magnuse hehe, at least it works ;-)
08:25 kulps yup
08:25 kulps hmm
08:25 kulps I built that record from the Toronto Public Library
08:26 kulps they seem to have added this "Online Resources: http://ezproxy.torontopubliclibrary.ca/login?url=http://proquest.safaribooksonline.com/?uiCode=torontopl&xmlId=9780735625303"
08:26 kulps can I just remove that from the biblio record and have it remove from the item record?
08:27 kulps are records nested that way?
08:28 magnuse items are attached to biblios, yes
08:28 magnuse some info is stored at the item level and some at the biblio level
08:29 kulps is it possible to edit an item without it affecting the bilbio
08:29 kulps right
08:30 kulps and if I have 3 items under the same biblio, I would need to modify each of them seperately if I wanted to make a change, yes? (assuming the edit was at an item-level)
08:32 magnuse yup
08:34 kulps neat
08:34 kulps got that online reseources entry purged
08:34 kulps now
08:34 kulps before bed, how much do I need to worry about securing the OPAC site? Is it pretty safe out of the box?
08:36 magnuse not my main area of expertise, but there are noe special recommended steps to make it more secure
08:36 magnuse apart from stuff that applies to any web server
08:36 magnuse like firewalls and such
08:38 kulps right
08:38 kulps well
08:38 kulps I'll probably get learned real good from the guys tomorrow, but for now I think it's a job well started, even if it's not done.
08:39 kulps They might want to build a DMZ to put that machine in
08:39 huginn New commit(s) needsignoff: [Bug 5981] OPAC: Add limits to search history <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5981>
08:39 kulps I don't know
08:39 kulps for now it's working, let the spooks figure it out!
08:40 kulps Thanks again Magnuse, if our pilot goes well I may end up as the hackerspaces librarian
08:40 kulps hopefully I will need less and less help
08:40 kulps but also, hopefully I can bring smart people to the project
08:40 kulps since most hackerspaces have a few devs milling about
08:40 magnuse yay
08:41 Oak kulps++
08:41 paul_p magnuse, (or anyone else) can you confirm this url works for you : http://depot.biblibre.com/ppoulain/nytprof.ini/ ?
08:41 kulps you, and everyone else here has been super helpful
08:41 magnuse kulps++
08:42 kulps loads for me
08:42 Oak yup works paul_p
08:42 magnuse paul_p: i see a page called "Performance Profile Index"?
08:42 paul_p magnuse, yep. mail to koha-devel to follow ;-)
08:42 magnuse yay
08:43 kulps well, quarter to three, gotta get to bed so I'm not a wreck tomorrow. Thanks again folks!
08:43 Oak take good care kulps :)
08:43 paul_p (then I head for 6 hours of train where i'll continue working on that : going to "Librarians in University association annual meeting" )
08:43 magnuse have fun kulps!
08:43 paul_p sweet dreams kulps
08:53 magnuse long_train_rides++
09:07 jenkins_koha Project Koha_master build #413: STILL UNSTABLE in 44 mn: http://jenkins.koha-community.org/job/Koha_master/413/
09:07 jenkins_koha januszop: Bug 6368: unimarc_field_4XX plugin does not work with new templates - corrected
09:07 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6368 normal, PATCH-Sent, ---, januszop, ASSIGNED , unimarc_field_4XX plugin does not work with new templates
09:46 huginn New commit(s) kohagit: Bug 6841 - A member with cataloging permissions cannot change branches (when independ... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c2015c710355a0ab81306515a70af29e6aef3504> / Bug 6620 Ensure autoflush is set on output filehandles <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f9ccfae400324fdd88597ff81fba42715e50f19d>
09:52 jenkins_koha Starting build 414 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #385 27 j ago)
10:17 huginn New commit(s) kohagit: Fix for Bug 2891, cannot manually enter date at reports/issues_stats.pl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8474059769ae921c9dfb8249bc774ade606785fa> / bug 6677 - remove reference to 'debarred' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=92e71131faf55e719f84c6e29314f5abc5714b57>
10:28 huginn New commit(s) kohagit: 6829: Remove two warnings for opac-MARCdetail <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=caae541135dedb5d0ccddbf8ffd31887f802332d>
10:36 jenkins_koha Project Koha_master build #414: STILL UNSTABLE in 43 mn: http://jenkins.koha-community.org/job/Koha_master/414/
10:36 jenkins_koha * colin.campbell: Bug 6620 Ensure autoflush is set on output filehandles
10:36 jenkins_koha * lrea: Bug 6841 - A member with cataloging permissions cannot change branches (when independent branches is set on)
10:36 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6620 major, PATCH-Sent, ---, colin.campbell, ASSIGNED , Sip Server Output may be buffered
10:36 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6841 major, PATCH-Sent, ---, wizzyrea, ASSIGNED , A member with cataloging permissions cannot change branches (when independent branches is set on)
10:36 jenkins_koha Starting build 415 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #385 27 j ago)
11:20 jenkins_koha Project Koha_master build #415: STILL UNSTABLE in 43 mn: http://jenkins.koha-community.org/job/Koha_master/415/
11:20 jenkins_koha * nengard: bug 6677 - remove reference to 'debarred'
11:20 jenkins_koha * oleonard: Fix for Bug 2891, cannot manually enter date at reports/issues_stats.pl
11:20 jenkins_koha * m.de.rooy: 6829: Remove two warnings for opac-MARCdetail
11:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6677 normal, PATCH-Sent, ---, nengard, ASSIGNED , patron stats still refers to debarred
11:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2891 normal, PATCH-Sent, ---, oleonard, ASSIGNED , Cannot manually enter dates in some report forms
13:02 libsysguy morning #Koha
13:04 magnuse afternoon libsysguy
13:05 libsysguy heh silly time differences
13:06 magnuse :-)
13:10 libsysguy seen rangi
13:10 wahanui1 rangi was last seen on #koha 8 hours, 24 minutes and 49 seconds ago, saying: usa v russia tomorrow should be a good one [Wed Sep 14 04:44:44 2011]
13:10 libsysguy @later tell rangi this is how I feel when squashing bugs in Koha http://soundcloud.com/doverspike/daft-punk-technologic
13:10 huginn libsysguy: The operation succeeded.
13:11 libsysguy wizzyrea might also appreciate that
13:19 libsysguy @later tell wizzyrea http://soundcloud.com/doverspike/daft-punk-technologic = bug squishing music
13:19 huginn libsysguy: The operation succeeded.
14:01 andersonbd1 I'm getting closer, but now stuck on a handful of modules. I haven't been successful install via apt-get (not found?) or via cpan. Here's the first one: http://pastebin.com/raw.php?i=x3xdxpLj
14:03 wizzyrea andersonbd1: can you do sudo apt-get install libcgi-session-serialize-yaml-perl
14:03 wizzyrea and see if that will install
14:04 wizzyrea (have you been doing these via cpan or packages?)
14:04 wizzyrea and good morning peeps
14:04 wizzyrea :)
14:04 druthb hi, wizzyrea! :)
14:04 wizzyrea hiyaaaaa
14:05 wizzyrea also sudo apt-get install libhttp-oai-perl
14:05 wizzyrea and sudo apt-get install libmarc-crosswalk-dublincore-perl
14:06 wizzyrea that should hit the required ones
14:07 wizzyrea also, looks like you were trying to do serialize with cpan
14:07 wizzyrea it's probably sudo cpan -i CGI::Session::Serialize::yaml
14:08 * wizzyrea does work.
14:10 wizzyrea libsysguy that's a great song
14:50 wizzyrea in accountlines, does anyone know
14:50 wizzyrea what is "accountno"
14:50 wizzyrea what does that denote?
14:54 sekjal wizzyrea: taken with borrowernumber, the two fields form as close to a key as you're going to get
14:54 wizzyrea hmm
14:54 wizzyrea ok so
14:54 wizzyrea what if you have about 50 of them with the same accountnumber?
14:55 sekjal same patron?
14:55 wizzyrea multiple patrons, actually
14:55 sekjal that's okay
14:55 wizzyrea all of them exhibit the same sympton
14:55 sekjal it's only a problem if (borrowernumber,accountno) is not a unique combo
14:55 wizzyrea they pay a fine, and the amountoutstanding gets 0'd out
14:55 wizzyrea even if that's not right
14:56 wizzyrea ah, then we had/have a problem
14:56 sekjal eep
14:56 wizzyrea big pastebin inc
14:57 andersonbd1 thanks wizzyrea. that's the strategy I'd been following (apt-get). Where I got confused is that the module names were chopped off in the ./koha_perl_deps.pl -m command
14:57 pastebot "wizzyrea" at 24.124.17.146 pasted "accountlines - see the borrowernumbers/acctno combos that have the 32767" (101 lines) at http://paste.koha-community.org/36
14:57 wizzyrea did that help at all?
14:59 sekjal wizzyrea: I see
14:59 wizzyrea I think
14:59 wizzyrea there is a data problem in our accountlines
15:00 sekjal 32767... seems to come up a couple times
15:00 wizzyrea exactly!
15:00 wizzyrea and it looks like it's still happening on new fines
15:01 sekjal 32767 is the maximum possible value for accountno
15:01 sekjal since it's of type 'smallint'
15:02 trea ^^
15:02 wizzyrea LOL
15:02 sekjal http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
15:02 wizzyrea so we've exceeded the field
15:02 trea i knew it seemed familiar somehow
15:02 trea :D
15:02 wizzyrea uh
15:02 wizzyrea how to fix it :)
15:03 wizzyrea we have 2100 accounts that would be susceptible to fine zeroiing
15:04 sekjal does any individual patron have more than 32767 fines/payments entries?
15:04 wizzyrea I would find that very surprising
15:04 sekjal so the repair is to reset the accountnumbers sequentially, starting from 1
15:05 * wizzyrea will file a bug to suggest fixing the column type
15:05 wizzyrea to prevent this for others
15:05 sekjal the fix is going to be something else
15:05 sekjal somewhere, in the code somewhere (or some when) the accountno was not incrementing properly
15:05 sekjal either through a bad SQL, or a mis-directed variable, or both
15:06 wizzyrea well it's happening now
15:06 wizzyrea on new fines on our system
15:06 wizzyrea and if 32767 is the max for the column
15:06 wizzyrea oh wait
15:06 wizzyrea I see
15:06 wizzyrea what you're saying
15:07 wizzyrea you're saying that accountno for *each patron* is supposed to increment by 1
15:07 wizzyrea and sometime/where it was incrementing the whole table
15:07 * wizzyrea tries to find the oldest incidence
15:07 sekjal possibly
15:08 sekjal a larger number than intended was put in the accountno field, somehow
15:08 * wizzyrea considers suggesting a fine amnesty
15:08 wizzyrea :{P
15:08 wizzyrea :P
15:08 trea i like :{P - it's like a guy with a handlebar moustache
15:09 wizzyrea hee
15:09 magnuse :-{)
15:10 wizzyrea :-{)>
15:10 wizzyrea goatee
15:11 magnuse heh
15:11 magnuse }:{)>
15:12 magnuse big furry eyebrows, handlebar moustache and a goatee...
15:13 wizzyrea the first occurrence of this was april 15 this year
15:51 sekjal found the root of the problem
15:51 sekjal writeoffs are corrupting the data
15:51 wizzyrea sekjal++
15:53 sekjal oh, hey, and it's fixed in master
15:53 wizzyrea WOOT!
15:53 sekjal with the recently pushed bug 3498
15:53 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3498 enhancement, PATCH-Sent, ---, colin.campbell, ASSIGNED , Allow partial fine payments
15:53 libsysguy even better
15:53 wizzyrea LOLOL
15:53 libsysguy bug fix by surpriese
15:53 * wizzyrea lol's all over the place
15:53 libsysguy surprise**
15:54 sekjal thank you Colin Campbell
15:54 sekjal this is why we need git reward in addition to git blame
15:54 magnuse hehe
15:55 sekjal so it's just matter of writing the cleanup script
15:58 wizzyrea so. excited
15:58 wizzyrea woot :D
15:58 wizzyrea colin's not here, what's his usual nick?
15:59 oleonard Colin I think
15:59 wizzyrea @seen colin_c
15:59 huginn wizzyrea: I have not seen colin_c.
15:59 oleonard That's what I see on the irc stats page
15:59 wizzyrea @seen colin
15:59 huginn wizzyrea: colin was last seen in #koha 35 weeks, 6 days, 17 hours, 56 minutes, and 27 seconds ago: <Colin> Colin Campbell, PTFS Europe Ltd
15:59 wizzyrea colin++
15:59 oleonard @karma colin
15:59 huginn oleonard: Karma for "colin" has been increased 28 times and decreased 2 times for a total karma of 26.
16:15 kulps Hey folks, is there a guide to enabling self checkout? I searched the wiki but didnt come up with much. I enabled it in the admin menu (I think) but don't know where to go now.
16:16 oleonard /cgi-bin/koha/sco/sco-main.pl
16:16 kulps found that
16:16 kulps what do I need to do with it?
16:16 kulps sorry, I've only been using Koha for a few days
16:17 rhcl RE: email regarding printing with Linux -- I intend to take a good look at printing from FF/Koha on Linux "when I get the time". We have never been entirely successful with it so far.
16:17 oleonard kulps: Have you read this? http://koha-community.org/documentation/3-4-manual-en/?ch=x8658
16:17 kulps not yet
16:18 kulps thanks
16:18 kulps I'll read it and get back to you
16:18 kulps what's better, the faq or the wiki?
16:18 kulps or do I need to check both?
16:19 oleonard The official documentation first
16:19 kulps noted
16:20 kulps thanks for your help, I'll see what I can do
16:23 sekjal accountlines really needs a primary key.... ::grumble::
16:25 oleonard sekjal: I just saw the article in Library Journal about ByWater and CAUSE
16:26 oleonard Really interesting that Koha's use of standard ports was a selling point for the military.
16:26 sekjal oleonard: oh, really? I haven't read my most recently received copy
16:26 sekjal will have to dig it out
16:26 oleonard page 21
16:28 oleonard "..there were also technical reasons [for the switch], as Koha uses standard computer-network ports--a military requirement that Derrow told LJ was 'an issue' with a previous software provider, which she declined to name."
16:30 wizzyrea standards++
16:30 sekjal will look once I can find it (a little too much paper floating around right now)
16:43 wizzyrea this makes me think of natec: http://pinterest.com/pin/195080383/
16:48 sekjal NateC?
16:48 wahanui1 I LIKE SPACE!
17:01 kulps oleonard, which military?
17:02 * kulps does not get Library Journal
17:02 wizzyrea presumably the US military?
17:02 oleonard US military
17:02 oleonard Libraries which support US military veterans
17:04 kulps too bad it wasnt the navy, they would have contracted it out
17:04 kulps and you all could have made a killing
17:06 * kulps pokes fun at NMCI
18:05 chris_n @later tell cait should http://tinyurl.com/5r7nnnv apply to 3.4.x?
18:05 huginn chris_n: The operation succeeded.
18:05 chris_n @later tell kf should http://tinyurl.com/5r7nnnv apply to 3.4.x?
18:05 huginn chris_n: The operation succeeded.
18:06 oleonard chris_n, are you applying all the other 6458 patches to 3.4.x?
18:06 chris_n yes, but the above mentioned one does not apply cleanly
18:07 chris_n it looks to be based on an earlier commit which did not land in 3.4.x
18:08 oleonard That template has had several modifications in the last couple of months
18:09 chris_n if I missed one that should be there please let me know
18:10 rhcl oleonard: were you referring to the September issue of LJ?
18:10 oleonard rhcl: Yes
18:10 rhcl I need to track our copy down.
18:10 oleonard It's not a full-blown article, just a blurb, but interesting nonetheless.
18:11 * oleonard is getting frustrated with the last remaining fix for bug 6458
18:11 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
18:11 libsysguy sekjal
18:11 sekjal libsysguy
18:11 wahanui1 libsysguy is Koha's hottest developer or partying with swedes on his deck
18:11 libsysguy fines is broken in hourly
18:11 libsysguy :'(
18:11 libsysguy are broken**
18:12 wizzyrea define broken
18:12 libsysguy like all fines are not accruing correctly
18:12 sekjal libsysguy: all fines, even on day-based loans?
18:12 libsysguy yes all of them
18:12 libsysguy and I think I know why...I'm working on a fix
18:12 sekjal cool
18:13 libsysguy its in CalcFine
18:13 libsysguy I just wanted to let you know so you could hold off on testing
18:13 libsysguy I feel bad for passing it now :'(
18:14 wizzyrea fix it and you'll be redeemed :)
18:14 wizzyrea otherwise:
18:14 * wizzyrea readies the bull whip
18:14 libsysguy I go to programmer hell hehe
18:16 libsysguy I see this line in master
18:16 libsysguy # use copy-pasted functions from calendar module.  (deprecated -- these functions will be removed from C4::Overdues ).
18:16 libsysguy does that mean the functions following it will be removed?
18:17 oleonard The enrichment center reminds you that developer hell is real place where you will be sent at the first sign of defiance.
18:18 cait hi #koha
18:18 wizzyrea caait
18:18 cait hi there
18:19 libsysguy cait!!
18:19 cait you were not missing me, weren't you? :)
18:19 libsysguy I was :(
18:19 cait @later tell chris_n: it should if owen's first patch to this has been applied
18:19 huginn cait: The operation succeeded.
18:19 cait aw
18:20 cait were talking about koha to libraries all day
18:20 cait now all I want is stop thinking
18:20 cait was talking...
18:22 wizzyrea I was missing you :)
18:22 jenkins_koha Starting build 45 for job Koha_3.4.x (previous build: SUCCESS)
18:25 cait wizzyrea: sql report? :P
18:26 wizzyrea no, I was missing your wit and charm :)_
18:26 cait sounds unlikely :)
18:26 wizzyrea lol!
18:26 wizzyrea all true
18:26 wizzyrea you believe what you want to ;)
18:27 cait yep
18:27 cait :)
18:30 rangi i was missing your cookies
18:30 * libsysguy wants cookies
18:30 libsysguy there was a guy with brownies in my phys class this morning
18:30 * libsysguy got none
18:31 sekjal wait, brownies, what?
18:31 * sekjal looks away for a second, and there is dessert
18:31 libsysguy well of course...we should make Koha Cookies
18:31 libsysguy branding ftw
18:32 wizzyrea you know we have a community cookie
18:32 libsysguy 0_0
18:32 rangi yup
18:33 wizzyrea bug 5158
18:33 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5158 enhancement, P5, ---, camins, ASSIGNED , Koha needs its own cookie, ice cream, and fudge flavors
18:33 libsysguy why are there bugs in our tasty treats?
18:34 wizzyrea hehe
18:34 * cait sents rangi cookies
18:34 cait oh
18:34 cait I showed that to the library today!
18:34 cait the bug
18:34 rangi hehe
18:35 rangi right kahu 'needs' to use my computer
18:35 cait does he want to write you an email? :)
18:35 rangi "I have to send some emails, im a busy man"
18:35 rangi so im gonna go have a shower, bbiab
18:37 wizzyrea lol did he really say that
18:37 wizzyrea kahu++
18:39 maximep wow, that's the best bug report ever
18:39 wizzyrea *nod*
18:40 wizzyrea sekjal: bug 6868
18:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6868 normal, P5, ---, kyle.m.hall, NEW , Need a script to fix bad accountno data in accountlines
18:40 * wizzyrea loves getting symmetrical bug numbers
18:40 cait :)
18:41 sekjal anyone have opinions on whether the logic should live in it's own script, or be included as part of updatedatabase.pl? or both?
18:41 libsysguy the logic?
18:42 oleonard Which is easier for people installing/upgrading?
18:42 wizzyrea people installing won't be affected
18:42 wizzyrea only people upgrading
18:42 libsysguy way to think of people actually using Koha oleonard
18:42 wizzyrea well, people installing versions above 3.4
18:43 wizzyrea chris_n may want to consider snatching some parts of bug 3498 to mitigate this for 3.4
18:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3498 enhancement, PATCH-Sent, ---, colin.campbell, ASSIGNED , Allow partial fine payments
18:43 sekjal anybody who did writeoffs before bug 3498 was integrated is effected by this
18:43 sekjal most folks will never notice
18:43 sekjal but when you have lots of fines
18:43 wizzyrea you'll notice
18:43 wizzyrea eventually
18:43 sekjal you start to hit the max value of accountno
18:44 chris_n cait: that patch relies on a series which appear to begin with bug 5252
18:44 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5252 enhancement, P5, ---, nengard, REOPENED , Emails & Phones On Patron Add/Edit form
18:44 wizzyrea when that happens: kablooey
18:44 cait hm
18:44 cait yeah tha tmight have interfered with it probably
18:44 sekjal now, this WILL happen eventually, even with 3498 in place
18:44 cait I have to check that
18:44 cait really too tired now
18:44 sekjal but it'll take many many years, instead of a few months
18:44 chris_n cait: if that looks right to you, I'll go ahead and apply all those to 3.4.x
18:44 cait all those from 5252?
18:45 cait or from the translation thing?
18:45 chris_n both since the translation ones depend on 5252
18:45 * chris_n considers the phone labels a very minor enh
18:46 cait oh ok
18:46 cait it sound sok tome
18:50 pastebot "libsysguy" at 129.114.242.85 pasted "Hourly issue" (67 lines) at http://paste.koha-community.org/37
18:50 libsysguy can somebody look at that for me and give me your thoughts
18:51 chris_n kablooey?
18:51 libsysguy I know there is a bug because $chargeduration->days doesn't return the right value
18:51 libsysguy but it does it randomly from what I can tell
18:53 chris_n wizzyrea: which part of 3498 would you have applied to 3.4.x?
18:53 sekjal libsysguy: $charge_duration->{'days'}
18:53 sekjal instead?
18:53 libsysguy well hours gets called by $chargeduration->hours();
18:53 libsysguy so that is what I'm confused
18:53 wizzyrea 1s I'd have to poke at it
18:53 wizzyrea :)
18:54 * chris_n hands wizzyrea a stick
18:54 sekjal libsysguy: ah, this looks like object oriented Perl
18:54 libsysguy yes it is the new calendar module
18:54 * sekjal has less experience with that
18:54 chris_n so what does the days method do?
18:55 libsysguy interestingly enough...there is no sub for it
18:55 libsysguy oh
18:55 libsysguy wait
18:55 libsysguy chargeduration is a call to days_between
18:58 libsysguy I don't really understand the whole truncate to hours then 5 lines down truncate to days with no hourly calc
19:03 jenkins_koha Project Koha_3.4.x build #45: SUCCESS in 40 mn: http://jenkins.koha-community.org/job/Koha_3.4.x/45/
19:03 jenkins_koha * oleonard: Fix for Bug 5234 - Remove unused CSS files
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5234 normal, PATCH-Sent, ---, oleonard, ASSIGNED , Remove unused CSS files
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing / patron-attr-types
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing / clone-rules
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing / branches
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:03 jenkins_koha * oleonard: Follow-up fix for Bug 6458, incorrect parsing result in translation processing
19:03 jenkins_koha * januszop: Bug 6368: unimarc_field_4XX plugin does not work with new templates - corrected
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6368 normal, PATCH-Sent, ---, januszop, ASSIGNED , unimarc_field_4XX plugin does not work with new templates
19:03 jenkins_koha * colin.campbell: Bug 6620 Ensure autoflush is set on output filehandles
19:03 jenkins_koha * lrea: Bug 6841 - A member with cataloging permissions cannot change branches (when independent branches is set on)
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6620 major, PATCH-Sent, ---, colin.campbell, ASSIGNED , Sip Server Output may be buffered
19:03 jenkins_koha * nengard: bug 6677 - remove reference to 'debarred'
19:03 jenkins_koha * oleonard: Fix for Bug 2891, cannot manually enter date at reports/issues_stats.pl
19:03 jenkins_koha * m.de.rooy: 6829: Remove two warnings for opac-MARCdetail
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6841 major, PATCH-Sent, ---, wizzyrea, ASSIGNED , A member with cataloging permissions cannot change branches (when independent branches is set on)
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6677 normal, PATCH-Sent, ---, nengard, ASSIGNED , patron stats still refers to debarred
19:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2891 normal, PATCH-Sent, ---, oleonard, ASSIGNED , Cannot manually enter dates in some report forms
19:07 cait libsysguy: the line you were referring to earlier in the logs - about the copypasteoverdue thing - it's been in there like forever
19:07 cait libsysguy: if you are in there... can you check that a grace period of 3 and a fine interval of 7 actually gives you the first fine after 3 days of grace period? :)
19:07 jenkins_koha Starting build 46 for job Koha_3.4.x (previous build: SUCCESS)
19:08 libsysguy wouldn't it take 7 days to check
19:08 libsysguy err 10
19:08 * libsysguy can't add
19:10 cait libsysguy: duedate - grace period 3 fine seven days later another fine... and so on
19:10 cait but what it does do is fine interval = enforced minimum grace period
19:10 cait which is evil
19:10 cait it works perfectly for charging periods like 1
19:10 cait but not for higher numbers
19:10 * cait grumbles
19:10 libsysguy oh? so its a 24 hour grace period regardless
19:11 libsysguy ohh
19:11 libsysguy i see
19:11 cait not sur eif it changed for hourly
19:11 cait that's why I told you - in hope oyu might be able to check :)
19:11 libsysguy yeah that whole function changed
19:11 cait and because I gave you cookies... and I am nice (sometimes)... and... more cookies?
19:12 * libsysguy is full, fat, and happy :)
19:13 * libsysguy has a new favorite perl line
19:13 libsysguy use Carp;
19:13 cait so cookies will not work?
19:13 cait :)
19:13 libsysguy as a bribe?
19:14 libsysguy I would check it for you regardless cait
19:14 cait aww
19:14 cait ok, normal setting for us would be something like 2 days grace, charge interval weekly and some fine like 1.50
19:15 cait and in my perfect world it owuld give you the first fine 2 days after due date
19:15 libsysguy gotcha
19:15 libsysguy so right now it is giving you 2 days after the interval
19:15 libsysguy so 9 days after the due date
19:17 cait something liek that yes
19:17 cait last tested in 3.2.2 i have to confess
19:17 libsysguy hehe
19:18 cait but not aware of any changes soon after that or in the 3.2.x
19:18 libsysguy well there is that new OOP Calendar module
19:19 cait lots of changes for short loans I guess
19:19 libsysguy yes there are quite a few
19:20 * oleonard finally tracks down the stupid typo he was sure was causing his problems of the last few hours
19:22 cait oleonard: cookie?
19:22 wahanui1 cookie is being set in the browser?
19:22 wizzyrea oleonard: ice cream?
19:22 wizzyrea forget cookie
19:22 wahanui1 wizzyrea: I forgot cookie
19:22 * oleonard checks his watch. Too early for what he needs.
19:23 cait but you found the problem
19:23 cait I found a lot of i18n problems in my presentation today :(
19:23 cait some quite embarassing typos
19:23 * cait sighs
19:23 cait lots of cleaning up to do
19:23 wizzyrea cookie is bug 5158
19:23 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5158 enhancement, P5, ---, camins, ASSIGNED , Koha needs its own cookie, ice cream, and fudge flavors
19:24 oleonard The good news is I think Bug 6458 is vanquished, for now.
19:24 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
19:26 libsysguy I have a DateTime::Duration object that I call ->days on...the object has 13 months 0 days 863 minutes and I get 0 for days
19:29 rangi back
19:29 huginn New commit(s) needsignoff: [Bug 6458] incorrect parsing result in translation processing <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458>
19:29 rangi oleonard: ill try to push the new patches
19:29 rangi today
19:30 * chris_n empathizes with oleonard's typo hunt
19:30 chris_n heya rangi
19:30 libsysguy anybody familiar with the DateTime::Duration module?
19:30 rangi probably colin
19:30 libsysguy I think I found the problem I just want to make sure I'm not crazy
19:31 rangi man pages tell ya anything?
19:31 libsysguy yeah...you can't convert from months to days
19:32 libsysguy also there was an error in the CalcFine code
19:32 rangi you have to convert first, then call duration?
19:32 libsysguy it just says its not supported...that is what I wanted to ask about...just make sure I was reading it right
19:33 rangi well a month could be 28, 29, 30, 31
19:33 rangi days
19:33 libsysguy right
19:33 rangi so it makes sense
19:33 libsysguy I thought manip supported that kind of weird date manipulation
19:33 rangi for a specific month yes
19:33 rangi 1 month
19:34 rangi who knows 2011-09 you could do
19:34 rangi that make sense?
19:34 rangi ill read the man when I get off the bus
19:34 rangi but thats my guess why
19:34 libsysguy ok...i may try and see if date::calc will do it
19:35 rangi what exactly are u trying to convert?
19:35 rangi a specific month, or range of months
19:35 libsysguy well just how ever long the overdue is
19:35 rangi or the phrase 1 month?
19:35 rangi why would it ever be in months?
19:36 libsysguy dude...our librarians are insane about holding a grudge for fines
19:36 libsysguy they keep them...like forever
19:36 rangi I know
19:36 rangi but still days
19:36 rangi we have some 4578 days overdue
19:37 libsysguy so my duration hash has 13 months 867 minutes and 57 seconds in it
19:37 libsysguy and when i call ->days I get 0
19:37 rangi ah so it is converting
19:37 libsysguy yeah
19:37 libsysguy then not wanting to convert back
19:37 rangi can u make it not do that?
19:37 libsysguy hmm
19:37 libsysguy maybe
19:37 libsysguy but it does it in koha::calendar
19:38 libsysguy so I don't want to break that lol
19:38 rangi hmm
19:39 libsysguy yeah im slightly stumped
19:39 libsysguy I guess I'm the only one using hourly because that DateCalc function was all kinds of broken
19:39 huginn New commit(s) needsignoff: [Bug 6869] Batch item modification fails if accented characters are used in the modification form. <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6869>
19:39 rangi you know what, id update the bug
19:39 rangi make sure colin is cced
19:39 rangi since koha::calendar is his code
19:39 rangi and see what he has to say, mean while you can do a local patch for calcfines to not use duration maybe?
19:39 rangi use date::calc isntead
19:40 rangi you sure are
19:40 libsysguy Im ashamed I didn't catch it
19:40 rangi no worries
19:40 rangi thats why we have 3 levels of signoff for big stuff
19:40 libsysguy ok I'll ping colin and see what he thinks
19:40 libsysguy yeah for sure
19:41 rangi thanks for testing
19:41 libsysguy thanks for helping me
19:42 rangi no worries
19:42 rangi what was the calcfine bug?
19:43 rangi fixing that will catch all but the really old overdues (which hopefully already have fines)
19:43 libsysguy it was calling DateTime::Duration Object ->days instead of -> in_units()
19:43 libsysguy ('days')
19:43 libsysguy **
19:43 libsysguy same deal for hours
19:43 libsysguy so basically the entire diff for the dates was off
19:44 sekjal libsysguy: you've done a great job testing Hourly Loans, and you're continuing to do so
19:44 * wizzyrea is totally kidding
19:44 wizzyrea no, you fail! Good day!
19:44 wizzyrea there, does that satisfy you?
19:44 libsysguy did wizzyrea lose it?
19:44 wizzyrea :)
19:45 libsysguy and thanks sekjal
19:45 sekjal rangi: did you catch up on back-conversation about the problem with the writeoff subroutine in accounts (pre-bug3498)?
19:45 wizzyrea libsysguy: I was "giving you the punishment you (deserve) expect"
19:45 rangi yup
19:46 libsysguy 0_0
19:46 sekjal rangi: recommendations on whether the cleanup should be done as part of updatedatabase.pl or as a separate script?
19:46 rangi hmmm
19:46 rangi sep script
19:46 sekjal takes about 5 min to run on a NEKLS-sized system
19:47 wizzyrea pretty much everybody *ought* to run it if it's an upgrade
19:47 rangi bet it will take longer on hlt one
19:47 rangi 11.5 years of accounts
19:47 wizzyrea how many lines in hlt accountlines?
19:47 wizzyrea i'm amazed they haven't hit the limit
19:47 rangi millions
19:47 sekjal depends on the number of patrons, and how often writeoff was used
19:48 jenkins_koha Project Koha_3.4.x build #46: SUCCESS in 40 mn: http://jenkins.koha-community.org/job/Koha_3.4.x/46/
19:48 jenkins_koha * nengard: Bug 5252 - Phone labels on patron creation
19:48 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
19:48 jenkins_koha * katrin.fischer: Fix for Bug 6458 Follow-up for memberentrygen.tt
19:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5252 enhancement, P5, ---, nengard, REOPENED , Emails & Phones On Patron Add/Edit form
19:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
19:48 rangi the only thing id worry about is apache timeouts
19:48 sekjal each individual has a limit of 32767 lines currently... but writeoffs make folks hit that sooner than they normally would
19:48 cait sekjal: there was an old bug for writeoff
19:48 cait sekjal: telling it will corrupt data -but noone ever told me how and why
19:49 cait bug 2632
19:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2632 normal, P3, ---, gmcharlt, REOPENED , Writeoff Fines Need Improvements
19:49 wizzyrea well i haven't observed it not working
19:50 sekjal yes, just looking at that
19:50 wizzyrea it seems to work fine
19:50 wizzyrea just doesn't/didn't increment accountno correctly
19:50 sekjal there could be other problems in addition to taht
19:50 sekjal all this will be moot once the accountlines structure is updated
19:50 wizzyrea always :)
19:51 wizzyrea but like I said, we obviously use it all the time, and have had no complaints that it's not working correctly
19:51 wizzyrea except for the stinger today
19:52 rangi well wed need to port the fix to 3.r
19:52 rangi gah
19:52 rangi 3.4.x too
19:54 sekjal I think we could do the 3.4.x fix with a couple quick lines in members/pay.pl
19:54 sekjal use the correct subroutine to get the next account number, instead of the buggy SQL
19:55 rangi hmm if we changed updatabase to warn it might take a long time, before it ran, then in there might be ok
19:55 rangi yep
19:55 rangi I propose we chabg
19:56 rangi man bumpy ride
19:56 rangi we change the column too to integer
19:56 rangi just in case someone does legit do that many per borrowernumber
19:57 wizzyrea it seems like it could be possible
19:57 wizzyrea to get that high
19:57 wizzyrea though unlikely
19:57 sekjal my cleanup script is ready to upload to the bug report; I can put the logic into an updatedatabase.pl update as well, including the redefinition of the accountno column
19:57 rangi I could see an institution doing it
19:57 wizzyrea *nod*
19:57 wizzyrea sekjal++
19:57 rangi cool
19:59 sekjal okay, so three attachments: cleanup script, patch with cleanup in updatedatabase.pl, and patch of ported fix for 3.4.x
20:01 wizzyrea awesomesauce
20:02 sekjal will upload the clean up script now; the others will take a bit of time to complete
20:02 chris_n sekjal: will it make 3.4.5?
20:03 sekjal chris_n: likely
20:03 chris_n cool
20:04 rangi my stop bbiab
20:05 cait and time to get some sleep for me
20:05 cait good night all
20:23 huginn New commit(s) needsignoff: [Bug 6870] [enh] allow opac-userupdate.pl to use the patron's email as 'from' address <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6870>
20:24 oleonard Nice.
20:29 wizzyrea wow colin is made of win today
20:29 wizzyrea see that patch for bug 3638 - that is an oooold NEKLS wishlist item
20:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3638 normal, PATCH-Sent, ---, colin.campbell, ASSIGNED , Status of hold not changed when item checked in via SIP2 Interface
20:30 rangi yeah, ptfs europe are nothing like their cousins
20:30 wizzyrea ptfs-e++
20:31 libsysguy rangi do you know how holidays currently work?
20:31 libsysguy before OOP koha
20:31 rangi yeah, i never get any
20:31 rangi oh you mean in koha
20:31 rangi nope
20:31 wizzyrea i'd take that as a no
20:31 wizzyrea ;)
20:32 wizzyrea can you define your question, libsysguy?
20:33 libsysguy well...with Koha::Calendar all the dates/holidays revolves around this module
20:33 libsysguy but what about the old one?
20:33 rangi C4::Calendar
20:33 rangi its all in there
20:37 rangi was that what you were asking?
20:43 rangi heya druthb
20:43 druthb hi, rangi!
20:45 huginn New commit(s) kohagit: Merge remote-tracking branch 'kc/new/bug_6458' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6499cfc2c090b79516fa55ee23abbe1cda357150> / Fix for Bug 6458 - incorrect parsing result in translation processing <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7cc412d337245b5ffbbb94b5c503e6afd989a3ed> / Fix for Bug 6458 - incorrect parsing result in translation processing <http://
20:52 libsysguy hey guys sorry i went afk
20:52 libsysguy anyway I was just wondering if C4::Calendar handled dates the same way as Koha::Calendar
20:52 jenkins_koha Starting build 416 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #385 27 j ago)
21:32 libsysguy I am about to ask a newb question...just a fair warning
21:32 wizzyrea @quote get 145
21:32 huginn wizzyrea: Quote #145: "Don't ask to ask, just ask!" (added by wizzyrea at 02:37 PM, July 07, 2011)
21:32 wizzyrea <3
21:32 libsysguy can someone explain to me the difference between a date and a delta
21:32 libsysguy aww thanks wizzyrea
21:33 rangi looking at date::calc libsysguy ?
21:33 libsysguy looking at Date::Manip
21:33 rangi dont use that
21:33 libsysguy aww
21:33 rangi Date::Manip is slow
21:33 libsysguy yeah its big
21:34 rangi it will slow down everything like circ
21:34 rangi a patch with date::manip will not get pushed
21:34 libsysguy who needs circ anway :p
21:34 libsysguy well Calc really isn't that much smaller
21:34 wizzyrea rangi lays down the law
21:34 wizzyrea I like it
21:34 libsysguy heh
21:34 rangi its not size its speed
21:34 * libsysguy will forget how much he loves manip
21:34 rangi manip is fine for doing things that are needing to be fast
21:35 rangi but it even warns you itself
21:35 libsysguy yeah it does
21:35 libsysguy its monolithic
21:35 rangi its more the way its written
21:35 rangi its not intended to be fast
21:35 rangi but complete
21:36 rangi Date::Calc will do all you need
21:36 libsysguy yes sir
21:36 rangi have you looked at C4::Dates ?
21:36 libsysguy I haven't
21:36 rangi might be Koha::Dates in 5549
21:37 libsysguy just been plunking around in calendar
21:37 rangi yeah look at that module
21:37 jenkins_koha Project Koha_master build #416: STILL UNSTABLE in 44 mn: http://jenkins.koha-community.org/job/Koha_master/416/
21:37 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
21:37 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
21:37 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
21:37 libsysguy I see DateUtils
21:37 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
21:37 jenkins_koha * oleonard: Fix for Bug 6458 - incorrect parsing result in translation processing
21:40 rangi here to make you feel better
21:40 rangi http://crappypictures.typepad.com/crappy-pictures/2011/09/gifts-from-my-children.html
21:41 libsysguy hehe
21:41 wizzyrea lol
21:41 * wizzyrea can relate to the puke in hands thing
21:41 libsysguy GROSS!!
21:42 wizzyrea you call me when you have a kid and tell me what you do when it's the carpet or your hands
21:42 wizzyrea ;)
21:42 libsysguy if we keep talking about puke I may not have to wait for kids
21:42 wizzyrea oh cool, you can just puke in your own hands :)
21:43 libsysguy I was afraid that may not have come accross
21:43 libsysguy ok i gotta get out of here for today
21:44 rangi @later tell libsysguy PUKE!!! PUKE!! VOMIT!! UPCHUCK!! RALPH!!
21:44 huginn rangi: The operation succeeded.
21:45 rangi http://wimp.com/babygorilla/
21:47 jenkins_koha Starting build 417 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #385 27 j ago)
21:47 rangi right, this time!
21:53 wizzyrea lol you crack me up rangi
21:56 rhcl wizzyrea and gmcharlt : looks like the university students have decided to work on the public access computer project
21:56 wizzyrea woohoo
21:56 gmcharlt coolness
21:57 rangi yay!
21:57 rhcl BTW, our children's playstation is pretty much finished; I just have to do the documentation. I'm thinking, however, that it'
21:57 rhcl ...
21:57 rhcl it's going to be a bit more complicated that what may first come to mind
21:59 rangi http://www.stuff.co.nz/sport/rugby/5627316/New-Plymouth-braces-for-Cold-War-battle
22:17 * moodaepo reads rangi's link and thinks for a second that there are Cold War reenactment groups in NZ
22:17 rangi heh
22:18 moodaepo Oh it is rugby...Russians play rugby?
22:18 rangi yup
22:18 rangi first time they have qualified for the world cup though
22:21 moodaepo Yea just finished reading the article, haven't watched rugby in a while.
22:30 jenkins_koha Yippie, build fixed!
22:30 jenkins_koha Project Koha_master build #417: FIXED in 43 mn: http://jenkins.koha-community.org/job/Koha_master/417/
22:30 rangi w00t!
23:44 druthb o/