Time Nick Message 23:06 LBA howdy rangi 22:34 rangi hi LBA 22:26 jcamins Good night, #koha 21:46 sekjal github.com/nabeta/next-l 21:45 sekjal japanese open source ILS: Enju 21:32 jcamins Yeah, I had the two arguments backwards. 21:32 jcamins Oh, I figured it out. 21:32 liw git log COMMITID1 HEAD # iirc 21:31 jcamins Okay, one last question... is it possible to get a log going all the way back to a specific commit? 21:28 jcamins That's really cool. 21:28 rangi git freaking rules 21:28 rangi d251585f717203b3abc27ab1238a276cc6addbaf 21:28 rangi rorohiko:[git/new/enh/bug_5720-]:~/git/catalyst-koha% git merge-base new/enh/bug_5720 kc/master 21:27 rangi git merge-base 21:27 jcamins Right. 21:27 rangi 2 branches in git? 21:26 jcamins How do you find out where two branches diverged? 21:23 jcamins Hm. Thanks. 21:22 rangi * build: three-digit 21:22 rangi * revision: two-digit 21:22 rangi * minor: two-digit 21:22 rangi * major: one digit 21:22 rangi major.minor[.revision[.build]] 21:22 rangi With Koha 3, version numbering has been changed to use a method similar to Perl's: 21:22 rangi is scrapped from that site 21:22 * druthb must now hustle to get her room tidied up a bit... 21:22 rangi http://pakbill.net/koha/ 21:22 * druthb announces a code4lib Koha hackfest tonight, in her hotel room. :) 21:21 rangi one is on the site whose name i will not utter 21:21 rangi theres more than one 21:18 jcamins I seem to recall there being a document explaining Koha version numbers. Does anyone know where that document might be? 21:08 oleonard Ciao #koha 21:07 hudsonbot Paul Poulain: Bug 5718 : fix permission of moveitem = edit_items needed 21:07 hudsonbot Project Koha_Master build #350: SUCCESS in 24 min: http://hudson.koha-community.org/job/Koha_Master/350/ 20:56 rangi thats it 20:55 sijobl mount albert research centre 20:55 rangi yeah 20:55 sijobl it is a bit mad, in the high rise out in the burbs sense 20:55 rangi has a bunch of land around it too still 20:55 sijobl MARC 20:55 rangi you can see eden park from it anyway 20:55 sijobl ohh, yes 20:55 rangi mt edenish 20:54 rangi s/build/big/ 20:54 sijobl whereabouts? 20:54 rangi build old science block 20:54 rangi its one of those ones they could never build these days 20:54 rangi their building is pretty neat 20:54 sijobl http://www.nzherald.co.nz/science/news/article.cfm?c_id=82&objectid=10533889 20:53 rangi :) 20:53 rangi we only started in sept 20:53 sijobl you don't want to rush these things :-) 20:53 sijobl so two years to merge library systems 20:53 sijobl sorry, end of 2008 20:53 rangi well a year ago :) 20:53 sijobl ohh, no, it was only the end of 2009 20:52 rangi yes, yes they were ;) 20:52 sijobl I'm suprised it's taken that long - weren't crop and hort merged years ago? 20:52 rangi rhcl: i think that link only works inside their vpn 20:52 sijobl eventually, the router division was commercialised and became allied telesyn 20:51 rangi hehe cool 20:51 rangi both used different systems 20:51 sijobl from scratch 20:51 sijobl we were so cool, we made our own routers 20:51 rangi right, plant and food were an interesting one, cos it was merging 2 catalogues, crop and food and hortresearch 20:51 sijobl the last six months of that august institution :-) 20:51 sijobl yup, and the DSIR before that 20:51 slef rangi: doesn't absol... hmm 20:50 rangi you were at hort research eh? 20:50 rangi sijobl: hmm nope, all women 20:47 rhcl well, I guess all the left margin links are dead--site not live yet I guess? 20:46 * sijobl guesses not, as it as 20 years ago when I worked there :-) 20:46 rhcl re: plantand food 20:46 sijobl rangi: is stephen northover still the librarian? 20:46 rhcl there seems to be a dead link on the page -- E Journals and Books 20:45 sijobl woo, plant and food 20:42 hudsonbot Starting build 350 for job Koha_Master (previous build: SUCCESS) 20:41 hdl I think paul sent his rebuild_zebra_sliced.pl script 20:41 hdl mtj: good script, could be part of a patch 20:39 hdl nice looking 20:39 hdl in fact most of Koha sites should be in https 20:38 rangi that site is your definitive resource for kiwifruit btw :) 20:38 rangi we just helped them with the trickier bits of css 20:37 rangi they did most of it 20:37 oleonard rangi: Is that designed by Catalyst? 20:37 mtj nice css skinning rangi 20:37 rhcl ic login page 20:37 chris_n rangi: nice looking site 20:37 mtj ooh, new books! ;) 20:37 rangi i dont want passwords floating around in plain text 20:36 rangi it connects to their active directory 20:36 mtj ok, gotta scoot... 20:36 rhcl chris: just out of idle curiosity, why https vs http? 20:36 mtj hdl http://paste.koha-community.org/141 20:36 oleonard rangi: Nice! 20:35 hdl fcapo: where is this zeb_wrapper script ? 20:35 rangi https://library.plantandfood.co.nz/ <-- new koha site live 20:35 rangi i hope to finish 5574 today 20:35 hdl nice. 20:35 rangi hdl: another biblibre patch merged ! :-) 20:34 wahanui hola, hdl 20:34 hdl hi 20:32 fcapo mtj : Thank you for sharing your zeb_wrapper.pl script. It's working great! 20:32 huginn New commit(s) kohagit: Bug 5718 : fix permission of moveitem = edit_items needed <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d251585f717203b3abc27ab1238a276cc6addbaf> 20:31 jcamins Yeah, that's what I figured. 20:31 rangi well, you'd probably have to try it and see 20:30 jcamins The purpose of the thought experiment was to determine whether it's something worth doing. 20:30 jcamins rangi: yeah, that's what I would do if I were going to implement the feature. 20:30 rangi where you can specify how many to commit after 20:30 rangi how about making a switch 20:21 jcamins Would that make it any faster? 20:20 jcamins Here's a thought experiment. What if link_bibs_to_authorities committed changes to 1000 records at a time? 20:18 slef lots of admin done, but it's just not the same 20:17 sekjal nice when busy days are pointy 20:17 sekjal sorry to hear that, slef 20:17 slef hi all... been a pointlessly busy day here 20:09 space_librarian oh yes. I know. That's the irony of it all. And you can never get a straight answer either. 20:09 jcamins For example, which record has killed the indexing process. 20:09 jcamins space_librarian: no, my objection is when -v gives you all the information in the world except what you need. 20:08 space_librarian you know that useless verbosity is a mainstay of bibs and authorities in library cataloguing, right? Just checking... :) 20:07 sekjal I'll chip in on that :) 20:07 sekjal useless_verbose_logging-- 20:05 jwagner And hello from Maryland 20:05 oleonard Hello from Ohio, space_librarian 20:04 jcamins useless_verbose_logging-- 20:04 jcamins That's it? 20:04 huginn jcamins: Karma for "useless_verbose_logging" has been increased 0 times and decreased 1 time for a total karma of -1. 20:04 jcamins @karma useless_verbose_logging 20:04 jcamins useless_verbose_logging-- 20:02 jcamins gmcharlt++ # for including useful information when you run link_bibs_to_authorities.pl with -v 20:01 brendan_ :D 19:58 druthb :D 19:58 rangi wizzyrea is from NEKLS http://www.nekls.org/ 19:58 rangi (a koha support company) 19:57 rangi jcamins, sekjal, druthb, brendan_, Nate_ and nengard are all from bywater 19:57 space_librarian ciao wizzyrea, nice to meet you. 19:57 rangi ah yep, and jcamins 19:57 * jcamins is in the US, too. 19:56 rangi cya wizzyrea 19:56 wizzyrea i'm out, peace :P 19:56 rangi sekja, wizzyrea and druthb are in the us, mtj is somewhere near wellington, ibeardslee is down on level 2 :) 19:56 wizzyrea ok for real this time 19:56 wizzyrea mtj: !!!!! Give! 19:55 rangi :) 19:55 space_librarian great. I will take notes and be attentive. And go look for that screensaver. 19:55 rangi http://wiki.koha-community.org/wiki/IRC_Meetings 19:54 rangi http://stats.workbuffer.org/irclog/koha/today 19:54 ibeardslee space_librarian: System >> Preferences >> Screensaver >> MatrixView 19:54 rangi space_librarian: this is the main koha channel, its all logged, and its where we have our community meetings etc 19:53 space_librarian And I wonder if I can still find that old school (original) matrix screensaver somewhere... 19:52 space_librarian that sounds pretty awesome. 19:51 sekjal druthb and I, that is 19:51 * mtj always views the matrix with dual monitors, (in hex) 19:51 sekjal space_librarian: we're watching a presentation on the Astronomical Data System here at Code4Lib 19:51 space_librarian Hey all. :) 19:50 druthb hi, space_librarian! :D 19:50 mtj space_librarian: grateings from planet earth 19:50 space_librarian and dual monitors. I'm so impressed! 19:50 rangi heh 19:50 ibeardslee and she has a computer already! 19:50 space_librarian hello space_librarian. :) 19:49 rangi today is her 3rd day at catalyst 19:49 jcamins Hello, space_librarian. 19:49 rangi everyone say hi to space_librarian 19:48 mtj ive been too busy/embarassed to submit it to kc.org, but its been running fine on a prod/slave combo for 2 years :) 19:47 mtj … which would be close to real-time indexing, without the zeb_daemon.pl memory bloat problem 19:46 mtj fcapo: so my goofy zeb_wrapper.pl script could be increased to loop every 5 /10 seconds 19:43 jcamins Just for the record, if you set autocommit=0, make sure you run `COMMIT;` after the queries you want to stick. 19:43 mtj ah, me remembers.... 19:41 mtj katipo named the box for that client? 19:40 rangi nope katipo is all spiders 19:40 fcapo I was thinking about the time it takes to start new instances of perl, but then I saw the "Select limit 1" ... nice 19:40 mtj twas a katipo name, i think? 19:39 brendan_ heh s/live/love 19:39 brendan_ mtj I live the name of your computer ( bilbo ) :) 19:39 mtj thats the theory , anyway... :) 19:38 mtj ive you clean out the zeb_que table every few days, that select is pretty quick 19:38 mtj its just a "select * limit 1" lookup to zebra_queue table... 19:37 mtj it should *not* slow the server, too badly 19:37 fcapo interesting 19:37 rangi if you did it nicely, with a fork, from within perl, then no, no more than the daemon does 19:36 fcapo just wondering if lowering the interval so it's almost "live" would slow down the server :/ 19:36 mtj no different really , but i/admins can start/stop the job easily 19:36 ebegin fcapo, you could set it at 10 sec if you want to. If there is nothing to do, this script just access the db once 19:36 rangi you can adjust the time 19:36 rangi fcapo: i use one that just starts another one as soon as one finishes, well 5 second wait 19:35 fcapo Well, normal cronjobs have a 1 minute limit, so using that script with a 60 seconds interval isn't really different, no? 19:35 mtj then, start rebulild_zeb.pl.. 19:35 rangi back 19:35 mtj are there any outstanding bibs to index, yes... 19:34 mtj is a current rebuild happening?, no... 19:34 mtj sleep for a minute, 19:34 mtj but you get the picture... 19:34 fcapo yea :P 19:33 mtj lol, its actually a *perl* wrapper, not bash ;) 19:33 fcapo mtj: looking at it. I'll test it 19:33 mtj as chris.c said, its a looping bash wrapper for rebuild_zeb.pl, rather than a cron 19:32 mtj fcapo: check out my prev. paste.. 19:31 ebegin It's ok for bib appearing in the catalogue, but when they are creating a new bib and want to add a newly created authority, they have to wait for X minutes before being able to search it... 19:31 fcapo Thanks for the feedbacks, I'll be careful with it. 19:30 fcapo Well, right now my modified zebraqueue seems to be working correctly, only leaking memory when a lot of modifications are made :/ 19:30 pastebot0 "mtj" at 203.97.99.222 pasted "zeb_wrapper.pl" (55 lines) at http://paste.koha-community.org/141 19:30 ebegin But having to wait X minute for reindexation is quite long for the users. 19:29 mtj no, its been on my to do list for a while too! 19:29 mtj rather than calling rebuild_zeb.pl via cron 19:28 mtj i have a wrapper script that calls rebuild-zeb.pl every X minutes 19:28 fcapo so... no perfect way to do live reindexation yet? :( 19:28 mtj oops, i take that back!….. 19:27 rangi Bbiab 19:26 rangi Is my advice 19:26 rangi Don't use it 19:26 mtj but yeah, what we really need is a new re-index method thats a hybrid of the two 19:26 rangi I wrote it and it sux 19:26 rangi Every so often 19:26 rangi It still spazzes out 19:26 rangi Naw 19:25 mtj (but i should not really recommend that, to folks) 19:25 fcapo yea, If I get memory problem, I'll change the restart interval 19:25 mtj a restart every hour even, and it prolly works ok too 19:24 fcapo yea :/ that's why we do a restart every night 19:24 rangi That's why it shouldn't be used 19:24 rangi Yes but it still leaks 19:23 fcapo Well, my modifications to zebraqueue are already done and working. 19:23 rangi Well more that calls it whenever it finishes,every min you will get more than one running 19:22 mtj this allows me to start/start the re-indexing easily, without a cron edit 19:21 mtj ie: a bash wrapper script that calls zebq.pl, every minute 19:21 rangi In a loop 19:21 rangi To run rebuild_zebra.pl 19:20 rangi You are better off writing some bash 19:20 mtj fcapo: i have a similar hack for zebq 19:20 rangi Fcapo 19:20 ebegin They are fixing things ;) 19:20 fcapo I'm just wondering what all these fix subroutines are doing :/ 19:19 fcapo Today, I had to modify zebraqueue so it would work like rebuild_zebra. I just copied the fix_leader, fix_biblio_ids, fix_authority_id and fix_unimarc_100 subroutines from rebuild_zebra and used them in zebraqueue. 19:18 fcapo ok, good :) 19:18 ebegin but it still in my todo list :) 19:17 ebegin I had a look at it, but I was pulled by something else and didn't have time to look at it since. 19:16 jcamins fcapo: I think ebegin was doing some work on that. 19:15 fcapo Our clients need to have live reindexation of records, so right now we are using zebraqueue with a restart every night because of its memory leaks :/ 19:14 fcapo Hello, I have some questions on Zebra reindexation : is anybody working on a replacement for zebraqueue right now? 19:13 rangi Ahh nickserv, gotta love it 19:02 rangi Cool 19:02 druthb so far, so good. 19:02 rangi Heya how's the conf going? 19:01 * druthb waves to rangi 19:01 rangi Nice :) 18:56 liw oleonard, I have a friend who's contribution to the Linux kernel is -1 lines :) he found a bug whose fix was to remove a line 17:02 magnuse oleonard: my first patch removed one character... ;-) 16:47 cait this missing space was annoying :) 16:47 cait oleonard++ even 16:46 cait owen++ 16:37 oleonard I hope it finds its way into Koha's top-ten list of single-character bug fixes 16:37 jcamins oleonard++ # for attention to detail 16:37 oleonard Yes, it's true: I created a bug report and sent a patch for a bug involving one space. 16:23 hdl trying to know what we are supposed to send 16:23 hdl But is rasing an error when answering MARC 16:22 hdl Our SimpleServer for Solr is working fine with marcxml 16:22 hdl marcxml is being sent ok 16:21 gmcharlt though you could try MARCXML 16:21 gmcharlt hdl: yep, it should be expecting regular ISO 16:21 wizzyrea so close. 16:21 huginn wizzyrea: The current temperature in Channel 6 Downtown, Lawrence, Kansas is -15.1�C (10:25 AM CST on February 08, 2011). Conditions: Partly Cloudy. Humidity: 66%. Dew Point: -20.0�C. Windchill: -22.0�C. Pressure: 30.59 in 1035.8 hPa (Steady). Winter Weather Advisory in effect until 6 am CST Wednesday... 16:21 wizzyrea @wunder lawrence ks 16:20 hdl gmcharlt: Do you know what data SimpleServer should send back when being asked MARC records ? It seems that sending MARC::Record->as_usmarc is being interpreted as BAD MARC 16:19 * jwagner gathers armies in the other blue countries and prepares to attack Switzerland 16:19 gmcharlt mxiture, then 16:19 hdl But there are some MARC21 also 16:19 hdl gmcharlt: we had UNIMARC libraries there 16:17 gmcharlt hmm, looks like MARC21 if the national library's catalog is any indication 16:16 jcamins gmcharlt: that's a really funny image. But I have no idea. 16:15 * gmcharlt suddenly had an imagine of a weird, cataloger-centric game of Risk 16:15 gmcharlt does anybody know offhand whether Switzerland is UNIMARC or MARC21 territory? 16:00 gmcharlt very Pyrrhic 16:00 huginn gmcharlt: The current temperature in Earthquake Park, Anchorage, Alaska is -5.7�C (6:59 AM AKST on February 08, 2011). Conditions: Clear. Humidity: 79%. Dew Point: -9.0�C. Windchill: -6.0�C. Pressure: 30.16 in 1021.2 hPa (Falling). Strong wind through late tonight along Turnagain Arm and higher elevations... 16:00 gmcharlt @wunder 99517 16:00 oleonard rhcl: A Pyrrhic victory though it is 15:59 huginn gmcharlt: Quote #112: "gmcharlt: only superlibrarians can be trusted with capes" (added by wizzyrea at 09:17 PM, December 15, 2010) 15:59 gmcharlt @quote random 15:52 rhcl -16.7 Do I win? 15:52 huginn rhcl: The current temperature in St Joseph, Missouri is -16.7�C (9:56 AM CST on February 08, 2011). Conditions: Clear. Humidity: 52%. Dew Point: -24.0�C. Windchill: -17.0�C. Pressure: 30.42 in 1030.0 hPa (Falling). Wind Chill Advisory in effect until noon CST today... 15:52 rhcl @wunder 64507 15:47 nengard last time was for SLA 15:47 nengard my second visit 15:47 * oleonard should find an excuse to visit Seattle someday 15:46 nengard training yet another new koha library :) 15:46 nengard yep oleonard 15:46 huginn jcamins: The current temperature in Long Island City, Queens, New York is 6.4�C (10:45 AM EST on February 08, 2011). Conditions: Mostly Cloudy. Humidity: 61%. Dew Point: -1.0�C. Windchill: 2.0�C. Pressure: 30.04 in 1017.2 hPa (Rising). 15:46 jcamins @wunder 11375 15:46 nengard well - i guess it's good i'm in seattle :) 15:46 oleonard Are you in Seattle nengard ? 15:45 huginn nengard: The current temperature in CWOP # AR939, Penndel, Pennsylvania is 2.2�C (10:49 AM EST on February 08, 2011). Conditions: Overcast. Humidity: 62%. Dew Point: -4.0�C. Windchill: 2.0�C. Pressure: 29.71 in 1006.0 hPa (Steady). Wind Advisory in effect until 8 PM EST this evening... 15:45 nengard @wunder 19030 15:45 huginn nengard: The current temperature in Herrera Environmental Consultants, Seattle, Washington is 5.1�C (7:49 AM PST on February 08, 2011). Conditions: Overcast. Humidity: 88%. Dew Point: 3.0�C. Windchill: 3.0�C. Pressure: 30.26 in 1024.6 hPa (Steady). 15:45 nengard @wunder seattle, wa 15:29 huginn oleonard: The current temperature in Athens, Ohio is -3.0�C (10:15 AM EST on February 08, 2011). Conditions: Light Snow. Humidity: 81%. Dew Point: -6.0�C. Windchill: -8.0�C. Pressure: 30.12 in 1020 hPa (Rising). 15:29 oleonard @wunder 45701 15:26 huginn magnuse: The current temperature in Bodo, Norway is -1.0�C (4:20 PM CET on February 08, 2011). Conditions: Mostly Cloudy. Humidity: 86%. Dew Point: -3.0�C. Windchill: -8.0�C. Pressure: 29.18 in 988 hPa (Rising). 15:26 magnuse @wunder bodo, norway 15:23 kf no, shoudl work on a zillion other things 15:23 oleonard I just wanted to make sure we weren't both working on it 15:23 kf ok, thx 15:23 oleonard No, I'll just keep going 15:23 kf oleonard: i don't have time now - I could try tonight 15:22 * druthb shivers a little. 15:22 huginn druthb: The current temperature in Bloomington, Indiana is -7.7�C (10:25 AM EST on February 08, 2011). Conditions: Overcast. Humidity: 74%. Dew Point: -12.0�C. Windchill: -12.0�C. Pressure: 30.25 in 1024.3 hPa (Rising). 15:22 druthb @wunder Bloomington, IN. 15:20 * oleonard had just started to review it 15:20 oleonard kf: Are you signing off on that patch? 15:18 kf kmkale: I was customizing one of these pages with jquery yesterday and was missing a unique id :) 15:17 kf kmkale++ 15:17 jcamins (and the suppress index wasn't set up) 15:17 jcamins jwagner: no results were coming up because OpacSuppression was turned on. 15:16 jwagner jcamins, do you mean the record wasn't searching because it was suppressed, or it was failing to index/corrupting because it was suppressed? 15:15 jcamins OpacSuppression, rather. 15:13 jcamins It's suppress lost biblios. 15:13 jcamins Oh, never mind. 15:11 jcamins You'd think there would be some sort of error, though. 15:11 wahanui oleonard: I forgot probably 15:11 oleonard wahanui: forget probably 15:11 jcamins Apparently the very first record, in fact. 15:10 wahanui hmmm... probably is already fixed in 3.2.x and 3.4 15:10 jcamins Probably. 15:10 sekjal ? 15:10 sekjal jcamins: corrupted biblio record 15:09 jcamins Yup. 15:09 kf have you reindexed with a and b? 15:08 jcamins Authorities are searching fine, but biblios are not. 15:08 jcamins Why would Zebra not work only with biblios? 15:06 * druthb returns ffrom break. 14:18 jcamins I left foreign_key_checks alone, since that makes the deletion propagate. 14:16 jcamins It was slow, but not like before. 14:15 jcamins (actually, I increased innodb_buffer_pool_size first) 14:15 jcamins Ran the delete. 14:15 jcamins Increased innodb_buffer_pool_size as much as possible. 14:15 jcamins SET autocommit=0; 14:15 jcamins For those of you who have been waiting with bated breath to learn how to delete massive numbers of records, here is what I did: 14:09 sekjal also, we can develop it in parallel, and fall back to prog if things get weird 14:08 sekjal since not every browser supports HTML5 yet, we can keep koha's requirements lower by making HTML5 optional at first 14:08 sekjal oleonard: ah 14:07 oleonard sekjal: Sorry, I mean why a second template directory? 14:07 sekjal the change to the templates breaks the patron messaging preferences form 14:07 oleonard sekjal: why a second one? 14:06 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5462 enhancement, PATCH-Sent, ---, gmcharlt, NEW, Fix variable names so we dont break template::toolkit 14:06 sekjal oh, and found another followup fix for bug 5462 14:06 sekjal I'm interested in a second template directory with all the templates done in HTML5 and CSS3 14:05 druthb Good morning, from code4lib. :) 14:03 kf when the change to template toolkit is done 14:03 kf I think we should wait for the next version perhaps 14:02 oleonard And T:T of course. 14:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5481 enhancement, P5, ---, oleonard, ASSIGNED, Replace YUI JS libraries with Jquery UI 14:02 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4048 normal, P5, ---, oleonard, ASSIGNED, CSS and JS libs must be outside of translated paths 14:02 oleonard We've got too many template-wide change bugs at the moment: bug 4048, bug 5481 14:01 oleonard I think we should plan to use html5 in koha eventually 14:00 kf and do we plan to use html5 in koha 14:00 kf and if we want to change it now before that happens? 14:00 kf oleonard: I think the question is if the translator script will be changed for template toolkit 13:57 oleonard Should we be modifying the translator script to accommodate a feature that isn't in Koha? 13:57 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5709 enhancement, P5, ---, brice.sanchez, ASSIGNED, Adding the ability to translate HTML5 placeholder text in an input field 13:57 oleonard bug 5709 13:45 jcamins What do y'all recommend for key_buffer on a VirtualBox VM? 13:39 jcamins Woohoo! 4.2 seconds. 13:39 jcamins Ooh, I'll try SET foreign_key_checks = 0; 13:38 kf jwagner: only a little painful, once you have the statement it's pretty fast to do 13:38 jcamins I'm just going to blow away the database after I figure out what's going on anyway. 13:37 jcamins jwagner: they are. I'd be fine with manually reconciling foreign key constraints, though. 13:37 jcamins It took 1:30 to delete about 10k records. 13:37 jwagner jcamins, I assume you've checked that these records aren't linked to anything? 13:37 jcamins Ah. I see why it was so fast. 13:36 jwagner kf, that sounds painful 13:35 kf and we did rewrite the output from a select to delete statements, using concat 13:35 kf but I had problems with tables where I was not allowed to delete more than one line at a time (not koha) 13:35 kf not sure it will be faster 13:35 jcamins The problem is when there are no typos, deleting 50k records takes a loooooooooooong time. 13:34 jcamins Oh, I got all the results I want to delete. 13:34 jwagner What do you get if you do a select with the biblionumber < 51200? 13:34 jwagner I don't work at the MySQL level much, but if you can do a where you should be able to frame a select. 13:33 jcamins Never mind. The DELETE didn't work right. That's why it was so fast. 13:32 jcamins I've been spending a lot of time deleting records of late. 13:31 jcamins Cool. If there's a better day to do it, though, I'd be grateful for any pointers. 13:30 jcamins DELETE FROM biblio WHERE biblionumber < 51200 only took 1:30 today. 13:30 jcamins Huh. That was weird. 13:30 jcamins jwagner: yeah. 13:30 jwagner i.e., can you select where.... 13:30 jwagner jcamins, is there something identifiably unique about them? 13:28 jcamins Does anyone know of a way to quickly delete a huge number of records from MySQL? 13:20 oleonard :) 13:20 jcamins I'm still working on that. 13:19 oleonard what's your plan? 13:19 jcamins I think I'll take a stab at it. 13:19 jcamins Okay. 13:18 oleonard No 13:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5704 enhancement, P5, ---, oleonard, NEW, bib level item type icon should display on search results 13:18 jcamins oleonard: Good morning. I was just thinking of you. Are you working on Bug 5704? 13:17 oleonard Hi #koha 12:59 Nate_ morning! 12:58 jcamins Hi there, jwagner and Nate_. 12:57 jwagner morning, jcamins 12:54 jcamins Good morning, #koha 09:40 kmkale brb 09:36 magnuse jransom: ah, you made the mistake earlier and discovered it now? 09:35 jransom Magnus: yep - but now I have to fess up :( 09:32 rangi yup 09:32 indradg rangi, pm? 09:32 indradg rangi, hi 09:32 rangi hi indradg 09:30 magnuse jransom: good thing you found it, then! 09:29 hudsonbot Chris Cormack: Bug 2742 : Fix typo 09:29 hudsonbot Project Koha_Master build #349: SUCCESS in 26 min: http://hudson.koha-community.org/job/Koha_Master/349/ 09:21 jransom just found it but need to explain it now .... 09:21 jransom magnise: been crunching numbers all day. did a bit huge mistake 09:20 jransom hiya Katrin :D 09:13 rangi cool 09:10 magnuse rangi: thanks, i'll give nynorsk a try, then 09:10 rangi yup, thats right 09:09 wahanui hey, hdl 09:09 hdl hi 09:09 magnuse rangi: cool. do i set the the status back to patch sent when it's sent? 09:08 rangi magnuse: yes, thats fine 09:06 * kf waves to jransom 09:03 hudsonbot Starting build 349 for job Koha_Master (previous build: SUCCESS) 09:03 magnuse jransom: and you are crunching numbers? 09:02 hudsonbot * Fr?d?rick Capovilla: Bug 5616: Corrects an utf-8 encoding problem in cardviews 09:02 hudsonbot * Marcel de Rooy: Bug 5701: Distinction between authors/additional authors in staff normal view (MARC21/XSLT) 09:02 hudsonbot * Chris Cormack: Bumping database version 09:02 hudsonbot * Colin Campbell: Bug 2742 Correct language names in install 09:02 hudsonbot Project Koha_Master build #348: SUCCESS in 24 min: http://hudson.koha-community.org/job/Koha_Master/348/ 09:02 jransom tell me about it .. 09:01 magnuse jransom: fine thanks, lots of work to do and not enough time, though... ;-) 09:01 magnuse rangi: is it ok if i submit a patch for 2742 that just adds "nynorsk"? 09:00 jransom magnus baby !! how are you :D 09:00 magnuse kia ora, jransom! 08:59 magnuse hiya kf 08:58 kf morning magnus 08:57 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2742 normal, PATCH-Sent, ---, chris, NEW, Wrong language name in the preferences 08:57 magnuse hm, looks like the patch for bug 2742 does not include our beloved "nynorsk" 08:46 huginn New commit(s) kohagit: Bug 2742 : Fix typo <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=403f53c0d841e2a9f5991d3e6a9cb7704a83cf40> 08:38 hudsonbot Starting build 348 for job Koha_Master (previous build: SUCCESS) 08:37 hudsonbot Owen Leonard: Follow-up correction for Bug 5462 - Fix variable names for template::toolkit 08:37 hudsonbot Project Koha_Master build #347: SUCCESS in 25 min: http://hudson.koha-community.org/job/Koha_Master/347/ 08:16 huginn New commit(s) kohagit: Bug 5616: Corrects an utf-8 encoding problem in cardviews <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=07731037ee453fe3537c257b07be9c49b66e8ced> / Bug 5701: Distinction between authors/additional authors in staff normal view (MARC21... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8ce06ddf3220bf4b16efe6d796ec80251f3390fb> / Bumping database version <http://git.koha-community.org/gitweb 08:13 paul_p thx kf 08:13 kf paul_p 08:13 kf and good morning paul_ü 08:12 kf hope they get better soon 08:12 hudsonbot Starting build 347 for job Koha_Master (previous build: SUCCESS) 08:12 paul_p working from home today. 2 boys ill 08:12 paul_p hello world ! 08:06 huginn New commit(s) kohagit: Merge remote branch 'kc/new/enh/bug_5462' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=083fd5776aad2dcc97a231ce5cefec1ec661e51a> / Follow-up correction for Bug 5462 - Fix variable names for template::toolkit <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6709d0e4f7bf82c2110167fda132dd06e171eff3> 08:05 rangi always 08:05 kf pushing patches? :) 08:04 kf hi rangi :) 08:03 rangi hi kf 08:02 kf good morning #koha 07:25 snail Outside of a dog a book is a man's best friend, inside of a dog it's too dark to read --- Groucho Marx 07:20 rangi cool photo :) 07:19 snail rangi: cheers, added those awards 07:14 magnuse ooh, cozy! 07:14 snail heh, can ppl see http://a4.sphotos.ak.fbcdn.net/hphotos-ak-ash1/hs778.ash1/166870_10150175320254045_818194044_8696073_335845_n.jpg ? 07:13 snail kmkale: if you're in there giving things id's and there are some that are similar, you may want to group them into a class as well 07:02 francharb hi rangi! 07:02 rangi hi francharb 07:02 francharb hello #koha 06:49 kmkale cool 06:48 rangi i cant think of any reason not to give something one, even if we never use it, it cant hurt :) 06:48 rangi everything should have an id 06:48 rangi yes, that is a good idea 06:47 kmkale many of the templates in opac which deal with users data eg opac-account.tmpl, opac-passwd.tmpl etc do not have a id for the container div like opac-user.tmpl has an id userdetail. having these id's makes it easier to customize with css. If you think adding such id's is a good idea, I can make a bug and a patch. 06:44 kmkale chris got a minute? 06:41 rangi i think thats all of them :) 06:40 rangi prolly not worth adding that one tho 06:40 rangi http://www.nzosa.org.nz/winners finalist in nzosa, and i got contributor of the year for koha work 06:39 rangi http://computerworld.co.nz/news.nsf/news/6C696179245321F5CC256EBD006E50BC?Opendocument&HighLight=2,koha 06:39 rangi Another one in 2004 06:37 rangi http://lianza2009.wordpress.com/2009/10/07/library-idol-its-the-3m-award-for-innovation-in-libraries/ 06:35 rangi trying to find a 3rd party source for that 06:35 rangi it won the 3m award for innovation in 2000 too 06:33 rangi http://computerworld.co.nz/news.nsf/news/CC256CED0016AD1ECC2569810006EAE0?Opendocument&HighLight=2,koha 06:32 rangi snail: do you want to add some of the other awards? 06:30 kmkale never mind 06:17 kmkale can anyone tell me how to initialize a git repo with a copied kohaclone directory? 05:17 snail mtj: if you're around and have questions about the wikipedia article, I'm around at the moment 04:39 kmkale hi druthb 04:38 druthb hi, kmkale. :) 04:36 kmkale namaskar #koha 04:12 druthb sekjal++ # for bein' a hero. 02:49 brendan_ :) 02:49 brendan_ a little 02:48 mtj getting some sun, i hope 02:48 brendan_ I should be coming back a little bit slowly now though 02:48 brendan_ yeah been off for awhile 02:47 mtj long time, no chat :p 02:47 brendan_ heya mtj - 02:47 * mtj waves at brendan_ 02:47 rangi reading good press releases about masscat :) 02:46 brendan_ rangi - what's happening man :D 02:46 rangi heya brendan_ 02:44 brendan_ evening 02:36 nengard bug updated 02:25 rangi adding the sort bit didnt work? 02:22 rangi 4263 02:17 nengard rangi what bug # was that - i can update the bug report if you want 02:14 rangi now just have to fix it 02:14 rangi found the commit that broke the ordering 02:13 nengard thanks though!! 02:13 jcamins_away I wasn't finding it anyway. 02:13 nengard :) 02:13 jcamins_away Nope. 02:13 jcamins_away Oh, good. 02:13 nengard unless you mean another bug report 02:13 nengard jcamins - rangi helped me find it already 02:08 jcamins_away nengard: One moment, I recall a bug report. 02:06 jcamins_away usb_hubs_on_external_monitors++ 00:44 rangi packages++ 00:44 rangi yay 00:43 eythian new koha packages uploaded, for anyone interested :) 00:04 nengard hi all - i'm wondering if someone knows of a commit that recently changed the order in which the item fields appear in cataloging - when adding an item the fields aren't in alpha order anymore .....