IRC log for #koha, 2012-02-26

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

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

← Previous day | Today | Next day → | Search | Index

koha1