| Time |
S |
Nick |
Message |
| 02:09 |
|
gmcharlt |
@quote random |
| 02:09 |
|
huginn |
gmcharlt: Quote #152: "gmcharlt: Koha: unifying the world one library at a time" (added by wizzyrea at 02:19 PM, September 13, 2011) |
| 02:34 |
|
|
fALSO_ left #koha |
| 04:19 |
|
|
wizzyrea1 joined #koha |
| 05:12 |
|
|
cait joined #koha |
| 05:12 |
|
cait |
good morning #koha |
| 06:08 |
|
|
luisb joined #koha |
| 06:22 |
|
magnus_afk |
hiya cait and #koha |
| 06:24 |
|
cait |
hi magnus_afk :) |
| 06:24 |
|
magnus_afk |
i thought i was up early |
| 06:24 |
|
magnus_afk |
:-) |
| 06:25 |
|
cait |
nope |
| 06:25 |
|
cait |
beat you :) |
| 06:26 |
|
magnus_afk |
you're always here, aren't you ;-) |
| 06:29 |
|
cait |
no |
| 06:29 |
|
cait |
sometimes I sleep :P |
| 06:29 |
|
magnus_afk |
ah |
| 07:04 |
|
|
hdl joined #koha |
| 07:12 |
|
|
hdl joined #koha |
| 07:42 |
|
|
luisb joined #koha |
| 08:04 |
|
|
mbalmer joined #koha |
| 09:10 |
|
cait |
morning mbalmer |
| 09:10 |
|
mbalmer |
morgen! |
| 11:17 |
|
|
Mehwish joined #koha |
| 11:17 |
|
Mehwish |
hi all I need a help regarding KOha database.. |
| 11:18 |
|
Mehwish |
is there any one who knows koha database in detail? |
| 11:18 |
|
cait |
ask your question :) |
| 11:19 |
|
Mehwish |
I need to know that what table stores shelving information for books...?? |
| 11:20 |
|
cait |
what do you want to do? |
| 11:20 |
|
Mehwish |
means "Shelving location" that we write when we add item.. |
| 11:20 |
|
Mehwish |
I want to copy that information from my older koha to newer one. |
| 11:21 |
|
cait |
items information is all stored in the items table |
| 11:21 |
|
Mehwish |
I copied lots of tables but don't know which table stores that info. |
| 11:21 |
|
cait |
copying over single tables is a bit dangerous |
| 11:21 |
|
jcamins |
Mehwish: don't copy over tables. |
| 11:21 |
|
jcamins |
Mehwish: you should take a complete dump of your database, load it on the new system, then run the upgrade script. |
| 11:22 |
|
Mehwish |
no I changed database due to some other reason. |
| 11:22 |
|
Mehwish |
in older Koha I did not use zebra |
| 11:22 |
|
jcamins |
Mehwish: I don't think anyone will be able to offer you any help on your installation. |
| 11:23 |
|
Mehwish |
in new koha I setup zebra and was confused that which tables uses zebra |
| 11:23 |
|
Mehwish |
so i imported books from older koha |
| 11:23 |
|
jcamins |
Mehwish: as long as you understand that you probably won't be able to get help from anyone when you run into problems (and you will!). |
| 11:24 |
|
cait |
Mehwish: zebra doesn't use tables |
| 11:24 |
|
cait |
or not any tables different |
| 11:24 |
|
Mehwish |
hmm.. but can any one just tell me where Authorized values are stored? I mean in which table? |
| 11:24 |
|
cait |
in your database you only need to activate the system preference |
| 11:24 |
|
cait |
in the table with the sa ename |
| 11:25 |
|
jcamins |
Mehwish: read installer/data/mysql/kohastructure.sql |
| 11:28 |
|
Mehwish |
I ok I am trying that. |
| 11:33 |
|
Mehwish |
OK thanks It will help me I hope. |
| 11:33 |
|
jcamins |
Mehwish: good luck, but *please* consider upgrading properly. |
| 11:34 |
|
jcamins |
As I said, I don't think you'll get any help if you insist on copying over individual tables. |
| 11:34 |
|
cait |
Mehwish: it will end up messy and is really not necessary |
| 13:12 |
|
jcamins |
bug 7590 |
| 13:12 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7590 normal, P5 - low, ---, frederic, Needs Signoff , Cataloging authorities search result page is broken |
| 13:17 |
|
cait |
ah yes |
| 13:17 |
|
cait |
not sure how to test that |
| 13:17 |
|
cait |
looking at 7298 now |
| 14:54 |
|
|
mbalmer joined #koha |
| 14:58 |
|
|
mbalmer joined #koha |
| 14:58 |
|
|
hdl joined #koha |
| 15:07 |
|
|
hdl joined #koha |
| 15:33 |
|
|
ago43 joined #koha |
| 16:08 |
|
|
mib_dmc7ok joined #koha |
| 16:50 |
|
cait |
silent day |
| 16:50 |
|
cait |
on #koha |
| 16:52 |
|
jcamins_away |
Indeed it is. |
| 16:56 |
|
* cait |
shares cake with jcamins |
| 16:56 |
|
jcamins |
:) |
| 17:01 |
|
cait |
noone else here.. more cookies for us |
| 17:07 |
|
cait |
new evil bug filed |
| 17:08 |
|
jcamins |
Interesting. |
| 17:08 |
|
wahanui |
well, interesting is good |
| 17:09 |
|
jcamins |
Not in this case, wahanui. |
| 17:09 |
|
wahanui |
jcamins: excuse me? |
| 17:09 |
|
cait |
no, not really |
| 17:09 |
|
cait |
one of our libraries found it |
| 17:09 |
|
cait |
wonder why nobody ever before did |
| 17:10 |
|
jcamins |
It depends on the browser. |
| 17:10 |
|
jcamins |
So maybe old versions of Firefox worked correctly. |
| 17:10 |
|
cait |
bug 7607 |
| 17:10 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7607 major, P5 - low, ---, gmcharlt, NEW , Advanced search: Index and search term don't match when leaving fields empty |
| 17:10 |
|
cait |
I just tested in chrome |
| 17:10 |
|
cait |
I see the same behaviour there :( |
| 17:10 |
|
cait |
so perhaps the browser idea is a false lead |
| 17:10 |
|
jcamins |
Right. But you didn't test *old* versions. |
| 17:11 |
|
jcamins |
No, it's definitely dependent on the browser. |
| 17:11 |
|
cait |
hm no i didn't |
| 17:11 |
|
cait |
well |
| 17:11 |
|
cait |
that#s good |
| 17:11 |
|
cait |
perhaps we can fix it on template level then |
| 17:11 |
|
cait |
becaue fixing in search.pm... |
| 17:11 |
|
jcamins |
It has to do with whether browsers pass empty CGI params. |
| 17:11 |
|
cait |
do you think it warrants a critical? |
| 17:12 |
|
jcamins |
Hmm. |
| 17:12 |
|
jcamins |
It is a pretty big issue. |
| 17:18 |
|
cait |
I think so too |
| 17:21 |
|
jcamins |
Maybe I could rebase 7248. |
| 17:22 |
|
jcamins |
It seems to me it should be pretty simple. All I'm doing is removing code. |
| 17:23 |
|
cait |
what's the opposite of collapsed? |
| 17:23 |
|
jcamins |
Expanded? |
| 17:23 |
|
cait |
aah |
| 17:23 |
|
cait |
right |
| 17:23 |
|
cait |
thank you |
| 17:25 |
|
cait |
ok another bug filed |
| 17:51 |
|
|
Guillaume joined #koha |
| 18:12 |
|
|
Soupermanito joined #koha |
| 18:46 |
|
|
adnc joined #koha |
| 18:55 |
|
|
Viktor joined #koha |
| 19:04 |
|
|
Viktor_ joined #koha |
| 19:05 |
|
|
Viktor_ left #koha |
| 19:20 |
|
|
ibeardslee joined #koha |
| 19:58 |
|
|
adnc joined #koha |
| 20:44 |
|
|
Space_Librarian joined #koha |
| 20:48 |
|
Space_Librarian |
o/ |
| 20:49 |
|
cait |
hi Space_Librarian |
| 20:50 |
|
jcamins |
How was your half-marathon? |
| 20:51 |
|
Space_Librarian |
walked 21km in 2h45 (my stopwatch was 2h43.45, but who's to quibble). It was great. But my toes are very sore today. :D |
| 20:51 |
|
* Space_Librarian |
can finally plot to make fudge |
| 20:51 |
|
jcamins |
Awesome! |
| 20:55 |
|
ibeardslee |
did you use your 5 finger shoes? |
| 20:56 |
|
|
luisb joined #koha |
| 21:00 |
|
Space_Librarian |
ibeardslee, next year - I haven't had them long enough to think it was a good idea. |
| 21:51 |
|
Space_Librarian |
lovely people - when organising serial subscriptions - and the issue number goes up indefinitely, while the volume number ticks over ever 12 issues... how does one set this up? I've RTFM'd, and I've tried all possible variations on the theme. Guidance would be most appreciated so early on a Monday morning... Pretty please? |
| 21:52 |
|
jcamins |
Space_Librarian: you set the numbering to Volume, Number. |
| 21:52 |
|
jcamins |
Then you set rollover to 12. |
| 21:52 |
|
jcamins |
I think. |
| 21:52 |
|
eythian |
hi |
| 21:53 |
|
Space_Librarian |
hey eythian |
| 21:54 |
|
Space_Librarian |
jcamins: and the issue number? (that's where it seems to get iffy) |
| 21:54 |
|
cait |
Space_Librarian: every 12 the X + 1 and y +1 indefinitely, right? |
| 21:54 |
|
cait |
I think you need to use a special pattern here |
| 21:54 |
|
jcamins |
Space_Librarian: oh, I misunderstood. |
| 21:54 |
|
cait |
I have documentation for that... but it's on the hard drive at work |
| 21:54 |
|
Space_Librarian |
There is a paatern |
| 21:54 |
|
jcamins |
Space_Librarian: I have a really bad cold, sorry. |
| 21:54 |
|
Space_Librarian |
pattern* |
| 21:54 |
|
Space_Librarian |
jcamins: np |
| 21:54 |
|
jcamins |
It's like newspapers. |
| 21:55 |
|
Space_Librarian |
I've tried the one in the manual, and it doesn't want to work for me. |
| 21:55 |
|
cait |
I use numbering pattern = none of the above and an advanced pattern for those |
| 21:55 |
|
Space_Librarian |
cait: that's what I was attempting to do |
| 21:55 |
|
cait |
but the problem with advanced patterns is, that the 'test prediction pattern' is broken |
| 21:55 |
|
cait |
so don't look at that |
| 21:55 |
|
cait |
at all |
| 21:56 |
|
Space_Librarian |
right. that's where I'm going wrong then |
| 21:56 |
|
Space_Librarian |
I'm looking at it. |
| 21:56 |
|
cait |
yes |
| 21:56 |
|
cait |
it's very very annoying |
| 21:56 |
|
cait |
not sure we have a bug for that |
| 21:56 |
|
Space_Librarian |
*nods* |
| 21:56 |
|
cait |
but we shoud have one |
| 21:57 |
|
cait |
I think advanced should be |
| 21:57 |
|
Space_Librarian |
so the instructions in the manual http://miburl.com/qRutUg is right? |
| 21:57 |
|
cait |
begins with (your year) add 1 once every 1 when more than 9999999 |
| 21:57 |
|
Space_Librarian |
cool. done that |
| 21:57 |
|
cait |
for x |
| 21:57 |
|
cait |
and |
| 21:57 |
|
cait |
oh |
| 21:57 |
|
cait |
sorry |
| 21:58 |
|
cait |
x = 1, 12, 9999999, empty, 0, year |
| 21:58 |
|
cait |
now I confused myself, ignoreme |
| 21:59 |
|
* Space_Librarian |
is confused. And would offer cait chocolate, but isn't sure how lent is going... |
| 21:59 |
|
cait |
heh |
| 21:59 |
|
cait |
still trying |
| 21:59 |
|
cait |
ok |
| 21:59 |
|
cait |
slowly |
| 21:59 |
|
cait |
the first number |
| 21:59 |
|
cait |
changes every 12, right? |
| 21:59 |
|
cait |
so |
| 21:59 |
|
Space_Librarian |
yep |
| 22:00 |
|
cait |
add 1 once every 12, when more than when more than 99999, empty, 0, 1 (I think) |
| 22:00 |
|
cait |
then the second goes up every issue by 1 |
| 22:01 |
|
cait |
so |
| 22:01 |
|
cait |
1, 1, 99999, empty, 0, issuenumber |
| 22:01 |
|
cait |
and the last for the first is not one, but your year or whatever |
| 22:01 |
|
cait |
I should test that |
| 22:02 |
|
Space_Librarian |
sweet. :) |
| 22:02 |
|
Space_Librarian |
Thank you! |
| 22:02 |
|
cait |
hope it works :) |
| 22:02 |
|
Space_Librarian |
Should I wait on your test? |
| 22:02 |
|
cait |
yep, wait a second |
| 22:05 |
|
cait |
yep it works |
| 22:07 |
|
cait |
I got the first date wong, should be january |
| 22:07 |
|
cait |
and the prediction pattern preview is wrong, but we already knew that |
| 22:08 |
|
cait |
Space_Librarian: still there? :) |
| 22:11 |
|
cait |
now I scared her away |
| 22:11 |
|
cait |
:( |
| 22:14 |
|
Space_Librarian |
just got a cuppa tea... |
| 22:14 |
|
Space_Librarian |
:) |
| 22:15 |
|
Space_Librarian |
cait++ :) |
| 22:19 |
|
|
BobB joined #koha |
| 22:32 |
|
cait |
night #koha |
| 22:33 |
|
|
cait left #koha |
