Time Nick Message 00:04 rangi well that took freaking ages 00:04 rangi but i think i have fixed the translating js 00:28 Brooke_ kia ora 00:28 rangi hi Brooke_ 00:34 space_librarian hey Brooke_ 00:36 Brooke_ :D 00:37 space_librarian :) 01:27 rangi holy crap i actually got the js translating 01:27 rangi http://opac.opus.koha.catalystdemo.net.nz/cgi-bin/koha/opac-main.pl# 01:27 rangi toggle to deutsch and the lists dropdown is now translated 01:36 space_librarian rangi: ++ 01:43 huginn New commit(s) kohagit: Merge branch 'new/enh/bug_5917' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d4f2bde05474bec3bb9534b510d424e2c5e792ed> / Bug 5917 Trying to fix the js parsing for translation <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1c5005beb20962778b28b6a3418fddb0d0c90e5a> / Bug 5917 : Fixing a bug in the results page <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h= 01:44 jenkins_koha Starting build 183 for job Koha_master (previous build: FIXED) 01:53 mtj well done chris! 02:21 mtj have the new *.tt files had any html-tidy type beautification done? 02:21 rangi no, cos that would make it a nightmare debugging 02:21 rangi maybe when we are sure they are working perfectly, we can move stuff around 02:22 mtj ok, very wise, at this stage.... 02:22 mtj *nod* 02:24 jenkins_koha Project Koha_master build #183: UNSTABLE in 39 mn: http://jenkins.koha-community.org/job/Koha_master/183/ 02:24 jenkins_koha * Chris Cormack: Bug 5917 : Fixing a bug in the results page 02:24 jenkins_koha * Chris Cormack: Bug 5917 Trying to fix the js parsing for translation 02:24 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5917 enhancement, PATCH-Sent, ---, gmcharlt, NEW, Switch Koha to use Template::Toolkit 02:39 huginn New commit(s) kohagit: Fix for Bug 6183, "Cancel marked requests" button has become "Renew checked items" <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d00d0721b2898481e148480906502c5445cc4dec> 02:44 jenkins_koha Starting build 184 for job Koha_master (previous build: UNSTABLE -- last SUCCESS #182 22 h ago) 02:49 huginn New commit(s) kohagit: Merge remote branch 'kc/new/enh/bug_5952' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7cfa1ca50938f597ddb21b0a81a0597d60ed06d1> / Follow-up fix for Bug 5952, Shows member relatives in issues list <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=49af98afd7dd0a48605a3d77dcc6b24c9b9b549c> 03:11 huginn New commit(s) kohagit: Fix for Reserves.t allow the tests to run without a logged in user <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=67e3b861819f62d125f40564fe6a7370ee47e219> / Merge remote branch 'kc/new/bug_6162' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a0c815033acd1ba514c2fa812e3e0dcc1858fcc9> / Bug 6162 Fix passing of borrower details to reading history <http://git.koha-community.org 03:23 jenkins_koha Project Koha_master build #184: STILL UNSTABLE in 39 mn: http://jenkins.koha-community.org/job/Koha_master/184/ 03:23 jenkins_koha * Owen Leonard: Fix for Bug 6183, "Cancel marked requests" button has become "Renew checked items" 03:23 jenkins_koha * Owen Leonard: Follow-up fix for Bug 5952, Shows member relatives in issues list 03:23 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6183 major, PATCH-Sent, ---, oleonard, ASSIGNED, "Cancel marked requests" button has become "Renew checked items" on moremember.pl's display of holds 03:23 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5952 enhancement, PATCH-Sent, ---, guillaume.hatt, ASSIGNED, Shows member relatives in issues list 03:23 jenkins_koha Starting build 185 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #182 23 h ago) 03:27 rangi heya AmitG and druthb 03:27 AmitG heya chris 03:28 druthb hi, rangi and AmitG. :) 03:28 AmitG heya druthb 03:45 huginn New commit(s) kohagit: Bug 6188 : Gender not showing in the opac <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c673f6cf4630c49d2adc007875059ff30ddc952a> / Bug 6187 : Fixing template issue with opac-authoritesdetail.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=30ae70897829e1be25ec7759e082180dd6305348> / Fix for Bug 6179, Extra column on fines in staff client <http://git.koha-community.org/gitweb/?p=koha.gi 04:03 jenkins_koha Yippie, build fixed! 04:03 jenkins_koha Project Koha_master build #185: FIXED in 39 mn: http://jenkins.koha-community.org/job/Koha_master/185/ 04:03 jenkins_koha * Colin Campbell: Bug 6162 Fix passing of borrower details to reading history 04:03 jenkins_koha * Chris Cormack: Fix for Reserves.t allow the tests to run without a logged in user 04:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6162 major, PATCH-Sent, ---, oleonard, ASSIGNED, name missing on reading history in opac 04:03 jenkins_koha Starting build 186 for job Koha_master (previous build: FIXED) 04:04 rangi yippie! 04:05 rangi heya Irma and pianohacker 04:06 pianohacker Hey chris 04:10 rangi http://www.dougcurrie.ca/news/75/57/Ministerial-House-Statement---Koha-Integrated-Library-System/ <-- check that out 04:13 space_librarian hooray! 04:19 ibeardslee it even tells you about the footer area 04:36 eythian so this liberty database has some barcodes derived from the biblio ID. Guess what happens when you have two items on one of these biblios... 04:37 rangi liberty is so dumb 04:38 mtj … switch to Koha? 04:39 rangi in the process ;) 04:40 mtj i wonder if thats an setup fail, or a liberty internal fail? 04:43 jenkins_koha Project Koha_master build #186: SUCCESS in 39 mn: http://jenkins.koha-community.org/job/Koha_master/186/ 04:43 jenkins_koha * Owen Leonard: Fix for Bug 6179, Extra column on fines in staff client 04:43 jenkins_koha * Chris Cormack: Bug 6187 : Fixing template issue with opac-authoritesdetail.tt 04:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6179 normal, PATCH-Sent, ---, oleonard, ASSIGNED, Extra column on fines in staff client 04:43 jenkins_koha * Chris Cormack: Bug 6188 : Gender not showing in the opac 04:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6187 major, PATCH-Sent, ---, oleonard, NEW, View full heading in OPAC's authority search broken 04:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6188 minor, PATCH-Sent, ---, oleonard, NEW, OPAC: 'my personal details' tab doesn't show sex 05:50 cait hi #koha 05:59 cait rangi++ 06:03 mtj hmm, ill bumped into a weird bug/error on additem.pl 06:03 mtj line 607 06:04 mtj @values = $itemrecord->field($tag)->subfield($subtag) if ($itemrecord && defined($itemrecord->field($tag)->subfield($subtag))); 06:04 mtj http://git.koha-community.org/cgi-bin/gitweb.cgi?p=koha.git;a=blob;f=cataloguing/additem.pl;h=b2b11929abf6b18478110924dd3841d953fe765b;hb=HEAD#l607 06:04 mtj . 06:04 cait ? 06:05 cait what's the bug? 06:05 mtj $itemrecord->field($tag)->subfield($subtag) does *not* return an @ARRAY? 06:05 mtj Can't call method "subfield" on an undefined value at /home/mason/git/ebc/cataloguing/additem.pl line 607 06:06 cait oh? 06:06 mtj is my error on 3.2.6 06:06 cait it worked for me yesterday on master 06:06 cait oh 3.2.6 - never tried there 06:07 mtj looks like the error happens only sometimes, so far 06:08 mtj hmm, i take that back 06:08 mtj "Or if you think there might be more than one you can get all of them by calling in a list context: 06:08 mtj my @subfields = $field->subfield( 'a' ); " 06:12 rangi cait: if you get a chance i think ive fixed the translating js 06:12 cait testing it right now 06:12 rangi Attach Item should translate 06:12 rangi yay 06:12 cait :) 06:12 cait but my result list in intranet is still broken 06:12 rangi hmmm maybe i missed pushing that 06:12 mtj ooh, ive fixed my bug 06:13 rangi lemme check 06:13 rangi ah yes i did push it 06:14 rangi http://git.koha-community.org/gitweb/?p=koha.git;a=commit;h=2fb5b73e6b51c28d12176d33b051b20c1a48b88a 06:14 rangi results list is working for me 06:14 mtj and… heya cait 06:15 rangi cait: whats the error you are getting? 06:19 cait hi mtj :) 06:19 cait it's gone now - I think I was probably looking at the German templates 06:19 cait sorry! 06:20 cait whoohoo 06:20 cait translation of toolbar looks very good now 06:21 cait xslt still needs some attentio 06:21 cait n 06:25 rangi yep 06:25 rangi but at least got the js working :) 06:25 rangi ill try to do the xslt tomorrow 06:28 rangi i think i fixed 2 other of the bugs you reported too 06:33 cait yes 06:33 huginn New commit(s) kohagit: Merge remote branch 'kc/new/bug_6104' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=97446f86ced2c2d6d4d7a11b97ed81a5a0a25d95> / Bug 6104: Modify item looses branch <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b0374db5ffe1ef15a331eea3fd24b50fe8396b3b> 06:33 cait have to get ready for work - will try to do more testing tonight 06:34 rangi 6190 will be hand too i think 06:34 rangi handy 06:34 rangi cool thanks cait 06:34 cait yep 06:35 cait I had the old bug in my bookmarks - in hope to get there someime :) 06:35 rangi :) 06:41 cait I do that with jquery now - will be very nice to get rid of that 06:42 cait and of the jquery to do the message name translation too - lots of good new things in koha :) 06:42 cait time to go - bbl! 06:44 jenkins_koha Starting build 187 for job Koha_master (previous build: SUCCESS) 06:58 rangi hi magnuse 06:58 magnuse hiya rangi 06:58 magnuse think i finally got bip working - woohoo 06:59 rangi yay 07:00 magnuse :-) 07:10 julian hello #koha 07:11 rangi hi julian 07:13 francharb hello all 07:13 sophie_m hi 07:24 jenkins_koha Project Koha_master build #187: SUCCESS in 39 mn: http://jenkins.koha-community.org/job/Koha_master/187/ 07:24 jenkins_koha Paul Poulain: Bug 6104: Modify item looses branch 07:24 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6104 critical, PATCH-Sent, ---, paul.poulain, ASSIGNED, Modifying an item causes it to lose its branch 07:37 hdl hi all 07:39 kf hi #koha 07:44 * kf waves at Guillaume1 07:45 hdl hi Guillaume1 07:45 Guillaume1 hi 07:45 kf bonjour hdl :) 07:45 Guillaume1 bonjour kf 07:45 Guillaume1 bonjour hdl 07:46 miguelxercode hi all 07:46 miguelxercode hi hdl 07:46 hdl hi miguelxercode hi kf 07:56 kmkale Namaskar #koha 08:01 kf fredericd: around? 08:02 kf @later tell fredericd could you check my permissions for pootle please? I have problems accepting suggestions. perhaps something is missing? 08:02 huginn kf: The operation succeeded. 08:21 magnuse rangi: XXX in kohaversion.pl? http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=kohaversion.pl;h=83304597a15932c28241955ceb83fbf895dc707b;hb=HEAD 08:23 rangi damnit why didnt my test catch that 08:24 rangi will fix now 08:28 huginn New commit(s) kohagit: Bumping database version <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=265167d0c3ab4898c1ac6d19ce8e5ae91ed94078> / 5917 Fix for updating/creating .po files <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c450306d7561d56a3be30e7bbc8362833166625a> 08:28 rangi kf: i have made the translate update work better if you want to try that 08:29 jenkins_koha Starting build 188 for job Koha_master (previous build: SUCCESS) 08:42 AmitG heya all 09:09 jenkins_koha Project Koha_master build #188: SUCCESS in 39 mn: http://jenkins.koha-community.org/job/Koha_master/188/ 09:09 jenkins_koha * Chris Cormack: 5917 Fix for updating/creating .po files 09:09 jenkins_koha * Chris Cormack: Bumping database version 09:14 magnuse BorrowerUnwantedField++ 09:15 rangi hmm anyone from xercode here? 09:16 rangi miguel: are you around? 09:18 miguel yes 09:20 rangi just reading your blog post http://blog.xercode.es/?p=399 09:20 rangi would you be able to do me a favour? 09:21 rangi call it Koha, not KOHA ? 09:21 miguel ok, thank you 09:21 rangi http://www.web2learning.net/archives/4213 <-- explains what a Koha is in Maori and why we chose that for the name :) 09:22 rangi great work at the hackfest! :) 09:25 magnuse and there is even a norwegian flag in the picture, even if it was taken after some of us left... ;-) 09:31 rangi :) 09:48 kf back 09:48 * kf waves to magnuse 09:50 * magnuse waves to kf and #koha in general 09:50 kf rangi: I see you pushed some updates for translation 09:50 rangi yeah try a translate update now 09:50 rangi it was getting all the comments before 10:03 kf all the comments? 10:04 rangi it had stuff like <!-- Search starts here --> 10:04 rangi which doesnt need to be translated 10:05 rangi so it was looking like there was more to be translated than there really was 10:06 AmitG chris: any thing know about svc 10:07 kf rangi: will try, but will have to update the installation on this computer first 10:07 AmitG heya kf 10:07 kf hi AmitG :) 10:11 rangi AmitG: in what context? 10:12 AmitG for authentication 10:14 rangi no 10:23 adnc i don't understand the difference between koha and koha-common? 10:25 rangi from the wiki 10:25 rangi Wait! There are actually two packages here: koha and koha-common. 10:25 rangi koha-common contains all the code and support scripts. It won't give you a koha instance that is up and running on installation, but it does allow you to use koha-create and associated tools to create as many instances as you want. Anything created with this command will automatically be managed by cron jobs, and zebra will work, and so forth. 10:25 rangi koha is similar, but provides a single site. At the moment however, this site can't be managed by the tools that come with the package, and so you will need to set up the cron jobs and zebra for it yourself. See bug 5071 for plans to fix this. 10:25 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5071 enhancement, P5, ---, robin, NEW, Make the 'koha' package set things up so that zebra etc. just work 10:26 rangi wiki page is pointed to here http://debian.koha-community.org/koha/README 10:26 adnc if I use koha-common and you guys release 3.4 will the debian packages also be released and an upgrade possible? 10:26 rangi of course :) 10:26 adnc ;) 10:27 rangi we run all our clients on the packages 10:27 adnc well than ;) 10:27 rangi so just for self preservation we would keep the packages up to date 10:27 adnc rangi, when do you guys plan to release 3.4 10:27 rangi april 22 10:27 rangi 3.4.0 that is 10:27 adnc is that the birthday of guttenberg? 10:28 rangi nope, its 6 months after october 22 10:28 adnc well, thats true 10:28 rangi which is when 3.2.0 was released 10:28 adnc ahh 10:28 rangi major release every 6 months, point release every 1 10:28 rangi so 3.4.1 will be may 22 10:31 adnc the wiki says editing koha-sites.conf but that file does not exist 10:32 rangi After install, edit /etc/koha/koha-sites.conf with details about your site. You may need to create this file. Some example content would be: 10:32 rangi keep reading :) 10:35 adnc i don't understand the variables. for example the DOMAIN should it without the hostname and just the domain.tld? 10:35 adnc and what is INTRAPREFIX, or INTRASUFFIX 10:35 rangi yes for the domain 10:35 adnc DEFAULTSQL? on that path /usr/share/koha/defaults.sql.gz there is no file 10:36 adnc rangi. so if i have library.mydomain.tld i should add there ".mydomain.tld"? 10:36 rangi depends 10:36 rangi if you want library.mydomain to do be your opac then yes 10:36 huginn New commit(s) needsignoff: [Bug 6191] Order Details table not showing modify in basket <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6191> 10:37 rangi the suffix or prefix are what you want you to have appended or prepended 10:37 rangi if you went with -intra 10:37 rangi as suffix 10:37 rangi and went koha-create library 10:37 rangi you would get library.domain for the opac library-intra.domain for the staff site 10:39 rangi and the default sql is if you have some default data you want to be loaded into any koha instance you create 10:40 rangi with koha-common you can have multiple koha on one machine easily u just koha-create as many as you want, you may want to load the same data into all of them (same preference settings etc) you can use the default for that 10:44 adnc rangi, is this information from a wikipage? I wouldnt need to ask here all the time if that is written somewhere 10:44 rangi well the previous questions were all written there, and you asked anyway :-) 10:45 adnc you are talking about the koha-site.conf 10:46 adnc config file question. yes, I should have read the rest ;) 10:46 rangi its a wiki feel free to edit it 10:47 adnc anything to consider with DEFAULTSQL="/usr/share/koha/defaults.sql.gz"? 10:47 rangi ummm 10:47 rangi 22:40 < rangi> and the default sql is if you have some default data you want to be loaded into any koha instance you create 10:47 rangi 22:41 < rangi> with koha-common you can have multiple koha on one machine easily u just koha-create as many as you want, you may want to load the same data into all of them (same preference settings etc) you can use the default for that 10:48 adnc ohh ;) 10:51 tcohen hi rangi 10:51 rangi hi tcohen 10:52 adnc koha-create --create-db kitap 10:52 adnc ERROR 1044 (42000) at line 3: Access denied for user 'debian-sys-maint'@'localhost' to database 'koha_kitap' 10:52 tcohen i'll do some tests today on context::config in memcached 10:53 rangi adnc: did you do this bit less /usr/share/doc/koha/README.Debian 10:53 tcohen is there something specific you'd like to test? 10:53 rangi or koha-common in this case adnc 10:54 adnc i'm just reading README.Debian 10:54 conan hi everybody 10:54 rangi tcohen: anything is fine :) 10:55 tcohen ack 10:55 * rangi needs to go to sleep, meeting the NZ Treasury dept tomorrow morning at 9 10:55 tcohen is there a bug filled for that enhancement yet? 10:56 rangi search for memcached tcohen 10:56 tcohen ack rangi 10:56 tcohen good luck in tomorrows meeting 10:56 rangi thanks 10:56 rangi excuse 10:56 wahanui rangi: High line impedance. 10:56 * rangi goes to bed due to to High line impedance 10:57 rangi ttyl 11:16 pastebot0 "adnc" at 77.20.244.49 pasted "/etc/cron.hourly/koha-common:" (7 lines) at http://paste.koha-community.org/3 11:17 adnc whats wrong with the installation 11:30 adnc rangi, the koha-create did not create the db-tables here. 11:30 adnc can i do this manually? 11:37 adnc and this because I could not load the admin site, since I can not login with the credentials given in the koha-conf.xmo 11:46 magnuse hiya jwagner 11:47 jwagner Hi magnuse 11:53 adnc it says use the username and password given to you by your systems administrator and located in your koha-conf.xml . but these do not work 11:54 kf adnc: perhaps you can try the mailing list or a little later - seems none of the packages experts is around 11:54 kf nz is sleeping :) 11:54 adnc kf, thanks 11:55 adnc demo of koha looks good. but even package installation makes that much trouble 12:01 kf adnc: perhaps following one of the instruction manuals is a bit easier? 12:01 adnc i did 12:01 adnc but thats what happened 12:02 kf I never used the packages - always did it without, so can't help much here 12:04 adnc language_subtag_registry' doesn't exist at /usr/share/koha/lib/C4/Languages.pm line 192. 12:04 adnc this is the error that comes when i try to login 12:04 adnc in the logfiles 12:20 oleonard Hi #koha 12:21 kf hi oloeonard 12:21 kf oleonard even 13:04 huginn New commit(s) needsignoff: [Bug 6186] Change to DOCTYPE declaration causing validation errors <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6186> 13:05 conan does anybody know what are the steps/requirements to have an /installer/data/mysql/es-ES directory? I mean, besides filling it with the proper translations 13:05 conan who calls them? 13:06 kf no more requirements conan, afaik 13:06 kf the templates have to be there once you start the web installer 13:06 kf and it will offer you the sample files for translation when you choose es-ES in the drop down at the beginning 13:07 kf so, before starting web installer - templates must have been created, after that everything just works 13:11 tcohen conan, write bgkriegel@gmail.com 13:11 tcohen he's been working on that and is planning to commit soon 13:12 conan tcohen: thanks, will contact him as soon as I fix my disaster from yesterday, I broke DB! 13:13 tcohen oops 13:13 tcohen on a dev env right? 13:13 gmcharlt good morning 13:13 tcohen hi gmcharlt 13:14 conan kf: you mean the very-very beginning? I did a test install yesterday and it only shown 'en', but there are other languages in the subdir 13:14 kf yep 13:14 conan tcohen: yes, a virtual machine with nothing in it 13:14 kf in the veryvery beginning 13:14 conan gmcharlt: good morning 13:14 kf before running the web installer - after running the other things on command line 13:15 kf or using stable release with template sin different languages already included 13:15 huginn New commit(s) needsignoff: [Bug 6189] renewal warning should say 'renew' not checkout <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6189> 13:15 tcohen conan, do u have the translations created before running webinstaller? 13:15 conan gmcharlt: shuffling the install sql scripts proved to be more work than I thought at first sight 13:25 adnc anyone here who know debian packaged koha? I'm getting errors I pasted above 13:25 gmcharlt adnc: I see no paste 13:26 adnc gmcharlt, mom 13:26 adnc language_subtag_registry' doesn't exist at /usr/share/koha/lib/C4/Languages.pm line 192. 13:26 pastebot0 "adnc" at 77.20.244.49 pasted "DBD::mysql::st execute failed:" (12 lines) at http://paste.koha-community.org/4 13:27 gmcharlt at what point are you seeing this? 13:27 gmcharlt ah, I see 13:27 gmcharlt have you run through the web installer? 13:27 adnc I've deleted the koha instance now. but i could not login to run the webinstaller 13:27 adnc in order to have the db created 13:29 adnc # koha-create --create-db kutuphane 13:29 adnc Koha instance is empty, no staff user created. 13:29 adnc Enabling site kutuphane. 13:29 adnc Run '/etc/init.d/apache2 reload' to activate new configuration! 13:29 adnc Restarting web server: apache2[Thu Apr 14 15:29:28 2011] [warn] _default_ VirtualHost overlap on port 80, the first has precedence 13:29 adnc ... waiting [Thu Apr 14 15:29:29 2011] [warn] _default_ VirtualHost overlap on port 80, the first has precedence 13:29 adnc . 13:29 adnc Starting Zebra server for kutuphane 13:29 adnc this is what I get when creating the instance. the virtualhost warning is because there is a <*:80> instead of < ip_addr:80> 13:31 adnc gmcharlt, do you have any ideas? unfortunately the kohausername and password in the koha-conf.xml does not work 13:37 adnc ok. obviously koha is nothing that can easily be handled. not even packaged stable releases. koha had its chance. enough 13:37 adnc thank you very much community 13:37 gmcharlt adnc: does mysql -D koha_kutuphane -u user -p pass get you into the database? 13:37 adnc yes it does 13:38 adnc no, the newone not 13:43 gmcharlt ok, if you do mysql -u root -p 13:43 gmcharlt and supply the mysql root password 13:43 gmcharlt then do base koha_kutuphane 13:43 gmcharlt does it connect? 13:45 conan tcohen: to your question before: no I don't have my tranlations, but the subdir /installer/data/mysql/ is full with other translations and none of them show up 13:46 adnc gmcharlt, wt does base koha_kutuphane mean? 13:46 wizzyrea that's the name of your database? 13:46 adnc the db koha_kutuphane does exist and i can do a use koha_kutuphane, but the db does not have any tables 13:48 wizzyrea have you run through the web installer? 13:48 huginn New commit(s) needsignoff: [Bug 6192] Path to theme directory scoped incorrectly, causing broken images <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6192> 13:48 kf conan: run perl translate <languagecode> before web installert - it will work 13:48 tcohen conan: i meant template translations 13:49 kf conan: once you have the templates, it will be possible to select the translated files in web installer 13:49 tcohen template translation are needed fot the webinstaller to show you different languages available 13:49 adnc wizzyrea, for the webinstaller I need to login, but the username and password given in koha-conf.xml does not work 13:49 tcohen the translated files (not available for es-ES rigt now) are used then, to fill with some default data 13:50 kf adnc: they should - did you perhaps confuse them with the passwords for zebra? 13:50 wizzyrea ^^ happened to me once 13:50 wizzyrea I forget, what's the default? 13:50 adnc in koha-conf.xml tag <user>kohauser</user> and <password>givenpassword</password> 13:51 adnc if that is not wrong. than it simply does not work 13:52 adnc the only thing that I changed was in /etc/mysql/ the link koha-common.cnf with a file that contains the mysql root username and password 13:52 tcohen the webinstaller needs a valid username/pass with access to the db you created 13:52 wizzyrea did you try the mysql root user and password? 13:53 wizzyrea no, that wouldn't work.. never mind 13:53 adnc wizzyrea for the admin webinstaller 13:53 adnc tcohen, where do i get them? 13:53 wizzyrea i would undo your change in /etc/mysql 13:54 tcohen at some point you where asked for a user/pass for koha to connect to mysql 13:54 wizzyrea it's the only thing you've changed, and probably isn't a common tack. 13:54 tcohen that's what you need now 13:54 wizzyrea tcohen: adnc has indicated that he's using the user/pass as defined in koha-conf.xml 13:54 tcohen i haven't used debian packages so i don't know what the workflow is 13:54 wizzyrea and it's not working 13:55 tcohen wizzyrea, perhaps adnc didn't GRANT that user the needed privileges for that DB 13:55 wizzyrea could be 13:55 adnc but isnt this something that the package does? 13:55 adnc i did not grant anything 13:56 wizzyrea grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; 13:56 wizzyrea in your mysql client 13:56 wizzyrea then try your webinstaller 13:56 wizzyrea the webinstaller creates the tables, which is why you don't have them 13:57 adnc wizzyrea what is the kohadatabaseuser name? 13:57 wizzyrea it's the <user> from koha-conf.xml 13:57 adnc wizzyrea 'kohauser' 13:57 adnc ? 13:58 wizzyrea if that's what is defined in there, yes 13:58 tcohen adnc: inside the 'config' section, <user> and <pass> 13:59 wizzyrea (and it should be noted that the packages are not in the debian apt for a reason: they're really new, and are still undergoing testing, so thanks for helping to test!) 14:00 adnc i can now login with mysql -u kohauser -p koha_mylibrary and the password given in the koha-config.xml but still installer does not allow me to login 14:00 wizzyrea flush privileges; in your mysql client 14:01 adnc no, still no luck 14:02 adnc [Thu Apr 14 16:02:48 2011] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Languages.pm line 193., 14:02 adnc this is what intranet-error.log shows 14:02 tcohen adnc: what's the error the webinstaller shows? 14:03 kf hm I wonder why it says something about Languages.p 14:03 kf m 14:03 adnc Error: Invalid username or password 14:03 wizzyrea um, permissions? 14:03 wizzyrea http://www.mail-archive.com/koha-bugs@lists.koha-community.org/msg01466.html 14:03 adnc wizzyrea, possible but which permissions where? 14:03 wizzyrea looks like there's an open bug for this 14:03 tcohen grant all privileges on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; flush privileges; 14:03 wizzyrea bug 6101 14:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6101 enhancement, P5, ---, robin, NEW, Debian packaging error on koha-create second and next instances 14:04 wizzyrea what's in your apache logs? 14:05 adnc wizzyrea I'm looking 14:06 wizzyrea I wonder what the locale is of your server as well? 14:06 * wizzyrea steals ideas from eythian 14:06 adnc LANG=en_US.UTF-8 14:07 wizzyrea k that shoould be fine 14:07 adnc the webserver logfile named intranet-error.log contains this [Thu Apr 14 16:02:48 2011] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Languages.pm line 193., 14:07 adnc [Thu Apr 14 16:02:48 2011] install.pl: DBD::mysql::st execute failed: Table 'koha_kutuphane.language_subtag_registry' doesn't exist at /usr/share/koha/lib/C4/Languages.pm line 192. 14:09 wizzyrea just curious, what version of debian are you using? (I missed it if you said earlier, sorry( 14:11 gmcharlt adnc: I have an idea; could you paste the contents of /etc/koha/koha-sites.conf ? 14:13 gmcharlt in particular, is there a line like this: 14:13 gmcharlt DEFAULTSQL="/usr/share/koha/defaults.sql.gz" 14:20 adnc gmcharlt, sure, 14:20 adnc DEFAULTSQL="/usr/share/koha/defaults.sql.gz" 14:20 adnc and that file does not exist 14:21 pastebot0 "adnc" at 77.20.244.49 pasted "DOMAIN=".mydomain.org" INTRAPO" (5 lines) at http://paste.koha-community.org/5 14:27 wizzyrea does anyone know if III z targets still don't work in 3.4? 14:28 wizzyrea I haven't checked, thought I'd ask first 14:29 wizzyrea righto: I'll check some :) 14:37 adnc gmcharlt, whats your ide? 14:42 gmcharlt adnc: I'm running through a package install on a fresh VM 14:42 gmcharlt the error messages you're seeing in the logs just indicate that the tables haven't been created yet 14:43 gmcharlt but if you're supplying to the web installer the same user name and password that you are using to successfully connect using the mysql command-line client 14:43 gmcharlt that is the one it's looking for 14:46 tcohen gmcharlt: is there a way to know if everything went ok with new Cache::Memcached ? 14:46 tcohen i mean Cache::Memcached->new() 14:46 kf wizzyrea: about reports - permissions perhaps? 14:47 kf wizzyrea: I think someone said there was a problem with permissions in template toolkit 14:47 wizzyrea no, I tried it again and it worked fine, 14:47 wizzyrea the first time I did it 14:47 wizzyrea I was superlibrarian 14:47 wizzyrea the first time I did it 14:47 kf oh 14:47 wizzyrea it showed a blank screen 14:47 wizzyrea then "report saved" 14:47 kf oh 14:47 wizzyrea which seemed odd 14:47 kf yep 14:47 wizzyrea then I did it again 14:47 wizzyrea and it worked? 14:47 wizzyrea so... 14:48 wizzyrea I don't know if there's a bug there or not? 14:48 wizzyrea and I really must test owen's patch 14:49 tcohen has anyone played with Cache::Memcached and has any thought on error handling? 14:50 tcohen has anyone played with Cache::Memcached and has any thought on error handling? 14:51 hdl tcohen: I played with that. But did little on error Handling 14:56 gmcharlt @later tell tcohen it's meant to be transparent; if the memcached server falls over, it shoudl soldier on regardless; in any event, the stats method probably can indicate if somethign is alive 14:56 huginn gmcharlt: The operation succeeded. 14:58 tcohen has anyone played with Cache::Memcached and has any thought on error handling? 14:58 gmcharlt tcohen: umm, your repetition is getting a bit annoying; anyway, did you get the @later message I just sent? 14:59 tcohen i'm sorry, i'm having network issues right now 14:59 tcohen i was reading you right now gmcharlt 14:59 tcohen thanks 14:59 kf wizzyrea: testing++ wizzyrea++ :) 15:02 Oak \o 15:03 gmcharlt @later tell adnc well, I just ran through the process; if you're taking the username and password from the <user> and <pass> elements in the <config> section of koha-conf.xml, it works for me 15:03 huginn gmcharlt: The operation succeeded. 15:54 NCAR Hey guys, I need some SQL Reports help... 15:54 NCAR I need number of items currently checked out at a particular shelving location 15:59 wizzyrea NCAR: one sec :) 15:59 gmcharlt NCAR: select count(*) from items join issues using (itemnumber) where location = 'location_code'; 15:59 wizzyrea ^^ what he said 15:59 wizzyrea gmcharlt++ #so fast! 15:59 gmcharlt better version in a sec 16:00 NCAR k 16:01 jwagner gmcharlt, shouldn't you select from issues rather than from items, to only get the things that are currently checked out? 16:02 jwagner select count(*) from issues LEFT JOIN items on (issues.itemnumber = items.itemnumber) where items.location = 'CODE' 16:02 gmcharlt no, not a left join 16:02 wizzyrea left joins = evil 16:02 * jwagner gets lost on the joins.... 16:03 gmcharlt left join would apply if the report potentially included items that may or may not be on loan 16:03 NCAR that seemed to work. gave me a reasonable number (109) 16:03 NCAR thanks! 16:04 wizzyrea if you'd like to make your report multifunctional, you can use parameters: 16:04 wizzyrea http://koha-community.org/documentation/3-2-manual/?ch=x15127#runtimefaq 16:04 wizzyrea so you can have one report and run it for any location 16:04 wizzyrea :) 16:04 NCAR ah, cool! 16:04 NCAR thx 16:04 NCAR i'll investigate 16:04 wizzyrea (if you're using the created from sql reports within koha) 16:05 wizzyrea (that won't work directly against the DB, of course) 16:10 adnc gmcharlt, sorry, I lost my network for some minutes. did I miss any ideas? 16:12 adnc can someone please tell me if this option DEFAULTSQL does need to point to a valid file? 16:12 gmcharlt no, it doesn't for a fresh install 16:13 gmcharlt it is sufficient to just run the webinstaller using the username and password found in the <user> and <pass> elements in koha-conf.xml 16:13 adnc gmcharlt, i did this many many times 16:14 adnc am i right that i need to simply call mylib-admin.domain.tld and the webinstaller will come 16:14 gmcharlt yes 16:14 adnc http://mylib-admin.domain.tld/cgi-bin/koha/installer/install.pl 16:14 adnc ok 16:14 wizzyrea that should be... you don't have a 2nd, standard install hiding somewhere, or a 2nd koha-conf.xml? 16:15 adnc wizzyrea, not that I know. it is my first installation on that server 16:15 wizzyrea k thanks, what version of debian again? 16:15 wizzyrea lenny or squeeze? 16:15 adnc it used to be lenny, i upgraded yesterday to squeeze 16:15 wizzyrea k cool 16:16 adnc is it a common username 'kohauser'? 16:16 gmcharlt NCAR: the improved version would be 16:16 gmcharlt select count(*) from items join issues using (itemnumber) where location = <<Location|LOC>> 16:21 gmcharlt NCAR: in case you missed it: 16:21 gmcharlt select count(*) from items join issues using (itemnumber) where location = <<Location|LOC>> 16:21 NCAR this one's better than the last one? 16:21 gmcharlt yes, because when you run it, it gives you a drop-down and lets you select the library 16:22 NCAR ah, i see 16:22 wizzyrea ^^ extremely handy 16:22 NCAR new question 16:22 NCAR what SQL would give me circulation activity at a particular location since a given date 16:22 wizzyrea reports library? 16:23 wizzyrea boo no wahanui! 16:23 oleonard wahanui is here. Slacking? 16:23 wizzyrea http://wiki.koha-community.org/wiki/SQL_Reports_Library 16:23 wizzyrea totally slacking! 16:23 wizzyrea wahanui: reports library? 16:23 oleonard wahanui: reports library? 16:23 wahanui bugger all, i dunno, wizzyrea 16:23 wahanui i don't know, oleonard 16:23 NCAR i looked at the reports library and i see 16:23 wizzyrea reports library is found at http://wiki.koha-community.org/wiki/SQL_Reports_Library 16:23 oleonard wahanui: What do you know? 16:23 wahanui bugger all, i dunno, oleonard 16:24 wizzyrea reports library? 16:24 wahanui reports library is found at http://wiki.koha-community.org/wiki/SQL_Reports_Library 16:24 wizzyrea there we go 16:24 NCAR previous month's checkouts, but where would i stick the LOC code 16:24 gmcharlt adnc: the username woudl be koha_<whatever the site you entered is> 16:24 gmcharlt and just to be clear, the koha-conf.xml I'm referring to would be in /etc/koha/sites/<sitename> 16:24 adnc gmcharlt, I'm using 'kohauser' all the time 16:24 oleonard Someone conked wahanui on the head. Conk him a second time so his memory will come back. 16:24 adnc yes 16:24 wizzyrea conk wahanui 16:25 gmcharlt adnc: well, there's your problem; koha-create uses a specific pattern 16:25 gmcharlt for user names 16:25 gmcharlt and wouldn't be generating 'kohauser' 16:25 wizzyrea there really needs to be a bot thingie that does something when you say "conk X" 16:25 adnc gmcharlt, but I took the name that what between the <user> tags, which is "kohauser" 16:26 adnc <serverinfo id="biblioserver"> 16:26 adnc <ccl2rpn>/etc/koha/zebradb/ccl.properties</ccl2rpn> 16:26 adnc <user>kohauser</user> 16:26 adnc <password>cbbcsuud</password> 16:26 adnc </serverinfo> 16:26 gmcharlt adnc: look further down in the file 16:26 wizzyrea oh that's the zebra user/pass 16:26 gmcharlt you want the one that is in the <config> section 16:26 gmcharlt it should fall in the last 25 lines or so of the file 16:27 adnc with the same information there is <serverinfo id="authorityserver"> 16:27 wizzyrea keep going 16:27 wizzyrea down down down 16:27 adnc ok in the config 16:28 adnc I can't believe it 16:28 adnc I'm really sorry for that much trouble 16:28 gmcharlt no worries 16:28 adnc it is the one in the config section, which I oversaw all the time 16:29 adnc I'm really sorry 16:29 wizzyrea NCAR: replace items.ccode with items.location 16:29 wizzyrea as a general rule 16:29 wizzyrea adnc: all good, glad we got it figured out 16:29 gmcharlt NCAR: e.g. in http://wiki.koha-community.org/wiki/SQL_Reports_Library#Previous_Month.27s_Checkouts.2FRenewals_by_Collection_Code 16:29 adnc thank you very much! 16:30 gmcharlt replace 'items.ccode' where it occurs with 'items.location' 16:30 NCAR ok, trying that... 16:30 gmcharlt or what wizzyrea said :) 16:30 wizzyrea haha great minds :) 16:35 NCAR ok, i did that, and also added 'AND where location = <<Location|LOC>>' 16:35 wizzyrea adnc: i am sure that same thing tripped me up too when I first started. 16:35 NCAR i adjusted '1 month' to '2 month' 16:36 NCAR it gave me a number which i suppose could be realistic (21), so maybe it worked. 16:36 adnc wizzyrea there are so many user, password tags in the xml that I oversaw them simply. it is my fault. and when i asked here, probably people thought i replaced the username 16:36 NCAR and it prompted me for LOC before running, which was cool 16:36 adnc in order to hide it. 16:36 wizzyrea :D 16:36 adnc i would like to ask if 3.02.06.000 does for sure not have the opac privacy option in order to secure my opac 16:39 oleonard adnc: Do you mean the OpacNotPublic option, requiring all users to log in to use the OPAC? 16:39 adnc yes 16:39 adnc i did not know that option name 16:39 adnc thanks 16:39 adnc unfortunately my version does not have that option 16:40 wizzyrea i'm looking at 3.2.5 16:40 wizzyrea and I don't see that one either 16:41 wizzyrea but it doesn't exist in 3.4 either 16:41 wizzyrea so 16:41 wizzyrea oh oh 16:41 wizzyrea its OpacPUvlic 16:41 wizzyrea OpacPublic 16:42 oleonard Oh right, because no negative sys pref names 16:42 wizzyrea enable/disable koha opac as public. Private opac requres authentication before accessing the opac 16:42 wizzyrea authentification, even, hehe 16:42 wizzyrea adnc: look for OpacPublic 16:42 * oleonard confirms it's not in 3.02.06.001 16:43 wizzyrea ah, yea, it's not is it 16:43 wizzyrea I thought that had been around a while 16:44 cait hi all 16:44 oleonard It just missed the feature freeze for 3.2 I think 16:44 wizzyrea oooooh 16:46 wizzyrea so yea, it's been around a while, but not in 3.2 16:48 NCAR Ok, I'm back with yet more SQL Reports difficulties... 16:48 wizzyrea :) 16:48 wizzyrea you can just stay and hang out, we don't mind :) 16:48 NCAR what's the best way to share with you the code I've got 16:48 wizzyrea paste.koha-community.org 16:48 NCAR right 16:48 wizzyrea remember to hit the "channel" drop down 16:48 wizzyrea so it posts it here automagically 16:49 wizzyrea very handy that 16:49 pastebot0 "NCAR" at 128.117.174.160 pasted "Checkouts since date @ LOC" (5 lines) at http://paste.koha-community.org/6 16:50 NCAR ok, so i changed the 1 month to 2 month, hoping that that would give me total checkouts since 2 months ago 16:50 NCAR result: 21 16:50 NCAR then i changed it to 3 month and it spit out 13 16:50 NCAR the number should grow as i go back in time 16:50 NCAR or is it giving me checkouts for a 30 day period? 16:51 cait hm no 16:51 cait like .... 16:51 wizzyrea circs for 3 months ago maybe? not 16:51 wizzyrea cumulative 16:51 cait yep 16:51 cait not cumulative 16:51 wizzyrea so that's a little misleading 16:51 cait for the month 3 months ago 16:51 wizzyrea you can be explicit about the date 16:51 NCAR ok, i see 16:51 NCAR right 16:52 cait like 2011-03* 16:52 cait or something 16:52 wahanui something is broken in ht elayout 16:52 wizzyrea lol 16:52 wizzyrea wahanui: forget something 16:52 wahanui wizzyrea: I forgot something 16:52 cait wahanui: forget something 16:52 wahanui cait, I didn't have anything matching something 16:52 NCAR how would i edit so that it adds all circs since a date until today? 16:52 * wizzyrea high fives cait 16:52 wizzyrea sec 16:52 * cait high fives wizzyrea 16:53 * cait thinks it's ab it of a strange way of date comparison 16:53 wizzyrea there's an example of explicit dates in the report library somewhere... I always have to look it up lol 16:53 NCAR ideally, it would use runtime parameter and ask for LOC as well as DATE to start at. 16:53 cait ye 16:53 cait s 16:53 wizzyrea sure 16:53 cait I have done that before, let me look it up 16:53 wizzyrea youc an do that 16:53 NCAR or maybe even a date range 16:53 wizzyrea <<Starting Date|date1>> 16:54 wizzyrea <<Ending Date|date2>> 16:54 wizzyrea for the value 16:54 wizzyrea dates are in format yyyy-mm-dd 16:54 cait hm, it's in a file on my work computer... 16:54 cait hmpf 16:54 wizzyrea hmpf 16:55 NCAR so, that would go somewhere in this line? 16:55 NCAR WHERE (statistics.datetime LIKE concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%'))) 16:55 cait I think this whole like concat thing is weird 16:55 cait there are better ways to do that 16:56 cait we want all since date x, right? 16:56 NCAR yes 16:56 wizzyrea AND statistics.datetime >= <<Start Date|date1>> 16:56 wizzyrea AND statistics.datetime <= <<End Date|date2>> 16:56 wizzyrea that could be totally wrong 16:56 wizzyrea heh 16:56 NCAR ok. and deleting what from WHERE (statistics.datetime LIKE concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%'))) 16:57 wizzyrea right... do note I haven't tried it 16:57 NCAR k 16:57 wizzyrea that should give you a box to type in 16:57 wizzyrea for the dates 16:57 wizzyrea remember the format :) 16:57 wizzyrea leave the where 16:57 wizzyrea get rid fo the first and 16:57 NCAR WHERE statistics.datetime >= <<Start Date|date1>> AND statistics.datetime <= <<End Date|date2>> 16:57 NCAR like this? 16:57 wizzyrea yes, like that :( 16:57 wizzyrea :( 16:57 wizzyrea agh 16:57 wizzyrea lol 16:57 NCAR ok, i'll try 16:58 wizzyrea no frowning. 16:58 wizzyrea i wonder if you'd have to go all the way down to the timestamp 16:58 wizzyrea ok, afk, lunch (sorry) 16:58 wizzyrea bbl 16:59 cait NCAR: does it work? 17:00 NCAR runtime param doesn't work right 17:00 NCAR gives me dropdown with no options and no way to enter date 17:00 NCAR pasting me code... 17:00 pastebot0 "NCAR" at 128.117.174.160 pasted "Checkouts in date range @ LOC" (5 lines) at http://paste.koha-community.org/7 17:01 cait hm try without the |date1 part 17:01 cait and enter your date manually 17:01 cait in the formYYYY-MM-DD 17:02 NCAR ok 17:04 NCAR a HA 17:04 NCAR it seems to be working! 17:04 cait cool! 17:04 NCAR number increase as i bring start date back 17:04 gmcharlt yay 17:05 NCAR thx y'all! 17:05 cait hi gmcharlt 17:05 gmcharlt hi cait 17:05 cait :) 17:17 tcohen gmcharlt: is there a way to use conditionals for processing koha-conf.xml during install? 17:18 gmcharlt tcohen: I think I know what you mean, but what are you trying to accomplish? 17:18 tcohen I want to add two setenv lines in koha-httpd.conf 17:18 tcohen depending whether the user chose to use memcached or not 17:19 tcohen something similar to pazpar2_toggle_xml_{pre,post} I think 17:20 tcohen I see I need to hook rewrite-config.PL 17:23 tcohen gmcharlt: 17:23 tcohen if ("__USE_MEMCACHED__" eq 'yes') { 17:23 tcohen $configuration{'__MEMCACHED_COMMENTED__'} => ''; 17:23 tcohen } 17:23 tcohen (default to #) 17:24 gmcharlt why not just let the memcached settings be blank if a user hasn't specified using memcached? 17:26 tcohen to reduce the number of objects creation and evaluations in C4::Context->new() 17:26 tcohen i'm setting memcached vars in apache's ENV 17:26 tcohen if it is not set, then skip memcached stuff 17:27 tcohen otherwise, I need to evaluate if new Cache::Memcached yielded an incomplete object, etc 17:28 tcohen i'm trying to reduce footprint, so it is worth the trouble, i think 17:29 conan gotta run, bye all 17:37 * chris_n wonders why FF's plugin container is consuming >75% of cpu resources 17:38 cait flash? 17:38 chris_n seems to be 17:39 gmcharlt tcohen: that's *way* premature optmization, IMO 17:39 chris_n google uses it gratuitously 17:39 tcohen gmcharlt: in what way 17:39 tcohen ? 17:39 chris_n ditching both google and FF may actual make me more productive in many ways :-) 17:40 gmcharlt tcohen: biggest immediate win would be splitting the part of koha-conf.xml used by Zebra from that used by (most of) Koha's Perl code 17:41 gmcharlt to quibble over the memcached settings would produce an insignficant gain in parsing the configuration file at the cost of making the memcahed options hidden 17:42 tcohen so you think the gain is insignificant 17:43 tcohen i think i'll post the patch so we can do stress tests on that 17:43 tcohen and maybe we throw the patch away if is not worth it 17:54 gmcharlt tcohen: I am quite positive that extra code to remove two lines from koha-conf.xml is not worth it 17:55 gmcharlt I not, of course, talking about the utility of memcached in general, which does provide obvious performance improvements 17:55 gmcharlt and since we *want* people to use memcached, hiding the config options from koha-conf.xml will make it less likely that it will be used 17:55 tcohen oh, i think because of my spanish to english translation we are misscomunicating 17:56 tcohen i attached to my new bug code for C4::Context to store and use koha-conf.xml info into memcached 17:56 cait rangi: around? 17:57 tcohen the "hiding" is that I moved configuration variables to koha-httpd.conf 17:57 tcohen and wanted them to be hidden (commented out actually) 17:57 tcohen if not in a memcached setup 17:58 tcohen gmcharlt: is bug 6193 17:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6193 enhancement, PATCH-Sent, ---, tomascohen, NEW, Use memcached cache koha-conf.xml configuration variables 18:00 tcohen if you can take a look at the patch, perhaps the code will speak for itself 18:00 gmcharlt tcohen: it does 18:01 tcohen (it still can be useless :-D) 18:01 gmcharlt assuming the SetEnv MEMCAHED_SERVERS "" is accepted by Apache, and I believe it is 18:01 gmcharlt wouldn't need to comment it out 18:02 gmcharlt just set it to the empty string 18:03 tcohen ok, and 'if ($servers)' will evaluate to false 18:04 tcohen how do I create a new patch against master so it is not a follow up 18:04 tcohen ? 18:05 gmcharlt git rebase origin 18:05 gmcharlt then patch 18:05 gmcharlt then git rebase -i to consolidate the patch 18:05 gmcharlt and submit the new versin 18:06 tcohen by 'then patch' you mean git am patchfile? 18:15 wizzy_lunch lol, urg, manual reading fail for me. cait++ 18:17 tcohen gmcharlt: git rebase -i origin and tell to squash the commit, this is great! 18:17 gmcharlt tcohen: you have the power! 18:17 gmcharlt use it wisely, and never for evil! 18:17 gmcharlt ;) 18:18 tcohen this is an glorious day 18:18 wizzy_lunch hehe 18:21 cait wizzy_lunch? 18:24 wizzyrea reports library? 18:24 wahanui reports library is, like, found at http://wiki.koha-community.org/wiki/SQL_Reports_Library 18:25 wizzyrea cait? 18:25 wahanui cait is a competent programmer AND really sweet. 18:25 * cait is confused 18:25 wizzyrea for helping that guy with his parameters 18:25 cait ah 18:25 cait sure 18:25 wizzyrea i forgot that if you're not using the auth val you don't need the | bi 18:25 wizzyrea bit 18:26 cait a date option would be very cool though 18:26 wizzyrea very extremely 18:26 wizzyrea i'm also working on updating the reports on a new page for 3.2 reports that incorporates the parameters where it can 18:26 wizzyrea for much nicer copy/paste 18:27 huginn New commit(s) needsignoff: [Bug 6193] Use memcached cache koha-conf.xml configuration variables <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6193> 18:31 cait wizzyrea++ 18:32 wizzyrea omg, when did we get "run this report" on the saved sql report pages?!?!?! 18:32 cait hehe 18:32 wizzyrea and who do I give karma to for that treat of a tiny but epic enhancement 18:32 cait short before feature freeze 18:32 cait catalyst 18:32 wahanui catalyst are funding template refactoring 18:32 wizzyrea catalyst++ 18:32 cait nots ure about the developer 18:33 cait you would have to ask koha or bugzilla or git for that 18:33 wizzyrea I have wanted that for so long 18:39 tcohen git++ 18:39 sekjal wizzyrea: that particular addition (run this report now) was funded by MassCat and VOKAL 18:39 wizzyrea MassCat++ 18:40 wizzyrea VOKAL++ 18:40 wizzyrea ByWater++ 18:40 wizzyrea MassCat++ just for good measure. 18:40 wizzyrea seriously, seeing that really made my day 18:40 sekjal :) 18:40 wizzyrea it's that little "stupid" stuff that makes koha so awesome, really 18:58 tcohen bye #koha 19:02 cait oh sorry for wrong information :( 19:02 cait confused patches it seems 19:02 wizzyrea I bet catalyst actually submitted it though 19:02 wizzyrea so you're probably right 19:02 wizzyrea :) 19:04 sekjal catalyst wrote the code, yes 19:08 cait bywater++ 19:08 cait wizzyrea++ too 19:09 * chris_n wonders if the 3.2.7 release will be eclipsed in the usa by tax day :-D 19:10 cait ? 19:49 rangi morning 19:50 oleonard Hi rangi 19:50 rangi hiya owen, how's things? 19:51 oleonard Not bad. Fighting with Drupal today. 19:51 cait morning rangi 19:51 rangi oleonard: ahh thats going around 19:51 rangi hey cait 19:54 magnuse "The beauty of Koha is we develop in the open, nothing is hidden so you can see what is going on at any time. [...] Koha grows through its strong and vibrant community, and the best users are the ones who invest the time in asking questions." 19:54 magnuse rangi++ 19:54 magnuse good night #koha ;-) 19:55 rangi night magnus_away 19:55 cait good night magnuse 19:55 cait where is this quote from? 19:56 rangi mailing list 19:57 rangi I just wrote it 19:57 druthb rangi++ 19:57 rangi coffee inspiration 19:57 wizzyrea @quote add <rangi> "The beauty of Koha is we develop in the open, nothing is hidden so you can see what is going on at any time. [...] Koha grows through its strong and vibrant community, and the best users are the ones who invest the time in asking questions." 19:57 rangi its college boy!! 19:57 huginn wizzyrea: 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). 19:57 wizzyrea noooooo 19:57 wizzyrea lol every stinkin time. 19:57 rangi lol 19:57 wizzyrea PH! 19:57 wizzyrea I was just thinking of you, it's as if you KNEW 19:58 oleonard ? 19:58 wizzyrea @quote add <rangi> "The beauty of Koha is we develop in the open, nothing is hidden so you can see what is going on at any time. [...] Koha grows through its strong and vibrant community, and the best users are the ones who invest the time in asking questions." 19:58 huginn wizzyrea: The operation succeeded. Quote #126 added. 19:58 wahanui i already had it that way, wizzyrea. 19:58 * cait waves at pianohacker 19:58 wizzyrea the beauty of koha? 19:58 wizzyrea "the beauty of koha? 19:58 wahanui i heard "the beauty of koha was we develop in the open, nothing is hidden so you can see what is going on at any time. [...] Koha grows through its strong and vibrant community, and the best users are the ones who invest the time in asking questions." 19:58 wizzyrea *giggle* 19:59 rangi oleonard: do u reckon stephen heges will be at ala? 19:59 rangi I should email him 19:59 rangi be great to catch up 19:59 oleonard No idea, but I don't recall hearing about him going in the past 20:01 rangi no chance of you coming? 20:02 * cait wished she could come... to catch up with rangi ;) 20:02 rangi :) 20:02 cait hi SpaceLibrarian_home 20:03 SpaceLibrarian_home morning! :) 20:05 oleonard rangi: me come to ALA? No. 20:06 rangi dang 20:06 rangi worth a shot 20:06 oleonard I don't even know where it is 20:06 rangi nola 20:07 gmcharlt just a (long) day's drive 20:07 rangi I was gonna make another tshirt for ya :) 20:08 oleonard Long day's drive? If I'm going to travel for 15 hours I ought to go visit rangi at his place! 20:10 gmcharlt oleonard: heh. at least I tried ;) 20:10 rangi hehe 20:11 cait oleonard: you should do that - nz is great 20:12 tcohen_home which koha devs come from nz? 20:13 wizzyrea perhaps a better question: which of you here are from NZ? 20:14 wizzyrea or, live in NZ 20:14 cait rangi, eythian, mtj, SpaceLibrarian... hm. 20:14 wizzyrea jo 20:14 cait jransom 20:14 wizzyrea darling 20:14 SpaceLibrarian_home yes. 20:14 SpaceLibrarian_home there are a few of us... :) 20:15 cait yep 20:15 tcohen_home if i manage to visit koha folks in france in my next visit to europe i should polish my english a bit i think 20:15 rangi darling 20:15 SpaceLibrarian_home ibeardslee as well 20:16 liw I was in NZ when I did a little Koha stuff 20:16 liw "Go to NZ for the scenery. Stay to develop Koha." 20:17 rangi liw++ 20:17 rangi heh 20:17 SpaceLibrarian_home liw++ 20:17 SpaceLibrarian_home :) 20:17 tcohen_home liw++ 20:17 rangi wizzyrea: you should check out obnam 20:17 rangi its cool! 20:17 oleonard For me it would be "Go to NZ for the Koha, hope to maybe see some scenery" 20:18 rangi and would be useful for nekls I think 20:18 liw oleonard, as long as you go to NZ it's a win 20:18 SpaceLibrarian_home oleonard: there's scenery right outside your window. :) 20:18 wizzyrea rangi: ooooooooooo 20:18 wizzyrea ty for that 20:18 rangi thank liw for writing it 20:18 * SpaceLibrarian_home agrees with rangi 20:18 * liw blushes 20:18 * oleonard is going to see what this "outside" of which you speak is all about 20:20 rangi #obnam is on oftc too which is handy 20:21 wizzyrea liw++ 20:21 wizzyrea good heavens lots of sirens here today 20:22 rangi tornado? 20:22 wizzyrea :) not yet 20:23 cait ok, what is obnam? 20:23 liw obnam is my backup application: http://braawi.org/obnam/ 20:23 wizzyrea that looks super slick 20:24 rangi software for doing backups, it allows encryption and incremental backups 20:24 rangi and requires no special software on the server you are backing up to 20:24 rangi so you can backup to anywhere you can scp to 20:24 rangi which is what I like 20:25 liw warning (I'm too honest for my own good): I've only just implemented encryption, so it's fresh and not in a release version yet 20:25 cait cool :) 20:25 cait liw++ 20:25 liw and it's slow, for now 20:25 rangi :) 20:26 SpaceLibrarian_home time to disappear for a wee while. rangi: good luck with the meeting! :) 20:27 mtj liw: have you looked at duplicity? 20:27 rangi thanks 20:27 mtj http://duplicity.nongnu.org/ 20:27 liw mtj, yes, I know of duplicity 20:27 liw but a) I don't want to flood #koha with obnam talk and b) it's been too long since I've looked at the other backup apps that I don't want to make comparisons (I'd like someone else to do that for me) 20:28 rangi ok my stop soon bbl 20:28 mtj liw: cool, just checking 21:01 wizzyrea I was happily creating saved reports 21:02 wizzyrea then all of a sudden, in my test server 21:02 wizzyrea guided_reports.pl: DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /home/liz/kohaclone/reports/guided_reports.pl line 496., referer: http://koha-staff.lan.nekls.org/cgi-bin/koha/reports/guided_reports.pl 21:02 wizzyrea and this is what the interface did: http://screencast.com/t/ytYdIsKJp 21:03 wizzyrea mind you I don't think anything changed 21:04 wizzyrea at least, I haven't personally been actively changing anything 21:05 sekjal wizzyrea: space before the SELECT clause? 21:05 wizzyrea ooooooooo 21:05 wizzyrea possibly, let me try 21:05 wizzyrea sho nuff. 21:05 wizzyrea now I feel dumb :) 21:06 wizzyrea but that's not your fault 21:06 sekjal it's a silly thing to cause an error... would be easy enough to fix 21:08 wizzyrea speaking of that, in certain reports you have multiple place where you ahve to specify something like a branch 21:08 wizzyrea so if you use parameters, you end up with 4 dropdowns with identical information 21:08 wizzyrea i'll give an example 21:09 wizzyrea http://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library#Not_Circulating_Items 21:09 wizzyrea with parameters as they are 21:09 wizzyrea it looks like this when you run that: http://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library#Not_Circulating_Items 21:09 wizzyrea er 21:09 wizzyrea no 21:09 wizzyrea http://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library#Not_Circulating_Items 21:09 wizzyrea urg, too speedy: http://screencast.com/t/8x7zdK99pVVq 21:09 wizzyrea there 21:10 wizzyrea this report: http://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library#Not_Circulating_Items looks like this when run: http://screencast.com/t/8x7zdK99pVVq 21:10 wizzyrea it would be nice to have a filter that keys off of another already defined filter 21:11 wizzyrea so you end up with only one "select your library" 21:11 wizzyrea and one "location code" 21:11 sekjal yeah, that would help 21:11 wizzyrea not always, of course, sometimes you need to have two or three different branches 21:11 wizzyrea (for example) 21:12 sekjal for that, you could use "branchcode IN (<<branches|provide a comma separated list>>)" 21:12 sekjal my syntax may be a little off 21:13 wizzyrea OH 21:13 wizzyrea actually 21:13 wizzyrea yes, you're right 21:13 wizzyrea that should be a documented example 21:14 wizzyrea branchcode IN (<<Comma separated list of branch codes>>) 21:14 wizzyrea no pipe, pipes are only for auth vals 21:14 wizzyrea without the pipe you get a freetext box 21:14 wizzyrea anything in it goes inside single quotes 21:15 wizzyrea more likely you'd see something like items.location IN (<<Comma separated list of locations>>) 21:15 wizzyrea or ccodes 21:15 wizzyrea or itypes 21:15 wizzyrea yes, thanks sekjal :) 21:15 wizzyrea < uptight thinking about it 21:19 wizzyrea @quote get 123 21:19 huginn wizzyrea: 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) 21:19 wahanui i already had it that way, huginn. 21:19 wizzyrea wahanui: forget if there 21:19 wahanui wizzyrea, I didn't have anything matching if there 21:22 wizzyrea @later tell nengard remind me to tell you about the reports parameters documentation that we might want to add. :) 21:22 huginn wizzyrea: The operation succeeded. 21:26 NCAR has everyone gone home for the day? 21:26 wizzyrea < is still here 21:27 wizzyrea for 32 more minutes :) 21:27 NCAR oh hey! 21:27 NCAR this'll take 3 21:27 wizzyrea shoot 21:27 NCAR i came up with an SQL Report today (with help)... 21:27 NCAR that counts circ activity within a daterange 21:28 wizzyrea yup 21:28 NCAR my question is, what exactly is that counting? 21:28 NCAR checkout events? 21:28 NCAR what about renewals? 21:28 wizzyrea what was the report? 21:28 NCAR well, it was a modified one from the SQL Reports page...i'll paste it. 21:28 NCAR what's the paste url again? 21:28 wizzyrea paste.koha-community.org 21:28 NCAR right, thx 21:29 wizzyrea paste? 21:29 wahanui i guess paste is found at http://paste.koha-community.org 21:29 wizzyrea haha 21:29 wizzyrea botsnack wahanui 21:29 wizzyrea @botsnack wahanui 21:29 huginn wizzyrea: I'll give you the answer as soon as RDA is ready 21:29 wahanui i already had it that way, huginn. 21:29 pastebot0 "NCAR" at 128.117.174.160 pasted "circulation within daterange @ LOC" (5 lines) at http://paste.koha-community.org/8 21:30 wizzyrea right, that's counting checkouts and renewals 21:30 wizzyrea they're all kept in the statistics table 21:30 wizzyrea now, it's not counting localuse, but it could be 21:31 NCAR ok. so, if an item was checked out before the specified date range, it wouldn't count as a checkout. 21:31 space_librarian and back! :) 21:31 wizzyrea right 21:31 wizzyrea hi space_librarian 21:31 NCAR okay 21:31 space_librarian hey wizzyrea! 21:31 wahanui i heard wizzyrea was a wonderful mother, colleague, and friend. or a koha poet 21:31 NCAR what do you mean by localuse? 21:34 wizzyrea it's like statistics users 21:34 wizzyrea we use it to count computer circulations 21:34 wizzyrea or one of our libraries does 21:34 NCAR ok 21:35 NCAR Apparently, we were getting smaller circ stats back when we were using Unicorn. 21:35 NCAR So, I'm trying to figure out why. 21:35 NCAR I can't imagine that our circulation went up all that much. 21:35 NCAR I'm not even sure how much discrepancy there is. 21:36 NCAR I got the info secondhand. Maybe our Unicorn stats were flawed. 21:37 wizzyrea hmm I remember something similar about our statistics (we came from unicorn too) 21:37 wizzyrea just a sec 21:37 wizzyrea let me grab you the report we use (or at least look at it :)) 21:37 NCAR k 21:38 wizzyrea oh, lookie, a left join I need to murder. 21:39 cait you murder left joins? 21:39 pastebot0 "wizzyrea" at 24.124.17.146 pasted "NEKLS circ report" (1 line) at http://paste.koha-community.org/9 21:39 wizzyrea sometimes :) 21:39 wizzyrea oh zounds 21:39 * cait is translating norwegian 21:39 wizzyrea lulz 21:39 wizzyrea O.o 21:39 wizzyrea that's not your usual thing :) 21:39 cait tempted to give magnuse negative karma... but... no 21:40 cait and I could live without it 21:40 wizzyrea we do ours by branch 21:40 cait hm? 21:40 NCAR i see 21:40 wizzyrea sry that was for NCAR 21:40 wizzyrea now, there is a reason we don't count checkins 21:41 wizzyrea and I think that was where our inflation was coming from 21:41 NCAR oh. does my report count checkins? 21:41 wizzyrea because every transit counted as a checkin 21:41 wizzyrea no, it doesn't 21:41 NCAR ok 21:41 NCAR that's good 21:41 wizzyrea :) yea 21:41 NCAR well, i guess i'll just assume that our Unicorn report was skewed somehow. 21:42 wizzyrea is it possible that your patrons can find books better and thus check out more items with koha? 21:42 NCAR I don't see any reason why the Koha report would be inaccurate. 21:42 wizzyrea that certainly was the case in our system. 21:42 NCAR that IS possible, yes. 21:43 wizzyrea if you have a minute more, let me talk to Sharon here, who probably remembers more about the possibly wacked out numbers we saw for a few months 21:43 NCAR ok 21:43 wizzyrea how long have you been on koha? 21:44 NCAR let's see...since Aug I guess. 21:45 wizzyrea and how different are the numbers? 21:45 * wizzyrea wonders if sirsi and koha count different things 21:45 NCAR that's what i need to find out... 21:45 NCAR i'll get those nos tomorrow and jump back on here. 21:46 NCAR that was my suspicion, that they were counting different things. 21:46 wizzyrea rather, I wonder if they define what they count differently 21:46 wizzyrea a "checkout" might mean something different to stastical sirsi 21:46 wizzyrea oy I cannot type today 21:47 wizzyrea but you are definitely counting the right things 21:47 wizzyrea those are the numbers we use for our stats 21:47 NCAR cool. well, i'll see if i can find you on here at different points during the day tomorrow. 21:47 NCAR thanks fer yer help! 21:47 wizzyrea sure thing, come hang out anytime :) 21:47 NCAR ciao 22:26 huginn New commit(s) kohagit: Fix for Bug 6186 - Change to DOCTYPE declaration causing validation errors <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d44896079b2c8619b120cda789de717fa77bfeea> 22:29 jenkins_koha Starting build 189 for job Koha_master (previous build: SUCCESS) 22:36 huginn New commit(s) kohagit: Fix for Bug 6192 - Path to theme directory scoped incorrectly <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=55984a1610504ab7d6e81cccca3c5df85fd4bdd5> / Merge remote branch 'kc/new/bug_6187' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9d6fbefce6c0bb3b6fbe024c9c30e7321ef92c4a> / Bug 6187 : Stupid typo in previous patch <http://git.koha-community.org/gitweb/?p=koha.git;a=co 22:48 huginn New commit(s) kohagit: Lower dependency on Storable to 2.20 in PerlDependencies.pm <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7457243d4d54a76588d51d1833df3517ee40988b> / Incremental fix for Bug 3514, Returning items through patron details tab <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ed9b0c551ef1a87303c8cfbc6204ddf83dabacb6> 23:09 jenkins_koha Project Koha_master build #189: SUCCESS in 39 mn: http://jenkins.koha-community.org/job/Koha_master/189/ 23:09 jenkins_koha * Owen Leonard: Fix for Bug 6186 - Change to DOCTYPE declaration causing validation errors 23:09 jenkins_koha * Chris Cormack: Bug 6187 : Stupid typo in previous patch 23:09 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6186 minor, PATCH-Sent, ---, oleonard, ASSIGNED, Change to DOCTYPE declaration causing validation errors 23:09 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6187 major, PATCH-Sent, ---, oleonard, NEW, View full heading in OPAC's authority search broken 23:09 jenkins_koha Starting build 190 for job Koha_master (previous build: SUCCESS) 23:49 jenkins_koha Project Koha_master build #190: SUCCESS in 40 mn: http://jenkins.koha-community.org/job/Koha_master/190/ 23:49 jenkins_koha * Owen Leonard: Fix for Bug 6192 - Path to theme directory scoped incorrectly 23:49 jenkins_koha * Owen Leonard: Incremental fix for Bug 3514, Returning items through patron details tab 23:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6192 normal, PATCH-Sent, ---, oleonard, ASSIGNED, Path to theme directory scoped incorrectly, causing broken images 23:49 jenkins_koha * Ricardo Dias Marques: Lower dependency on Storable to 2.20 in PerlDependencies.pm 23:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3514 major, PATCH-Sent, ---, kyle.m.hall, NEW, Returning items through patron Details tab doesn't activate all circulation functions