IRC log for #koha, 2011-04-14

All times shown according to UTC.

Time S Nick Message
00:04 rangi well that took freaking ages
00:04 rangi but i think i have fixed the translating js
00:15 NateC joined #koha
00:24 NateC left #koha
00:25 NateC joined #koha
00:28 Brooke_ joined #koha
00:28 Brooke_ kia ora
00:28 rangi hi Brooke_
00:32 NateC left #koha
00:34 space_librarian hey Brooke_
00:36 Brooke_ :D
00:37 space_librarian :)
00:54 Waylon left #koha
01:00 Brooke_ left #koha
01:05 ronald left #koha
01:06 ronald joined #koha
01:17 glernil joined #koha
01:27 rangi holy crap i actually got the js translating
01:27 rangi http://opac.opus.koha.catalyst[…]koha/
01:27 rangi toggle to deutsch and the lists dropdown is now translated
01:36 space_librarian rangi: ++
01:37 Irma left #koha
01:43 huginn New commit(s) kohagit: Merge branch 'new/enh/bug_5917' into kcmaster <[…]510d424e2c5e792ed> / Bug 5917 Trying to fix the js parsing for translation <[…]3418fddb0d0c90e5a> / Bug 5917 : Fixing a bug in the results page <[…]t;a=commitdiff;h=
01:44 jenkins_koha Starting build 183 for job Koha_master (previous build: FIXED)
01:53 mtj well done chris!
02:09 druthb joined #koha
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:23 druthb left #koha
02:24 jenkins_koha Project Koha_master build #183: UNSTABLE in 39 mn: http://jenkins.koha-community.[…]/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 Bug[…]w_bug.cgi?id=5917 enhancement, PATCH-Sent, ---, gmcharlt, NEW, Switch Koha to use Template::Toolkit
02:30 Guillaume1 joined #koha
02:39 huginn New commit(s) kohagit: Fix for Bug 6183, "Cancel marked requests" button has become "Renew checked items" <[…]906502c5445cc4dec>
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 <[…]a81a0597d60ed06d1> / Follow-up fix for Bug 5952, Shows member relatives in issues list <[…]7dcc6b24c9b9b549c>
03:11 huginn New commit(s) kohagit: Fix for Reserves.t allow the tests to run without a logged in user <[…]4fe6a7370ee47e219> / Merge remote branch 'kc/new/bug_6162' into kcmaster <[…]12e3e0dcc1858fcc9> / Bug 6162 Fix passing of borrower details to reading history <
03:23 jenkins_koha Project Koha_master build #184: STILL UNSTABLE in 39 mn: http://jenkins.koha-community.[…]/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 Bug[…]w_bug.cgi?id=6183 major, PATCH-Sent, ---, oleonard, ASSIGNED, "Cancel marked requests" button has become "Renew checked items" on's display of holds
03:23 huginn Bug[…]w_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:26 AmitG joined #koha
03:27 druthb joined #koha
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:33 druthb left #koha
03:45 huginn New commit(s) kohagit: Bug 6188 : Gender not showing in the opac <[…]875059ff30ddc952a> / Bug 6187 : Fixing template issue with <[…]9e082180dd6305348> / Fix for Bug 6179, Extra column on fines in staff client <
04:03 jenkins_koha Yippie, build fixed!
04:03 jenkins_koha Project Koha_master build #185: FIXED in 39 mn: http://jenkins.koha-community.[…]/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 Bug[…]w_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:04 Irma joined #koha
04:05 pianohacker joined #koha
04:05 rangi heya Irma and pianohacker
04:06 pianohacker Hey chris
04:07 Guillaume1 left #koha
04:10 rangi[…]d-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.[…]/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
04:43 huginn Bug[…]w_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 Bug[…]w_bug.cgi?id=6187 major, PATCH-Sent, ---, oleonard, NEW, View full heading in OPAC's authority search broken
04:43 huginn Bug[…]w_bug.cgi?id=6188 minor, PATCH-Sent, ---, oleonard, NEW, OPAC: 'my personal details' tab doesn't show sex
05:41 Ahmuck-Sr left #koha
05:50 cait joined #koha
05:50 cait hi #koha
05:53 Ahmuck-Sr joined #koha
05:57 space_librarian left #koha
05:57 space_librarian joined #koha
05:59 cait rangi++
06:03 mtj hmm, ill bumped into a weird bug/error on
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[…]765b;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/ 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[…]3b051b20c1a48b88a
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:27 snail joined #koha
06:28 ronald left #koha
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 <[…]b97ed81a5a0a25d95> / Bug 6104: Modify item looses branch <[…]3fd24b50fe8396b3b>
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:38 AmitG left #koha
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:42 cait left #koha
06:44 jenkins_koha Starting build 187 for job Koha_master (previous build: SUCCESS)
06:50 AmitG joined #koha
06:54 magnus_a` left #koha
06:56 magnus_away joined #koha
06:56 magnus_away is now known as magnuse
06:56 Irma left #koha
06:57 mtest joined #koha
06:57 magnuse is now known as magnus_away
06:58 magnus_away is now known as magnuse
06:58 rangi hi magnuse
06:58 magnuse hiya rangi
06:58 magnuse think i finally got bip working - woohoo
06:59 mtest left #koha
06:59 rangi yay
07:00 magnuse :-)
07:00 matts_away is now known as matts
07:02 julian joined #koha
07:07 miguel left #koha
07:08 hdl joined #koha
07:10 julian hello #koha
07:11 rangi hi julian
07:13 miguelxercode joined #koha
07:13 sophie_m joined #koha
07:13 francharb joined #koha
07:13 francharb hello all
07:13 sophie_m hi
07:15 SpaceLibrarian_home joined #koha
07:16 magnuse is now known as magnus_away
07:16 miguel joined #koha
07:24 jenkins_koha Project Koha_master build #187: SUCCESS in 39 mn: http://jenkins.koha-community.[…]/Koha_master/187/
07:24 jenkins_koha Paul Poulain: Bug 6104: Modify item looses branch
07:24 huginn Bug[…]w_bug.cgi?id=6104 critical, PATCH-Sent, ---, paul.poulain, ASSIGNED, Modifying an item causes it to lose its branch
07:29 magnus_away is now known as magnuse
07:37 hdl hi all
07:38 kf joined #koha
07:39 kf hi #koha
07:42 Guillaume1 joined #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:47 miguelxercode left #koha
07:56 kmkale joined #koha
07:56 kmkale Namaskar #koha
08:01 AmitG left #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:07 kmkale left #koha
08:07 Guillaume1 left #koha
08:16 kmkale joined #koha
08:21 magnuse rangi: XXX in[…]895dc707b;hb=HEAD
08:23 magnuse is now known as magnus_breakfast
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 <[…]9ce8e5ae91ed94078> / 5917 Fix for updating/creating .po files <[…]bbc8362833166625a>
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:36 AmitG joined #koha
08:41 Guillaume1 joined #koha
08:42 Guillaume1 left #koha
08:42 AmitG heya all
08:45 magnus_breakfast is now known as magnuse
08:51 kmkale left #koha
08:52 glernil left #koha
08:53 Guillaume1 joined #koha
08:57 AmitG left #koha
09:08 adnc joined #koha
09:09 jenkins_koha Project Koha_master build #188: SUCCESS in 39 mn: http://jenkins.koha-community.[…]/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:11 kmkale joined #koha
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 kmkale left #koha
09:20 rangi just reading your blog post
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  <-- 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:26 AmitG joined #koha
09:31 rangi :)
09:35 snail left #koha
09:41 pianohacker left #koha
09:48 kf back
09:48 * kf waves to magnuse
09:49 kmkale joined #koha
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
09:54 wahanui joined #koha
09:57 druthb joined #koha
09:58 kmkale left #koha
10:02 matts is now known as matts_away
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 Bug[…]w_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
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 kmkale joined #koha
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 kmkale left #koha
10:36 huginn New commit(s) needsignoff: [Bug 6191] Order Details table not showing modify in basket <[…]w_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:49 tcohen joined #koha
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:53 conan joined #koha
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 wahanui left #koha
10:56 wahanui joined #koha
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
10:58 tcohen left #koha
11:10 SpaceLibrarian_home left #koha
11:16 pastebot0 "adnc" at pasted "/etc/cron.hourly/koha-common:" (7 lines) at
11:17 adnc whats wrong with the installation
11:19 matts_away is now known as matts
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:39 jwagner joined #koha
11:46 magnuse hiya jwagner
11:47 jwagner Hi magnuse
11:49 NateC joined #koha
11:49 NateC left #koha
11:49 NateC joined #koha
11:51 francharb1 joined #koha
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
11:56 francharb left #koha
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 clrh_ left #koha
12:04 sekjal joined #koha
12:04 adnc language_subtag_registry' doesn't exist at /usr/share/koha/lib/C4/ line 192.
12:04 adnc this is the error that comes when i try to login
12:04 adnc in the logfiles
12:13 AmitG left #koha
12:17 oleonard joined #koha
12:20 oleonard Hi #koha
12:20 druthb left #koha
12:21 kf hi oloeonard
12:21 kf oleonard even
12:22 clrh joined #koha
12:33 JesseM joined #koha
12:34 tcohen joined #koha
12:41 sekjal left #koha
12:55 clrh left #koha
12:58 clrh joined #koha
13:04 huginn New commit(s) needsignoff: [Bug 6186] Change to DOCTYPE declaration causing validation errors <[…]w_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 sekjal joined #koha
13:07 kf so, before starting web installer - templates must have been created, after that everything just works
13:11 tcohen conan, write
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 <[…]w_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:17 tcohen left #koha
13:18 magnuse is now known as magnus_away
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/ line 192.
13:26 pastebot0 "adnc" at pasted "DBD::mysql::st execute failed:" (12 lines) at
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 tcohen joined #koha
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 <[…]w_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] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/ 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[…]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 Bug[…]w_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] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/ line 193.,
14:07 adnc [Thu Apr 14 16:02:48 2011] DBD::mysql::st execute failed: Table 'koha_kutuphane.language_subtag_registry' doesn't exist at /usr/share/koha/lib/C4/ 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 pasted "DOMAIN="" INTRAPO" (5 lines) at
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:28 rhcl_away is now known as rhcl
14:29 wizzyrea righto: I'll check some :)
14:36 JesseM left #koha
14:37 adnc gmcharlt, whats your ide?
14:38 hdl left #koha
14:39 JesseM joined #koha
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:44 hdl joined #koha
14:46 tcohen gmcharlt: is there a way to know if everything went ok with new Cache::Memcached ?
14:46 adnc left #koha
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:48 conan left #koha
14:49 tcohen has anyone played with Cache::Memcached and has any thought on error handling?
14:50 tcohen left #koha
14:50 tcohen joined #koha
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:51 tcohen left #koha
14:53 conan joined #koha
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:57 tcohen joined #koha
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:00 Guillaume1 left #koha
15:01 Oak joined #koha
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:06 conan left #koha
15:16 conan joined #koha
15:22 Ahmuck joined #koha
15:30 hdl left #koha
15:45 matts is now known as matts_away
15:50 NCAR joined #koha
15:53 kf left #koha
15:53 Ahmuck left #koha
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:57 julian left #koha
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[…]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 joined #koha
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/[…]taller/
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:17 NCAR left #koha
16:20 NCAR joined #koha
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[…]L_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[…]L_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[…]L_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​/</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:27 sophie_m left #koha
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[…]ry#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 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 NCAR left #koha
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
16:43 wizzyrea ah, yea, it's not is it
16:43 wizzyrea I thought that had been around a while
16:44 cait joined #koha
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:47 NCAR joined #koha
16:47 adnc left #koha
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
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 pasted "Checkouts since date @ LOC" (5 lines) at
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:58 wizzyrea is now known as wizzy_lunch
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 pasted "Checkouts in date range @ LOC" (5 lines) at
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:10 NCAR left #koha
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:29 conan left #koha
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 HBankhead joined #koha
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:45 francharb1 left #koha
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 Bug[…]w_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:18 wizzy_lunch is now known as wizzyrea
18:21 cait wizzy_lunch?
18:24 wizzyrea reports library?
18:24 wahanui reports library is, like, found at[…]L_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 Ahmuck joined #koha
18:27 huginn New commit(s) needsignoff: [Bug 6193] Use memcached cache koha-conf.xml configuration variables <[…]w_bug.cgi?id=6193>
18:31 Ahmuck-Sr left #koha
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 magnus_away is now known as magnuse
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
18:58 tcohen left #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:03 ebegin joined #koha
19:04 Guillaume1 joined #koha
19:04 sekjal catalyst wrote the code, yes
19:04 Oak left #koha
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:16 brendan__ left #koha
19:20 hdl joined #koha
19:23 adnc joined #koha
19:32 hdl left #koha
19:34 jwagner left #koha
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 druthb joined #koha
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 magnuse is now known as magnus_away
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 pianohacker joined #koha
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:01 tcohen joined #koha
20:02 * cait wished she could come... to catch up with rangi ;)
20:02 rangi :)
20:02 SpaceLibrarian_home joined #koha
20:02 cait hi SpaceLibrarian_home
20:03 SpaceLibrarian_home morning! :)
20:03 tcohen is now known as tcohen_home
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:19 oleonard left #koha
20:20 rangi #obnam is on oftc too which is handy
20:20 adnc left #koha
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 druthb left #koha
20:23 liw obnam is my backup application:
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 SpaceLibrarian_home left #koha
20:27 mtj
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
20:32 chilts_ is now known as chilts
20:40 JesseM left #koha
20:47 brendan_ joined #koha
20:51 brendan_ left #koha
20:52 tcohen_home left #koha
20:53 tcohen_home joined #koha
20:55 brendan_ joined #koha
20:55 brendan_ left #koha
21:01 wizzyrea I was happily creating saved reports
21:02 wizzyrea then all of a sudden, in my test server
21:02 wizzyrea DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /home/liz/kohaclone/reports/ line 496., referer: http://koha-staff.lan.nekls.or[…]
21:02 wizzyrea and this is what the interface did:
21:02 Guillaume1 left #koha
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[…]Circulating_Items
21:09 wizzyrea with parameters as they are
21:09 wizzyrea it looks like this when you run that:[…]Circulating_Items
21:09 wizzyrea er
21:09 wizzyrea no
21:09 wizzyrea[…]Circulating_Items
21:09 wizzyrea urg, too speedy:
21:09 wizzyrea there
21:10 wizzyrea this report:[…]Circulating_Items looks like this when run:
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:24 NCAR joined #koha
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 sekjal left #koha
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
21:28 NCAR right, thx
21:29 wizzyrea paste?
21:29 wahanui i guess paste is found at
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 pasted "circulation within daterange @ LOC" (5 lines) at
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 pasted "NEKLS circ report" (1 line) at
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
21:48 NCAR left #koha
21:51 HBankhead left #koha
21:51 NateC left #koha
22:02 tcohen_home is now known as tcohen
22:23 cait left #koha
22:26 huginn New commit(s) kohagit: Fix for Bug 6186 - Change to DOCTYPE declaration causing validation errors <[…]789de717fa77bfeea>
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 <[…]cca3c5df85fd4bdd5> / Merge remote branch 'kc/new/bug_6187' into kcmaster <[…]c9c30e7321ef92c4a> / Bug 6187 : Stupid typo in previous patch <[…]/?p=koha.git;a=co
22:48 huginn New commit(s) kohagit: Lower dependency on Storable to 2.20 in <[…]833df3517ee40988b> / Incremental fix for Bug 3514, Returning items through patron details tab <[…]c6204ddf83dabacb6>
22:54 rhcl is now known as rhcl_away
22:58 rhcl_away left #koha
23:09 jenkins_koha Project Koha_master build #189: SUCCESS in 39 mn: http://jenkins.koha-community.[…]/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 Bug[…]w_bug.cgi?id=6186 minor, PATCH-Sent, ---, oleonard, ASSIGNED, Change to DOCTYPE declaration causing validation errors
23:09 huginn Bug[…]w_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:20 stinky_9cx1li joined #koha
23:21 Irma joined #koha
23:22 stinky_9cx1li left #koha
23:25 tcohen left #koha
23:29 druthb joined #koha
23:29 druthb left #koha
23:49 jenkins_koha Project Koha_master build #190: SUCCESS in 40 mn: http://jenkins.koha-community.[…]/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 Bug[…]w_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
23:49 huginn Bug[…]w_bug.cgi?id=3514 major, PATCH-Sent, ---, kyle.m.hall, NEW, Returning items through patron Details tab doesn't activate all circulation functions

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