IRC log for #koha, 2012-02-03

All times shown according to UTC.

Time S Nick Message
00:10 wizzyrea1 joined #koha
00:10 wizzyrea is now known as Guest1386
00:10 wizzyrea1 is now known as wizzyrea
00:36 wizzyrea left #koha
00:45 bencahill okay, I've run Devel::NYTProf on, 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:51 libsysguy joined #koha
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 this about the fastest I can expect?
00:52 bencahill jcamins_away: np ;)
00:52 jcamins_away bencahill: but, see[…]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,'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 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 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[…]L_Reports_Library
01:19 Space_Librarian I love wahanui sometimes.
01:22 mtj 'Holds to Pull at Branch'
01:22 pastebot "mtj" at pasted "sql" (9 lines) at
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:30 melia left #koha
01:35 Space_Librarian Absolutely brilliant. Thanks mtj!
01:37 ibeardslee oh hai Space_Librarian how is the new job going?
01:49 NateC left #koha
01:55 wizzyrea joined #koha
02:06 Culiforge joined #koha
02:08 druthb joined #koha
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:27 Culiforge is now known as cul_away
02:48 ago43_away left #koha
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:09 mibbit joined #koha
03:10 mibbit is now known as Guest1394
03:12 Guest1394 left #koha
03:15 wizzyrea left #koha
03:18 mib_diqous joined #koha
03:19 wizzyrea joined #koha
03:21 mib_gs444k joined #koha
03:21 mib_diqous left #koha
03:23 mib_gs444k left #koha
03:26 Amit_Gupta joined #koha
03:26 Amit_Gupta heya bag
03:32 wizzyrea left #koha
03:39 mib_3pi6xh joined #koha
03:42 aleksa left #koha
03:43 kathryn left #koha
03:45 mib_3pi6xh left #koha
03:49 Amit_Gupta left #koha
03:50 Amit_Gupta joined #koha
03:56 wizzyrea joined #koha
03:57 Space_Librarian right #koha - seeya next week!
03:57 Space_Librarian left #koha
04:05 mib_yrhs32 joined #koha
04:18 mib_yrhs32 hi
04:18 mib_yrhs32 left #koha
04:43 stuartyeates joined #koha
04:45 libsysguy left #koha
04:45 druthb left #koha
05:05 bencahill g'night, #koha :)
05:06 bencahill left #koha
05:16 cait joined #koha
05:16 cait hi #koha
05:30 wizzyrea left #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:30 Amit_Gupta_ joined #koha
06:36 Amit_Gupta left #koha
06:36 Amit_Gupta_ is now known as Amit_Gupta
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 magnus_away is now known as magnuse
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 mbalmer joined #koha
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 reiveune joined #koha
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 hdl joined #koha
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` Bug[…]w_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` Bug[…]w_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:44 cait left #koha
07:50 hdl left #koha
07:50 julian_m joined #koha
07:50 paul_p joined #koha
07:50 magnuse bonjour julian_m paul_p
07:52 julian_m hello magnuse
07:52 paul_p hi magnuse
07:52 Guillaume joined #koha
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:02 hdl joined #koha
08:02 sophie_m joined #koha
08:05 sophie_m hi #koha
08:06 rangi hi hdl and sophie_m
08:06 hdl hi rangi
08:09 Guillaume left #koha
08:09 Guillaume joined #koha
08:10 kf joined #koha
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 asaurat joined #koha
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 joined #koha
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` Bug[…]w_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` Bug[…]w_bug.cgi?id=7488 minor, P5 - low, ---, adrien.saurat, Needs Signoff , Errors with logs about /
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` Bug[…]w_bug.cgi?id=7457 normal, P5 - low, ---, adrien.saurat, Needs Signoff , makes a lot of noise in the logs
08:35 mib_tl2cwx joined #koha
08:36 mib_ftvpyi joined #koha
08:36 mib_tl2cwx left #koha
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
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:51 francharb joined #koha
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` Bug[…]w_bug.cgi?id=7489 normal, P5 - low, ---, magnus, Needs Signoff , Implement DisplayOPACiconsXSLT for NORMARC XSLT
09:05 kf drojf1:  :)
09:07 christophe_c joined #koha
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 to add rebuild_zebra_sliced.zsh <[…]w_bug.cgi?id=7286>
09:35 sophie_m taking[…]w_bug.cgi?id=6199
09:35 huginn` Bug 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?[…]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
09:45 kf bug 7432
09:45 huginn` Bug[…]w_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 ?
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 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:50 Amit_Gupta left #koha
09:52 kf magnuse: that one is really old - zeno did the schema things
09:52 Amit_Gupta joined #koha
09:58 mib_ftvpyi left #koha
10:01 drojf1 so when are we doing all those video tutorials that are requested lately? ;)
10:01 kf lol
10:01 kf is now known as kf_mtg
10:01 kf_mtg will be back later - happy bug squashing :)
10:01 asaurat testing bug 6968
10:01 huginn` Bug[…]w_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:22 cul_away left #koha
10:25 NateC joined #koha
10:43 paul_p QAing 7387
10:43 magnuse bug 7387
10:43 huginn` Bug[…]w_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` Bug[…]w_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` Bug[…]w_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 joined #koha
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` Bug[…]w_bug.cgi?id=7450 critical, P5 - low, ---, adrien.saurat, Passed QA , Missing placeholders in admin/
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` Bug[…]w_bug.cgi?id=7422 enhancement, P5 - low, ---, adrien.saurat, Signed Off , Prevent creation of vendors with the same name
11:05 huginn` Bug[…]w_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:19 francharb is now known as francharb_lunch
11:21 * marcelr Only 19 in signed off state left..
11:24 paul_p left #koha
11:25 huginn` New commit(s) kohagit: bug 7450 small follow-up, removing warn <[…]0cf920b17d5e2662e> / Bug 7450: missing placeholders in <[…]fe11402eebfa45a01> / Bug 7431: Fixes the display of the due date in opac item specific holds. <
11:26 NateC left #koha
11:31 jenkins_koha Starting build #613 for job Koha_master (previous build: FIXED)
12:07 magnuse is now known as magnus_afk
12:09 kf_mtg is now known as kf
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` Bug[…]w_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` Bug[…]w_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 jwagner joined #koha
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:23 Amit_Gupta left #koha
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.[…]/Koha_master/613/
12:25 jenkins_koha * 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
12:25 jenkins_koha * paul.poulain: bug 7450 small follow-up, removing warn
12:25 huginn` Bug[…]w_bug.cgi?id=7355 enhancement, P3, ---, frederic, Pushed to Master , Note subfields are not displayed in TEXTAREA if hidden
12:25 huginn` Bug[…]w_bug.cgi?id=7431 major, P5 - low, ---, gcollum, Pushed to Master , OPAC item hold list doesn't show 'checked out'
12:25 huginn` Bug[…]w_bug.cgi?id=7450 critical, P5 - low, ---, adrien.saurat, Pushed to Master , Missing placeholders in admin/
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` Bug[…]w_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:49 NateC joined #koha
12:51 marcelr bye koha
12:51 kf bye marcelr
12:51 slef bye and thanks marcelr
12:51 kf yep marcelr++
12:52 marcelr left #koha
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:53 paul_p joined #koha
12:53 paul_p_ joined #koha
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:01 paul_p_ left #koha
13:01 paul_p left #koha
13:02 paul_p joined #koha
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:09 collum joined #koha
13:17 oleonard joined #koha
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` Bug[…]w_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` Bug[…]w_bug.cgi?id=7459 major, P2, ---,, 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[…]ng/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 JesseM joined #koha
13:34 magnus_afk drojf1:[…]C21_Holding_field.2C_3.0.x.2C_3.2.x_and_3.4.x_default_-_field_952
13:37 drojf1 takk magnus_afk
13:38 Guillaume1 joined #koha
13:38 Guillaume1 left #koha
13:42 chris_n looks like PTFS woke up
13:44 chris_n[…]e-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
13:54 Soupermanito joined #koha
14:12 * oleonard 's pre-commit hook doesn't seem to be working...
14:12 * oleonard wonders why...
14:14 ago43 joined #koha
14:15 * oleonard finds that neither "git diff" commands in the pre-commit file return any changed files
14:16 mbalmer left #koha
14:24 fredpierre joined #koha
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[…]ki/DB_schema_bugs
14:26 kf bug 5339
14:26 huginn` Bug[…]w_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 maximep joined #koha
14:30 paul_p no prob
14:30 paul_p (maybe set "in discussion" directly then !)
14:30 kf done
14:32 nengard joined #koha
14:33 trea joined #koha
14:37 jcamins_away is now known as jcamins
14:37 jcamins Good morning again, #koha.
14:37 oleonard paul_p: I have a question about your pre-commit hook ([…]/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 <[…]c0d67cc619608fcb6> / Bug 7238 : Shifting SIPconfig.xml to the etc dir and the scripts to misc/bin <[…]58ff01483890b42d1> / 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 Guillaume left #koha
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
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[…]ch-in-Bash-Prompt
15:14 Guest1386 is now known as wizzyrea
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 drojf joined #koha
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 magnus_afk is now known as magnuse
15:19 * oleonard waves his hands in the air like he just doesn't care
15:19 kf lol
15:21 drojf1 left #koha
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` Bug[…]w_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 wizzyrea1 joined #koha
15:37 wizzyrea is now known as Guest1440
15:37 wizzyrea1 is now known as wizzyrea
15:37 wizzyrea left #koha
15:37 Guest1440 LIES
15:37 Guest1440 is now known as wizzyrea
15:38 paul_p hi wizzyrea
15:38 wizzyrea hey
15:38 paul_p wizzyrea I got no email from
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 drojf left #koha
15:47 drojf joined #koha
15:47 huginn` New commit(s) kohagit: Bug 6314 XSL UNIMARC Improvments <[…]81f13e387586199cc> / Bug 5674: patron name sort ignoring case when placing holds. <[…]bc73e11fabc2a0e88>
15:52 nengard left #koha
15:55 jenkins_koha Project Koha_master build #614: STILL UNSTABLE in 53 mn: http://jenkins.koha-community.[…]/Koha_master/614/
15:55 jenkins_koha * gcollum: Bug 6984 - Holds statistics doesn't work.
15:55 jenkins_koha * 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` Bug[…]w_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` Bug[…]w_bug.cgi?id=7459 major, P2, ---,, 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
15:55 huginn` Bug[…]w_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` Bug[…]w_bug.cgi?id=7472 normal, P5 - low, ---, frederic, Pushed to Master , Edit button ineffective when paying borrower fee
15:55 huginn` Bug[…]w_bug.cgi?id=7461 minor, P5 - low, ---, oleonard, Pushed to Master , cart offering to remove items when closing
15:55 huginn` Bug[…]w_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` Bug[…]w_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 magnuse is now known as magnus_away
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:22 reiveune left #koha
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:26 JesseM is now known as Guest1445
16:26 JesseM joined #koha
16:29 asaurat left #koha
16:30 christophe_c left #koha
16:31 jcamins Looks like it's the end of the work day in France.
16:31 Guest1445 left #koha
16:31 talljoy joined #koha
16:34 alex_a left #koha
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:42 libsysguy joined #koha
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` Bug[…]w_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 julian_m left #koha
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-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.[…]/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 it git am -iu3 <patch_location> to try and fix
16:49 jenkins_koha * f.demians: Bug 6314 XSL UNIMARC Improvments
16:49 huginn` Bug[…]w_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` Bug[…]w_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:50 francharb_lunch is now known as francharb_afk
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 melia joined #koha
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/atomicupdat​e/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 sophie_m left #koha
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 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.
16:59 ago43 left #koha
17:01 slef ask them what they're doing to celebrate ;-)
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 hdl left #koha
17:03 wizzyrea cool, thanks :)
17:04 gaetan_B bye everyone, have a nice week end!
17:04 gaetan_B left #koha
17:07 libsysguy this may be a dumb question but do you import authorities just like a regular import?
17:07 jcamins libsysguy: use -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 edveal joined #koha
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 hdl joined #koha
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:11 ago43 joined #koha
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` Bug[…]w_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:20 talljoy is now known as talljoy_away
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:
17:25 jcamins lol
17:25 jcamins Lunch time.
17:25 jcamins is now known as jcamins_away
17:25 wizzyrea finally an achievement system that I don't have to work too hard to get all of them.
17:25 francharb_afk left #koha
17:27 hdl left #koha
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:39 kf left #koha
17:40 libsysguy left #koha
17:45 oleonard so if I want the constraint the set reviews.borrowernumber null on patron delete, I add the constraint to borrowers?
17:49 jcamins_away is now known as jcamins
17:53 jwagner left #koha
18:08 cait joined #koha
18:08 liw left #koha
18:08 cait hi #koha
18:09 wizzyrea heya
18:09 NateC left #koha
18:09 NateC joined #koha
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 to
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
18:12 pastebot "chris_n" at pasted "upgrading from Koha to" (87 lines) at
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 moodaepo left #koha
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:17 nengard joined #koha
18:21 liw joined #koha
18:28 cait :)
18:31 chris_n running
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
18:40 ago43 is now known as ago43_lunch
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.[…]aster/614/console looks to be caused by bug 5327
18:57 huginn` Bug[…]w_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:00 trea is now known as trea-omgdoctors
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` Bug[…]w_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:08 ago43_lunch is now known as ago43
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 magnus_away left #koha
19:20 magnuse joined #koha
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
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 slef rugby sevens
19:30 trea joined #koha
19:31 chris_n 9200 records and counting
19:31 * chris_n looks around for memcached
19:32 rangi heh
19:36 talljoy_away is now known as talljoy
19:36 trea-omgdoctors left #koha
19:37 Soupermanito left #koha
19:43 Brooke joined #koha
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:53 Soupermanito joined #koha
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/
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[…]_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 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 pasted "Setting up foreign key constraints for reviews table" (7 lines) at
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 pasted "updatedatabase error" (1 line) at
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 oleonard left #koha
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.
20:57 jcamins is now known as jcamins_away
20:59 ago43 is now known as ago43_phone
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:05 nengard left #koha
21:08 Brooke left #koha
21:09 collum left #koha
21:19 maximep having a weird problem bug 6634
21:19 huginn` Bug[…]w_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` Bug[…]w_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[…]0825f43bd8592d109
21:27 maximep oh, it's from someone at libeo haha
21:27 maximep but it was a very old patch
21:29 paul_p left #koha
21:30 ago43_phone is now known as ago43
21:52 maximep left #koha
21:54 cait left #koha
21:57 fredpierre left #koha
22:01 melia is now known as melia_lunch
22:04 ago43 left #koha
22:10 JesseM left #koha
22:13 ago43 joined #koha
22:15 ago43 left #koha
22:22 * drojf puts some cold beers in #koha. weekend :)
22:31 druthb joined #koha
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:46 magnuse is now known as magnus_away
22:47 drojf wahanui: botsnack beer
22:47 wahanui thanks drojf :)
22:49 melia_lunch is now known as melia
22:58 druthb left #koha
23:04 talljoy left #koha
23:10 edveal left #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary