Time  Nick     Message
13:26 Brooke   howdy
13:34 Brooke   Ha
13:34 Brooke   it worked
13:34 Brooke   it produced an Owen
13:35 owen     Hey, and newlogbot is here so I can find out what Brooke is talking about!
14:20 owen     Brooke, if you're handing out wish lists, better to do it where Santa might be listening.
14:21 Brooke   yeah conversation changed, sorry
14:21 Brooke   so anyway
14:21 Brooke   all Libraries (or just about all of em)
14:22 Brooke   are gonna want to know how many things got checked out each month
14:22 Brooke   I've always seen this broken down by subject area
14:22 Brooke   when it's broken down
14:22 Brooke   some people want something as flat as "Hey, how many items went out?
14:23 Brooke   Like that would be a statistic I needed in my annual town report and in my aris
14:23 Brooke   but it would be neat some time in the murky future to have statistics help us
14:24 Brooke   and I realise that this is a moon on a string thing
14:24 Brooke   for like Koha 4 or 5
14:24 Brooke   but I'd love it to not just tell me how many times each book in the Mystery section went out last month
14:25 Brooke   but how many times each book in the mystery section went out last month in my Library
14:25 atz_     Brooke: what keeps you from getting that now?
14:25 Brooke   and how many times each book in the mystery section at Nelsonville Main went out last month
14:25 Brooke   if they let me be nosy
14:25 acmoore  I'm not sure how the custom reporting stuff works, but this sounds like something that can do.
14:25 Brooke   and then compare what is circing more there
14:26 Brooke   right, but that should be an out of box no fuss option
14:26 atz_     Brooke: you actually want a list of barcodes or titles or what?
14:27 atz_     that seems excessively detailed, for a library with tens of thousands or hundreds of thousands of items
14:27 Brooke   For the future thing, I would want a list of suggested titles with ISBN so that I could then order them. But it would be even better
14:27 Brooke   if it went into acquisitions somehow and gave me an option to just order that book
14:29 Brooke   so the checkouts by patron category at the way bottom under other
14:29 Brooke   is on the right track
14:29 Brooke   and I like that
14:30 Brooke   it's not terribly fussy, but it kind of gets buried with all the stuff on the left
14:30 Brooke   just like ye olde catalogue by item type is very useful for me aris, but it too takes a bit of sniffing about to find
14:32 Brooke   and yes, that would be kind of weird for a large academic Library to want atz, but I bet it'd be popular for the smaller ones
14:32 Brooke   and it wouldn't need to return all of the items
14:32 Brooke   it would need to return the items we had in common
14:33 Brooke   and then look at what we didn't share
14:33 Brooke   and then pick the titles that were newer than a date I gave it, that were missing from my catalogue, but did well at Nelsonville
14:34 Brooke   or even easier
14:34 Brooke   have it crawl NYTimes
14:34 Brooke   and my Library catalogue
14:34 Brooke   and see what I missed from the bestseller list
14:34 Brooke   then suggest a missing one as an aquisition
14:36 Brooke   or perhaps I want to see what's not working. Instead of a Most Circulated items Top List, have a dusty book list
14:36 Brooke   that would let me weed what was bad
14:37 Brooke   but that went a step further and looked at say $650 to see if there were trouble spots by subject
14:38 kf       great ideas, brooke
14:38 Brooke   thanks
14:38 Brooke   and hard to execute, I realise
14:38 Brooke   and a little weird sounding, and excessively detailed, I realise
14:38 Brooke   but some stuff could be done without me seeing it as a user
14:38 kf       not so weird at all
14:38 Brooke   so that I didn't get overloaded
14:40 Brooke   But this is way lower in priority for me than I think an installer would be
14:40 Brooke   and that's higher than cataloguing
14:40 Brooke   which is higher than reports
14:42 kf       i have a long wishlist for acquisitions... but i hope that rfcs for 3.2 get all implemented
14:42 Brooke   <---- has a long wishlist for everything
14:43 Brooke   but everything is getting done :D
14:43 Brooke   I remember when there were no reports
14:44 Brooke   just like installation is nicer now than it was in past, but I'd still love a package of the programme and dependencies so BOOM click click done
14:46 Brooke   I'm still chomping on the RDA report
14:46 Brooke   anyone else read that?
14:48 gmcharlt I've been avoding having to do that, but know I need to digest it sooner rather than later :)
14:53 Brooke   *nod*
14:53 Brooke   I think it's a good thing, since we're in a position to actually implement it in future
14:54 Brooke   it's something to think about when we think about cataloguing since we know how things are now
14:54 Brooke   the big problem is
14:54 Brooke   and sit for this
14:54 Brooke   they've not addressed subject yet
14:55 gmcharlt they'll deal with that eventually
14:55 gmcharlt my main concern is that the standard will be hobbled
14:55 gmcharlt if they don't make it freely available
14:56 gmcharlt for example, it would have been nice if they had released the draft in it's original XML form (or whatever they're using)
14:56 gmcharlt instead of PDFs
14:56 gmcharlt much easier to slice and dice, from my point of view
14:56 Brooke   true
14:57 Brooke   but PDFs are a cut above mail this person $65 - $75 for your very own copy of the AACR2R on paper
14:57 Brooke   yes Paper!
14:57 gmcharlt if they expect libraries to pay $X per copy/license/whatever, where $X is much above $10 at most
14:57 gmcharlt it's going to take years for it to be adopted
14:57 gmcharlt if it all
14:57 Brooke   it's going to take years to be adopted for other systems
14:58 Brooke   I do think it will eventually be adopted
14:58 Brooke   and yes
14:58 Brooke   the whole pay for access to professional reading is something I've always taken a baseball bat to kneecaps over
14:58 Brooke   so hey, American Libraries is free now
14:59 Brooke   but I think it's good that I can read RDA now for free, even if it's not the format I might like
14:59 gmcharlt good about AL, but overdue - you would think library publications would have been the first to be published open access
14:59 Brooke   :D
15:00 Brooke   preaching to the choir mah brother!
15:00 Brooke   I defy you to walk into a public Library and find a real useable section on Library Science
15:00 gmcharlt just atoning for once working for a subsidiary of Elsevier ;)
15:00 Brooke   we care for ourselves last
15:01 Brooke   *nod* I hear ya. El$ivier is evil
15:01 Brooke   I used to say stuff like that in Collection Development
15:01 Brooke   and the professor would just say "Brooke, Brooke, Brooke..." but laugh
15:02 Brooke   but they do a good job of aggregating and presenting which is why they're around
15:03 Brooke   can't gripe if you're not gonna fix it, which is why I'm trying to do slides of changes as I talk to people
15:03 Brooke   so instead of just saying
15:03 Brooke   hey, that sucks
15:03 Brooke   I can say
15:03 Brooke   hey, this not this
15:05 Brooke   I'm going to the gym so I can think and exercise instead of typing and thinking which leads to leg cramps
15:22 gelinp   hi, is there anyone to help me to install koha?
15:23 gelinp   I've followed the install documentation at http://wiki.koha.org/doku.php?id=ubuntu_gutsy
15:24 atz      and what's the hangup?
15:32 nahuel   hi people :)
15:32 atz      greets nahuel
15:32 nahuel   the request in C4::Auth::get_user_subpermissions(), work on my mysql 5.0.67
15:32 kf       hi nahuel
15:32 nahuel   but doesn't in an install on one of our clients in mysql 5.0.27
15:33 nahuel   hmm 5.0.18
15:33 nahuel   should I patch the request ?
15:33 nahuel   because koha support mysql >= 5.0
15:33 atz      nahuel: what is special about it?
15:33 nahuel   don't really know
15:33 nahuel   a problem "joining"
15:33 nahuel   ERROR 1054 (42S22): Unknown column 'code' in 'field list'
15:34 nahuel   using : select user_permissions.code from user_permissions ....
15:34 nahuel   it works
15:34 nahuel   so It should be patched by :
15:34 atz      SELECT flag, code  FROM user_permissions
15:34 atz         JOIN permissions USING (module_bit, code)
15:34 atz         JOIN userflags ON (module_bit = bit)
15:34 atz        JOIN borrowers USING (borrowernumber) WHERE userid = ?"
15:34 nahuel   select user_permissions.code as code from user_permissions ....
15:34 nahuel   the flag works :)
15:35 atz      nahuel: check the table that it's looking at
15:35 nahuel   the tables are the same :)
15:35 nahuel   code field exists
15:35 nahuel   etc...etc...
15:36 atz      but yeah, i guess code is is in two tables, it should be referenced unambiguously by SELECT
15:36 atz      not sure why it works in one and not the other though
15:37 nahuel   I think it's a bug/evolution of mysql
15:37 atz      we might have more places where that is a problem then too
15:37 atz      perhaps w/ different tables
15:37 nahuel   they make a lot of improvement between 5.0.x versions
15:38 nahuel   this work : select flag, user_permissions.code as code from user_permissions join permissions using (module_bit,code) join userflags on (module_bit = bit) join borrowers using (borrowernumber)
15:38 atz      yep, looks good
15:38 atz      nice catching this error early
15:38 nahuel   this doesn't work : select flag,  code from user_permissions join permissions using (module_bit,code) join userflags on (module_bit = bit) join borrowers using (borrowernumber) ;
15:38 nahuel   :)
15:39 nahuel   Well I send a patch now
16:04 gelinp   the hang up is that the connexion http://localhost:8080 display "production mode - trapped fatal error"
16:05 atz      gelinp: need to check your error log then
16:05 gelinp   ok, where is the file, do you mean the error log of apache?
16:05 atz      gelinp: there should be a Koha file referenced in /etc/apache2/sites-enabled
16:06 atz      in that file it defines ErrorLog for OPAC and STAFF interface
16:06 atz      you want the second one
16:07 gelinp   ok thank you very much, I'm going to look for all of this...
16:07 atz      probably you just have some prerequisite perl modules not installed
16:11 gelinp   may be... I've just have a look into /etc/apache2/sites-enabled, there is only two files: koha and 000-default, not any log files...
16:12 atz      right, you need to read the koha file
16:12 gelinp   ok
16:12 atz      or grep -i ErrorLog /etc/apache2/sites-enabled/koha
16:14 gelinp   ErrorLog /var/log/koha/koha-opac-error_log
16:14 gelinp      ErrorLog /var/log/koha/koha-error_log
16:14 gelinp   I think I have to have a look at the content of this files...
16:15 atz      ok, so the 2nd one is your staff interface error log
16:15 gelinp   ok
16:15 atz      less  /var/log/koha/koha-error_log
16:15 atz      (to read it)
16:17 gelinp   I've got a lot of:DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist
16:18 gelinp   also: DBD::mysql::st fetchrow_hashref failed: fetch() without execute()
16:19 gelinp   or: install.pl: Can't call method "id" on an undefined value at InstallAuth.pm line 281.
16:19 atz      it sounds like you haven't completed the command line portion of the install successfully
16:19 gelinp   what do you mean?
16:20 atz      the file /installer/data/mysql/kohastructure.sql  should have been loaded
16:20 atz      and it creates all the tables, including: CREATE TABLE language_descriptions
16:22 acmoore  using 'tail -50f' might make sure you're just looking at recent errors instead of old ones.
16:22 atz      true, though there shouldn't be that many old ones since this is the first part of the install
16:26 gelinp   the make test of the cgi component display:
16:26 gelinp   t/g4_mysql......................skipped: Couldn't establish connection
16:26 gelinp   with the MySQL server: Can't connect to data source '' because I can't
16:26 gelinp   work out what driver to use (it doesn't seem to contain a 'dbi:driver:'
16:26 gelinp   prefix and the DBI_DRIVER env var is not set) at t/g4_mysql.t line 44
16:27 atz      I don't think this is a problem with your version of CGI.pm
16:28 atz      and that is just a skip message, not an error
16:28 gelinp   ok
16:29 gelinp   but why /installer/data/mysql/kohastructure.sql didn't load?
17:08 atz      owen: something odd in the layout of jacket images here:
17:08 atz      http://librarycatalog.lcc.lt/cgi-bin/koha/opac-search.pl?q=poetry
17:09 owen     What are you seeing atz ?
17:10 atz      at 4. the image placeholders shift to the right leaving an empty (unshaded) block under the first 3 placeholders
17:11 atz      at 7. they go back with a populated jacket image
17:12 atz      9, 12-14, 16-17,19 are wide right again,=
17:12 owen     I'm not seeing that in FF3 or IE6 on WinXP
17:13 atz      hmm... ok must be a FF2/OSX thing
17:14 atz      oddly erratic though
17:17 acmoore  owen: see http://arwen.metavore.com/~acm/layout1.png and http://arwen.metavore.com/~acm/layout2.png for a screenshot of that.
17:17 acmoore  It seems familiar, almost like I've seen this problem before.
17:18 owen     I haven't.
19:07 atz      gmcharlt: when is it logical for items to have no holdingbranch?
19:08 atz      e.g. do we assume holdingbranch is homebranch if NULL?
19:08 gmcharlt atz: I think never, if holdingbranch is interpreted as branch item last seen at
19:08 atz      ok, i think i might be seeing a data migration issue then
19:09 gmcharlt using homebranch value if holdingbranch is null is a sensible default, but not sure it's rigorously observed
19:09 owen     In the past we've seen null holdingbranch for fresh imports, but that was with a custom 2.x import script
21:05 kados    speaking of crashing FF, owen did you ever know bout that issue that happens on the 'Holds awaiting pickup' report?
21:05 owen     Hm... I don't know
21:06 kados    owen: it apparantly takes about 25 hours to load when you've got a few thousand entries
21:06 kados    and it appeares to be an issue with browser rendering ...
21:06 owen     Well, I can imagine
21:06 kados    ie, maybe there's some really zany logic for YUI going on there?
21:07 owen     There's a jquery tablesorter on that table. That'd be the cause.
21:08 owen     Seems your clients are proving that no table is safe from being too big for the jquery tablesorter
21:09 kados    :(
21:09 kados    too bad, it's a nice feature
21:11 owen     Maybe a syspref to turn table sorting on and off. I know NPL would like the feature.
21:11 owen     I mean, I know NPL would like having the ability to sort on the fly.
21:12 kados    yea, not a bad idea
03:39 ryan     anyone around who knows what the 'ib' is in 'ibfk' naming convention for foreign keys ?
04:03 ryan     ... to answer my own question , it looks like it's a mysql internal convention, and must have come from an auto-named fk from mysql.