Time 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) 05:12 cait good morning #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 09:10 cait morning mbalmer 09:10 mbalmer morgen! 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 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? 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:06 cait [off] http://librarygeekgirl.de/pics/Auswahl_008.png 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:08 cait [off] http://librarygeekgirl.de/pics/Auswahl_009.png 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:32 cait night #koha