IRC log for #koha, 2013-12-18

All times shown according to UTC.

Time S Nick Message
00:00 francharb waited for the bus yesterday evening (45min), I thought I will lost my legs.
00:00 francharb ;)
00:00 dcook -27 with windchill? Ouch..
00:00 dcook Eeep. I'm glad you're ok, francharb!
00:00 francharb thanks! :)
00:01 dcook Growing up in Saskatchewan, I'm quite accustomed to feeling like I'm going to turn to ice
00:01 francharb but I could have wait in the dep' near the bus stop
00:01 dcook When I was a child, all the children would huddle together outside for warmth during recess and lunch
00:01 jcamins Okay, prefix characters are on page 8-1.
00:01 francharb I dont know why I didnt actually...
00:01 dcook You could've grabbed some beer :D
00:01 francharb haha
00:02 ebegin dcook, are you from Vancouver ?
00:02 dcook ebegin: I was born and raised in Saskatchewan, but I lived in Vancouver most recently for a few  years before moving to Sydney, Australia
00:02 ebegin oh, saskatchewan, just read it
00:03 dcook I thought about moving to Montreal for my MLIS but Vancouver had the co-op program that got me my current job working on Koha
00:04 dcook Montreal would've been better for my French though ;)
00:06 dcook Ah, right, I was going to say, you provide services in both English and French, ebegin?
00:07 ebegin yes, both languages
00:10 rsd30 left #koha
00:11 jcamins Asterisk is 042.
00:11 jcamins Just FYI
00:18 rocio left #koha
00:32 francharb diner time
00:32 francharb have a great day dcook
00:33 dcook You too, francharb. It was great catching up :)
00:33 dcook Don't freeze!
00:33 francharb have a good night jcamins
00:33 francharb dcook, thanks
00:34 francharb dcook, say hi to the summer! I miss him/her! ;)
00:34 ebegin bye everyone !
00:37 rambutan joined #koha
00:43 maximep @wunder cyqb
00:43 huginn maximep: The current temperature in Quebec, Quebec is -13.0°C (7:00 PM EST on December 17, 2013). Conditions: Overcast. Humidity: 79%. Dew Point: -16.0°C. Windchill: -22.0°C. Pressure: 30.13 in 1020 hPa (Falling).
00:44 maximep oh, not that bad!
00:45 dcook Just a bit chilly ;)
00:56 maximep left #koha
00:58 eythian wahanui: liblime koha is <reply>I think you mean fauxha, $who
00:58 wahanui ...but liblime koha is based on an older version of Koha, but with a higher version number....
00:58 eythian no wahanui, liblime koha is <reply>I think you mean fauxha, $who
00:58 wahanui okay, eythian.
01:11 nengard joined #koha
01:13 nengard left #koha
04:01 kenan24 joined #koha
05:13 mtompset @seen paul_p
05:13 huginn mtompset: paul_p was last seen in #koha 1 day, 12 hours, 48 minutes, and 52 seconds ago: <paul_p> mtompset yes ?
05:14 mtompset @later tell paul_p 6874 is ready for the final sign off. Hopefully I didn't miss anything. :)
05:14 huginn mtompset: The operation succeeded.
05:48 dcook I love librarians with good ideas
05:48 dcook Just sayin'
06:03 mtompset dcook: What good idea?
06:03 dcook Setting up an RSS feed for the lists
06:08 mtompset Okay... 4 things to attempt to finish before end of year. Maybe.
06:08 mtompset liblime?
06:08 mtompset liblime koha?
06:08 wahanui I think you mean fauxha, mtompset
06:08 mtompset liblime koha?
06:08 wahanui I think you mean fauxha, mtompset
06:08 mtompset no randomness on that. I liked the other line too.
06:09 mtompset @wunder schomberg
06:09 huginn mtompset: The current temperature in Ebhausen, Ebhausen, Germany is 0.8°C (7:00 AM CET on December 18, 2013). Conditions: Mist. Humidity: 88%. Dew Point: -1.0°C. Windchill: 1.0°C. Pressure: 30.31 in 1026 hPa (Rising).
06:09 mtompset @wunder schomberg, ON
06:09 huginn mtompset: The current temperature in Ebhausen, Ebhausen, Germany is 0.8°C (7:00 AM CET on December 18, 2013). Conditions: Mist. Humidity: 88%. Dew Point: -1.0°C. Windchill: 1.0°C. Pressure: 30.31 in 1026 hPa (Rising).
06:09 wahanui i already had it that way, huginn.
06:09 mtompset @wunder schomberg, ontario
06:09 huginn mtompset: The current temperature in Ebhausen, Ebhausen, Germany is 0.8°C (7:00 AM CET on December 18, 2013). Conditions: Mist. Humidity: 88%. Dew Point: -1.0°C. Windchill: 1.0°C. Pressure: 30.31 in 1026 hPa (Rising).
06:09 wahanui i already had it that way, huginn.
06:09 mtompset @wunder l7e 5y5
06:09 huginn mtompset: The current temperature in Richmond Hill, Richmond Hill, Ontario is -6.9°C (12:56 AM EST on December 18, 2013). Conditions: Overcast. Humidity: 98%. Dew Point: -7.0°C. Windchill: -7.0°C. Pressure: 29.93 in 1014 hPa (Falling).
06:10 * mtompset shrugs.
06:10 mtompset Have a great day, #koha.
06:25 cait joined #koha
06:26 * dcook waves to cait
06:26 dcook Have a good day :)
06:32 cait :)
06:33 sophie_m joined #koha
06:57 laurence joined #koha
07:31 * magnuse waves
07:38 reiveune joined #koha
07:39 reiveune hello
07:39 wahanui salut, reiveune
07:50 cait left #koha
08:03 alex_a joined #koha
08:13 cait joined #koha
08:13 cait hi #koha
08:19 magnuse wb cait
08:20 gaetan_B joined #koha
08:20 gaetan_B hello
08:20 wahanui bonjour, gaetan_B
08:29 paul_p joined #koha
08:43 cait hi magnuse, gaetan_B, wahanui :)
08:43 wahanui cait: what?
08:44 magnuse @wunder boo
08:44 huginn magnuse: The current temperature in Bodo, Norway is 3.0°C (9:20 AM CET on December 18, 2013). Conditions: Mostly Cloudy. Humidity: 93%. Dew Point: 2.0°C. Windchill: -2.0°C. Pressure: 29.68 in 1005 hPa (Steady).
08:44 magnuse ...and so dark!
08:44 cait same here :(
08:56 alex_a_ joined #koha
08:58 alex_a joined #koha
09:03 magnuse hm... MARC::File::XML seems to dislike the § (Section sign) character, e.g. in 500a. anyone got an idea for how to deal with that?
09:19 alex_a joined #koha
09:24 nlegrand Hey #koha o/
09:53 magnuse oh hooray for perl - 26 years today!
10:00 Binu joined #koha
10:01 Binu hello
10:03 Binu hello with whom can I ask a query on MAR21 import in Koha? Any experts our there?
10:04 * Binu slaps BobB_ around a bit with a large fishbot
10:31 cait Binu: we don't slap around here - lots of poeple are constantly logged in, but BobB_ for example is in australia and it's really late for him
10:32 cait Binu: just ask your question, if someone knows they will answer
10:33 Binu so sorry for that. I was just checking the functionality.
10:35 cait np
10:36 Binu Ques : While importing MARC records into a blank Koha database, I want Koha to check if there are duplicate records in the MARC file that I am importing so that duplicate records are clubbed together to a particular bibliography.
10:38 Binu for clarity duplicate records mean - one title with mutiple barcodes( i.e. more than one copy)
10:40 cait sorry phone
10:42 Binu what phone? do u want me to call u?
10:43 nlegrand Binu: I guess cait has a phone call and is unable to answer you right now :)
10:44 nlegrand (and so am I, because I'm new to Koha ^^)
10:45 Binu ok thanks nlegrand
11:09 cait reading back
11:09 cait ah too late
11:12 busla joined #koha
11:18 ebegin_away joined #koha
11:18 cait hi khall :)
11:18 khall mornin cait!
11:20 cait :)
11:32 cait gmcharlt++
11:37 busla joined #koha
11:38 tcohen joined #koha
12:06 drojf joined #koha
12:17 tcohen joined #koha
12:18 tcohen morning #koha
12:34 jwagner joined #koha
12:37 alex_a joined #koha
12:55 laurence left #koha
12:55 NateC joined #koha
12:56 meliss joined #koha
13:17 oleonard joined #koha
13:17 tcohen is jenkins around?
13:19 oleonard Hi #koha
13:20 tcohen joined #koha
13:35 talljoy joined #koha
13:41 nengard joined #koha
13:51 tcohen @later tell jenkins_koha build Koha_3.12.x
13:51 huginn tcohen: The operation succeeded.
13:53 Dyrcona joined #koha
14:03 edveal joined #koha
14:16 ebegin_away joined #koha
14:25 oleonard Just realized I dreamed about finding git merge conflict markers in a live site. Do I get a nerd merit badge for that?
14:27 SherryS joined #koha
14:32 cait hehe yes
14:45 SherryS left #koha
14:56 maximep joined #koha
14:59 rambutan hola koha
15:04 Dyrcona joined #koha
15:06 khall joined #koha
15:08 ebegin a quick perl question : What means a -s in a condition like : if (exists $ENV{"KOHA_CONF"} and $ENV{'KOHA_CONF'} and -s  $ENV{"KOHA_CONF"}) {
15:09 jcamins ebegin: file has nonzero size:
15:11 ebegin thanks jcamins
15:11 rocio joined #koha
15:13 ashimema_away hi all
15:18 rambutan hi ashimema
15:19 cait hi ashimema
15:29 rocio1 joined #koha
15:31 tcohen hi ashimema
15:31 rocio1 left #koha
15:31 rocio1 joined #koha
15:48 ashimema still qa'ing your bug tcohen.. gave me a good reason to finally get to grips with building packages ;)
15:48 tcohen heh
15:48 ashimema shame I've gotta fit it in around work ;)
15:48 tcohen fortunately it is documented how to do it!
15:49 ashimema indeed..
15:49 ashimema Works nicely so far.. just bringing up a clean vm to install my freshly build package onto now..
15:50 petter joined #koha
16:00 cait ashimema++
16:06 oleonard doesn't work at all the way I thought it did now that I look closely at the query it uses
16:07 oleonard "Top 50 of the most popular titles in the last 12 months" means most popular titles *added* in the last 12 months, not *circulated* in the last 12 months
16:07 cait huh??
16:07 jcamins oleonard: really? Eww.
16:07 cait can you paste the sql?
16:07 cait just curious
16:08 cait but today nothing should surprise me
16:08 cait today--
16:09 pastebot "oleonard" at pasted " query" (15 lines) at
16:20 gmcharlt oleonard: wow, and it's been like that from the beginning, it seems
16:21 gmcharlt issues.issuedate would match what you're expecting rather than bibio.datecreated
16:23 gmcharlt though I could see somebody wanting to include datecreated if they want the emphasis to be on newer titles and their patrons are still reading nothing but Harry Potter ;)
16:35 cait left #koha
16:46 oleonard I wonder if it would make sense to add an "any" option to sql report runtime parameters?
16:48 paul_p @karma
16:48 huginn paul_p: Highest karma: "rangi" (962), "oleonard" (806), and "jcamins" (662).  Lowest karma: "ie" (-125), "<!" (-116), and "failed" (-111).  You (paul_p) are ranked 9 out of 2720.
16:48 ashimema @karma
16:48 huginn ashimema: Highest karma: "rangi" (962), "oleonard" (806), and "jcamins" (662).  Lowest karma: "ie" (-125), "<!" (-116), and "failed" (-111).
16:50 tcohen @karma
16:50 huginn tcohen: Highest karma: "rangi" (962), "oleonard" (806), and "jcamins" (662).  Lowest karma: "ie" (-125), "<!" (-116), and "failed" (-111).  You (tcohen) are ranked 15 out of 2720.
16:51 oleonard @karma huginn
16:51 huginn oleonard: Karma for "huginn" has been increased 8 times and decreased 0 times for a total karma of 8.
16:51 oleonard @karma cookies
16:51 huginn oleonard: Karma for "cookies" has been increased 5 times and decreased 0 times for a total karma of 5.
16:51 ashimema lol
16:51 ashimema I hadn't seen the karma command before :$
17:02 oleonard SQL Reports Library says "You have to put "%" in a text box to 'leave it blank'" Does that work?
17:02 tcohen_ joined #koha
17:09 cait joined #koha
17:11 tcohen_ joined #koha
17:15 oleonard As far as I can tell, if I want to use branch runtime parameters in an SQL report, I'll have to create a separate report to cover all branches.
17:22 cait ?
17:22 cait oleonard: maybe i am late, but what is the problem?
17:23 cait ah, ok, no i get it I think
17:23 cait now
17:23 cait oleonard: you could create an authorized value.... with your branchcodes, branches and % and use like... but that would be a bitof a stretch
17:47 nengard oleonard: what people do is create another authorized value list with all the branches in it and then add an 'all branches' with the value equal to %
17:47 nengard i thought i had a blog post about that - but can't find it
17:48 reiveune bye
17:48 reiveune left #koha
17:48 oleonard So, what cait said :)
17:48 oleonard cait++
17:48 oleonard nengard++
17:48 nengard[…]-tip-in-koha-3-8/
17:48 oleonard I still think it would be a nice idea to build in a blank option when using runtime parameters
17:49 nengard i agree
17:49 nengard and i want!!!
17:49 nengard for item types, collection codes, etc etc etc
17:49 nengard an 'all' option would be great
17:51 cait hm we'd need to be abit careful, it will only work if you use like
17:51 cait and depending on how people did their codes that coudl have some unwanted effects
17:53 NateC joined #koha
17:54 oleonard cait: If we're modifying how the query is built by the script we wouldn't necessarily be required to use 'like'
17:55 cait hm
17:55 * oleonard speculates
17:55 cait i think it's not trivial to do that
17:55 cait right now it's a placeholer
17:55 cait then it woudl have to change the logic
17:55 cait and remove the clause
18:05 oleonard Welcome rocio1! ([…]rations-support/)
18:16 kenan24 joined #koha
18:22 rocio1 left #koha
18:22 rocio joined #koha
18:26 barton joined #koha
18:41 collum joined #koha
18:46 magnuse welcome rocio_lunch!
18:56 drojf i am wondering about hosting koha for clients. are there ways of virtualization that have proven particularly useful (or the opposite) to run koha on a root server?
18:58 magnuse drojf: are you considering a physical server?
18:58 magnuse i have only good things to say about linode
18:58 magnuse gah
18:58 * magnuse wanders off
18:58 cait i think better use a server in germany
18:58 drojf with the nsa stuff… i suppose only german servers would work ^^
18:58 cait less trouble
18:59 drojf yep
18:59 gmcharlt drojf: we use Xen quite successfully
19:00 cait drojf: do you want to run a big server yourself? or rent something in a data center?
19:00 jcamins drojf: Xen works pretty well, especially if someone else will manage it for you.
19:00 drojf cait: rent. neither place nor bandwidth here i am afraid
19:01 cait i got worried for a moment :)
19:01 drojf gmcharlt jcamins: i'm not sure if that would work with a rented root server but i'll check
19:01 cait i have heard good things about hetzner
19:01 drojf that is who i am thinking about
19:01 jcamins drojf: oh, probably not. On an individual server level, I just use multiple Koha instances.
19:02 drojf cait. but the vps are pretty low spec so i guess it would make more sense to get a root server (and i could also use it for other fun things)
19:02 drojf low spec as in, they have only single cpu vps i think
19:02 jcamins I'd suggest testing Debian/kFreeBSD, since that would give you Debian + jails.
19:02 jcamins And pf.
19:03 * jcamins is not a fan of iptables.
19:04 jcamins lxc is really nice, but the root user in lxc might have full root privileges on the host system, which is not so good. In my opinion.
19:05 drojf jcamins: i have read about lxc and it did not sound safe. and seems to have extra problems on debian 7
19:05 drojf apart from that, it sounds very interesting
19:05 jcamins I use lxc for testing and development.
19:06 jcamins Much faster to do clean room package testing on an lxc container than on a separate VM.
19:12 drojf jcamins: yes i will have to play with it when i have more time. looks cool
19:12 jcamins You should just make the switch to Debian/kFreeBSD and play with jails.
19:12 drojf i was thinking about just using koha instances but i was not sure how that will work out if people want ssh access
19:13 * jcamins doesn't provide SSH access.
19:14 drojf i should probably neither
19:14 * jcamins doesn't want to support anyone who does things not through the Koha interface.
19:14 drojf good point ^^ i also do not feel like cleaning up after people with no idea but access :P
19:15 rambutan consider webmin access?
19:15 cait drojf: there is a way you can allow them to download their database anytime with packages
19:15 cait maybe a compromise?
19:16 drojf i have no idea if people would want access at all. i suppose that was my way of thinking. because i would want to have that :D
19:17 cait yeha, but you wouldn't go to a service provider ;)
19:17 jcamins drojf: my feeling is that if someone has a need for SSH access, they should run their own servers, and I will charge (higher) support fees accordingly.
19:19 jcamins Way higher chances of weirdness.
19:19 drojf good point. and i think those who actually asked me so far did so because they do not want to have to do any servery things. but i will have to bring that up if anything is going to happen with them at all
19:22 druthb Having (in my evil past) had customers who insisted on SSH access, I would start by *doubling* the support fee.  Got to pay for the therapy you'll need when you see what they do to your poor innocent servers somehow.
19:23 druthb There is nothing good that can come of that.  You can provide an SFTP location to download the tar-gzipped sql dumps, if they have a fetish about keeping a copy of their backups, but letting someone have shell access is just asking for a ticket to the loony bin.
19:26 druthb …and I'd hate to have to come to Germany to visit you in an asylum, drojf!
19:27 drojf druthb: thanks for pointing that out :D
19:29 talljoy o/ druthb
19:30 phasefx joined #koha
19:31 cait drojf: she is serious
19:31 cait shemight actually be coming!
19:32 talljoy looks she may be on her way now.
19:32 druthb o/ talljoy
19:32 talljoy ah!
19:32 talljoy there she is!
19:32 druthb might-nothing.  I *am* coming to Germany, in April.
19:32 cait hehe
19:32 * druthb hopes cait can pop over to see me!
19:34 * cait hopes too
19:38 talljoy Germany in April?  mmmm......
19:38 * talljoy checks her calendar
19:38 talljoy cait i had an opportunity to join a group in Stuttgart in May.  Is that near you?  or not?
19:39 cait it is close by yes :)
19:39 cait i studied in stuttgart, about 3 hours of a train ride and BSZ has hm a branch? in stuttgart
19:40 cait :)
19:40 talljoy i haven't decided to go or not.  It is with the Library School here and they are visiting an International School in Stuttgart to work in the library.
19:41 talljoy a Koha library no less!!
19:41 cait aaah
19:41 cait i know them :)
19:41 cait have been there for a day once
19:41 cait it was interesting
19:42 druthb talljoy, has mashing too many Follett data sets made you funny in the head?  You have to *think* about whether to go to Germany?
19:42 talljoy ha!
19:42 jcamins germs?
19:42 wahanui it has been said that germs is
19:42 jcamins germs?
19:42 wahanui Germs originated in Germany, before rapidly spreading throughout the rest of the world.
19:42 jcamins ^^ possible reason not to go to Germany. Who wants to get sick?
19:42 talljoy the librarian there is Betty.  And I spent some time at an International School in Kiev with her.
19:42 * druthb gives jcamins the stink eye.
19:43 druthb hush, you
19:43 cait i think i have met her
19:43 talljoy okay, duty calls ...  phone time.
19:43 cait talljoy: and germany won't make you sick
19:44 cait talljoy: you should totally go :)
19:45 talljoy i am going to look into getting on the bandwagon with it.
19:45 * druthb thinks cait oughta give jcamins the ebil eye, too.
19:51 cait druthb: he is just influenced by eythian
19:51 cait germs?
19:51 wahanui hmmm... germs is
19:51 cait germs?
19:51 wahanui Germs originated in Germany, before rapidly spreading throughout the rest of the world.
19:51 cait druthb:  not worth it ;)
19:51 druthb eythian is a bad influence, yes.
19:58 oleonard Bye #koha
19:59 rambutan can't believe the koha world is so full of world travelers
19:59 cait kohamakes us
19:59 rambutan "Yea, I studied Ada under the great professor Dr. Kurtz in Moscow and then a year with Dr. Richie in Kiev then took a year off and just sat around drinking wine with Dr. Wirth in Vienna"
19:59 cait if you have suddenly friends around theglobe... you got not so many options
20:02 rambutan Does anybody off hand know where Paengyongdo is? Those are the kind of places I've been.
20:04 jcamins Isn't that an island off South Korea?
20:05 rambutan North Korea more correctly, although it is a "UN controlled" (effectively South Korea) island
20:08 phasefx joined #koha
20:09 rangi gmcharlt: can you please zero out my karma?
20:10 * druthb boggles
20:10 cait gmcharlt: please can't you not listen to him and just move it somewhere else until that thread is thorugh?
20:10 cait can you....
20:10 rangi no
20:10 druthb @most increased
20:10 huginn druthb: "rangi": 969, "oleonard": 811, "jcamins": 664, "gmcharlt": 570, "cait": 496, "wizzyrea": 473, "kf": 326, "chris_n": 316, "paul_p": 286, "magnuse": 279, "nengard": 256, "eythian": 254, "sekjal": 247, "druthb": 216, "tcohen": 195, "slef": 182, "bgkriegel": 143, "drojf": 133, "marcelr": 107, "fredericd": 99, "mtj": 85, "joubu": 72, "biblibre": 71, "hdl": 70, and "mveron": 68
20:10 rangi if its gonna be used as a tool, instead of a pointless gimmick, id like to restart mine
20:11 rangi i think im allowed to do that
20:11 jcamins cait: "can't you" also works in that sentence.
20:11 cait sorry
20:11 tcohen joined #koha
20:12 rangi NateC: you about?
20:12 rangi ahh nevermind i see you fixed the typo already :)
20:12 rangi welcome rocio :)
20:13 rocio thank you rangi!
20:13 cait welcome rocio!
20:13 rocio thanks cait!
20:13 druthb yeah, the Pronoun Police (me) told NateC about it earlier.  :)
20:13 gmcharlt hi rocio
20:14 rocio hi there
20:14 wahanui hi, rocio
20:14 rangi rocio: have you been introduced to the bots?
20:14 gmcharlt @karma gmcharlt
20:14 huginn gmcharlt: Karma for "gmcharlt" has been increased 0 times and decreased 0 times for a total karma of 0.
20:15 gmcharlt @karma rangi
20:15 huginn gmcharlt: Karma for "rangi" has been increased 0 times and decreased 0 times for a total karma of 0.
20:15 rangi we have 3 main ones, wahanui, who is an info bot, huginn who is a supybot, and logbot who suprisingly logs things
20:15 rangi so you can do things like this
20:15 rocio yes! I'm not very good at remembering them though
20:15 rangi NateC?
20:15 wahanui I LIKE SPACE AND MY WIFE
20:15 rangi bag?
20:15 wahanui I LIKE BASEBALL
20:15 rangi be rangi
20:15 wahanui There's a bug for that
20:15 jcamins cookies?
20:15 wahanui Cookies are delicious delicacies
20:15 rangi or
20:16 druthb druthb?
20:16 wahanui Well, she finally snapped, like we all knew she would.
20:16 rocio hahahaha
20:16 gmcharlt ot
20:16 gmcharlt or
20:16 gmcharlt @quote random
20:16 huginn gmcharlt: Quote #37: "< nelsonf> I'm pretty sure I deleted this one in the name of being thorough..." (added by chris at 11:27 PM, October 04, 2009)
20:16 rangi @weather fort worth
20:16 huginn rangi: The current temperature in Riverside, Fort Worth, Texas is 21.1°C (2:10 PM CST on December 18, 2013). Conditions: Scattered Clouds. Humidity: 38%. Dew Point: 6.0°C. Pressure: 30.09 in 1019 hPa (Falling).
20:16 rangi (you are near fort worth right?)
20:16 rocio yes I am! I am in Denton
20:17 talljoy talljoy?
20:17 wahanui I CRUNCH DATA or kicking butt at words with friends
20:17 talljoy nom nom nom
20:17 wizzyrea "words with people you used to be friends with"
20:17 talljoy HA!
20:17 cait lol
20:18 rangi rocio: huginn has some more practical uses too
20:18 rangi like
20:18 rangi bug 12345
20:18 huginn Bug[…]_bug.cgi?id=12345 was not found.
20:18 rangi bug 11000
20:18 huginn Bug[…]_bug.cgi?id=11000 normal, P3, ---, gmcharlt, NEW , koha-restore not working: Koha username error
20:18 rangi or
20:18 rangi @marc 100
20:18 huginn rangi: A personal name used as a main entry in a bibliographic record. [a,b,c,d,e,f,g,j,k,l,n,p,q,t,u,4,6,8]
20:18 wizzyrea @quote get 123
20:18 wahanui
20:18 huginn wizzyrea: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011)
20:18 rocio omg that's definitely useful
20:18 talljoy ^ best quote
20:18 rocio didn't know that could be done
20:19 * wizzyrea waves to rocio
20:19 wizzyrea wecome to the family
20:19 rocio thank you wizzyrea!
20:21 cait and don't forget
20:21 cait @wunder Konstanz
20:21 huginn cait: The current temperature in Konstanz, Germany is 0.0°C (9:00 PM CET on December 18, 2013). Conditions: Heavy Fog. Humidity: 98%. Dew Point: 0.0°C. Pressure: 30.20 in 1023 hPa (Falling).
20:21 cait weather reports :)
20:21 cait and
20:22 cait @later tell rocio welcome again!
20:22 huginn cait: The operation succeeded.
20:22 rocio that's one I keep forgetting!
20:22 rocio the later tell lol
20:22 rangi its very handy
20:22 rocio @wunder Konstanz
20:22 huginn rocio: The current temperature in Konstanz, Germany is 0.0°C (9:00 PM CET on December 18, 2013). Conditions: Heavy Fog. Humidity: 98%. Dew Point: 0.0°C. Pressure: 30.20 in 1023 hPa (Falling).
20:22 rocio hahahaha cool
20:24 paul_p joined #koha
20:24 cait which means it's too cold here... brrr
20:24 cait :)
20:26 rangi hmm meeting in 35 mins, i probably should read up on what it's about
20:26 rangi rocio: have you seen the dashboad too?
20:27 rangi
20:27 wahanui are the better stats to optimise
20:27 rangi oh wow 4 sign offs from joel
20:27 cait yep
20:27 cait been busy :)
20:42 rocio no I hadn't seen the dashboard rangi thank you for that
20:42 * cait loves the dashboard
20:46 * magnuse too
20:51 meliss joined #koha
20:57 magnuse oh look, bug 11004 is not a difficult signoff at all ;-)
20:57 huginn Bug[…]_bug.cgi?id=11004 normal, P5 - low, ---, magnus, Needs Signoff , Make xmlControlfield.js use the marcflavour syspref to look for XML files
20:58 magnuse Have fun #koha!
21:19 tcohen joined #koha
21:35 pastebot "gmcharlt" at pasted "Approximate size of releases by non-merge commit count" (9 lines) at
21:36 rangi exactly
21:36 rangi 3.2 wasnt time based, ie thats over 2.5 years
21:37 rangi and 3.4 had a zillion tt commits
21:37 wizzyrea 3.6 was lovely and stable
21:37 rangi otherwise 1k a every 6 months .. is very impressive
21:37 rangi gonna do a nice 2013 summary gmcharlt ?
21:38 gmcharlt yeah
21:38 gmcharlt I'm in a number-crunching mood
21:38 rangi cool
21:38 jcamins I think 3.6 was a slightly shorter release cycle, too, since the release month was changed.
21:39 jcamins Or was that later?
21:39 rangi that was later, 3.8 was a longer one (or 3.10)
21:39 rambutan anybody installing koha on btrfs yet? any libraries have exabyte size data?
21:39 rangi one was 7 months
21:39 jcamins Ah, right.
21:39 jcamins We moved *back* not forward.
21:45 eythian hi
21:46 rambutan hi eythian
22:29 dcook joined #koha
22:31 pianohacker joined #koha
22:40 cait gmcharlt++
22:40 cait so... anyone up to sign off my patches now? ;)
22:41 dcook Maybe yes, maybe no :p
22:41 dcook What are the patches?
22:41 wahanui the patches are on the bug
22:41 nengard left #koha
22:41 gmcharlt which bug?
22:41 gmcharlt no
22:41 gmcharlt wait
22:41 gmcharlt SIGN OFF ALL THE BUGS!
22:42 dcook hehe
22:42 cait dcook: you go to needs signoff and sort by assignee ;)
22:42 dcook :P
22:42 dcook In that case, probably not. Trying to figure out an acquisitions bug atm.
22:44 jcamins rangi: I think I submitted a patch for that.
22:44 cait bug 11279
22:44 huginn Bug[…]_bug.cgi?id=11279 normal, P5 - low, ---, katrin.fischer, Needs Signoff , Quote of the day feature won't pick a quote
22:44 cait bug 11260
22:45 huginn Bug[…]_bug.cgi?id=11260 normal, P5 - low, ---, katrin.fischer, Needs Signoff , Update German web installer
22:45 jcamins Nope, not that one.
22:45 cait bug 11228
22:45 jcamins Not that one either.
22:45 cait bug 11144
22:45 huginn Bug[…]_bug.cgi?id=11228 normal, P5 - low, ---, katrin.fischer, Needs Signoff , Explanation on 'patron notification' is not quite right
22:45 cait bug 10907
22:45 huginn Bug[…]_bug.cgi?id=11144 normal, P5 - low, ---, katrin.fischer, Needs Signoff , Switch order of overdues and fines cronjob for packages and in crontab.example
22:45 rangi ohh id love it if you had
22:45 huginn Bug[…]_bug.cgi?id=10907 enhancement, P5 - low, ---, katrin.fischer, Needs Signoff , Showing the staff members name who managed a suggestion should be optional
22:45 cait just helping dcook find my patches ;)
22:45 jcamins Maybe not.
22:45 jcamins Bug 8908 is where I reported it, but I don't see a patch.
22:45 huginn Bug[…]w_bug.cgi?id=8908 normal, P5 - low, ---, gmcharlt, NEW , Starman/Plack hangs when faced with zombie Zebra
22:45 jcamins Hmm.
22:45 jcamins I remember working on it.
22:46 * cait shudders at the thought of a zombie zebra
22:46 rangi any ideas would also be awesome
22:47 jcamins Let me see if I can figure out where the work is, because I know I spent time on it.
22:49 rangi cool thanks
22:56 rambutan creative subject line
23:00 dcook Oh ho...I think I might have an idea about this bug now..
23:01 jcamins rangi: looks like I never got very far.
23:01 rangi ahh bummer
23:02 rangi i was thinking of just trying to do a really simple thing, like change format or something
23:02 rangi to test the connection was still valid
23:02 rangi cos this
23:02 wahanui i heard cos this was publicly logged
23:02 rangi if ( defined($context->{"Zconn"}->{$server}) && (0 == $context->{"Zconn"}->{$server}->errcode()) )
23:02 jcamins I just have a bunch of debugging statements trying to track down where it hangs, but wasn't able to recreate the bug consistently enough to answer the question.
23:02 rangi isn't doing it
23:02 rangi *nod*
23:02 rangi k ill keep working on it
23:04 jcamins rangi: try $conn->check().
23:04 dcook ModSuggestion, you little devil..
23:04 rangi hmm does that actually exist?
23:04 jcamins Yeah.
23:05 jcamins Well, I think.
23:05 rangi just not documented?
23:05 rangi i can certainly try
23:05 jcamins It's in the POD.
23:05 jcamins[…]ib/ZOOM.pod#check()
23:06 rangi ah yep, we are acting asynchronously in this case
23:06 rangi cool ill give it a try
23:06 eythian rangi: you could kick the zebra server, that'd probably break the connection.
23:07 jcamins eythian: that didn't work for me.
23:07 jcamins I mean, it did work, and didn't trigger the bug.
23:07 eythian ah right
23:10 papa joined #koha
23:16 dcook Why would there be a foreign constraint error on the prod system but not the dev system when using the same code and the same data...
23:17 jcamins dcook: because your dev system had an extra upgrade.
23:17 dcook Mmm
23:17 dcook Hmm
23:18 dcook Possibly but I don't see why it would
23:18 jcamins When did you copy the data from production to dev?
23:18 dcook 15 minutes ago?
23:19 jcamins And you didn't go through the installer?
23:19 jcamins (for the upgrade)
23:20 gmcharlt are both prod and dev using innodb?
23:20 gmcharlt or did the dev system somehow end up using myisasm?
23:21 dcook Both should be innodb
23:22 dcook jcamins: The dev used to be higher but I did a restore with a lower DB
23:22 jcamins dcook: and you downgraded the code, too?
23:22 dcook Mind you, I think the restore only removed the tables and readded them. It didn't drop the database and start absolutely completely from scratch
23:22 dcook Downgraded the code?
23:22 jcamins Your code and database have to be in sync.
23:23 dcook Both systems are running the same code and (nearly) the same db
23:23 jcamins Okay.
23:24 dcook The prod system dies when it tries to send a letter to patron that doesn't exist anymore, whereas the dev system seems to just chug along
23:25 dcook foreign_key_checks are on in the global mysql variables as well so I'm surprised no error comes up
23:25 dcook Unless...
23:25 wahanui it has been said that unless is probably meant to give code that reads more like natural language? but i'm not a fan either
23:25 * dcook tries another thing
23:25 jcamins You are missing a table on the production system?
23:26 eythian dcook: you have a problem with the letter table
23:26 eythian I don't know what it is, but that table screws up a lot
23:26 eythian I think deleting everything before you load is the way to go
23:26 eythian I have a script to do that.
23:27 dcook It's the message_queue table (I should've mentioned that)
23:27 dcook It does have a foreign key pointing back to the borrowers table
23:28 eythian ah, I've seen weird things happen with the letter table.
23:29 dcook I'm wondering if the indexes aren't there...
23:30 gmcharlt dcook: could you paste the output of 'show create table message_queue;' from both dev and production?
23:30 jcamins dcook: I suggest getting the CREATE TABLE command for each table, and diffing them.
23:32 dcook Hmm, they're identical
23:33 jcamins Compare other tables.
23:33 * jcamins would compare all the tables.
23:33 pastebot "dcook" at pasted "message_queue create" (43 lines) at
23:33 jcamins mysqldump --no-data
23:36 gmcharlt dcook: another thing to check -- start a new mysql session, then do SELECT @@FOREIGN_KEY_CHECKS;
23:37 dcook jcamins: Dev has a few more tables that didn't get dropped when I downgraded but I can't imagine them getting in the way
23:37 jcamins dcook: message_transport_type?
23:37 wahanui message_transport_type is, like, print. I would like email
23:38 dcook gmcharlt: Still says 1 :/
23:41 gmcharlt hmm
23:41 gmcharlt could you paste the exact error message?
23:41 dcook gmcharlt: Just about to :)
23:41 pastebot "dcook" at pasted "error message" (2 lines) at
23:43 dcook I'm going to drop the dev db and try this again
23:46 dcook Dang...still no error...
23:47 gmcharlt dcook: select count(*) from suggestions where suggestedby is not null and suggestedby not in (select borrowernumber from borrowers);
23:47 * gmcharlt would be willing to get that the order in question has a suggested where suggestedby = 0
23:47 dcook 4
23:47 gmcharlt or refers to a borrower that got deleted after making the suggestion
23:48 dcook I checked the suggestion earlier and it had a borrowernumber which had already been deleted from borrowers
23:48 dcook Yeah, the latter
23:49 dcook Hmm...
23:49 dcook No entry got made in the dev system
23:50 dcook I imagine that it returned a warning rather than an error and that warning isn't captured
23:51 dcook {'RaiseError' => $ENV{DEBUG}?1:0 })
23:51 dcook I bet the prod system has that environmental variable set and the dev system doesn't
23:51 dcook Which is interesting..
23:52 gmcharlt the apache log in prod would be quite verbose if it were set
23:53 dcook I've often thought it was rather verbose (although not always as much as I would like)
23:53 dcook Should find out in about 40 seconds
23:53 eythian it's far too verbose at the moment.
23:53 eythian mostly with meaningless warnings
23:53 dcook Yeah, the meaningless warnings suck, that's true
23:54 dcook Yep, that was it
23:54 dcook Set on prod but not on dev
23:55 dcook Apache config is the only thing that would've been different
23:55 eythian hmm. So if debug is not set, you get things failing mostly silently to the user? That's not ideal.
23:56 dcook eythian: Agreed
23:56 dcook I think I ran into this same thing elsewhere a few months ago

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