IRC log for #koha, 2011-06-17

All times shown according to UTC.

Time S Nick Message
00:01 Oak joined #koha
00:28 NateC joined #koha
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  ( = 'a'  OR LIKE 'a%' OR 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 samerrill joined #koha
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:04 samerrill1 joined #koha
01:04 samerrill left #koha
01:27 NateC left #koha
01:36 NateC joined #koha
01:37 Soupermanito joined #koha
01:39 NateC left #koha
01:40 Irma joined #koha
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 Bug[…]w_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[…]w_bug.cgi?id=5693
02:22 huginn Bug 5693: normal, PATCH-Sent, ---, reed, RESOLVED FIXED, if parentheses used in ccode then searches against ccode fail
02:28 Oak left #koha
02:38 huginn New commit(s) kohagit: Bug 6512: time missing from item circulation history <[…]a40d00870f0a99295> / Bug 4993 checkpw_ldap - do bind just once <[…]e07150ce873aa6a3d>
02:42 jenkins_koha Starting build 300 for job Koha_master (previous build: SUCCESS)
02:45 atz joined #koha
02:51 Soupermanito left #koha
02:55 eythian[…]ree/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 <[…]5b1f721d0303bc136> / Bug 5094 auth_by_bind authentication can fail even if given a correct password and... <[…]caaa873be3dfcc5ef> / Bug 6512: time missing from item circulation history <http://g
03:22 huginn New commit(s) kohagit: Bug 6350 : Updating history <[…]7e0213efe4f23e3e9>
03:25 jenkins_koha Project Koha_master build #300: SUCCESS in 42 mn: http://jenkins.koha-community.[…]/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 Bug[…]w_bug.cgi?id=4993 critical, PATCH-Sent, ---, dpavlin, ASSIGNED , ldap search always anonymous when using auth_by_bind
03:25 huginn Bug[…]w_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:58 Oak joined #koha
03:59 Oak \o
04:02 Brooke joined #koha
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.[…]/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 Bug[…]w_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 Bug[…]w_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 Bug[…]w_bug.cgi?id=6350 trivial, P5, ---, nengard, NEW , Bug for tracking updates to the history file
04:08 eythian <-- 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:14 pianohacker left #koha
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[…]es/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
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 pianohacker joined #koha
05:11 Brooke 0/
05:16 Amit_Gupta joined #koha
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:17 pianohacker left #koha
05:18 Brooke good morning amit
05:39 Brooke left #koha
06:04 Amit_Gupta heya Oak
06:15 alex_a hello #koha
06:27 mib_sun joined #koha
06:28 mib_sun hi  #koha
06:32 bigbrovar left #koha
06:37 magnus_away is now known as magnuse
06:40 reiveune joined #koha
06:40 reiveune hello
06:40 prawesh joined #koha
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
06:45 Oak left #koha
06:46 Amit_Gupta left #koha
06:53 hdl joined #koha
06:53 clrh joined #koha
06:54 Guillaume joined #koha
06:56 matts_away is now known as matts
06:58 julian joined #koha
07:00 julian hello !
07:00 magnuse bonjour france
07:03 christophe_c hello magnuse, & all
07:04 miguel left #koha
07:06 magnuse bonjour christophe_c
07:06 francharb joined #koha
07:07 francharb hello all
07:07 magnuse bonjour francharb
07:08 miguelxercode joined #koha
07:13 miguel joined #koha
07:17 matts left #koha
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:18 matts joined #koha
07:21 cait_mib joined #koha
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:39 sophie_m joined #koha
07:43 miguel good morning, buenos días
07:43 Oak joined #koha
07:44 miguelxercode left #koha
07:44 Oak so if I register, i can help with translating words for Urdu language
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 for known bugs and file a new one, or ask on the mailing list
07:55 prawesh
07:55 julian left #koha
07:55 prawesh i had posted query in the mailing list, but didn't get any reply
07:55 julian joined #koha
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:02 cait_mib left #koha
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:
08:09 Oak in, 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-communit[…]ref.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:15 prawesh left #koha
08:17 magnuse hdl: the submodule discussion?
08:19 paul_p joined #koha
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:31 magnuse is now known as magnus_bbl
08:33 bigbrovar joined #koha
08:35 paul_p definetly : the more the merrier ! no doubts !
08:38 sophie_m1 joined #koha
08:38 sophie_m left #koha
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?
08:52 sophie_m joined #koha
08:53 sophie_m1 left #koha
08:59 Oak left #koha
09:00 magnus_bbl is now known as magnuse
09:01 magnuse cool, thanks paul_p
09:40 miguel left #koha
09:40 ibeardslee left #koha
09:41 miguel joined #koha
09:41 ibeardslee joined #koha
10:16 matts is now known as matts_away
10:17 LBA left #koha
10:25 mib_sun left #koha
10:27 Irma left #koha
10:58 NateC joined #koha
11:00 NateC left #koha
11:02 miguel left #koha
11:02 miguel joined #koha
11:19 jwagner joined #koha
11:26 nengard joined #koha
11:30 NateC joined #koha
11:44 matts_away is now known as matts
11:45 matts left #koha
11:46 matts joined #koha
11:48 sophie_m left #koha
11:48 sophie_m joined #koha
11:51 collum joined #koha
11:52 paul_p left #koha
12:01 JesseM joined #koha
12:01 samerrill1 left #koha
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!
12:37 magnuse is now known as magnus_away
12:42 tcohen joined #koha
12:49 bigbrovar left #koha
13:07 Guillaume left #koha
13:22 magnus_away is now known as magnuse
13:24 magnuse is now known as magnus_away
13:28 sekjal joined #koha
13:37 paul_p joined #koha
13:43 fcapo joined #koha
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 tcohen left #koha
13:57 tcohen joined #koha
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 ( -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:27 rhcl joined #koha
14:27 rhcl left #koha
14:28 rhcl joined #koha
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:34 fcapo left #koha
14:58 reiveune bye
14:59 reiveune left #koha
15:00 talljoy_away is now known as talljoy
15:06 alex_a left #koha
15:08 hdl left #koha
15:10 hdl joined #koha
15:10 clrh left #koha
15:12 julian left #koha
15:13 clrh joined #koha
15:14 clrh left #koha
15:15 sophie_m left #koha
15:17 Oak joined #koha
15:17 Oak \o
15:19 rhcl IO
15:27 gmcharlt EIEIO
15:27 rhcl :)
15:31 matts is now known as matts_away
15:36 christophe_c left #koha
15:46 Oak left #koha
15:53 Oak joined #koha
15:56 hdl left #koha
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:05 rhcl left #koha
16:07 Oak left #koha
16:08 rhcl joined #koha
16:24 library_systems_guy does anybody have experience setting up OpacSupression
16:26 paul_p left #koha
16:33 francharb left #koha
16:47 nengard left #koha
17:21 rhcl left #koha
17:44 tcohen left #koha
18:05 talljoy left #koha
18:21 jwagner left #koha
18:27 collum left #koha
18:55 nengard joined #koha
19:25 hdl joined #koha
19:27 hdl1 joined #koha
19:33 hdl left #koha
19:35 ketchup joined #koha
19:36 ketchup left #koha
19:37 hdl1 left #koha
19:47 Soupermanito joined #koha
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:22 nengard left #koha
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
20:41 aogle joined #koha
20:41 rhcl joined #koha
20:45 sekjal left #koha
20:54 library_systems_guy left #koha
21:25 rhcl left #koha
21:31 francharb joined #koha
21:37 JesseM left #koha
21:41 rhcl joined #koha
21:51 NateC left #koha
21:55 francharb left #koha
22:06 rhcl left #koha
22:20 aogle left #koha
22:24 NateC joined #koha
22:40 NateC left #koha
22:58 Brooke joined #koha
22:59 Brooke kia ora!
23:37 Brooke left #koha
23:38 Irmaongo joined #koha
23:58 Irmaongo left #koha

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