IRC log for #koha, 2012-08-28

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

All times shown according to UTC.

Time Nick Message
00:09 melia left #koha
00:14 libsysguy joined #koha
00:17 rangi zomg
00:17 please, just stop
00:21 Judit joined #koha
00:21 Judit morning
00:21 rangi hi Judit
00:21 Judit how is spring treating you dow there, rangi?
00:22 rangi officially hasnt started yet, but isn't too bad so far
00:53 bshum joined #koha
01:18 mib_odf96vVATAL joined #koha
01:57 druthb joined #koha
01:57 druthb o/
02:05 rangi hi druthb
02:05 druthb hi, rangi! :)
02:20 bag heya druthb
02:20 rangi - howdy
02:20 druthb hi, bag. :)
02:20 bag oh whoops it's bath time - guess I'll catch you all later
02:20 mtj?
02:20 wahanui DeM KraZy NutZ!!
02:21 bag w00t there it is
02:21 rangi heh
02:24 bug 8597 signed off
02:24 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8597 enhancement, P5 - low, ---, fcapovilla, Signed Off , New theme for the OPAC with a mobile view
02:26 jcamins_away Woohoo!
03:15 Judit joined #koha
03:50 cait joined #koha
04:13 Oak joined #koha
04:22 mona joined #koha
04:23 mona Error; your data might not have been saved     You need to log in again, your session has timed out
04:23 can somebody pleae help me in this
04:25 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:25 what do you need help with?
04:25 does logging in again not work?
04:25 druthb cait++
04:26 mona no actually in system preference i changes the timeout option to 1d
04:26 rangi that's the problem, you need to change that in the database, 1d doesnt work
04:26 mona after that it is getting timeout every second
04:27 meaning that i am not able to do a single thing
04:27 it logins and shows session timeout
04:27 pls help please
04:27 rangi update systempreferences set value='120000' where variable='timeout';
04:28 you need to run that in your database, the documentation is wrong, you can't use 1d
04:28 WaqarAzeem joined #koha
04:29 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:29 rangi you need to do it in the database
04:29 not in koha
04:30 did you log into mysql, into your koha database and run that sql?
04:31 mona atually someone has setup the pc installed for me
04:31 rangi they will need to do that for you then
04:32 mona can u guide me how to run mysql in ubuntu
04:32 please
04:32 if u will guide i will do it
04:32 rangi i have to go catch a bus home now sorry
04:34 mona just guide me how to start pls
04:58 Callender_ joined #koha
05:13 Irma joined #koha
05:14 mona Error; your data might not have been saved     You need to log in again, your session has timed out can anybody help
05:22 Oak joined #koha
05:47 cait-m__ joined #koha
05:59 * cait-m__ waves
06:00 Irma joined #koha
06:01 cait-m__ hi irma
06:01 Irma hello cait-m How are you?
06:24 alex_a bonjour #koha
06:25 Oak Bonjour Monsieur alex_a
06:26 alex_a Salut Oak !
06:26 laurence joined #koha
06:31 drojf good morning #koha
06:36 reiveune joined #koha
06:36 laurence joined #koha
06:36 Irma joined #koha
06:36 Callender_ joined #koha
06:36 WaqarAzeem joined #koha
06:36 jeff joined #koha
06:36 clrh joined #koha
06:36 huginn joined #koha
06:40 pastebot joined #koha
06:46 sophie_m joined #koha
06:48 reiveune joined #koha
06:48 laurence joined #koha
06:48 Irma joined #koha
06:48 Callender_ joined #koha
06:48 WaqarAzeem joined #koha
06:48 jeff joined #koha
06:48 clrh joined #koha
06:48 huginn joined #koha
06:50 asaurat joined #koha
06:56 pastebot joined #koha
06:56 Judit joined #koha
06:56 drojf joined #koha
06:56 logbot joined #koha
06:56 alex_a joined #koha
06:56 wajasu joined #koha
06:56 wahanui joined #koha
06:56 sijobl joined #koha
06:56 lamiette joined #koha
06:56 fredy joined #koha
06:56 mtate joined #koha
06:56 liw joined #koha
06:56 tweetbot` joined #koha
06:56 dpavlin joined #koha
06:56 slef joined #koha
07:01 WaqarAzeem Hello! Along with Perl... is there any framework is also used? like python with django for web apps.
07:05 alex_a WaqarAzeem: You mean with koha ?
07:05 WaqarAzeem: hello
07:10 drojf joined #koha
07:10 WaqarAzeem yeah!
07:13 Perl used as the programming language for Koha. I am wondering how to setup an local environment to play around with it.
07:15 alex_a WaqarAzeem: I'm not sure to understand your question :s
07:16 WaqarAzeem it's ok
07:18 alex_a Okay!
07:18 :)
07:19 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:20 :)
07:31 WaqarAzeem nice effort...
07:50 paul_p joined #koha
07:50 magnuse kia ora paul_p!
07:51 paul_p good morning #koha
07:51 drojf bonjour paul_p
07:51 hei magnuse
07:51 paul_p still 100 mails to deal with before i'm back to pushing patches ...
08:18 rangi can i get a test please, www.library.org.nz working ok?
08:19 drojf website is loading. anything else to try?
08:19 rangi nope thats all i needed
08:19 drojf 76508 results for a search for "a"
08:19 ok
08:19 rangi (been shifting servers)
08:19 Judit joined #koha
08:19 rangi wanted to check all resolving good for the outside world
08:22 magnuse rangi: works from norway too :-) maybe a little faster than it used to be too?
08:23 rangi should be on a faster piece of internet
08:23 magnuse yay
08:36 rangi i hate printers
08:38 drojf why is that?
08:39 rangi they never work
08:39 in any kind of predictable manner
08:42 drojf rangi: i'm afraid i have to agree, from my experience. but i mostly blame kde if something stops working for me
08:46 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:46 rangi :(
08:48 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:49 rangi hmm all comcast ppl have been suspended for excessive bounces, 9 of them
08:49 however the one that is still bouncing must be subscribed under something else, and that address redirects
08:50 drojf tricky
08:52 could that be found in the email headers somewhere maybe?
08:52 rangi yep found it eventually
08:52 drojf yay
08:52 rangi that's that sorted
08:53 drojf rangi++
08:53 eythian joined #koha
08:54 rangi hows stuttgart eythian ?
08:55 eythian dunno, only just arrived, the train was late
08:55 rangi ahhh
08:55 how long before the workshop starts?
08:55 eythian Setting up now, probably in 5-10
08:55 drojf late? deutsche bahn? never!
08:57 rangi good luck
08:58 Barrc1 joined #koha
08:59 laurence joined #koha
08:59 eythian drojf: we determined that it was your fault
09:01 drojf eythian: i can live with that :P
09:08 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:10 drojf Barrc1: multiple opacs for one database? or multiple koha installations?
09:11 Barrc1 drojf: Multiple for one Koha instance (sorry, should have been clearer!)
09:15 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:16 Oak joined #koha
09:18 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:32 * magnuse wishes eythian and kf the best of luck - have fun!
09:42 drojf kf is not even logged in to the irc. serious business
09:54 @wunder berlin, germany
09:54 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:57 magnuse @wunder boo
09:57 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).
09:58 drojf what's a good summer termperature for bodø? i've only seen it in winter
09:59 mbalmer joined #koha
10:10 magnuse drojf: well, we expect to have a few days over 20C during a summer
10:10 anything above 15 is good
10:13 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:13 magnuse yup, that's how we stay sane ;-)
10:16 * eythian has completed his first talk
10:21 rangi cool :) did it go ok?
10:22 eythian I think it did, though I'm biased :)
10:22 cait says it did, but I don't know if she's trustworthy
10:23 (she's watching me type!)
10:25 rangi hehe
10:27 cait joined #koha
10:27 cait hi all
10:28 rangi hi cait
10:30 mveron joined #koha
10:30 eythian hi mveron
10:31 mveron hi eythian
10:31 chris_n` joined #koha
10:38 drojf hi mveron
10:38 how is the workshop going?
10:39 i hope you did not plan to look at sandboxes tomorrow
10:39 eythian why?
10:40 oh
10:40 Oak yup :)
10:43 mveron hi drojf, it is very interesting.
10:57 cait joined #koha
11:10 * magnuse waves to cait and eythian
11:17 magnuse i love it when customers report problems that there is already a fix for - this time it was bug 8251
11:17 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8251 critical, P1 - high, ---, koha, Pushed to Master , Patrons are systematically debarred at checkin
11:33 jwagner joined #koha
11:37 drojf joined #koha
11:40 bshum joined #koha
11:47 nengard joined #koha
11:54 eythian joined #koha
11:58 cait joined #koha
12:00 talljoy joined #koha
12:18 oleonard joined #koha
12:20 oleonard Hi #koha
12:26 drojf hi oleonard
12:27 paul_p_ joined #koha
13:00 mbalmer left #koha
13:02 Oak joined #koha
13:06 libsysguy-tab joined #koha
13:10 tcohen joined #koha
13:21 nengard_ joined #koha
13:23 libsysguy joined #koha
13:34 NateC joined #koha
13:48 * wizzyrea waves
13:49 oleonard Hi wizzyrea
13:51 drojf1 joined #koha
13:54 maximep joined #koha
13:57 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:57 * nengard is working on the manual again
13:58 oleonard It doesn't go away if you have no routing lists
13:58 I'm guessing it's not controlled by a pref because I didn't turn one on and I see the tab.
13:58 And it violates capitalization guidelines :P
13:59 * oleonard wishes, again, for serials sample data
14:07 nengard oleonard i can give you my serials ?
14:07 asaurat joined #koha
14:08 oleonard nengard: I would gratefully accept
14:08 nengard it's not much
14:08 and it's a bit messy :) but I'll send you a dump
14:18 eythian wah<tab>...damn
14:19 wahanui joined #koha
14:19 eythian wahanui: hello
14:19 wahanui what's up, eythian
14:19 oleonard Magic.
14:20 eythian germs?
14:20 wahanui Germs originated in Germany, before rapidly spreading throughout the rest of the world.
14:20 reiveune1 joined #koha
14:21 eythian slides?
14:21 wahanui kf should be writing slides. Get to it! Schnell!
14:21 eythian no wahanui, slides is kf has written her slides.
14:21 wahanui okay, eythian.
14:23 wizzyrea schnell.
14:24 eythian wahanui: schnell is <reply>I know nozink!
14:24 wahanui OK, eythian.
14:31 * wizzyrea giggles
14:32 rambutan joined #koha
14:33 rambutan left #koha
14:33 rambutan joined #koha
14:40 eythian wizzyrea: when do you hit civilisation?
14:41 wizzyrea October 29 :)
14:41 eythian Øarsome
14:42 oleonard Eh?
14:43 eythian You heard me, oleonard
14:48 paul_p joined #koha
14:50 paul_p joined #koha
14:57 laurence left #koha
15:00 gaetan_B joined #koha
15:02 asaurat left #koha
15:02 asaurat joined #koha
15:03 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:03 jcamins_away drojf: 1xx fields are optional.
15:03 drojf cool, thanks jcamins_away
15:04 btw, you are not really away
15:04 jcamins_away drojf: sort of away. What are you trying to do?
15:04 oleonard He is drojf, but he's shouting from far away
15:05 drojf lol oleonard
15:06 reiveune1 bye
15:06 reiveune1 left #koha
15:07 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:07 jcamins_away Yes, what does the 1xx have to do with anything?
15:07 You're describing analytics.
15:08 And specifically the EasyAnalytics use case.
15:08 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:09 wizzyrea drojf: that was the way koha was originally designed, until we put MARC in and broke it.
15:09 :(
15:09 (as I understand it)
15:09 jcamins_away Got it.
15:09 drojf: that's the correct way to do things.
15:09 wizzyrea NEKLS has a similar problem with things like TV series DVD's
15:09 jcamins_away But use EasyAnalytics to make the patrons happy.
15:10 wizzyrea some of our libraries split up the sets
15:10 and it was confusing for patrons
15:10 when they had items on the same set
15:10 for different discs
15:10 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:11 very, very frustrating for patrons.
15:11 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:11 wizzyrea so we finally cataloged them all separately
15:11 breaking bad, season one, disk 1
15:11 disc*
15:11 <items>
15:12 oleonard wizzyrea: Around here we call that the "pride and prejudice" problem after the multi-volume VHS set popular several years ago
15:12 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:12 wizzyrea and those records are separate from the ones where libraries choose not to split them up
15:12 so you can get "breaking bad, season one (full set)"
15:12 which is discrete from "breaking bad, season one, disc 1"
15:13 how did you solve it, oleonard?
15:13 oleonard We didn't
15:13 wizzyrea I think our method works ok - it muddies up the catalog but at least it's good for the patrons
15:14 if they want disc *, they can get it
15:14 and if there is a full set, they can get that too.
15:14 ah the joys of collaborating 42 public libraries.
15:14 in one system
15:14 drojf lol
15:14 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:15 wizzyrea ^^ I would prefer this, but some libraries, concerned about the sets being out for weeks, want to split them
15:15 so we let them, but make them do extra work. :P
15:16 oleonard Maybe if we did that too I'd have gotten to see some Game of Thrones by now
15:16 wizzyrea sorry jcamins, it had not occurred to me (and it is quite brilliant) to use analytics for that
15:16 of course it is brilliant. ;)
15:16 * oleonard guesses he'll have to learn what analytics are for now
15:17 jcamins_away oleonard: someone did this presentation on analytics for KohaCon12...
15:17 wizzyrea hehe oleonard re: game of thrones
15:18 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:18 drojf heh
15:20 jcamins_away oleonard: http://archive.org/details/Koh[…]ticRecordsAndKoha
15:20 Sadly I can't figure out how to tell the site that it's a movie not audio.
15:24 Oak joined #koha
15:48 nengard anyone know if Koha is compliant with Open URL?
15:49 what about SRU/WRW
15:49 SRW
15:49 oleonard i have info in the manual about what analytics are
15:51 jcamins_away nengard: OpenURL requires an outside link resolver. Koha does handle SRU/SRW.
15:53 nengard: you can insert the link resolver using jQuery, pulling the information required from CoINs.
15:58 oleonard On the left, the record staged in Koha. On the right, the .mrc file in MarcEdit: http://screencast.com/t/aixGrcN1Ae
15:58 What's going on?
15:58 Did we get bad MARC data from our vendor? Is Koha interpreting the data incorrectly?
16:00 melia joined #koha
16:00 jcamins_away oleonard: you imported it as UTF-8 when it was actually MARC-8.
16:00 MarcEdit defaults to MARC-8, and Koha defaults to UTF-8.
16:00 I think.
16:01 I might have it backwards, but I don't think so.
16:02 cait joined #koha
16:03 drojf joined #koha
16:03 asaurat left #koha
16:06 oleonard Okay, so re-importing and specifying MARC-8 corrected that record.
16:06 jcamins_away \o/
16:06 ^^ the MARC must die dance
16:07 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:08 jcamins_away They mixed MARC-8 and UTF-8.
16:08 huginn New commit(s) kohagit: Merge remote-tracking branch 'origin/new/bug_8268' <http://git.koha-community.org/[…]1ed2ca80cbe80289f> / Bug 8268: improve error checking <http://git.koha-community.org/[…]3a694c5c6e6208b72> / Bug 8268 follow-up: rewrite config correctly <http://git.koha-community.org/[…]h=d944df2272b0fbe
16:17 Oak jcamins++
16:17 jcamins_away ?
16:17 Oak paul_p++
16:18 jcamins_away @karma
16:18 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:18 Oak your knowledge about stuff always astonishes me jcamins_away :)
16:18 oleonard Yes, jcamins_away++
16:18 jcamins_away Ooh, I'm catching up with you, oleonard!
16:18 @karma jcamins_away
16:18 huginn jcamins_away: Karma for "jcamins_away" has been increased 15 times and decreased 0 times for a total karma of 15.
16:19 oleonard jcamins_away: I'll keep being unhelpful if that would help
16:19 * oleonard explodes in paradox
16:19 Oak funny
16:19 jcamins_away Hehe.
16:21 Barrc1 left #koha
16:23 jenkins_koha Starting build #802 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #773 1 mo 25 days ago)
16:25 Oak thsi is very very good, Van Morrison - Sweet Thing: https://www.youtube.com/watch?v=1eK1aQF60xc
16:26 @later tell Brooke https://www.youtube.com/watch?v=1eK1aQF60xc
16:26 huginn Oak: The operation succeeded.
16:27 Oak @later tell cait https://www.youtube.com/watch?v=1eK1aQF60xc
16:27 huginn Oak: The operation succeeded.
16:40 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:40 * oleonard tests Bug 5888 for real now
16:40 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5888 enhancement, P5 - low, ---, julian.maurice, Signed Off , opac-detail subject/author links improvements
16:41 jcamins_away oleonard: ooh, good idea.
16:45 oleonard jcamins_away: Shouldn't 5888 have a system pref to turn it on and off?
16:53 rambutan joined #koha
16:56 jcamins_away oleonard: probably.
16:56 * jcamins_away was particularly concerned with the functionality that was moved to bug 8210.
16:56 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8210 enhancement, P5 - low, ---, jcamins, Signed Off , Headings in OPAC bib details should link to authority record
16:59 JoeLib001 joined #koha
17:01 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:01 (assuming you're not going to do them all at once, and let the zebraqueue handle them)
17:01 (i.e. not just doing a full reindex for each batch)
17:01 or would a full reindex be a better route?
17:05 martian523 joined #koha
17:05 martian523 hi, just a quick question
17:06 has koha set up the hourly circulation policies yet?
17:06 or is it still under construction?
17:07 maximep hourly loans are in 3.8
17:08 martian523 really? maybe i missed it, i'm using 3.8
17:09 maximep look in circulation rules
17:09 you should have hours unit
17:10 martian523 thanks
17:12 ok...now i have another one
17:13 in circulation rules, there are 3 reference in "type"
17:13 but when editing item, there's only 1 reference
17:13 what happened to the other 2?
17:15 never mind
17:15 i found the answer
17:15 sorry!
17:26 jenkins_koha Project Koha_master build #802: STILL UNSTABLE in 1 hr 3 min: http://jenkins.koha-community.[…]/Koha_master/802/
17:26 * jonathan.druart: Bug 8607: FIX overdues_notices script: $date is not replaced
17:26 * julian.maurice: Bug 8495: Fix JS error when creating a new order
17:26 * fridolyn.somers: Bug 8576: Software error on authority edition when using merge
17:26 * jcamins: Bug 8268 follow-up: rewrite config correctly
17:26 * jcamins: Bug 8268: improve error checking
17:26 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8607 blocker, P5 - low, ---, jonathan.druart, Pushed to Master , overdue_notices is broken
17:26 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8495 blocker, P5 - low, ---, julian.maurice, Pushed to Master , Javascript error when creating a new order
17:26 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8576 critical, P2, ---, fridolyn.somers, Pushed to Stable , Software error on authority edition when using merge
17:26 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8268 enhancement, P2, ---, jcamins, Pushed to Master , Koha should offer way to backup entire db
17:28 brylie joined #koha
18:26 rambutan joined #koha
18:29 drojf joined #koha
18:39 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:40 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:40 unless i'm on the wrong track
18:40 oleonard The sort should work. What do you get instead of the highest number?
18:40 nengard hang on i'll do a paste
18:40 jcamins_away nengard: SELECT MAX(barcodes) from items
18:41 Or MAX(barcode) or whatever the field is.
18:42 pastebot "oleonard" at 127.0.0.1 pasted "Top barcodes" (16 lines) at http://paste.koha-community.org/141
18:42 oleonard ^^ that's some awesome barcode garbage I have
18:42 pastebot "nengard" at 127.0.0.1 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 http://paste.koha-community.org/142
18:43 nengard oleonard, i fixed those :)
18:43 after i gave you the dump
18:43 jcamins_away Right, you can't do a sort on barcode.
18:43 oleonard Oh those aren't yours, those are all mine :)
18:43 jcamins_away Barcode is a string.
18:43 nengard nuh uh - those are what i had when i first wrote the report
18:44 jcamins_away Also, MAX() with strings does weird things.
18:44 nengard right
18:44 the number it gave me is not super high
18:44 jcamins_away There was a ticket about that with Masscat.
18:44 nengard how about a count of characters
18:44 what is the max number of characters allowed?
18:44 and can i query any codes above that?
18:44 oleonard Oh you're right nengard I had my dbs switched
18:44 nengard :)
18:45 oleonard xx226648-108820 instead :)
18:45 jcamins_away nengard: the database can't store more than the maximum number of characters.
18:45 Your problem barcode is literally "3.89924798249022e+18" or something like that.
18:46 nengard mysql> select barcode from items where barcode like '3.899%';
18:46 Empty set (0.00 sec)
18:46 jcamins_away Use SELECT MAX(barcode)
18:47 I should mention- if you're *lucky* that barcode exists.
18:48 If you're not lucky, I suggest going through the database's pockets and looking for loose change.
18:48 pastebot "nengard" at 127.0.0.1 pasted "i bet the one that is 20 char in length is the problem" (20 lines) at http://paste.koha-community.org/143
18:48 wizzyrea the last time I tried to get a max barcode, I got "SPECIAL ITEM NO BARCODE" as the result (or something like)
18:49 not helpful ;)
18:49 jcamins_away wizzyrea: sounds about right.
18:49 nengard i did the max thing and got a number that was not long at all
18:49 pastebot "nengard" at 127.0.0.1 pasted "thing i found the culprit" (9 lines) at http://paste.koha-community.org/144
18:49 wizzyrea then I limited to branch and that was much nicer.
18:49 oleonard wizzyrea: Sounds like my staff, who like to put in the phone number field "No phone"
18:50 jcamins_away http://git.koha-community.org/[…]a14a0;hb=HEAD#l95
18:50 wizzyrea argle bargle bargle blarg
18:50 jcamins_away nengard: ^^ the offending code.
18:50 Try MAX(ABS(barcode))
18:51 * jcamins_away notes this is why Excel is evil.
18:52 wajasu drojf: i think you mentioned being interested in my postfix email client setup. so I've pasted some config for reference.
18:52 pastebot "wajasu" at 127.0.0.1 pasted "notes for configuring "null" email client for koha outgoing email" (345 lines) at http://paste.koha-community.org/145
18:53 nengard fixed it :)
18:53 it was that 20 character barcode
18:53 * oleonard thanks jcamins_away for pointing out that "argle bargle bargle blarg" is offending code
18:53 drojf wow. thanks wajasu
18:54 wajasu it worked with my bug 8378 patch, which hopefully gets sign off
18:54 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8378 critical, P5 - low, ---, koha-bugs, Needs Signoff , <fine> syntax not working on overdues anymore
19:00 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:00 jcamins_away Odd.
19:01 I'll run the linker against my database again when I'm looking at authority linking next.
19:02 * gmcharlt has a guess - checks something to confirm
19:02 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:02
19:03 I also, got fitnesee running to call groovy based fixtures. So we could have non-programmers write tests in fitnesse web pages.
19:04 then use fitnesse to verify that database row entries are correct in the backend.
19:05 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:07 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:12 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:13 jcamins_away wajasu: that only works as well as your users' motivation to write tests.
19:16 gaetan_B joined #koha
19:17 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:18 brylie joined #koha
19:21 jcamins_away wajasu: true.
19:27 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:32 rangi Morning
19:32 oleonard Hi rangi
19:33 rangi @wunder nzwn
19:33 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:33 rangi Spring
19:40 Hmm Jenkins still angry
19:40 Better sooth him soon
19:40 Or he will go postal
19:42 * wizzyrea read that "better scotch him soon"
19:42 wizzyrea yes, give him booze. that makes all butlers happy
19:44 rangi Hehe
19:57 Ok my stop bbiab
20:09 kathryn joined #koha
20:11 oleonard Bye #koha
20:22 rangi back
20:23 wajasu rangi: to prevent repeating myself.  http://irc.koha-community.org/[…]2-08-28#i_1061550
20:25 rangi cool
20:55 mbalmer joined #koha
21:02 pastebot "wajasu" at 127.0.0.1 pasted "using geb-spock to test koha gui using firefox" (112 lines) at http://paste.koha-community.org/146
21:03 jcamins_away wajasu: don't suppose we could use Perl with that?
21:04 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:06 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:07 jcamins_away wajasu: but people need to use the wiki to write Python?
21:10 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:16 * jcamins_away leaves
21:16 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:39 caitst joined #koha
21:44 cait-m__ joined #koha
22:08 jenkins_koha Starting build #144 for job Koha_3.8.x (previous build: SUCCESS)
22:14 NateC left #koha
22:14 NateC joined #koha
22:15 Ccorrales joined #koha
22:27 maximep left #koha
22:46 jcamins_away wajasu: exactly. It's the complete stack that needs testing.
22:46 rambutan joined #koha
23:11 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:11 julian.maurice: Bug 8495: Fix JS error when creating a new order
23:11 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8495 blocker, P5 - low, ---, julian.maurice, Pushed to Stable , Javascript error when creating a new order
23:18 rambutan left #koha

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

koha1