Time  Nick            Message
01:02 mtj             hey #koha, is koha 3.22.x and debian7 (jessie) a safe combo?
01:05 mtj             ..i recall that ubuntu-16 has a problem with koha, using mysql-server5.7
01:06 mtj             but koha-3.22 on jessie is all good? (as it still uses mysql 5.5)
01:08 mtj             oops, jessie is deb8, of course :)
01:39 wizzyrea        mtj: yes
01:40 mtj             thanks liz, grate nooz
06:10 * magnuse       waves
06:13 fridolin        hie
06:26 LibraryClaire   Morning #koha
06:29 magnuse         @wunder boo
06:29 huginn`         magnuse: The current temperature in Bodo, Norway is 10.0°C (8:20 AM CEST on June 16, 2016). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 7.0°C. Pressure: 29.80 in 1009 hPa (Rising).
06:37 LibraryClaire   @wunder LCY
06:37 huginn`         LibraryClaire: The current temperature in London City, United Kingdom is 15.0°C (7:20 AM BST on June 16, 2016). Conditions: Scattered Clouds. Humidity: 77%. Dew Point: 11.0°C. Pressure: 29.53 in 1000 hPa (Steady).
06:38 magnuse         humility: 56%
06:41 eythian         https://plus.google.com/+RobinSheat/posts/AkezQER6WvL <-- guess I have to upload everything before I can download anything
06:48 drojf1          morning #koha
06:51 LibraryClaire   Hi drojf
06:51 drojf           guten morgen LibraryClaire
06:55 alex_a          bonjour
06:59 reiveune        hello
06:59 * LibraryClaire waves
07:18 drojf           @wunder berlin, germany
07:18 huginn`         drojf: The current temperature in Berlin Tegel, Germany is 17.0°C (8:50 AM CEST on June 16, 2016). Conditions: Scattered Clouds. Humidity: 72%. Dew Point: 12.0°C. Pressure: 29.62 in 1003 hPa (Steady).
07:32 marcelr         hi #koha
07:34 LibraryClaire   Hi marcelr
07:34 marcelr         :)
08:00 mveron          Hi #koha
08:01 mveron          @wunder Allschwil
08:01 huginn`         mveron: The current temperature in Grenchen, Switzerland is 12.0°C (9:50 AM CEST on June 16, 2016). Conditions: Rain. Humidity: 100%. Dew Point: 12.0°C. Pressure: 29.68 in 1005 hPa (Rising).
08:01 mveron          @wunder Basel
08:01 huginn`         mveron: The current temperature in Grenchen, Switzerland is 12.0°C (9:50 AM CEST on June 16, 2016). Conditions: Rain. Humidity: 100%. Dew Point: 12.0°C. Pressure: 29.68 in 1005 hPa (Rising).
08:02 liw             @wunder helsinki
08:02 huginn`         liw: The current temperature in Helsinki, Finland is 15.0°C (10:50 AM EEST on June 16, 2016). Conditions: Rain Showers. Humidity: 94%. Dew Point: 14.0°C. Pressure: 29.65 in 1004 hPa (Steady).
08:02 mveron          No weather in Basel. Maybe because of the rain....
08:02 marcelr         hi mveron
08:02 mveron          goede morgen marcelr :-)
08:03 mveron          We have a regression: Bug 16747
08:03 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16747 critical, P5 - low, ---, veron, Needs Signoff , Fix regression in patron card creator (patron image)
08:08 drojf           hi mveron and marcelr
08:09 mveron          hi drojf
08:09 marcelr         gute morgen drojf
09:01 eythian         @later tell kathryn https://katieconf.xyz/
09:01 huginn`         eythian: The operation succeeded.
09:12 arcer121        hi! I am setting up a big library. If anyone would help me with all the small small doubts that I have every now and then, I would be very greatful.
09:13 arcer121        To start with, we have 5 main categories of collection. I defined the five in 'Item Types'
09:14 arcer121        Three of them are not for loan, one can be loaned by any patron, and one category can be leased by one a special category of patrons.
09:16 arcer121        So how do I restrict this particular 'Item Type' to be check-out-able by a special category of patrons?
09:30 * andreashm     waves
09:39 drojf           hi andreashm
09:42 andreashm       hey drojf
09:56 arcer121        are the library staff also patrons?
10:02 mveron          arcer121: Yes. For permissions see http://manual.koha-community.org/16.05/en/patronpermissions.html
10:02 drojf           arcer121: you might want to read the manual before you set up a big library
10:03 arcer121        I am just simulating it on my laptop before the actual work.
10:03 mveron          Oh, lunchtime...
10:03 wahanui         lunchtime is a terrible time for a meeting
10:03 arcer121        Thanks!
10:19 drojf           marcelr: do you remember why bug 6536 only supports sru targets for biblio search and not authorities? were there technical reasons not to do it, or just because you had no use case for it?
10:19 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6536 new feature, P3, ---, m.de.rooy, Pushed to Master , Z3950 Search Enhancements: SRU targets and additional XSLT processing
10:19 marcelr         drojf: didn't dcook write the authority side later on?
10:20 drojf           i don't think so. at least if i add a sru target, it's hardcoded to biblios
10:20 drojf           or its a bug in the template file
10:20 marcelr         look at the Record type parameter in Z3950 admin
10:21 marcelr         Biblio or Auth
10:21 drojf           that does not work for sru targets
10:21 marcelr         ok
10:21 drojf           its bibliographic and grey
10:21 drojf           at least for me :)
10:21 marcelr         yeah could be
10:21 marcelr         i never needed one
10:22 drojf           i tried it at some point and just expected it to work. then i found it does not. wanted to ask at the hackfest, but forgot
10:22 marcelr         should not be that hard to add it :)
10:22 drojf           no i guess most code could be copied
10:23 marcelr         iirc the code has been copied already; we should try to consolidate again
10:23 drojf           but i thought there may have been reasons not to do it that i can't see ;)
10:23 marcelr         no technical reasons
10:23 drojf           ok
10:40 wizzycray       eythian: hahaha I showed katieconf to kathryn too
10:49 drojf           i should ask that other drojf to have a drojfconf
11:09 oleonard        Hi #koha
11:11 drojf           hi oleonard
11:12 drojf           brb
11:15 druthb          o/
11:15 oleonard        Good morning druthb
11:15 druthb          :)  Hi, oleonard!
12:01 tcohen          hola #koha
12:01 tcohen          @wunder cordoba, argentina
12:01 huginn`         tcohen: The current temperature in Bo Altos de San Martin - NW, Cordoba city, Cordoba City, Argentina is 6.2°C (9:00 AM ART on June 16, 2016). Conditions: Clear. Humidity: 87%. Dew Point: 4.0°C. Windchill: 6.0°C. Pressure: 30.39 in 1029 hPa (Steady).
12:01 tcohen          brrr
12:02 LibraryClaire   afternoon #koha
12:03 tcohen          hi LibraryClaire
12:03 LibraryClaire   hi tcohen :)
12:05 drojf           hi tcohen
12:05 drojf           @wunder berlin, germany
12:05 huginn`         drojf: The current temperature in Berlin Tegel, Germany is 22.0°C (1:50 PM CEST on June 16, 2016). Conditions: Mostly Cloudy. Humidity: 43%. Dew Point: 9.0°C. Pressure: 29.65 in 1004 hPa (Rising).
12:07 mveron          Hi again #koha
12:22 tcohen          hi mveron
12:22 mveron          hi tcohen
12:27 magnuse         @wunder boo
12:27 huginn`         magnuse: The current temperature in Bodo, Norway is 11.0°C (2:20 PM CEST on June 16, 2016). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 8.0°C. Pressure: 29.83 in 1010 hPa (Steady).
12:27 magnuse         ooh, i beat tcohen
12:27 tcohen          yes! its cold here!
12:37 magnuse         tcohen: is it normal for this time of year?
12:37 magnuse         btw, your winter, my summer ;-)
12:37 tcohen          exactly
12:37 blou            Hey Cait, thanks a lot for your hint about LDAP bug 8993 yesterday.  Saved my bacon.
12:37 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8993 enhancement, P5 - low, ---, julian.maurice, Needs Signoff , LDAP authentication improvements: multiple branch and transformation modules
12:45 druthb          @wunder 77098
12:45 huginn`         druthb: The current temperature in Montrose (Mandell Place), Houston, Texas is 27.2°C (7:45 AM CDT on June 16, 2016). Conditions: Overcast. Humidity: 93%. Dew Point: 26.0°C. Pressure: 29.98 in 1015 hPa (Falling).  Heat advisory in effect from 10 am this morning to 7 PM CDT this evening...
12:45 druthb          Jealous, tcohen?  Nice and warm here.
12:46 tcohen          druthb: definitely!
12:46 drojf           not sure if 27° at 7:45am qualifies as nice
12:46 tcohen          if it was 5pm for my tennis match it would be awesome
12:47 drojf           hehe
12:47 druthb          with the humidity later, it'll feel like about 41, come mid-afternoon
12:47 drojf           nice tennis weather. erghs
12:47 druthb          I'm not saying it's hot or anything, but two hobbits threw a ring into my back yard yesterday.
12:48 oleonard        :P
12:48 druthb          (thought it was bag, at first.)
12:55 liw             druthb, haha
13:20 oleonard        I wonder if we should prevent the creation of budgets with duplicate names
13:22 oleonard        Related: When we duplicate a budget, should we add something to the duplicated budget description? "Copy of X" or "X (2)" or something like that?
13:24 magnuse         oleonard: in general, that sounds like a good idea
14:16 bag             @later tell rangi - So last night in my dreams - I kept riding in taxi’s and whenever I got to where I arrived you came out of nowhere and paid my taxi bill - then looked at me and said - hi - I need more champange and ran off to get more.  Had me laughing… random
14:16 huginn`         bag: The operation succeeded.
14:43 cbrannon        kidclamp: when you get a moment, check out bug 16756.
14:43 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16756 major, P5 - low, ---, koha-bugs, NEW , Can't link guarantor when guarantor has apostrophes in record
14:43 kidclamp        @later tell Joubu can you check the comment on 14874 and let me know your thoughts?
14:43 huginn`         kidclamp: The operation succeeded.
14:44 kidclamp        is that causing issues for you cbrannon?
14:44 cbrannon        Yes.  Staff keep bumping into it.  I just tested scenarios and posted the bug.  Really weird conditions.  And of course our library AND city have apostrophes in the names.
14:46 kidclamp        does that trigger it for patrons without the apostrpohe anywhere?
14:46 kidclamp        that bug got tied into the prevent xss bug, but that was reverted and I am not sure the current status
14:46 kidclamp        anyone know?
14:47 bag             XSS was reverted - we’ve been sort of picking at little parts of that though
14:49 cbrannon        kidclamp: not sure of your question.  If there are no apostrophes in the record (at least in the city and library that show on the search results), you can search by name or card number and link just fine.
14:49 kidclamp        sorry cbrannon I was wondering if all patrons at library with ' are affected, or only if they have ' in other parts of their record
14:51 cbrannon        It's patrons with either an apostrophe in the city or in the library name.  Doesn't have to be both.
14:51 kidclamp        okay, got it
14:51 kidclamp        will look into that today
14:52 cbrannon        Awesome.  Really bizarre on the conditions, and especially in the manner the patron is searched for if it is just the library name.
15:35 LibraryClaire   laters #koha
15:53 reiveune        bye
16:10 kyr_stefanidis  aloha
16:14 kyr_stefanidis  A quick question. Now that 16.05 is live, "oldstable" dist (the one that i always use for production servers) points to 3.22. Is there anyway to change my package inst sources so that they keep updating 3.20 instead of upgrading to 3.22?
16:16 kyr_stefanidis  hmm... hoping into irc for just for a question seems not polite. I ll take it to the mailing lists instead
16:17 drojf           kyr_stefanidis: there are no packages for 3.20 any longer
16:18 drojf           we only have packages for the last two branches. however 3.20 is still supported, you could build your own packages for deployment
16:18 kyr_stefanidis  oh well, thank you for the answer. It seems I ll have to upgrade to 3.22 asap then
16:18 drojf           and coming to irc for a question is fine, it just may take a while to get an anwer
16:19 drojf           so you have to stay a little and see if people have an answer ;)
16:19 kyr_stefanidis  I was prepared or a long wait (coffe, coockies and such). the answer came faster than anticipated :)
16:19 drojf           hehe
16:20 drojf           ok gotta go. later #koha
16:35 Shane-S         Does Koha track "last seen" meaning a book that was scanned with check-in but had no check-out, to verify it is still in possession?
16:36 Shane-S         If it does, I assume there is a report for it..any clue what it is called? I am on https://wiki.koha-community.org/wiki/SQL_Reports_Library#All_Checked_Out_Books and not sure what I am looking for there.
16:36 eythian         Yeah, there's a field in the table for that.
16:36 eythian         I forget what it's calledb though
16:36 eythian         Look for info on stocktaking
16:37 eythian         (it uses this mechanism)
16:37 Shane-S         okay, I have chromebooks entered into Koha, and I am trying to see what spares Koha says I should have, and what I actually have by re-scanning and then searching for ones "not seen" in over 9 months
16:39 Shane-S         I guess thinking about it, I should check them out to myself and then back in each year
16:43 oleonard        kidclamp still around?
16:44 kidclamp        sortof in meeting so will be slow
16:44 oleonard        kidclamp: I just wanted to mention that I have a patch that I think will fix bug 16756. I'll see if I can get it ready today.
16:44 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16756 major, P5 - low, ---, koha-bugs, NEW , Can't link guarantor when guarantor has apostrophes in record
16:45 kidclamp        oh sweet
16:45 kidclamp        that would be incredibly helpful, you post it I'll sing off
16:45 kidclamp        oleonard++
16:46 oleonard        (yet another reason to avoid 'onclick', I'm pretty sure)
17:11 oleonard        kidclamp: It wasn't an in-progress patch I was thinking of, it was Bug 16450, which hasn't been picked up for 3.22.x
17:11 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16450 enhancement, P5 - low, ---, oleonard, Pushed to Master , Remove the use of "onclick" from guarantor search template
17:13 kidclamp        ah, I thought it was working in master but hadn't dug in
17:15 drojf           evening
17:21 barton          rt 26521
17:22 oleonard        barton: We don't serve /those/ droids here
17:34 MauricioB-ECU   hello everyone...
17:35 oleonard        Hi MauricioB-ECU
17:36 MauricioB-ECU   i just want to say is nice to join the group
17:36 MauricioB-ECU   i'm new in kiha world
17:36 MauricioB-ECU   :)
17:36 MauricioB-ECU   sorry my poor english
17:37 oleonard        Welcome, MauricioB-ECU. Don't worry about your English. it's an international group here.
17:37 oleonard        Where are you from?
17:38 MauricioB-ECU   Ecuador
17:38 MauricioB-ECU   thanks
18:05 drojf           hi MauricioB-ECU
18:36 oleonard        Bug 3477
18:36 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3477 enhancement, P5 - low, ---, gmcharlt, CLOSED WONTFIX, Store patron OPAC passwords in plain text
18:37 oleonard        Ah, memories!
18:38 oleonard        I can't imagine what kind of other garbage they put into their software because they wouldn't say no to their customers.
18:38 drojf           wow. best bug ever
18:38 drojf           err, enhancement
18:40 drojf           maybe we can reopen it and discuss again
18:42 drojf           @seen jwagner
18:42 huginn`         drojf: jwagner was last seen in #koha 1 year, 17 weeks, 6 days, 23 hours, 16 minutes, and 49 seconds ago: <jwagner> #info Jane Wagner, PTFS
18:43 oleonard        Yeah jwagner stuck around for a long time not saying anything except to check in at meetings.
18:44 drojf           yeah and bring up apache license in the license discussion, as if that was an option ever considered
18:47 mveron          evening...
19:13 oleonard        Bye #koha
19:21 hector          Hi mveron
19:46 nuentoter       hello
19:46 wahanui         privet, nuentoter
19:49 nuentoter       could someone here help me with some sql?
19:50 pianohacker     depends on the sql ;)
19:52 pianohacker     ashimema_!
19:52 pianohacker     heyman
19:54 pianohacker     :(
19:55 nuentoter       im tyring to pull all bibs without records
19:55 nuentoter       SELECT biblionumber, title
19:55 nuentoter       FROM biblio
19:55 nuentoter       sorry didnt mean to paste in room
19:55 nuentoter       just switched to tiled wm and still getting used to keyboard shortcuts for everything
20:05 pianohacker     nuentoter: nice! which wm?
20:05 nuentoter       awesome
20:05 pianohacker     by bibs without records, do you mean bibs without items?
20:05 pianohacker     nuentoter: nice! I used that for a while and quite liked it. Switched to i3 a while back, but they're pretty close
20:06 nuentoter       yeah biblio records with no items
20:06 nuentoter       for some reason I have a handful of duplicates in my system when i look something up, and the duplicates have no items
20:07 nuentoter       so if i can round them up all together and delete them i should be good (i hope)
20:08 mtompset        Greetings, #koha.
20:08 pianohacker     nuentoter: SELECT ... FROM biblio LEFT JOIN items USING (biblionumber) GROUP BY biblionumber WHERE items.itemnumber IS NULL;
20:08 pianohacker     nuentoter: out of curiosity, are you familiar with the reports library?
20:09 nuentoter       nope im jumped into all of this semi-recently and am learning the hard way lol
20:10 pianohacker     reports library?
20:10 wahanui         it has been said that reports library is found at http://wiki.koha-community.org/wiki/SQL_Reports_Library
20:10 pianohacker     nuentoter: ^
20:11 nuentoter       ty ill be reading for a bit now :)
20:38 barton          does anyone know off hand whether it's now possible to use elastic on the sandbox sites?
20:38 drojf           barton: my guess is no
20:39 barton          that was going to be my guess as well, but I was hoping to be proved wrong :-)
20:55 nuentoter       where is this chat logged?
20:56 drojf           http://irc.koha-community.org/koha/today
21:01 nuentoter       df
21:02 nuentoter       
21:32 talljoy         hi #koha
21:32 talljoy         anyone in that has access to bug 14298
21:32 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14298 is not accessible.
21:32 rangi           yep
21:32 talljoy         i have an upgrade from 3.06 where the updatedatabase is failing on this part
21:32 talljoy         what should i be looking for on this?
21:33 rangi           what version are you updating too
21:33 talljoy         3.22.06
21:33 rangi           its pushed to stable, ill make the bug public now
21:33 talljoy         thx
21:33 rangi           there ya go
21:33 talljoy         yay me!!!
21:33 talljoy         thanks rangi!
21:34 rangi           @later tell bag that's totally plausible too
21:34 huginn`         rangi: The operation succeeded.
21:57 rangi           hmm i guess linode rebooted the server
21:59 rangi           right
22:00 rangi           so how the hell do you attach a pdf to a bib record in 3.22.x ?
22:02 drojf           rangi: in the framework, set the upload plugin for 856u
22:02 rangi           thank you
22:02 drojf           then you can add a file while cataloguing
22:02 rangi           ta
22:03 drojf           you may need to set the UPLOAD authorized value to some path before
22:16 magnuse         isn't there something like upload_path you need to set in koha-conf.xml, if it is not set?
22:16 rangi           yep, had set that bit
22:16 rangi           just didnt know where you went to actually upload, working now
22:17 magnuse         yay
22:17 magnuse         upload all the files, then! :-)
22:26 pianohacker     @later tell matts out of curiosity, why doesn't the staff CAS code append $query->script_name when building the service URL?
22:26 huginn`         pianohacker: The operation succeeded.
22:31 pianohacker     Joubu: did you sign off 16166 but not add your stamp to the commits?
23:10 * cait          waves
23:11 wizzyrea        hi cait