Time Nick Message
23:45 huginn chris_n: The current temperature in Erwin, North Carolina is 5.0�C (6:42 PM EST on February 03, 2011). Conditions: Clear. Humidity: 45%. Dew Point: -6.0�C. Windchill: 4.0�C. Pressure: 30.42 in 1030 hPa (Steady).
23:45 chris_n @wunder 28334
23:44 huginn rangi: The current temperature in Wellington, New Zealand is 18.0�C (12:00 PM NZDT on February 04, 2011). Conditions: Partly Cloudy. Humidity: 88%. Dew Point: 16.0�C. Pressure: 29.95 in 1014 hPa (Steady).
23:44 rangi @wunder wellington nz
23:24 huginn jcamins_away: The current temperature in Middle Village, Queens, New York is -0.3�C (6:26 PM EST on February 03, 2011). Conditions: Clear. Humidity: 47%. Dew Point: -10.0�C. Windchill: 0.0�C. Pressure: 30.31 in 1026.3 hPa (Falling).
23:24 jcamins_away @wunder 11375
22:58 rangi thank you
22:57 * chris_n has QA fun for a bit
22:49 rangi presumably its in there somewhere
22:48 rangi yeah i cant find it
22:48 * wizzyrea gets over it
22:48 * wizzyrea gets annoyed
22:47 wizzyrea I see what happened here.
22:47 wizzyrea hrm
22:47 wizzyrea oh I see.
22:47 rangi in there somewhere
22:47 rangi http://git.koha-community.org/gitweb/?p=wip/koha-ptfs.git;a=shortlog;h=refs/heads/Bug3496
22:46 rangi so probably something that needs to be cherry-picked from the old harley git repo
22:46 rangi gotta admire the kids optimism
22:45 rangi I wrote a fines limit override, controlled by granular permission, for PTFS; it should be heading to the patches list fairly soon
22:45 rangi well he did say for ptfs
22:44 huginn 04Bug 3496: enhancement, PATCH-Sent, ---, jwagner, ASSIGNED, Override maximum fine at checkout
22:44 wizzyrea http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3496 but that's a harley thing
22:44 wizzyrea well
22:43 wizzyrea this was the conversation
22:42 wizzyrea http://stats.workbuffer.org/irclog/koha/2009-08-28#i_292455
22:42 wizzyrea lemme see if I can find a bug for it
22:42 wizzyrea i'm looking at the IRC logs
22:42 wizzyrea i'm poking too
22:42 rangi did it have a bug number?
22:42 rangi gmcharlt is at a conference
22:41 rangi ill look
22:41 rangi maybe
22:41 rangi then /limit override
22:41 wizzyrea truf
22:41 rangi git log
22:41 wahanui1 it has been said that gmcharlt is an expert in all things library technology.
22:41 wizzyrea gmcharlt?
22:41 wizzyrea hmm
22:41 rangi pass
22:41 wizzyrea something pianohacker did
22:41 wizzyrea it was wayyyy back in 2009
22:41 wizzyrea rangi did the "fines limit override" ever get into koha?
22:33 rangi local ones dont exist in there
22:33 rangi its because the new preferences relies on a .pref file
22:33 chris_n seems half-baked
22:31 rangi nope thats by design
22:31 chris_n are local sysprefs handled by systempreferences.pl or is that a bug?
22:24 rangi it's true :)
22:16 sijobl and chris couldn't be convinced to recompile it :-)
22:16 sijobl for some reason they'd compiled the ircd with nick length restrictions
22:16 sijobl on the old server
22:15 sijobl ibeardslee: that was a debianism
22:15 * ibeardslee doesn't complain, he now has all his 'e's
22:09 brendan__ yeah that's it ;)
22:09 rangi :)
22:09 brendan__ ____r_a_n_g_i_____
22:09 rangi i suspect its cos your nicks are in use
22:09 _____r_a_n_g_i_______ try typing that right :)
22:09 brendan__ heh - I think it's this new channel being a pain ;)
22:08 rangi its a bywater thing
22:08 rangi heh
22:03 wizzyrea very fashionable
22:03 wizzyrea I'm digging the underscore look
21:59 brendan__ hey thanks :)
21:57 wizzyrea welcome to the new digs ;)
21:56 wizzyrea ___
21:56 wizzyrea hey brendan_
21:55 rangi hi brendan__
21:52 wizzyrea on the messaging
21:52 wizzyrea still*
21:51 wizzyrea oh we stil have the notices and the messaging tab
21:16 oleonard That's it for me, see y'all in 16 hours
21:13 rangi A comment saying works and set it to signed off again would make me spot it
21:12 oleonard Another signoff? A comment saying "works?"
21:12 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5277 minor, PATCH-Sent, ---, mason, ASSIGNED, cant search by barcode in OPAC search-page
21:12 oleonard Okay, for a bug like Bug 5277 which has been pushed for QA, what action is being awaited?
21:11 rangi done
21:11 oleonard wahanui1 is onboard I think
21:11 rangi right will do
21:11 oleonard Sound good to me
21:10 wahanui1 that is, like, a risk you have to take... ;-)
21:10 rangi how about that?
21:10 rangi Pushed for QA
21:10 rangi right
21:10 oleonard that's how I interpreted it before
21:09 rangi shall we leave patch pushed as meaning pushed to master
21:07 rangi no sense being confused if we dont need to be
21:07 rangi 2 secs
21:07 rangi right lemme make a new status then
21:07 oleonard I have to say I keep getting confused by the "patch pushed" status because sometimes it means pushed to a branch, sometimes pushed to master
21:06 oleonard Yes
21:06 rangi that make sense?
21:06 rangi i have to rely on ppl naming their patches right .. and that doesnt always happen
21:05 rangi s
21:05 rangi if i delete the branche
21:05 rangi i can find them easy
21:05 rangi for example
21:05 rangi because they are discovered to have a bug, and we release next week
21:05 rangi so if i ever need to pull commits out
21:05 rangi they are all links
21:05 rangi in the shortlog
21:04 rangi see all the bug names
21:04 rangi http://git.koha-community.org/gitweb/?p=koha.git;a=summary
21:04 rangi the reason i dont is so a can do this
21:04 rangi when they are qa, and moved into a real branch
21:04 rangi the only ones i delete are the needing qa ones
21:04 rangi i do locally, not in the main repo
21:02 oleonard rangi: If you have merged a new/bug_* branch you delete it?
20:56 rangi yeah we need to have a good go at those, plus the ones needing signoff
20:55 * sekjal runs
20:55 oleonard Wow, 139 "patch pushed" bugs still open
20:24 wizzyrea !
20:24 wizzyrea woot
20:24 rangi yay!
20:23 hudsonbot * Christopher Hall: Bug 5462: fixed current preferences tab highlighting bug created by dashfix
20:23 hudsonbot * Christopher Hall: Bug 5462: more dash fixing for variable names within scripts
20:23 hudsonbot * Christopher Hall: Bug 5462: modified intranet scripts to match templates
20:23 hudsonbot * Christopher Hall: Bug 5462: both intranet and opac seem to be 'clean', still need to make relevant changes in scripts
20:23 hudsonbot * Christopher Hall: Bug 5462: fixed incorrect TMPL_IF
20:23 hudsonbot * Christopher Hall: Bug 5462: fixed dashes (replaced with _) and fullstops (removed) for variable names
20:23 hudsonbot Project Koha_Master build #340: SUCCESS in 25 min: http://hudson.koha-community.org/job/Koha_Master/340/
20:02 ibeardslee that's a sad state of society
19:59 wizzyrea they stole 6 computers and all of the networking gear
19:59 wizzyrea we had a library literally cleaned out a month or so ago
19:58 hudsonbot Starting build 340 for job Koha_Master (previous build: FIXED)
19:58 wizzyrea such a bummer
19:58 rangi http://twitter.com/#!/jransom/status/33252548018176000
19:58 wizzyrea yea, foxton?
19:57 rangi that sux
19:57 rangi oh man
19:56 huginn New commit(s) kohagit: Merge branch 'bug_5462_signoff' of git://github.com/colinsc/koha into new/enh/bug_5462 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3b5aa120d71ebc7c3db7fb2177d360df03d5ed35> / Bug 5462: fixed current preferences tab highlighting bug created by dashfix <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0088c5da53a56f44ec435f88a56b67ae99616a4d> / Bug 5462: more dash fixing for variable names
19:49 rangi ahh right
19:46 wizzyrea :) I like that one too
19:46 * mtj favourite comment…. :)
19:46 rangi ?
19:45 mtj yes, but is teh free?
19:45 wizzyrea there we go, comments updated (bad links removed)
19:40 wizzyrea un moment
19:40 wizzyrea oh ya I'll delete or mod that comment
19:39 jwagner Good. Thanks.
19:39 oleonard The HTML structure shouldn't change at all
19:39 jwagner So the codes/divs/whatever we look for might change, but the functionality would be there.
19:38 oleonard jquery is client side, so it doesn't have anything to do with the templating system
19:38 jwagner Speaking of jquery, will it still work with the new templating system?
19:38 wizzyrea backscroll
19:38 wizzyrea oh ya that was before the wiki moved
19:38 jwagner Ya know, I _tried_ that!
19:37 oleonard-away jwagner: Tell 'em it's fine the way it is ;)
19:37 * jwagner is tired of wrestling with jquery :-(
19:29 rangi heya cait
19:29 * cait waves
19:26 rangi back
18:07 tcohen of course. it's liz commenting :-D
18:07 rangi ie, dont use it :)
18:07 rangi its more the text is right
18:07 tcohen right, liz's link is broken but I guess harmless
18:06 rangi ahh liz's comment is good, theone below it eh?
18:04 tcohen http://koha-community.org/download-koha/
18:04 rangi tcohen: url for the comment?
18:00 rangi not sure ill make kohacon this year, so hackfests at ala and access would be good
17:56 druthb yes!
17:56 rangi we should organise evening hackfests for ala too
17:55 druthb (for here.)
17:55 druthb conferece center a short walk from my place--and across the street from the Metro--is 109/129/149 for guest rooms. That's not too shabby.
17:55 rangi cya kf
17:53 druthb see ya, kf.
17:53 kf see you all later
17:53 kf I am the last person in this office - really time to go home
17:52 kf *sighs*
17:52 rangi yep
17:51 druthb :) I'll find a reasonably inexpensive hotel with a meeting room and wi-fi...really, that's about all the setup we'd need, logistically. Local guides, I have and am, and an "un" con is free from too much schedule.
17:50 oleonard atz and I can carpool
17:50 rangi and maybe the osslabs
17:50 rangi and atz
17:50 rangi druthb: be good if could get gmcharlt
17:49 druthb oleonard: I can probably wheedle sekjal into coming down, too....find two more who'd commit, and I'll do it...someplace *cheap*.
17:48 rangi dc has the advantage of everywhere flies there
17:48 oleonard druthb: I would!
17:48 rangi http://www.ted.com/
17:48 rangi gah
17:48 rangi or ignite evenhttp://www.ted.com/
17:48 druthb (only the insane.)
17:48 rangi oh you havent heard of TED?
17:47 * druthb wonders if anyone would come to Kohacamp in DC...
17:47 kf TED?
17:47 rangi or ignite even
17:47 wizzyrea ok, afk
17:47 rangi yep
17:47 wizzyrea a la TED
17:47 rangi then it could be a blueprint for running others
17:46 rangi and document the process
17:46 rangi what would be good, would be for someone to do a kohacamp
17:46 kf yeah, some help with organisational stuff would be good
17:45 kf hehe
17:45 rangi you need a kristina :)
17:45 rangi yeah
17:45 kf or until march, it already is
17:45 kf but march will be crazy
17:44 kf I hoped to organise a workshop this year
17:44 rangi are a good idea
17:44 rangi but i do think regional camps (unconference style)
17:44 * druthb would *hitchhike* if necessary, to get to Konstanz.
17:43 kf hehe
17:43 rangi make everyone in europe come visit you :)
17:43 rangi you are kinda in the middle
17:43 kf per train not really, poland yes
17:43 rangi and poland?
17:43 rangi yeah, is a train feasible?
17:42 kf rangi: in km?
17:41 rangi how far is portugal?
17:41 druthb I'd suggest one at computers in libraries, if I knew anyone was gonna be here besides me and nengard. :P
17:40 rangi take turns hosting :)
17:40 rangi well france isnt that far, nor the uk
17:40 kf rangi: I am all for hackfests - but I am a bit lonely here..
17:40 druthb hackfest_at_ALA++; hackfest_at_Access++
17:40 wizzyrea and have kohacamps
17:40 wizzyrea agreed, we should do things like wp does with the wordcamp
17:40 rangi we should do more regional ones
17:39 rangi hackfests dont have to wait for kohacon
17:39 kf I flew from zürich to nz
17:39 druthb I'm with you on that, wizzyrea.
17:39 kf wizzyrea: only 1 from zürich :)
17:39 rangi kf: i was thinking
17:39 rangi hehe
17:39 rangi i was very greatful schuster picked me and the biblibrans up at the airport
17:39 kf kohacon + 1 month hackfest....
17:39 * wizzyrea would love to take a train for 2 hours to konstantz
17:39 druthb see ya, jcamins!
17:39 jcamins_away Have a good afternoon, #koha
17:39 druthb ended up sending a university van to DFW to pick up a bunch of folks.
17:39 * jcamins_away will leave y'all to plot and plan KohaCon 2012.
17:38 indradg rangi, hey
17:38 kf :)
17:38 kf although I would love it to have you all here
17:38 * druthb held a conference in Abilene, TX once; that was *hard*, as air service there is rare and of low quality.
17:38 rangi if it wasnt so expensive
17:38 rangi id suggest switzerland
17:38 kf Stuttgart is about 2,5 hours by train
17:38 kf Zürich (Sitzerland) is the next airport
17:37 kf not sure Konstanz is good travel wise
17:37 rangi hi indradg
17:37 wizzyrea I know, i mean it's exactly like that :)
17:37 rangi ppl not there cant complain :-)
17:36 rangi next meeting
17:36 rangi its on the agenda
17:36 wizzyrea like forming the next release team before the current one is through :P
17:36 * druthb thinks of locations in the US...some really nice--and inexpensive--places can be had.
17:36 rangi yup, it takes a while to organise
17:35 wizzyrea agreed, we should be working 2 years out I think
17:35 * jcamins recuses himself - no German
17:35 rangi i think that once kohacon11 is decided, people should reall y think about 2012
17:35 jcamins taking_the_afternoon_off_before_I_go_crazier++
17:35 * druthb points at jcamins.
17:35 kf but who is going to organise it?
17:35 kf yeah, you would like that
17:35 druthb see? Already have two supporters!
17:35 jcamins kf++
17:35 jcamins konstanz++
17:35 jcamins :D
17:35 * druthb suggests that kf put in a bid for Konstanz next year.
17:35 rangi kf: bah, try nz .. everyhing is far away from here :)
17:35 kf I still support UK, but don't really see it happening
17:34 rangi if there is a real worry taht every year the most populous nations will win
17:34 kf there are a lot of countries far away from here :P
17:34 rangi or something
17:34 rangi its quite easy to make a rule, cant be the same country within 3 years
17:34 kf and cheaper
17:34 kf I really hope it's getting nearer sometime soon
17:34 * druthb had some potential concerns about India, but those have been dealt with. India will be a serious pain to get to for me, but it's do-able, I think.
17:33 rangi its not like its gonna be india every year
17:33 rangi which is ummm kinda the point
17:33 rangi i think its an overreaction to the fact that lots of ppl in india will vote for it in india
17:32 druthb madness.
17:32 rangi kf: he wants it weighted presumably so that people from some countries votes count for more than others
17:31 jcamins I have put it on my to-do list, for some other time.
17:31 kf I didn't understand all of his mail - what was the part about vote by country not institution?
17:31 jcamins You're right, incidentally. Subquery would be better.
17:30 jcamins I agree.
17:30 kf it has already started and it would be confusing
17:30 kf and I don't think we should change it
17:30 kf no, it's not you
17:29 rangi it might be just me, but i think as mohan didnt show for the meeting, its a bit late to be asking to change the way the voting works
17:28 kf I normally do that, I always confuse the joins
17:28 rangi it might be even easier to do it as a subquery
17:28 rangi thats what a left join does
17:27 kf so one side in both tables can be null?
17:27 rangi or a straight join
17:27 kf probably need a union?
17:27 rangi cool, so ill say no more :)
17:27 druthb rangi++
17:27 jcamins Yes.
17:27 kf ah
17:27 rangi you understand the difference with joins?
17:26 jcamins Ohhh.
17:26 rangi you dont want that
17:26 rangi left join
17:26 jcamins My VM made a lovely keening noise when I tried, though. ;)
17:26 jcamins rangi: I noticed. :(
17:26 rangi oh yeah, that query wont work jcamins
17:26 jcamins (from a particular time period)
17:25 jcamins kf: I'm able to get the sum of fines outstanding, the difficulty is going to be getting the sum of payments PLUS the sum of additional fines.
17:23 kf I have a report fines per borrower somewhere.... would that help something?
17:22 jcamins *accountlines
17:21 jcamins When I take out accoutlines it works.
17:21 jcamins Huh.
17:20 pastebot0 "jcamins" at 208.120.0.116 pasted "Troublesome query" (11 lines) at http://paste.koha-community.org/137
17:19 rangi you just did a select sum() eh?
17:18 rangi heh
17:18 druthb for a suitably-large value of fifteen, yes.
17:18 wizzyrea !
17:18 jcamins Apparently 10+10+10+10+10+15 == 1430.
17:16 druthb Working for an ILS vendor would be a lot more fun, except for these darn squirrely customers. ;-)
17:16 druthb he's having a rough day.
17:15 wizzyrea O.O
17:15 jcamins This was only my third today. :)
17:15 jcamins wizzyrea: yeah, but don't worry.
17:14 wizzyrea uhoh did we just witness jcamins having a meltdown?
17:14 jcamins AAAAAAAAAAAAAAAAAHHHHHHHHHHH!!!!!!!!!!!!!!! Why won't it work?
17:14 jcamins statistics.value is a double.
17:14 jcamins Wait.
17:13 jcamins rangi: any idea how to get a sum of payments from the statistics table?
16:55 huginn druthb: Karma for "jcamins" has been increased 45 times and decreased 1 time for a total karma of 44.
16:55 druthb @karma jcamins
16:49 druthb jcamins++
16:29 rangi :)
16:29 rangi yup, thats what i mean, we should at least attempt to catch that
16:28 fcapo Just hoping none of my users will set an incorrect leader manually when creating new records :P
16:28 rangi might be worth looking at what that contains
16:28 rangi my @warnings = $record->warnings();
16:27 fcapo anyways, thanks for the feedbacks, as a temporary fix, I'll modify my importation scripts so 45 gets forced in leader positions 20 and 21 :P
16:26 rangi so i think we have to fix koha, to not save an invalid leader (for this case at least)
16:26 fcapo true
16:25 rangi converting from one to the other, should not change the values
16:25 rangi it should be roundtrippable and remain the same
16:24 rangi marcxml is a representation of the usmarc in xml
16:24 fcapo Well, marcxml doesn't really need these leader informations anyways. The problem just happens when we return those records as usmarc without changing the leader.
16:18 rangi *nod*
16:18 jcamins rangi: I know. I was using that to point out that Koha will happily save invalid MARCXML.
16:18 rangi most likely letting people save invalid leaders :)
16:18 rangi but it will be somethign we (koha) are doing
16:18 rangi jcamins: naw, its the leader in the marcxml is wrong
16:17 jcamins (and still don't... just as soon as I figure out how to write tests for that sort of thing I will)
16:17 jcamins We haven't had the most strenuous of checks in the past.
16:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5683 critical, PATCH-Sent, ---, jcamins, NEW, link_bibs_to_authorities.pl can corrupt records
16:17 jcamins fcapo: this isn't the problem you were running into, but see bug 5683
16:16 rangi fcapo: the system that should be generating them is koha, zebra is an indexing engine, it shouldnt change values, just index them and return them
16:10 rangi we should fix our marcxml
16:10 rangi thats the problem
16:10 rangi if you send it an invalid record to index
16:10 rangi zebra should not change what you tell it to index
16:10 rangi i dont think its a bug in those
16:03 fcapo I still don't know if it was the ZOOM library or Zebra itself that made the conversion to usmarc. It might be a bug in one of those.
15:54 fcapo Still, I find it strange that when the search results are converted from marcxml to usmarc, these leader values weren't automatically set to 45 since they are supposed to be system-generated...
15:54 fcapo So when I index using rebuild_zebra.pl -x, the marcxml column with the incorrect leader values is sent to zebra, but when the search results are send back to koha, they are converted to usmarc. With the leader now incorrect, invalid marc records are returned.
15:53 fcapo I'll just copy what I tried to say on the old IRC, it will be easier :
15:53 jcamins Interesting.
15:53 jcamins Oh, I see.
15:52 fcapo but the marcxml columns is kept as is
15:51 fcapo because the usmarc record in the marc column of biblioitems seems to always have these leader values set to 45
15:50 fcapo yes
15:50 jcamins fcapo: but the records showed up correctly when you indexed without -x?
15:49 fcapo It should always be 45. any other value seems to make the item not appear correctly in search results when zebra is indexed using marcxml or when using zebraqueue
15:48 fcapo See http://www.itsmarc.com/crs/Bib1486.htm
15:48 fcapo Some of my biblios had 00 at position 20 and 21 of their leader, which made zebra return invalid usmarc records
15:47 fcapo Anyways, to repeat what I trid to say on the old IRC: I think I found what caused my "Some search results appear as 'No title' when Zebra is rebuilt with marcxml" problem I had.
15:45 * oleonard didn't even know it was back up
15:44 wizzyrea :) yep
15:44 fcapo So that's why nobody was responding when I was talking on that other IRC :P
15:44 briceSanc ok, i understand
15:44 wizzyrea so we had no "hands on the ground" when it went down
15:43 wizzyrea the contact we had at the company that was hosting the IRC doesn't work there anymore
15:43 briceSanc what's wrong with the old irc ?
15:43 briceSanc cool, so : hello all !
15:43 wizzyrea yep :)
15:42 briceSanc is it the new irc ?
15:27 jwagner kf, if you have a patron record with overdue fines, I'd like it if you could doublecheck the problem. The code doesn't look to have changed, but my test server setup isn't always reliable on the patron data.
15:20 kf didn't see the discussion aroudn that before
15:20 kf ah ok, reading back now
15:19 jwagner kf, sorry, didn't clean up that bit. I was looking at fines.pl on current head this morning.
15:18 oleonard It must have come to me first
15:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5688 enhancement, P5, ---, oleonard, NEW, OPAC My Summary tab fines column doesn't display accruing fines
15:18 kf jwagner: fines2.pl does not exist in current Koha - sould be fines.pl (reading your bug 5688)
15:14 jcamins I don't see anything.
15:14 jcamins I remember your message, but was there a further response?
15:14 oleonard On the Koha list
15:14 jcamins oleonard: ?
15:13 oleonard So much for my advice not to install Koha 2.2.9 on Windows...
15:03 * wizzyrea had a kudos question for him
15:03 wizzyrea well I can let him do that I guess :)
15:03 wizzyrea oooh cool
15:02 * jcamins comforts wizzyrea... I think sekjal is out demoing Koha today.
14:59 * wizzyrea cries a little
14:59 wizzyrea !! no sekjal!
14:57 jcamins I never thought I'd say this, but... maybe SOLR is a good idea.
14:56 wizzyrea hm no brooke.
14:52 tcohen ahh, zebraqueue stuff
14:51 jcamins But rebuild_zebra only reports indexing 1000 records from the zebraqueue.
14:51 jcamins I'm working with a catalog of 160k.
14:51 jcamins tcohen: I know.
14:48 tcohen jcamins: we have more than 60K in one library here
14:42 jcamins That doesn't seem quite right, somewhow.
14:41 jcamins Does rebuild_zebra not work if you have more than 1000 records to index?
14:38 jcamins 1301Undefined subroutine &MARC::Record::carp called at /usr/share/perl5/MARC/Record.pm line 565.
14:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3319 normal, PATCH-Sent, ---, oleonard, ASSIGNED, Need a nicer error message when attempting to add a patron with no libraries defined
14:32 oleonard Yay, one of my oldest outstanding patches was pushed. Bug 3319
14:31 jcamins Never mind. I got it.
14:26 jcamins Anyone know how to use IN to get all the numbers in a certain range in MySQL?
14:19 jcamins Well, I'll wait and see what happens.
14:19 tcohen (if you're using file per table on mysql, of course)
14:18 tcohen perhaps you can copy the valid registers to a new table, truncate and copy back
14:18 tcohen mm
14:18 jcamins tcohen: my goal is to do exactly that, but I think that particular command is very slow.
14:16 tcohen jcamins: it depends :-D
14:16 jcamins Yes, it is.
14:13 jcamins DELETE FROM biblio WHERE biblionumber<118000 is a bad idea, isn't it?
13:59 tcohen liblime fue comprada por una empresa que se llama PTFS
13:59 tcohen si
13:59 cirbic tcohen: español?
13:59 jcamins No.
13:59 cirbic is that right?
13:59 cirbic that literally says: "Liblime leads the Koha community"
13:58 tcohen cirbic: hola
13:58 cirbic and there´s an official document
13:57 cirbic I live in spain
13:56 jcamins koha.org is not.
13:56 jcamins koha-community.org is the website for the Koha that we all know and love.
13:56 cirbic which is the difference between www.koha-community.org and koha.org?
13:55 cirbic one question
13:55 cirbic hello everyone
13:52 tcohen pfff, wide character... error....
13:43 chris_n bbl
13:42 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5688 enhancement, P5, ---, oleonard, NEW, OPAC My Summary tab fines column doesn't display accruing fines
13:42 jwagner This is a slightly different problem, though. I know (now) what the different accounttypes are, just not why the OPAC won't display them. See new Bug 5688
13:41 jwagner That jwagner is an inquisitive type...
13:41 chris_n brain's not awake yet
13:41 chris_n opp
13:41 chris_n last year
13:41 chris_n here's jwagner at a similar point with accouttypes: http://stats.workbuffer.org/irclog/koha/2009-10-08#i_317863
13:40 chris_n heh...
13:39 jwagner They're definitely hardcoded in the current scripts. I'm not sure of the implications of changing the scripts, though.
13:38 hudsonbot * Chris Cormack: Fixing a syntax error, that snuck in with a merge
13:38 hudsonbot * Owen Leonard: Fix for Bug 3319 - Need error message when adding patron and libraries are defined
13:38 hudsonbot * Fr?d?ric Demians: Bug 3212 Force leader 9 position to 'a' for new biblios
13:38 hudsonbot * Colin Campbell: Bug 5673: test guarantorid consistently
13:38 hudsonbot * Ian Walls: Bug 2341: items marked 'on order' not reserveable from search results
13:38 hudsonbot * Chris Cormack: Bug: 4263 - Repeatable subfields in items
13:38 hudsonbot * Chris Cormack: Bug 4931: Stocking can be by homebranch or holding branch
13:38 hudsonbot Project Koha_3.2.x build #96: SUCCESS in 25 min: http://hudson.koha-community.org/job/Koha_3.2.x/96/
13:37 chris_n here's a bit of conversation which suggests they are hardcoded: http://stats.workbuffer.org/irclog/koha/2009-07-10#i_272959
13:36 chris_n seems it is a bit of lore as to what they all mean
13:36 chris_n here's a bit of discussion about what they account types mean: http://stats.workbuffer.org/irclog/koha/2006-12-03#i_141743
13:34 jwagner I'll go ahead & create a bugzilla entry.
13:34 jwagner not having much luck there, either.... Not my day for good search results.
13:31 chris_n you might search the irc log for discussion on it
13:31 jwagner I couldn't find a bugzilla entry, but bugzilla and I don't seem to get along -- my searching skills don't match its entries :-(
13:30 chris_n it definitely needs a bug if it does not have one
13:30 jwagner I just looked at the code on current head, and it's reading the same way the 2008 message says. A test record with overdues accrued in fines.pl doesn't show that amount on the OPAC screen.
13:29 chris_n a rather complicated mess to sort out iirc
13:29 chris_n I very vaguely remember some discussion about account types and hardcoding a very long time ago
13:26 jwagner Fines aren't displaying in the fines column of the OPAC My Summary page -- they do show on the My Fines tab
13:25 jwagner The problem reported there still seems to be in place, but I can't find a bugzilla entry. Does anyone recognize this one?
13:24 jwagner One of my users found this message from 2008: http://lists.katipo.co.nz/public/koha/2008-March/013387.html
13:17 * druthb puts a big strip of "hooks" on her chair, and a matching piece of "loops" on her fanny.
13:15 * jwagner hands the velcro back to druthb
13:13 oleonard Hi all
13:13 * druthb waves to oleonard.
13:13 hudsonbot Starting build 96 for job Koha_3.2.x (previous build: SUCCESS)
13:10 * druthb goes "harrrumph!"
13:09 jwagner Trying to figure out how to automate the identify nonsense, sigh. Got it working in Chatzilla but can't figure out how to do it in mIRC
13:09 huginn New commit(s) kohagit32: Fixing a syntax error, that snuck in with a merge <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9facc2612104d989e77de932f2a60bc9f3352c5c> / Fix for Bug 3319 - Need error message when adding patron and libraries are defined <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7f9eec6920dc096f82f56b69046866a5ad45243b> / Bug 3212 Force leader 9 position to 'a' for new biblios <http://git.koha-c
13:08 * druthb gets out the Velcro for jwagner.
12:36 druthb They give the appearance of being fairly-commited to not liking vendors and developers much, yes. I don't know if that's their intention, to appear that way, but it certainly doesn't encourage *me* to want to go.
12:34 * chris_n is disappointed to see that KUDOS is looking for proposals from users rather than vendors and/or developers
12:32 huginn druthb: Quote #66: "<paul_p> shame on koha, mySQL & user !" (added by jwagner at 03:39 PM, March 04, 2010)
12:32 druthb @quote random
12:31 huginn gmcharlt: Quote #49: "wizzyrea: KOHAKONG: Stomping all other ILS's" (added by a user that is no longer registered at 04:20 PM, December 22, 2009)
12:31 gmcharlt @quote random
12:01 cirbic nobody can help me?¿
11:20 cirbic I found something in Wikipedia, but I´d like to put something more
11:20 cirbic until now
11:20 cirbic from 1999 when Katipo made the first installation
11:18 cirbic wherer could I find something like that?
11:18 cirbic and I´d like to write something about the development history of KOHA
11:18 cirbic I´m writing the migrating project of our library
11:14 hdl hi cirbic
11:12 cirbic greetings from almeria, spain
11:12 cirbic hello everybody
11:04 kmkale Anyway. Gotta run. Another meeting coming up.
11:03 kmkale IMHO computers are necessary in this day and age period.
11:02 thd kmkale: Computers are necessary for making libraries part of the rest of the computerised culture.
11:02 kmkale thd: 100 yrs plus old libraries running on cardex. Dont know how many books and patrons they have. Forget about finding non popoualr books fast
11:01 thd kmkale: Computers are not essential for basic library services. However, young people the world over ignore anything which is not accessible via computer.
11:00 kmkale But yes this could be a good thing to take up. Funding for public libraries.
10:59 thd kmkale: I have met many students from India an Packistan who were amongst my best customers in my former bookshop. Yet, I may never have met a librarian from India.
10:59 kmkale they are only interested in maintening their fiefdom
10:58 kmkale Typicall the public libraries are managed by trusts run by really old people who think computers are not needed to run a library.
10:57 kmkale how many librarians from India have you come across? And how many of these were from public libraries?
10:57 thd kmkale: You might be able to obtain some business from awakening the blind.
10:57 kmkale our public libraries need to interact with librarians from abrod. They are totally blind as to the possibilities
10:57 thd kmkale: Often the problem is merely knowing whom to ask. There may be other foundations interested in supporting libraries internationally with recycled computers without insisting on proprietary software as part of the gift.
10:55 thd kmkale: The Gates foundation has bought computers for many US libraries even if they come with MS Windows that is better than no computers.
10:54 kmkale thd: true. that will make the M$ tax useful
10:54 thd kmkale: Indian libraries should apply for assistance from the Gates foundation.
10:53 kmkale :) we have lots of wealthy people. problem is they are not benefactors
10:53 thd kmkale: You need wealthier benefactors.
10:53 kmkale but the money is totally inadequate
10:52 kmkale thd: here too
10:52 kmkale s/noghtmare/nightmare/
10:52 thd kmkale: Even in the US, public libraries often rely upon donations from wealthy benefactors to provide computers, buildings, etc.
10:51 kmkale so when we take Koha to them, the catalog is a noghtmare for them ;)
10:51 kmkale no large public libraries can afford to employ properly qualified librarian staff
10:50 thd kmkale: I have seen such a catalogue at a US library once in rural Maine.
10:50 kmkale when I do conversions for Granthalaya.org project, I find the catalog consists of 8 to 10 columns in a register or excel or foxpro or access
10:49 kmkale these software have no concept of standard cataloging.
10:48 kmkale whereever the libraries have done computerization at all, its based on some home grown software ( most probabely foxpro based or ms access at most)
10:47 kmkale large public libraries are so under funded that there is hardly any computerization
10:46 kmkale there are not many large public libraries. Commuting to them is a problem, so people prefer the smaller ones close to home
10:45 kmkale thd: even the large, funded public libraries like mgst.in are fee based
10:45 thd kmkale: Are other public library provisions too insufficient to meet public demand for books?
10:44 kmkale thd: yes. there are small fee based lending library in almost every major housing cluster
10:43 thd kmkale: Home based meaning people with about a thousand books at home setting up a fee based lending library.
10:43 kmkale thd: but if you mean I can take a book home, then yes
10:42 kmkale thd: home based lending meaning books delivered to home? then no
10:42 kmkale thd: the other person I spoke has some very interesting ideas beyond this, but I cant discuss them right now till he launches it
10:42 thd kmkale: Are home based lending libraries common?
10:41 kmkale thd: that is why this project was very interesting to me
10:41 kmkale thd: currently there are no libraries offering delivery services in my area ( at least that I know of)
10:41 thd kmkale: The delivery service attracted my attention. Are delivery services customarily provided by libraries in your area?
10:40 kmkale yay!! my net connection :(
10:36 thd kmkale: The delivery service attracted my attention. Are delivery services customarily provided by libraries in your area?
10:35 thd kmkale: Most library services in the part of the world with which I am familiar are financed by some institution or governmental body. User fees are reserved for special services such as photocopies but never ordinary lending.
10:32 thd kmkale: Subscription libraries are rare in the part of the world with which I am familiar.
10:31 thd kmkale: Well I suppose that is one more reason to see South Asia and discover such differences.
10:30 kmkale thd: every circulating library here charges a monthly fee
10:30 thd kmkale: There is also a delivery service which libraries do not generally do.
10:29 thd kmkale: The idea that there is a fee involved seems very much like the books business to me.
10:28 thd kmkale: Well yes but there is a rental fee.
10:28 kmkale thd: books business? Its a home lending library
10:27 thd kmkale: no but I like the idea of Koha being put to use in the books business.
10:27 kmkale thd: do you know this person?
10:26 kmkale thd: no clue. I have advised him to be a subscriber to Koha mailing lists many times. So far he hasn't
10:25 kmkale cant tell without a photo. Will ask him
10:25 thd kmkale: Will Abhay Kambli be at KohaCon wherever it may be held at least if it is somewhere in South Asia?
10:24 thd kmkale: http://www.spoke.com/info/p8dzjrk/AbhayKambli
10:24 thd kmkale: Maybe the name is common but I found someone of that name with an office in New York.
10:23 kmkale thd: not that I know of. Why?
10:22 thd kmkale: Does Abhay Kambli have an office in the US?
10:19 hudsonbot Chris Cormack: Fixing a syntax error, that snuck in with a merge
10:19 hudsonbot Project Koha_Master build #339: FIXED in 26 min: http://hudson.koha-community.org/job/Koha_Master/339/
10:19 hudsonbot Yippie, build fixed!
10:16 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5670 enhancement, P5, ---, colin.campbell, NEW, Housebound Readers Module
10:16 kmkale bug 5670 is very interesting
10:16 kmkale thd: re personal book delivery services I am working with two independent entrepreneurs from different cities. Both planning to set this up with Koha
10:16 kmkale thd: Sorry, that call led to a full fledged conference call meeting.
10:00 huginn New commit(s) kohagit: Fixing a syntax error, that snuck in with a merge <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e29aca325d199468673365ee7540760b38630833>
09:53 hudsonbot Starting build 339 for job Koha_Master (previous build: FAILURE -- last SUCCESS #337 40 min ago)
09:43 hudsonbot * Owen Leonard: Fix for Bug 3319 - Need error message when adding patron and libraries are defined
09:43 hudsonbot * Fr?d?ric Demians: Bug 3212 Force leader 9 position to 'a' for new biblios
09:43 hudsonbot * Colin Campbell: Bug 5673: test guarantorid consistently
09:43 hudsonbot Project Koha_Master build #338: FAILURE in 3 min 40 sec: http://hudson.koha-community.org/job/Koha_Master/338/
09:40 hudsonbot Starting build 338 for job Koha_Master (previous build: SUCCESS)
09:40 thd kmkale: are you still on telephone?
09:39 hudsonbot Ian Walls: Bug 2341: items marked 'on order' not reserveable from search results
09:39 hudsonbot Project Koha_Master build #337: SUCCESS in 26 min: http://hudson.koha-community.org/job/Koha_Master/337/
09:26 huginn New commit(s) kohagit: Fix for Bug 3319 - Need error message when adding patron and libraries are defined <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e6a3029470501b3a8269986c1448d5f8b2d6b7f2> / Bug 3212 Force leader 9 position to 'a' for new biblios <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f1f36a0c940fa53a5671b379a31d77c2cbe40a7f> / Bug 5673: test guarantorid consistently <http://git.koha-community.org
09:13 kmkale 1 min on call again :(
09:13 hudsonbot Starting build 337 for job Koha_Master (previous build: SUCCESS)
09:12 thd kmkale: Is there much interest in personal delivery services in India?
09:12 kmkale helping him with Koha
09:12 kmkale :) its a young enterprenure's dream project
09:11 thd kmkale: The flash advertisement for the book delivery service seemed very interesting.
09:11 thd kmkale: Your welcome
09:11 kmkale ouch. Will ask the web admin to change it asap. Thanks thd
09:10 kmkale what the hell
09:10 thd kmkale: It is linked from http://www.orientalthane.com/
09:09 kmkale where did you get it?
09:09 kmkale aye thats a WIP
09:08 thd http://59.165.133.196/
09:08 kmkale 1 min on call
09:07 thd s/my webrowser/Iceweasel/
09:07 kmkale which site thd?
09:07 thd kmkale: one thing I noticed is that your category links bring up a blank Open Office spreadsheet in my webroser.
09:06 huginn New commit(s) kohagit: Bug 2341: items marked 'on order' not reserveable from search results <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f692123bf1b2b843d348a897852018caa04de76f>
09:06 kmkale got it. please ask your question..
09:05 thd kmkale: not what the bot said.
09:04 wahanui1 thd is concerned that CCL, Pazpar2, and Zebra support should not be an either that or Solr/Lucene option. We need CCL and Pazpar2 for metasearch and we currently need Zebra for a Z39.50/SRU server.
09:04 kmkale yes thd ?
09:02 thd kmkale: I have a question about what I saw in your Koha installations.
08:13 paul_p for the opacprivacy video
08:13 paul_p nengard++
08:13 Oak \o
08:13 paul_p hello kf & al
08:11 hdl hi all
08:10 kf hi paul_p and hdl
07:26 kf good mornig #koha
07:00 francharb hello all
06:52 thd fredericd: New York would be nice but accommodation is maximally expensive for anyone who does not have a small place with some rent control.
06:51 thd I am very interested in seeing places where library metadata standards and practises are most different from what is familiar to me.
06:50 fredericd New York would be nice also
06:49 thd fredericd: No, eventually every significant place will have a chance to host KohaCon in different years.
06:48 fredericd I'd prefer to go to Nepal...
06:48 fredericd thd: at the same time?
06:48 thd However, as I told nengard yesterday, eventually there will be a KohaCon everywhere.
06:47 thd fredericd: I may favour Kolkata with the National Library.
06:43 fredericd thd: glad to meet you here and soon in Thane...
06:41 kmkale fredericd: yes
06:41 thd Hello fredericd
06:41 fredericd is there accomaodation near the campus?
06:41 kmkale thd: ok
06:41 fredericd hi all
06:41 fredericd interesting...
06:41 thd kmkale: Please try to alter the wiki page listing to include a lower range of prices or some may decide against Thane falsely.
06:39 kmkale Also there is just a administrative boundry between Thane and Mumbai. Its a continuous cityscape so hotel choice is really wide.
06:38 kmkale thd: there are similar hotels in Thane. Closer to the campus than these. Will try to get accommodation organized as per requirements / budgets if we decide on Thane
06:35 thd kmkale: http://www.hostels.com/findabed.php?ChosenCity=Mumbai&ChosenCountry=India&Search=1
06:33 kmkale thd: do share the links you found
06:30 thd I found some of those a few hours ago.
06:30 kmkale & even cheaper Non air conditioned ones. But I wont have you try those ;)
06:29 kmkale thats approx 20USD
06:29 kmkale thd: there are lots of small inns. good clean rooms with air conditioning about 1000/- INR
06:29 thd ?
06:28 thd kmkale: Where do local people without much money stay/
06:28 thd kmkale: I thought that India and Nepal would have the very lowest prices to offset for the higher air fare from the US.
06:27 kmkale thd: the exchange rates work in your favour when you visit us
06:27 kmkale :)
06:27 thd kmkale: A few hours ago I found some prices for Mumbai lower than anywhere except Somerset.
06:27 kmkale Also if you fancy, all the major international 5 / 7 stars in Mumbai are within 15km distance from the college campus
06:26 kmkale but if we do decide on Thane, I intend to visit the better and good ones and set up a booking system
06:25 kmkale Cant find website links
06:25 kmkale There are too many.
06:24 thd kmkale: What about the 'not good' but cheap accommodations in Thane?
06:21 cait hi kmkale
06:21 * kmkale waves at cait
06:07 cait hi all
04:07 Brooke_ <.<
04:07 Brooke_ >.>
04:07 hudsonbot Chris Cormack: Bug: 4263 - Repeatable subfields in items
04:07 hudsonbot Project Koha_Master build #336: SUCCESS in 24 min: http://hudson.koha-community.org/job/Koha_Master/336/
04:06 kmkale wow Brooke_ how did ya know that?
04:06 Brooke_ namaste
04:06 kmkale Namaskar #koha
04:05 kmkale hey Brooke_
04:05 Brooke_ ahoy there kmkale
03:49 Brooke_ if only I knew the mind behind the move!
03:49 Brooke_ tee hee
03:46 rangi http://www.maconch.com/features/x1779421749/Macon-Public-LIbrary-has-new-software-system
03:43 hudsonbot Starting build 336 for job Koha_Master (previous build: SUCCESS)
03:40 Brooke_ okay, fine, it's twitter.
03:39 Brooke_ it's natural.
03:39 Brooke_ soon you'll find a black glove on your hand
03:39 Brooke_ it's part of being a Duhrector
03:38 jransom I can feel my life force being sucked out of me ..... find myself using clipped 1 syllable words now
03:31 * Brooke_ salutes Rangi
03:31 huginn New commit(s) kohagit: Bug: 4263 - Repeatable subfields in items <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=aa398ed055a7226ba02d6559b297cb172b3ce3df>
03:31 rangi hi Brooke_
03:28 mtj jransom: yep, its part of their design spec ;)
03:27 jransom i HATE them
03:27 jransom just told microsoft phone operator that his companies phone maze sucks the life force of me
03:27 Brooke_ http://xkcd.com/850/
03:21 Brooke_ your initials sound like a freeway in California.
03:21 * Brooke_ smiles at the mtj
03:21 mtj heya Brooke_
03:18 Brooke_ kia ora
02:59 huginn rangi: The operation succeeded.
02:59 rangi @later tell chris_n thanks for the fix and signoff
02:10 mtj i think zebra may have p0wnd my brain this arvo
01:59 druthb evenin, #koha.
01:51 thd s/staff/staff\/significant patrons/
01:51 thd gmcharlt: I personally like people with explicitly known affiliations but I understand that people at small libraries do not want to be outvoted by the larger staff of large libraries.
01:50 gmcharlt thd: not surprising; it's I think one of the inherent dichotomies in library OSS projects
01:49 thd gmcharlt: That issue came up again momentarily at the #koha meeting today.
01:49 gmcharlt a more instituion-based model was advocated by some on the EG gov committee
01:48 gmcharlt the SFC treats projects as collections of individuals
01:48 gmcharlt thd: that's still a bit unsettled
01:48 thd ?
01:48 thd gmcharlt: Would institutions be members and also significant contributors who are members of the institution separately/
01:45 thd gmcharlt: I am most interested in how the people vs. institution issue works out for membership, http://evergreen-ils.org/dokuwiki/doku.php?id=governance:structure:draft_rules .
01:43 thd I have been looking at the list in the past few minutes but was not certain which thread is most relevant to the current discussion.
01:42 gmcharlt thd: the app has been approved by the SFC and invitation has been extended; project is in discussions about it; see archives at http://list.georgialibraries.org/pipermail/evergreen-governance-l/ if you're curious
01:42 mtj i need to track down where thats defined :/
01:42 mtj so ?somehow? the zebra config has allowed 'ext' searching on title, but not ccode?
01:41 mtj .
01:41 mtj [114] Unsupported Use attribute -- v2 addinfo '8009'
01:41 mtj Diagnostic message(s) from database:
01:41 thd gmcharlt: when is the next SFC board meeting at which Evergreen might be accepted?
01:41 mtj records returned: 0
01:41 mtj Result Set Status: none
01:40 mtj Number of hits: 0, setno 13
01:40 mtj Search was a bloomin' failure.
01:40 mtj Received SearchResponse.
01:40 mtj Sent searchRequest.
01:40 mtj Z> f @attr 1=8009 @attr 4=1 @attr 6=3 Listening
01:40 mtj but using an 'ext' search on ccode (8009), gives an error...
01:39 mtj 1=4 is title , btw...
01:39 mtj Z> f @attr 1=4 @attr 4=1 @attr 6=3 Listening
01:39 mtj weirder still, i can search OK using 'ext' on a title, in zebra
01:31 chris_n enjoyed a bitof sight seeing at niagara while I was there
01:31 * chris_n was in toronto last year this time
01:30 thd Oh yes, I have not been reading most any mailing lists.
01:29 gmcharlt software freedom conservancy
01:29 thd SFC?
01:28 gmcharlt thd: it's on the back burner; fair amount going on with Evergreen's application to join the SFC
01:27 thd gmcharlt: Have you had favourable interactions with people from GPLS over OpenNCIP?
01:26 hudsonbot Chris Cormack: Bug 4931: Stocking can be by homebranch or holding branch
01:26 hudsonbot Project Koha_Master build #335: SUCCESS in 28 min: http://hudson.koha-community.org/job/Koha_Master/335/
01:26 huginn gmcharlt: The current temperature in Toronto, Ontario is -8.0�C (8:24 PM EST on February 02, 2011). Conditions: Light Snow. Humidity: 73%. Dew Point: -12.0�C. Windchill: -15.0�C. Pressure: 30.12 in 1020 hPa (Rising).
01:26 gmcharlt @wunder toronto, ontario
01:26 huginn gmcharlt: Error: No such location could be found.
01:26 gmcharlt @wunder toronto, on
01:26 huginn gmcharlt: Error: No such location could be found.
01:26 gmcharlt @wunder toronto
01:25 icicle I don't melt, for one
01:25 thd gmcharlt: How does it compare to Florida this time of year?
01:23 gmcharlt Toronto
01:23 thd gmcharlt: what part?
01:23 gmcharlt thd: yep
01:23 thd gmcharlt: Are you in Canada now?
01:19 chris_n ahh... I had a bip-kicking session earlier am
01:19 gmcharlt chris_n: just kicking bip
01:17 chris_n gmcharlt: identity crisis?
01:17 chris_n heya brendan_
00:58 hudsonbot Starting build 335 for job Koha_Master (previous build: SUCCESS)
00:57 mtj i might ask you to look on a BL koha , with your fix running sometime
00:56 mtj right, ok
00:56 hdl since zebra is not forgiving
00:55 hdl problem is to find the correct combination
00:55 hdl mtj: should be either 6=2 or 6=3 with 4=1
00:55 rangi meeting bbiab
00:54 huginn New commit(s) kohagit: Bug 4931: Stocking can be by homebranch or holding branch <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=35b47b6ff71ea2bcfc699ec35132756d01bfadd3>
00:54 hdl mtj: sorry
00:54 mtj hdl: ok cheers, i think ive got enuff info to start debugging my koha
00:54 thd indradg: are you here and awake?
00:47 mtj so my 'ext' mapping isnt correct, i guess
00:47 mtj Elapsed: 0.000354
00:47 mtj [114] Unsupported Use attribute -- v2 addinfo '8009'
00:47 mtj Diagnostic message(s) from database:
00:46 mtj records returned: 0
00:46 mtj Result Set Status: none
00:46 mtj Number of hits: 0, setno 14
00:46 mtj Search was a bloomin' failure.
00:46 mtj Received SearchResponse.
00:46 mtj Sent searchRequest.
00:45 mtj Z> f @attr 1=8009 @attr 6=2 MATAKI
00:45 mtj .
00:45 mtj Z> f @attr 1=8009 @attr 6=1 MATAKI , is successfull
00:45 mtj 6=1 works ok, but 6=2 and 6=3 dont, for me..
00:44 mtj interesting...
00:38 mtj looks more...
00:37 mtj it errors on 6=3 and 6=2 too
00:35 mtj Prefix query error: extra token (code 1)
00:35 mtj ^
00:35 mtj Z> f 1=8009 @attr 6=3 MATAHI
00:35 rangi i see gmcharlt made it to canada
00:32 hdl then search
00:32 hdl base biblios
00:32 hdl you needn't get authenticated
00:32 mtj hdl: sorry, remembering how to auth to zebra , using yazclient... :/
00:31 * chris_n greets gmcharlt
00:27 hdl it is :p
00:27 mtj ok, attr 4=1 was the phr type search, i think?
00:26 hdl without attr 4
00:25 hdl try without f @attr 1=8009 @attr 6=3 MATAHI
00:24 mtj yep
00:24 hdl do you have a yaz-client ?
00:24 hdl you neednt
00:24 mtj i havent reindexed yet tho
00:23 mtj 13:25:08-03/02 zebrasrv(1) [request] Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=8009 @attr 4=1 @attr 6=2 MATAHI
00:23 hdl can you get the error code ?
00:23 mtj ive done that , the query is different now, but still an error
00:16 wahanui hdl: that doesn't look right
00:16 hdl change 6=3 to 6=2 in ccl.properties just for a test
00:15 mtj ./pqf.properties:position.firstAndLast = 3=3 6=3
00:14 mtj ./ccl.properties:ext 4=1 6=3
00:14 mtj ./ccl.properties:complete-field 6=3
00:14 mtj ./ccl.properties:startswithnt 3=1 5=101 6=3
00:14 mtj mason@xen1:~/koha/k3/etc/zebradb$ grep -ir '6=3' ./*
00:14 mtj .
00:13 mtj no mention of '@attr 6=3'
00:13 mtj # Used if completeness is 'complete {sub}field' (@attr 6=2, @attr 6=1)
00:13 mtj # Phrase index
00:12 mtj but default.idx says...
00:12 mtj 13:11:24-03/02 zebrasrv(1) [request] Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=8009 @attr 4=1 @attr 6=3 MATAHI
00:12 mtj hmm, my search with ext is ..
00:11 mtj completeness 1
00:10 mtj index p
00:10 mtj yep
00:09 mtj shall i remove the ccode:w , perhaps?
00:09 hdl grab your default.idx and see whether completeness 1 for p index
00:09 mtj melm 952$8 ccode:w,ccode: p
00:09 mtj melm 952$8 ccode:w,ccode:p
00:08 mtj yes, and yes
00:08 hdl AND reindexed ?
00:08 hdl ?
00:08 hdl do you have edited your record.abs to add ccode:p
00:07 mtj but (mc-CCODE,ext:MATAHI) gives a zebrasrv error
00:07 hdl mtj: still awake
00:07 mtj (mc-CCODE,phr:MATAHI) returns some results..
00:07 mtj hdl: about still?