gmail.com← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:04 | rangi | well that took freaking ages |
| 00:04 | 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 | http://opac.opus.koha.catalyst[…]koha/opac-main.pl# | |
| 01:27 | 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 <http://git.koha-community.org/[…]510d424e2c5e792ed> / Bug 5917 Trying to fix the js parsing for translation <http://git.koha-community.org/[…]3418fddb0d0c90e5a> / Bug 5917 : Fixing a bug in the results page <http://git.koha-community.org/[…]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 | 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 | *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 | * Chris Cormack: Bug 5917 : Fixing a bug in the results page | |
| 02:24 | * Chris Cormack: Bug 5917 Trying to fix the js parsing for translation | |
| 02:24 | huginn | 04Bug http://bugs.koha-community.org[…]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" <http://git.koha-community.org/[…]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 <http://git.koha-community.org/[…]a81a0597d60ed06d1> / Follow-up fix for Bug 5952, Shows member relatives in issues list <http://git.koha-community.org/[…]7dcc6b24c9b9b549c> |
| 03:11 | New commit(s) kohagit: Fix for Reserves.t allow the tests to run without a logged in user <http://git.koha-community.org/[…]4fe6a7370ee47e219> / Merge remote branch 'kc/new/bug_6162' into kcmaster <http://git.koha-community.org/[…]12e3e0dcc1858fcc9> / 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.[…]/Koha_master/184/ |
| 03:23 | * Owen Leonard: Fix for Bug 6183, "Cancel marked requests" button has become "Renew checked items" | |
| 03:23 | * Owen Leonard: Follow-up fix for Bug 5952, Shows member relatives in issues list | |
| 03:23 | huginn | 04Bug http://bugs.koha-community.org[…]w_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 | 04Bug http://bugs.koha-community.org[…]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 <http://git.koha-community.org/[…]875059ff30ddc952a> / Bug 6187 : Fixing template issue with opac-authoritesdetail.tt <http://git.koha-community.org/[…]9e082180dd6305348> / 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 | Project Koha_master build #185: FIXED in 39 mn: http://jenkins.koha-community.[…]/Koha_master/185/ | |
| 04:03 | * Colin Campbell: Bug 6162 Fix passing of borrower details to reading history | |
| 04:03 | * 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[…]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 | http://www.dougcurrie.ca/news/[…]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 | * Owen Leonard: Fix for Bug 6179, Extra column on fines in staff client | |
| 04:43 | * Chris Cormack: Bug 6187 : Fixing template issue with opac-authoritesdetail.tt | |
| 04:43 | huginn | 04Bug http://bugs.koha-community.org[…]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 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6187 major, PATCH-Sent, ---, oleonard, NEW, View full heading in OPAC's authority search broken |
| 04:43 | 04Bug http://bugs.koha-community.org[…]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 additem.pl |
| 06:03 | line 607 | |
| 06:04 | @values = $itemrecord->field($tag)->subfield($subtag) if ($itemrecord && defined($itemrecord->field($tag)->subfield($subtag))); | |
| 06:04 | http://git.koha-community.org/[…]765b;hb=HEAD#l607 | |
| 06:04 | . | |
| 06:04 | cait | ? |
| 06:05 | what's the bug? | |
| 06:05 | mtj | $itemrecord->field($tag)->subfield($subtag) does *not* return an @ARRAY? |
| 06:05 | 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 | oh 3.2.6 - never tried there | |
| 06:07 | mtj | looks like the error happens only sometimes, so far |
| 06:08 | hmm, i take that back | |
| 06:08 | "Or if you think there might be more than one you can get all of them by calling in a list context: | |
| 06:08 | 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 | yay | |
| 06:12 | cait | :) |
| 06:12 | 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 | ah yes i did push it | |
| 06:14 | http://git.koha-community.org/[…]3b051b20c1a48b88a | |
| 06:14 | 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 | it's gone now - I think I was probably looking at the German templates | |
| 06:19 | sorry! | |
| 06:20 | whoohoo | |
| 06:20 | translation of toolbar looks very good now | |
| 06:21 | xslt still needs some attentio | |
| 06:21 | n | |
| 06:25 | rangi | yep |
| 06:25 | but at least got the js working :) | |
| 06:25 | 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 <http://git.koha-community.org/[…]b97ed81a5a0a25d95> / Bug 6104: Modify item looses branch <http://git.koha-community.org/[…]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 | handy | |
| 06:34 | cool thanks cait | |
| 06:34 | cait | yep |
| 06:35 | 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 | and of the jquery to do the message name translation too - lots of good new things in koha :) | |
| 06:42 | 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 | 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 | Paul Poulain: Bug 6104: Modify item looses branch | |
| 07:24 | huginn | 04Bug http://bugs.koha-community.org[…]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 | bonjour hdl | |
| 07:46 | miguelxercode | hi all |
| 07:46 | 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 | @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 kohaversion.pl? http://git.koha-community.org/[…]895dc707b;hb=HEAD |
| 08:23 | magnuse is now known as magnus_breakfast | |
| 08:23 | rangi | damnit why didnt my test catch that |
| 08:24 | will fix now | |
| 08:28 | huginn | New commit(s) kohagit: Bumping database version <http://git.koha-community.org/[…]9ce8e5ae91ed94078> / 5917 Fix for updating/creating .po files <http://git.koha-community.org/[…]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 | * Chris Cormack: 5917 Fix for updating/creating .po files | |
| 09:09 | * Chris Cormack: Bumping database version | |
| 09:11 | kmkale joined #koha | |
| 09:14 | magnuse | BorrowerUnwantedField++ |
| 09:15 | rangi | hmm anyone from xercode here? |
| 09:16 | miguel: are you around? | |
| 09:18 | miguel | yes |
| 09:20 | kmkale left #koha | |
| 09:20 | rangi | just reading your blog post http://blog.xercode.es/?p=399 |
| 09:20 | would you be able to do me a favour? | |
| 09:21 | 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 | 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 | 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 | which doesnt need to be translated | |
| 10:05 | 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 | Wait! There are actually two packages here: koha and koha-common. | |
| 10:25 | 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 | 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[…]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 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 | 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 | 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 | 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 | 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 | rangi. so if i have library.mydomain.tld i should add there ".mydomain.tld"? | |
| 10:36 | rangi | depends |
| 10:36 | 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 <http://bugs.koha-community.org[…]w_bug.cgi?id=6191> |
| 10:37 | rangi | the suffix or prefix are what you want you to have appended or prepended |
| 10:37 | if you went with -intra | |
| 10:37 | as suffix | |
| 10:37 | and went koha-create library | |
| 10:37 | you would get library.domain for the opac library-intra.domain for the staff site | |
| 10:39 | and the default sql is if you have some default data you want to be loaded into any koha instance you create | |
| 10:40 | 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 | 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 | 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 | 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 | 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 | good luck in tomorrows meeting | |
| 10:56 | rangi | thanks |
| 10:56 | 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 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:19 | matts_away is now known as matts | |
| 11:30 | adnc | rangi, the koha-create did not create the db-tables here. |
| 11:30 | can i do this manually? | |
| 11:37 | 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 | nz is sleeping :) | |
| 11:54 | adnc | kf, thanks |
| 11:55 | 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 | 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/Languages.pm line 192. |
| 12:04 | this is the error that comes when i try to login | |
| 12:04 | 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 | 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 <http://bugs.koha-community.org[…]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 | who calls them? | |
| 13:06 | kf | no more requirements conan, afaik |
| 13:06 | the templates have to be there once you start the web installer | |
| 13:06 | 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 bgkriegelgmail.com |
| 13:11 | 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 | 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 | 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[…]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 | 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 | ah, I see | |
| 13:27 | 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 | in order to have the db created | |
| 13:29 | # koha-create --create-db kutuphane | |
| 13:29 | Koha instance is empty, no staff user created. | |
| 13:29 | Enabling site kutuphane. | |
| 13:29 | Run '/etc/init.d/apache2 reload' to activate new configuration! | |
| 13:29 | Restarting web server: apache2[Thu Apr 14 15:29:28 2011] [warn] _default_ VirtualHost overlap on port 80, the first has precedence | |
| 13:29 | ... waiting [Thu Apr 14 15:29:29 2011] [warn] _default_ VirtualHost overlap on port 80, the first has precedence | |
| 13:29 | . | |
| 13:29 | Starting Zebra server for kutuphane | |
| 13:29 | 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 | 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 | 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 | no, the newone not | |
| 13:43 | gmcharlt | ok, if you do mysql -u root -p |
| 13:43 | and supply the mysql root password | |
| 13:43 | then do base koha_kutuphane | |
| 13:43 | 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[…]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 | I forget, what's the default? | |
| 13:50 | adnc | in koha-conf.xml tag <user>kohauser</user> and <password>givenpassword</password> |
| 13:51 | if that is not wrong. than it simply does not work | |
| 13:52 | 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 | no, that wouldn't work.. never mind | |
| 13:53 | adnc | wizzyrea for the admin webinstaller |
| 13:53 | 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 | i did not grant anything | |
| 13:56 | wizzyrea | grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; |
| 13:56 | in your mysql client | |
| 13:56 | then try your webinstaller | |
| 13:56 | 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 | ? | |
| 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 | [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 | 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 | m | |
| 14:03 | adnc | Error: Invalid username or password |
| 14:03 | wizzyrea | um, permissions? |
| 14:03 | http://www.mail-archive.com/ko[…]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[…]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] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Languages.pm line 193., |
| 14:07 | [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 | in particular, is there a line like this: | |
| 14:13 | DEFAULTSQL="/usr/share/koha/defaults.sql.gz" | |
| 14:20 | adnc | gmcharlt, sure, |
| 14:20 | DEFAULTSQL="/usr/share/koha/defaults.sql.gz" | |
| 14:20 | 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 | 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 | the error messages you're seeing in the logs just indicate that the tables haven't been created yet | |
| 14:43 | 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 | 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 | 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 | the first time I did it | |
| 14:47 | I was superlibrarian | |
| 14:47 | the first time I did it | |
| 14:47 | kf | oh |
| 14:47 | wizzyrea | it showed a blank screen |
| 14:47 | 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 | and it worked? | |
| 14:47 | so... | |
| 14:48 | I don't know if there's a bug there or not? | |
| 14:48 | 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 | i was reading you right now gmcharlt | |
| 14:59 | 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 | 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 | 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 | 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 | thanks! | |
| 16:04 | wizzyrea | if you'd like to make your report multifunctional, you can use parameters: |
| 16:04 | http://koha-community.org/docu[…]x15127#runtimefaq | |
| 16:04 | so you can have one report and run it for any location | |
| 16:04 | :) | |
| 16:04 | NCAR | ah, cool! |
| 16:04 | thx | |
| 16:04 | i'll investigate | |
| 16:04 | wizzyrea | (if you're using the created from sql reports within koha) |
| 16:05 | (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 | 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 | 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 | 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/install.pl |
| 16:14 | 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 | 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 | 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 | 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 | what SQL would give me circulation activity at a particular location since a given date | |
| 16:22 | wizzyrea | reports library? |
| 16:23 | boo no wahanui! | |
| 16:23 | oleonard | wahanui is here. Slacking? |
| 16:23 | wizzyrea | http://wiki.koha-community.org[…]L_Reports_Library |
| 16:23 | totally slacking! | |
| 16:23 | wahanui: reports library? | |
| 16:23 | oleonard | wahanui: reports library? |
| 16:23 | wahanui | bugger all, i dunno, wizzyrea |
| 16:23 | 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[…]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 http://wiki.koha-community.org[…]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 | 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 | for user names | |
| 16:25 | 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 | <serverinfo id="biblioserver"> | |
| 16:26 | <ccl2rpn>/etc/koha/zebradb/ccl.properties</ccl2rpn> | |
| 16:26 | <user>kohauser</user> | |
| 16:26 | <password>cbbcsuud</password> | |
| 16:26 | </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 | 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 | 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 | 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 | I'm really sorry | |
| 16:29 | wizzyrea | NCAR: replace items.ccode with items.location |
| 16:29 | as a general rule | |
| 16:29 | adnc: all good, glad we got it figured out | |
| 16:29 | gmcharlt | NCAR: e.g. in http://wiki.koha-community.org[…]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 | 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 | i did not know that option name | |
| 16:39 | thanks | |
| 16:39 | unfortunately my version does not have that option | |
| 16:40 | wizzyrea | i'm looking at 3.2.5 |
| 16:40 | and I don't see that one either | |
| 16:41 | but it doesn't exist in 3.4 either | |
| 16:41 | so | |
| 16:41 | oh oh | |
| 16:41 | its OpacPUvlic | |
| 16:41 | 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 | authentification, even, hehe | |
| 16:42 | 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 | 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 | 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 | 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 | so it posts it here automagically | |
| 16:49 | 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 | result: 21 | |
| 16:50 | then i changed it to 3 month and it spit out 13 | |
| 16:50 | the number should grow as i go back in time | |
| 16:50 | or is it giving me checkouts for a 30 day period? | |
| 16:51 | cait | hm no |
| 16:51 | like .... | |
| 16:51 | wizzyrea | circs for 3 months ago maybe? not |
| 16:51 | cumulative | |
| 16:51 | cait | yep |
| 16:51 | 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 | right | |
| 16:52 | cait | like 2011-03* |
| 16:52 | or something | |
| 16:52 | wahanui | something is broken in ht elayout |
| 16:52 | wizzyrea | lol |
| 16:52 | 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 | 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 | 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 | <<Ending Date|date2>> | |
| 16:54 | for the value | |
| 16:54 | dates are in format yyyy-mm-dd | |
| 16:54 | cait | hm, it's in a file on my work computer... |
| 16:54 | hmpf | |
| 16:54 | wizzyrea | hmpf |
| 16:55 | NCAR | so, that would go somewhere in this line? |
| 16:55 | 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 | there are better ways to do that | |
| 16:56 | we want all since date x, right? | |
| 16:56 | NCAR | yes |
| 16:56 | wizzyrea | AND statistics.datetime >= <<Start Date|date1>> |
| 16:56 | AND statistics.datetime <= <<End Date|date2>> | |
| 16:56 | that could be totally wrong | |
| 16:56 | 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 | for the dates | |
| 16:57 | remember the format :) | |
| 16:57 | leave the where | |
| 16:57 | get rid fo the first and | |
| 16:57 | NCAR | WHERE statistics.datetime >= <<Start Date|date1>> AND statistics.datetime <= <<End Date|date2>> |
| 16:57 | like this? | |
| 16:57 | wizzyrea | yes, like that :( |
| 16:57 | :( | |
| 16:57 | agh | |
| 16:57 | lol | |
| 16:57 | NCAR | ok, i'll try |
| 16:58 | wizzyrea | no frowning. |
| 16:58 | i wonder if you'd have to go all the way down to the timestamp | |
| 16:58 | ok, afk, lunch (sorry) | |
| 16:58 | 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 | gives me dropdown with no options and no way to enter date | |
| 17:00 | 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 | and enter your date manually | |
| 17:01 | in the formYYYY-MM-DD | |
| 17:02 | NCAR | ok |
| 17:04 | a HA | |
| 17:04 | 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 | depending whether the user chose to use memcached or not | |
| 17:19 | something similar to pazpar2_toggle_xml_{pre,post} I think | |
| 17:20 | I see I need to hook rewrite-config.PL | |
| 17:23 | gmcharlt: | |
| 17:23 | if ("__USE_MEMCACHED__" eq 'yes') { | |
| 17:23 | $configuration{'__MEMCACHED_COMMENTED__'} => ''; | |
| 17:23 | } | |
| 17:23 | (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 | i'm setting memcached vars in apache's ENV | |
| 17:26 | if it is not set, then skip memcached stuff | |
| 17:27 | otherwise, I need to evaluate if new Cache::Memcached yielded an incomplete object, etc | |
| 17:28 | 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 | ? | |
| 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 | 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 | i think i'll post the patch so we can do stress tests on that | |
| 17:43 | 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 | I not, of course, talking about the utility of memcached in general, which does provide obvious performance improvements | |
| 17:55 | 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 | 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 | and wanted them to be hidden (commented out actually) | |
| 17:57 | if not in a memcached setup | |
| 17:58 | gmcharlt: is bug 6193 | |
| 17:58 | huginn | 04Bug http://bugs.koha-community.org[…]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 | wouldn't need to comment it out | |
| 18:02 | just set it to the empty string | |
| 18:03 | tcohen | ok, and 'if ($servers)' will evaluate to false |
| 18:04 | how do I create a new patch against master so it is not a follow up | |
| 18:04 | ? | |
| 18:05 | gmcharlt | git rebase origin |
| 18:05 | then patch | |
| 18:05 | then git rebase -i to consolidate the patch | |
| 18:05 | 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 | use it wisely, and never for evil! | |
| 18:17 | ;) | |
| 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 http://wiki.koha-community.org[…]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 | sure | |
| 18:25 | wizzyrea | i forgot that if you're not using the auth val you don't need the | bi |
| 18:25 | bit | |
| 18:26 | cait | a date option would be very cool though |
| 18:26 | wizzyrea | very extremely |
| 18:26 | 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 | 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 <http://bugs.koha-community.org[…]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 | catalyst | |
| 18:32 | wahanui | catalyst are funding template refactoring |
| 18:32 | wizzyrea | catalyst++ |
| 18:32 | cait | nots ure about the developer |
| 18:33 | 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 | VOKAL++ | |
| 18:40 | ByWater++ | |
| 18:40 | MassCat++ just for good measure. | |
| 18:40 | 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 | confused patches it seems | |
| 19:02 | wizzyrea | I bet catalyst actually submitted it though |
| 19:02 | so you're probably right | |
| 19:02 | :) | |
| 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 | 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 | 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 | rangi++ | |
| 19:54 | 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 | 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 | lol every stinkin time. | |
| 19:57 | rangi | lol |
| 19:57 | wizzyrea | PH! |
| 19:57 | 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 | "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 | I should email him | |
| 19:59 | 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 | 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 | 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 | 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 | "Go to NZ for the scenery. Stay to develop Koha." | |
| 20:17 | rangi | liw++ |
| 20:17 | heh | |
| 20:17 | SpaceLibrarian_home | liw++ |
| 20:17 | :) | |
| 20:17 | tcohen_home | liw++ |
| 20:17 | rangi | wizzyrea: you should check out obnam |
| 20:17 | 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 | 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 | 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: 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 | and requires no special software on the server you are backing up to | |
| 20:24 | so you can backup to anywhere you can scp to | |
| 20:24 | 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 | 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 | http://duplicity.nongnu.org/ |
| 20:27 | liw | mtj, yes, I know of duplicity |
| 20:27 | 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 | then all of a sudden, in my test server | |
| 21:02 | 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.or[…]guided_reports.pl | |
| 21:02 | and this is what the interface did: http://screencast.com/t/ytYdIsKJp | |
| 21:02 | Guillaume1 left #koha | |
| 21:03 | wizzyrea | mind you I don't think anything changed |
| 21:04 | 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 | possibly, let me try | |
| 21:05 | sho nuff. | |
| 21:05 | now I feel dumb :) | |
| 21:06 | 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 | so if you use parameters, you end up with 4 dropdowns with identical information | |
| 21:08 | i'll give an example | |
| 21:09 | http://wiki.koha-community.org[…]Circulating_Items | |
| 21:09 | with parameters as they are | |
| 21:09 | it looks like this when you run that: http://wiki.koha-community.org[…]Circulating_Items | |
| 21:09 | er | |
| 21:09 | no | |
| 21:09 | http://wiki.koha-community.org[…]Circulating_Items | |
| 21:09 | urg, too speedy: http://screencast.com/t/8x7zdK99pVVq | |
| 21:09 | there | |
| 21:10 | this report: http://wiki.koha-community.org[…]Circulating_Items looks like this when run: http://screencast.com/t/8x7zdK99pVVq | |
| 21:10 | it would be nice to have a filter that keys off of another already defined filter | |
| 21:11 | so you end up with only one "select your library" | |
| 21:11 | 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 | (for example) | |
| 21:12 | sekjal | for that, you could use "branchcode IN (<<branches|provide a comma separated list>>)" |
| 21:12 | my syntax may be a little off | |
| 21:13 | wizzyrea | OH |
| 21:13 | actually | |
| 21:13 | yes, you're right | |
| 21:13 | that should be a documented example | |
| 21:14 | branchcode IN (<<Comma separated list of branch codes>>) | |
| 21:14 | no pipe, pipes are only for auth vals | |
| 21:14 | without the pipe you get a freetext box | |
| 21:14 | anything in it goes inside single quotes | |
| 21:15 | more likely you'd see something like items.location IN (<<Comma separated list of locations>>) | |
| 21:15 | or ccodes | |
| 21:15 | or itypes | |
| 21:15 | yes, thanks sekjal :) | |
| 21:15 | < uptight thinking about it | |
| 21:19 | @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 | for 32 more minutes :) | |
| 21:27 | NCAR | oh hey! |
| 21:27 | this'll take 3 | |
| 21:27 | wizzyrea | shoot |
| 21:27 | NCAR | i came up with an SQL Report today (with help)... |
| 21:27 | that counts circ activity within a daterange | |
| 21:28 | wizzyrea | yup |
| 21:28 | NCAR | my question is, what exactly is that counting? |
| 21:28 | checkout events? | |
| 21:28 | 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 | 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 | botsnack wahanui | |
| 21:29 | @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 | they're all kept in the statistics table | |
| 21:30 | 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 | 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 | we use it to count computer circulations | |
| 21:34 | or one of our libraries does | |
| 21:34 | NCAR | ok |
| 21:35 | Apparently, we were getting smaller circ stats back when we were using Unicorn. | |
| 21:35 | So, I'm trying to figure out why. | |
| 21:35 | I can't imagine that our circulation went up all that much. | |
| 21:35 | I'm not even sure how much discrepancy there is. | |
| 21:36 | 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 | just a sec | |
| 21:37 | 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 | oh zounds | |
| 21:39 | * cait | is translating norwegian |
| 21:39 | wizzyrea | lulz |
| 21:39 | O.o | |
| 21:39 | that's not your usual thing :) | |
| 21:39 | cait | tempted to give magnuse negative karma... but... no |
| 21:40 | 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 | now, there is a reason we don't count checkins | |
| 21:41 | 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 | no, it doesn't | |
| 21:41 | NCAR | ok |
| 21:41 | 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 | i'll get those nos tomorrow and jump back on here. | |
| 21:46 | 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 | a "checkout" might mean something different to stastical sirsi | |
| 21:46 | oy I cannot type today | |
| 21:47 | but you are definitely counting the right things | |
| 21:47 | 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 | 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 <http://git.koha-community.org/[…]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 <http://git.koha-community.org/[…]cca3c5df85fd4bdd5> / Merge remote branch 'kc/new/bug_6187' into kcmaster <http://git.koha-community.org/[…]c9c30e7321ef92c4a> / Bug 6187 : Stupid typo in previous patch <http://git.koha-community.org/[…]/?p=koha.git;a=co |
| 22:48 | New commit(s) kohagit: Lower dependency on Storable to 2.20 in PerlDependencies.pm <http://git.koha-community.org/[…]833df3517ee40988b> / Incremental fix for Bug 3514, Returning items through patron details tab <http://git.koha-community.org/[…]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 | * Owen Leonard: Fix for Bug 6186 - Change to DOCTYPE declaration causing validation errors | |
| 23:09 | * Chris Cormack: Bug 6187 : Stupid typo in previous patch | |
| 23:09 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6186 minor, PATCH-Sent, ---, oleonard, ASSIGNED, Change to DOCTYPE declaration causing validation errors |
| 23:09 | 04Bug http://bugs.koha-community.org[…]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 | * Owen Leonard: Fix for Bug 6192 - Path to theme directory scoped incorrectly | |
| 23:49 | * Owen Leonard: Incremental fix for Bug 3514, Returning items through patron details tab | |
| 23:49 | huginn | 04Bug http://bugs.koha-community.org[…]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 PerlDependencies.pm |
| 23:49 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=3514 major, PATCH-Sent, ---, kyle.m.hall, NEW, Returning items through patron Details tab doesn't activate all circulation functions |
← Previous day | Today | Next day → | Search | Index
