| Time |
S |
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/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 |
|
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. |
