Time  Nick         Message
23:53 wajasu       ok. got to head out.  will try later.
23:51 jcamins_away Add my github repo as remote, and checkout a copy of the search_t branch.
23:49 wajasu       ok.  i'll try tonight. just git clone your git repo and run?
23:48 jcamins_away But that's really just for fun. :)
23:48 jcamins_away Unless you want to see the coverage report, in which case you'll need Devel::Cover.
23:47 jcamins_away But the latter two are already needed.
23:47 jcamins_away And Test::MockModule and DBD::Mock.
23:47 jcamins_away Just Test::Warn.
23:46 wajasu       that unit test you slaved over today.  will i need to install Devel:Cover or something special?
23:46 jcamins_away Jeez... themes are like two days ago! Expecting me to remember all that. :P
23:45 wajasu       :)
23:45 jcamins_away That too.
23:45 jcamins_away Oh, yeah, theme stuff.
23:45 jcamins_away Nice easy sign offs.
23:45 rangi        or those 2
23:45 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8649 enhancement, P5 - low, ---, jcamins, Needs Signoff , C4::Search needs a unit test
23:45 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8648 normal, P5 - low, ---, jcamins, Needs Signoff , searchResults uses SQL query rather than GetMarcFromKohaField
23:45 rangi        the theme stuff
23:45 jcamins_away wajasu: bug 8648 and bug 8649.
23:44 wajasu       rangi: if you were to pick something to signoff, what would it be?
23:43 rangi        so yeah, linking it to that column, not a good idea
23:42 jcamins_away Right.
23:42 rangi        thats how mysql does it anyway
23:42 rangi        ie, if you dont set it, it updates automatically
23:42 rangi        the timestamp will change
23:42 rangi        if that row is ever changed by anything else
23:41 rangi        BUT
23:41 rangi        yuo can manually set them tho
23:41 rangi        thats right
23:41 jcamins_away Timestamps are maintained by the database, which is written to after the record is saved... right?
23:41 wajasu       the comment is enough?
23:41 jcamins_away rangi: would linking a MySQL timestamp column to a MARC field even work?
23:40 rangi        yes
23:40 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8637 critical, P1 - high, ---, christophe.croullebois, Needs Signoff , Lack of control on mandatory in orderreveive.tt
23:39 wajasu       rangi: working on signoffs today i see for bug 8637 owen mentioned the patch fixed it and suggested some other work, but should it still be left as Needs Signoff? or is comment enough to signal the patch writer to working it some more?
23:39 jcamins_away True.
23:39 jcamins_away Ah.
23:39 rangi        i dont think that even touches zebra
23:38 rangi        in acquisitions tho?
23:35 wajasu       ooooh
23:34 jcamins_away That's my analysis.
23:34 jcamins_away They don't have duplicate records. They have duplicate index entries.
23:18 rangi        cya drojf
23:17 drojf        good night #koha
23:10 rangi        so its -itemscontent title,date_due,etc
23:10 rangi        http://perldoc.koha-community.org/misc/cronjobs/overdue_notices.html
23:10 rangi        heh wrong url
23:09 rgbv         thanks rangi, you're a star :) I did'nt know I can change it
23:09 rangi        https://wrms.catalyst.net.nz/wr.php?request_id=97492
23:09 rangi        the switch is -itemscontent
23:08 rangi        rgbv: you know you can change what is is in the items.content in how you call the job eh?
23:07 wahanui      i guess itemnumber is the primary key for the items table
23:07 rangi        itemnumber
23:07 rgbv         what does the 70566 refer to? it's not the bib number
23:07 rgbv         IWe are using the <<items.content>> sytax on our overdue notices,it generates this in emails02/08/2012	Cold case /	U10985963	Kellerman, Faye.	70566
23:05 rangi        hi rgbv
23:04 rgbv         Hi all
23:04 rangi        i cant see how either of them could possibly duplicate anything
23:03 rangi        yeah, it just runs 2 update querys
23:03 rangi        hehe
23:03 drojf        isn't that libsysguy's library? he might have done something crazy :P
23:02 rangi        its an odd one
23:01 rangi        it doesnt touch acquisitions at all
22:59 drojf        ;)
22:59 drojf        would be interesting if they messed it up before and found out by running that script
22:58 rangi        its impossible to have 2 with the same biblionumber unless you have messed your db up
22:58 rangi        also, you cant have duplicate entries in the biblio table, at least biblionumber is unique
22:58 rangi        so i cant see how it could duplicate entries
22:57 drojf        but why would it duplicate entries if nothing was changed?
22:57 rangi        it just runs updates
22:55 rangi        it updates the biblio and biblioitems tables
22:55 rangi        wath it does is run through every record, and do _koha_modify_biblio and _koha_modify_biblioitem_nonmarc
22:55 drojf        "rebuilds the non-MARC DB from the MARC values". i don't even know what that means
22:54 rangi        but yeah i reckon that note should go
22:54 rangi        hmm it has a -t
22:53 drojf        i have never used that script, but yes that is probably right
22:52 rangi        so 2 problems there
22:52 rangi        could be, but running command line batch processes when you dont need to is never a good idea
22:52 drojf        i don't think it should matter what field the text was meant for, that should not happen?!
22:51 rangi        it does
22:51 drojf        uh-oh that bug report sounds bad
22:44 cait         sorry libsysguy - not sure
22:43 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8650 normal, P5 - low, ---, gmcharlt, NEW , running misc/batchRebuildBiblioTables.pl messes up tables and creates duplicates
22:43 rangi        bug 8650
22:43 rangi        eeek even
22:42 rangi        eel
22:29 libsysguy    for(x=0; x<30; x++){}
22:28 libsysguy    a for loop
22:28 cait         does it has text that needs to be translated?
22:28 cait         what kind of loop?
22:27 libsysguy    ok so I want to print a select tag in html with options 1-30.  I don't want to have to type them all so I thought I could do a forloop in TT and print them in it.  I can't seem to figure out how to make TT do that.  Anybody have any pro tips
22:24 cait         hi kathryn :)
22:23 kathryn      hi cait :)
21:39 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8253 blocker, P3, ---, kyle.m.hall, Needs Signoff , Fine doubling
21:39 wajasu       maybe bug 8253 needs to be in FailedQA based on comment#12, so Kyle might know to work on it some more?
21:35 wajasu       signoff
21:35 wajasu       skipping duplicate bug 8348 after comment #35 in 8110 and later deprecation of a patch in 8110, someone else deep into it should.
21:33 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8110 blocker, P1 - high, ---, kyle.m.hall, Signed Off , Add tests for Calendar modules
21:33 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8348 critical, P1 - high, ---, koha-bugs, Needs Signoff , useDaysMode syspref does not apply
21:33 wahanui      bug 8348 is a duplicate of bug 8110
21:33 wajasu       bug 8348
21:33 wajasu       i'm skipping that one for now
21:22 wajasu       owen mentioned the patch fixed it and suggested some other work, but should it still be left as Needs Signoff?
21:21 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8637 critical, P1 - high, ---, christophe.croullebois, Needs Signoff , Lack of control on mandatory in orderreveive.tt
21:21 wajasu       bug 8637
21:13 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8649 enhancement, P5 - low, ---, jcamins, Needs Signoff , C4::Search needs a unit test
21:13 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8648 normal, P5 - low, ---, jcamins, Needs Signoff , searchResults uses SQL query rather than GetMarcFromKohaField
21:13 jcamins      Bug 8648 and bug 8649 ready for sign off.
21:02 jcamins      :)
21:01 jcamins      I'll find out.
21:01 wajasu       i'm going to attach snapshots, but should i make it failedQA?
21:01 rangi        no idea
21:01 jcamins      rangi: what's the maximum size for uploads to bugzilla?
21:01 drojf        from how i understand it the patch is not doing what it is supposed to. but i had a really long day, i might be wrong
21:00 wajasu       maybe the javascript is not matching up
21:00 wajasu       but not i don't
21:00 wajasu       before the patch, if I put the orderline inthe filter and click the filter button, i got a Receive/Cancel column added to the row.
20:59 wajasu       after i put somehting in the filter, i don't get the Receive/Cancel links anymore so I can't "Cancel"
20:59 drojf        hm yes i woul dsuppose that there still should be one, or i misinterpret the text
20:59 wizzyrea     I didn't even see the "cancel" link  I must have been doing it wrong.
20:58 drojf        i think "you will only get a warning message, but not more, the line will not be cancelled"
20:58 drojf        To test : when you are in "parcel.pl" ready to receive orders, simply select a filter on the left and on the filtered page try to cancel a line, you'll have the warning message but no more, the line will be not canceled.
20:58 rangi        http://digitalcommons.kennesaw.edu/glq/vol49/iss3/9/
20:57 wizzyrea     i don't understand it either
20:57 wajasu       i see the Receive/Cancel links in master, but after the patch, i don't see them anymore.  is that the dsired behavior?
20:56 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8649 enhancement, P5 - low, ---, jcamins, Needs Signoff , C4::Search needs a unit test
20:56 * jcamins    is attaching the patch to bug 8649.
20:56 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8382 blocker, P1 - high, ---, christophe.croullebois, Needs Signoff , It is not possible to cancel an order when receiving on a filtered page in parcel.pl
20:55 wajasu       can someone read bug 8382 to help me understand the desired behavior.  aquisitions, receiving order/shipment, filter Cancel ?
20:54 drojf        also
20:54 drojf        no items available alspo
20:54 drojf        yes
20:53 jcamins      drojf: yes, they regularly demand to know why they don't have usable results.
20:53 drojf        still we have people "using" nozebra with koha 3.8, according to the mailing list
20:52 jcamins      NoZebra has not worked since 3.2.
20:52 jcamins      Right.
20:52 wajasu       is nozebra not an option anymore?  you must use zebra or upncoming solr?
20:50 jcamins      wajasu: yes, that was mine.
20:49 wajasu       jcamins - is saw a bug for deleting vestigal nozebra stuff.
20:49 jcamins      (NZ=NoZebra)
20:47 jcamins      69.6% coverage if you delete all the NZ stuff.
20:44 kathryn      hi wizzyrea!
20:43 wizzyrea     hi kathryn :)
20:33 kathryn      :)
20:31 drojf        hi kathryn
20:25 kathryn      morning folks :)
20:24 rangi        yep
20:24 jcamins      It's a known issue that hidelostitems doesn't work, isn't it?
20:23 drojf        hey rangi
20:23 rangi        heh
20:22 drojf        hey. i got 8 (!!) snapshots of today now in hyper-v, none of which has the name i gave that one that pretended to go on and on
20:22 rangi        hi drojf
20:19 drojf        hello again
20:08 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8382 blocker, P1 - high, ---, christophe.croullebois, Needs Signoff , It is not possible to cancel an order when receiving on a filtered page in parcel.pl
20:08 wajasu       iok i am trying to atempt to signoff Bug 8382 again
20:04 jcamins      66.8% coverage if you delete all the NoZebra stuff.
20:03 mveron       Hi rangi
20:03 rangi        Hi mveron
20:02 mveron       Good evening #koha
19:55 rangi        Excellent
19:54 jcamins      rangi: ^^
19:54 pastebot     "jcamins" at pasted "Testing C4::Search" (114 lines) at http://paste.koha-community.org/110
19:52 jcamins      4.5MB is acceptable.
19:52 jcamins      Actually, it's not nearly as large as I thought.
19:52 jcamins      It's a shame this patch is horrifyingly large.
19:50 rangi        It's a shame Yahoo break everything good they do eventually
19:49 jcamins      All fifty one tests are passing again.
19:49 oleonard     I'm still not thrilled with any of the grid systems I've tested as replacements for YUI Grids
19:48 oleonard     I hope some of that experience I'll be able to bring to Koha
19:48 * oleonard   is ironing out the kinks in his responsive redesign of his library's web page
19:48 jcamins      oleonard: I think the trick is to move it one library at a time.
19:47 * oleonard   gave up
19:47 oleonard     Heh, yeah I tried the other -- moving js out of translated paths.
19:46 tweetbot`    [off] twitter: @percussionbf1: "kohails"
19:45 wahanui      You are welcome, I also tried the other - moving js out of translated paths
19:45 rangi        You?
19:43 rangi        But mostly just testing patches and client work
19:43 rangi        I was playing with Ajax and pazpar2 as well
19:42 oleonard     Oh yeah
19:42 rangi        To allow ppl to auth via that (browserid)
19:41 wahanui      that is pulled from the fields
19:41 oleonard     What's that?
19:41 rangi        I still have to finish my Mozilla persona patch
19:40 oleonard     Working on anything fun lately rangi?
19:38 oleonard     Hi rangi
19:38 rangi        Morning
19:26 rambutan     perhaps I should have made that a declarative statement.
19:24 rambutan     hey tweetie, is blip.tv down?
19:22 jcamins      Only 7 tests failing.
19:19 tweetbot`    [off] twitter: @kohails: "#kohails  Suspending Holds in Your Koha 3.8 Catalog http://t.co/uxZUgaGZ"
19:03 wizzyrea     lol, jcamins, ein
19:01 wizzyrea     now*
19:01 wizzyrea     I think I see what you're gettig at not
19:00 wizzyrea     all in description
19:00 wizzyrea     hm no
19:00 wizzyrea     washington
18:59 jcamins      salud works, though, actually.
18:59 jcamins      All the hits have Potter in the title. :/
18:09 tweetbot`    [off] twitter: @ByWaterSolution: "Suspending Holds in Your Koha 3.8 Catalog http://t.co/XnZqO2W8 #kohails"
17:57 drojf        great, i am held hostage by that hyper-v snapshot-taking process. or i cancel it and have it run for hours again when i'm home :/
17:54 drojf        btw i stopped working on it because our koha was suddenly broken
17:54 drojf        i think it tries to guess what audio and subtitle languages our items have. and some other things. also i think it's not even in "produce an actual outout file" mode. it's great to return to working on stuff that was weird and complicated weeks ago when i remembered what all the things actually do
17:53 jcamins      drojf: in that case I don't know either.
17:52 drojf        jcamins: nooo it would never do that
17:52 jcamins      drojf: is it breaking circulation on my newly-reinstalled Koha instance?
17:51 drojf        i have no idea what my script is doing, but at least it takes a long time to run it
17:47 tcohen       (from my upgrade script for the 38 isntances I have)
17:46 tcohen       echo "========================================="
17:46 tcohen       echo ""
17:46 tcohen       KOHA_CONF=/etc/$KOHAINSTANCE/koha-conf.xml PERL5LIB=/usr/share/$KOHAINSTANCE/lib perl /usr/share/$KOHAINSTANCE/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
17:46 tcohen       echo ""
17:46 tcohen       echo "========================================="
17:46 tcohen       echo ""
17:46 tcohen       echo ">> updatedatabase.pl"
17:46 tcohen       KOHA_CONF=/etc/$KOHAINSTANCE/koha-conf.xml PERL5LIB=/usr/share/$KOHAINSTANCE/lib perl /usr/share/$KOHAINSTANCE/bin/maintenance/remove_items_from_biblioitems.pl --run
17:46 tcohen       echo ">> remove_items_from_biblioitems.pl"
17:46 chris_n      virtual machines are only ever virtually dead, not really dead
17:46 tcohen       wajasu: it did run ok *before* the updatedatabase.pl for me
17:45 wizzyrea     raggy?
17:44 wizzyrea     rut roh shaggy
17:44 jcamins      It boots, but Koha Does Not Function Right.
17:44 wizzyrea     errrr
17:44 jcamins      I think I just killed my VM.
17:44 wizzyrea     ?
17:44 jcamins      Wow.
17:40 * jcamins    reinstalls Koha.
17:39 wizzyrea     cool
17:39 wizzyrea     oh :)
17:39 jcamins      You answered my question in a PM.
17:39 jcamins      Detail.
17:39 wizzyrea     opac search or detail
17:37 jcamins      Then tell me whether the OPAC says its been checked out.
17:37 jcamins      Any book.
17:37 jcamins      Check out a book.
17:36 jcamins      Would someone please do me a favor?
17:28 maximep      but dont do like me :p
17:27 maximep      bah, I ran it months after the upgrade :S
17:27 wajasu       cool.
17:27 jcamins      Right.
17:26 wajasu       right after the webinstaller upgrades
17:26 jcamins      Before anyone else touches the server.
17:26 jcamins      If you mean running the script, you *absolutely must* run it as soon as you upgrade.
17:26 jcamins      If you mean the upgrade is, that's fine.
17:25 wajasu       thats on my TODO list.
17:25 jcamins      Yes.
17:25 wajasu       if i upgrade from 3.0.??? to 3.8.3  then should i be running remove_items_from_biblioitems after the upgrade?
17:24 jcamins      And consistent authorized values.
17:24 wizzyrea     hm
17:24 jcamins      With items and stuff.
17:23 jcamins      But I wanted a dataset of ~100-200 records.
17:23 jcamins      No.
17:23 wajasu       are you in a sandbox?
17:22 jcamins      In hindsight, that was roughly the stupidest thing I could've done starting out.
17:22 jcamins      Why on earth did I decide to use the MARC21 data from the sandboxes?
17:21 jcamins      Or not.
17:21 jcamins      I needed to run remove_items_from_biblioitems.
17:20 jcamins      Ah-ha.
17:16 wajasu       thx
17:15 jcamins      Then no.
17:15 wajasu       i'm calling it from overdue_notices.pl successfully.
17:15 jcamins      Okay, I shall check out a few items that I know are checked out.
17:14 jcamins      wajasu: that depends if you want to export it.
17:14 wizzyrea     !
17:14 wizzyrea     you are right@
17:14 wajasu       at the top of C4::Letters. do i need to add GetLetter like so?  ==> @EXPORT = qw( &GetLetters &GetLetter  ...
17:14 wajasu       perl question.  fixed overdue_notice.pl to show fines for each item.  i needed to add GetLetter in C4::Letters  i noticed a @EXPORT section
17:14 drojf        cait: i'm pretty sure it will break itself
17:14 jcamins      wizzyrea: I figure baffling check out statuses is a tradition, amiright?
17:13 cait         drojf: I would break that too
17:11 jcamins      I don't know.
17:11 jcamins      I'll tell you-
17:11 wizzyrea     do tell
17:11 jcamins      You're thinking "how the devil can you not know if an item is checked out or not?"
17:11 jcamins      I know what you're thinking.
17:10 jcamins      Uh-oh. I can't tell whether these records are checked out or not.
17:10 drojf        switch even
17:10 drojf        i would be happy to swicht vms with you. this is hyper-v
17:09 cait         virtualbox hates me
17:09 drojf        uh-oh a blue line appeared, indicating something around 50%
17:07 drojf        what did i miss? or should i better not ask?
17:07 * cait       growls
17:07 cait         drojf: don't mention vm to me
17:05 drojf        hm. it has a progress bar. that is all grey, like in 0%
17:04 drojf        i wish that snapshot thing had a percentage though. i wonder if that does anything and it has been running for almost an hour now
17:04 jcamins      drojf: no.
17:03 drojf        heh i should probably not complain about my db upgrade taking 10 minutes in front of jcamins
17:03 jcamins      Barely.
17:03 jcamins      And the test is still shorter than Search.pm.
17:02 jcamins      50.6%
17:02 * jcamins    does the happy truffle dance
17:01 drojf        maybe i have to reboot something. the solution to everything
17:00 drojf        wow, i did not remember how long things can take in windowsland. watching a stone age filemaker database to update to a new filemaker database just to export the data on one machine, waiting for a hyper-v *cough* snapshot on the other
16:59 wizzyrea     good one
16:59 * wizzyrea   giggles
16:58 drojf        it is on mars ;)
16:57 * wizzyrea   wonders since when "try and help out" was an offensive suggestion
16:54 wizzyrea     yw, anytime
16:54 wizzyrea     kek
16:53 martian523   haha, thanks!
16:53 wizzyrea     whoever, we're happy to help
16:53 * drojf      notes 'wizzyrea' in his 'people to bug about jquery' list
16:53 wizzyrea     or your IT guy
16:52 wizzyrea     yea, let us know if you need help with the jquery
16:52 martian523   thanks for your help!
16:52 * cait       waves
16:51 martian523   ok
16:51 wizzyrea     (can't fix it if we don't know it's broken and all that)
16:51 wizzyrea     and bug reports help us know what to fix
16:51 * wizzyrea   suspects you took that a bit in the wrong way - *you* don't have to submit a patch, but patches are *always* welcome ;)
16:51 martian523   ?
16:51 martian523   so i'll need to ask IT to hide that field
16:51 jcamins      And it sounds like we're about to have an epic downpour.
16:50 jcamins      Be vewwy, vewwy quiet. We're hunting zebras!
16:50 martian523   file a bug and submit a patch
16:50 wizzyrea     wow?
16:50 * jcamins    wasn't paying attention, sorry.
16:50 martian523   wow....
16:50 wizzyrea     and submit a patch :P
16:50 wizzyrea     and file a bug
16:50 wizzyrea     is to use jquery to hide that until it's fixed.
16:50 wizzyrea     then your next best option
16:49 martian523   yes
16:49 wizzyrea     it would seem so if he shows fines on the fines tab
16:48 jcamins      martian523: did you have your IT person set up the fines cron jobs?
16:48 martian523   3.8.3
16:48 martian523   it is showing up they're over due
16:48 wizzyrea     what version are you using?
16:48 martian523   but the fines are showing up on "my fines"
16:48 wizzyrea     it's not showing that they are overdue?
16:48 martian523   yes, these items are overdue, it's not showing up on "my summary" tab
16:48 wizzyrea     i mean, I don't have rules for overdues so overdue items don't accrue fines in my system
16:47 wizzyrea     but are not
16:47 wizzyrea     or are you saying that in your system, these items are overdue and should be showing that there are fines
16:47 wizzyrea     not in my system
16:47 martian523   they're overdue, so there should be fines
16:46 martian523   but it is fine on these items
16:46 wizzyrea     ping oleonard
16:46 martian523   hmm...
16:46 wizzyrea     Fines accruing on this item (too long) or "fines on this item" or "fines accruing"
16:45 wizzyrea     to whatever you think is more clear
16:45 wizzyrea     is to use jquery to change the header text for that column
16:45 wizzyrea     the simple fix for you
16:45 drojf        that it is only fines for that particular item
16:45 * drojf      thinks that is obvious
16:44 wizzyrea     wow, epic misspelling.
16:44 wizzyrea     bears
16:44 wizzyrea     I have no fines accruing on berenstain bairs
16:44 wizzyrea     so in my case
16:44 wizzyrea     oh I see - right that only applies if there is a fine for that particular item
16:43 martian523   "o, i don't have fines....but wait, i do."
16:43 martian523   isn't that kinda misleading for a patron?
16:43 martian523   but when you click on the "my fines" tab, the fines show up
16:42 martian523   yes, that's how mine looks like too, but should the fines show up on "fines" instead of "no"?
16:41 wizzyrea     this is what mine looks like
16:41 wizzyrea     http://screencast.com/t/ELfJb7nQb
16:41 wizzyrea     do you know what version of koha you are using?
16:40 martian523   ok
16:39 wizzyrea     and you can tell me if yours is different :)
16:39 martian523   ok, i'll try
16:39 wizzyrea     well, better, I'll show you what *I* see
16:39 wizzyrea     can you get a screen cap of the problem you're experiencing, martian523?
16:38 wizzyrea     there it is :)
16:38 wahanui      well, the third question is "What version of Koha are you using?" http://koha-community.org/faq/find-version-koha-running/
16:38 wizzyrea     the third question?
16:38 wahanui      the second question is "What is the exact error message?"
16:38 wizzyrea     the second question?
16:38 wahanui      "What are you trying to do?"  "What is the goal?" or "What problem are you experiencing?"
16:38 wizzyrea     the first question?
16:38 wizzyrea     hmm, in 3.8 it shows the fines on the fines tab in my summary
16:38 martian523   yes, in the opac
16:37 * wizzyrea   checks that too
16:37 wizzyrea     oph you mean in the OPAC
16:37 jcamins      rambutan: however, the bigger issue is that we're discussing the SQL at all.
16:37 jcamins      rambutan: it's borrowed from the C library.
16:37 * wizzyrea   is looking
16:36 martian523   just want to let you know i'm not an IT expert, just a regular librarian. =)
16:35 rambutan     an idle mind wants to know why not use $db_connection and $query?
16:35 martian523   it shows up on "my fines", but not showing up on "my summary"
16:35 martian523   i have a question regarding fines
16:35 wizzyrea     hi :)
16:34 wahanui      morning is probably a state of mind. or whenever the cat wants breakfast.
16:34 martian523   morning!
16:33 pastebot     "jcamins" at pasted "this is what I have to put up with" (5 lines) at http://paste.koha-community.org/109
16:32 jcamins      BLARGH!
16:30 jcamins      When I hit 50%, I'm making more truffles.
16:29 jcamins      47.9%
16:23 jcamins      Kind of hard to test something that is known to not work.
16:22 jcamins      Availability limit.
16:21 jcamins      I forgot that yaz uses a slightly modified version of CQL.
16:20 jcamins      Oh, never mind.
16:18 jcamins      This may be problematic.
16:18 jcamins      I need a CQL query.
16:18 jcamins      Okay...
16:17 drojf        almost there!
16:16 jcamins      47.0%
16:07 jcamins      Ah, yeah, it would be.
16:06 kf           jcamins: it'y only broken for diacritics
16:05 jcamins      It does work, ignore my earlier statement.
16:05 chris_n      ahh
16:05 jcamins      Index scan.
16:05 chris_n      scan?
16:05 * jcamins    tries.
16:03 jcamins      Could someone please test scan in master?
16:03 jcamins      Well- maybe.
16:03 jcamins      I'd also like to test scan, but it's broken in master.
16:03 jcamins      Oh, and error conditions.
16:02 * chris_n    peaks in while eating lunch
16:00 jcamins      ... not that I wanted those results, but...
15:57 drojf        ha! :D
15:57 jcamins      If I search for "pressed" I'll get results for "University Press." :D
15:57 drojf        so it makes up for the rest
15:57 wahanui      actually are you going to be the system administrator for this system?
15:57 jcamins      Yes, actually.
15:57 jcamins      lol
15:57 jcamins      45.9%
15:57 drojf        but in that combination i bet it's awesome
15:56 jcamins      So stemming will only work with one word, and only if you have just the right combination of sysprefs.
15:56 jcamins      If you have query weighting on, we keep the stemming, *but* then we go and massacre it with our relevancy transformation.
15:55 drojf        wow. that's… special
15:55 jcamins      drojf: nope.
15:55 drojf        jcamins: so we get results, but throw them away? you're kidding. right? right?
15:54 huginn       rambutan: The operation succeeded.
15:54 rambutan     @later tell chris_n Hey, I monitor the list at least. I'll check in on IRC.
15:54 huginn       jcamins: chris_n was last seen in #koha 1 week, 0 days, 1 hour, 27 minutes, and 34 seconds ago: <chris_n> lol
15:54 jcamins      @seen chris_n
15:54 huginn       rambutan: I have not seen chrisn.
15:54 rambutan     @seen chrisn
15:54 huginn       rambutan: I have not seen CNighswonger.
15:54 rambutan     @seen CNighswonger
15:54 jcamins      Turns out stemming doesn't work because we throw away the results.
15:53 drojf        jcamins: honestly i think i tried to find out something about it long ago, long before i knew about the full glory of Search.pm. i stopped because i thought i don't understand anything that is going on and should leave it alone
15:53 jcamins      I have always thought that stemming didn't work because we didn't do it right.
15:52 jcamins      We were wrong.
15:52 jcamins      You know how we thought stemming did something on its own?
15:52 drojf        drown your sorrows in sugar ;)
15:52 * drojf      offers english wine gums
15:51 jcamins      Creative.
15:51 jcamins      That's...
15:51 jcamins      Well.
15:49 jcamins      drojf: right, thanks.
15:49 drojf        jcamins: sound important?
15:47 jcamins      Uhhh... does stemming *do* anything?
15:47 wahanui      bitte jcamins
15:47 jcamins      wahanui: thanks for that.
15:46 wahanui      stemming is off, however
15:46 jcamins      stemming.
15:46 Barrc1       Yes, I know. But it is not the sort (order) that is the problem:
15:46 jcamins      Okay, I still need to test ccl and cql overrides, availability limit, and...
15:46 druthb       jinx, jcamins!
15:46 jcamins      If it's an array, you must have reversed it by accident.
15:46 druthb       If you're dumping a hash, the order of the dumping is pretty arbitrary, as hashes are not ordered.
15:46 jcamins      Barrc1: if it's a hash, there's no implied order.
15:45 Barrc1       Data Dumper
15:44 Barrc1       Ha - just a strange aside - has anyone ever seen Data::Dumper display in reverse! That is, the dataset reads upwards instead of downwards!
15:42 jcamins      44.6%
15:33 druthb       Ooohh... "Evenstar" from the Two Towers soundtrack, just came up in Pandora.  Lovely!
15:33 Barrc1       jcamins: Thanks - maybe I will check it out and sign it off! Else write one myself!
15:28 jcamins      42.8%
15:28 jcamins      Barrc1: not at present. I think there is a bulk biblio update feature that is waiting for signoff.
15:20 Barrc1       Hey all - is there a routine available for writing/updating a specific tag value from the biblioitems marcxml feild? Say, I needed to update the 008 tag. I don't mind taking a crack at it but if there is something already there......
15:19 drojf        you said that ;)
15:19 jcamins      Mostly just dumb.
15:19 drojf        jcamins: you are a brave, brave man
15:18 jcamins      It's awful.
15:18 jcamins      It isn't delicious.
15:18 jcamins      drojf: writing a test for C4::Search.
15:17 drojf        mhh sounds delicious
15:17 druthb       o/
15:16 eythian      drojf: everlasting gobstopper
15:14 drojf        jcamins: what is that slow thing you are doing?
15:12 jcamins      Bah. I need to populate itemtypes.
15:08 jcamins      Thanks.
15:07 eythian      we'll call it 42.15%
15:06 jcamins      Oh, I already said that.
15:06 jcamins      42.1%
15:03 eythian      that's not so bad
15:03 eythian      ah no, 3.6
15:03 eythian      oh no, this client is still on 3.2
15:02 eythian      ah right. Wasn't fixed in the staff client apparently.
15:02 jcamins      eythian: that bug used to be an issue in the OPAC, but it was fixed.
15:01 jcamins      42.1%
15:01 tcohen       but couldnt find a list of the available macros
15:01 tcohen       i'd like to add the staff member cardnumber for example
15:00 tcohen       nengard, is there a list of expresions/macros that can be used when defining slips?
14:37 jcamins      32.7%
14:33 jcamins      Ah, good call.
14:32 eythian      could be a cached error
14:32 jcamins      I'll restart nginx.
14:32 jcamins      It works when I access Apache directly.
14:32 eythian      quitter
14:31 oleonard     quit
14:31 * oleonard   will be back later
14:31 eythian      that seems unexpected
14:31 jcamins      That's what I got when I changed QueryAutoTruncate to true.
14:30 jcamins      "Bad gateway"
14:30 jcamins      Whoah.
14:28 eythian      jcamins needs a progress bar
14:28 jcamins      31.4%
14:27 eythian      processed stuff is generally fine
14:27 eythian      Chocolate is OK
14:27 kf           I brought lots of chocolate
14:27 kf           but if you declare it seemed ok
14:27 tcohen       goot to know!
14:27 eythian      NZ is extremely picky about those sorts of things.
14:27 tcohen       oh, i'll let my fellow know
14:26 tcohen       the worst scenario would be dumping them i guess
14:26 eythian      Make sure that they're declared, otherwise it'd be a nasty fine should they find them otherwise.
14:26 tcohen       i think we're gonna try
14:26 eythian      tcohen: I don't know that alfajor would be allowed into the country.
14:23 wahanui      actually are you going to be the system administrator for this system?
14:23 jcamins      yes, actually.
14:23 jcamins      kf: well...
14:22 kf           jcamins: by accident?
14:22 jcamins      I just managed to get QueryWeightFields working.
14:22 eythian      Poor Damon.
14:22 jcamins      Oh-ho!
14:22 kf           and it's unhappy
14:22 kf           there is also a bus driven by damons apparently
14:21 jcamins      Meaning that we don't actually modify the relevance ranking with our stupid relevancy transformation.
14:20 oleonard     Meaning Zebra always, or never ranks search results by relevance?
14:19 jcamins      Not a blessed thing.
14:19 eythian      http://en.wikipedia.org/wiki/Guru_Meditation
14:19 jcamins      Nothing at all.
14:19 eythian      kf: those who don't study historical error messages are doomed to repeat them.
14:19 jcamins      Did anyone know that QueryWeightFields doesn't do anything?
14:19 jcamins      Hey, this is weird.
14:19 drojf        hi #koha
14:19 kf           including a little picture of a meditating guru
14:18 kf           sorry... that was the error virtualbox is showing
14:18 oleonard     http://www.youtube.com/watch?v=MRewcZXEMb8
14:17 kf           guru meditation???
14:12 oleonard     ...and/or TV shows shot in the 60's set in the 23rd century featuring space hippies.
14:11 eythian      If movies set in/from the 60's or so have taught me anything...
14:10 eythian      squares are serious
14:08 kf           that looks square, not really serious
14:07 oleonard     |:-|
14:07 * oleonard   promises to get serious
14:06 kf           you _are_ on a roll today
14:06 kf           heh
14:06 oleonard     I wonder if git called him back?
14:05 huginn       gmcharlt: Quote #208: "<mtompset> Tonight... I tango with git." (added by jcamins at 03:01 PM, June 28, 2012)
14:05 gmcharlt     @quote random
13:59 pastebot     "jcamins" at pasted "25 tests, 21 of them new" (89 lines) at http://paste.koha-community.org/108
13:54 tcohen       http://en.wikipedia.org/wiki/Alfajor
13:54 kf           wahanui++
13:52 wahanui      they are still working on it...
13:52 eythian      what are they?
13:52 tcohen       i think i'll send some alfajores for our Koha frineds
13:52 eythian      I'll be back there in about 5 or so weeks.
13:52 eythian      cool
13:48 tcohen       oh, a sysadmin here at UNC is announcing is going to NZ to work with some friends in a few months!
13:46 jcamins      27mb.
13:46 jcamins      Alas, it's rather a large patch...
13:46 kf           fast and feature packed... ubuntu makes your pc a delight to use.
13:46 jcamins      tcohen: writing tests for C4::Search.
13:44 tcohen       nengard: i'll check that bug, thanks
13:44 tcohen       what are you working on jcamins?
13:41 jcamins      Because I was only checking the "C4::Context" syspref.
13:41 tcohen       if we had metagroups we could set defaults for each group, and have specific rules for a few that differ a bit
13:41 jcamins      Ah-ha.
13:40 tcohen       we have at least 12 patron types which could be grouped in 3 metagroups that are pretty similar in circ rules
13:40 tweetbot`    [off] twitter: @ByWaterSolution: "Open Source = Less Risk http://t.co/sJKbDGTX #kohails"
13:40 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6685 enhancement, P5 - low, ---, kyle.m.hall, NEW , circ rules by groups of items
13:40 nengard      tcohen - i was wrong - I did one for groups of items : bug 6685
13:39 nengard      i know some of our partners have asked for it in the past
13:39 nengard      tcohen i think i have an enhancement request with that idea
13:37 jcamins      Why is coverage still at 30%?
13:37 tcohen       we had our own when we migrated from ISIS to Koha 3.0.6
13:37 tcohen       we are live with 3.8 now, and still need to adapt circ rules to the suspension in days implementation
13:36 tcohen       hehe
13:35 jcamins      tcohen: I'm writing tests for C4::Search, so I understand you. :P
13:35 tcohen       jcamins: i realized i volunteer for things, but pathologically came back to implement indexing queue stuff hahaha
13:33 tcohen       jcamins: i'd like to, but i still have to work on prioritizing cover images
13:32 kf           aren't our circ rules complicated enough yet? :)
13:31 kf           metagroups for patron types?
13:31 tcohen       hahaha
13:31 kf           hm
13:31 jcamins      tcohen: there has been discussion of how great it would be, but you're the first to volunteer. :)
13:31 oleonard     tcohen: Many people, but no one has done the work to make it happen.
13:31 tcohen       has anyone thought on having sort of 'groups' of patrontypes for setting circ and fines rules?
13:30 kf           oleonard++
13:29 jcamins      lol
13:29 nengard      oleonard is on a roll today
13:29 nengard      oh my
13:29 kf           lol
13:29 oleonard     jcamins: You got to the part in C4::Search where Bambi's mom dies?
13:27 jcamins      We have reached the depressing part.
13:27 jcamins      30%
13:26 nengard      OH NO!
13:22 oleonard     Here we thought Koha was a gift, turns out it's just a time-sink!
13:22 oleonard     Google Translate says "Koha" is Estonian for "Time"
13:21 oleonard     Gmail says "Koha" is Armenian for "Time"
13:21 * nengard    was up at 3am today to get bengard to the airport
13:20 nengard      Gmail must be tired today like me :)
13:20 nengard      LOL
13:20 oleonard     nengard: GMail offered to translate your email into English from Armenian.
13:20 nengard      did gmail tell you that? or did my email have something in it that made that happen?
13:20 nengard      oleonard huh?
13:18 kf           eythian: stop procrastinating!
13:18 jcamins      oleonard: I was wondering that too.
13:18 eythian      good work, it'll act like a silencer.
13:18 * kf         gets a pillow in between
13:18 jcamins      Testing C4::Search is like shooting yourself in the arm with a nail gun every fifteen seconds.
13:18 * jcamins    sighs, bangs his head on the desk.
13:17 eythian      American, Armenian. Easy mistake to make :)
13:15 * oleonard   wonders why GMail thought that message from nengard was in Armenian
13:14 nengard      but now everyone knows :)
13:14 nengard      sorry to ignore you the first time
13:14 nengard      jcamins++
13:14 nengard      Thank you Jared
13:13 nengard      oh okay :)
13:13 jcamins      I responded on the list as well.
13:13 nengard      :)
13:13 nengard      obviously
13:13 nengard      I asked you what? and I logged out before I saw an answer
13:12 jcamins      nengard: you asked me that yesterday and I answered it.
13:00 kf           jcamins++
13:00 tcohen       hi #koha
12:46 jcamins      A lot of hard work?
12:45 kf           oh, cool. how?
12:38 jcamins      Statement coverage in C4::Search is up to 29.4%
12:33 oleonard     Hi #koha
12:21 mib_y0sjgk   Thanks!!
12:21 jcamins      Good luck to you.
12:21 jcamins      Wow.
12:21 mib_y0sjgk   I know - I can't - it's complicated!
12:21 jcamins      You should upgrade to 3.6.
12:21 jcamins      Wow.
12:21 jcamins      Uhhh...
12:20 mib_y0sjgk   3.05.01 (dev version) we got stuck with a good while back at this stage
12:18 jcamins      What version?
12:18 mib_y0sjgk   yep, for a newer install I would. However, this is an older version of Koha I am migrating, all the dependencies came down fine from apt store
12:16 wahanui      i guess packages is at http://wiki.koha-community.org/wiki/Debian
12:16 jcamins      packages?
12:16 jcamins      Actually, what you should really be doing is using the packages.
12:15 mib_y0sjgk   touche!
12:15 jcamins      Is it working as you expected?
12:14 mib_y0sjgk   Not sure about the moving folders though, as long as dependencies are exact I can't see any problem (not to say there isn't any though!)
12:14 jcamins      Go through the installation process, point it to our existing database.
12:14 jcamins      If you don't want to upgrade to the latest stable version (and you should), at the very least you should install the same version.
12:14 mib_y0sjgk   True about the "... sounds weird" !
12:13 jcamins      When you run into problems like this, all anyone can say is "that sounds weird."
12:13 jcamins      Because you ran the installer in one environment, and are now using the files in another environment.
12:12 mib_y0sjgk   why so?
12:12 jcamins      Copying /usr/share/koha yourself is considered a spectacularly bad idea.
12:11 jcamins      I have no idea.
12:11 mib_y0sjgk   which part doesn't match?
12:11 mib_y0sjgk   jcamins: So, I moved the /usr/share/koha/* folder from the old server to the new one, load the old koha database to the new, copy the /etc/koha/* folder to the new.......
12:10 jcamins      It is upgrading tables because the code does not match.
12:10 jcamins      You need to go through the installer.
12:10 mib_y0sjgk   I did, at first, but I noticed it upgrading tables. So I reloaded the db dump and it appeared again
12:09 jcamins      *the new system
12:09 jcamins      (since moving to a new system)
12:09 jcamins      That is very odd. Did you actually go through the installer?
12:08 mib_y0sjgk   but /etc/koha/* too for config etc
12:08 mib_y0sjgk   yes, my mistake. I did mean /usr/share/koha/*
12:08 jcamins      /usr/share/koha/*
12:08 wahanui      source code is at git.koha-community.org
12:08 jcamins      Source code.
12:07 mib_y0sjgk   Right, however. How can it tell the code is newer. I copied the /etc/koha/* folder from the older server to the new one. So the old code should be (is) there now
12:06 jcamins      Yes.
12:06 mib_y0sjgk   But then it will update the database, won't it!?
12:05 jcamins      mib_y0sjgk: did you run through the web installer? It shows up when you have code that is newer than your database.
12:02 mib_y0sjgk   Is there a file somewhere (that I am missing) that has a value set to keep showing the web installer/maintenace page?
12:01 mib_y0sjgk   I have loaded the database from the original Koha server, the OpacMaintenance syspref is set to 0 and the source folder structure has been copied over....
12:00 mib_y0sjgk   anyone know why, when trying to move Koha to a new server, I am getting the "Down for Maintenance" page on OPAC and the web installer on the STAFF?
11:53 nengard      anyone know what reserves.constrainttype is? It has an 'o' or an 'a' in my database
11:50 * mveron     ...is back in office.
11:38 jcamins      I was running the test from the wrong directory.
11:36 jcamins_away Yay! I figured out how to get coverage from Search.t!
11:28 kf           back
10:33 * magnuse    too
10:30 kf           lunch too
10:24 * eythian    <- lunch
10:23 eythian      I can't remember if anything depends on 'letter', if it does you'll have to follow the trail and drop all the appropriate tables.
10:22 eythian      then attempt the reload again.
10:22 eythian      'DROP letter;'
10:22 ala_3vo      eythian: I'm lost with the instructions.
10:21 eythian      ok, now continue with the instructions.
10:20 ala_3vo      yes I have that mysql>
10:20 eythian      ok. In that case, sudo koha-mysql koha
10:19 ala_3vo      I'm sorry the only sites available is koha. It should be koha_koha
10:19 eythian      the second time you were using koha_koha
10:18 eythian      ala_3vo: you're doing something wrong somewhere, because the first time you were using koha_siche
10:17 ala_3vo      user is koha_koha
10:17 ala_3vo      mysql -u koha_koha -p koha_koha < 20120730.sql
10:16 ala_3vo      mysql -u koha_koha -p koh_koha < 20120730.sql
10:15 eythian      actually, how are you doing the restore? I bet they're exactly the same as that.
10:15 eythian      where user, password and database are the ones for your koha database.
10:15 eythian      Oh well, you can do the same by using: mysql -uuser -ppassword database
10:14 eythian      really? That doesn't make a whole lot of sense to me.
10:13 ala_3vo      same message when "sudo koha-mysql siche"
10:13 mib_l6ceu8   kf: Agreed.  Time is against me at the moment though.
10:13 eythian      then do that. It's important to follow instructions correctly, or things won't work.
10:12 ala_3vo      no
10:12 eythian      ala_3vo: did you type 'sudo koha-mysql siche'?
10:12 ala_3vo      koha-mysql siche
10:12 kf           so with git you can get the same version again, but maybe long term you should consider updating and fixing your customizations
10:12 eythian      ala_3vo: what did you type to get that?
10:12 ala_3vo      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
10:12 eythian      mib_l6ceu8: well if you've customised it, and the customisations are in git, then it shouldn't be hard.
10:12 ala_3vo      eythian: the last line states:
10:11 mib_l6ceu8   I had just forgotten!
10:11 mib_l6ceu8   git
10:11 kf           so how did you download it the first time?
10:10 mib_l6ceu8   I would love to, honestly. But this version is almost a fork (I have customised it so much for the customer) that it is beyond upgrading.....
10:10 kf           mib_l6ceu8: yes :) that was the next stable release after 3.5 - uneven is development, even numbers are stable
10:10 ala_3vo      okay, I'll try tha
10:10 eythian      mib_l6ceu8: I would seriously consider the upgrade.
10:10 mib_l6ceu8   kf: me?
10:09 eythian      ala_3vo: use "sudo koha-mysql siche" to get access to mysql, then 'DROP letter;' to delete the table.
10:09 kf           you could consider and update to a recent stable version of 3.6
10:09 mib_l6ceu8   ah, yes - that would make sense!
10:09 eythian      (which is what that is)
10:09 eythian      I don't think we make tarballs of development releases.
10:09 eythian      mib_l6ceu8: it's not a git checkout, is it?
10:09 mib_l6ceu8   I must have downloaded it from somewhere!?
10:08 ala_3vo      eythian: how do I do that?
10:08 mib_l6ceu8   eythian: That may be the case, but I have it in production for about 18 months!
10:08 eythian      ala_3vo: you didn't drop the letter table
10:08 ala_3vo      ERROR 1005 (HY000) at line 3309: Can't create table 'koha_koha.letter' (errno: 150) r
10:08 ala_3vo      Here's the error again
10:08 eythian      there's not really such a thing as 3.05
10:07 mib_l6ceu8   Does anyone know where I can download Koha version ? I need to move server and the source server version is this but it isn't listed on the koha download site?
10:03 ala_3vo      give me sometime
10:03 ala_3vo      let me try an restore again
10:03 eythian      (actually, I'd drop everything, but that's not all that easy unfortunately.)
10:02 eythian      I would drop the letters table manually and try the restore again.
10:02 eythian      OK, that's the issue. There's something funny about the letters table.
10:01 ala_3vo      before mysql restore
10:01 ala_3vo      yes, I went through that
10:00 eythian      ala_3vo: and after doing that, did you run the web installer before you attempted to restore the mysql file?
09:59 ala_3vo      I have just install a new koha
09:59 magnuse      kf: it will be ok, i think...
09:59 eythian      ala_3vo: what is in the database before you do the restore?
09:59 kf           magnuse: hope you sleep well after all this talk about zombies...
09:58 ala_3vo      ERROR 1005 (HY000) at line 3318: Can't create table 'koha_siche.letter' (errno: 150)
09:58 ala_3vo      the error message is
09:57 ala_3vo      I had an error message when trying to restore mysql file
09:56 ala_3vo      Hello #koha
09:48 magnuse      kf: yup
09:48 kf           magnuse: hiding out in the woods again? :)
09:47 * magnuse    is on mobile not-so-broad-band today...
09:45 eythian      http://youtu.be/S6vnM9I7HIo <-- magnuse, on the subject of zombies...
08:56 magnuse      the same folks have made couple of other great flix too: Kill Buljo http://www.imdb.com/title/tt0913401/ and Tomme tønner http://www.imdb.com/title/tt1553935/ (the followup to the last one was shite, though)
08:54 magnuse      eythian: gah!
08:54 ibeardslee   http://www.imdb.com/title/tt1034314/
08:53 eythian      magnuse: way ahead of you ;)
08:52 magnuse      http://www.imdb.com/title/tt1278340/
08:52 eythian      *Snø
08:51 eythian      However it was Død Snøw I was talking about.
08:51 magnuse      in norway we have nazi zombies
08:51 rangi        finnish movie
08:51 eythian      well, I suppose it could be both...
08:51 ibeardslee   Iron Sky .. yes it was a good bit of a laugh
08:51 rangi        and they made it into a movie
08:51 eythian      rangi: it's a movie, not a conspiracy theory :)
08:50 rangi        after the war they built a base on the darkside of the moon
08:50 eythian      ibeardslee: I saw that movie when I was in London. It's good fun.
08:50 eythian      No, the ones that were chased into the mountains and came back when the cursed gold was touched.
08:50 rangi        kf: there is a conspiracy theory
08:49 kf           ?
08:49 ibeardslee   nazis from the dark side of the moon?
08:48 eythian      Also the reanimated Nazis looking for their gold.
08:47 magnuse      :-)
08:46 rangi        heh specially the finns, you can ask the russians about that
08:45 magnuse      we are a tough lot to get along with...
08:44 tweetbot`    [off] twitter: @mikromarc: "The Bibits AS Daily is out! http://t.co/Ys8A4TGL ▸ Top stories today via @kohails @toremor"
08:44 magnuse      ah yes, forgot about that one
08:43 rangi        http://www.kb.se/english/about/news/No-deal-with-OCLC/
08:43 rangi        yeah sweden
08:42 magnuse      oh?
08:38 rangi        oclc have been not having much luck in scandanavia lately
08:38 magnuse      hehe
08:38 eythian      I'm sure they can still find someone to argue with :)
08:37 magnuse      i did a blog post saying drop oclc, use free software. then there is noone to argue with and no lawyers :-)
08:36 magnuse      hehe
08:36 rangi        thats code for, we argued for 2 years
08:36 magnuse      yeah
08:36 rangi        took nearly 2 years
08:35 magnuse      "differences in timing and interpretation of what the solution would entail for BIBSYS, as a system integrator"
08:35 magnuse      they are in a hurry to find a new "search/end user tool", it seems
08:34 rangi        looks like they blew the budget
08:34 rangi        hmm
08:33 rangi        ah yep
08:33 magnuse      there is an english bit in italics
08:32 magnuse      http://www.bibsys.no/norsk/nyheter/readMore.php?id=276
08:32 magnuse      i have not heard a lot of detail yet
08:31 wahanui      i heard interesting was sometimes good and sometimes bad
08:31 rangi        interesting
08:31 rangi        ohh
08:31 eythian      Did they say why?
08:31 eythian      I didn't.
08:30 magnuse      did you guys hear bibsys and oclc decided not to go ahead with their deal?
08:27 magnuse      kia ora eythian
08:26 eythian      hello magnuse
08:25 magnuse      hiya rangi
08:25 magnuse      lucky eythian :-)
08:25 rangi        hi magnuse
08:25 rangi        we can deputise kf as honorary nzer then
08:25 * magnuse    waves
08:25 rangi        :)
08:25 eythian      though, I could phone it in (literally)
08:25 eythian      I shall be at YAPC::EU then, all going well :)
08:25 kf           he probably can't
08:25 kf           ah no wednesday
08:25 kf           thursday I think
08:24 rangi        yep the 22nd
08:24 rangi        next week i think?
08:24 eythian      Ah right.
08:24 eythian      Oh, when's that?
08:24 rangi        its on at 3am here
08:24 rangi        eythian: you'll have to represent nz at the kohacon13 meeting
08:21 eythian      The packaging one seems to be RPM focussed, alas.
08:21 eythian      yeah
08:20 kf           there is also plack, moose, moo...
08:20 kf           looks like lots of talks could be relevant
08:19 rangi        oh yep
08:19 eythian      http://act.yapc.eu/ye2012/talk/4174 <-- ohh very relevant
08:16 rangi        fredericd++ # po files updated
07:44 mbalmer      I am a bit swamped in work, these days, it seems ;)
07:43 mbalmer      I marc, completely forgot about the age restrictions, sorry...
07:40 mveron       Good morning #koha
07:40 rangi        cool
07:40 eythian      yay, just got approval to go to YAPC::EU
07:33 kf           it's still weird :) good morning and good evening
07:33 eythian      hi kf
07:33 rangi        or morning
07:33 rangi        evening kf
07:32 wahanui      niihau, eythian
07:32 eythian      howdy
07:32 rangi        hi eythian
05:42 wajasu       i'm toast. this will have to wait for a new day.
05:41 wajasu       ooh mama. found it.  i got its spitting out  $0.00   yeah.
05:36 cait         wajasu: and I think rental charges and such would not be printed maybe, should be a real fine generated by the overdue notices job
05:35 cait         did you run first the fine job and then the overdues job in your testing?
05:35 cait         another question
05:35 cait         but it shows as paid
05:35 cait         no, when you write it off, it's gone
05:12 wajasu       do fines get reconciled in a bactch job? i checked in a book for patron, wrote off the payemnt and when i log in, he still has the same amount due.
05:04 wajasu       i'm adding another overdue with a fine so i can see if multiple rows come out.
05:03 wajasu       bugzilla.  your right.  well if i get multiple amount without summing, that would  be decent.
05:03 cait         and it's probably only for the overdue message sent as attachement, sould be hard to reach that limit for a single borrower
05:02 cait         I remember it's quite old - did you see it in the code or on bugzilla?
05:02 cait         I think that got fixed
04:56 wajasu       one bug said there is a 64K limit, so after that, those notices are lost.
04:55 wajasu       i wish we could reuse template tooolkit for this.
04:55 wajasu       i see a few patches, and other bugs i see int he code that have new bugs.
04:54 cait         so i guess that's why it's broken... but no idea how the new system changed it
04:54 cait         the notices and slips have changed a lot
04:54 wajasu       thx
04:53 cait         sorry, have to get ready for work, brb
04:52 wajasu       you should see those
04:52 cait         the abovelink it the initial commit that introduced the feature
04:52 cait         too much changed perhaps, maybe trakcing down the commits would work
04:52 wajasu       then GetPreparedLetter is called with all that.  But it rereads the DB and gets the original template  <fine>USD</fine>
04:52 cait         sorry, I am lost here
04:51 wajasu       BUT the code in overdue converts to converts to <<item.fine>> after grabbing the USD, and formats/pushes a table for each item.
04:50 cait         the <fine> syntax is the only way I am aware of
04:50 cait         I am not sure about that
04:50 cait         http://git.koha-community.org/gitweb/?p=koha.git;a=commit;h=599887a1855349de6bafe9c1b6ce155ed9be5fb5
04:50 wajasu       i think <fine>USD</fine>  is a OLD way to designate a placemarker, so they massaged it to <<item.fine>>
04:49 cait         maybe the code got messed up?
04:49 wajasu       then later <<item.fine>> is not substituted, and then cleaned up.
04:48 cait         that doesn't make much sense to me
04:48 wajasu       then its becomes <item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<item.fine>></item>
04:48 wajasu       i have <item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <fine>USD</fine></item>
04:47 cait         and it's F or FU?
04:47 cait         and there is an amount on the item I guess?
04:47 wajasu       no amount.
04:46 cait         no amount?
04:46 wajasu       Fine: USD    or  Fine:  EUR
04:46 cait         what is it doing now?
04:45 cait         but we do... so I would be really glad to see it fixed
04:45 cait         I tihnk not a lot of libraries are using fines
04:45 cait         I have never gone there I fear
04:43 wajasu       i am trying to understand the substitution code.  its very db chatty.
04:42 cait         yep
04:42 cait         or it did that... not sure how badly they broke it
04:42 wajasu       "Catcher inthe Rye" by Joe,   Fine: $5.00 \n   "To Kill a zebra" ,bby Frank  Fine: $10.00
04:42 cait         book c, 3.00 EUR
04:42 cait         book b, 1.50 EUR
04:42 cait         book a, 1.50 EUR
04:41 cait         it will not output each single fine, but the total fine for each item
04:41 cait         I am not sure what you mean by multiple lines :(
04:41 cait         that sounds messy
04:40 wajasu       so you remember seeing multiple lines.
04:40 wajasu       i see a default overdue template with  <fine>USD</fine>  in it.  then later remnant non effective code is substituting that for <<item.fine>>  but the GetPreparedLetter requeries for the db letter, so back to <fine>USD</fine>, then cleanup code strips out tags that never got substituted.
04:39 cait         just one line for each item and the respective fine - not sure I understand your question :(
04:38 cait         output all items with fines and the fine on the item, not summing up or something like that
04:38 cait         what it used to do is
04:38 cait         ?
04:37 wajasu       does anyone recall seeing overdue_notices reporting multiple items with a fine?    and possibly accumulating them?
04:17 cait         so leave :)
04:17 cait         heh
04:16 jcamins_away cait: it's not you. It's just late.
04:16 jcamins_away Heh. Funny how I always leave right when cait arrives.
04:10 jcamins      The getRecords cursor functionality is... odd.
04:09 jcamins      Wow.
04:06 wajasu       i'm going to have to break GetPreparedLetter up so I can getLetter, do my overdue processing, and then ProcessLetter.
03:36 jcamins      Well... ugh.
03:35 jcamins      C4::Search is coverage-proof.
03:35 jcamins      Not set_context.
03:34 jcamins      set_context?
03:34 jcamins      Nothing to do with the fork.
03:33 jcamins      Now I'm stuck on the Devel::Cover issue.
03:32 wajasu       http://perldesignpatterns.com/?DaemonProcess
03:32 jcamins      Oh, yeah, I know how to do that.
03:31 wajasu       i remember coding to discern   if child, close parent resources/file descriptors.   if you google how to write daemon.  Also, in that new index server patch from Tamil, it might have perl code to look at.
03:30 jcamins      Nope.
03:29 jcamins      Ooh, maybe that's my problem.
03:29 wajasu       when you fork, in the child, if you close all the stdin,out,err filedescriptors inherited from the parent process, then the child process is not part of the parent process's  process group. and the parent won't block and wait for the child to finish.
03:22 jcamins      It's exec that's causing the problem.
03:21 jcamins      Yeah, that's my analysis, too.
03:20 rangi        most likely the fork, because you are running it in the devel::cover wrapper
03:20 rangi        no idea
03:19 jcamins      It's either because of set_context or the fork.
03:18 pastebot     "jcamins" at pasted "rangi: any ideas?" (40 lines) at http://paste.koha-community.org/107
03:17 jcamins      When I run it with -MDevel::Cover it fails spectacularly.
03:16 jcamins      Uh-oh.
03:06 rangi        yup
03:06 pastebot     "jcamins" at pasted "rangi: it's a start, right?" (8 lines) at http://paste.koha-community.org/106
02:12 schnydszch   how do I make a MARC field-subfield be searchable in advance search. like make MARC field 590a is included in the searching limit (in advance search) of date?
02:05 jcamins      wajasu: yeah, by using -l it didn't start sh, so that worked.
02:04 wajasu       in C we would do an exec, and the child process would know and close the file descriptors inherted from the parent, etc.
02:01 jcamins      The problem is that it doesn't seem to know it's a child process.
02:01 jcamins      Use -l
02:01 jcamins      Figured it out.
02:01 wajasu       so do you have to "wait " for the process to end?  and close/cleanup the process in perl.
02:01 jcamins      Ah-ha!
02:00 jcamins      Right.
02:00 wajasu       then running it writing to a file? then reading the file when it ends?
02:00 jcamins      Now I just want to kill Zebra when the script ends.
02:00 jcamins      I've given up on that.
01:59 wajasu       are you running zebra and trying to read its output from perl?
01:59 jcamins      wajasu: and then use cut to get the process number?
01:59 wajasu       ps -aef | grep zebra
01:58 jcamins      wajasu: yeah, but that requires me identifying the process.
01:57 wajasu       shoot the zebra.
01:56 wajasu       kill -9
01:38 jcamins      I can kill the sh process, but not zebrasrv.
01:33 jcamins      No, still can't.
01:31 jcamins      Oh.
01:30 jcamins      Damn it. Why can't I kill Zebra when the test ends?
01:15 jcamins      I just read in the output file.
01:14 jcamins      I have an alternative idea.
01:14 jcamins      Ooh!
01:13 jcamins      I hate I/O.
01:05 jcamins      select has the worst documentation EVAR.
01:05 jcamins      Wow.
00:58 mtj          all those books on the main page
00:57 mtj          http://catalogue.cmi.univ-mrs.fr/cgi-bin/koha/opac-main.pl looks like its sposed to have one running, too
00:57 mtj          http://koha.mediathequeouestprovence.fr did have a carousel running, but its gone now
00:52 jcamins      I have to sleep before setting the context.
00:52 jcamins      Ah.
00:50 jcamins      set_context doesn't seem to do anything.
00:49 mtj          jcamins, im not sure
00:47 mtj          ok, ill try to catch some BL folk later
00:47 jcamins      Okay... why doesn't this work?
00:47 mtj          hmm, looks to be 3am in france now
00:47 jcamins      mtj: not that I know of.
00:46 wajasu       AND the boss won't let him move the books :(
00:46 mtj          do any biblibre sites have a book-carousel running on them , currently?
00:46 wajasu       my librarian is up in arms because they moved the library to a new site, but the movers didn't place the shelves (with the books) back in the same relative locations.
00:46 mtj          hi #koha
00:45 wahanui      rumour has it somewhat is not the adjective I would use
00:45 jcamins      Somewhat.
00:44 wajasu       more of a style?
00:43 wajasu       I am learning so much.
00:43 wajasu       Oh.
00:43 jcamins      Classifications are not consistent at all.
00:42 wajasu       Yes
00:42 jcamins      No.
00:42 wajasu       i'm leaving you to index.
00:42 wajasu       since my librarian said "we use LOC classification" i det that as the default.  And i just thought, it would be enforcable during dataentry for consistency.  Only because i worked on spine labels.
00:39 jcamins      Well, spine labels maybe.
00:39 jcamins      No.
00:39 wajasu       and does each scheme influence the way labels are printed? spine labels?  callnumbers?
00:39 jcamins      Type of classification scheme used in itemcallnumber is irrelevant.
00:38 jcamins      They can use as many classification schemes as they want.
00:37 wajasu       i guess my question involves whether it is ok for libraries to support multiple classiciation schemes at the same time? should the default be "locked". not changable at biblio import or item add.
00:35 jcamins      You're asking Koha to automatically do something that is inherently non-automatable.
00:34 jcamins      No, nothing to do with Zebra.
00:34 jcamins      You choose which field the itemcallnumber should be pulled from by default.
00:34 wajasu       so negative. zebra's fault.
00:34 jcamins      No.
00:31 wajasu       true, but if i change it during biblio import, wouldn't that mean i want my item and biblio to be in sync?  or is it common for them not to be in sync.
00:30 jcamins      There's a system preference to choose the default classification source.
00:29 jcamins      No.
00:29 wajasu       shouldn't it propogate the biblio import setting for my add item, which would be associated with that biblio?
00:28 wajasu       i recall, that when i z3950 search, i find a record in a popup. then save, and i am on Add MARC Record.  i go to tab 9, change source of classification shelving scheme from Dewey to LOC) hit Save.  Now I am on Add Item page.  But source of classification shelving is Dewey.
00:27 jcamins      sysread is blocking.
00:27 jcamins      Oh, you have an example on your blog.
00:26 jcamins      Which tests do we mock new_dbh?
00:23 jcamins      Huh?
00:22 wajasu       general catlaogin question.  if i z3950 search and import a biblio, saving it, i jump to an add items page.  if i change the field from Dewey Dec  to LOC, in the biblio, could we propogate that to the add items page? or is that not a good idea?
00:13 * jcamins    stabs Perl's IO repeatedly with a spoon.
00:11 jcamins      sysopen only works on files.
00:10 rangi        http://www.perlfect.com/articles/select.shtml
00:10 rangi        you can monkey with select() too
00:09 jcamins      Which is opposite.
00:09 jcamins      sysopen
00:09 jcamins      Now. How do I not block on the read.
00:08 jcamins      Good, that's what I have.
00:08 rangi        http://perldoc.perl.org/functions/open.html
00:08 rangi        its the former
00:06 jcamins      I'm seeing documentation that says open(FH, mode, expr) and also documentation that says open(FH, expr, mode)
00:05 jcamins      I'm confused.
00:00 wajasu       i just searched for Letters.pm in bugzilla. so many that I see in the code.  It must be a touchy piece of code for legacy templates, etc.