Time  Nick                  Message
00:30 eythian               I found a place where koha generates a 2MB SQL query. This may be a bug.
00:31 wizzyrea              !!
00:31 eythian               SELECT * from borrowers WHERE (((( ( borrowers.firstname = 'a'  OR borrowers.firstname LIKE 'a%' OR borrowers.firstname LIKE ' a%')  OR  ( borrowers.surname = 'a'  OR borrowers.surname LIKE 'a%' OR borrowers.surname LIKE ' a%')  OR  ( borrowers.email = 'a'  OR borrowers.email LIKE 'a%' OR borrowers.email LIKE ' a%')  OR  ( borrowers.othernames = 'a'  OR borrowers.othernames LIKE 'a%' OR borrowers.othernames LIKE ' a%')  OR  ( borrowers.cardnumber =
00:31 eythian               'a'  OR borrowers.cardnumber LIKE 'a%' OR borrowers.cardnumber LIKE ' a%') ))) OR ((( ( borrowers.branchcode = 'F'  OR  borrowers.branchcode= ''  OR borrowers.branchcode IS NULL OR borrowers.branchcode LIKE 'F%' OR borrowers.branchcode LIKE ' F%') ))) OR ((( ( borrowers.borrowernumber = '1000005445'  OR  borrowers.borrowernumber= ''  OR borrowers.borrowernumber IS NULL) ))) OR ((( ( borrowers.borrowernumber = '1000002562'  OR  borrowers.borrowernumb
00:31 eythian               er= ''  OR borrowers.borrowernumber IS NULL) ))) OR ((( ( borrowers.borrowernumber = '8563'  OR  borrowers.borrowernumber= ''  OR borrowers.borrowernumber IS NULL) ))) OR ((( ( borrowers.borrowernumber = '1000016441'  OR  borrowers.borrowernumber= ''  OR borrowers.borrowernumber IS NULL) ))) OR ....
00:33 eythian               ah, and now I see why it does that.
00:34 eythian               It builds a list of attributes that match the search for 'a' first, and then includes each of those.
00:34 eythian               That's what joins are for.
01:47 rangi                 heya Irma
01:47 rangi                 did space_librarian get hold of you?
01:58 pianohacker           rangi: are you familiar with zebra ccl syntax?
01:59 rangi                 not particularly, hdl and gmcharlt seem to know the most, but i can take a crack
01:59 gmcharlt              ccl is pretty much the easiest of the supported syntaxes
02:17 pianohacker           gmcharlt: supposing you're still around, what's the best way to escape parentheses in ccl terms? putting it in quotes would work, from what I can read of the parser (indexdata--), but is a little hairy
02:18 gmcharlt              pretty sure quotes is it
02:18 pianohacker           bleh, okay. thanks
02:18 rangi                 i thought jcamins or reed had done somthing with quotes before and searching
02:18 pianohacker           rangi: this is related to bug 5369
02:18 huginn                04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5369 normal, P5, ---, jcamins, NEW , se queries with paranthesis fail
02:19 rangi                 ah right
02:19 rangi                 there was one for subjects, or itemtypes or something
02:19 pianohacker           I'm pretty sure I can fix this with some careful =~ s///, but nothing in C4::Search is ever simple
02:22 rangi                 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5693
02:22 huginn                04Bug 5693: normal, PATCH-Sent, ---, reed, RESOLVED FIXED, if parentheses used in ccode then searches against ccode fail
02:38 huginn                New commit(s) kohagit: Bug 6512: time missing from item circulation history <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=fbfb68a444c7f30f363b952a40d00870f0a99295> / Bug 4993 checkpw_ldap - do bind just once <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=322a5ef4819960c5ba5b65ce07150ce873aa6a3d>
02:42 jenkins_koha          Starting build 300 for job Koha_master (previous build: SUCCESS)
02:55 eythian               https://github.com/petdance/vim-perl/tree/master/syntax <-- vim users, tt2.vim and tt2html.vim are handy
02:57 eythian               rangi: "get_template_and_user({template_name => "serials/member-search.tmpl","
02:57 eythian               what's with the .tmp there?
02:57 eythian               *tmpl
02:57 eythian               do they get silently converted to .tt?
02:58 rangi                 yup
02:58 rangi                 some day ill sed them all out
02:58 eythian               cool
03:02 eythian               This: my $branches=defined $$patron{branchcode} ? GetBranchesLoop($$patron{branchcode}) : GetBranchesLoop());
03:02 eythian               is the same as:
03:03 eythian               my $branches=GetBranchesLoop($patron->{branchcode});
03:03 eythian               right?
03:03 eythian               or am I missing something?
03:03 rangi                 no you arent, functionally its the same
03:03 eythian               good.
03:03 rangi                 but the oneliner will warn if $patron->{branchcode} doesnt exist
03:04 eythian               hmm
03:04 eythian               yeah, it will
03:04 eythian               I can still make it cleaner though
03:04 rangi                 yup
03:10 huginn                New commit(s) kohagit: Merge remote-tracking branch 'kc/new/bug_5094' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c6ac6167935e6a9c6d8e1f85b1f721d0303bc136> / Bug 5094 auth_by_bind authentication can fail even if given a correct password and... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7bb178e30be74abda82eb4fcaaa873be3dfcc5ef> / Bug 6512: time missing from item circulation history <http://g
03:22 huginn                New commit(s) kohagit: Bug 6350 : Updating history <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=99a7916b11c0d63ad3c792c7e0213efe4f23e3e9>
03:25 jenkins_koha          Project Koha_master build #300: SUCCESS in 42 mn: http://jenkins.koha-community.org/job/Koha_master/300/
03:25 jenkins_koha          * dpavlin: Bug 4993 checkpw_ldap - do bind just once
03:25 jenkins_koha          * ian.walls: Bug 6512: time missing from item circulation history
03:25 huginn                04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4993 critical, PATCH-Sent, ---, dpavlin, ASSIGNED , ldap search always anonymous when using auth_by_bind
03:25 huginn                04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6512 normal, PATCH-Sent, ---, ian.walls, ASSIGNED , Time missing from Item circulation history table
03:25 jenkins_koha          Starting build 301 for job Koha_master (previous build: SUCCESS)
03:59 Oak                   \o
04:03 Brooke                kia ora
04:03 Oak                   Hello Brooke :)
04:03 Brooke                :)
04:05 Brooke                wait a sec
04:05 Brooke                shouldn't you be uh
04:05 Brooke                on weekend :P
04:05 Oak                   me?
04:05 wahanui               you are Arslan. I am a student doing masters in Library Science (2nd semester). I am a web developer and work in Joomla.
04:05 Brooke                ya you ;)
04:06 Oak                   i work on Saturdays also :-|
04:07 Brooke                ick
04:07 Oak                   it's funny, I was just thinking about taking the day off and do some personal things pending...
04:07 jenkins_koha          Project Koha_master build #301: SUCCESS in 42 mn: http://jenkins.koha-community.org/job/Koha_master/301/
04:07 jenkins_koha          * ian.walls: Bug 6512: time missing from item circulation history
04:07 Brooke                ;)
04:07 jenkins_koha          * JeremyC: Bug 5094  auth_by_bind authentication can fail even if given a correct password and userid
04:07 huginn                04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6512 normal, PATCH-Sent, ---, ian.walls, ASSIGNED , Time missing from Item circulation history table
04:07 jenkins_koha          * Chris Cormack: Bug 6350 : Updating history
04:07 huginn                04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5094 major, PATCH-Sent, ---, gmcharlt, ASSIGNED , auth_by_bind authentication can fail even if given a correct password and userid
04:07 huginn                04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6350 trivial, P5, ---, nengard, NEW , Bug for tracking updates to the history file
04:08 eythian               http://www.youtube.com/watch?v=QH2-TGUlwu4 <-- youtube is trially a new progress bar
04:09 eythian               *trialling
04:09 Oak                   thank you mr. robin, will check this link at once
04:09 Oak                   :)
04:09 eythian               you better
04:09 Brooke                cool
04:09 * Brooke              just tried Mumble in the stead of vent and is hooked.
04:10 * Oak                 sometimes do not understand at all what Brooke says
04:10 Brooke                it's a chat programme
04:10 Brooke                for gaming
04:10 Brooke                so like
04:10 Brooke                it's IRC but voice ;)
04:10 Oak                   aah
04:10 Brooke                and pretty much no one understands me, so you're not alone.
04:11 Oak                   oh good, i feel much better now
04:11 Brooke                I behave when I have to present or Lobby though :)
04:13 Oak                   that must be fun to watch
04:13 Oak                   and listen also
04:13 Brooke                on the lobbying front I am an unexpected shark
04:13 Brooke                presenting varies from pretty boring to not so bad
04:13 Brooke                nasty tendency to read me slides
04:13 Brooke                but that's better than rambling by a little
04:14 Oak                   true dat
04:14 Oak                   (heard you say that yesterday) ;)
04:14 Oak                   true dat
04:14 Brooke                feedback varies depending on the topic
04:14 Brooke                heheh
04:16 Oak                   :) can we see you doing a presentation in any KohaCon videos?
04:16 Oak                   or as a shark?
04:16 Brooke                I'm not in any videos yet
04:16 Oak                   uh oh
04:16 Brooke                and I don't have anyone to Lobby for currently
04:17 Oak                   that sounds funny
04:17 Oak                   oh wait, it is funny
04:18 Brooke                here's the written form of testimony I gave
04:18 Brooke                http://mblc.state.ma.us/mblc/legislative/updates/BWSJohnson.pdf
04:19 Brooke                many, many moons back
04:19 Brooke                I had karate fight night the night before, too
04:19 Brooke                so as I was walking up to the podium
04:19 Brooke                I was praying not to fall
04:19 Brooke                cause if I did
04:19 Brooke                I was so bruised the little mister would have been tossed in gaol.
04:19 Oak                   hehe
04:20 Oak                   little mister?
04:20 wahanui               i think little mister is a die hard Patriots fan.
04:20 Brooke                ha!
04:21 Brooke                wahanui botsnack Gillette Chili Dawg
04:21 wahanui               :)
04:25 Oak                   on page two, Brooke, and wow. you are a writer. excellent writer.
04:25 Brooke                psha
04:26 Brooke                "Can't eat a speech"
04:35 Oak                   Brooke, I'm a fan now. Officially. Sold. If anyone asks, count me in.
04:35 Brooke                heh
04:36 * Brooke              blushes.
04:36 Oak                   :)
04:41 Brooke                just wish I didn't have a block on our history
04:41 Brooke                I felt like it was coming to me yesterday, but it slipped by coz I looked at too many numbers
04:48 Oak                   i googled "Can't eat a speech" and found something... but I totally did not get what you just said. :)
04:48 Oak                   Brooke, you are attending KohaCon this year... right?
04:49 Brooke                I have writer's block on http://wiki.koha-community.org/wiki/History
04:49 Brooke                and I've had it for ages.
04:49 Brooke                Yes, I will be at KohaCon
04:49 Oak                   oh I did not know about that writer's block...
04:50 Oak                   great.. .i was thinking i may never meet Matthew Perry or Audrey Tautou...  but i sure can *try* to be at KohaCon
04:51 * Brooke              nods.
04:51 Brooke                don't miss it when it's so close
04:51 Oak                   and annoy you, cait and druthb as much as i can
04:51 Brooke                it is neigh impossible to annoy druthb
04:52 Oak                   we'll see
04:52 Brooke                I have deliberately tried to get her goat a couple times, and it's been largely to no avail.
04:52 Brooke                >:)
04:53 Oak                   hmm, oh  well, first i should start working on how to get there
04:53 Brooke                Train!
04:55 Oak                   yes, may be. i should check routes. india pakistan are not two friendly neighbors
04:55 Brooke                there's that, but it's cheap.
05:11 Brooke                0/
05:16 Amit_Gupta            good morning koha ;)
05:17 Oak                   Hello Amit_Gupta and pianohacker :)
05:17 pianohacker           hi
05:17 wahanui               bonjour, pianohacker
05:17 pianohacker           hi
05:17 pianohacker           slightly smarter bot than I gave it credit for
05:17 pianohacker           now bed
05:17 pianohacker           bye all
05:18 Brooke                good morning amit
06:04 Amit_Gupta            heya Oak
06:15 alex_a                hello #koha
06:28 mib_sun               hi  #koha
06:40 reiveune              hello
06:42 prawesh               is anybody out there??
06:44 magnuse               yeah, but it's not the most crowded of times, prawesh
06:44 Oak                   i believe there is, in fact many of them
06:45 Oak                   i should confirm from my window though
07:00 julian                hello !
07:00 magnuse               bonjour france
07:03 christophe_c          hello magnuse, & all
07:06 magnuse               bonjour christophe_c
07:07 francharb             hello all
07:07 magnuse               bonjour francharb
07:18 mib_sun               shall I customize the search list format of books? When I am serching for a book the list contain the item type several types. how can I change this??
07:21 cait_mib              hi all
07:25 christophe_c          hi cait_mib
07:27 cait_mib              hi christophe_c
07:30 clrh                  hello
07:30 wahanui               bonjour, clrh
07:33 cait_mib              hi clrh
07:34 clrh                  hi cait_mib
07:43 miguel                good morning, buenos días
07:44 Oak                   so if I register, i can help with translating words for Urdu language http://translate.koha-community.org
07:46 cait_mib              yup
07:46 cait_mib              if you can only do suggest you should ask fredericd for more permissions
07:46 Oak                   ooh hi cait :)
07:46 cait_mib              suggest will make a suggestiong, submit will add it
07:46 Oak                   okay
07:47 cait_mib              suggestions are broken at the moment - I can't accept those for German :(
07:51 prawesh               can some one help me??
07:54 prawesh               i have problem in generating barcode
07:54 cait_mib              what is your problem?
07:54 prawesh               after adding new items in new or old record, the barcode for it are not generated in pdf
07:54 prawesh               but for old items, it is generating the barcode
07:54 cait_mib              hm
07:54 cait_mib              I am sorry, I am not so familiar with the barcode module
07:54 prawesh               ok
07:54 cait_mib              which version are you using?
07:54 cait_mib              you chould check bugzilla.koha-community.org for known bugs and file a new one, or ask on the mailing list
07:55 prawesh               3.00.05.003
07:55 prawesh               i had posted query in the mailing list, but didn't get any reply
07:55 prawesh               i think i will post with details again
07:55 cait_mib              hm your version is quite old, not sure there was a problem
07:56 cait_mib              but if it's a but it's unlikely to be fixed, barcode modue was completely rewritten for 3.2
07:56 prawesh               oh
07:57 prawesh               can i explain what happened??
07:57 prawesh               to you
07:57 prawesh               may be it will help us
07:58 cait_mib              not sure I can help here
07:58 prawesh               ok
07:58 cait_mib              never used the old barcode module, did some tests with the new module
07:58 cait_mib              if you write to the mailnig list again include as many information as possible, version, steps to reproduce
07:58 prawesh               i think i will post it in mailing list again
07:58 prawesh               sure
07:58 prawesh               thank u
07:58 cait_mib              sorry that I don't have a solution for you
07:59 prawesh               no problem
08:02 cait_mib              ok, bye #koha
08:02 Oak                   bye cait_mib
08:03 * magnuse             wonders if it is a good idea to have stuff like jquery and yui below the language specific directories in koha-tmpl/ aren't they identical for all languages?
08:08 Oak                   not related, but an alternative to yui: http://www.blueprintcss.org/
08:09 Oak                   in http://translate.koha-community.org/ur/, when I copy the English string to the edit box, and paste the Urdu word replacing English text, some places of % and s get changed... and look wrong.
08:11 Oak                   and here: http://translate.koha-community.org/ur/34/ur-Arab-pref.po/translate/ looks like the right column is messed up
08:12 Oak                   not working i mean
08:14 hdl                   magnuse: same feeling here.
08:15 hdl                   I even think it could be interesting not to have them embedded but used as external dependencies.
08:17 magnuse               hdl: the submodule discussion?
08:22 magnuse               kia ora paul_p
08:23 paul_p                hello world
08:28 magnuse               paul_p and hdl: do you think it would be a good or a bad if i try to announce another global sign off day (gsod!) on the same day as your "community day" (8th july?)
08:28 magnuse               could we risk "tripping over" each other?
08:29 magnuse               or is it "the more the merrier"?
08:31 magnuse               s/bad/bad idea/
08:35 paul_p                definetly : the more the merrier ! no doubts !
08:44 mib_sun               hello, can some one help me please? I have a doubt in searching catalog.
08:48 mib_sun               shall I customize the search list format of books?
09:01 magnuse               cool, thanks paul_p
12:18 gmcharlt              @quote random
12:18 huginn                gmcharlt: Quote #115: "chris: friends don't let friends use proprietary software." (added by chris_n at 05:36 PM, January 19, 2011)
12:21 JesseM                Nice quote :)
12:30 magnuse               yay!
13:46 fcapo                 Hello, we have a huge slowdown problem on one of our Koha instances. It has ~150000 biblio records and I get 99,8% IO wait every partial rebuild.
13:47 fcapo                 Our client want to have "almost live" record updates, so we must do rebuilds every 5 minutes or so, but that means a huge slowdown every 5 minutes.
13:47 fcapo                 I heard some peoples got Koha instances with a lot more records than that and seems to have no problem. Anybody can share some tips?
13:55 library_systems_guy   fcapo I'm no expert but there are several things I would check
13:55 library_systems_guy   one is to double check and make sure you are only running a partial rebuild
13:56 gmcharlt              fcapo: another step is just to check for general disk I/O problems, and check your RAID settings on the filesystem you're using for zebra's indexes
13:56 library_systems_guy   the other is that you have sufficient hardware (mostly sufficient ram since we are using mysql in koha)
13:56 gmcharlt              e.g., if you're using RAID5 for that filesystem, you don't really need it
13:56 * library_systems_guy agrees with gmcharlt
13:57 gmcharlt              if everything (zebra, mysql, apache) is sitting on one filesystem
13:57 gmcharlt              try separating it
13:57 gmcharlt              if you're using virtualization, check the I/O tuning settings for the hypervisor
13:59 library_systems_guy   gmcharlt, what do you think about fcapo running ps aux to see what exactly is dying when he runs the rebuild
13:59 fcapo                 The rebuilds really are partial (rebuild_zebra.pl -z -b -x) and the RAM seems sufficient (3,5G)
13:59 library_systems_guy   just to see exactly when the load spikes
13:59 gmcharlt              library_systems_guy: sure
13:59 fcapo                 the load spikes at the end of zebraidx's work
13:59 gmcharlt              also strace on the zebraidx
14:01 fcapo                 But checking for genral I/O disk problems seems like a good idea.
14:02 fcapo                 Is it normal to get 98% IO wait when doing partial rebuilds?
14:02 gmcharlt              fcapo: the last step of zebraidx is always slow relative to the rest of the rebuild, but 98% i/o wait is excessive
14:04 library_systems_guy   does anybody have experience setting up OpacSupression
14:05 fcapo                 Ok, thanks a lot for the help. I'll check with my sysadmin if we can find any disk or filesystem problem or misconfiguration.
14:28 rhcl                  Well, heck, it's happening.
14:28 gmcharlt              ?
14:29 rhcl                  Missouri is forming a consortium.
14:29 gmcharlt              cool!
14:29 rhcl                  The committee is ready to pick an ILS, and soliciting preliminary membership interest.
14:31 rhcl                  We got the solicitation notice, the director wanted my input, and I gave it.
14:58 reiveune              bye
15:17 Oak                   \o
15:19 rhcl                  IO
15:27 gmcharlt              EIEIO
15:27 rhcl                  :)
16:03 Oak                   when installing dependencies like: perl -MCPAN -e 'install "LWP::Simple"', does it do this: "Searching for the best CPAN mirrors (please be patient)"   *every* time
16:04 Oak                   i mean should it find 'best mirror' every time? why can't it just pick one and stick with it?
16:24 library_systems_guy   does anybody have experience setting up OpacSupression
19:54 library_systems_guy   so I have a code question.  I'm not very familiar with the innerworkings of Koha yet and I'd like to pull some information from the database and display it on the results page
19:54 library_systems_guy   so I know I'd have to modify the tt page
19:54 library_systems_guy   but where do i make the call to the db?
19:54 nengard               in the matching pl file
19:55 nengard               each tt file has a matching pl file
19:55 library_systems_guy   ahh
19:55 nengard               the pl files are in folders outside of the tmpl folder
19:55 nengard               but template changes mean that when you upgrade you lose your changes
19:56 library_systems_guy   unless i commit them or stash my changes :D
19:56 library_systems_guy   right 0_0
19:56 nengard               right
19:57 nengard               slef around?
19:57 nengard               @later tell slef i just got your message from a day ago about giving me an email address ... but I don't remember what I was asking ... email address for who?
19:57 huginn                nengard: The operation succeeded.
20:24 library_systems_guy   so if i wanted to get started on some more serious development could I talk somebody into giving me tour of the codes physiology
20:38 library_systems_guy   maybe not :'(
20:38 * library_systems_guy just wants to help
22:59 Brooke                kia ora!