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