← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 13:26 | Brooke | howdy |
| 13:34 | Ha | |
| 13:34 | it worked | |
| 13:34 | it produced an Owen | |
| 13:35 | owen | Hey, and newlogbot is here so I can find out what Brooke is talking about! |
| 14:20 | 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 | so anyway | |
| 14:21 | all Libraries (or just about all of em) | |
| 14:22 | are gonna want to know how many things got checked out each month | |
| 14:22 | I've always seen this broken down by subject area | |
| 14:22 | when it's broken down | |
| 14:22 | some people want something as flat as "Hey, how many items went out? | |
| 14:23 | Like that would be a statistic I needed in my annual town report and in my aris | |
| 14:23 | but it would be neat some time in the murky future to have statistics help us | |
| 14:24 | and I realise that this is a moon on a string thing | |
| 14:24 | for like Koha 4 or 5 | |
| 14:24 | 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 | 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 | 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 | 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 | 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 | if it went into acquisitions somehow and gave me an option to just order that book | |
| 14:29 | so the checkouts by patron category at the way bottom under other | |
| 14:29 | is on the right track | |
| 14:29 | and I like that | |
| 14:30 | it's not terribly fussy, but it kind of gets buried with all the stuff on the left | |
| 14:30 | 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 | 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 | and it wouldn't need to return all of the items | |
| 14:32 | it would need to return the items we had in common | |
| 14:33 | and then look at what we didn't share | |
| 14:33 | 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 | or even easier | |
| 14:34 | have it crawl NYTimes | |
| 14:34 | and my Library catalogue | |
| 14:34 | and see what I missed from the bestseller list | |
| 14:34 | then suggest a missing one as an aquisition | |
| 14:36 | 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 | that would let me weed what was bad | |
| 14:37 | 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 | and hard to execute, I realise | |
| 14:38 | and a little weird sounding, and excessively detailed, I realise | |
| 14:38 | 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 | But this is way lower in priority for me than I think an installer would be | |
| 14:40 | and that's higher than cataloguing | |
| 14:40 | 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 | but everything is getting done :D | |
| 14:43 | I remember when there were no reports | |
| 14:44 | 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 | I'm still chomping on the RDA report | |
| 14:46 | 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 | I think it's a good thing, since we're in a position to actually implement it in future | |
| 14:54 | it's something to think about when we think about cataloguing since we know how things are now | |
| 14:54 | the big problem is | |
| 14:54 | and sit for this | |
| 14:54 | they've not addressed subject yet | |
| 14:55 | gmcharlt | they'll deal with that eventually |
| 14:55 | my main concern is that the standard will be hobbled | |
| 14:55 | if they don't make it freely available | |
| 14:56 | 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 | instead of PDFs | |
| 14:56 | much easier to slice and dice, from my point of view | |
| 14:56 | Brooke | true |
| 14:57 | but PDFs are a cut above mail this person $65 - $75 for your very own copy of the AACR2R on paper | |
| 14:57 | 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 | it's going to take years for it to be adopted | |
| 14:57 | if it all | |
| 14:57 | Brooke | it's going to take years to be adopted for other systems |
| 14:58 | I do think it will eventually be adopted | |
| 14:58 | and yes | |
| 14:58 | the whole pay for access to professional reading is something I've always taken a baseball bat to kneecaps over | |
| 14:58 | so hey, American Libraries is free now | |
| 14:59 | 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 | preaching to the choir mah brother! | |
| 15:00 | 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 | *nod* I hear ya. El$ivier is evil | |
| 15:01 | I used to say stuff like that in Collection Development | |
| 15:01 | and the professor would just say "Brooke, Brooke, Brooke..." but laugh | |
| 15:02 | but they do a good job of aggregating and presenting which is why they're around | |
| 15:03 | 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 | so instead of just saying | |
| 15:03 | hey, that sucks | |
| 15:03 | I can say | |
| 15:03 | hey, this not this | |
| 15:05 | 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 | 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 | hmm 5.0.18 | |
| 15:33 | should I patch the request ? | |
| 15:33 | because koha support mysql >= 5.0 | |
| 15:33 | atz | nahuel: what is special about it? |
| 15:33 | nahuel | don't really know |
| 15:33 | a problem "joining" | |
| 15:33 | ERROR 1054 (42S22): Unknown column 'code' in 'field list' | |
| 15:34 | using : select user_permissions.code from user_permissions .... | |
| 15:34 | it works | |
| 15:34 | so It should be patched by : | |
| 15:34 | atz | SELECT flag, code FROM user_permissions |
| 15:34 | JOIN permissions USING (module_bit, code) | |
| 15:34 | JOIN userflags ON (module_bit = bit) | |
| 15:34 | JOIN borrowers USING (borrowernumber) WHERE userid = ?" | |
| 15:34 | nahuel | select user_permissions.code as code from user_permissions .... |
| 15:34 | 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 | code field exists | |
| 15:35 | etc...etc... | |
| 15:36 | atz | but yeah, i guess code is is in two tables, it should be referenced unambiguously by SELECT |
| 15:36 | 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 | perhaps w/ different tables | |
| 15:37 | nahuel | they make a lot of improvement between 5.0.x versions |
| 15:38 | 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 | 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 | :) | |
| 15:39 | 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 | in that file it defines ErrorLog for OPAC and STAFF interface | |
| 16:06 | 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 | ErrorLog /var/log/koha/koha-error_log | |
| 16:14 | 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 | (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 | also: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() | |
| 16:19 | 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 | 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 | t/g4_mysql......................skipped: Couldn't establish connection | |
| 16:26 | with the MySQL server: Can't connect to data source '' because I can't | |
| 16:26 | work out what driver to use (it doesn't seem to contain a 'dbi:driver:' | |
| 16:26 | 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 | and that is just a skip message, not an error | |
| 16:28 | gelinp | ok |
| 16:29 | 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 | http://librarycatalog.lcc.lt/c[…]earch.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 | at 7. they go back with a populated jacket image | |
| 17:12 | 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 | 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 | 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 | 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 | 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 | Seems your clients are proving that no table is safe from being too big for the jquery tablesorter | |
| 21:09 | kados | :( |
| 21:09 | 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 | 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 | ... 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. |
← Previous day | Today | Next day → | Search | Index