Time Nick Message 00:45 bencahill okay, I've run Devel::NYTProf on mainpage.pl, and it took about 5 sec, highest is 673ms for DBI::st::execute 00:46 jcamins_away bencahill: you'll need to tune your MySQL settings most likely. That seems rather long. 00:47 bencahill jcamins_away: could you give me some advice? I'm not quite a mysql expert :P 00:52 jcamins_away bencahill: not much, as it's almost time for dinner and I'm starving. 00:52 bencahill jcamins_away: I forgot to mention, this is on a p4 2.5...is this about the fastest I can expect? 00:52 bencahill jcamins_away: np ;) 00:52 jcamins_away bencahill: but, see http://wiki.koha-community.org/wiki/Koha_Tuning_Guide 00:52 bencahill sweet 00:52 jcamins_away bencahill: how much RAM? 00:52 bencahill 640MB :-/ 00:52 bencahill iirc 00:53 bencahill actually, no...it's 1GB 00:53 bencahill only 235MB in use right now 00:54 bencahill jcamins_away: I hadn't seen that tuning page before...I'm checking that out now, thx 00:57 mtj bencahill: be aware that you are running a VM on windows :) 00:57 jcamins_away bencahill: definitely need to tune MySQL, then. 00:57 jcamins_away Good luck. 00:57 jcamins_away Ohhh. 00:57 jcamins_away On a P4? 00:57 jcamins_away That's your problem. 00:57 * jcamins_away goes to eat dinner. 00:57 bencahill mtj: no... ? 00:57 wahanui no is failing unit tests 00:57 bencahill lol 00:59 mtj bencahill: oops, sorry - i misread my scrollback :p 00:59 bencahill I just wanted to see if I could get it any faster atm, eventually will be getting a faster server 00:59 bencahill mtj: ;) 00:59 bencahill mtj: ironically, I am on windows right now...using putty with a couple of screen sessions :P 00:59 mtj but hay... good to hear that you *aren't* running it in a windows VM 01:00 bencahill hehe 01:01 * bencahill detests windows, if only for its slowness 01:01 bencahill windows? 01:01 wahanui windows is, like, a poor fit for free software like Koha. Some of the thing's we use heavily are not easily available at the moment. No-one's funded Koha 3.x for Windows and I'm not sure who'd be willing to work on it. You are probably best off using a liveCD for testing, then commissioning a GNU/Linux server 01:01 bencahill true dat 01:01 bencahill arch? 01:01 wahanui somebody said arch was extremely simple in philosophy...so the less 'stuff', the better 01:02 bencahill well, true dat as well :P 01:02 bencahill I think I'll take me one of the bot 01:04 bencahill ubuntu? 01:04 wahanui i heard ubuntu was a operating system 01:05 bencahill lol, okay, I'm done now 01:05 mtj bencahill: re; Koha tuning, try a 1<core cpu 01:05 bencahill mtj: that read a little odd, one less than core :P 01:05 bencahill mtj: but yeah, will get one at some point 01:05 mtj and having your zebra database on a 2nd disk 01:05 bencahill mtj: why so? 01:08 mtj zebra and mysql often get busy under load, a multi-core cpu handles that a bit better 01:09 mtj same with disk stuff too 01:09 bencahill mtj: gotcha...I might try that, I'm sure I've got a disk I could use somewhere around here :P 01:10 mtj have a raided mysql filesystem, and a unraided fast zebra disk 01:10 mtj ive used that method on prod systems with good results 01:11 mtj and run mysqltuner.pl on your box too 01:12 mtj but, if you have a Koha with not much data in it, those techniques wont make too much difference 01:13 bencahill about 2k biblios and items 01:13 mtj ok, not much.... 01:14 bencahill yeh 01:14 bencahill mainly just the p4 then, and not much I can do at this point? 01:14 mtj sounds like a 'cpu is just too slow' problem 01:15 bencahill I ran some cpu tests a few days ago comparing it against my (~6-year-old) laptop's athlon64 1.8 (single-core), and the laptop beat it by a factor of about 1.5, so... :P 01:16 Space_Librarian right, people of #koha - help! I've looked through the wiki, and I can't find anything... looking for a report to pull "all items with holds placed on them" - do we have this somewhere? Have I just missed it? Help? 01:18 mtj reports? 01:18 mtj koha reports? 01:19 Space_Librarian yep 01:19 mtj (thought i might get lucky :) ) 01:19 Space_Librarian SQL reports library... 01:19 wahanui hmmm... sql reports library is at http://wiki.koha-community.org/wiki/SQL_Reports_Library 01:19 Space_Librarian I love wahanui sometimes. 01:22 mtj 'Holds to Pull at Branch' 01:22 pastebot "mtj" at 203.97.99.222 pasted "sql" (9 lines) at http://paste.koha-community.org/240 01:23 mtj something like that? 01:23 mtj its the 'Holds to Pull at Branch' sql, with the WHERE stuff removed... 01:27 Space_Librarian orly? *has a look* 01:28 Space_Librarian Thanks! I'll try it. :) 01:35 Space_Librarian Absolutely brilliant. Thanks mtj! 01:37 ibeardslee oh hai Space_Librarian how is the new job going? 02:08 druthb o/ 02:08 Space_Librarian Ruth! :D 02:08 druthb ! :D :D 02:10 * Space_Librarian *does a happy dance* 02:12 * druthb does a happy dance, too! 02:14 Space_Librarian hai there ibeardslee - new job is going! ;) 02:59 jcamins_away @later tell wizzyrea Could you please update the front page on the Koha website so that the "Bugs to be signed off" link points to the current list of bugs to be signed off? 02:59 huginn` jcamins_away: The operation succeeded. 02:59 jcamins_away @later tell wizzyrea Thanks! 02:59 huginn` jcamins_away: The operation succeeded. 03:26 Amit_Gupta heya bag 03:57 Space_Librarian right #koha - seeya next week! 04:18 mib_yrhs32 hi 05:05 bencahill g'night, #koha :) 05:16 cait hi #koha 05:33 cait @wunder Konstanz 05:33 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -12.0�C (6:29 AM CET on February 03, 2012). Conditions: Clear. Humidity: 71%. Dew Point: -16.0�C. Windchill: -15.0�C. Pressure: 30.38 in 1028.7 hPa (Rising). 06:37 cait @wunder Konstanz 06:37 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -12.8�C (7:35 AM CET on February 03, 2012). Conditions: Clear. Humidity: 74%. Dew Point: -16.0�C. Windchill: -13.0�C. Pressure: 30.40 in 1029.3 hPa (Rising). 06:37 magnuse @wunder boo 06:37 huginn` magnuse: The current temperature in Bodo, Norway is -8.0�C (7:20 AM CET on February 03, 2012). Conditions: Mostly Cloudy. Humidity: 42%. Dew Point: -19.0�C. Windchill: -19.0�C. Pressure: 30.66 in 1038 hPa (Steady). 06:37 cait hmpf 06:37 magnuse brr 06:38 magnuse bbiab 06:54 Amit_Gupta heya cait, magnuse 06:56 cait hi Amit_Gupta 07:04 cait @wunder Konstanz 07:04 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -12.8�C (7:59 AM CET on February 03, 2012). Conditions: Clear. Humidity: 73%. Dew Point: -17.0�C. Windchill: -17.0�C. Pressure: 30.40 in 1029.3 hPa (Steady). 07:21 magnuse hiya Amit_Gupta 07:21 magnuse @wunder kautokeino 07:21 huginn` magnuse: The current temperature in Kautokeino, Norway is -28.0�C (7:00 AM CET on February 03, 2012). Conditions: Partly Cloudy. Humidity: 65%. Dew Point: -31.0�C. Pressure: 30.80 in 1043 hPa (Falling). 07:21 cait ok 07:21 cait there are places colder than here 07:21 cait only not feels like it right now 07:21 magnuse hehe 07:25 magnuse @wunder drevsjo, norway 07:25 huginn` magnuse: The current temperature in Roros Lufthavn, Norway is -32.0�C (7:50 AM CET on February 03, 2012). Conditions: Light Snow. Humidity: 69%. Dew Point: -36.0�C. Windchill: -38.0�C. Pressure: 30.63 in 1037 hPa (Steady). 07:26 alex_a morning koha 07:26 cait morning alex_a 07:26 cait @wunder Marseille 07:26 huginn` cait: The current temperature in Marseille, France is -4.0�C (8:00 AM CET on February 03, 2012). Conditions: Clear. Humidity: 69%. Dew Point: -9.0�C. Windchill: -11.0�C. Pressure: 30.01 in 1016 hPa (Steady). 07:26 magnuse there is another place called Drevsj� not too far from R�ros that had -36,5 at 07 this morning - better now cait? ;-) 07:26 magnuse bonjour alex_a 07:26 cait magnuse: no 07:26 alex_a bonjour cait magnuse 07:26 cait I still don't want to walk to work 07:26 magnuse wow, that's cold for Marseille, isn't it? 07:27 alex_a magnuse: yes, very very cold 07:28 magnuse and houses are probably not built for it? 07:28 magnuse i can imagine the biblibre office being quite cold with that tempaerature... 07:28 cait brr 07:28 alex_a magnuse: houses yes but not the people 07:28 magnuse hehe 07:31 alex_a i've installed koha in standard mode for the first time yesterday (:)). But anyone can tell what is the difference between standard and dev mode ? 07:32 cait files and directories live in other places 07:32 alex_a only sow that configuration files and log goes in /etc/koha and /var/log. but what eles ? 07:32 magnuse in standard the files are scattered in different places - in dev you run off a git repo 07:33 magnuse i think C4 lives in /usr/share/koha or something? 07:33 rangi usually /usr/share/koha 07:33 rangi the scripts too 07:33 rangi nothing runs out of the git checkout 07:33 rangi because normally you do it from a tarball, and dont even have a git checkout 07:33 alex_a yes 07:33 rangi plus running production code, in your home dir = bad wrong and evil :) 07:35 * magnuse did that for 2,5 years 07:35 magnuse then the packages came along and saved me... ;-) 07:35 cait heh 07:35 cait we still do... but having git is better than having no git 07:39 magnuse hiya mbalmer 07:39 cait hi mbalmer 07:39 mbalmer good morning 07:40 magnuse @wunder wellington, nz 07:40 huginn` magnuse: The current temperature in Wellington, New Zealand is 18.0�C (8:00 PM NZDT on February 03, 2012). Conditions: Mostly Cloudy. Humidity: 59%. Dew Point: 10.0�C. Pressure: 30.01 in 1016 hPa (Steady). 07:40 magnuse ooh... 07:40 cait @wunder Konstanz 07:40 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -12.7�C (8:34 AM CET on February 03, 2012). Conditions: Clear. Humidity: 73%. Dew Point: -16.0�C. Windchill: -17.0�C. Pressure: 30.41 in 1029.7 hPa (Rising). 07:40 cait oh from 12.8 to 12.7 07:40 cait ... 07:40 cait *sigh* 07:40 magnuse hey, that's up 0.1! 07:40 cait time to go 07:41 mbalmer @wunder brussels 07:41 huginn` mbalmer: Error: No such location could be found. 07:41 rangi thats stupid cold 07:41 mbalmer @wunder bruxelles 07:41 huginn` mbalmer: The current temperature in Zonnebos, Steenokkerzeel, Belgium is -11.5�C (8:40 AM CET on February 03, 2012). Conditions: Clear. Humidity: 79%. Dew Point: -14.0�C. Windchill: -12.0�C. Pressure: 30.78 in 1042.2 hPa (Steady). 07:41 mbalmer fuck 07:41 cait not much better 07:41 mbalmer I'm going to freez... 07:41 reiveune hello 07:41 rangi hi reiveune 07:41 magnuse bonjour reiveune 07:42 reiveune hi everybody, I'm on bz4032 today 07:42 magnuse bug 4032 07:42 wahanui bug 4032 is completely independent 07:42 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4032 enhancement, P1 - high, ---, henridamien, NEW , XSLT systempreference should take a path to file rather than YesNo 07:42 magnuse yay 07:42 magnuse wahanui: forget bug 4032 07:42 wahanui magnuse: I forgot bug 4032 07:43 rangi if someone could sign off on bug 7432 07:43 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7432 critical, P1 - high, ---, paul.poulain, Needs Signoff , Changing frameworks should refresh cache 07:43 rangi that would be excellent 07:43 rangi it fixes a really nasty bug 07:43 rangi (everything we memoize_memcached was being set for infinite timeout so never timing out .. and getting refreshed) 07:44 magnuse that reminds me i need to try getting memcached set up on my server 07:50 magnuse bonjour julian_m paul_p 07:52 julian_m hello magnuse 07:52 paul_p hi magnuse 07:58 rangi hi paul_p Guillaume and julian_m 07:58 Amit_Gupta heya paul_p, rangi 07:58 paul_p hi rangi (seen your "later") 07:58 paul_p rangi thx for jenkins DB fix ! 07:59 paul_p @weather marseille 07:59 huginn` paul_p: The current temperature in Marseille, France is -4.0�C (8:30 AM CET on February 03, 2012). Conditions: Clear. Humidity: 69%. Dew Point: -9.0�C. Windchill: -11.0�C. Pressure: 30.01 in 1016 hPa (Steady). 07:59 paul_p -4°C ! the coldest i've ever seen in 12 years in Marseille probably !!! 08:00 * paul_p hope the lemontree in his garden will survive... fortunately there is almost no wind 08:00 rangi no problem 08:05 sophie_m hi #koha 08:06 rangi hi hdl and sophie_m 08:06 hdl hi rangi 08:10 kf hi again #koha 08:10 magnuse woohoo, kf made it! 08:10 magnuse no need to send out a jolly rescue party 08:10 kf had to run from the yetis 08:10 kf ;) 08:11 kf hi asaurat 08:11 magnuse kf: and you out-ran them! 08:11 asaurat hi !! 08:11 rangi wb kf 08:28 gaetan_B hello 08:30 kf :) 08:30 kf hi gaetan_B 08:32 asaurat bugs I sent a patch for, and which should be quickly tested: 08:32 asaurat bug 4969 08:32 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4969 minor, P5 - low, ---, adrien.saurat, Needs Signoff , Vendors can not be deleted / show only active vendors 08:32 drojf1 good day #koha 08:32 kf guten morgen drojf1 :) 08:32 drojf1 moin kf :) 08:32 asaurat hallo drojf1! 08:32 drojf1 hi asaurat 08:32 kf asaurat: a way to make that happen faster is by signing off on someon else's bug 08:33 asaurat kf: yes, I'll sign some bugs today, I'm just telling which bugs of mine are easy to test =) 08:33 kf fair :) 08:33 asaurat bug 7488 08:33 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7488 minor, P5 - low, ---, adrien.saurat, Needs Signoff , Errors with logs about moremember.pl / Messaging.pm 08:34 kf asaurat: I havet them all on my todo list even I think - only no time right now :( 08:34 asaurat and bug 7457 08:34 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7457 normal, P5 - low, ---, adrien.saurat, Needs Signoff , basket.pl makes a lot of noise in the logs 08:37 mib_ftvpyi hi 08:37 wahanui hi, mib_ftvpyi 08:38 mib_ftvpyi i have few query 08:38 mib_ftvpyi mean queries 08:39 mib_ftvpyi r u free? 08:40 kf @wunder Konstanz 08:40 huginn` kf: The current temperature in Taegerwilen, Taegerwilen, Germany is -12.3�C (9:39 AM CET on February 03, 2012). Conditions: Mostly Cloudy. Humidity: 70%. Dew Point: -17.0�C. Windchill: -17.0�C. Pressure: 30.43 in 1030.4 hPa (Steady). 08:40 kf @wunder boo 08:40 huginn` kf: The current temperature in Bodo, Norway is -8.0�C (9:20 AM CET on February 03, 2012). Conditions: Mostly Cloudy. Humidity: 38%. Dew Point: -20.0�C. Windchill: -18.0�C. Pressure: 30.66 in 1038 hPa (Steady). 08:41 kf @wunder marseille 08:41 huginn` kf: The current temperature in Marseille, France is -3.0�C (9:30 AM CET on February 03, 2012). Conditions: Clear. Humidity: 64%. Dew Point: -9.0�C. Windchill: -10.0�C. Pressure: 30.04 in 1017 hPa (Rising). 08:41 mib_ftvpyi Can some 1 help me in koha 08:41 mib_ftvpyi ?????????? 08:43 Amit_Gupta heya mib_ftvpyi 08:43 kf mib_ftvpyi: do't ask to ask - just ask :) 08:43 Amit_Gupta heya kf :D 08:44 mib_ftvpyi What is library , branches and group in administration 08:44 mib_ftvpyi what is difference 08:44 wahanui difference is, like, merely that 008 uses defined value lists and 260 $a is merely transcribed from the material 08:44 kf documentation? 08:44 wahanui documentation is probably at http://koha-community.org/documentation/ 08:44 kf you need to configure lbraries 08:44 kf you can add groups for some opac search feature, but you don't need to 08:45 mib_ftvpyi that means....internally we dont require it 08:47 drojf1 you need one library ;) 08:47 kf yep, you must have a tleast one library 08:47 kf but don't worry about groups 08:48 drojf1 is groups new? i dont think i remember that 08:48 magnuse wahanui: forget difference 08:48 wahanui magnuse: I forgot difference 08:52 kf drojf1: no, it's really old 08:52 francharb morning 08:52 mib_ftvpyi amit can we speak on phone so that we can have a better clarity 08:52 kf drojf1: I think it once used to do a lot more that it can do now 08:52 mib_ftvpyi i think on chat i am not ale to explain 08:54 kf magnuse++ 08:55 drojf1 kf: ok, maybe i just dont remember because we don't need it. haven't had a look in the actual system in a while 08:55 kf drojf1: you hardly get there after initial setup 08:55 drojf1 yes 08:55 kf you can use groups to group libraries together for search 08:55 kf say you have a lot of branches 08:56 kf and want to group them by area 08:56 drojf1 ah, that rings a bell 08:56 kf then the library pull down in opac will offer the search group 08:56 kf to limit search to those branches 08:57 drojf1 one day we will suddenly expand and need that. i wish :) 09:03 magnuse bug 7489 should be an easy signoff :-) 09:03 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7489 normal, P5 - low, ---, magnus, Needs Signoff , Implement DisplayOPACiconsXSLT for NORMARC XSLT 09:05 kf drojf1: :) 09:07 christophe_c hello 09:07 wahanui privet, christophe_c 09:07 kf hi christophe_c :) 09:08 christophe_c ;-) 09:22 huginn` New commit(s) needsignoff: [Bug 7286] fix rebuild_zebra.pl to add rebuild_zebra_sliced.zsh <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7286> 09:35 sophie_m taking http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6199 09:35 huginn` 04Bug 6199: enhancement, PATCH-Sent (DO NOT USE), ---, robin, Needs Signoff , Allow bulkmarcimport to blank duplicate barcodes rather than skipping items 09:38 drojf1 anybody knows how this was generated? http://wiki.koha-community.org/wiki/File:Kohastructure.png 09:38 drojf1 or did nengard do that by hand? (i hope not) 09:39 drojf1 oh, its there in the lower right corner. im just blind, or the pic is too big ;) 09:44 kf drojf1: not sure, it's quite old 09:45 kf I think it was not nengard, but perhaps paul? 09:45 paul_p kf ? could you signoff 7432 ? 09:45 kf do you know about schema.koha-community.org 09:45 kf bug 7432 09:45 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7432 critical, P1 - high, ---, paul.poulain, Needs Signoff , Changing frameworks should refresh cache 09:45 paul_p I think I can QA it &push quickly 09:45 kf paul_p: not today 09:45 paul_p (this bug has been reported by you) 09:45 kf paul_p: meeting and too much work 09:47 kf and I don't have memcache working here 09:47 paul_p drojf1 no, I don't know how Kohastructure.png has been generated. Maybe some tool from schema.koha-community.org ? 09:47 drojf1 kf: created by SQL::Translator 0.07, it's in the picture. thanks for your link, that looks lovely 09:47 kf paul_p: I think it's really old - the pic I mean. 09:49 kf [off] seems it was atz? http://librarypolice.com/wiki.koha.org/en:development:dbschema.html 09:49 drojf1 yes, it's old. 9 May 2010. i was just wondering how to get that kind of graphical output. SQL::Translator seems to be the answer 09:49 magnuse i seem to remember zeno tajoli being involved with that graphic, but i might be wrong 09:52 kf magnuse: that one is really old - zeno did the schema things 10:01 drojf1 so when are we doing all those video tutorials that are requested lately? ;) 10:01 kf lol 10:01 kf_mtg will be back later - happy bug squashing :) 10:01 asaurat testing bug 6968 10:01 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6968 enhancement, PATCH-Sent (DO NOT USE), ---, colin.campbell, Needs Signoff , Show items expired before today in check expiration of serials page 10:02 asaurat bis bald, kf! 10:43 paul_p QAing 7387 10:43 magnuse bug 7387 10:43 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7387 enhancement, PATCH-Sent (DO NOT USE), ---, chris, Signed Off , Add Template::Toolkit plugin to allow caching of includes 10:43 magnuse yay! 10:48 slef is rangi still around? 10:53 paul_p magnuse why yay ? (i've transfered bug 7387 to "in discussion") 10:53 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7387 enhancement, P1 - high, ---, chris, In Discussion , Add Template::Toolkit plugin to allow caching of includes 10:54 magnuse paul_p: then it's less yay - i had hoped it would pass qa, of course ;-) 10:59 paul_p QAing bug 7431 10:59 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7431 major, P5 - low, ---, gcollum, Passed QA , OPAC item hold list doesn't show 'checked out' 11:00 paul_p tiny patch, passed QA 11:04 marcelr hi paul_p 11:04 paul_p hi marcelr, and thx 11:04 marcelr looking at 7422 11:05 paul_p QAing bug 7450 11:05 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7450 critical, P5 - low, ---, adrien.saurat, Passed QA , Missing placeholders in admin/authorised_values.pl 11:05 paul_p marcelr if you say bug 7422 and not only 7422, everybody will see the bug description 11:05 * magnuse looking at bug 7264 11:05 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7422 enhancement, P5 - low, ---, adrien.saurat, Signed Off , Prevent creation of vendors with the same name 11:05 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7264 enhancement, PATCH-Sent (DO NOT USE), ---, srdjan, Needs Signoff , Display information about library on OPAC detail 11:06 marcelr paul_p: ok 11:07 drojf1 i have a perl question. let's say i have '$var1="one"' and 'var2="two"'. i want to print '$var1', the letter "s" and then '$var2', without any space in between, like "onestwo". if i say 'print "$var1s$var2"' the first var name is interpreted as '$var1s', so i get an error. if i use 'print "$var1\s$var2"' it works, but i get "Unrecognized escape \s passed through" so i guess its not the right way to do it. i could put "s" in a var, but that seems like o 11:09 magnuse $var1, "s", $var2 11:09 magnuse i think? 11:09 magnuse or rather: print $var1, "s", $var2 11:14 drojf1 thanks magnuse! 11:18 paul_p marcelr QAing ... my lunch. see you at 2PM 11:18 marcelr bon appetit 11:19 francharb lunch time 11:21 * marcelr Only 19 in signed off state left.. 11:25 huginn` New commit(s) kohagit: bug 7450 small follow-up, removing warn <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1034b21dea0460b58ef63550cf920b17d5e2662e> / Bug 7450: missing placeholders in authorised_values.pl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f0a660093442941ee11c0c2fe11402eebfa45a01> / Bug 7431: Fixes the display of the due date in opac item specific holds. <http://git.koha-community.org/gitweb/?p 11:31 jenkins_koha Starting build #613 for job Koha_master (previous build: FIXED) 12:10 kf drojf1: I think you can do something with {} too 12:10 kf ${var}s 12:12 drojf1 kf: yeah that sounds right. i thought i did it like that once. but i tried only {$var}s and that screws up a lot 12:12 drojf1 thanks 12:12 kf no worries :) 12:13 marcelr paul_p: picking bug 7461 now.. 12:13 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7461 minor, P5 - low, ---, oleonard, Signed Off , cart offering to remove items when closing 12:13 * drojf1 is too old to remember everything :) 12:13 kf hmpf 12:13 kf bet you are younger than me! 12:13 drojf1 #koha is part of my brain now ;) 12:13 kf ok, I can support that last part :) 12:14 drojf1 heh 12:14 slef drojf1: yeah, I use wahanui instead of a search engine sometimes 12:14 kf wahanui botsnack cookies 12:14 wahanui thanks kf :) 12:14 slef and huginn` is a search engine 12:14 kf but people forget to feed him 12:14 kf poor bot 12:15 slef marcelr: could you try bug 7476 - should be a quick one I think? 12:15 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7476 normal, P3, ---, aleksa, Signed Off , Files executable that probably should not be 12:15 marcelr will have a look 12:18 kf ok, now part of the lake is frozen... so people start talking about skating 12:18 kf brrr 12:18 kf @wunder Konstanz 12:18 huginn` kf: The current temperature in Konstanz, Germany is -9.0�C (1:00 PM CET on February 03, 2012). Conditions: Scattered Clouds. Humidity: 37%. Dew Point: -18.0�C. Pressure: 30.46 in 1032 hPa (Rising). 12:20 drojf1 kf: on bodensee? is that safe? 12:20 kf on part of it, not so deep 12:20 drojf1 ok 12:20 kf gnadensee 12:21 drojf1 @wunder berlin, germany 12:21 huginn` drojf1: The current temperature in Prenzlauer Berg, Berlin, Germany is -5.8�C (1:13 PM CET on February 03, 2012). Conditions: Mostly Cloudy. Humidity: 66%. Dew Point: -11.0�C. Windchill: -6.0�C. Pressure: 30.57 in 1035.1 hPa (Steady). 12:22 drojf1 getting better here :) 12:22 drojf1 but new snow 12:22 kf better here too - we started with -13 this morning 12:24 slef @marc 300 12:24 huginn` slef: A physical description of the described item, including its extent, dimensions, and such other physical details as a description of any accompanying materials and unit type and size. (Repeatable) [a,b,c,e,f,g,3,6,8] 12:25 slef hrrrm 12:25 kf what are you looking for? 12:25 drojf1 huginn` knows marc? that might be helpful for me too 12:25 huginn` drojf1: downloading the Perl source 12:25 drojf1 huch 12:25 kf @marc 200a 12:25 huginn` kf: unknown tag 200a 12:25 drojf1 what did i do now? 12:25 kf @marc 300a 12:25 huginn` kf: unknown tag 300a 12:25 slef kf: that gets labelled as Description by OPACxslt... 12:25 kf hmm 12:25 slef @marc 300 a 12:25 huginn` slef: Extent The number of pages, volumes, cassettes, total playing time, etc., of the described item. (Repeatable) 12:25 kf @marc 300 a 12:25 huginn` kf: Extent The number of pages, volumes, cassettes, total playing time, etc., of the described item. (Repeatable) 12:25 jenkins_koha Project Koha_master build #613: UNSTABLE in 54 mn: http://jenkins.koha-community.org/job/Koha_master/613/ 12:25 jenkins_koha * m.de.rooy: 6964 Follow-up typo borrowenumber 12:25 jenkins_koha * f.demians: Bug 7355 Note subfields are not displayed in TEXTAREA if hidden 12:25 jenkins_koha * gcollum: Bug 7431: Fixes the display of the due date in opac item specific holds. 12:25 jenkins_koha * adrien.saurat: Bug 7450: missing placeholders in authorised_values.pl 12:25 jenkins_koha * paul.poulain: bug 7450 small follow-up, removing warn 12:25 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7355 enhancement, P3, ---, frederic, Pushed to Master , Note subfields are not displayed in TEXTAREA if hidden 12:25 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7431 major, P5 - low, ---, gcollum, Pushed to Master , OPAC item hold list doesn't show 'checked out' 12:25 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7450 critical, P5 - low, ---, adrien.saurat, Pushed to Master , Missing placeholders in admin/authorised_values.pl 12:25 slef kf: wondering if there's a better word for it. 12:26 kf slef: seems not wrong to me 12:26 kf most of the time will be pages 12:26 kf perhaps size 12:26 slef kf: yeah, we've been asked for "Pages" or "Extent". It's not necessarily pages though. 12:26 kf yeah 12:26 slef door 12:26 kf I think making it that would make others complain 12:29 marcelr paul_p: looking at bug 7476 12:29 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7476 normal, P3, ---, aleksa, Signed Off , Files executable that probably should not be 12:31 slef kf: Description makes some complain. They say that's more like 12:31 slef @marc 520 12:31 huginn` slef: Unformatted information that describes the scope and general contents of the materials. This could be a summary, abstract, annotation, review, or only a phrase describing the material. (Repeatable) [a,b,u,3,6,8] 12:31 kf you could do an evil hack with jquery... 12:31 slef which is actually labelled on the tab as "Descripton", to be fair 12:31 kf but I guess you are opposed to that :) 12:32 kf perhaps ask jcamins_away? 12:32 kf or check the labels in other catalogs 12:32 slef mmmm 12:32 kf hm perhaps Physical description? 12:32 * slef goes looking around 12:32 marcelr slef: in the comment of the bash file: This script requires the isutf8 program from Joey Hess's moreutils package. ?? 12:32 kf 520 is more about the content? 12:32 slef kf: Physical description would be accurate but clunky. 12:33 slef marcelr: ha you got me. 12:33 marcelr shall i remove when signing off 12:33 slef marcelr: I cp'd another xt test to start off. 12:33 slef marcelr: if you don't mind, yes, please. Is the Copyright line correct? 12:33 marcelr ok do that 12:33 slef kf: yes 12:35 slef kf: hrm, 520 is only labelled "Description" in the intranet, it's Summary and Title Notes in the OPAC I think. 12:35 slef yay, internal consistency :-/ 12:36 slef anyway, they've not noticed that, it's 300 attracting question ;) 12:38 kf I am out of ideas 12:41 jcamins_away What about me? 12:41 kf slef was looking for a better label for 300 12:42 jcamins_away Physical description? 12:42 kf he didn't like that suggestion ;) 12:43 slef it's better than "Description" but can we do better? 12:43 jcamins_away Not really, no. 12:43 slef ok let me see if that passes the library 12:44 jcamins_away 300$a, 300$b, and 300$c contain very different information. 12:44 jcamins_away 520 should be Summary not Description. 12:47 jcamins_away Okay, better get ready to go. 12:47 jcamins_away I'll be back later. 12:47 kf blue cat? 12:47 slef blue cat? 12:48 kf blue cat is Chester 12:48 kf blue cat? 12:48 wahanui i guess blue cat is Chester 12:48 slef madness? 12:48 kf hehe 12:48 drojf1 meow 12:48 kf the cat of one of jared's clients 12:48 kf is blue 12:48 slef the second sign of madness is hairs on the palms of your hands 12:48 slef the first sign of madness is looking for hairs on the palms of your hands 12:49 kf lol 12:49 drojf1 :) 12:49 kf so nothing new about me 12:51 marcelr bye koha 12:51 kf bye marcelr 12:51 slef bye and thanks marcelr 12:51 kf yep marcelr++ 12:52 slef marcelr++ 12:53 slef @marc 005 12:53 huginn` slef: Sixteen characters that indicate the date and time of the latest record transaction and serve as a version identifier for the record. They are recorded according to Representation of Dates and Times (ISO 8601). The date requires 8 numeric characters in the pattern yyyymmdd. The time requires 8 numeric characters in the pattern hhmmss.f, expressed in terms of the 24-hour (00-23) clock. [] 12:54 * slef ponders that 12:57 slef @marc 856 a 12:57 huginn` slef: Host name The fully qualified domain (host name) of the electronic location. It contains a network address which is repeated if there is more than one address for the same host. (Repeatable) 12:57 slef @marc 856 u 12:57 huginn` slef: Uniform Resource Identifier The URI, which provides standard syntax for locating an object using existing Internet protocols. Field 856 is structured to allow for the creation of a URL from the concatenation of other separate 856 subfields. Subfield $u may be used instead of those separate subfields or in addition to them.Subfield $u may be repeated only if both a URN or a URL or more than one URN are (1 more message) 12:57 slef blah 12:59 slef transcription error by someone 13:04 paul_p hello back 13:04 * paul_p investigates why jenkins became unstable... 13:05 paul_p OK, it's a SIP db_dependant test again. Probably something still wrong with datas in sample DB 13:05 paul_p @later tell rangi jenkins unstable again, seems it's something wrong with sample data 13:05 huginn` paul_p: The operation succeeded. 13:06 * paul_p heads to "passed QA" patches (by marcelr or sekjal) 13:18 drojf1 what is a safe place to store some extra information in marc21 9xx that does not interfere with koha? 13:18 paul_p bug 6984 pushed 13:18 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6984 critical, P5 - low, ---, gcollum, Passed QA , Holds Statistics Doesn't Work 13:18 paul_p drojf1 any field, except 952 and 942 13:18 paul_p disclaimer: i'm not a MARC21 specialist 13:18 drojf1 i think 999 is also used somehow 13:19 kf yes 13:19 kf those 3 13:19 drojf1 ok i will roll a dice then. a dice with like 97 numbers :D 13:19 drojf1 thanks paul_p and kf 13:19 kf drojf1: for Germany 13:20 kf there is something 13:20 paul_p bug 7459 pushed 13:20 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7459 major, P2, ---, m.de.rooy, Passed QA , Can only add to one public list in OPAC search results 13:20 kf drojf1: they divided the 9xx fields for use... between different institutions 13:20 kf let me find the safe range for you 13:20 drojf1 kf i found that once. but then never again 13:20 drojf1 so i thought i would ignore that ;) unless you know where to find it 13:21 kf http://www.d-nb.de/standardisierung/pdf/v_068b.pdf 13:21 kf 980-999 13:22 kf formally 942 belongs to bvb and 952 to gbv... but I would just ignore that until you run into problems one day 13:22 drojf1 thanks. you are a good part of my brain :) 13:22 kf aaw 13:29 drojf1 @marc 952y 13:29 huginn` drojf1: unknown tag 952y 13:29 drojf1 heh 13:29 drojf1 in 952y is koha expecting the media code or the media description? like, 'bk' or 'Book'? 13:34 magnus_afk drojf1: http://wiki.koha-community.org/wiki/Holdings_data_fields_%289xx%29#MARC21_Holding_field.2C_3.0.x.2C_3.2.x_and_3.4.x_default_-_field_952 13:37 drojf1 takk magnus_afk 13:42 chris_n looks like PTFS woke up 13:44 chris_n http://koha-community.org/update-2-nz-koha-trademark-situation/comment-page-1/#comment-4452 13:46 oleonard We'll see. Progress, at least, that they're not pretending no one has requested to talk to them. 13:46 drojf1 depends on what that response is 14:12 * oleonard 's pre-commit hook doesn't seem to be working... 14:12 * oleonard wonders why... 14:15 * oleonard finds that neither "git diff" commands in the pre-commit file return any changed files 14:24 paul_p bug "signed-off" list down to 14 ! probably the lowest # since months !!! 14:25 kf :) 14:25 kf pretty busy day 14:25 kf ok 14:25 kf sanity check 14:25 kf is it being to picky to think a table should have another name? aqinvoices instead of invoices? 14:25 kf aq is the only module we have something like a prefix for most tables 14:26 paul_p kf that's a question we've asked with joubu on the wiki page "DB shema bugs". 14:26 kf it's a new table 14:26 paul_p kf http://wiki.koha-community.org/wiki/DB_schema_bugs 14:26 kf bug 5339 14:26 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5339 enhancement, P3, ---, julian.maurice, Needs Signoff , Parcel closing in acq 14:27 paul_p kf My opinion is = let's remove those strange "aq" prefix, so don't introduce a new table starting with it ! 14:27 oleonard Other things have prefixes too kf: borrower, import, marc, language, tags 14:28 kf hm I think I like that they are grouped together paul_p 14:28 kf so the prefix makes a lot of sense to me 14:28 kf and like oleonard said, we have some other similar things 14:28 kf and removing from all will be a lot more work, thatn making a new table fit into an existing pattern :) 14:28 paul_p kf I propose: 14:29 paul_p * you signoff the patch if its OK 14:29 paul_p * you say "sign-offed" but set "in discussion" because of table name 14:29 paul_p * you set to "in discussion" 14:29 kf no time for testing now - so it will sit around abit longer I fear 14:30 paul_p no prob 14:30 paul_p (maybe set "in discussion" directly then !) 14:30 kf done 14:37 jcamins Good morning again, #koha. 14:37 oleonard paul_p: I have a question about your pre-commit hook (http://wiki.koha-community.org/wiki/Tips_and_tricks) 14:38 paul_p oleonard yep ? 14:38 kf paul_p: and I have a question about data privacy :) do you delete borrowres from deletedborrowers regularly for your libraries? or other regular scheduled deletes/anonymisations? 14:38 oleonard It doesn't seem to be working for me, and I notice that the 'git diff' commands used in pre-commit don't return any files 14:38 * kf gets into the question queue 14:40 paul_p kf nope. And I think/feel it's bad and we should 14:40 paul_p oleonard is your file executable ? 14:40 paul_p (the pre-commit one) 14:40 kf ... and there goes my hope you had some scripts and experience with it :) 14:40 kf paul_p: we work on documents for data privacy... and I have to write a delete concept 14:41 paul_p kf nope. Until now, we just made as if it was really deleted. head hidden in the sand (frenchism suspected) 14:42 oleonard paul_p: That was the problem. Not executable. Thanks! 14:42 paul_p oleonard I had the same problem 14:42 paul_p ;-) 14:42 paul_p (and mine didn't worked for months, and I didn't spotted it !) 14:43 paul_p s/months/weeks/ maybe 14:43 jcamins I need to do a git hook. 14:52 kf yeah me too 14:52 kf paul_p: that was my tactic too so far... but not getting away with it :) 14:57 magnus_afk hm, when i use the reports "Patrons with no Checkouts" and set the date to 2000-01-01 i get ~400 results. when i give "Clean Patron Records" tool the same date i get "0 patrons will be deleted"? 14:57 kf no checkout patrons 14:57 kf can be in borrowers and deletedborrowers 14:57 huginn` New commit(s) kohagit: Bug 6323 -- Error handling cleanup for moveitem.tt <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5bba1353d0a910ee3337e99c0d67cc619608fcb6> / Bug 7238 : Shifting SIPconfig.xml to the etc dir and the scripts to misc/bin <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=43b3fb97015c16d159f67b758ff01483890b42d1> / Bug 7238 Followup - fix sip_run to require path to SIPconfig.xml <http://git.koh 14:57 kf hm 14:57 kf no 14:57 kf ignore me 14:58 kf but it's probably a bug 14:58 magnus_afk yeah, those two ought to give the same result, unless i'm misunderstanding something 14:59 kf Imeant that it was checking issues and old-issues 14:59 kf and I really am confusing things here 14:59 * kf goes to hide behind her documents 15:01 jenkins_koha Starting build #614 for job Koha_master (previous build: UNSTABLE -- last SUCCESS #612 18 h ago) 15:02 drojf1 @marc 041 15:02 huginn` drojf1: Codes for languages associated with an item when the language code in field 008/35-37 of the record is insufficient to convey full information. This includes records for multilingual items, items that involve translation, and items where the medium of communication is a sign language. The sources of the codes are: MARC Code List for Languages or other code lists such as ISO 639-1 (Codes for the (1 more message) 15:02 kf is there a script to delete entries from searchhistory? 15:02 drojf1 @marc 041j 15:02 huginn` drojf1: unknown tag 041j 15:02 kf @marc 041 j 15:02 huginn` kf: unknown field/subfield combination (041/j) 15:02 kf hm 15:02 kf @marc 041 a 15:02 huginn` kf: Language code of text/sound track or separate title The first language code in subfield $a is also contained in field 008/35-37 (Language), unless character positions 35-37 contain blanks (###) or the code "zxx." (Repeatable) 15:02 drojf1 thanks kf :) 15:03 drojf1 its for subtitles, probably huginn` is more into books ;) 15:03 kf heh 15:04 drojf1 so either i am missing something, or the LOC does not differentiate betweent hardcoded and optional subtitles. i cant believe i found something that i cannot code in marc 15:04 jcamins For subtitles? 15:04 jcamins The 041 is for languages. 15:04 drojf1 yes 15:04 drojf1 subtiltes have languages :) 15:04 jcamins The subtitle goes in 245$b. 15:04 drojf1 $j - Language code of subtitles or captions (R) 15:04 * jcamins thinks this might be a language issue. 15:04 jcamins Ah. 15:05 drojf1 subtitles in a dvd 15:05 drojf1 *on 15:05 jcamins Ohhhh. 15:05 drojf1 we have a lot of video 15:05 jcamins Right. 15:05 * jcamins was thinking "This is a title : with a subtitle" 15:05 jcamins Very confusing. ;) 15:05 drojf1 yes i see now :) 15:06 jcamins You are correct, there is no way to specify optional or mandatory. 15:06 * oleonard finds that the .bashrc change suggested in the wiki's tips and tricks slows down display of the prompt considerably 15:07 jcamins Which page? 15:08 jcamins Ah. 15:08 jcamins Yeah, I'm not surprised that slows things down. 15:09 kf oleonard: there are lots of similar things on the web - I use something else that it much more code but haven't noticed slow downs. hm. 15:09 oleonard "10:04 ~/kohaclone (master $% u-15)$" what is the "$% u-15" ? 15:10 kf looks like something is broken there 15:10 jcamins kf: what do you use? 15:10 kf http://www.bramschoenmakers.nl/en/node/624 15:10 kf I have the link at home 15:11 kf but that link is for another solution 15:11 kf mine also shows with a symbol if there are uncommitted changes 15:11 kf using different colors... lots more complicated 15:12 kf http://asemanfar.com/Current-Git-Branch-in-Bash-Prompt 15:14 * oleonard boggles at the number of alternate versions in the comments on that page 15:15 kf really, google gives lots of different options 15:15 kf only not finding the one I used 15:15 * jcamins can wait until you're home. 15:15 * jcamins isn't at his computer anyway. ;) 15:16 kf wb drojf 15:16 drojf oops, i was gone? 15:17 drojf ah, forced disconnect. thanks, german isp 15:18 kf weird time 15:18 * wizzyrea waves 15:18 kf hi wizzyrea :) 15:18 * jcamins waves back. 15:19 * magnus_afk waves too 15:19 * oleonard waves his hands in the air like he just doesn't care 15:19 kf lol 15:23 wizzyrea oy, is there anytihng in "claims returned" that puts an item in transit home? 15:24 wizzyrea my understanding was that these functions are utterly unrelated. 15:24 kf hm Ithink they should be? 15:25 wizzyrea !! 15:25 wizzyrea why?! 15:26 kf oh wrong answer? 15:26 kf I meant being unrealted 15:26 wizzyrea OH 15:26 kf unrelated 15:26 wizzyrea sorry I misunderstood what you meant 15:26 wizzyrea :) 15:27 kf it's friday 15:27 * kf offers cookies 15:27 wizzyrea hee thanks 15:27 wizzyrea I have a library claiming that another library "put an item in transit by marking it claims returned" 15:27 wizzyrea to which I say, bullsh*t! 15:28 oleonard Is "claims returned" a lost status you've set up? 15:28 wizzyrea yea 15:28 wizzyrea but marking things *lost* doesn't transit them home. 15:28 wizzyrea *people* transit things home. 15:29 wizzyrea ugh. yay for involved recreating what cannot be recreating. HEre I go down the rabbit hole. 15:31 kf ok, right or wrong: deleting entries from accountlines that are older than x days/months will throw off the calculated balance? 15:31 gaetan_B wizzyrea: about bug 6985 15:31 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6985 enhancement, P5 - low, ---, wizzyrea, Failed QA , Hide "kw,wrdl:" from Search Results 15:32 gaetan_B do you mean chan ging the display of search history list is also a part of this or is out of the scope ? (i was in the process of creating another ticket for this purpose) 15:34 wizzyrea changing the display of the search history is out of the scope of this I think 15:34 wizzyrea but a worthy goal 15:35 wizzyrea I meant that the "no result" text should also eliminate kw, wrdl 15:35 wizzyrea I thought I filed a bug for that... but maybe I didn't maybe I just thought very hard about it 15:37 Guest1440 LIES 15:38 paul_p hi wizzyrea 15:38 wizzyrea hey 15:38 paul_p wizzyrea I got no email from koha-community.org 15:38 wizzyrea oki 15:39 wizzyrea one mo 15:39 paul_p wizzyrea + you tried to test a sandbox on test5 yesterday, right ? I made a small mistake, it should not have worked well. Not it does. 15:39 wizzyrea ohh, wel 15:39 wizzyrea actually, for the patch I tested with it, it seemed to work ok 15:39 wizzyrea :) 15:40 wizzyrea but yes, i did create a test sandbox 15:40 wizzyrea which I do like very much how it works 15:47 huginn` New commit(s) kohagit: Bug 6314 XSL UNIMARC Improvments <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=fd84f8c2bcdc01fc753c6b281f13e387586199cc> / Bug 5674: patron name sort ignoring case when placing holds. <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e1d948ecd69b802917272b2bc73e11fabc2a0e88> 15:55 jenkins_koha Project Koha_master build #614: STILL UNSTABLE in 53 mn: http://jenkins.koha-community.org/job/Koha_master/614/ 15:55 jenkins_koha * gcollum: Bug 6984 - Holds statistics doesn't work. 15:55 jenkins_koha * m.de.rooy: Bug 7459 - Can only add to one public list in OPAC search results 15:55 jenkins_koha * mjr: Bug 7476 Remove executable bit from files that probably should not be executed 15:55 jenkins_koha * f.demians: Bug 7472 Edit button ineffective when paying borrower fee 15:55 jenkins_koha * oleonard: Bug 7461 - Cart offering to remove items when closing 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6984 critical, P5 - low, ---, gcollum, Pushed to Master , Holds Statistics Doesn't Work 15:55 jenkins_koha * wizzyrea: Bug 7238 Followup - fix sip_run to require path to SIPconfig.xml 15:55 jenkins_koha * Chris Cormack: Bug 7238 : Shifting SIPconfig.xml to the etc dir and the scripts to misc/bin 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7459 major, P2, ---, m.de.rooy, Pushed to Master , Can only add to one public list in OPAC search results 15:55 jenkins_koha * lrea: Bug 6323 -- Error handling cleanup for moveitem.tt 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7476 normal, P3, ---, aleksa, Pushed to Master , Files executable that probably should not be 15:55 jenkins_koha Starting build #615 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #612 19 h ago) 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7472 normal, P5 - low, ---, frederic, Pushed to Master , Edit button ineffective when paying borrower fee 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7461 minor, P5 - low, ---, oleonard, Pushed to Master , cart offering to remove items when closing 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7238 enhancement, P5 - low, ---, chris, Pushed to Master , move SIPconfig.xml, sip_run and sip_shutdown outside from C4 (NOT FOR 3.6) 15:55 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6323 enhancement, P3, ---, wizzyrea, Pushed to Master , Attach/move items - adding option "try again" after success or wrong barcode 16:11 drojf is it really that quiet or am i just offline? 16:11 wizzyrea it's that quiet. 16:11 wizzyrea :) 16:11 drojf ooh 16:11 drojf ok, thanks ;) 16:11 kf it's friday :) 16:11 * drojf tries to wake nobody 16:12 paul_p drojf kiwis are sleeping, be carefull, you're right 16:12 paul_p the problem here is that there is always someone sleeping ;-) 16:12 drojf :) 16:12 kf paul_p: on the positive side... always someone awake too:) 16:13 drojf i'm really tired, i could go to bed too. but its only 5pm so maybe not. 16:13 kf students... 16:14 kf ;) 16:14 drojf lol 16:16 drojf i play "find the patterns" to get languages of audio and subtitles out of our old db for the video entries. maybe some more inspiring work would make me less tired 16:17 kf ok 16:17 kf I could find some more inspiring projects for you... 16:17 drojf but they will probably not help with our import 16:18 drojf @wunder berlin, germany 16:18 huginn` drojf: The current temperature in Prenzlauer Berg, Berlin, Germany is -4.9�C (5:13 PM CET on February 03, 2012). Conditions: Light Snow. Humidity: 59%. Dew Point: -12.0�C. Windchill: -10.0�C. Pressure: 30.63 in 1037.1 hPa (Rising). 16:19 drojf still getting warmer. maybe i try shopping and some fresh air 16:21 kf :) 16:22 reiveune bye 16:23 kf @wunder Konstanz 16:23 huginn` kf: The current temperature in Konstanz, Germany is -9.0�C (5:00 PM CET on February 03, 2012). Conditions: Scattered Clouds. Humidity: 38%. Dew Point: -17.0�C. Pressure: 30.51 in 1033 hPa (Rising). 16:31 jcamins Looks like it's the end of the work day in France. 16:37 slef jcamins: and it looks like it's just work not passion for some ;-) 16:37 jcamins slef: heh. 16:42 jcamins slef: BTW, did I tell you we were approved for the co-op? It was a while ago, but I feel like you might not have been around. 16:43 wizzyrea hey libsysguy 16:43 wahanui libsysguy is, like, Koha's hottest developer or partying with swedes on his deck 16:43 libsysguy hey wizzyrea 16:43 wahanui I LIKE SCIENCE! 16:43 libsysguy hehe 16:43 wizzyrea <3 wahanui 16:43 libsysguy I have a question that will make all here cringe 16:43 jcamins libsysguy: oh no. 16:43 wizzyrea "when will hourly be tested and ready?" 16:43 libsysguy I want to try and import and link all authorities on a dev box 16:43 wizzyrea that won't make us cringe. 16:43 jcamins Bwahahahahahahaha!!!!!!! 16:43 wizzyrea :D 16:43 jcamins libsysguy: yes! 16:44 jcamins libsysguy: this is wonderful! 16:44 wizzyrea you will make jcamins cheer 16:44 jcamins I have good news! 16:44 libsysguy oh? 16:44 * jcamins does a happy dance. 16:44 jcamins Bug 7284. 16:44 wahanui somebody said bug 7284 was the first step to making that happen. 16:44 wizzyrea see? 16:44 libsysguy you single handly pushed hourly 16:44 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7284 major, P3, ---, jcamins, Needs Signoff , Authority matching algorithm improvements 16:44 jcamins That's what you need. 16:44 oleonard all for the price of a sign-off 16:44 jcamins And, look! There it is- bug 7284, just waiting for your sign-off. 16:44 jcamins Can't you hear it? "Sign off on me! Sign off on me!" 16:44 libsysguy haha jcamins 16:45 wizzyrea I hear a sign off on that comes with "favors" 16:45 wizzyrea lol 16:45 libsysguy oh boy...last time i signed off on something it got shot full of holes 16:45 libsysguy poor hourly 16:45 wizzyrea psh 16:45 wizzyrea that's a ginormous on 16:45 wizzyrea one 16:45 jcamins wizzyrea: guess I'd best figure out the stove, then, so I can bake fudge. 16:45 * wizzyrea waits for the shooting to begin re: 7001 16:45 libsysguy signoffs for favors ;) 16:46 * jcamins is not above bribes. 16:46 * oleonard can vouch for that 16:46 * wizzyrea too 16:46 libsysguy guess I just have to get on the jcamins train 16:46 wizzyrea toot toot! 16:46 kf only me... I never got any fudge 16:46 kf *sniffs* 16:46 jcamins kf: sorry! :( 16:46 kf ;) 16:47 kf I heard a lot of people talking about the fudge tho 16:47 jcamins libsysguy: in all seriousness, though, bug 7284 should do exactly what you need. 16:47 wizzyrea really, he's not lying 16:47 jcamins libsysguy: chances are you want the LastMatch module. 16:47 wizzyrea and that's the PERFECT opportunity to test 16:48 wizzyrea dev server, good authorities, good records 16:48 libsysguy ^^ BAHAHAHA 16:48 libsysguy wizzyrea has apparently never seen our records 16:48 jcamins I recommend using link_bibs_to_authorities.pl --link-report --commit=1000 16:48 wizzyrea where good = an appropriate challenge for the script 16:49 wizzyrea is not the same as a "good record" 16:49 wizzyrea ;) 16:49 jenkins_koha Project Koha_master build #615: STILL UNSTABLE in 54 mn: http://jenkins.koha-community.org/job/Koha_master/615/ 16:49 jenkins_koha * gcollum: Bug 5674: patron name sort ignoring case when placing holds. 16:49 libsysguy ok so the patch failed...is it git am -iu3 <patch_location> to try and fix 16:49 jenkins_koha * f.demians: Bug 6314 XSL UNIMARC Improvments 16:49 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5674 minor, P5 - low, ---, gcollum, Pushed to Master , Staff client - placing holds - patron name sort not ignoring letter case 16:49 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6314 enhancement, P1 - high, ---, frederic, Pushed to Master , UNIMARC OPAC XSL improvements 16:49 wizzyrea yeap 16:49 wizzyrea well I don't use the u 16:49 wizzyrea what's the u again? 16:50 jcamins unified. 16:50 * jcamins always uses it. 16:50 wizzyrea hm 16:50 libsysguy cpoy pasta from a rangi recommendation 16:50 francharb_lunch see ya 16:51 jcamins Sure doesn't take long for the code to not apply to master. 16:51 wizzyrea *nod* 16:51 wizzyrea I have had to do several lately where some minor merge things needed to be done before I could test 16:52 wizzyrea (updatedatabase, sysprefs, silly lil stuff) 16:52 jcamins Probably sysprefs. 16:52 * jcamins uses atomicupdate because updatedatabase conflicts irritate him. 16:52 wizzyrea most likely 16:53 libsysguy yeah thats what it was 16:53 libsysguy whitespace 16:53 libsysguy and a syspref file 16:53 wahanui a syspref file is only one that ever changes 16:53 wizzyrea ez to fix :) 16:53 libsysguy exactly 16:53 wizzyrea hi melia 16:53 melia good morning 16:54 jcamins libsysguy: since you applied that by hand, you'll probably need to run: perl installer/data/mysql/atomicupdate/bug_7284_authority_linking_pt1 16:55 libsysguy gracias sir 16:55 libsysguy in sysprefs.sql 16:55 libsysguy do I need to run that as well? 16:55 jcamins You need to run the atomicupdate because you applied the patch by hand, not as part of a regular update. 16:55 jcamins You don't need to do anything other than fix the conflict in sysprefs.sql. 16:56 libsysguy understood 16:56 libsysguy sysprefs.sql is new for me lol 16:56 libsysguy i think it is anyway 16:58 jcamins link_bibs_to_authorities.pl will take a while to run. 16:58 jcamins Oh, be sure to pipe the output into a file. 16:58 jcamins Running it on an average (large) public library's database produces a 10MB report. 16:59 slef jcamins: nope, that's news to me. 16:59 slef jcamins: still seems like the whole NY co-op housing needs some questions asked about its values and principles though ;) 16:59 jcamins slef: yeah, we were approved a while ago, actually. 16:59 jcamins Agreed. 17:01 slef ask them what they're doing to celebrate 2012.coop? ;-) 17:01 jcamins slef: nothing, I'm pretty sure. 17:03 gaetan_B wizzyrea: just catching up with your answer! I didn't find anything about this and went ahead and created the bug. It's linked to the search reasults one. 17:03 wizzyrea cool, thanks :) 17:04 gaetan_B bye everyone, have a nice week end! 17:07 libsysguy this may be a dumb question but do you import authorities just like a regular import? 17:07 jcamins libsysguy: use bulkmarcimport.pl -a 17:07 libsysguy ahh 17:08 jcamins This reminds me. I need to add an authority import interface to my list of proposed enhancements. 17:08 kf :) 17:08 * wizzyrea whispers teeesssssttttt plaaaaaaan 17:09 jcamins wizzyrea: oh, yes! 17:09 libsysguy hehe 17:09 wizzyrea for us dummies who don't do authorities every day. ;) 17:09 jcamins Sorry, I haven't actually turned my computer on at home since... 17:09 jcamins Sunday. 17:09 jcamins Morning. 17:09 libsysguy 0_0 how do you live man 17:09 jcamins libsysguy: it's glorious. 17:10 jcamins Well, I turned my computer on briefly last night. I sent a bunch of invoices, then turned it off. 17:10 oleonard Cheater. 17:10 jcamins oleonard: I forgot about that. 17:12 jcamins Wow. 17:12 wizzyrea ? 17:12 jcamins wizzyrea: the message that just came through the list. 17:13 libsysguy seen druthb 17:13 wahanui druthb was last seen on #koha 15 hours, 26 seconds ago, saying: does a happy dance, too! [Fri Feb 3 02:11:43 2012] 17:13 wizzyrea the video one? 17:13 jcamins Yup. 17:13 wizzyrea ah 17:13 jcamins Is it not worthy of a "wow"? 17:13 kf wow ? 17:13 wizzyrea there's a lot of wow in the list today. 17:16 rangi make me a video 17:17 wizzyrea sudo make me a video 17:17 rangi why you not make me one 17:17 oleonard I'm thinking the solution to Bug 7493 is a foreign key constraint on biblionumber and borrowernumber? 17:17 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7493 normal, P5 - low, ---, oleonard, NEW , Deleting a record with comments breaks "Recent Comments" 17:18 kf so you will delete the comments with the borrower? 17:18 kf I was thinking about that today 17:19 hdl one could also NULLIFY the borrowernumber 17:19 hdl See ya 17:19 wizzyrea ^^ this is what I was thinking 17:20 wizzyrea and have the display be "Unknown commenter" or "anonymous commenter" 17:20 wizzyrea depends on if you want to preserve the comment or not 17:20 * jcamins thinks his prices might be prohibitive for that task. 17:20 wizzyrea or just "library patron" 17:20 wizzyrea "library patron says blah blah blah" 17:20 wizzyrea s/says/said/ 17:21 oleonard "A dearly departed library patron" 17:21 wizzyrea I approve of the fact that we actually have to solve this problem - means people are using comments! 17:21 oleonard Someone somewhere... 17:23 wizzyrea lol: http://evilrouters.net/achievement-unlocked/ 17:25 jcamins lol 17:25 jcamins Lunch time. 17:25 wizzyrea finally an achievement system that I don't have to work too hard to get all of them. 17:36 kf @wunder Konstanz 17:36 huginn` kf: The current temperature in Taegerwilen, Taegerwilen, Germany is -10.4�C (6:34 PM CET on February 03, 2012). Conditions: Partly Cloudy. Humidity: 60%. Dew Point: -17.0�C. Windchill: -14.0�C. Pressure: 30.53 in 1033.7 hPa (Steady). 17:36 kf eew 17:36 wizzyrea brr 17:36 wizzyrea @wunder lawrence ks 17:36 huginn` wizzyrea: The current temperature in Channel 6 Downtown, Lawrence, Kansas is 7.6�C (11:35 AM CST on February 03, 2012). Conditions: Overcast. Humidity: 89%. Dew Point: 6.0�C. Windchill: 6.0�C. Pressure: 30.07 in 1018.2 hPa (Steady). 17:36 libsysguy all authorities imported 17:36 slef mmmm nice 17:36 libsysguy TO THE LINKER!! 17:36 kf lol 17:36 slef I'm not going to Germany soon but I know someone who is. 17:36 kf it's cold 17:36 slef @wunder EGYH 17:36 huginn` slef: Error: No such location could be found. 17:36 kf and I have to walk home 17:36 slef @wunder EGFC 17:36 kf meh. 17:36 huginn` slef: Error: No such location could be found. 17:37 slef huginn`: you suck! 17:37 huginn` slef: downloading the Perl source 17:39 kf bye all :) 17:45 oleonard so if I want the constraint the set reviews.borrowernumber null on patron delete, I add the constraint to borrowers? 18:08 cait hi #koha 18:09 wizzyrea heya 18:10 slef @wunder dersingham 18:10 huginn` slef: The current temperature in APRSWXNET Dersingham UK, Sculthorpe, United Kingdom is -0.6�C (5:33 PM GMT on February 03, 2012). Conditions: Mist. Humidity: 80%. Dew Point: -3.0�C. Windchill: -1.0�C. Pressure: 30.68 in 1038.8 hPa. 18:10 chris_n let's see how this goes: upgrading from Koha 3.03.00.002 to 3.07.00.011 18:10 jcamins chris_n: yikes! 18:11 jcamins chris_n: I hope you're not doing that on production first? 18:11 * chris_n hides under his desk 18:11 chris_n muahahaha 18:11 * chris_n watches the patrons and librarians run for cover :-) 18:11 cait is there a reason you need 3.7? 18:11 chris_n actually, this is my dev sandbox 18:12 chris_n ok, done... 18:12 jcamins Your dev sandbox is on 3.03.00.002? 18:12 pastebot "chris_n" at 63.162.197.228 pasted "upgrading from Koha 3.03.00.002 to 3.07.00.011" (87 lines) at http://paste.koha-community.org/241 18:13 chris_n for all you curious folks 18:13 chris_n it went beautifully 18:13 chris_n jcamins: no 18:13 wizzyrea remove items from biblioitems too?nice! 18:13 chris_n but I'm preparing to develop over a copy of my production db 18:13 chris_n using master 18:13 chris_n wizzyrea: well, I need to run the script 18:14 chris_n but the db upgrade looks smooth at first glance 18:14 wizzyrea I did an update from 3.0 to 3.4 not too long ago (before 3.6 was out) 18:14 chris_n this also gives me good practice for my planned summer upgrade of the production system 18:15 wizzyrea :) 18:28 cait :) 18:31 chris_n running remove_items_from_biblioitems.pl 18:32 chris_n hmm... an old error returns 18:32 chris_n DBD::mysql::st execute failed: Data too long for column 'isbn' 18:33 chris_n seems I recall that the isbn filed is comma delimited or some such and grows too long for some buggy reason 18:33 chris_n s/filed/field/ 18:33 jcamins Comma-delimited. 18:33 jcamins That's... 18:33 * jcamins tries not to think about it. 18:34 chris_n yeah, I think the issue was fixed somewhere along the upgrade path 18:35 chris_n don't know though 18:40 jcamins chris_n: your production system is running 3.03.000.002? 18:41 chris_n yes; heavily localized 18:41 jcamins Yikes. 18:41 chris_n lots of css, etc changes to the old templating system 18:42 jcamins That's not going to be fun. 18:43 chris_n I cringe at the prospect of bringing it up-to-date 18:43 chris_n initially I was very diligent to keep it merged with master 18:43 chris_n but.... 18:43 chris_n and you know the rest of the story :-) 18:52 rangi slef: you about? 18:55 rangi are welsh technically british? 18:56 slef rangi: yeah but many like the term as little as I do ;) 18:56 rangi yup, figured that :) 18:57 slef http://jenkins.koha-community.org/job/Koha_master/614/console looks to be caused by bug 5327 18:57 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5327 enhancement, P3, ---, sam-sanders, Failed QA , Unit tests required for all C4 modules 18:57 slef err, failed QA, so why's it in master? 18:58 slef didn't spot that before 18:58 cait more than one patch 18:58 slef yeah I see that now 18:59 slef ok but it's commit 597fabf4f474c52d0c9fc3f9fa9ce0267f6e04e2 which I think has done this 18:59 slef door 19:00 rangi slef: the 3 left attached are the failed ones i think 19:00 rangi and yes that is the cause of the problem 19:00 rangi you can't renew without a patron 19:01 rangi im not sure how that ever passed 19:01 rangi a patch fixing that would be awesome, or even just commenting out that test until its fixed 19:03 * chris_n boggles.... 19:03 chris_n more QA issues? 19:03 rangi well, sign off too, i can only assume it works on perhaps an empty db? 19:03 rangi or perhaps one filled with only sample data? 19:03 chris_n 5200 records and counting 19:04 chris_n this is sooo slooow 19:04 rangi im assuming the test was at least run once :) 19:04 chris_n you are gracious ;-) 19:05 rangi so 19:05 rangi bug 7432 19:05 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7432 critical, P1 - high, ---, paul.poulain, Needs Signoff , Changing frameworks should refresh cache 19:05 rangi turns out we were using memoize_memcached all wrong 19:05 rangi but now we know how to do it right 19:05 chris_n doing_it_right++ 19:06 rangi we can use it more, and it will speed up a lot of things like that remove_items script 19:06 cait rangi++ 19:06 rangi (assuming ppl are running memcached) 19:07 rangi cait++ # for reporting the bug which made me find the issue 19:07 rangi i had to read the source code of the module to figure out what were doing wrong which kinda sucked 19:07 rangi but hey I *could* 19:07 jcamins remove_items? 19:07 rangi free_software++ 19:07 cait :) 19:08 rangi jcamins: anything that has to do repetitive look ups 19:08 jcamins Oh, remove_items_from_biblioitems? 19:08 rangi thats it :) 19:08 * jcamins wasn't sure what the remove_items script was. 19:18 cait @wunder Konstanz 19:18 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -11.0�C (8:14 PM CET on February 03, 2012). Conditions: Clear. Humidity: 64%. Dew Point: -16.0�C. Windchill: -11.0�C. Pressure: 30.54 in 1034.1 hPa (Steady). 19:18 slef rangi: I don't know the syntax of that function and it appears to be undocumented 19:18 slef @wunder Dersingham 19:18 huginn` slef: The current temperature in APRSWXNET Dersingham UK, Sculthorpe, United Kingdom is -2.2�C (6:48 PM GMT on February 03, 2012). Conditions: Partly Cloudy. Humidity: 83%. Dew Point: -4.0�C. Windchill: -2.0�C. Pressure: 30.68 in 1038.8 hPa. 19:18 slef cait: racing towards you! 19:18 rangi comment it out for now then with a fixme would be my inclination 19:18 cait slef: you call that racing? ;) 19:19 slef cait: well, freezing 19:19 rangi @wunder nzwn 19:19 huginn` rangi: The current temperature in Wellington, New Zealand is 15.0�C (8:00 AM NZDT on February 04, 2012). Conditions: Drizzle. Humidity: 88%. Dew Point: 13.0�C. Pressure: 30.04 in 1017 hPa (Steady). 19:19 slef @wunder Weston-super-Mare SOMERSET 19:19 huginn` slef: The current temperature in Weston-Super-Mare, United Kingdom is -3.2�C (7:15 PM GMT on February 03, 2012). Conditions: Clear. Humidity: 60%. Dew Point: -10.0�C. Windchill: -3.0�C. Pressure: 30.69 in 1039.2 hPa (Rising). 19:19 rangi day 2 of the sevens today 19:19 slef is where I am today 19:19 wahanui somebody said today was Black Friday. 19:19 slef wahanui: they are wrong 19:19 wahanui ...but they is non-xslt, but I will check that.... 19:19 wahanui ...but they are non-xslt, but I will check that.... 19:20 slef madness 19:20 cait lol 19:20 slef madness? 19:20 wahanui somebody said madness was manyfold - ask me for the second sign of madness. 19:20 jcamins second sign of madness? 19:20 wahanui it has been said that second sign of madness is hairs on the palms of my hands 19:21 cait the first sign of madness? 19:21 wahanui somebody said the first sign of madness was looking for hairs on the palms of my hands 19:21 rangi heh 19:22 slef life is a bot cabaret, my friend... 19:23 slef cait: is that the coldest it gets there? 19:25 jcamins slef: thanks a lot. Now I have that song stuck in my head. 19:25 slef jcamins: with bot in it? 19:25 cait slef: hm not sure 19:25 jcamins slef: no, not with bot in it. 19:27 rangi speaking of madness 19:27 rangi http://www.stuff.co.nz/sport/photos/6360370 19:27 jcamins Those costumes are quite something. 19:28 rangi yes, it all goes a bit mad for sevens weekend 19:29 cait sevens weekend? 19:30 jcamins [off] Aaand, I was just thinking that we needed another demand that we do someone's work for them. 19:30 slef rugby sevens 19:31 chris_n 9200 records and counting 19:31 * chris_n looks around for memcached 19:32 rangi heh 19:44 fredpierre I've got a bunch of old fines to get rid of. 19:44 Brooke o/ 19:45 fredpierre In the past we accepted payments, but didn't match them to the items, so those items still show up on the fines report, even though they are paid. 19:45 fredpierre I think I might have found the answer: SELECT * FROM accountlines WHERE amount > 0 AND amountoutstanding = 0; 19:46 jcamins fredpierre: what's the problem you're trying to solve? 19:49 fredpierre If a patron's balance is zero, I want to clear all the old items from the fines report, so they don't clutter up the billing. 19:49 jcamins Ah. 19:49 fredpierre The problem is that the manual credits aren't applied to the items in the past. 19:49 jcamins Then, yes, that will select all the fines that have been paid. 19:49 fredpierre Thanks 19:57 cait @wunder Konstanz 19:57 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -10.9�C (8:55 PM CET on February 03, 2012). Conditions: Clear. Humidity: 64%. Dew Point: -16.0�C. Windchill: -15.0�C. Pressure: 30.55 in 1034.4 hPa (Steady). 20:02 slef I wanted to leave 111 minutes ago :-/ 20:02 fredpierre !!! 20:05 fredpierre Thanks jcamins - my thought is that this will only eliminate lines that were in balance. it's going to be harder to clear all lines prior to the account being in balance...I will work on it and report back! 20:05 jcamins Good luck! 20:18 slef test data? 20:18 chris_n cool 20:19 slef db_dependent? 20:19 slef description of the db_dependent test data? 20:19 slef wahanui: you suck. 20:19 wahanui slef: i'm not following you... 20:19 chris_n upgrade went very smoothly, items removed, and zebra reindexed nicely 20:19 chris_n searches work fine 20:20 * chris_n notes that there are a couple of dud records, but they were duds from the start 20:23 Brooke sure about that, stud? 20:23 Brooke I can bust up your searches. >:) 20:23 slef the description of the db_dependent test data is in t/db_dependent/lib/KohaTest.pm 20:26 slef 952? 20:26 slef @marc 952 20:26 huginn` slef: unknown tag 952 20:26 wahanui The 952 field is used by Koha to store item data in MARC21 and is described at http://wiki.koha-community.org/wiki/Holdings_data_fields_%289xx%29 20:27 slef so the test data has no known barcode? 20:27 slef am I reading it right? 20:28 rangi i dont think that data is used anymore by the tests 20:28 rangi the tests rely on the data that is installed when you choose yes to everything in the sample db 20:28 slef bah cruft 20:29 rangi that KohaTest.pm is something someone started, and never finished, so yeah nicest thing would be to remove it 20:29 slef so where is the sample db documented? 20:29 rangi in the .sql and corresponding .txt files 20:29 rangi in installer/data/ 20:30 * oleonard loves taking calls from libraries interested in Koha 20:30 slef installer/data/mysql/en/optional/sample_* 20:30 slef ? 20:30 rangi all the optional files 20:30 slef wahanui: forget the description of the db_dependent test data 20:30 wahanui slef: I forgot description of the db_dependent test data 20:30 rangi plus all the mandatory ones 20:30 slef the description of the db_dependent test data is in installer/data/mysql/en/ 20:31 rangi ta slef 20:31 slef I think I'm still wrong 20:32 slef I'm not seeing anything that looks like sample items there 20:33 pastebot "oleonard" at 66.213.78.34 pasted "Setting up foreign key constraints for reviews table" (7 lines) at http://paste.koha-community.org/242 20:33 oleonard Trying, but not succeeding. 20:34 oleonard The link to borrowers works, the one to biblio doesn't. 20:35 slef the mysqldumps have ON DELETE CASCADE ON UPDATE CASCADE but I doubt ordering matters 20:35 slef what error do you get running it from the mysql> prompt? 20:36 oleonard If I run each at the mysql prompt I get no error. I get an error when running updatedatabase 20:38 slef what error? 20:38 pastebot "oleonard" at 66.213.78.34 pasted "updatedatabase error" (1 line) at http://paste.koha-community.org/243 20:38 slef ta 20:41 slef "Cannot add or update a child row: a foreign key constraint fails" is a strange one 20:41 slef same database for both prompt and updatedatabase? 20:41 oleonard Yes 20:41 * oleonard will try again to make sure 20:43 oleonard Oh never mind, now it fails on the command line too :P 20:45 slef my thought was that you have a review of something no longer in biblio 20:46 slef select reviewid from reviews where biblionumber not in (select biblionumber from biblio); but that is an ugly query 20:46 oleonard Ah, that could be, since that's the bug I'm working on 20:47 slef ah cool 20:47 slef that's why I was confused by it working at the prompt 20:47 oleonard I must have tested it at the prompt when my database was in a different state 20:48 oleonard So any database update to add the constraint will have to look for that conflict as well 20:48 slef I think so. Do you want to junk reviews though? 20:48 slef Your problem ;) I'm off to dinner. Happy hacking. 20:48 oleonard What can you do with a review of a book which doesn't exist anymore? 20:49 * oleonard is open to suggestions, but is leaving now too 20:49 slef attach it to a new edition of the right book manually 20:49 oleonard Bye #koha 20:49 slef Oh and if anyone can tell me where the db_dependent sample item data is, that would be cool. 20:49 jcamins Bye. 20:50 nengard looking for my report gurus to provide a bit of help here ? "I need a report that lists titles that have ONLY 1 item and the status of that item is Withdrawn." 20:57 jcamins Good night, #koha. 21:00 rangi not sure it has any slef 21:00 rangi but it has itemtypes and all the things needed to create one 21:00 rangi the tests for biblio create a biblio, then remove it again at the end 21:19 maximep having a weird problem bug 6634 21:19 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6634 critical, P1 - high, ---, koha.sekjal, ASSIGNED , manager_id not populated when paying fines 21:19 maximep the patch seems to have been pushed in 3.6... in part 21:19 maximep $manager_id is created.... but never used 21:19 maximep :S 21:20 maximep maybe it was reverted... hmmmm 21:22 cait maximep: I think it was used when paying, but not when writing off 21:22 cait or the other way round 21:22 cait I remember testing it, or perhaps it broke again 21:23 maximep writeoff is in 6718 21:23 maximep writeoff is in bug 6718 21:23 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6718 major, P5 - low, ---, kyle.m.hall, NEW , No manager_id saved for writeoff of fines 21:24 maximep it broke again :/ 21:24 maximep will post in bugs 21:26 maximep aaaah 21:26 maximep http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5b945d8c415aa610e4ded830825f43bd8592d109 21:27 maximep oh, it's from someone at libeo haha 21:27 maximep but it was a very old patch 22:22 * drojf puts some cold beers in #koha. weekend :) 22:31 druthb o/ 22:32 drojf hi druthb take a beer before it gets warm. or the tumbleweed takes it all ;) 22:33 * druthb says "no thanks" to the beer, and pours herself a double shot of something stronger. 22:34 drojf cheers 22:35 * druthb raises her glass. 22:36 drojf *clink* 22:47 drojf wahanui: botsnack beer 22:47 wahanui thanks drojf :)