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