IRC log for #koha, 2012-08-28

All times shown according to UTC.

Time S Nick Message
00:12 melia left #koha
00:16 libsysguy joined #koha
00:19 rangi zomg
00:19 rangi please, just stop
00:23 Judit joined #koha
00:23 Judit morning
00:23 rangi hi Judit
00:24 Judit how is spring treating you dow there, rangi?
00:24 rangi officially hasnt started yet, but isn't too bad so far
00:56 bshum joined #koha
01:21 mib_odf96vVATAL joined #koha
01:59 druthb joined #koha
02:00 druthb o/
02:08 rangi hi druthb
02:08 druthb hi, rangi! :)
02:22 bag heya druthb
02:22 bag rangi - howdy
02:22 druthb hi, bag. :)
02:23 bag oh whoops it's bath time - guess I'll catch you all later
02:23 bag mtj?
02:23 wahanui DeM KraZy NutZ!!
02:23 bag w00t there it is
02:23 rangi heh
02:27 rangi bug 8597 signed off
02:27 huginn Bug[…]w_bug.cgi?id=8597 enhancement, P5 - low, ---, fcapovilla, Signed Off , New theme for the OPAC with a mobile view
02:29 jcamins_away Woohoo!
03:18 Judit joined #koha
03:52 cait joined #koha
04:15 Oak joined #koha
04:24 mona joined #koha
04:25 mona Error; your data might not have been saved     You need to log in again, your session has timed out
04:26 mona can somebody pleae help me in this
04:27 cait it would normally show that if you haven't done anything in a longer time or if you click the back browser button in ie
04:27 cait what do you need help with?
04:27 cait does logging in again not work?
04:28 druthb cait++
04:28 mona no actually in system preference i changes the timeout option to 1d
04:28 rangi that's the problem, you need to change that in the database, 1d doesnt work
04:28 mona after that it is getting timeout every second
04:29 mona meaning that i am not able to do a single thing
04:29 mona it logins and shows session timeout
04:29 mona pls help please
04:30 rangi update systempreferences set value='120000' where variable='timeout';
04:30 rangi you need to run that in your database, the documentation is wrong, you can't use 1d
04:31 WaqarAzeem joined #koha
04:32 mona i did it but its not saving     Error; your data might not have been saved     You need to log in again, your session has timed out
04:32 rangi you need to do it in the database
04:32 rangi not in koha
04:32 rangi did you log into mysql, into your koha database and run that sql?
04:34 mona atually someone has setup the pc installed for me
04:34 rangi they will need to do that for you then
04:34 mona can u guide me how to run mysql in ubuntu
04:34 mona please
04:34 mona if u will guide i will do it
04:35 rangi i have to go catch a bus home now sorry
04:36 mona just guide me how to start pls
05:01 Callender_ joined #koha
05:16 Irma joined #koha
05:16 mona Error; your data might not have been saved     You need to log in again, your session has timed out can anybody help
05:25 Oak joined #koha
05:50 cait-m__ joined #koha
06:01 * cait-m__ waves
06:02 Irma joined #koha
06:03 cait-m__ hi irma
06:03 Irma hello cait-m How are you?
06:27 alex_a bonjour #koha
06:28 Oak Bonjour Monsieur alex_a
06:28 alex_a Salut Oak !
06:28 laurence joined #koha
06:33 drojf good morning #koha
06:39 reiveune joined #koha
06:39 laurence joined #koha
06:39 Irma joined #koha
06:39 Callender_ joined #koha
06:39 WaqarAzeem joined #koha
06:39 jeff joined #koha
06:39 clrh joined #koha
06:39 huginn joined #koha
06:42 pastebot joined #koha
06:50 sophie_m joined #koha
06:58 asaurat joined #koha
06:58 huginn joined #koha
06:58 clrh joined #koha
06:58 jeff joined #koha
06:58 WaqarAzeem joined #koha
06:58 Callender_ joined #koha
06:58 Irma joined #koha
06:58 laurence joined #koha
06:58 reiveune joined #koha
06:58 sophie_m joined #koha
06:58 Oak joined #koha
06:58 bshum joined #koha
06:58 khall joined #koha
06:58 chris_n joined #koha
06:58 matts joined #koha
06:58 mtj joined #koha
06:58 senator joined #koha
06:58 tater joined #koha
06:58 ropuch joined #koha
06:58 jcamins_away joined #koha
06:58 janPasi joined #koha
06:58 bag joined #koha
06:58 ibeardslee joined #koha
06:58 rangi joined #koha
06:58 alohalog` joined #koha
06:58 fredericd joined #koha
06:58 wizzyrea joined #koha
06:58 gmcharlt joined #koha
06:58 jenkins_koha joined #koha
06:58 cjh joined #koha
06:58 magnuse joined #koha
07:03 WaqarAzeem Hello! Along with Perl... is there any framework is also used? like python with django for web apps.
07:07 alex_a WaqarAzeem: You mean with koha ?
07:07 alex_a WaqarAzeem: hello
07:12 drojf joined #koha
07:12 WaqarAzeem yeah!
07:15 WaqarAzeem Perl used as the programming language for Koha. I am wondering how to setup an local environment to play around with it.
07:17 alex_a WaqarAzeem: I'm not sure to understand your question :s
07:18 WaqarAzeem it's ok
07:20 alex_a Okay!
07:20 alex_a :)
07:22 alex_a WaqarAzeem: It would be nice to make koha works on a framework such as perl Dancer i.e. But i've tried to do this and it's very hard !
07:22 alex_a :)
07:33 WaqarAzeem nice effort...
07:52 paul_p joined #koha
07:53 magnuse kia ora paul_p!
07:53 paul_p good morning #koha
07:53 drojf bonjour paul_p
07:53 drojf hei magnuse
07:53 paul_p still 100 mails to deal with before i'm back to pushing patches ...
08:20 rangi can i get a test please, working ok?
08:21 drojf website is loading. anything else to try?
08:21 rangi nope thats all i needed
08:21 drojf 76508 results for a search for "a"
08:21 drojf ok
08:21 rangi (been shifting servers)
08:21 Judit joined #koha
08:22 rangi wanted to check all resolving good for the outside world
08:24 magnuse rangi: works from norway too :-) maybe a little faster than it used to be too?
08:25 rangi should be on a faster piece of internet
08:25 magnuse yay
08:38 rangi i hate printers
08:41 drojf why is that?
08:41 rangi they never work
08:41 rangi in any kind of predictable manner
08:44 drojf rangi: i'm afraid i have to agree, from my experience. but i mostly blame kde if something stops working for me
08:48 drojf hm. it appears my solar charge controller does not give out enough current on the usb connection to power the raspberry pi. still no self sustaining koha in a box :(
08:48 rangi :(
08:50 drojf fun fact: each progress bar in the process of staging and importing marc records via tools in koha seems to be broken in a different way
08:51 rangi hmm all comcast ppl have been suspended for excessive bounces, 9 of them
08:52 rangi however the one that is still bouncing must be subscribed under something else, and that address redirects
08:53 drojf tricky
08:54 drojf could that be found in the email headers somewhere maybe?
08:54 rangi yep found it eventually
08:54 drojf yay
08:54 rangi that's that sorted
08:55 drojf rangi++
08:56 eythian joined #koha
08:57 rangi hows stuttgart eythian ?
08:57 eythian dunno, only just arrived, the train was late
08:57 rangi ahhh
08:57 rangi how long before the workshop starts?
08:58 eythian Setting up now, probably in 5-10
08:58 drojf late? deutsche bahn? never!
08:59 rangi good luck
09:00 Barrc1 joined #koha
09:01 laurence joined #koha
09:02 eythian drojf: we determined that it was your fault
09:03 drojf eythian: i can live with that :P
09:11 Barrc1 Morning..... I am starting to look at publishing multiple OPACs (limited to library, CSS unique etc) and wondering if this is just a straight forward virtualhost config? Anyone have any gotchas or experience with this!?
09:12 drojf Barrc1: multiple opacs for one database? or multiple koha installations?
09:13 Barrc1 drojf: Multiple for one Koha instance (sorry, should have been clearer!)
09:17 drojf i think you can create several instances of koha using the same db. having just one koha instance with multiple opacs sounds not like something you can achieve easily. but that's more my feeling, i never thought about doing that. maybe others have some ideas
09:18 Oak joined #koha
09:20 Barrc1 it looks like you can set overrides in the virtual hosts and use host headers to resolve to the correct site - seems straight forward but I haven't tried it yet!
09:35 * magnuse wishes eythian and kf the best of luck - have fun!
09:45 drojf kf is not even logged in to the irc. serious business
09:56 drojf @wunder berlin, germany
09:56 huginn drojf: The current temperature in Prenzlauer Berg, Berlin, Germany is 21.7°C (11:43 AM CEST on August 28, 2012). Conditions: Mostly Cloudy. Humidity: 44%. Dew Point: 9.0°C. Pressure: 30.06 in 1018 hPa (Steady).
09:59 magnuse @wunder boo
09:59 huginn magnuse: The current temperature in Bodo, Norway is 13.0°C (11:50 AM CEST on August 28, 2012). Conditions: Clear. Humidity: 47%. Dew Point: 2.0°C. Pressure: 29.83 in 1010 hPa (Steady).
10:00 drojf what's a good summer termperature for bodø? i've only seen it in winter
10:02 mbalmer joined #koha
10:12 magnuse drojf: well, we expect to have a few days over 20C during a summer
10:13 magnuse anything above 15 is good
10:15 drojf heh. i like how people cope with that. when i've been to umeå everybody was running around in tshirts when it was 15°. they celebrate the summer they get :)
10:15 magnuse yup, that's how we stay sane ;-)
10:18 * eythian has completed his first talk
10:23 rangi cool :) did it go ok?
10:24 eythian I think it did, though I'm biased :)
10:25 eythian cait says it did, but I don't know if she's trustworthy
10:26 eythian (she's watching me type!)
10:27 rangi hehe
10:29 cait joined #koha
10:30 cait hi all
10:30 rangi hi cait
10:32 mveron joined #koha
10:33 eythian hi mveron
10:33 mveron hi eythian
10:33 chris_n` joined #koha
10:40 drojf hi mveron
10:40 drojf how is the workshop going?
10:41 drojf i hope you did not plan to look at sandboxes tomorrow
10:42 eythian why?
10:42 eythian oh
10:42 Oak yup :)
10:46 mveron hi drojf, it is very interesting.
10:59 cait joined #koha
11:12 * magnuse waves to cait and eythian
11:19 magnuse i love it when customers report problems that there is already a fix for - this time it was bug 8251
11:19 huginn Bug[…]w_bug.cgi?id=8251 critical, P1 - high, ---, koha, Pushed to Master , Patrons are systematically debarred at checkin
11:35 jwagner joined #koha
11:39 drojf joined #koha
11:43 bshum joined #koha
11:49 nengard joined #koha
11:56 eythian joined #koha
12:00 cait joined #koha
12:02 talljoy joined #koha
12:20 oleonard joined #koha
12:23 oleonard Hi #koha
12:28 drojf hi oleonard
12:30 paul_p_ joined #koha
13:03 mbalmer left #koha
13:05 Oak joined #koha
13:08 libsysguy-tab joined #koha
13:12 tcohen joined #koha
13:23 nengard_ joined #koha
13:25 libsysguy joined #koha
13:36 NateC joined #koha
13:51 * wizzyrea waves
13:51 oleonard Hi wizzyrea
13:53 drojf1 joined #koha
13:57 maximep joined #koha
13:59 nengard does anyone know if the new routing lists tab on the patron record in master is controlled by a preference? does it go away if you have no routing lists?
13:59 * nengard is working on the manual again
14:00 oleonard It doesn't go away if you have no routing lists
14:00 oleonard I'm guessing it's not controlled by a pref because I didn't turn one on and I see the tab.
14:01 oleonard And it violates capitalization guidelines :P
14:02 * oleonard wishes, again, for serials sample data
14:09 nengard oleonard i can give you my serials ?
14:10 asaurat joined #koha
14:10 oleonard nengard: I would gratefully accept
14:11 nengard it's not much
14:11 nengard and it's a bit messy :) but I'll send you a dump
14:20 eythian wah<tab>...damn
14:21 wahanui joined #koha
14:21 eythian wahanui: hello
14:21 wahanui what's up, eythian
14:22 oleonard Magic.
14:22 eythian germs?
14:22 wahanui Germs originated in Germany, before rapidly spreading throughout the rest of the world.
14:22 reiveune1 joined #koha
14:23 eythian slides?
14:23 wahanui kf should be writing slides. Get to it! Schnell!
14:24 eythian no wahanui, slides is kf has written her slides.
14:24 wahanui okay, eythian.
14:25 wizzyrea schnell.
14:26 eythian wahanui: schnell is <reply>I know nozink!
14:26 wahanui OK, eythian.
14:33 * wizzyrea giggles
14:35 rambutan joined #koha
14:35 rambutan left #koha
14:35 rambutan joined #koha
14:43 eythian wizzyrea: when do you hit civilisation?
14:43 wizzyrea October 29 :)
14:43 eythian Øarsome
14:44 oleonard Eh?
14:45 eythian You heard me, oleonard
14:50 paul_p joined #koha
14:53 paul_p joined #koha
15:00 laurence left #koha
15:02 gaetan_B joined #koha
15:04 asaurat left #koha
15:04 asaurat joined #koha
15:05 drojf can i skip MARC21 field 100 etc if i make a dummy entry to hang other biblios on? or will MARC come to get me?
15:05 jcamins_away drojf: 1xx fields are optional.
15:06 drojf cool, thanks jcamins_away
15:06 drojf btw, you are not really away
15:07 jcamins_away drojf: sort of away. What are you trying to do?
15:07 oleonard He is drojf, but he's shouting from far away
15:07 drojf lol oleonard
15:08 reiveune1 bye
15:08 reiveune1 left #koha
15:09 drojf jcamins_away: we have dvds with several titles. i want to have a parent titled "dvd XY" or something and link the "real" titles of the videos to the parent. so the parent has one item, the children have none, so people know they cannot get "video a" if it is on the same disk as "video b" and that disk is borrowed. does that make sense?
15:09 jcamins_away Yes, what does the 1xx have to do with anything?
15:10 jcamins_away You're describing analytics.
15:10 jcamins_away And specifically the EasyAnalytics use case.
15:11 drojf i try to keep the parent as minimal as possible. since there is not a single author for all the videos, i would prefer to have none for the parent. and was wondering wether that would make marc mad
15:11 wizzyrea drojf: that was the way koha was originally designed, until we put MARC in and broke it.
15:11 wizzyrea :(
15:11 wizzyrea (as I understand it)
15:11 jcamins_away Got it.
15:11 jcamins_away drojf: that's the correct way to do things.
15:12 wizzyrea NEKLS has a similar problem with things like TV series DVD's
15:12 jcamins_away But use EasyAnalytics to make the patrons happy.
15:12 wizzyrea some of our libraries split up the sets
15:12 wizzyrea and it was confusing for patrons
15:12 wizzyrea when they had items on the same set
15:12 wizzyrea for different discs
15:13 wizzyrea because since we don't allow item specific holds, they would request a hold for Breaking Bad (for example) and be wanting disc 2, but they would get disc 1 because they couldn't specify which disc to get.
15:13 wizzyrea very, very frustrating for patrons.
15:13 drojf jcamins_away: the data is not even in koha yet. as long as i get it in "somehow" I am happy, that might have to be enough happiness :D
15:13 wizzyrea so we finally cataloged them all separately
15:13 wizzyrea breaking bad, season one, disk 1
15:14 wizzyrea disc*
15:14 wizzyrea <items>
15:14 oleonard wizzyrea: Around here we call that the "pride and prejudice" problem after the multi-volume VHS set popular several years ago
15:14 drojf heh not sure what we are going to do with those because people don't like whole season boxes go away for weeks
15:14 wizzyrea and those records are separate from the ones where libraries choose not to split them up
15:14 wizzyrea so you can get "breaking bad, season one (full set)"
15:15 wizzyrea which is discrete from "breaking bad, season one, disc 1"
15:15 wizzyrea how did you solve it, oleonard?
15:15 oleonard We didn't
15:16 wizzyrea I think our method works ok - it muddies up the catalog but at least it's good for the patrons
15:16 wizzyrea if they want disc *, they can get it
15:16 wizzyrea and if there is a full set, they can get that too.
15:16 wizzyrea ah the joys of collaborating 42 public libraries.
15:17 wizzyrea in one system
15:17 drojf lol
15:17 oleonard We didn't solve the problem, but we also don't split up DVD sets, so the problem is lesser now that VHS is going away
15:17 wizzyrea ^^ I would prefer this, but some libraries, concerned about the sets being out for weeks, want to split them
15:17 wizzyrea so we let them, but make them do extra work. :P
15:18 oleonard Maybe if we did that too I'd have gotten to see some Game of Thrones by now
15:18 wizzyrea sorry jcamins, it had not occurred to me (and it is quite brilliant) to use analytics for that
15:18 wizzyrea of course it is brilliant. ;)
15:19 * oleonard guesses he'll have to learn what analytics are for now
15:19 jcamins_away oleonard: someone did this presentation on analytics for KohaCon12...
15:20 wizzyrea hehe oleonard re: game of thrones
15:20 oleonard jcamins_away:  If only there was a way to save a "re-cording" of that time and somehow play it back in the present
15:20 drojf heh
15:22 jcamins_away oleonard:[…]ticRecordsAndKoha
15:22 jcamins_away Sadly I can't figure out how to tell the site that it's a movie not audio.
15:26 Oak joined #koha
15:51 nengard anyone know if Koha is compliant with Open URL?
15:51 nengard what about SRU/WRW
15:51 nengard SRW
15:52 nengard oleonard i have info in the manual about what analytics are
15:53 jcamins_away nengard: OpenURL requires an outside link resolver. Koha does handle SRU/SRW.
15:55 jcamins_away nengard: you can insert the link resolver using jQuery, pulling the information required from CoINs.
16:00 oleonard On the left, the record staged in Koha. On the right, the .mrc file in MarcEdit:
16:00 oleonard What's going on?
16:01 oleonard Did we get bad MARC data from our vendor? Is Koha interpreting the data incorrectly?
16:02 melia joined #koha
16:02 jcamins_away oleonard: you imported it as UTF-8 when it was actually MARC-8.
16:03 jcamins_away MarcEdit defaults to MARC-8, and Koha defaults to UTF-8.
16:03 jcamins_away I think.
16:04 jcamins_away I might have it backwards, but I don't think so.
16:04 cait joined #koha
16:05 drojf joined #koha
16:06 asaurat left #koha
16:08 oleonard Okay, so re-importing and specifying MARC-8 corrected that record.
16:09 jcamins_away \o/
16:09 jcamins_away ^^ the MARC must die dance
16:09 oleonard There's another record which is the same either way. In MarcEdit the author looks like "Th?y, Kim" And the same in Koha after import
16:10 jcamins_away They mixed MARC-8 and UTF-8.
16:10 huginn New commit(s) kohagit: Merge remote-tracking branch 'origin/new/bug_8268' <[…]1ed2ca80cbe80289f> / Bug 8268: improve error checking <[…]3a694c5c6e6208b72> / Bug 8268 follow-up: rewrite config correctly <[…]h=d944df2272b0fbe
16:19 Oak jcamins++
16:19 jcamins_away ?
16:20 Oak paul_p++
16:20 jcamins_away @karma
16:20 huginn jcamins_away: Highest karma: "rangi" (643), "oleonard" (537), and "jcamins" (383).  Lowest karma: "<!" (-111), "failed" (-93), and "-" (-59).  You (jcamins_away) are ranked 58 out of 2197.
16:20 Oak your knowledge about stuff always astonishes me jcamins_away :)
16:20 oleonard Yes, jcamins_away++
16:21 jcamins_away Ooh, I'm catching up with you, oleonard!
16:21 jcamins_away @karma jcamins_away
16:21 huginn jcamins_away: Karma for "jcamins_away" has been increased 15 times and decreased 0 times for a total karma of 15.
16:21 oleonard jcamins_away: I'll keep being unhelpful if that would help
16:21 * oleonard explodes in paradox
16:22 Oak funny
16:22 jcamins_away Hehe.
16:24 Barrc1 left #koha
16:25 jenkins_koha Starting build #802 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #773 1 mo 25 days ago)
16:28 Oak thsi is very very good, Van Morrison - Sweet Thing:
16:29 Oak @later tell Brooke
16:29 huginn Oak: The operation succeeded.
16:29 Oak @later tell cait
16:29 huginn Oak: The operation succeeded.
16:42 oleonard It would be cool if git bz apply checked for dependent bugs. Then I wouldn't make dumb mistakes like forgetting to apply another patch first. :|
16:43 * oleonard tests Bug 5888 for real now
16:43 huginn Bug[…]w_bug.cgi?id=5888 enhancement, P5 - low, ---, julian.maurice, Signed Off , opac-detail subject/author links improvements
16:43 jcamins_away oleonard: ooh, good idea.
16:47 oleonard jcamins_away: Shouldn't 5888 have a system pref to turn it on and off?
16:55 rambutan joined #koha
16:58 jcamins_away oleonard: probably.
16:58 * jcamins_away was particularly concerned with the functionality that was moved to bug 8210.
16:58 huginn Bug[…]w_bug.cgi?id=8210 enhancement, P5 - low, ---, jcamins, Signed Off , Headings in OPAC bib details should link to authority record
17:02 JoeLib001 joined #koha
17:03 wizzyrea we want to match modify/import batches of records for catalog cleanup - what, do you think, on a light load catalog, is the maximum number you'd want to do at one time to keep zebra happy?
17:03 wizzyrea (assuming you're not going to do them all at once, and let the zebraqueue handle them)
17:03 wizzyrea (i.e. not just doing a full reindex for each batch)
17:04 wizzyrea or would a full reindex be a better route?
17:07 martian523 joined #koha
17:07 martian523 hi, just a quick question
17:08 martian523 has koha set up the hourly circulation policies yet?
17:09 martian523 or is it still under construction?
17:10 maximep hourly loans are in 3.8
17:11 martian523 really? maybe i missed it, i'm using 3.8
17:11 maximep look in circulation rules
17:11 maximep you should have hours unit
17:12 martian523 thanks
17:14 martian523 i have another one
17:15 martian523 in circulation rules, there are 3 reference in "type"
17:15 martian523 but when editing item, there's only 1 reference
17:16 martian523 what happened to the other 2?
17:17 martian523 never mind
17:17 martian523 i found the answer
17:17 martian523 sorry!
17:29 jenkins_koha Project Koha_master build #802: STILL UNSTABLE in 1 hr 3 min: http://jenkins.koha-community.[…]/Koha_master/802/
17:29 jenkins_koha * jonathan.druart: Bug 8607: FIX overdues_notices script: $date is not replaced
17:29 jenkins_koha * julian.maurice: Bug 8495: Fix JS error when creating a new order
17:29 jenkins_koha * fridolyn.somers: Bug 8576: Software error on authority edition when using merge
17:29 jenkins_koha * jcamins: Bug 8268 follow-up: rewrite config correctly
17:29 jenkins_koha * jcamins: Bug 8268: improve error checking
17:29 huginn Bug[…]w_bug.cgi?id=8607 blocker, P5 - low, ---, jonathan.druart, Pushed to Master , overdue_notices is broken
17:29 huginn Bug[…]w_bug.cgi?id=8495 blocker, P5 - low, ---, julian.maurice, Pushed to Master , Javascript error when creating a new order
17:29 huginn Bug[…]w_bug.cgi?id=8576 critical, P2, ---, fridolyn.somers, Pushed to Stable , Software error on authority edition when using merge
17:29 huginn Bug[…]w_bug.cgi?id=8268 enhancement, P2, ---, jcamins, Pushed to Master , Koha should offer way to backup entire db
17:31 brylie joined #koha
18:28 rambutan joined #koha
18:32 drojf joined #koha
18:42 nengard okay, silly question, how can i find out what my highest barcode number is? I tried a report sorting by barcode desc and it's not working ?
18:42 nengard when my barcode generator gives me a code it's always  3.89924798249022e+19  and i want to update my highest number so that stops
18:42 nengard unless i'm on the wrong track
18:42 oleonard The sort should work. What do you get instead of the highest number?
18:43 nengard hang on i'll do a paste
18:43 jcamins_away nengard: SELECT MAX(barcodes) from items
18:43 jcamins_away Or MAX(barcode) or whatever the field is.
18:44 pastebot "oleonard" at pasted "Top barcodes" (16 lines) at
18:44 oleonard ^^ that's some awesome barcode garbage I have
18:44 pastebot "nengard" at pasted "see the 3rd to last number - it's not in order and these can't be the highest numbers if that's what's happening with my auto barcode generator thingy :)" (18 lines) at
18:45 nengard oleonard, i fixed those :)
18:45 nengard after i gave you the dump
18:45 jcamins_away Right, you can't do a sort on barcode.
18:45 oleonard Oh those aren't yours, those are all mine :)
18:45 jcamins_away Barcode is a string.
18:46 nengard nuh uh - those are what i had when i first wrote the report
18:46 jcamins_away Also, MAX() with strings does weird things.
18:46 nengard right
18:46 nengard the number it gave me is not super high
18:46 jcamins_away There was a ticket about that with Masscat.
18:46 nengard how about a count of characters
18:46 nengard what is the max number of characters allowed?
18:47 nengard and can i query any codes above that?
18:47 oleonard Oh you're right nengard I had my dbs switched
18:47 nengard :)
18:47 oleonard xx226648-108820 instead :)
18:47 jcamins_away nengard: the database can't store more than the maximum number of characters.
18:48 jcamins_away Your problem barcode is literally "3.89924798249022e+18" or something like that.
18:48 nengard mysql> select barcode from items where barcode like '3.899%';
18:48 nengard Empty set (0.00 sec)
18:49 jcamins_away Use SELECT MAX(barcode)
18:49 jcamins_away I should mention- if you're *lucky* that barcode exists.
18:50 jcamins_away If you're not lucky, I suggest going through the database's pockets and looking for loose change.
18:51 pastebot "nengard" at pasted "i bet the one that is 20 char in length is the problem" (20 lines) at
18:51 wizzyrea the last time I tried to get a max barcode, I got "SPECIAL ITEM NO BARCODE" as the result (or something like)
18:51 wizzyrea not helpful ;)
18:51 jcamins_away wizzyrea: sounds about right.
18:51 nengard i did the max thing and got a number that was not long at all
18:52 pastebot "nengard" at pasted "thing i found the culprit" (9 lines) at
18:52 wizzyrea then I limited to branch and that was much nicer.
18:52 oleonard wizzyrea: Sounds like my staff, who like to put in the phone number field "No phone"
18:52 jcamins_away[…]a14a0;hb=HEAD#l95
18:52 wizzyrea argle bargle bargle blarg
18:52 jcamins_away nengard: ^^ the offending code.
18:52 jcamins_away Try MAX(ABS(barcode))
18:53 * jcamins_away notes this is why Excel is evil.
18:55 wajasu drojf: i think you mentioned being interested in my postfix email client setup. so I've pasted some config for reference.
18:55 pastebot "wajasu" at pasted "notes for configuring "null" email client for koha outgoing email" (345 lines) at
18:55 nengard fixed it :)
18:55 nengard it was that 20 character barcode
18:55 * oleonard thanks jcamins_away for pointing out that "argle bargle bargle blarg" is offending code
18:56 drojf wow. thanks wajasu
18:56 wajasu it worked with my bug 8378 patch, which hopefully gets sign off
18:56 huginn Bug[…]w_bug.cgi?id=8378 critical, P5 - low, ---, koha-bugs, Needs Signoff , <fine> syntax not working on overdues anymore
19:02 nengard jcamins i never did pin point my authority problem ? i re-ran the linker and it won't link my name authorities (not asking for help right now - just an fyi)
19:03 jcamins_away Odd.
19:03 jcamins_away I'll run the linker against my database again when I'm looking at authority linking next.
19:05 * gmcharlt has a guess - checks something to confirm
19:05 wajasu rangi: i know we spoke about some sort of functional or integrated tests a few days back.   i was able to use geb-spock (aka groovy based selenium2 webdriver specs) to login to koha and verifiy we arrive at the home page with firefox.
19:05 wajasu
19:05 wajasu I also, got fitnesee running to call groovy based fixtures. So we could have non-programmers write tests in fitnesse web pages.
19:06 wajasu then use fitnesse to verify that database row entries are correct in the backend.
19:08 wajasu i looked into a perl slim protocol driver, and that could be done later if you wanted, because you said unit tests were fine.
19:09 wajasu fitnesse is a wiki for writing high level tests.  devs can write fixtures to enable the tests.  fitnesse has a git plugin, so writing a test, adds the files inthe git directories to the git repo.  so they get checked in with the branch, etc.
19:14 wajasu if this could be set up, we could push slower workflow of test-fail-test-fail-signoff  to writetest-code-failtest-code-​passtest-test-signoff-passqa. devs would need to pass test before they checkin/push/supply patch code.
19:15 jcamins_away wajasu: that only works as well as your users' motivation to write tests.
19:18 gaetan_B joined #koha
19:19 wajasu as a signer, could we not write a test when a patch fails then refer to it for them to pass/adjust for the next cycle?  or when complex functionality is wanted (acquisitions, etc).  you are right. writing tests is hard, but decoupling is hard.
19:20 brylie joined #koha
19:23 jcamins_away wajasu: true.
19:29 jcamins_away wajasu: I think it's an excellent idea, just pointing out that a workflow of writetest-code-failtest-code-​passtest-test-signoff-passqa is a little bit overly optimistic. ;)
19:34 rangi Morning
19:34 oleonard Hi rangi
19:35 rangi @wunder nzwn
19:35 huginn rangi: The current temperature in Wellington, New Zealand is 7.0°C (7:00 AM NZST on August 29, 2012). Conditions: Clear. Humidity: 87%. Dew Point: 5.0°C. Windchill: 4.0°C. Pressure: 30.18 in 1022 hPa (Rising).
19:35 rangi Spring
19:42 rangi Hmm Jenkins still angry
19:42 rangi Better sooth him soon
19:43 rangi Or he will go postal
19:45 * wizzyrea read that "better scotch him soon"
19:45 wizzyrea yes, give him booze. that makes all butlers happy
19:46 rangi Hehe
19:59 rangi Ok my stop bbiab
20:11 kathryn joined #koha
20:13 oleonard Bye #koha
20:24 rangi back
20:25 wajasu rangi: to prevent repeating myself.[…]2-08-28#i_1061550
20:27 rangi cool
20:58 mbalmer joined #koha
21:05 pastebot "wajasu" at pasted "using geb-spock to test koha gui using firefox" (112 lines) at
21:05 jcamins_away wajasu: don't suppose we could use Perl with that?
21:06 wajasu i was going to write a perl slim port to let us call perl code.  then you can test sevices, modules, sub routines.
21:09 wajasu once its set up, folks just write specs in the fitness wiki.  the wiki specs are saved to a directory in the git repo.  the step definitions/fixtures can be written in groovy.  with a perl slim server port, you can write perl based fixtures for the same fitness tests.
21:09 jcamins_away wajasu: but people need to use the wiki to write Python?
21:12 wajasu to write specs in the fitnesse wiki markup.  language independent.  slim protocol sends strings/lists with simple protoocl to slim server that is written in java, ruby, perl(TODO), and the tests are executed, with results coming back to the fitnesse webbrowser.
21:18 * jcamins_away leaves
21:18 wajasu i'm just wondiering what you guys want/need in testing.   you have unit tests.   you can already mock.   its integration tests that use all the tiers (gui, service, api, database) that you can prove at release time to prevent regressions.
21:42 caitst joined #koha
21:47 cait-m__ joined #koha
22:10 jenkins_koha Starting build #144 for job Koha_3.8.x (previous build: SUCCESS)
22:16 NateC left #koha
22:17 NateC joined #koha
22:17 Ccorrales joined #koha
22:30 maximep left #koha
22:48 jcamins_away wajasu: exactly. It's the complete stack that needs testing.
22:49 rambutan joined #koha
23:13 jenkins_koha Project Koha_3.8.x build #144: SUCCESS in 1 hr 3 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/144/
23:13 jenkins_koha julian.maurice: Bug 8495: Fix JS error when creating a new order
23:13 huginn Bug[…]w_bug.cgi?id=8495 blocker, P5 - low, ---, julian.maurice, Pushed to Stable , Javascript error when creating a new order
23:21 rambutan left #koha

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