IRC log for #koha, 2012-08-15

All times shown according to UTC.

Time S 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 Irma joined #koha
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.[…]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:09 schnydszch joined #koha
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:12 papa joined #koha
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 cait joined #koha
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:30 schnydszch joined #koha
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/[…]1b6ce155ed9be5fb5
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:05 Irma joined #koha
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.
06:31 mbalmer joined #koha
07:13 Irma1 joined #koha
07:27 eythian joined #koha
07:32 rangi hi eythian
07:32 eythian howdy
07:32 wahanui niihau, eythian
07:32 kf joined #koha
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 mveron joined #koha
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/nyh[…]adMore.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[…]o-deal-with-OCLC/
08:44 magnuse ah yes, forgot about that one
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:36 trea joined #koha
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 mib_oo1lhy joined #koha
09:48 kf magnuse: hiding out in the woods again? :)
09:48 magnuse kf: yup
09:55 ala_3vo joined #koha
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:06 mib_l6ceu8 joined #koha
10:07 ala_3vo joined #koha
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:30 nengard joined #koha
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
11:54 mib_y0sjgk joined #koha
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:31 oleonard joined #koha
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?
12:47 ago43 joined #koha
12:54 Irma joined #koha
12:54 tcohen joined #koha
12:55 Callender joined #koha
12:57 Callender_ joined #koha
12:58 NateC joined #koha
12:59 Callender__ joined #koha
13:00 tcohen hi #koha
13:00 kf jcamins++
13:01 Callender___ joined #koha
13:02 libsysguy joined #koha
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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6685 enhancement, P5 - low, ---, kyle.m.hall, NEW , circ rules by groups of items
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 maximep joined #koha
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:53 nengard left #koha
13:54 kf wahanui++
13:54 tcohen http://en.wikipedia.org/wiki/Alfajor
13:57 Callender joined #koha
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:13 drojf joined #koha
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 wajasu joined #koha
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:35 oleonard joined #koha
14:37 jcamins 32.7%
14:45 mib_y56116 joined #koha
14:48 mao joined #koha
14:53 drojf joined #koha
14:56 jwagner joined #koha
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 rambutan joined #koha
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 joined #koha
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:18 Barrc1 joined #koha
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:29 nengard joined #koha
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:41 NateC left #koha
15:41 NateC joined #koha
15:42 jcamins 44.6%
15:42 rambutan joined #koha
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 adnc_ joined #koha
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 Barrc1 left #koha
16:34 martian523 joined #koha
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:37 melia joined #koha
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/[…]ion-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 cait joined #koha
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 adnc_ joined #koha
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/maintena​nce/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-bi​n/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:48 oleonard joined #koha
17:50 trea joined #koha
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 nengard joined #koha
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:07 adnc_ joined #koha
18:09 Ccorrales joined #koha
18:10 hankbank joined #koha
18:16 oleonard_ joined #koha
18:27 libsysguy joined #koha
18:58 logbot joined #koha
18:58 Topic for #koha is now Koha 3.8.3 and 3.6.7 Now Available | Koha Community Website - http://www.koha-community.org/ | General IRC meeting, 5 September 2012 at 18:00 UTC+0
18:59 jcamins All the hits have Potter in the title. :/
18:59 jcamins salud works, though, actually.
19:00 wizzyrea washington
19:00 rambutan joined #koha
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:03 trea joined #koha
19:04 trea-lunc left #koha
19:22 jcamins Only 7 tests failing.
19:23 ala_3vo joined #koha
19:24 rambutan hey tweetie, is blip.tv down?
19:26 rambutan perhaps I should have made that a declarative statement.
19:31 adnc_ joined #koha
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:47 Callender joined #koha
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 joined #koha
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 Bug http://bugs.koha-community.org[…]w_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 joined #koha
20:19 drojf hello again
20:21 adnc_ joined #koha
20:21 kathryn joined #koha
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:33 rambutan joined #koha
20:37 maximep left #koha
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 Bug http://bugs.koha-community.org[…]w_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 Bug http://bugs.koha-community.org[…]w_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[…]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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8648 normal, P5 - low, ---, jcamins, Needs Signoff , searchResults uses SQL query rather than GetMarcFromKohaField
21:13 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8649 enhancement, P5 - low, ---, jcamins, Needs Signoff , C4::Search needs a unit test
21:21 wajasu bug 8637
21:21 huginn Bug http://bugs.koha-community.org[…]w_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:28 clrh joined #koha
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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8348 critical, P1 - high, ---, koha-bugs, Needs Signoff , useDaysMode syspref does not apply
21:33 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8110 blocker, P1 - high, ---, kyle.m.hall, Signed Off , Add tests for Calendar modules
21:35 drojf joined #koha
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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8253 blocker, P3, ---, kyle.m.hall, Needs Signoff , Fine doubling
22:15 rambutan joined #koha
22:19 cait joined #koha
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 Bug http://bugs.koha-community.org[…]w_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 papa joined #koha
23:04 rgbv joined #koha
23:04 tcohen joined #koha
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/2012Cold case /U10985963Kellerman, 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/w[…]?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.[…]rdue_notices.html
23:10 rangi so its -itemscontent title,date_due,etc
23:17 drojf good night #koha
23:18 rangi cya drojf
23:21 tomas joined #koha
23:22 tomas joined #koha
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:36 BobB_ joined #koha
23:37 ala_3vo joined #koha
23:38 ala_3vo joined #koha
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 Bug http://bugs.koha-community.org[…]w_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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8648 normal, P5 - low, ---, jcamins, Needs Signoff , searchResults uses SQL query rather than GetMarcFromKohaField
23:45 huginn Bug http://bugs.koha-community.org[…]w_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.

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