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