Time Nick Message 03:05 Amit_Gupta hi all 03:30 mtompset Have a good day (24 hour period), #koha Amit_Gupta wizzyrea. 03:31 wizzyrea later 03:32 Amit_Gupta heya wizzyrea 03:32 wahanui wizzyrea is desperate to make a snarky reply here, but I'm not feeling very creative :) 06:16 * magnuse waves 06:18 dcook yo magnuse 06:18 * dcook also waves to a quiet cait 06:24 magnuse yo dcook! 06:24 magnuse does kohacon16 voting end today? 06:26 reiveune hello 06:27 * magnuse wonders why @kohails is tweeting about yoga 06:29 dcook Mmm dunno? 06:29 dcook on either count 06:29 dcook yo reiveune 06:30 reiveune salut dcook 06:33 fridolin hie there 06:43 magnuse bonjour fridolin 06:45 * cait waves back and runs off to work 06:56 fridolin bonjour tout le monde 06:58 Joubu hi 06:58 wahanui que tal, Joubu 06:59 alex_a bonjour 06:59 wahanui hi, alex_a 07:09 dcook laters all 07:13 drojf morning #kohaq 07:13 drojf koha even 07:18 drojf magnuse: yes it does, at 12 utc 07:18 drojf then it will only take a week to clean out the cheaters until you all get the results :P 08:01 magnuse drojf: cool :-) 08:05 * cait waves 08:13 * magnuse waves back 08:15 drojf hi cait 09:00 schnydszch hello koha community! 09:01 schnydszch can somebody here knows how to read nytprof? 09:02 schnydszch and interpret so I can adjust what needs optimization 09:16 Joubu schnydszch: Have you read the wiki page? http://wiki.koha-community.org/wiki/Profiling_with_Devel::NYTProf 09:16 schnydszch yes 09:17 schnydszch in fact I already have the nytprof 09:18 schnydszch Filename /usr/lib/perl5/Net/Z3950/ZOOM.pm Statements Executed 0 statements in 0s Subroutines Calls P F Exclusive Time Inclusive Time Subroutine 18 1 1 12.6s 12.6s Net::Z3950::ZOOM::resultset_record (xsub) 12 1 1 457ms 457ms Net::Z3950::ZOOM::event (xsub) 1 1 1 1.86ms 1.86ms Net::Z3950::ZOOM::query_ccl2rpn (xsub) 18 1 1 244µs 392µs Net::Z3950::ZOOM::record_get 20 1 1 97µs 97µs Net::Z3950::ZOOM::connection_error_x (xsub) 18 1 1 93µs 93µs Net::Z3950:: 09:18 drojf schnydszch: maybe use paste for such things, thats better to read 09:18 drojf paste? 09:18 wahanui I eat paste! It's tasty! http://paste.koha-community.org 09:19 schnydszch I see that subroutine resultset_record has a time of 12.6s with 18 calls (?) 09:19 schnydszch http://paste.koha-community.org/73 09:20 schnydszch what flavor is your paste wahanui? 09:20 schnydszch :) 09:22 Joubu schnydszch: you should have a look at bug 13665 09:22 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13665 major, P5 - low, ---, gmcharlt, NEW , Retrieve facets from zebra is slow 09:24 schnydszch so it's a bug? 09:26 schnydszch any advise then on what to do? 09:26 schnydszch I've already optimized the mysql database 09:27 Joubu How did you reach this call? What are you trying do to? 09:28 schnydszch I search for a keyword 09:28 schnydszch a keyword that gives me 245k plus 09:28 schnydszch of records 09:28 Joubu How are the facets calculated? 09:30 schnydszch sorry, how do I know how facets are calculated? 09:31 Joubu grep use_zebra_facets $KOHA_CONF 09:33 schnydszch it hanged when I issued that Joubu 09:35 Joubu Does $KOHA_CONF defined? 09:36 Joubu well, in your koha-conf.xml file, there should be a use_zebra_facets tag, if set to 1, you are using the facets calculated and retrieved from zebra 09:36 Joubu these are correctly calculated facets, but it depends on the number of results 09:36 schnydszch yeah it's one 09:37 Joubu If the tag does not exist or set to 0, you are using the old way: wrong facet but fast 09:37 Joubu schnydszch: ok so it's a known bug, the one I gave you 09:37 schnydszch so if I change to 0, searching will be faster? 09:37 Joubu yes 09:38 schnydszch do i need to reindex this? 09:38 Joubu no 09:38 schnydszch ok I'll try 09:38 Joubu you should def read the description of bug 13665 09:38 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13665 major, P5 - low, ---, gmcharlt, NEW , Retrieve facets from zebra is slow 09:39 Joubu "facets are retrieved from zebra" means use_zebra_facets = 1 09:39 Joubu "the old facet method" means 0 or does not exist 09:50 itsallonfire Good morning. :) I've inherited an old Koha system that I know very little about. It was plodding along nicely until we had a power cut yesterday. Prodding about I think some of the files may have vanished on me. I'm getting "File does not exist: /usr/share/koha/intranet/htdocs/js" pop up in the error log. When I browse to the htdocs folder it contains an intranet-tmpl folder but nothing else. Any thoughts? 09:52 cait schnydszch: less accurate (you want to turn off the number shown behind the facet) but way faster for big collections 09:52 Joubu itsallonfire: What's the Koha version? 09:56 schnydszch thanks Joubu cait but I seemed to messed up with the test server when I deleted all files in tmp, which I should have only deleted the nytprofs 09:56 schnydszch so I'm getting this instead: Software error: Can't call method "do" on unblessed reference at /usr/share/koha/lib/C4/Context.pm line 793. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 89. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. 09:57 Joubu Check the DB conn 09:57 itsallonfire That's a very good question. Is there any way to find that out when it's not running? 09:57 Joubu KOHA_CONF defined correctly, restart mysql/mariadb 09:58 Joubu itsallonfire: grep VERSION kohaversion.pl 09:58 schnydszch a ha the mysql percona server I installed 10:08 itsallonfire I just get "grep: kohaversion.pl: No such file or directory" 10:09 itsallonfire Although the latest set of release notes on the doc folder is for 3.0.5 10:10 cait itsallonfire: can you get into the mysqldatabas? 10:10 cait check if that is still ok? 10:10 cait if you can, this should give you the version: select * from systempreferences where variable = "Version" 10:11 cait if it deleted all the koha things... that sounds really bad 10:14 Francesca essay writing 10:14 wahanui essay writing is evil 10:14 Francesca sigh 10:14 cdickinson evil 10:15 cdickinson wahanui: literal evil 10:15 wahanui cdickinson: huh? 10:15 itsallonfire That vomes back with 3.0402000 10:16 cait hm ok 10:16 cait that's a pretty old version 10:16 cait i think i'd recommend to do a mysqldump first and keep that save 10:16 Francesca itsallonfire: hope your problem gets sorted out but on a totally unrelated note you have an awesome nickname 10:16 itsallonfire Thanks. :D 10:17 cait Joubu: what do you think about reinstalling Koha for itsallonfire - not sure what would be best? 10:17 drojf what cait says. then install latest koha on a test system and try to set up an instance with the db dump. that should upgrade your old stuff and work if the db is ok 10:18 cait but 3.4.2 would be quite a jump in features and appearance i think 10:18 cait from 3.4.2 to a latest 3.20 version that would be 10:18 drojf yes, a lot of new awesomeness :) 10:19 Joubu cait: I think it's time to upgrade, yes :) 10:19 drojf but if it works on a test installation, you know the db is alright and you can respawn koha 10:19 cait true, probably needs to switch to dom too 10:19 drojf or you run into problems. some of which can be fixed 10:19 cait if not frm nozebra to zebra :) 10:20 itsallonfire It's really odd. If I try to browse to it, the server takes me to the phpMyAdmin login page. If I try to log in to that, it takes me to a 404 koha page. 10:20 drojf there was nozebra still in 3.04? :) 10:20 Joubu but if the issue is that some files have been deleted (??), git should be able to restore them 10:20 itsallonfire Pretty sure it uses zebra. 10:20 drojf that sounds like your apache is confused 10:20 itsallonfire As I have to run some command to rebuild it occasionally. 10:20 cait ah ok 10:21 cait i think if the db is not compromised... you will be fine in the end 10:21 Joubu dump it now :) 10:21 drojf yes we are curious :D 10:21 itsallonfire I have dumps of both the koha and kohadata databases. 10:22 cait hm 10:22 cait there should only be one 10:22 itsallonfire fair enough. 10:22 itsallonfire I imagine one was an old test then 10:22 cait yeah, that could be 10:23 Francesca @wunder wlf 10:23 huginn` Francesca: Error: No such location could be found. 10:23 Francesca @wunder wlg 10:23 huginn` Francesca: The current temperature in Wellington, New Zealand is 12.0°C (10:00 PM NZST on September 16, 2015). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 8.0°C. Pressure: 29.98 in 1015 hPa (Steady). 10:23 * cait hands over to drojf ;) 10:23 cait and Joubu 10:24 cait i have to take care of an acq migration data mappig now... *sigh* 10:24 drojf i have to leave in a minute. just looking if i find notes on what i had to do with the sql of an old installation 10:24 drojf i may lurk on the phone if irc works there ;) 10:25 Francesca and i have an essay to write 10:25 Francesca not that I'd be able to help much with this problem anyways 10:25 Francesca but still 10:25 Francesca essays 10:26 drojf itsallonfire: what version of mysql are you on? 5.x? 10:27 drojf my notes were for installing koha 2.2.6 on wheezy :D dealing with the switch to mysql 5.x 10:27 drojf i think that won't be necessary 10:27 itsallonfire 5.1.54 10:27 drojf ok 10:27 drojf that should work 10:27 itsallonfire it's running on ubuntu 11.04 10:28 itsallonfire This whole thing is ancient... 10:28 drojf that could use an upgrade too 10:28 drojf indeed ;) 10:28 drojf not sure how well recent koha works on 11.04 10:29 Joubu Check the hardware before upgrading everything 10:30 drojf probably do a test installation in either latest ubuntu LTS or debian wheezy/jessie 10:30 itsallonfire I could always spin up a new virtual server, bung a new linux install on it. 10:30 drojf i'd recommend that to try the db/test the upgrade 10:31 drojf later #koha 10:32 itsallonfire Righto, I'll give that a bash and report back. Cheers everyone. :) 10:34 drojf seems to work 10:34 drojf irc on the phone that is 10:35 itsallonfire Brucey bonus. 10:37 cait bbl 10:53 itsallonfire Hmm... With my various proddings, I appear to have coaxed it back to life. 10:54 itsallonfire I'm still going to carry on with the test server and the new version. Because frankly I could do with knowing more about it. 10:54 itsallonfire And I don't trust it! ;) 11:05 drojf what did you do to reanimate it? 11:05 Joubu cardiac massage certainly 11:10 itsallonfire I wish I knew. 11:11 itsallonfire After a couple of attempts, I started getting the koha login screen instead of the phpMySql one. The patrons were all there, but I couldn't search the catalogue. 11:12 itsallonfire That happens sometimes, and I run "perl rebuild_zebra.pl -z -b -a" which didn't do the trick on this occasion. 11:12 itsallonfire So I switched it off and on again. ;) 11:13 itsallonfire I may have also threatened the server with the special hammer I keep in there. 11:36 cait hm -z 11:36 cait you shoudln#t need to run that if it was set up correctly 11:37 cait it means only reindexing the newly changed records since yur last index time... which hsould be automated 11:56 cait itsallonfire: if you reinstall koha for testing, make sure you install the packages 11:56 cait packages? 11:56 wahanui well, packages is at http://wiki.koha-community.org/wiki/Debian 11:56 cait itsallonfire: it will make everything in the future easier 11:59 drojf time to close the vote, right cait? 12:00 drojf in a minute 12:00 drojf now? 12:00 wahanui hey now now, sing this corrosion to me 12:01 * magnuse cheers drojf on 12:03 Joubu wait! I forgot to vote several times! 12:03 drojf bad internet, deactivated 12:03 drojf lol 12:04 cait close the vote! 12:04 cait all the votes! 12:04 cait i missed my moment... right? 12:13 magnuse heh, in wavemon, if you press f8 for help, it just says "don't panic" in friendly letters 12:13 misilot how do I check in an issue? I feel like I am missing it somewhere 12:14 misilot or receive* 12:14 marcelr hi #koha 12:15 marcelr drojf++ Joubu++ # 14321 12:27 cait :) 13:03 tcohen morning 13:04 magnuse ¡hola tcohen! 13:04 tcohen hi magnuse 13:05 tcohen hi Joubu 13:06 Joubu hi tcohen 13:07 * cait waves 13:07 tcohen Joubu: it seems you are back :-D 13:07 * tcohen is staring at his queue 13:10 tcohen Joubu: would you prefer to add the option to include items at a set-level? 13:10 cait sounds cryptic 13:12 Joubu tcohen: where? In the conf file? 13:13 Joubu tcohen: What I understood from the discussion was it is better to put it in the conf file 13:13 marcelr hi tcohen magnuse Joubu cait and others 13:13 Joubu we cannot do it in the conf file for set-level 13:13 Joubu tcohen: it could be added later if needed by someone 13:14 Joubu the config file would contain the default value, which could be overwritten by the set-level 13:24 cait i think oai works totally without sets too, doesn't it? so sets are optional? 13:27 tcohen we shouldn't ask for a yaml file, but for yaml content on the syspref 13:30 Joubu yes, defo 13:32 magnuse cait: yup 13:41 tcohen Joubu, marcelr: 14197 definitely fixes the warn, but do we need to handle the transaction inside testbuilder? 13:41 Joubu Since we only use it for tests, I'd say yes 13:42 Joubu Actually it should be moved to DataBuilder or something, and TestBuilder would use it and handle the transaction 13:42 tcohen Joubu: but is always superseded by the test file's transaction handling 13:43 marcelr not always? 13:43 tcohen i'm pushing it, but we could consider just removing it 13:43 tcohen once you write that refactoring you've just volunteered to :-P 13:43 marcelr you could just depend on testbuilder for the transaction? 13:56 huginn` New commit(s) kohagit: Bug 13622: [QA Follow-up] Add unit test descriptions <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=72d9c28bbf2b715fddc684fbb4a8b79c27a9fa49> / Bug 13622: Display a datetime without time in a notice <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cef7cd40ce5b2fe1505245cf232d4338b10eba3e> / Bug 14813: Fix encoding issues on editing help pages <http://git.koha-community.org/gitweb/?p=koha.g 14:06 huginn` New commit(s) kohagit: Bug 14640: 'Cancel Hold' check box on check-out confirmation does not cancel the... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a37b3bb7f76b5ddea7400f5268c592c0cc578a8c> / Bug 14640: Add tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=10820de380695f90fd544b40b52682efcf83a962> / Bug 10005: Inventory - Add an option to not check in items <http://git.koha-community.org/gitweb/?p=koh 14:24 marcelr Failed test 'use Koha::Sitemapper;' 14:46 tcohen unimarc author? 14:56 cait marcelr: nice feature - the reminder notices 14:56 marcelr yes it is 14:57 cait marcelr++ 15:02 tcohen Joubu: do u have a UNIMARC testing env? 15:11 Joubu yes of course :) 15:15 cait hm is there a possibility to send separate DUEDGST for each branch? 15:16 cait all items of one brnach in one notice? and another for the next branch? 15:16 cait what i currently see is that koha uses tha patron home library and includes all items fromall branches in the notice 15:20 drojf we're going to greece :) 15:20 drojf at least i hope i'm going :D 15:21 cait successful_decision_making++ :) 15:22 cait and drojf++ for runnign the vote 15:24 tcohen marcelr: where did u get that error? 15:25 marcelr it is in the jenkins logs 15:25 tcohen ah 15:25 tcohen that was on the 12.04+mariadb node 15:25 tcohen problem solved: i deleted the node 15:25 tcohen :-P 15:26 tcohen no, seriously, there was a missing dependency for the tests 15:28 drojf can we go to greece now? i bet its warmer 15:28 drojf @wunder thessaloniki 15:28 huginn` drojf: The current temperature in Thessaloniki, Greece is 28.0°C (6:20 PM EEST on September 16, 2015). Conditions: Clear. Humidity: 48%. Dew Point: 16.0°C. Pressure: 29.98 in 1015 hPa (Steady). 15:28 drojf want 15:29 barton tcohen: I have a question about some zebra indexes that one of our partner wants to add -- I'd like to know if I can get them into community, or whether I should simply make them custom changes for the library... 15:29 tcohen that's a fair question, what are those indexes? 15:29 marcelr greece++ 15:29 marcelr nice in may or june :) 15:29 barton they want to extend ISSN to include $x for 770, 775, 780, 785, and extend ISBN to include $z for 770, 775, 780, 785 15:30 marcelr have to go 15:32 Joubu "Category MY_CAT is in use. Deletion not possible!", and you get a big button "Delete this category"... hum.. 15:32 tcohen barton: I think it makes sense, but maybe ask on the list 15:32 barton dev list? 15:32 tcohen yeap 15:32 * Joubu wants to click 15:32 barton ok. I'll do that. thanks. 15:33 tcohen Joubu: don't! 15:33 cait barton: not sure that's a good idea 15:33 tcohen you never push a big red button 15:34 cait barton: I think the 7xx are linking fields 15:34 Joubu Well, just got an error :) 15:34 cait if you put them in the same index as issn/isbn - wouldn't that throw off the matching on issn/isbn for imports? 15:35 cait i am not sure if the matching only checks the index or also if the value is in a specific field - joy might now 15:35 barton cait. good point. 15:35 tcohen cait: the field 15:35 wahanui the field is mandatory or not 15:35 barton talljoy ^^ 15:35 cait also an isbn search would find all records linked to it - it woudl be quite unspecific in some cases 15:36 cait maybe a new index? 15:36 cait not sure about their use case 15:36 cait not against indexig it in genral... just not sure about rusing the existing indexes, it might make them 'fuzzy' 15:36 talljoy we are talking about the obscure isbn index on 7xx 15:36 Joubu (it just check a variable that is used in ... another script, c/p is baaad!) 15:37 talljoy that's a good question about the match. 15:37 barton talljoy -- yeah, the question is whether it would affect record matching. any ideas? 15:37 cait hm wonder if this could be handles similar to 001/$w 15:37 barton jinkx. 15:37 cait we have Control-number index for 001 - but the $w that are used with the 001 number for linking are in rcn - record-control-number I think 15:37 talljoy i think....it checks the specified tag in the incoming record against the entire index. so you could match an 'unmatchable' record if the isbn was in 7xx tag 15:38 talljoy in the database 15:38 cait hm that's what i thought, but was not sure 15:38 barton Yeah... I also wonder about ISBN normalization, come to think of it... 15:39 talljoy i think the match checks would help here, but I've never gotten 'match checks' to work on import. 15:40 barton Ok, so at this point, I'm feeling like if we want to add these to separate indexes, we're ok, but adding them to the existing indexes would be messy. 15:40 cait barton: did they specify what they want to do ? :) 15:40 * cait tends to agree 15:42 barton cait: I'm not *really* sure what they're using thos indexes for... I think that they just happen to have ISBNs/ISSNs in the 7XX range tht they want to search on. 15:57 cait @marc 750 15:57 huginn` cait: unknown tag 750 15:57 cait @marc 770 15:57 huginn` cait: Information concerning the supplement or special issue associated with the target item but cataloged and/or input as a separate record (vertical relationship). When a note is generated from this field, the introductory phrase Has supplement: may be generated based on the field tag for display. (Repeatable) [b,c,d,g,h,i,k,m,n,o,r,s,t,u,w,x,y,z,6,7,8] 16:05 Joubu Should we expect 1000 Koha users for the KohaCon16?? 16:05 cait was wondering something similar earlier 16:05 cait could be the biggest one so far :) 16:06 cait well you never know 16:14 drojf how many came to reno? 16:15 drojf i think they had ~400 voted? 16:16 drojf votes 16:17 drojf anyway i hope they have a huge university :D 16:34 Joubu (and good beers) 16:34 Joubu Have a good evening #koha! 16:36 lari Joubu, bug 12426, sorry I didn't find the trailing whitespaces (i didnt get any complaints either)? 16:36 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12426 enhancement, P5 - low, ---, larit, Needs Signoff , Allow resending of emails from the notices tab in the patron account 16:39 lari cait, pending messages are excluded from resend in the notices table. would you like to have it in the ResendMessage() subroutine as well? 16:40 cait hm it might make sense - it wouldn't change something, right? 16:40 cait timestamp maybe, but that is not used anywhere it hink 16:42 lari it shouldnt change anything 16:43 cait because updating pending to pending... :) 16:44 nitz0 hi everybody 16:44 cait hi nitz0 16:44 nitz0 hi cait 16:45 lari yeah, pointless 2 queries ^^ 16:45 lari actually just one since we need to get the message anyway, but still :) 16:50 lari okay it's there :) have a great evening, bye! 16:53 cait bye :) 18:10 * magnuse waves to nengard 18:12 * nengard waves back 18:16 magnuse anyone know if there are tools for translating .po files that run on windows? like poedit or lokalize? 18:25 cdickinson magnuse: poedit is available on Windows - https://poedit.net/download 18:26 tmcmahon magnuse: I haven't tried any, but poedit and others are listed here: http://alternativeto.net/software/better-po-editor/ 18:43 magnuse thanks cdickinson and tmcmahon 20:59 Francesca good morning 20:59 wahanui the only good morning is a dead one 21:00 wnickc gloomy wahanui 21:05 cait hi Francesca and wnickc :) 21:05 Francesca hey cait :) 21:06 wnickc hi cait 22:32 wizzyrea hi 22:37 eythian hi 22:47 Francesca hey wizzyrea, eythian