Time Nick Message 23:51 dcook So much rubber duck... 23:45 dcook #$*^(%^@@%@)! 23:45 dcook I just found it 23:45 dcook I lies 23:45 wahanui rumour has it facepalm is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity 23:45 * dcook facepalm 23:45 dcook OH SNAP 23:45 dcook Well, not so much figured out as ran out of room to debug 23:44 dcook It took way too long but sort of figured out that double encoding of ampersands.. 23:44 dcook http://kohadevreactions.tumblr.com/post/73499272725/someone-tells-you-of-a-stubborn-bug-kohails 23:43 dcook Just sayin' 23:43 dcook davidtennant++ 23:43 huginn dcook: davidtennant has neutral karma. 23:43 dcook @karma davidtennant 23:42 dcook lol 23:42 wizzyrea to that quote I say http://kohadevreactions.tumblr.com/post/69868436107/ptfs-liblime-trademark-application-for-kohails-in 23:35 dcook I'll leave it there :p 23:35 dcook die marc! 23:35 dcook die marc? 23:35 dcook Hmm 23:35 wahanui The MARC specs live at http://www.loc.gov/marc/bibliographic/ - abandon hope all ye who enter here. 23:35 dcook marc? 23:35 huginn francesca: Quote #214: "obelos: Perhaps this means it's time for HLT to choose a different name so we can all move on with our work without this distraction." (added by mtj at 01:52 AM, August 08, 2012) 23:35 dcook There are so many fields that a super anal archivist might use...but with no one ever looking at it again 23:35 francesca @quote random 23:34 dcook There are so many fields that a librarian would probably never use 23:34 dcook There are so many fields that a user would never use 23:34 dcook I just wonder if MARC is fully implemented anywhere or has ever been 23:33 dcook hehe 23:33 jcamins :P 23:33 jcamins dcook: I find your theory to be wholly disturbing. 23:32 dcook It seemed like a good idea in theory? 23:30 jcamins Avaunt foul spirit! 23:30 * dcook is looking at MFHD 23:30 dcook mhm 23:27 wizzyrea too right 23:26 huginn francesca: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011) 23:26 francesca @quote random 23:11 jcamins gmcharlt++ 23:11 jcamins Within five minutes of getting home, someone's taken care of it for me. :D 23:11 jcamins Wow, I'm loving this module maintainer gig. 23:11 huginn New commit(s) kohagit: Bug 10987: (follow-up) fix display of authorities containing only one see from or... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e686dd25438b66de751551c8f8fecff115b661d4> / Bug 10987: remove duplicate 'see also' and 'see from' labels from authority search... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=910dff28254b8a93ed03884b0e768fd7c013f449> / Bug 10691: (follow-up) replace HTML co 23:09 mrx much appreciated 23:09 jcamins Something to do with ISBNs. 23:09 mrx Thanks heaps guys, very much helpful 23:09 wizzyrea (3 timezones as well) 23:09 jcamins I don't actually know what we're trying to do. 23:08 wizzyrea (also, that's pretty magic, 4 people, 3 countries, one question.) 23:08 wizzyrea mrx: all of that ^ was for you. 23:08 jcamins (to get rid of whichever records don't match) 23:07 dcook Totes 23:07 jcamins dcook: if performance is a concern, filter after-the-fact. 23:07 dcook Doubtful though 23:07 dcook Hmm, probably. Although you might have that same number somewhere other than the 020$a 23:06 jcamins dcook: or, if performance is a concern: SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code="a"]') AS 'isbns' FROM biblioitems WHERE marcxml LIKE '%ISBN%'; 23:06 * dcook was just wondering because this seems to have been the same question from yesterday? :S 23:06 dcook Yep 23:06 wizzyrea either way, a buffet of queries there for him to choose from 23:06 dcook No real reasoon to have that > in there 23:05 dcook Actually subfield[@code>="a"] should probably just be subfield[@code="a"] 23:05 dcook May or may not need those mysql backticks...can't recall for sure.. 23:05 dcook select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as 'isbns' from biblioitems having `isbns` like '%ISBN%' 23:04 dcook or.. 23:04 dcook select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as 'isbns' from biblioitems where ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') like '%ISBN%' 23:04 wizzyrea isbns* 23:04 wizzyrea he wants to see the ISBN as well 23:04 dcook select biblionumber from biblioitems where ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') like '%ISBN%' 23:03 dcook Nvm 23:03 dcook Durr 23:03 dcook Oh wait 23:03 dcook Pretty sure that your first "select biblionumber, isbn from biblioitems where isbn LIKE '%9781922244024%'" should work for that then 23:03 wizzyrea biblioitems isbn only has the first, but the xml has them all. 23:02 wizzyrea he wants to see all biblionumbers that have a certain ISBN in one of their multiple 020a's 23:02 wahanui rumour has it the scenario is a problematic patch across versions 23:02 dcook wizzyrea: What's the scenario? 22:59 wizzyrea me too. Me. Too. 22:59 wahanui i think something is fishy 22:59 wizzyrea or something. 22:59 wizzyrea SELECT biblionumber, isbns FROM (select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') AS 'isbns' FROM biblioitems) as isbns where isbns LIKE '%YOURISBN%'; 22:52 francesca tom http://img585.imageshack.us/img585/9908/6ykn.png 22:46 mrx wizzyrea: multiple 020s 22:45 wizzyrea do you have multiple 020a fields per record, or several isbns in a single 020a? 22:43 francesca tom heres the link to the image http://pbrd.co/Km1RLy 22:43 rangi Roman_: https://web.archive.org/web/20130403095533/http://dashboard.koha-community.org/ 22:38 mrx wizzyrea: what do you mean by how you catalogued them as that query return same result 22:36 wizzyrea guess it would depend on how you catalogued them. 22:35 wizzyrea maybe you'd have better luck with something like select biblionumber, isbn from biblioitems where isbn LIKE '%9781922244024%' 22:33 mrx rangi: humm, unfortunately returns same results as before. It only appears to search the for 1st listed isbn not the rest... 22:30 rangi something like that anyway 22:29 rangi SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as isbns FROM biblioitems WHERE isbns LIKE '%9781922244024%' 22:29 rangi actually 22:28 rangi SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as isbns WHERE isbns LIKE '%9781922244024%' 22:23 mrx rangi: what will be the LIKE query in this case as I'm unable to get it to work I think 22:21 francesca so exciting!! 22:19 rangi which might get you some false positives occassionally 22:19 rangi the only way is to do LIKE %value% 22:18 rangi is the short answer 22:18 rangi mrx: no 22:16 wizzyrea francesca: http://img585.imageshack.us/img585/9908/6ykn.png 22:14 mrx ITEM 22:14 mrx isbn=9781922244024), '//datafield[@tag="020"]/subfield[@code>="a"]') AS 22:14 mrx SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE 22:14 mrx Hi guys, I am using ExtractValue as below to search isbn listed in a record as a second 020 field but the statment is not returning anything but if I use the first isbn listed in 020 filed of the same record it returns all 020 fields. Is there a way to search isbn other than the first listed in 020 filed? 22:10 rambutan inkscape requires some artistic ability! 22:10 pianohacker inkscape++ 22:10 francesca not really.. I just use inkscape 22:09 rambutan francesca: you have some artistic ability it would seem? 22:08 francesca the favicon I designed for the dashboard being used on the koha website 22:07 pianohacker about? :) 22:07 * francesca is very excited 22:05 francesca wow. 22:02 * pianohacker thought at first wizzy was talking about habitrpg :) 22:02 * wizzyrea uses it on the koha website 22:02 pianohacker That is an excellent favicon yes 22:01 pianohacker is that a reference to a floor or a game? 22:01 wizzyrea ok that favicon is super cute. 22:01 wizzyrea ya 21:54 MrAgent075 wizzyrea: you on Lv. 7? 21:51 francesca heres the link to the image http://pbrd.co/Km1RLy 21:50 pastebot "francesca" at 127.0.0.1 pasted "new favicon" (2 lines) at http://paste.koha-community.org/92 21:47 cait bye pianohacker :) 21:47 pianohacker good night cait 21:47 cait good night #koha 21:26 pastebot "MrAgent075" at 127.0.0.1 pasted "maxlength attribute to Random Quotes" (9 lines) at http://paste.koha-community.org/91 21:20 huginn MrAgent075: The current temperature in Maarssenbroek, Maarssen, Netherlands is 6.7°C (10:19 PM CET on January 16, 2014). Conditions: Scattered Clouds. Humidity: 99%. Dew Point: 7.0°C. Windchill: 7.0°C. Pressure: 29.42 in 996 hPa (Rising). 21:19 MrAgent075 @wunder Maarssen, Netherlands 21:19 huginn MrAgent075: The current temperature in London / Heathrow Airport, United Kingdom is 7.0°C (9:00 PM GMT on January 16, 2014). Conditions: Light Rain. Humidity: 84%. Dew Point: 5.0°C. Pressure: 29.17 in 988 hPa (Falling). 21:19 MrAgent075 @wunder London, England 21:15 oleonard Bye #koha 21:13 pianohacker francesca: not a fan of hex colors? :) 21:11 francesca color: rgb(184, 184, 184); 21:07 pastebot "francesca" at 127.0.0.1 pasted "link hover colour fix" (7 lines) at http://paste.koha-community.org/90 21:06 huginn magnuse: The current temperature in Bodo, Norway is -6.0°C (9:50 PM CET on January 16, 2014). Conditions: Clear. Humidity: 58%. Dew Point: -13.0°C. Windchill: -16.0°C. Pressure: 30.15 in 1021 hPa (Steady). 21:06 magnuse @wunder boo 21:00 rangi i hope its cooler by february 21:00 rangi that is too warm, its getting to 45 there today 21:00 huginn rangi: The current temperature in AO-GSO, Melbourne, Victoria is 28.8°C (7:48 AM EST on January 17, 2014). Conditions: Clear. Humidity: 45%. Dew Point: 16.0°C. Pressure: 29.80 in 1009 hPa (Steady). 21:00 rangi @wunder melbourne, australia 21:00 huginn rangi: Error: No such location could be found. 21:00 rangi @wunder melbourne 20:59 cait way too warm here still 20:57 huginn rangi: The current temperature in Wellington, New Zealand is 15.0°C (9:30 AM NZDT on January 17, 2014). Conditions: Partly Cloudy. Humidity: 72%. Dew Point: 10.0°C. Pressure: 29.62 in 1003 hPa (Steady). 20:57 rangi @wunder nzwn 20:57 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 4.7°C (9:55 PM CET on January 16, 2014). Conditions: Mostly Cloudy. Humidity: 90%. Dew Point: 3.0°C. Windchill: 5.0°C. Pressure: 29.74 in 1007 hPa (Rising). 20:57 cait @wunder Konstanz 20:56 cait :) 20:54 rangi thanks gmcharlt 20:50 gmcharlt with the latest and greatest from http://librarypolice.com/~gmc/koha_irc_quotes.txt 20:47 rangi is where they come from 20:47 rangi the koha_irc_quotes.txt file 20:47 rangi MrAgent075: https://gitorious.org/koha-dashboard/koha-dashboard/source/ebf43d2e810b4e7a2cb0defe13a1c7d431c9d377:data 20:46 rangi if you look here 20:46 rangi fetched from a file 20:46 rangi they are from the bot 20:46 pastebot "francesca" at 127.0.0.1 pasted "changing link hover colour" (4 lines) at http://paste.koha-community.org/89 20:45 MrAgent075 rangi: Where are the quotes being generated from? The idea I had seems like the easy way out, but ultimately, a script should be made where quotes that are at the limit of 'x' and under should be put up. 20:45 francesca ok 20:44 wizzyrea light grey 20:44 francesca is there a particular colour you would like the links to turn when when hovered over? 20:44 cait cool, thx francesca 20:43 francesca I'm fixing the hover colour for the links now 20:43 t-houlks cheers 20:42 rangi t-houlks: http://wiki.koha-community.org/wiki/Catalyst_Academy 20:42 cait looking at it in firefox 20:42 cait the hover on the toolbar is a bit dark, maybe it could pop a bit more? 20:42 t-houlks chris, where's that list that has all of our patches saying if they're signed off or not? 20:42 cait can i make a suggestion? 20:42 cait :) 20:40 wizzyrea that's really pretty! 20:38 rangi hmm yeah, wanna paste me the code? 20:37 MrAgent075 rangi: possibly impliment the maxlength attribute on the Random Quotes? #koha-dashboard 20:36 huginn francesca: Quote #213: "jwagner: There are few problems that can't be solved with patience, ingenuity, and a large kick in the pants (assuming servers wear pants, that is)." (added by wizzyrea at 06:18 PM, August 07, 2012) 20:36 francesca @quote random 20:32 pastebot "francesca" at 127.0.0.1 pasted "favicon code" (3 lines) at http://paste.koha-community.org/88 20:31 francesca http://pbrd.co/1dzopVX link to favicon for dashboard 20:30 cait gmcharlt++ :) 20:30 pianohacker gmcharlt++ 20:30 pianohacker hell yeah 20:29 gmcharlt pianohacker: correct 20:29 cait the dashboard looks great 20:29 pianohacker gmcharlt: Am I reading that code right? It looks like it should also update the pazpar2 configuration 20:29 cait :) 20:28 MrAgent075 (Person who make the .svg logo)++ 20:28 MrAgent075 Yay, it works! :) 20:28 cait woo :) 20:28 rangi yep 20:27 cait logo? :) 20:27 * cait does 20:27 rangi MrAgent075++ checkout out the dashboard now 20:27 gmcharlt there's an update_zebra_conf Makefile target, for example 20:26 gmcharlt pianohacker: it depends 20:20 cait circulation rules :) 20:20 cait pianohacker: i have an idea for another great gui project for you 20:20 cait or myswl on command line... or... :) 20:20 cait mysql client 20:20 cait no 20:19 pianohacker someone more familiar with the perl installer: is there an easy way to reinstall select config files from the templates? 20:18 rangi students http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ef7480f362a0286b13e1ba1b99e58c6d2ca7ba72#patch1 20:18 wizzyrea that's what I don't know 20:18 rangi thanks 20:18 MrAgent075 http://paste.koha-community.org/87 20:17 pianohacker and the pazpar2 config files are installed? 20:17 wizzyrea yep, I applied all of them 20:17 pianohacker wizzyrea: do you have all of the new config files from the patch and its followups? 20:16 wizzyrea and for the life of me I cannot make pazpar2 cooperate 20:16 wizzyrea well I am trying to use your z39.50 external search patch 20:15 pianohacker wazzup :) 20:15 pianohacker uh oh 20:15 wizzyrea just the person I wanted :) 20:15 wahanui somebody said pianohacker was a Dune fan, it seems. 20:15 wizzyrea pianohacker 20:12 pianohacker woo! and yeah, that kinda weirdo 20:09 cait or someone who would redo catalouging ;) 20:09 cait http://www.librarytechnology.org/ltg-displaytext.pl?RC=18805 < opl again :) 20:05 * mtompset looks at pianohacker. :) 20:05 pianohacker and where are we gonna find one of those? 20:05 pianohacker you'd need the kind of masochistic fool who'd do something like redo the sysprefs 20:04 pianohacker heh well that's the thing 20:04 cait feel free to improve ;) 20:04 * pianohacker loves our translaters and hates our JS translation system... 20:04 cait way better 20:03 pianohacker so $stuff.html( '<span>' + _( "Yay!" ) + '</span>' ) ? 20:03 mtompset pianohacker: you forgot the style="display: none" ;) 20:03 cait if you just wan to bold one word... i might leave it... to not break up the sentence but best to avoid totally 20:03 huginn magnuse: The operation succeeded. 20:03 magnuse @later tell slef: a cycling library unconference between barcelona and lyon - something for you? :-)http://cyc4libse.tumblr.com/post/73532123683/woop-woop-i-ar-cyklar-vi-till-kaunas-och-lyon-dock 20:02 cait well in that example i wouldn't leave it in 20:02 oleonard pianohacker: No 20:02 rangi yep 20:02 mtompset Sounds good to me, rangi. I think the test plan is easy enough to follow. :) 20:01 pianohacker $stuff.html( _( "<span>Yay!</span>" ) ); 20:01 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11513 minor, P5 - low, ---, mtompset, Needs Signoff , Warnings in Patron categories 20:01 rangi mtompset: one of the students is going to test bug 11513 20:01 pianohacker And is it considered kosher to leave the tags inside a short HTML bit? like 20:00 cait well not a perfect solution, but maybe some ideas :) 20:00 pianohacker woot! Thanks. 20:00 cait there was a discussion with paxed and oleonard 19:59 cait look at the logs from today 19:59 cait there seems to be a jquery replace thing 19:59 pianohacker possibly 19:59 cait i think we had this discussion earlier 19:59 pianohacker There's ways to break that up so it isn't needed, but it looks a lot less natural 19:58 pianohacker For example, "Found 10 matches in 3 external targets" 19:58 cait what are you trying to do? 19:58 cait ? 19:57 pianohacker cait: Is there any way at all to do formatted translations in JavaScript? 19:57 magnuse yeah, fill all the queues! 19:57 cait pianohacker: yes? 19:56 * magnuse cheers the students on 19:56 cait filling up my queue is the plan? :) 19:56 pianohacker cait: translation q 19:52 rangi so students lets see if we can make that list a big shorter by testing and signing off 19:52 oleonard That's a big list :| 19:51 francesca works for me 19:50 rangi does that url work for people? 19:50 rangi http://bugs.koha-community.org/bugzilla3/buglist.cgi?bug_status=Needs%20Signoff&columnlist=product%2Ccomponent%2Cassigned_to%2Cbug_status%2Cshort_desc%2Cchangeddate%2Cbug_severity&list_id=86769&order=changeddate%20DESC%2Cbug_severity%2Cbug_id%20DESC&query_based_on=Needs%20Signoff&query_format=advanced 19:46 rangi https://secure.flickr.com/search/?q=kohacon13 <-- kohacon13 in Reno last year 19:45 aleishaa https://secure.flickr.com/photos/4nitsirk/sets/72157639826342535/ 19:39 rangi https://secure.flickr.com/photos/4nitsirk/sets/72157639826342535/ 19:14 magnuse kia ora as 19:05 magnuse rangi: have fun! 19:03 pianohacker pfffft 19:03 rangi right gotta go back downstairs now for the last day of academy 19:02 rangi pianohacker: https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-ash4/1385436_10201323207815161_1419204447_n.jpg 19:01 magnuse rangi: very cool! 18:59 huginn rangi: The operation succeeded. Quote #289 added. 18:59 rangi @quote add < tcohen> FOSS for the win! 18:58 rangi and get it to a testable state 18:58 rangi magnuse: probably not, we are out of time, but i will collate it together into a branch 18:58 huginn rangi: Quote #73: "<chris_n> owen: try /msg munin identify nick password" (added by owen at 12:38 PM, April 29, 2010) 18:58 rangi @quote get 73 18:58 huginn rangi: downloading the Perl source 18:58 rangi @qyote get 73 18:58 huginn rangi: 1 found: #73: "<chris_n> owen: try /msg munin identify nick..." 18:58 rangi @quote search identify 18:57 huginn rangi: downloading the Perl source 18:57 rangi @qyote get 3 18:57 magnuse rangi: will there be any more work done on 11558 by the students? 18:57 huginn rangi: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). 18:57 rangi @quote add < tcohen> FOSS for the win! 18:57 tcohen FOSS for the win! 18:56 rangi cya tcohen 18:56 tcohen and congrats rangi 18:56 tcohen bye! 18:56 tcohen we'll sort it out sooner or later 18:56 huginn 04Bug 11566: enhancement, P5 - low, ---, oleonard, NEW , Fixing accessibility on OPAC 18:56 rangi magnuse: and also http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11566 18:56 tcohen gmcharlt: thanks, I'm leaving home now, but will try to do more testing on this. My first thought was it was a local problem, but a fresh setup yielded the same results 18:56 magnuse s/us/U.S./ 18:55 magnuse pianohacker: us hackfest? 18:55 huginn 04Bug 11558: enhancement, P5 - low, ---, oleonard, NEW , Collector bug for Academy bootstrap3 upgrading work - Not ready (not even close) for use yet 18:55 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11558 18:55 pianohacker that reminds me, we need to get a good coffee setup for hackfest 18:55 gmcharlt tcohen: once I finish witha meeting I'll attach the patch + more test cases to the bug 18:55 rangi ah yep that goes with this 18:55 rangi trust me, i need about 8 of those 18:54 * magnuse likes the look of this whiteboard: https://secure.flickr.com/photos/4nitsirk/11978868724/in/set-72157639826342535/ 18:54 magnuse lol 18:54 rangi about 6 coffees worth of caffeine 18:54 rangi ah yeah, energy drink 18:54 cait ? 18:53 magnuse mother energy? 18:53 cait yep she does :) 18:53 rangi cait: anitsirk took the photos, she takes good photos 18:53 cait a week of good news 18:53 cait :) 18:53 magnuse :-) 18:53 rangi tweeted it :) 18:53 rangi yep :) 18:52 rangi the students are doing their reports back today, so we will find out 18:52 cait did you see magnuse big news yet? 18:52 wahanui That'll be $1 for the awesome jar, magnuse 18:52 cait rangi: cool photos :) 18:52 magnuse awesome! 18:52 rangi i think every project, drupal, mahara, piwik and Koha got some code into core 18:52 magnuse ooh, that's cool! 18:51 rangi (matthieu the original author (and lead developer still) on the right) 18:50 rangi https://secure.flickr.com/photos/4nitsirk/11978337445/in/set-72157639826342535 <-- piwik 18:49 rangi https://secure.flickr.com/photos/4nitsirk/11979264396/in/set-72157639826342535 <-- the koha team (with francesca missing to the right 18:49 rangi yep they are all 16 or 17 18:48 tcohen she's really young! 18:48 rangi tcohen: emma is on the left https://secure.flickr.com/photos/4nitsirk/11978737674/in/set-72157639826342535 18:48 tcohen gmcharlt: yes, they pass 18:47 rangi the young woman on the left 18:47 rangi then you can thank https://secure.flickr.com/photos/4nitsirk/11978856444/in/set-72157639826342535 18:47 rangi if you like the new dashboard 18:46 gmcharlt tcohen: does the test case pass for you, at least, with the patch? 18:46 * tcohen is puzzled, and gives up 18:42 gmcharlt no, they're in sync for me 18:41 tcohen maybe we broke it recently and you have an old QP file? 18:38 tcohen I just want to move to using QP so we can add our work hours to that 18:37 tcohen that'd be great gmcharlt heh 18:36 gmcharlt ;) 18:36 gmcharlt tcohen: well, turn off the TortureTomas syspref! 18:36 * magnuse waves 18:35 tcohen gmcharlt: for me it doesn't work with QP, no matter which order I choose 18:33 gmcharlt tcohen: I've used http://www.techsmith.com/jing.html in the past 18:33 tcohen how can I upload a screencast? 18:31 tcohen added a couple of authority records, and nothing else 18:31 tcohen gmcharlt: i just did a super-fresh master install 18:28 gmcharlt with or without that patch 18:28 gmcharlt which works for me 18:27 tcohen hmm, i have $sortby: HeadingAsc and QP 18:23 pastebot "gmcharlt" at 127.0.0.1 pasted "tcohen: try this one on for size" (13 lines) at http://paste.koha-community.org/86 18:15 gmcharlt tcohen: one moment, let me check something 18:14 tcohen ok, how should I proceed? fix QP to default to something? 18:13 gmcharlt a-z, z-a, works for me 18:13 gmcharlt only if the sort order is none 18:13 tcohen in the UI 18:13 tcohen I can say the result is "no results" as soon as I enable QP 18:12 tcohen besides the difference between the regression test and the UI handling sorting 18:11 gmcharlt looks like Heading A-Z is the implicit default if there's no op CGI parameter 18:09 tcohen ok, and it happens to be the default, right? 18:09 gmcharlt and it looks like it's sort-order none that doesn't work in QP, specifically 18:08 gmcharlt while the test has the sort order as 'none' 18:08 gmcharlt tcohen: OK, so the difference between the UI and the test is that the UI has sets the default sort order to heading A-Z 18:04 tcohen thanks! 18:03 gmcharlt let me take a look 18:03 gmcharlt ah 18:03 tcohen isn't the unit test enough evidence? 18:03 gmcharlt e.g., main heading vs all headings, contains vs starts with, and so forth 18:02 gmcharlt tcohen: it works for me, but previous experience indicates that knowing exactly what kind of search you're doing would help for the bug report 18:01 tcohen ? 18:01 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11533 major, P5 - low, ---, gmcharlt, NEW , "use" QueryParser breaks authority search 18:01 tcohen can anyone confirm bug 11533 17:45 reiveune bye 17:43 gaetan_B bye ! 17:26 Joubu bye all 17:22 rambutan waves 17:14 * cait waves 16:55 * oleonard hopes donuts were included in the contract 16:55 oleonard magnuse isn't going to have time to buy donuts with all the work they'll have for him 16:53 tcohen Anne Lena Westrum's email to the koha list 16:52 oleonard ? 16:49 rambutan :) don't know that he had anything to do with it 16:49 rambutan looks like magnus is buying donuts this week 16:35 cait bye all 16:23 cait tcohen++ thx :) 16:07 tcohen gotta test it, 16:07 tcohen i thought i had 10908 on 3.12 16:07 cait which will be in 3.12.9 16:07 cait together with 10605 16:06 cait i see that my coworker has added it to our 3.12.7 branch 16:06 cait tcohen: hm do you think 10908 should go into 3.12? 16:05 * cait adds another for being tcohen 16:04 tcohen heh 16:03 * Joubu are sending 2 bonus points to tcohen 15:44 tcohen i think it can be safely signed btw 15:42 Joubu tcohen: ha yes (rebased+bootstrap). I did not see that! 15:41 tcohen Joubu: I fixed a couple of minor problems (rebased against latest 10691), but mostly because I added bootstrap to get bonus points 15:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10987 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Too many 'see also' and 'usedfor/see from' labels occurences 15:40 Joubu tcohen: bug 10987, why did you switch back the status to NSO? 15:35 huginn New commit(s) kohagit: Bug 7143: add another name to the about page <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4e4a33ef5deecc32711092d78d87f2eefe3fbcf5> / Bug 7143: Updating about page and history <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ef7480f362a0286b13e1ba1b99e58c6d2ca7ba72> 15:29 oleonard Look at datatables.inc 15:25 cait oleonard: i remember something about the paging for datatables using multiple variable replacement, something like __PREV__? 15:25 paxed doesn't koha use jQuery? it has placeholder replacement functions, iirc. 15:25 Joubu And it avoids modifying the translate script... 15:24 cait poor emma :( I told her a non working solution. 15:24 cait thin the problem here was probably the tt variable in the message 15:24 Joubu It is not perfect because only 1 placeholder is possible. But it fixes this specific string. 15:22 oleonard ...for suggesting alternative solutions. 15:22 oleonard Joubu++ 15:22 oleonard cait++ 15:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11488 normal, P5 - low, ---, emmaheath.student, Needs Signoff , Untranslatable warning "Are you sure you want to write off ..." 15:21 cait paxed, oleonard: i commented on bug 11488 15:21 paxed no. i'm saying the translator should be able to decide where in that sentence it goes. 15:20 oleonard You're saying that [% format %] needs to be modified somehow to be grammatically correct? 15:18 paxed _("Dates of birth should be entered in this format:")+ " '"+[% format %]+"'"; 15:17 paxed "Päivämäärät pitää syöttä %s -muodossa." 15:17 oleonard I don't see how the example you provide applies to the bugs we're talking about. 15:16 paxed ...sorry? 15:14 oleonard paxed: The goal of the reformatted comment was to remove the requirement that the number must be modified 15:13 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11487 normal, P5 - low, ---, koha-bugs, Failed QA , Untranslatable tooltip "Dates of birth should be entered in the format ..." 15:13 paxed oleonard: re my comment (#5) on bug 11487: let's say the language must add something to the number to make it grammatical. (think: "1st" or "2nd" in english). would that be enough to convince you concatenating strings is very bad for translation? 14:47 cait oleonard: oh, i will put a reminder in my calendar 14:45 oleonard cait: Ask him yesterday. 14:42 tcohen :-P 14:42 cait tcohen: how is work going on the new time machine module? 14:22 tcohen magnuse: it is just a couple of signoffs away :-P 14:17 magnuse that would be neat :-) 14:14 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10942 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Provide a way for package upgrades to update template translations 14:14 * tcohen thinks maybe it is time to check bug 10942 14:13 * magnuse commented on the bug 14:11 magnuse yup, i had that, updating my templates/translation fixed it 14:07 kivilahtio_ I had similar issues today, but it vanished after reloading/refreshing 14:00 tcohen i have seen it in master a while ago, but after a couple of testing for other stuff (I assumed it was a problem with the patches I was testing) the problem dissappeared 13:59 oleonard Anyone else have that problem? 13:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11567 major, P5 - low, ---, koha-bugs, NEW , Shortcut is searching with every keypress 13:58 oleonard Bug 11567 13:30 kivilahtio_ the facets work well 13:30 kivilahtio_ :D 13:29 kivilahtio_ so there is only "Serials" under Locations-facet 13:29 kivilahtio_ When one clicks "show more", "show more" vanishes, and nothing happens!!! 13:28 kivilahtio_ Under locations-facet, we have Serials and show more 13:28 kivilahtio_ I can't believe these bug reports 13:28 kivilahtio_ Locations-facet apparently has something worng? 13:25 jcamins oleonard: I may have been a bit in advance. 13:24 kivilahtio_ it must be boring to read one's own mind 13:24 oleonard jcamins: You're reading your own mind again. Oh wait, except for the coffee part. 13:24 * tcohen remembers how awesome jcamins' cookies are 13:24 jcamins oleonard: I'm getting... "coffee... cookies... fudge... cookies... cookies? cookies? cookies!" 13:24 kivilahtio_ oleonard: jcamins already read my mind regarding the availability facet 13:23 kivilahtio_ tcohen: lemme, see, I have some screenshots around 13:23 * oleonard waits for jcamins to read his mind 13:23 tcohen what problems do u actually have kivilahtio_ ? 13:23 jcamins kivilahtio_: some of the bugs have patches, but if you want to substantially improve facets (for example, making the availability facet work), that could probably be started now, just on top of work that's already been done. 13:21 kivilahtio_ but I gather from this conversation that I should just wait, regarding facet generation 13:20 jcamins kivilahtio_: a lot of painful experience talking about search in Koha. 13:20 kivilahtio_ jcamins: I wonder how you do it. 13:20 kivilahtio_ jcamins: what I find extrememly cool is your capability to read my mind 13:20 tcohen i hope so jcamins 13:19 kivilahtio_ jcamins: looking forward to it :) 13:19 jcamins tcohen: and with luck, by the time kivilahtio_ gets back from vacation, there won't be any calls to ->render() anyway. 13:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9579 major, P1 - high, ---, tomascohen, Needs Signoff , Facets truncation broken for multi-byte characters 13:18 tcohen i was focusing on the effects bug 9579 has (read "the problems we have with facets") 13:17 tcohen jcamins: agreed, that's what 11096 does 13:17 kivilahtio_ jcamins: I think the entities I represent are interested in those things :) 13:17 jcamins No, what we are building has the semantics of facets, but based on the scrollback, kivilahtio_ is planning to read about ->render() so that he can modify the behavior of facets. 13:16 jcamins (in terms of functionality, which is what kivilahtio_ is interested in) 13:16 tcohen you are saying that what we are building does not have the semantics of what one would call facets 13:16 jcamins We could just as easily use a MARC::Record object in that context, and it would make no difference. 13:15 jcamins We parse the result of the render() call to generate facets, but the render() call is not actually a meaningful part of the facet generation. 13:15 tcohen yes, i almost have all those lines in my head since kohacon13 heh 13:14 jcamins C4::Search lines 509-539. 13:14 jcamins Whoops. 13:14 jcamins tcohen: 13:13 tcohen what do u mean? 13:12 jcamins All that does is creates a string that can be parsed using string parsing in Perl. 13:12 jcamins But that doesn't actually generate facets at all. 13:12 tcohen Zoom::Record->render() 13:11 kivilahtio_ tcohen: thank you! I'll look into it when I get back from my holiday week 13:11 * magnuse guesses so too 13:10 tcohen that's how we've been doing it for years I guess 13:10 kivilahtio_ with default configuration? 13:10 kivilahtio_ tcohen: So if I install for git, am I using Zoom::Results? 13:09 tcohen kivilahtio_: when I say "we" i mean the stable source code, not my university's Koha deploy 13:08 francharb :) 13:08 kivilahtio_ good afternoon francharb! 13:08 francharb Good morning #koha 13:08 tcohen there is a problem with multibyte chars in facets that is addressed by 9579 13:07 tcohen heh 13:07 jcamins :) 13:06 jcamins While we do use ->render(), that makes it sound like facets are coming from Zebra. 13:06 kivilahtio_ tcohen: Do you have a separate server for that ? :) 13:06 tcohen we also do that 13:06 jcamins tcohen: better to describe it as "we compute the facets using custom code," IMO. 13:06 tcohen ->render() 13:06 tcohen we use a poorly documented Zoom::Results feature 13:05 kivilahtio_ tcohen: hmm, but you do use facets? 13:05 tcohen we don't currently use Zebra's facets 13:04 kivilahtio_ tcohen: I received some reports that they don't but maybe it is something else on the OPAC's left frame 13:04 petter hehe, I hope so! 13:04 kivilahtio_ petter: I won't :) 13:04 tcohen facets in zebra seem to work great as we saw on kohacon13 13:04 petter You'l be reading zebra manual on the beach, miserable 13:03 kivilahtio_ I don't need to worry about that 13:03 kivilahtio_ well I am going on a holiday this saturday so... 13:02 kivilahtio_ cait: gee? you think so? 13:02 cait kivilahtio_: that's already expired 13:02 cait using zebra's facets instead of having koha make facets... 13:01 cait kivilahtio_: the problem with zebra facetting are well known and there has been a poc at kohacon i think, but i am not sure anyone is actively working on it 13:01 petter zebra it is then! 13:01 kivilahtio_ we are going live 1.1.2014 13:01 petter I see 13:01 kivilahtio_ :) 13:01 kivilahtio_ ASAP 13:01 petter olli, hwen are you going live? 13:01 kivilahtio_ I was hoping I wouldn't have to learn yet another library technology 13:01 kivilahtio_ gotta hit the Zebra book 13:01 kivilahtio_ damn it 13:01 kivilahtio_ lol 13:00 cait kivilahtio_: 6 months after 3.14 ;) 13:00 kivilahtio_ cait: ok 13:00 cait but that's only my impression 13:00 petter in may 13:00 petter http://lists.koha-community.org/pipermail/koha-devel/2013-December/040113.html 13:00 cait kivilahtio_: i think probably less work fixing koha's facets than making solr ready for production 12:59 kivilahtio_ petter: Any idea when 3.16 is due? 12:59 petter i think 12:59 kivilahtio_ 3.16? 12:59 petter coming in 3.16? 12:59 kivilahtio_ I feel we need to work a lot with Zebra to make it work for us and the code doesn't look too nice 12:59 petter I'd rather wait for ElasticSearch 12:58 kivilahtio_ and searches in general 12:58 kivilahtio_ because we are facing LOTS of issues with Zebra facets 12:57 kivilahtio_ but I would like to know how far is solr from being production ready 12:57 kivilahtio_ cait siad it's not production ready 12:57 kivilahtio_ I did 12:57 kivilahtio_ did I already ask here about Solr? 12:54 tcohen heh 12:53 tcohen kivilahtio_: well, a tiny amount then 12:53 petter boss 12:53 petter our boos is brewing, so dont worry about cost! 12:53 petter sure, beer is a big part of the job 12:53 kivilahtio_ tcohen: beer in Oslo is expensive 12:53 kivilahtio_ I would if I could 12:53 tcohen if by work you mean drink lots of beer? 12:51 petter working holiday? 12:51 petter maybe we can work something out:) 12:51 petter hehe 12:51 tcohen heh 12:51 kivilahtio_ :) 12:51 tcohen honeymoon doesn't count, right? 12:51 petter Secret tip: we'll be hiring a koha-perl-ninja soon.. Anyone feel like coming to Oslo? 12:50 tcohen petter++ 12:50 petter :) 12:50 tcohen petter: congratulations! 12:49 kivilahtio_ c u in the other side then 12:49 petter so now we can start actually WORKING on it; rather than endless meetings, workshop, risk-assesments and so on 12:49 kivilahtio_ but good you made it 12:49 petter and the bureaucracy we have 12:48 petter well, this is quite fast actually, for an organization like ours 12:48 kivilahtio_ considering you have been working with Koha for how many years? 12:48 petter haha 12:48 kivilahtio_ I think your library takes the term "shadow IT" to the MAX 12:47 petter So my library now finally and officially has approved of us changing to koha! 12:47 kivilahtio_ patter++ can't type :) 12:46 wahanui it has been said that good news is it looks like it's running properly. 12:46 cait good news! 12:46 cait can't type 12:46 cait petter++ 12:46 cait petter 12:45 petter hi olli! 12:45 kivilahtio_ hi petter! 12:43 petter hi koha! 12:34 magnuse woohoo! 12:34 tcohen magnuse++ petter++\o/ 12:34 wahanui o/ '`'`'`'`'`'`'`'` 12:34 magnuse confetti! 12:30 magnuse w00000t!!! http://digital.deichman.no/blog/2014/01/16/oslo-public-library-chooses-the-free-and-open-koha-integrated-library-system/ 12:21 tcohen too many stuff to qa? 12:21 tcohen how is the qa team doing? 12:14 marcelr np 12:14 tcohen hi marcelr, thanks for signing 12:14 marcelr hi tcohen 12:11 cait magnus: make it 18 hours please 12:04 tcohen morning #koha! 11:12 magnuse woooo that was fun 09:54 paxed cait: UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat'; -- should be Cur_r_ency? 09:42 HB aha more secrets reveiled :) 09:40 magnuse HB: do "man koha-common" for a list of available koha-* commands :-) 09:34 HB thx got it running but just to be sure (thx fr the mail) i would not have found it myself ++++ 09:30 magnuse HB: if you installed with the packages you can do "sudo koha-list" to see all your instances 09:26 HB is there a command to get your intance 09:22 marcelr hi Joubu 09:19 magnuse bonjour Joubu 09:17 Joubu hello 09:15 magnuse paul_p: will do! ;-) 09:09 paul_p magnuse yes, I know. could you ask God to add 12 hours to each day please ;-) 09:08 magnuse paul_p: yup, but some people might need an "official" announcement to refer to, to get the green light to go :-) 09:05 paul_p magnuse nope, it's on my todo list. But date are marc 10-14th 09:04 magnuse paul_p: has the hackfest been announced officially yet? 09:01 magnuse have fun cait! 08:59 cait bbl 08:59 wahanui i think meeting time is always going to favour one section of the globe 08:59 cait ok, meeting time 08:57 cait probably me who messed it up in the first place 08:57 cait if you file a bug somewhere i will take a look later 08:57 cait paxed: i think you might be right, but can't look at the file right now :( 08:57 paxed cait: in commit bbe6497 there's +VALUES( 'Laoo', 'script', 'en', 'Laotisch'); in file installer/data/mysql/de-DE/mandatory/subtag_registry.sql -- that should be 'de', not 'en', right? 08:31 HB hey 08:28 cait hi ashimema :) 08:28 ashimema Mornin' all 08:27 gaetan_B hello :) 08:27 cait hi gaetan_B :) 08:27 cait ah no Joubu yet 08:20 HB annyone has tips ? 08:20 HB Hey koha i try to run build_oai_sets.pl i get Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl /5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/pe rl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./build_oai_sets.pl line 45. 08:19 wahanui i guess any help is appreciated ;) 08:19 alexia any help? 08:19 alexia 10:07:35-16/01 zebrasrv(9) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied] 10:07:45-16/01 zebrasrv(10) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied] 10:07:45-16/01 zebrasrv(10) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied] 08:18 alexia file /var/log/koha/koha-zebra-daemon-output.log 08:18 alexia hello! we have a problem with our koha installation. We had a server crash a couple of days ago, and after we managed to bring it back online, the system does not return any results when searcing bibliographic records or authorities. I have re-indexed the system but still nothing appears. We also get some lock errors on the 07:59 magnuse paul_p: yup :-) 07:56 marcelr hi alex_a 07:56 alex_a bonjour 07:54 marcelr hi #koha magnuse reiveune paul_p 07:54 paul_p hi magnuse. Just read a mail from Arve (oslo p.l.) . Good new ;-) 07:52 magnuse kia ora paul_p 07:50 wahanui kai ora, reiveune 07:50 reiveune hello 07:50 magnuse windchill-- 07:49 huginn magnuse: The current temperature in Bodo, Norway is -7.0°C (8:20 AM CET on January 16, 2014). Conditions: Clear. Humidity: 58%. Dew Point: -14.0°C. Windchill: -18.0°C. Pressure: 30.18 in 1022 hPa (Steady). 07:49 magnuse @wunder boo 07:49 magnuse bonjour reiveune 07:47 * magnuse waves 07:06 cait bbl 07:06 cait time for the dentist... ew. 06:46 dcook thanks again, eythian 06:46 wahanui goodnight dcook. You'll be back. 06:46 dcook night all 06:42 dcook Bleargh. Whatever. 06:37 dcook Maybe one more experiment before the gym.. 06:36 rangi excellent 06:35 eythian rangi: I've found a starman configuration that gets slow under high load, but never seems to run out of RAM. It's all CPU bound now, which is nicer. 06:34 dcook But it's 5:34... 06:34 dcook Oh, but I was going to look at the TT filter... 06:33 dcook And that ampersands get encoded and recoded way too many times in way too many spots.. 06:32 dcook After all that, my conclusion is...grs1 blows. 06:30 rangi yeah gotta be 06:29 eythian yeah, something is munted in hardware. 06:29 eythian ah 06:28 rangi xev sees nothing 06:28 rangi but if i push shift and 1 06:28 rangi state 0x1, keycode 50 (keysym 0xffe1, Shift_L), same_screen YES, 06:28 eythian oh, curiouser and curiouser. 06:28 rangi it all works fine 06:28 rangi yeah the weird thing is in xev if i hit left shift 06:28 dcook eythian++ 06:28 * dcook has no idea what happened in the end, but thinks he has a workable solution? 06:27 eythian it sure sounds like something liquid or otherwise conductive got in there. 06:27 rangi but workable 06:27 rangi bizzare 06:26 rangi i can write #! again 06:26 rangi !! 06:26 rangi yay 06:26 rangi !!!! 06:26 rangi thanks 06:26 rangi cool exclam 06:25 eythian XFilterEvent returns: False 06:25 eythian XmbLookupString gives 1 bytes: (21) "!" 06:25 eythian XLookupString gives 1 bytes: (21) "!" 06:25 eythian state 0x11, keycode 10 (keysym 0x21, exclam), same_screen YES, 06:25 eythian root 0xb6, subw 0x0, time 1023361165, (502,530), root:(2423,602), 06:25 eythian KeyPress event, serial 34, synthetic NO, window 0x3600001, 06:25 dcook Oh wait, I'm an idiot.. 06:25 rangi and tell me what the name is when they push shift+1 06:25 eythian that's my có₥pøśê key 06:24 rangi can someone fire up xev 06:24 dcook That might be why it couldn't dump.. 06:24 dcook My first database appears to have disappeared.. 06:24 rangi i never use that 06:24 rangi good idea there is the menu key over by the right control 06:24 dcook wtf... 06:23 rangi :) 06:23 dcook Hmm that second method got further.. 06:22 eythian map another key you never use to !. Like z, no one needs z. 06:22 rangi xmodmap -e "keycode 66 = Shift_L" 06:22 eythian no not-equals for j00! 06:22 rangi yeah it really is 06:22 rangi but everythign else works 06:22 rangi still cant do a exclamation mark 06:22 eythian rangi: that is totally bizarre 06:21 rangi and i can do that again 06:21 rangi (*()#$&#$#* 06:21 rangi eythian: i remapped capslock to left shift 06:20 dcook But I can dump devtwo but not devone (possibly because of that earlier manual mangling job I did) 06:19 dcook Right. The error said localhost annd there are entries in the user table for localhost as the host as well 06:19 eythian it's not just a user, it's also correlated with where you're connecting from 06:18 dcook Yeah, when i look at the user table, it looks like the koha_ users don't have that many privileges.. 06:18 dcook Huh... 06:17 wahanui yeah that is golded jcamins 06:17 eythian yeah that 06:17 dcook FLUSH PRIVILEGES; 06:17 dcook GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; 06:17 dcook CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; 06:17 dcook CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; 06:17 dcook CREATE DATABASE \`$mysqldb\`; 06:16 eythian have a look at how koha-create does it. 06:16 eythian in particular, I'm not sure you want @'%' 06:16 dcook Seems like it :S 06:15 eythian s/privileges/anything/ 06:15 eythian there's some oddness with the way that mysql does privileges sometimes. 06:14 dcook So I'm wondering why there were those issues with dumping/restoring.. 06:14 dcook " GRANT ALL PRIVILEGES ON `koha_devtwo`.* TO 'koha_devtwo'@'%'" 06:14 eythian what does that mean? 06:14 dcook Hmmm, I think koha_devone and koha_devtwo have full privileges? :S 06:10 cait hi dcook and eythian 06:10 dcook heya cait :) 06:09 * cait waves 06:09 eythian maybe it's something weird 06:09 eythian or see what like 140990 is. 06:09 eythian well in that case, you'll have to grant to the database for the koha user 06:08 dcook When doing " cat dump.sql | sudo koha-mysql newinstance" ? 06:08 eythian hi cait 06:08 eythian you'll have to grant as the root user 06:07 dcook ERROR 1227 (42000) at line 140990: Access denied; you need (at least one of) the SUPER privilege(s) for this operation 06:07 dcook Interesting...that first method didn't work.. 06:06 dcook I'll just start over..sort of 06:06 eythian a grant _might_ take care of it 06:06 dcook Indeed. 06:06 dcook hehe 06:06 eythian because then this happens :) 06:06 eythian well, you shouldn't do that 06:06 eythian yeah, you can't do that 06:05 dcook Because I loaded it up as the root user as the koha user couldn't do it 06:05 dcook Mmm, right 06:05 wahanui hmmm... Interesting is sometimes good and sometimes bad 06:05 dcook Interesting 06:05 eythian then you probably didn't grant access to it 06:05 dcook Yep 06:04 dcook Hmm, perhaps I broke it the first time.. 06:04 eythian unless you've manually created that db 06:04 eythian that's not expected 06:04 eythian sorta 06:04 eythian that is an error from koha then 06:04 eythian oh 06:04 dcook I'm just using koha-dump 06:04 dcook I dumped the same database not that long ago 06:04 eythian are you using the right password? 06:04 wahanui somebody said not sure why was still pulling it 06:04 dcook But not sure why.. 06:03 dcook Yeah, I know. Mysql error. 06:03 eythian (as in, not an error from koha) 06:03 eythian that's not koha 06:03 eythian oh 06:03 eythian hmm 06:03 dcook mysqldump: Got error: 1045: Access denied for user 'koha_devone'@'localhost' (using password: YES) when using LOCK TABLES 06:03 * dcook mutters to himself 06:02 dcook Hmm, that's not good.. 06:02 eythian could do with 2 more cores really. 06:02 eythian I don't think I can squeeze more performance out of this server, but I know it's not going to go down in a flaming heap. 06:01 eythian 978ms per search, not too bad, but you don't want to be doing 10 at once. A mean of nearly 10 seconds per request. 06:01 dcook All right, let's give this a go.. 05:58 * eythian has zebra using 20% CPU and koha using the remaining 180%... 05:57 dcook Oooh :D 05:57 eythian so that's OK 05:57 eythian in the second case, the use fails, but everything else works. 05:56 dcook I was wondering about 'use koha_anothername' 05:56 eythian the first way uses one transaction so the wrong name causes the whole load to abort, the second doesn't. 05:55 eythian there are situations where that may abort (primarily if the dump has 'use koha_anothername'), in which case you can do sudo koha-mysql instance and then use \. to load the dump 05:55 dcook Interesting...I'll give that a shot 05:54 eythian it depends, but generally you can do cat dump.sql | sudo koha-mysql newinstance 05:54 dcook Ideally, that's what I was thinking of doing, but I don't see a place to specify the name of the new instance 05:54 dcook How do you load the dump into a koha-create? 05:53 eythian there's also not much point 05:53 eythian you _can_ but it's probably not a good idea 05:53 dcook Yeah, it sounds mental 05:52 eythian I really wouldn't do that 05:52 eythian my method for that is to do a dump, and then after a koha-create load the dump in. 05:52 dcook Or can you have two instances running off the same DB with different config? 05:52 dcook Well, what I want to do is clone a DB 05:52 eythian It lets you use a pre-existing mysql database instead of creating one 05:51 dcook Actually, I think I do, and it's not what I'm thinking 05:51 dcook Hmm, not sure that I necessarily understand --use-database.. 05:50 eythian it might also have a good --help, some of the scripts do 05:50 eythian dcook: yeah, magnus_away is good for making sure that happens. 05:50 dcook paxed: I think he speaks some Czech 05:50 dcook Ooo the man page for koha-create has been updated. That's handy.. 05:49 paxed do you happen to know if he speaks any other language than english? 05:49 gmcharlt yep 05:48 paxed just out of curiosity, is owen leonard american? 05:48 eythian OK, 2000 requests to opac-detail, 10 concurrent, mean response time 350ms and memory use peaked at about 60%. Now I'm getting somewhere. 05:48 dcook Now what was I doing.. 05:47 dcook In which case, points for seeming genuine! 05:47 dcook Unless you were meaning to mislead me... 05:47 dcook eythian: Your answer might not have been correct, but the spirit was there :) 05:47 eythian it was just gmcharlt, I lied to you :) 05:46 paxed dcook: translation related. 05:46 dcook paxed: Indexing related? 05:46 dcook eythian++ 05:46 dcook gmcharlt++ 05:46 * paxed is getting high blood pressure before 8am... 05:46 dcook Excellent 05:46 dcook Ah, yes 05:46 gmcharlt --biblio-idx 05:46 gmcharlt er 05:46 eythian ah, I remember that now :) 05:46 gmcharlt dcook: and yes -- koha-create --biblio-dix grs1 ... 05:46 dcook Just checked as well. Defo DOM. 05:46 gmcharlt ;) 05:45 gmcharlt see commit aba3db26 (when you're not tortuing a poor, defenseless server, that is) 05:45 gmcharlt eythian: yep, unless you're munging koha-create when you package 05:45 dcook Is there any way to specify grs1 instead? 05:45 eythian gmcharlt: for packages? 05:45 dcook gmcharlt: Thanks. That makes sense. 05:44 dcook No worries, eythian 05:44 * gmcharlt has just looked at it -- the default is indeed DOM nowadays 05:44 eythian I'd look, but I'm in the middle of seeing how far I can push a production Koha server without it falling over, and really don't want it to fall over :) 05:44 dcook I suppose I could just check the files.. 05:43 eythian I don't think so anyway 05:43 dcook Ok, thanks, eythian :) 05:43 dcook Huh... 05:43 eythian no, not yet 05:43 dcook When using Debian packages, are we defaulting to DOM indexing with 3.14? 05:22 eythian starman seems to reap memory more when it's not busy. That's unfortunate. 04:57 dcook pas mal 04:57 dcook 13 minutes! 04:57 eythian hmm, I just hit memory limits with plack on a 3GB machine. This is going to need some tuning. 04:55 dcook I even dawdled at the beginning... 04:54 dcook Not bad 04:54 dcook 10 minutes and I'm at the Koha web installer 04:49 eythian oh, it's in the init script 04:45 eythian rangi: there is definitely a memory leak under plack. Where do you change things like how many requests it does before a restart I want to experiment with it. 04:30 mtompset Well, have a great day (24 hour period), #koha wizzyrea MrAgent075 dac Oak and others. :) 04:16 MrAgent075 wizzyrea: is that alright? 04:16 MrAgent075 wizzyrea: better URL (not temporary :] // http://files.pilcrowsquared.com/koha_128dpi.png) 04:14 mtompset It helps stop floody warnings when you are setting up a library's patron categories. :) 04:13 mtompset Anyone want a simple signoff? :) 04:11 huginn mtompset: The operation succeeded. 04:11 mtompset @later tell cait Remember that loss of currency problem on basket groups? Check out bug 11471. 04:01 MrAgent075 I can't do that... 04:01 MrAgent075 Which is why it should be uploaded to the server that is operating the Dashboard site. 04:00 wizzyrea for the image 04:00 wizzyrea that url is going to be problematic 03:47 pastebot "MrAgent075" at 127.0.0.1 pasted "logo for Koha Dashboard" (23 lines) at http://paste.koha-community.org/85 03:32 francesca goodbyyye! see you/talk to you tomorrow :) 03:30 wizzyrea ohsnap 03:24 francesca you kept going on in the presentation about how the nav bar was awful in design terms, yet your presentation is pretty much entirely purple and orange... 03:23 MrAgent075 #memories 03:22 wizzyrea MrAgent075 is funny 03:20 francesca thanks 03:20 aleisha https://docs.google.com/file/d/0BxgQvS2dQklRc0c2YmpzbHhTeVJLTC1LOU14ZVJReUN6T29n/edit 03:13 francesca chris you also need to do the same thing to .span8 h3 { 03:08 pastebot "francesca" at 127.0.0.1 pasted "changing font for h3" (5 lines) at http://paste.koha-community.org/84 03:07 huginn francesca: Quote #39: "chris <chris> nope, ive made it my aim in life not to learn js or html" (added by ricardo at 06:00 PM, October 07, 2009) 03:07 francesca @quote random 03:03 wizzyrea hm those are somewhere in the git repo as well I think... 03:02 eythian ah good, there is an svg logo 02:58 rangi http://wiki.koha-community.org/w/images/Koha3-staff-client-logo.svg 02:58 rangi MrAgent075: http://wiki.koha-community.org/wiki/File:Koha-logo-black-and-white.jpg 02:57 pastebot "francesca" at 127.0.0.1 pasted "more code for header" (5 lines) at http://paste.koha-community.org/83 02:52 MrAgent075 Now getting onboard the Dashboard Train. 02:49 huginn francesca: Quote #213: "jwagner: There are few problems that can't be solved with patience, ingenuity, and a large kick in the pants (assuming servers wear pants, that is)." (added by wizzyrea at 06:18 PM, August 07, 2012) 02:49 francesca @quote random 02:46 pastebot "francesca" at 127.0.0.1 pasted "font change for header" (7 lines) at http://paste.koha-community.org/82 02:45 rangi ok. we are gonna finish at 4.30 today 02:43 mtompset Out of curiosity, are hypens in an ISBN13 in any particular positions? 02:41 mtompset Yes, which is why it is funny. 02:36 eythian It's the traditional family for palms 02:35 mtompset Arecaceae ... *laugh* 02:29 wahanui facepalm is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity. 02:29 * dcook facepalm 02:29 dcook When comparing two systems that seem to have the same code and the same database...it helps to make sure they have the same indexing configuration 02:20 wizzyrea ohh thanks 02:13 gmcharlt http://librarypolice.com/wiki.koha.org/en:development:frbrlikegroupingandmetasearch.html 02:13 wizzyrea well it's about to become relevant 02:12 * gmcharlt makes no guarantees that it got documented, given the age and relative disused of the feature 02:12 wizzyrea oh, doesn't matter anyway because it's not there. 02:11 * wizzyrea facepalms 02:11 * wizzyrea says, realising that the manual was not consulted 02:10 wizzyrea that, I feel like that is not written down anywhere. 02:09 wizzyrea <3 thank you 02:09 wizzyrea gmcharlt++ 02:09 gmcharlt also see misc/bin/koha-pazpar2-ctl.sh 02:09 wizzyrea yay thank you gmcharlt 02:08 gmcharlt etc/pazpar2/pazpar2.xml 02:07 wizzyrea on an outside chance that anyone knows, what is the config file you start it with for Koha? 02:07 * wizzyrea swears a bit at pazpar2 02:06 mtompset dcook: finally. the bug is signed off. :) 02:04 wizzyrea Ah cool! 02:04 mrx wizzyrea: we have an online bookstore (wheelers.co.nz) and at the moment offering custom developed ebook lending system to libraries but we are evaluating koha for marc record management as a separate solution, if possible 02:02 mtompset okay... just checking. :) 02:02 gmcharlt a larger follow-up you might attach to the bug, and ask the original patch submitter to sign off on your follow-up 02:02 gmcharlt mtompset: yep, that's small enough 02:02 mtompset for example, gmcharlt, there was a string quoting problem. I fixed the string quoting problem, so the patch would do what it was supposed to do. 02:01 huginn 04Bug 11363: minor, P5 - low, ---, koha-bugs, NEW , Label printer profile units are not translatable 02:01 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11363 <-- fair game too for someone 02:01 gmcharlt mtompset: yes, assuming it's a correction, and not, say, a follow-up that completely revamps the patch 02:00 wizzyrea ooh now it's a race ^.^ 02:00 mtompset So, let's say we have a bug, and there's a problem, and I fix it while testing it for sign off. Do I still sign off? 02:00 mtompset Anyways. 02:00 MrAgent075 'additem.pl' had the buttons on the bottom, originally. 02:00 huginn 04Bug 11089: enhancement, P5 - low, ---, oleonard, NEW , Item edit screen should use floating toolbar like cataloging interface 01:59 rangi Roman_: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11089 <-- see if you can fix this 01:59 mtompset Okay. :) 01:59 wizzyrea on the edit bib page. 01:59 wizzyrea mtompset: the thing he is working on is making the add item save button float like the buttons do in cataloguing. 01:59 mtompset well, sometimes pages put things at the bottom, and the content in between varies. 01:58 wizzyrea :) a problem to solve 01:58 MrAgent075 Brill, will keep it at the top... But what about the table? ... :/ 01:57 wizzyrea i.e. at the top, and floating. 01:57 wizzyrea MrAgent075: I think it should closely mirror the cataloguing interface 01:57 MrAgent075 mtompset: like... let's say... if the bar was to appear at the bottom of the screen already? Or that it'd be at the top? I think either option would be sensibly possible. 01:56 mtompset MrAgent075: could it be were someone doesn't have to scroll? -- Just noting my dislike for scrolling. :) 01:52 * dcook shakes his fists and shouts "Double-encoding!!!" 01:49 wizzyrea mrx: hm, yeah that'd do it. What kind of library? 01:48 wizzyrea MrAgent075++ 01:48 wizzyrea ! 01:48 wizzyrea ohhh nice 01:48 MrAgent075 wizzyrea: PROGRESS // The bar in add-item.pl is working & is fixed. Just thinking... Might place it down at the bottom of the page. All-in-all, it is functioning. 01:45 MrAgent075 I wonder how we can create quotes on here... 01:44 huginn francesca: Quote #13: "<atz> ricardo: ask and ye shall receive.... eventually, ye shall stop asking." (added by gmcharlt at 08:31 PM, July 09, 2009) 01:44 francesca @quote random 01:40 mrx thanks wizzyrea: I'm not sure will the scenario fit in real library system or not but at the moment we have different users responsible for handling title descriptions and title subject headings and came across simultaneous record updatation problems 01:40 Roman_ daniel_? 01:39 rangi http://meta.ohloh.net/2013/07/announcing-ohloh-badges/ 01:38 MrAgent075 jcamins: Good way to go - wish I could try them. 01:38 francesca :) 01:37 mtompset francesca++ # dr. who fan and 2 commits in 23 hours 01:37 francesca so do we claim them? 01:36 rangi https://www.ohloh.net/accounts/ranginui 01:36 rangi then you get 01:36 rangi if you claim your commits 01:35 jcamins I decided to do a cinnamon sugar flatbread. 01:35 jcamins MrAgent075: I don't really have much in the way of cheese. 01:34 rangi https://www.ohloh.net/p/koha 01:34 MrAgent075 jcamins: Just alot of Cheese... 01:34 MrAgent075 I haz an idea for pizza jcamins. 01:34 rangi https://www.ohloh.net/p/koha/contributors?highlight_key=first_checkin&time_span=30+days 01:33 rangi everyone else 01:33 rangi francesca: https://www.ohloh.net/p/koha_dashboard/contributors/summary 01:31 francesca :) 01:31 wizzyrea francesca++ 01:31 MrAgent075 Umm... Hmm... Depends on what's available. 01:30 gmcharlt Catalyst_Academy++ # moar prettier dashboard 01:30 francesca pizza! 01:30 MrAgent075 jcamins: I see... :) 01:30 jcamins MrAgent075: I mean, I already made two full pizzas with caramelized onion and goat cheese. ;) 01:29 MrAgent075 Because I can't precisely imagine a pizza worth of anything. 01:29 MrAgent075 I wonder what the conversion equation for pizza worth to kg is... 01:28 jcamins Advice welcomed. 01:28 jcamins I already have two pizzas worth of caramelized onion-goat cheese. 01:27 jcamins I have three pizzas worth of dough left, but no idea what to put on them. 01:26 mrx I'm not sure will the scenario fit in real library system or not but at the moment we have different users responsible for handling title descriptions and title subject headings and came across simultaneous record updatation problems 01:24 huginn MrAgent075: Quote #210: "< oleonard> You could carpet a floor in FIXME's from C4/Search" (added by jcamins at 12:35 PM, July 17, 2012) 01:24 MrAgent075 @quote random 01:20 rangi http://catalogue.bu.univ-rennes2.fr/ 01:18 wizzyrea heh yea 01:18 dcook Hence wanting pianohacker to come along, yes? 01:17 dcook \o/ 01:17 wizzyrea that's what I'm trying to do 01:16 dcook wizzyrea: Yarp. That's partially why I want to test the patch.. 01:16 * wizzyrea suspects that "installing pazpar2"will become relevant when this external searches patch gets in 01:14 mtompset dcook: YAY! I got it tested for steps 5-7. 01:13 wizzyrea get your banjo! 01:13 jcamins wizzyrea: dueling catalogers! 01:12 wizzyrea if you have an example of a workflow where this would be an issue I'm sure we'd be happy to hear it 01:12 wizzyrea even in big systems, it's pretty rare for two librarians to be working on the exact same record at the exact same time. The workflow just generally doesn't work that way 01:11 dcook For there to be mangling that is 01:11 dcook mrx: I've never known it to be an issue, but it's theoretically possible 01:11 mrx dcook: humm ok 01:11 dcook I signed up before I got my personal filing system up and running.. 01:11 mtompset francesca: The site was http://doctorwhomedia.co.uk/ 01:10 * dcook really wonders where his membership doc is now... 01:10 dcook wizzyrea: Agreed 01:10 rangi http://library.waitaki.govt.nz/ 01:10 wizzyrea the library still needs to declare their intentions with your data 01:10 dcook That said, I think you have a point about specifying it in your terms of library membership though.. 01:10 rangi or 01:10 rangi http://ils.stdc.govt.nz/ 01:10 dcook You're signing up to the library 01:10 dcook But when you sign up to the library, you're not signing up to the ILS 01:10 wizzyrea (but I'm not, as it might seem, trying to be actively hostile :)) 01:10 rangi or 01:10 rangi http://opac.library.org.nz/ 01:10 rangi so if you look at this 01:09 * dcook has noticed :p 01:09 * wizzyrea has very strong opinions about it 01:09 wizzyrea any library where a borrower self presents and gives data should be opt-in to any emails that are outside standard ILS operations (overdues, holds, fines) 01:09 dcook There should be though 01:09 yhager we are a very small community library, and we have an upcoming event. We'll do it manually this time, but I'll want to set up some system that will allow people to opt-out. 01:08 dcook mrx: As far as I know, there are no locks. 01:08 wizzyrea a corporate could, because they are presumably employees. 01:07 wizzyrea big no no for a public 01:07 eythian wizzyrea: it totally depends on your situation, a corporate library could do it happily, as could a special-interest one in general. 01:07 yhager eythian: okay, that I can do myself. thought you meant something specific :) 01:07 mrx Another query, if two different users try to update same record at the same time, is it possible to lock the rescord so that other can not edit or some way of managing muliple edits so no change is lost or overwritten? 01:07 eythian https://www.google.com/search?btnG=1&pws=0&q=mail+merge <-- yhager 01:06 yhager eythian: mail-merge? 01:06 * dcook tries to remember if he has a copy of that document somewhere 01:05 dcook Hmm 01:05 * wizzyrea considers that abuse of borrower submitted data. 01:05 wizzyrea that is so wrong, unless you signed something that said it was ok when you registered. 01:05 dcook (They usually look boring anyway) 01:05 dcook Only about workshops though, and they're always during work :/ 01:05 dcook My public library mass emails us :o 01:04 wizzyrea don't do that, unless every single person in your library has opted in. 01:04 eythian report and mail-merge is the best way 01:04 wizzyrea yhager, no. 01:04 yhager is there a way to send mass email to all library patrons through Koha? 01:03 wizzyrea you do not technically have netflix here, no. 01:02 MrAgent075 We have video streaming services, but I'm not sure if Netflix is operating here... 01:02 francesca do we? 01:02 francesca we don't have netflix in nz 01:01 wizzyrea ah yea netflix runs a year behind. If one lived in a place that had netflix. 01:01 mtompset Super foobar to them. 01:01 mtompset No such message for IE. 01:00 francesca what!! thats sad 01:00 francesca "francesca" at 127.0.0.1 pasted "hover link css" (10 lines) at http://paste.koha-community.org/81 you may want to take out the > but see if it works with them first 00:59 dcook Inexplicably fixed issues.. 00:59 mtompset "Doctor Who Media does not fully support Mozilla Firefox." -- oh foobar to them. 00:59 dcook Man...I've had two issues recently where backing up the database and restoring it to dev has fixed issues :S 00:57 huginn eythian: Quote #139: "library_systems_guy: I guess I could put (git-bz) in /usr/games because Koha + git = fun times" (added by wizzyrea at 05:55 PM, May 31, 2011) 00:57 eythian @quote random 00:57 MrAgent075 Man, I'm feeling love from the bots today... :D 00:57 francesca true though 00:56 francesca hahahaha 00:56 wahanui facebook is *not* a universal authenticator! 00:56 MrAgent075 Or Facebook... 00:56 eythian yeah, this ain't twitter :) 00:56 wizzyrea @ makes huginn feel crabby. 00:56 wizzyrea ah MrAgent075 you can leave off the @ :) 00:55 huginn MrAgent075: I've exhausted my database of quotes 00:55 MrAgent075 @wizzyrea: "You can't always get what you want, but if you try sometimes, you get what you need...." 00:55 dcook A place to put his water bottle? 00:55 * dcook gets... 00:55 francesca mtompset if you're looking for a good site to watch doctor who online go to doctorwhomedia.uk 00:54 francesca you may want to take out the > but see if it works with them first 00:54 pastebot "francesca" at 127.0.0.1 pasted "hover link css" (10 lines) at http://paste.koha-community.org/81 00:54 wizzyrea we get fancy coffee and fruit, much more than that is rather stretching it don't you think? 00:54 mtompset What ticks me off is Netflix only has until Season 7 episode 6 with Matt Smith. 00:51 MrAgent075 If that were true, I'd like to see Catalyst 'shouting' their employees (& part-time volunteers) popcorn. 00:50 mtompset wizzyrea++ # nice link! 00:50 francesca nice 00:50 wizzyrea is what I was getting at. 00:50 wizzyrea http://persephonemagazine.com/wp-content/uploads/2013/01/jon-stewart-popcorn11.gif 00:50 francesca lol 00:50 wizzyrea true. 00:50 wahanui well, popcorn is a vital part of any work day. 00:50 wizzyrea popcorn? 00:50 wizzyrea popcorn 00:49 francesca true but we don't actually know that for sure 00:49 mtompset (Amy said it to River) 00:49 mtompset His psychopathic wife, River Song, likely gave "all her regenerations" when we revived him in Nazi Germany. :P 00:49 francesca well he got one anyway 00:48 mtompset Oh, and the Doctor doesn't need to be granted another cycle by the TimeLords. 00:48 mtompset all find and dandy, but David Tennant beats Matt Smith any day. 00:47 francesca does this help? 00:47 francesca in the christmas speical the timelords granted matt smith another cycle or regenerations so peter capaldi is the 12th doctor, but the 13th regeneration 00:47 wizzyrea hrmph. 00:47 wahanui I'm a bot, wizzyrea. Not a popcorn transfer technician. 00:47 wizzyrea get the popcorn 00:46 francesca and the war doctor (john hurt) was counted as a regeneration as well, making matt smith the 11th doctor, but in his final body 00:45 francesca but technically matt smiths doctor was in his last body as the 10th doctor used a regenration to heal himself and kept the same face(the meta crises doctor ) 00:45 dcook Oh, David Tennant...*beams* 00:44 rangi run git status 00:44 rangi if you wanna know what you changed 00:44 emmah yes^^ 00:44 MrAgent075 Agreed. 00:44 wizzyrea ^^ what he said 00:44 daniel_ David is the best doctor 00:44 wizzyrea ^^ what she said 00:43 francesca well matt smith is the 11th actor to play the doctor so we call him the 11th doctor 00:43 wizzyrea ok, now 00:43 mtompset 11th or 12th? The whole war doctor caused a bizarre temporal renumbering, I think. Women should explicitly swoon over David Tennant not over an wibbly wobbly timey wimey mess of a number. :P 00:40 * dcook nods 00:40 wahanui Work is progressing nicely 00:40 dcook Work? 00:39 wizzyrea sorry sorry you're doing work and stuff. We'll stop now 00:39 * dcook hides 00:39 wahanui I love the 11th doctor! 00:39 wizzyrea francesca? 00:39 * francesca waves *back 00:39 * wizzyrea nods 00:38 wahanui somebody said wizzyrea was silly 00:38 aleisha wizzyrea? 00:38 dcook of all the isbns* 00:38 aleisha hahahahahaha 00:38 * francesca waves bacl 00:38 dcook mrx: Searching the 020 using ExtractValue will give you a concatenated string of all the results 00:38 wizzyrea hehehehehe 00:38 wahanui JUST LET ME WORK!!!! 00:38 wizzyrea aleishaa? 00:38 * aleishaa waves 00:38 dcook Hmm? 00:37 wizzyrea that has all of the user submitted reports, yes 00:37 mrx wizzyrea: http://wiki.koha-community.org/wiki/SQL_Reports_Library has all reports or there are some other links too? 00:36 rangi emmah, alexh, Roman_ etc 00:35 wizzyrea because as you have it, it will only come back if you have one ISBN that matches what you've given. 00:35 rangi academy: 11566 is the bug to attach your accessibility stuff too 00:35 wizzyrea mrx ^ 00:34 wizzyrea I think they are all in there - you probably need a LIKE instead of an = 00:32 wahanui Interesting is, like, sometimes good and sometimes bad 00:32 dcook Interesting 00:32 mtompset Ah... I'm at the biblio and using Save button drop down. 00:31 mtompset Because I just trigged an error on MARC non-unicode. 00:31 dcook It's been a little whie 00:31 dcook Using the export bibliographic holdings tool, I believe 00:31 wizzyrea there might be a report for that in the sql library mrx 00:31 mtompset How do you export? 00:31 dcook mtompset: That's odd. 00:30 mtompset The export didn't put out the 999$c. 00:30 mtompset dcook: I think I figured out why I couldn't do steps 5-7 in the bug. 00:30 mrx Do I have to use some different sql query? 00:30 mrx Using Catalog -> search catalog I can search any isbn and it will bring up results even with muliple 020 fields and also apparently search z subfield but while trying to fetch same isbn using sql like 'Select biblionumber from biblioitems where isbn=9781922244024' it is not returning anything. 00:30 mrx Is it possible to search through all isbns using sql? Like isbn listed in 020|z or in case of multiple 020s? 00:29 mrx Hi Guys, I have a couple of queries? 00:27 * wizzyrea hopes pianohacker pops up 00:27 tcohen night #koha 00:25 mtompset There we go. ;) 00:25 wahanui I'M EXCERCISING MY ROBOT RIGHT TO FREE DATA TRANSMISSION 00:25 mtompset shh wahanui 00:24 wahanui okay, eythian. 00:24 eythian no wahanui, shh wahanui is <reply>I'M EXCERCISING \MY ROBOT RIGHT TO FREE DATA TRANSMISSION 00:24 mtompset Mistake, eythian. ;) 00:24 eythian rats 00:24 * mtompset laughs. 00:24 wahanui I'M EXCERCISING eythian's ROBOT RIGHT TO FREE DATA TRANSMISSION 00:24 mtompset shh wahanui 00:24 wahanui somebody said which one was that? The fixed navbar? 00:24 tcohen which one? 00:24 * wizzyrea giggles at wahanui's new trick 00:22 tcohen SELECT biblionumber FROM biblioitems WHERE ExtractValue(biblioitems.marcxml,'//datafield[@tag="999"]/subfield[@code="c"]')<>'' 00:19 mtompset dcook: MySQL query to find a record with a 999$c on it? 00:05 * tcohen overstepped on 9579