Time Nick Message
00:37 dcook eythian: around for a quick question about packages?
00:37 dcook Actually...
00:38 eythian dcook: si
00:38 dcook Nevermind
00:38 dcook Thanks anyway :)
00:38 eythian happy to have helped.
00:41 dcook You know your keyboard has seen better days when the up arrow jumps out and onto your desk in protest...
00:42 dcook I didn't know huginn could do PM reminders...
00:42 dcook Or did huginn just come up...
00:42 eythian haha
00:42 eythian PM reminders?
00:42 eythian https://twitter.com/BrandsSayingBae <-- "Bæ/bae is a Danish word for poop. Also used by people on the internet who think it means baby, sweetie etc."
00:43 eythian it should really be muninn that does reminders.
00:58 dcook hehe
00:58 dcook Yeah, I used to think that about muninn as well
00:58 dcook I think huginn must've been down until that big upheaval and I just got my reminder really late
00:59 wizzyrea eythian++ for excellent facts about language
01:02 wizzyrea also, fun fact, it means good bye in icelandic.
01:03 eythian also english, roughly
01:03 wizzyrea sorta kinda.
01:03 wizzyrea I don't think I'd ever spell "bye" that way
01:04 wizzyrea now bye looks weird to me.
01:08 dcook By the by... it must be annoying to learn English
01:08 dcook By, bye, bi
01:08 dcook Oh God, this is a... *insert boyband name* song
01:09 wizzyrea Buffalo buffalo buffalo... and so on.
01:09 dcook Buffalo buffalo buffalo... is just plain awesome though :p
01:09 wizzyrea hehe
01:10 eythian https://www.youtube.com/watch?v=hTdhXxxWREo <-- not a boyband
01:10 dcook :D
01:52 dcook http://www.zdnet.com/article/microsoft-is-building-a-new-browser-as-part-of-its-windows-10-push/ <-- Great... another browser to support...
01:53 eythian oh dear
02:00 rangi @later tell tcohen working on a fix for the issue with the failing tests introduced by the db change
02:00 huginn rangi: The operation succeeded.
02:02 eythian http://youtu.be/rtR63-ecUNo
02:05 eythian @wunder nzwn
02:05 huginn eythian: The current temperature in Wellington, New Zealand is 22.0°C (2:30 PM NZDT on December 30, 2014). Conditions: Mostly Cloudy. Humidity: 64%. Dew Point: 15.0°C. Pressure: 30.04 in 1017 hPa (Falling).
02:11 pastebot "rangi" at 127.0.0.1 pasted "ten points if you can spot the problem here" (30 lines) at http://paste.koha-community.org/331
02:18 dcook Is this a trick question, rangi?
02:18 rangi nope
02:23 dcook Hmm
02:23 dcook I'm wondering what inputs they're getting in all the cases where the result is different
02:23 dcook The only thing that really looks different is that "if ($borrowernumber);"
02:23 rangi look at the order of the tenary
02:24 dcook Looks all right, no?
02:24 rangi nope
02:24 dcook Although..
02:24 wahanui although is mine 2.3.2 or 2.3.3
02:24 rangi if $count = 1 return 0
02:24 dcook Yeah
02:25 rangi well if $count return 0
02:25 dcook ( $uid ne '' ) && ( my $row = $sth->fetchrow_hashref ){ return 0 }
02:25 dcook Although I can't remember what happens there if you do/do not have a row..
02:25 rangi the wrong thing
02:25 dcook Had a feeling that might be it
02:26 rangi basically it is returning 0, when it should return 1
02:26 dcook That'll do it
02:27 dcook I imagine "my $row = $sth->fetchrow_hashref" returns true no matter what?
02:27 rangi not sure, just the old version worked, the new one, not so much
02:27 dcook :/
02:28 dcook Haven't looked at Check_Userid in ages, what does that one do again?
02:28 dcook Is it for checking userid for new members or as part of auth?
02:28 rangi tests if a user id is unique
02:28 rangi does it when you add a borrower etc
02:28 dcook Mmm, thought that might be it
02:28 dcook What's the borrowernumber?
02:28 rangi bug 1861 made a unique constraint ont he db
02:28 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1861 normal, P4, ---, kyle, ASSIGNED , Unique patrons logins not (totally) enforced
02:29 dcook Or rather whose borrowernumber is it? :S
02:29 rangi and changed this code
02:29 dcook Mmm
02:29 rangi now 25 tests are failing
02:29 dcook Yeah I saw the test failing part :(
02:30 rangi $data{'userid'} = Generate_Userid( $data{'borrowernumber'}, $data{'firstname'}, $data{'surname'} )
02:30 rangi if ( $data{'userid'} eq '' || Check_Userid( $data{'userid'} ) );
02:30 rangi thats pretty broken
02:31 rangi if your userid is unique
02:31 rangi lets throw it away and make a new one
02:31 rangi bzzt
02:31 rangi wrong
02:31 rangi no wonder the tests are failing they try to add a borrower with a userid they know
02:32 rangi - $data{'userid'} = Generate_Userid($data{'borrowernumber'}, $data{'firstname'}, $data{'surname'}) if $data{'userid'} eq '';
02:32 rangi + $data{'userid'} = Generate_Userid( $data{'borrowernumber'}, $data{'firstname'}, $data{'surname'} )
02:32 rangi + if ( $data{'userid'} eq '' || Check_Userid( $data{'userid'} ) );
02:32 rangi *sigh*
02:34 rangi basically that should be ! Check_Userid
02:34 rangi and it then works
02:35 dcook Hmm..
02:36 rangi Check_Userid returns 1 for unique
02:36 rangi 0 if its not
02:36 dcook Yeah
02:36 dcook So "return $count ? 0 : 1;" should be ok, no?
02:36 rangi well either its wrong
02:36 rangi or that or is wrong
02:36 dcook Since "return 0 if ( $uid eq C4::Context->config('user') );" would mean the userid is the same as the db user
02:37 rangi basically they are both expecting contradictory behaviour
02:37 dcook Sounds like it
02:37 wahanui Sounds like it is beer o'clock for you dcook? ;)
02:37 dcook :D
02:37 rangi ill change the AddMember and hope its the only place that is wrong
02:38 dcook Hmm ! Check_Userid doesn't look like it would be right though..
02:42 rangi why not?
02:43 dcook Ah wait..
02:43 dcook Right right
02:43 dcook Since if you get a 0, you want a new userid..
02:43 rangi @later tcohen please take a look at the last patch on bug 1861
02:43 huginn rangi: I'll give you the answer just as soon as RDA is ready
02:43 rangi @later tell tcohen please take a look at the last patch on bug 1861
02:43 huginn rangi: The operation succeeded.
02:43 dcook Check_Userid is a hell of a function name..
02:43 rangi yeah, if its not unique, make a new one
02:43 rangi yeah its dumb
02:43 rangi is_userid_unique
02:44 rangi is better
02:44 rangi or unique_userid
02:44 rangi if ! unique_userid(blah)
02:44 dcook totes
02:44 rangi but since half arsed refactoring is what broke this
02:44 rangi im not about to start doing more :)
02:44 dcook Fair enough :)
02:45 dcook I certainly hear that
03:10 eythian OK, after far too long I've finally figured out how to alias repo names (e.g. "stable" to "squeeze") without warnings showing up.
03:11 rangi :)
03:12 dcook \o/
03:17 dcook eythian++
03:18 eythian turned out to be surprisingly easy, once you've waded through a fair bit of documentation
03:20 dcook Reminds me of more than a few things ;)
03:21 dcook Yay for documentation!
05:02 mtompset @seen eythian
05:02 huginn mtompset: eythian was last seen in #koha 1 hour, 44 minutes, and 37 seconds ago: <eythian> turned out to be surprisingly easy, once you've waded through a fair bit of documentation
05:03 eythian I'm still here if you're quick
05:04 mtompset Just curious why you turned the other repo possibilitiesinto blue boxes in the ubuntu wiki.
05:04 mtompset It's confusing for a person who doesn't understand repos.
05:04 eythian I don't understand the question
05:05 mtompset I'll just revert your changes then.
05:05 eythian what changes?
05:05 wahanui changes are written to the database, but Koha doesn't seem to pick it up...
05:05 mtompset http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
05:06 eythian oh
05:06 eythian that was an error
05:06 mtompset the add koha community repo section now has three blue boxes for the adding repo, instead of just the one.
05:06 eythian oh wait
05:06 eythian on moment
05:06 eythian +e
05:06 dcook blue boxes?
05:07 mtompset The commands were there before, but purposefully not formatted.
05:07 mtompset code boxes show up as blue on my browser.
05:07 dcook So that people don't accidentally add them?
05:07 mtompset EXACTLY.
05:07 eythian ah
05:07 dcook Seems reasonable... the caps less so :p
05:07 eythian yeah, revert that if you like
05:07 mtompset Sorry. Just a little passionate.
05:08 eythian I was making something cleaner, but that got caught up in it I think.
05:08 mtompset Though, I was thinking, since you added/renamed and added aliases... we should remove reference to squeeze.
05:08 eythian sure
05:08 * dcook is wondering how he can finish his donuts, crackers, and sandwiches in the next 50 minutes...
05:08 dcook While also typing up a storm
05:08 mtompset And that's why I just sent you an email about perhaps squeeze-dev being something other than 'unstable'..
05:08 * dcook needs an extra set of hands..
05:09 mtompset (or in addition to being unstable)
05:09 mtompset eythian: You don't like <pre>? :)
05:10 mtompset I like explicitness. :)
05:10 eythian it's icky to read in source, and it requires noisy markup to get a multiline entry.
05:12 eythian it's unstable because that's what it is
05:12 eythian it's expected to change a lot, which is what stable means in the debian context.
05:13 mtompset But Jessie is testing, and sid is experimental, aren't they?
05:14 eythian no, jessie is testing, sid is unstable
05:14 mtompset Oh, just read your email reply. :)
05:14 mtompset So our master is unstable?!
05:15 mtompset Considering the QA process to get something in there, I would think it is more testing than unstable.
05:15 eythian sure it is, it changes most days
05:16 eythian stable
05:16 eythian 2: firm and dependable; subject to little fluctuation; "the
05:16 eythian economy is stable"
05:16 eythian it's not that, by design
05:17 mtompset consider a person unfamiliar with geek talk, unstable is going to sound bad.
05:17 dcook If they're unfamiliar with geek talk, they shouldn't be using unstable :)
05:17 eythian yes.
05:17 eythian that
05:19 mtompset Just trying to keep the technical bar low, so that people aren't afraid to join the coding community. :P
05:21 eythian I sorta think that having some consistency is good. Now our naming matches the parts of debian that they are closest to.
05:31 mtompset Oops... silly internet connection.
05:31 mtompset I suppose
05:31 mtompset I should get sleep.
05:31 mtompset Have a great day, #koha.
05:32 * eythian leaves also.
05:32 eythian bye
07:39 reiveune hello
07:39 wahanui what's up, reiveune
07:57 alex_a bonjour
07:57 wahanui salut, alex_a
08:10 cait good morning #koha
08:11 ashimema morning cait
08:11 * ashimema is a tad embarrassed that he missed a pretty epic bug in a auth patch he qa'd
08:12 Joubu hello #koha
08:12 cait hi Joubu
08:12 cait nice that it's not totally empty here these days
08:13 cait ashimema: I am embarassed too - but it happens
08:13 * cait sends cookies
08:13 cait i tested it too, remember? :)
08:14 ashimema yup
08:14 ashimema what it teaches me is that I really need to sort out tests on this system..
08:14 ashimema a huge number fail for me every time I run then..
08:15 ashimema and thus it kinda becomes pointless
08:15 cait the problem is that i don't have a clean database really... intentionally because the data is good for testing
08:15 cait but it means a lot of the db dependent tests are failing
08:16 ashimema that's my issue exactly too
08:16 ashimema our db_dependant tests really really should be database agnostic
08:16 ashimema i.e. they should all create and destroy ALL data they need to run the test.
08:17 gaetan_B hello
08:19 ashimema @wunder stevenage, uk
08:19 huginn ashimema: The current temperature in Pin Green, Stevenage, United Kingdom is -1.1°C (8:10 AM GMT on December 30, 2014). Conditions: Clear. Humidity: 94%. Dew Point: -2.0°C. Windchill: -1.0°C. Pressure: 30.69 in 1039 hPa (Steady).
08:22 Joubu ashimema: I always point out this patch, but you can create a DB with the script provided on bug 10337
08:22 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10337 enhancement, P5 - low, ---, jonathan.druart, In Discussion , UT: The unit tests cannot be launched by everyone
08:23 Joubu ashimema: I have 2 DB, the one to test the patch using koha, and the one for the "unit" tests, I switch the db name in koha-conf when needed
08:23 ashimema indeed Joubu..
08:23 ashimema having two db's is a pretty good work around actually..
08:24 Joubu especially because I test on an UNIMARC DB and the tests need a MARC21 DB...
08:24 fridolin hie all
08:24 rangi i have about 8 :)
08:24 cait could there be a script to do the switch?
08:25 * cait is lazy
08:25 ashimema thanks for spotting that rangi, and coming up with a patch so quick.
08:25 Joubu rangi: yes, I have 5 or 6 too, but I always use the same for tests
08:25 cait also i tend to mess up things too much :)
08:25 rangi its just export KOHA_CONF= different/koha-conf.xml
08:25 cait rangi: ooh
08:25 rangi i toggle between unimarc and marc21 for testing
08:25 ashimema can't believe I missed it.. so obvious now you've pointed it out :(
08:25 Joubu and it's the one created by the script on 10337
08:25 cait i didn't htink of doubling up the koha-conf
08:25 rangi both with only sample data in
08:26 cait i have a unimarc installation too, but right now it's totally separate - even another git clone
08:26 rangi you can even write a small .sh
08:26 rangi #!/bin/sh
08:26 rangi export KOHA_CONF
08:26 rangi run tests
08:26 rangi export other one
08:26 rangi run tests
08:26 rangi now its been tested in marc21 and unimarc
08:27 rangi or
08:27 rangi you can use magnuse kohadevbox
08:27 rangi and have 2 vagrant instances
08:27 ashimema don't tihnk I'de seen 10337 before
08:27 rangi one for each
08:27 ashimema or maybe I had but forgotten about it.
08:28 rangi thats handy for UAT too
08:28 cait UAT?
08:28 ashimema I was in fact tihnking of using the vagrant box as a new qa machine
08:28 ashimema at the moment I just use my main dev system directly
08:28 rangi user acceptance testing
08:29 rangi yeah i use that for dev
08:29 rangi but use 'clean' ones for testing
08:30 cait for automatic testing or in general?
08:30 rangi both
08:31 rangi if im gonna sign off, i switch to my clean repo and sample db database
08:31 cait for things like acq i find a clean database not so helpful
08:31 cait you have to set up a lot of stuff and it gets more interesting once you have longer lists and more different data
08:31 * ashimema goes away to grab a second db and impliment rangi and joubu's suggestions
08:31 cait well interesting = you see more of the problematic things easier
08:32 rangi you can always test on both
08:32 rangi but stuff should work on a fresh install
08:32 rangi not just a populated one too
08:32 * ashimema has been thinking for a while that we should be using https://metacpan.org/pod/DBIx::Class::Fixtures
08:32 cait that's true - but setting up funds and stuff takes a lot of time
08:32 rangi yep
08:32 cait and i think some of the tests fail once you have raeally basic data
08:32 rangi they should all pass with the sample data
08:32 rangi thats the rul
08:32 rangi e
08:33 rangi if they dont, then they need to be fixed
08:33 cait yeah but we have no acq sample data :)
08:33 Joubu they pass
08:33 Joubu cait: yes, that why we need to create all data before testing
08:33 rangi id like to do some more www::mechanize tests
08:33 rangi that would have caught this bug too
08:33 rangi because it would have seen the userid put in, is not what came back out
08:34 cait makes sense
08:34 rangi those are harder tho, because you need a running webserver
08:34 * cait feels a bit lazy now... but i don't want to double the time for testing each time :(
08:35 cait but i will try to run the db_dependent tests on a sample database in future
08:36 Joubu it's really easy with the patch I proposed
08:50 ashimema cait..
08:50 ashimema your followup to 5511 doesn't apply?
08:51 cait hm
08:51 cait let me see
08:52 ashimema leaves me in a 'wierd' git state..
08:52 cait strange
08:52 ashimema mmm.. it's a simple patch.. can't see why it wouldn't apply
08:52 cait me neither
08:53 ashimema i get the usual.. 'fatal: sha1 information is lacking or useless'
08:53 ashimema for updatedatabase.pl..
08:53 cait huh
08:53 ashimema but then it drops out without giving me a file with merge conflicts to sort out..
08:53 cait don't have a master at hand right now to test :(
08:54 ashimema rangi... always wondered why that happens on occasions and wondered if you had any advice.
08:55 cait wonder if updatedatabase changed since i tested?
08:55 cait tcohen pushed in between
08:55 ashimema possibly..
08:55 ashimema but I would have though it be the patch before that fails rather than yours ;)
08:56 Joubu ashimema: it fails here too, but you can try to apply --reject
08:56 cait hm i moved it around quite a bit
08:56 cait it was in a weird spot
08:57 ashimema ooh..
08:57 ashimema --reject
08:57 ashimema never used that
08:57 cait how does it work?
08:57 rangi i usually just --abort
08:58 ashimema indeed.. and abort gets me back to a working tree..
08:58 ashimema but I wanted to know if there's any way to save the apply ;) i.e. sort out the merge conflicts..
08:59 ashimema I'de have tought git would be able to dump me out with a conflicte file as per usual which I could sort out with mergetool..
08:59 ashimema never worked out why sometimes it fails to do that
09:00 rangi ah yeah reject will make *.rej files for the bits taht fail
09:00 ashimema ooh.
09:00 rangi and applies the bits it can
09:00 Joubu yep, very useful in some cases
09:00 cait ah
09:00 rangi often its best/easiest to just get the person to rebase tho if they can, but if they cant reject is handy
09:00 cait and then you have to only fix the one file and git ament?
09:00 cait amend
09:00 rangi yep
09:00 Joubu especially where there is a sha1 information lacking or useless
09:01 rangi Joubu: http://blog.bigballofwax.co.nz/2014/12/30/2014-and-koha-by-the-numbers/
09:01 ashimema how do I reject then..
09:01 ashimema 'git bz apply --reject' isn't an option?
09:01 cait how do you run it? with the git am when it fails the first time?
09:01 ashimema 'git am --reject' also failed for me.
09:02 Joubu rangi: wahou nice :)
09:02 rangi it saves a copy of the patch in /tmp
09:02 Joubu ashimema: no git apply --reject
09:02 Joubu not git bz
09:02 ashimema ahh..
09:02 ashimema thanks
09:02 rangi git apply --reject /tmp/the_patch
09:02 Joubu you have to git bz apply --skip
09:02 ashimema that's better, it's actually doing somtihng now..
09:02 cait Joubu: congrats on author of the year :)
09:02 Joubu and then git apply --reject /tmp/the_file_created_by_git_bz.patch
09:02 ashimema thanks Joubu.. a new command to add to my git repetior
09:03 ashimema ooh.. rangi your block looks different
09:05 Joubu rangi: It seems that the numbers are not the same as on the dashboard
09:06 cait hm think he added the failed
09:06 Joubu rangi: the total are good, but the not the individuals. For instance, I PQA 263 on the dashboard and 336 on your blog, where does come from this number?
09:06 Joubu ha yes, makes sense!
09:07 ashimema I'm gonna set 1861 back to passed qa (skipping signoff) if that's ok with peeps.. rangi's change is a single character fix
09:07 ashimema then I'll push it onto my module branch
09:07 Joubu 87 authors, that a great number :)
09:07 ashimema yeah.. those stats are brill
09:08 ashimema ooh.. joubu beat me.
09:08 cait yeah :)
09:08 cait Joubu++
09:09 ashimema and he added a unit test..
09:09 ashimema even better.. Joubu++
09:09 rangi Joubu: you failed some too
09:10 rangi passed + failed = number qaed
09:10 cait hm i am failing about 25%
09:12 cait hope a lot of those still made it in
09:14 cait hm but maybe not only me looking at the stats
09:14 rangi most of them are the same bug, it fails, then it passes
09:15 rangi but you have to test it each time
09:15 rangi so i count that
09:15 cait yeah 'zombie bugs' coming back at you :)
09:17 Joubu rangi: it could be good to add the number of new devs
09:18 rangi hmm yep i can do that
09:20 rangi 34
09:21 cait very cool
09:22 cait ashimema: thx for fixing the follow-up
09:22 Joubu I have just compared with http://blog.bigballofwax.co.nz/2012/12/17/2012-and-koha-by-the-numbers/ and the numbers are very closed
09:22 Joubu 2250 vs 2225 commits
09:22 cait rangi: why is the person with most sign offs missing? ;)
09:22 Joubu 84 dev vs 85
09:23 rangi yeah we are pretty consistent
09:23 Joubu 33 new dev bd 34
09:23 Joubu s/bd/vs
09:23 cait hm could we see a enh/new vs. bugs stat?
09:23 rangi 2013 was similar
09:23 cait guess i can look that up in release notes :)
09:23 rangi more commits
09:24 rangi but around the same number of devs
09:24 rangi actually 91 in 2013
09:24 JesseDhammu koha in the blind koha in the blind
09:24 cait btw - coworker testing 3.18 - filing tickets for me while we speak )
09:24 JesseDhammu Cait are you there ..?
09:24 cait mostly translation things for now
09:24 cait and some old things
09:25 rangi in 2013 we got more new devs at the hackfest than in 2014 that helped jump the number
09:25 cait he just brought up bug 4041 again
09:25 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4041 enhancement, P5 - low, ---, koha-bugs, NEW , Address Format as a I18N/L10N system preference
09:26 ashimema rangi.. did you look at bug 12954 at all?
09:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12954 major, P3, ---, abl, Signed Off , Questionable logic regarding session handling in C4::Auth::checkauth()
09:27 ashimema I'm just going through the logic of it now, but wondered if you had any thoughts
09:28 ashimema my feeling is that we probably shouldn't completely nuke the session data upon failed login, rather set the session to anon again, and maintian the anon search history through a bad login attempt
09:29 rangi yeah
09:29 rangi that makes sense
09:29 rangi you know what we should do sometime soon
09:29 rangi count login attempts, and block them after a number of failed ones
09:30 rangi (offtopic but i just remembered that)
09:30 ashimema indeed.. we probably should..
09:30 ashimema I'm also thinking of submitting a non-destructive (i.e don't break lines) tidy of the Auth.pm file.. it's bacome pretty unreadable with indenting all over the shop..
09:31 JesseDhammu hello i need some help with users issues data
09:32 JesseDhammu i have migrated to another koha server,,, and have exported and imported bibliographic records.
09:32 rangi good plan ashimema
09:32 rangi if it doesnt break lines the git diff -w works well
09:32 ashimema that was my thoughts :)
09:33 JesseDhammu but dont have data of issued books to the users.
09:33 JesseDhammu how do i restore that from my old database ..?
09:37 rangi you cant; the id numbers of the items and borrowers will be different
09:37 rangi its better to copy the whole db, and upgrade it
09:42 rangi ok, sleep time for me
09:43 cait night rangi
09:48 JesseDhammu good night rangi , just a small query
09:53 JesseDhammu cait: do you remember the problem which i explained yesterday
09:53 JesseDhammu about the database upgradation faliure ..
09:54 JesseDhammu i still have that issue
09:54 cait JesseDhammu: rangi is right, it's too complicated to explain that here
09:54 JesseDhammu no i understand why he is saying that ..
09:54 JesseDhammu but my issue is i can not import the whole sql dump
09:54 cait there is too much involved, your best bet would probably doing it manually
09:54 JesseDhammu ok ..
09:55 cait it's possible... but not easily and what we can do here is limitted
09:55 JesseDhammu and by mannually you mean i should export the list of books from old database,, and re issue them using circulation module after identifying the book names and patrons ..??
09:55 JesseDhammu what about the main problem ..
09:56 JesseDhammu my koha upgrade script failed on the main server..
09:56 JesseDhammu thats why this all is happening ...
09:56 JesseDhammu http://paste.koha-community.org/328
09:56 JesseDhammu this is the error i am facing after installing the updates..
10:03 JesseDhammu and one more thing .. which are the two tables where information about issued books is stored .??
10:03 JesseDhammu one is issues table that im sure
10:03 JesseDhammu which is the other one ..?
10:06 cait JesseDhammu: issues stores all the information about the issued books
10:07 JesseDhammu only one table ..??
10:08 Joubu and old_issues
10:08 JesseDhammu i dont want old issued records..
10:08 JesseDhammu i just need the current data ...
10:08 cait then it's only one table.
10:09 cait it has the itemnumber, borrowernumber, due date
10:14 JesseDhammu ok .. so, when i imported only the bibliographic records on a fresh koha server, it will import the biblio data, but will assign item numbers acording to its own
10:14 JesseDhammu and according to you, the old issues table will have the old scheme of item numbers..
10:15 JesseDhammu and thats why it wont work if i just export and import only one table ..
10:15 JesseDhammu is that what are yo saying ..??
10:15 cait correct
10:15 JesseDhammu ok i got it ...
10:15 cait you'd have to get the new numbers for each, borrower and item
10:16 JesseDhammu see i have only 199 books circulated that i could see from the old issues table .. .
10:17 JesseDhammu so if i use Excel Vlookup, or any other probrame.. and replace the old item numbers with the new item numbers, (sort of modifying the issues table data), and then import that modified issues table to the new database would it work ..??
10:19 cait it kind of would probably
10:21 JesseDhammu let me try
10:21 JesseDhammu i would update you
10:23 JesseDhammu by that time can you please check the upgrade issue which is the mother of all this hell ...
10:24 JesseDhammu http://paste.koha-community.org/328
10:24 JesseDhammu here is the error log
10:25 cait thre s also an on_loan field in the items tabel
10:25 cait loading it via sql is more dangerous then doing it manually
10:25 cait and if you change data in the items tabel you need to do a full reindex
10:26 JesseDhammu how do i do that ..??
11:14 JesseDhammu_ cait: i got the details of the books which are issued ..
11:15 JesseDhammu_ so now apart from item number.. i have, the details like, borrower number, borrower name, barcode of the book, title of the book, author of the book, date of issue, due date ..
11:16 JesseDhammu_ would it help now ..??
11:16 JesseDhammu_ cait1: ^
12:38 ashimema Joubu.. fancy commenting on bug 13499
12:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13499 enhancement, P5 - low, ---, gmcharlt, NEW , Auth.pm needs a tidy
12:38 ashimema I'm hoping to make Auth a bit more readable without affecting blame history ;)
12:40 Joubu ashimema: the problem with this king of patches is it will add conflicts for patches already in the queue (NSO, NQA, PQA)
12:41 ashimema true.. I could be pursuaded to do those initial rebases though... I tihnk this would make my life as mm easier as a whole
12:42 ashimema there are 23 bugs affecting Auth.pm at the minute
12:43 ashimema of which, so far most look trivial to rebase should this get pushed
16:05 reiveune bye
16:12 fridolin byebye
16:39 gaetan_B bye !
18:53 rangi morning
18:53 ashimema_ evening
18:53 cait hi rangi
18:56 ashimema_ silly question... did we ever settle on a standard for logging?
18:57 rangi not really, there are couple of interesting patches in the signoff queue to
18:57 rangi tho
18:57 rangi around logging, using cpan modules, and one that builds on that that stops SIP being so verbose in syslog (unless you want it to be)
18:57 ashimema_ bug 8190 being one of them?
18:57 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8190 enhancement, P5 - low, ---, jonathan.druart, In Discussion , Add a logging module to Koha
18:58 rangi i cant test tho, cos they are from catalyst
18:58 rangi theres that one
18:58 ashimema_ ooh.. point me at them?
18:58 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13413
18:58 ashimema_ I'd love to see decent loggin but got lost in the discussions somewhere..
18:58 huginn 04Bug 13413: enhancement, P5 - low, ---, gmcharlt, Needs Signoff , Koha::Log - an attempt to have sane logging in Koha
18:59 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12952
18:59 huginn 04Bug 12952: enhancement, P5 - low, ---, srdjan, Needs Signoff , Log koha actions to syslog too
19:01 jenkins_koha Starting build #22 for job Koha_3.18.x_U14 (previous build: STILL FAILING -- last SUCCESS #19 4 days 23 hr ago)
19:01 rangi http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=13413&attachment=34189 this is the patch i like
19:03 rangi or at lesat the idea i like :)
19:05 ashimema_ cheers rangi..
19:05 ashimema_ i'll do some digging :
19:05 rangi cool
19:10 ashimema_ think I prefer that approach too just looking at it in brief.. will have to comment properly later.. need to go do some painting now
19:11 * ashimema_ is getting a nursery ready :)
19:11 rangi :)
19:13 cait :)
19:13 cait ashimema: which color for the walls?
19:16 jcamins cait: teal.
19:17 cait No tengo ningún gato?
19:17 jcamins I don't have a cat?
19:18 cait made as much sense as teal :)
19:18 rangi teal is a colour cait
19:18 cait i had to look it up... so i made him look up something
19:19 * jcamins actually knew what it meant without looking it up, but looked it up anyway.
19:19 cait ok, was just trying to buy time while looking it up? :)
19:19 jcamins lol
19:19 cait and i am doing my daily duolingo bit right now
19:23 cait @wunder Konstanz
19:23 huginn cait: The current temperature in Konstanz, Germany is -2.0°C (8:00 PM CET on December 30, 2014). Conditions: Snow. Humidity: 96%. Dew Point: -2.0°C. Pressure: 30.63 in 1037 hPa (Rising).
19:23 cait snow... nothing new
20:35 rangi right 17 tests fixed, down to 7 still failing
20:35 * rangi is on the case
20:41 rangi ah ha missed one other corner case
20:41 rangi if ( $data{'userid'} eq '' || !Check_Userid( $data{'userid'} ) );
20:42 rangi that works
20:42 rangi unless $data{'userid'} is undef
20:46 jenkins_koha Starting build #23 for job Koha_3.18.x_U14 (previous build: STILL FAILING -- last SUCCESS #19 5 days 1 hr ago)
20:58 rangi working on a fix for bug 13502 now
20:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13502 normal, P5 - low, ---, koha-bugs, NEW , A bug was introduced by 1861 - meaning borrowers sometimes cant be added
20:58 cait rangi++
21:25 rangi right .. needs signoff now
21:26 eythian hi
22:09 dcook rangi++
22:10 * dcook was wondering a bit about the case where $data{'userid'} would be undef... that's one case where the old version of Check_Userid would probably work while the latter wouldn't..
22:10 rangi yeah
22:50 wnickc @wunder 05048
22:50 huginn wnickc: The current temperature in Quechee Lakes Sec 1, Quechee, Vermont is -8.3°C (5:50 PM EST on December 30, 2014). Conditions: Clear. Humidity: 47%. Dew Point: -18.0°C. Windchill: -8.0°C. Pressure: 30.33 in 1027 hPa (Steady).