IRC log for #koha, 2011-08-07

← Previous day | Today | Search | Index

All times shown according to UTC.

Time Nick Message
00:50 davidnind left #koha
00:52 jcamins_away Yowch!
00:52 I just had the tiniest drop of harissa, and my entire mouth is on fire.
00:53 wizzyrea yikes
00:54 jcamins_away I'll start with an eighth of a teaspoon for my amazing Moroccan-style dal. :)
00:55 * druthb waves to wizzyrea
00:56 jcamins_away wizzyrea: all your references to Doctor Who inspired me to start watching it on Netflix.
00:56 wizzyrea do you like it?
00:57 jcamins_away I do.
00:57 druthb wahanui: wizzyrea?
00:57 wahanui druthb: bugger all, i dunno
00:57 jcamins_away It's kind of absurd, but a lot of fun.
00:57 druthb !
00:57 wizzyrea oh it's completely absurd
00:57 but awesome. :)
00:58 * wizzyrea waves at druthb
00:58 wizzyrea hiyas :)
00:58 * druthb wriggles happily
00:58 wizzyrea i'm just happy you can still wriggle. :)
00:58 druthb :)  me too
00:59 big progress last night--no pain meds needed to sleep!
00:59 wizzyrea nice!
01:05 jcamins_away Well, I'm not sure that Shari's going to want to help eat this, but that's okay- I'm not sure I want to share.
01:05 druthb :)
01:07 jcamins_away Dal with garlic, harissa, lemon juice, and avocado oil = delicious.
01:07 wizzyrea yum
01:40 * druthb heads to bed.
02:04 wizzyrea jcamins_away:
02:04 http://www.flickr.com/photos/b[…]o/in/photostream/
02:05 since you're a new whovian. :)
02:05 jcamins_away :)
02:05 Thanks.
02:06 Oops, I think I missed 30 years of the show.
02:06 wizzyrea :D
02:34 libsysguy joined #koha
02:34 libsysguy #Koha I need halp
02:35 * wizzyrea perks up
02:35 wizzyrea no guarantees tho :P
02:35 BrookeenTauride joined #koha
02:35 BrookeenTauride kia ora
02:35 wizzyrea kia ora BrookeenTauride
02:35 libsysguy so im modifying the import patrons script to work with the shell
02:35 and i am getting a mysql error
02:36 Database returned the following error: Cannot add or update a child row: a foreign key constraint fails (`koha`.`borrower_attributes`, CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /home/koha/kohaclone/C4/Members/Attributes.pm line 207, <$uploadborrowers> line 29.
02:36 DBD::mysql::st execute failed: Duplicate entry '5000006191' for key 'cardnumber' at /home/koha/kohaclone/C4/SQLHelper.pm line 147, <$uploadborrowers> line 30.
02:36 DBD::mysql::st execute failed: Duplicate entry '5000006196' for key 'cardnumber' at /home/koha/kohaclone/C4/SQLHelper.pm line 147, <$uploadborrowers> line 31.
02:36 DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`borrower_attributes`, CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /home/koha/kohaclone/C4/Members/Attributes.pm line 205, <$uploadborrowers> line 31.
02:36 sorry...I should have used paste bot for that
02:36 jcamins_away Yah, try again w/pastebot? I can't see it all in one screen.
02:37 libsysguy do i just do @pastebot?
02:37 i've never used it
02:37 wizzyrea paste.koha-community.org
02:37 jcamins_away libsysguy: no, just paste it in at paste.koha-community.org.
02:38 BrookeenTauride joined #koha
02:39 libsysguy http://paste.koha-community.or[…]bmit=Format+it%21
02:40 jcamins_away libsysguy: do you have duplicate card numbers in your file?
02:40 libsysguy there are duplicates in the database
02:40 but i have update turned on
02:40 jcamins_away I suspect the problem is it's trying to add instead of update.
02:40 Change it to match on card number?
02:41 wahanui jcamins_away: that doesn't look right
02:41 wahanui joined #koha
02:41 jcamins_away Change?
02:41 wahanui rumour has it Change is quite new
02:41 libsysguy ohh i think i have a case error
02:41 jcamins_away Change it?
02:41 wahanui jcamins_away: that doesn't look right
02:41 wahanui joined #koha
02:41 jcamins_away Change me?
02:41 wahanui jcamins_away: that doesn't look right
02:41 jcamins_away Oops.
02:41 wizzyrea lol
02:41 jcamins_away I killed him.
02:41 wizzyrea he's gone for good now
02:41 poor lil fella
02:41 libsysguy haha
02:42 aww wahanui is always so left out
02:42 jcamins_away @later tell rangi I accidentally killed wahanui. Could you give him a kick when you get the chance?
02:42 huginn jcamins_away: The operation succeeded.
02:42 BrookeenTauride don't feel sorry for waha, he was bad people then, he got his due now XD
02:42 libsysguy yeah that fixed it
02:42 jcamins_away Yay!
02:42 libsysguy kind of...i mean i have errors still :p
02:42 yeah i had the c in cardnumber uppercased
02:43 silly me
02:43 BrookeenTauride naughty libsysguy
02:44 wahanui joined #koha
02:44 jcamins_away rangi++
02:46 libsysguy ok so im a regex newb
02:46 can anybody tell me what this does /\S/
02:47 jcamins_away Not whitespace?
02:47 libsysguy i think it is not...
02:47 yeah
02:47 that
02:47 ok i just wanted to verify
02:48 * jcamins_away goes to claim experience on chorewars.
02:48 wizzyrea hehe
03:14 libsysguy w00t...modded that import patrons script to work on the shell
03:14 well..kinda
03:14 i mean its a new script
03:14 but it works
03:14 jcamins_away libsysguy: you should submit it.
03:14 wizzyrea nice
03:14 libsysguy i think i am going to try and merge them before i submit jcamins_away
03:16 wizzyrea libsysguy: in celebration, you can get down with this: http://www.youtube.com/watch?v=CMNDdnYOjWw
03:18 libsysguy: also, remember that the perfect is the enemy of the good ;)
03:20 jcamins_away wizzyrea: why did you have the link for that handy?
03:20 wizzyrea because I just found it :)
03:21 I think the guy on the bottom row, 2nd from the right, he reminds me vaguely of reed.
03:23 jcamins_away I never met Reed.
03:23 libsysguy jcamins_away: thats awesome
03:24 jcamins_away libsysguy: it's wizzyrea's link.
03:26 eythian http://www.tofugu.com/2011/07/[…]l-together-oh-yes <-- this. this is coding music.
03:26 libsysguy do you guys know how i could pull a list of all patrons in a script
03:26 i was going to use Member.pm
03:26 and get Member
03:27 but i didn't know if there was a better way
03:27 eythian It's probably the best way
03:27 It's good to not touch the database directly unless you can't avoid it.
03:27 libsysguy right...that is what I was trying to avoid
03:28 i just want to get them all and not pass GetMember anything
03:28 so maybe i can
03:29 eythian Not sure if that'll work or not, it might.
03:29 It probably should.
03:29 libsysguy i was looking at the sql and the where clause is listed in the select...anyway...ill try it and see where i get
03:35 eythian: just for the record...that doesn't work
03:36 eythian ah well
03:40 libsysguy i thought I could be clever and way where 1=1
03:40 but i don't know if i can make it work
03:44 libsysguy left #koha
06:01 cait joined #koha
06:01 cait hi #koha
06:03 eythian hi cait
06:04 cait hi robin
06:04 it's still sunday for you, isn't it?
06:04 eythian yep
06:04 but got a go-live on Tuesday, so I'm clearing out all the issues that aren't directly related to the final process.
06:10 cait busy
06:10 I am trying to learn how to multiplicate binary numbers
06:11 for my new distance study course...
06:11 eythian that's nice and easy, once you realise what's going on.
06:11 cait yeah, the problem is, he asks for it in the tasks, but he doesn't explain it
06:11 looking for a website now that can teach me
06:12 eythian ah. I used to teach it, but it's been a long while now
06:12 cait it's ok - I will find out
06:12 but it worries me a little that the first chapter already has something like that
06:13 looks like I will need a lot of additional materials to the book
06:13 eythian just do it like you do decimal long multiplication
06:13 http://www.binarymath.info/mul[…]tion-division.php
06:13 cait ah thx :)
06:13 eythian it's easier though because there's only two digits to worry about combining.
07:17 bigbrovar joined #koha
07:42 cait @wunder Konstanz
07:42 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 17.3°C (9:40 AM CEST on August 07, 2011). Conditions: Rain. Humidity: 92%. Dew Point: 16.0°C. Pressure: 29.77 in 1008.0 hPa (Steady).
08:10 rangi evening
08:11 cait hi rangi
08:12 rangi heya cait, hows the weekend going?
08:13 cait busy and rainy :)
08:13 how was yours?
08:14 rangi got hailed on today, but good other than that
08:15 cait hailed on?
08:18 rangi yep
08:18 http://en.wikipedia.org/wiki/Hail
08:19 cait oh
08:19 hagel
08:19 ouch
09:21 rangi http://www.packtpub.com/open-source-awards-home
10:16 druthb joined #koha
10:37 rangi man, im too old for this
10:38 cait hm?
10:39 rangi koha-devel
10:39 wahanui koha-devel is probably the best list
10:46 cait hmpf
10:58 rangi right time for sleep
10:59 cait good night rangi

← Previous day | Today | Search | Index

koha1