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