Time Nick Message 23:59 jcamins And I found them. 23:59 jcamins Ha! I did have! 23:58 jcamins I found charoli. 23:58 jcamins dcook: no, I'm not saying "I don't think I have any cacao nibs," I'm saying "I have absolutely no idea whether I have cacao nibs." 23:55 dcook jcamins: That's probably where they are then 23:55 jcamins Here's the problem: I'm not sure I have any cacao nibs. 23:54 dcook For all Google's money and power, they sure make it hard to give useful feedback for bugs.. 23:51 dcook sorry :p 23:50 cait where did the bees go? 23:50 cait ew 23:49 drojf you know that there is no possible answer that does not involve the belly of a spider at this point 23:48 jcamins Now, here's a question: where are my cocoa nibs? 23:48 jcamins :D 23:48 jcamins You're welcome! 23:48 drojf thanks jcamins very helpful reminder. i think i might just stay up for a little longer to forget about that picture before i start dreaming 23:48 jcamins Ask anyone. 23:48 jcamins They're found only in Canada. 23:47 jcamins drojf: mutant ice spiders are more dangerous than other spiders. 23:47 drojf lol 23:47 dcook Spiders in parkas.. 23:47 dcook hehe 23:47 drojf unless, very furry spiders 23:47 dcook I do miss how there were no bugs in the cold 23:47 drojf in fact, cold kills spiders 23:47 * dcook thumbs up 23:46 drojf cold > spiders 23:46 dcook In Australia, I think we pretend that it's not insanely dangerous in some areas 23:46 dcook In Canada, I used to think that we pretended that it wasn't insanely cold outside 23:46 dcook Probably not 23:46 dcook hehe 23:46 drojf not sure if i want to know the numbers of *weirdanimal*-bites in general 23:46 dcook Sharks, snakes, spiders 23:45 dcook Oh, we also have sharks.. 23:45 dcook But really it's not that bad. When I moved here, I figured most people don't die from spiders and snakes, so I'll probably be fine 23:45 dcook "The Eastern brown snake is responsible for around 60% of deaths caused by snakebite in Australia." O_O 23:45 dcook February 23:45 drojf i blame spiders 23:44 dcook Although a little girl was killed by a snake a few months ago I think :( 23:44 dcook Actually, I think even the deadly Australian spiders haven't killed anyone in decades 23:44 dcook But a big buck could destroy a human 23:44 dcook Well deer can be deadly too... people think they're so cute 23:44 dcook Not that you usually have to worry about moose 23:43 dcook I think the only deadly things there are bears, wolves, cougars, and moose 23:43 dcook Yeah, that was me in Canada 23:43 dcook So if I see a big one, I encourage it to eat all the bugs :3 23:43 drojf i live in an area where spiders are just disgusting for being spiders, i don't expect anything to be deadly, but it creeps me out :P 23:43 dcook The little ones are the really awful ones I think 23:43 dcook The bigger the spider, the nicer they probably are 23:43 dcook Pretty much 23:43 drojf so you walk around and think "oh look there is that crazy huge spider but i know it is not deadly so i don't care at all"? 23:42 dcook "Bringing a boat? Saltwater crocodiles can attack people in boats - the smaller the boat the greater the risk. - See more at: http://www.parksaustralia.gov.au/kakadu/plan-your-trip/staying-safe.html#sthash.yRXrMOSJ.dpuf" 23:42 dcook http://www.parksaustralia.gov.au/kakadu/plan-your-trip/staying-safe.html 23:42 dcook Oh, we also have deadly crocadiles 23:41 dcook Of course, I'm a city dweller >_> 23:41 dcook I've seen more pretty birds than deadly things : ) 23:41 dcook Neither was in my house either 23:41 dcook I think I've only seen maybe two deadly spiders, and they stayed in their corners indeed 23:41 dcook It's actually not that bad overall 23:41 dcook hehe 23:40 drojf *in 23:40 drojf "this picture shows 75187 spiders, but they are not that huge and usually stay on their corners" 23:39 drojf :D 23:39 drojf ever 23:39 drojf not going there 23:39 drojf a friend of mine has been to australia and nope 23:38 dcook Spider web in the face in Australia is a bit terrifying 23:38 dcook Or walking into spider webs in the garden at my old place... 23:38 * dcook doesn't miss finding spiders in his towels after showers in Vancouver.. 23:37 dcook drojf: I was just thinking about that 23:37 cait bees are prettier than spiders 23:37 drojf i am not sure but i think i am quite happy that spiders don't have a sound 23:36 dcook And bees do sound nice 23:35 dcook Honey is pretty great 23:35 dcook hehe 23:35 drojf unless you poke and stuff :D 23:35 drojf bees are nice! 23:35 drojf you can have all the spiders 23:35 dcook Spiders more than bees 23:34 dcook I can handle snakes more than bees 23:34 dcook Bees are one of the few things that I just... nope 23:34 dcook Thanks for your email drojf :) 23:34 dcook O_O 23:33 * wizzyrea cries 23:33 drojf wizzyrea: that's how the web works 23:32 wizzyrea this page on the website, I poked it and out came an entire hive of bees. 22:59 huginn wizzyrea: The operation succeeded. 22:59 wizzyrea @later tell joubu rangi sorted the download links thanks for pointing out that problem 22:42 wizzyrea rangi++ for fixing the 16.11 download links 22:21 drojf hmpf the nightly build server ran out of disk space. apparently upgrading two pbuilder images to jessie made the difference. lol 22:18 drojf hi bag and cait 22:18 * cait waves 22:16 wahanui afternoon is good 22:16 bag afternoon 22:16 drojf evening 20:47 huginn wizzyrea: The operation succeeded. 20:47 wizzyrea @later tell joubu I don't routinely manage that but I will have a look. Hopefully someone else has sorted you out by now. 19:38 LibraryClaire hi rangi 19:26 oleonard Hi rangi 19:23 drojf hi rangi 19:21 rangi morning 18:00 cait 16.11 was released yesterday - 3.20, 2.22, 16.05, 16.11 - 2 years 18:00 cait it's old by now 18:00 cait i am not sure 3.18 can do all that yet 17:59 jc_ cait: but it's not in the marc framework? 17:59 cait kf 17:53 cait jc_: you can catalog using 264 and it will be searchable and show up in the result lst and on the detail pages 17:44 jc_ Hi, my library is using Koha 3.18, and i'm just wondering if newer versions have the tag 264 included yet 17:12 reiveune bye 15:57 bag morning 15:48 drojf Joubu: makes sense. i'll roll a package with it and leave feedback on the bug. thanks! 15:38 khall thanks Joubu! 15:35 Joubu drojf: and so you should be able to add the FK 15:31 drojf which i guess is a good thing ;) 15:31 drojf Joubu: can't roll back the whole db atm to try, but running it manually makes the update affect 23646 rows instead of 0 15:30 Joubu s/because/before 15:29 Joubu drojf, khall: I have attached a followup on 17216, I am 99% sure it comes from this typo, but I'd like to get drojf confirmation because to see it pushed 15:23 drojf ah yes that looks odd 15:23 Joubu well, you got it 15:23 Joubu =';'; 15:22 Joubu and can you retry the whole upgrade after modiying l. 13171 with WHERE authorised_value = ""; # instead of =";" 15:21 drojf i get 0 for that select query. in case you wanted me to run it 15:21 Joubu because of the wrong query 15:21 Joubu I guess you have some marc_subfield_structure.authorised_value="" which have not been set to NULL 15:21 Joubu f**** nopaste vi mode 15:21 drojf sorry grabbed a coffee 15:19 Joubu ='' instead of =';' 15:19 Joubu this looks definitely wrong 15:19 Joubu 13171 UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = ';'; 15:17 Joubu drojf: ^ 15:17 Joubu select count(*) from marc_subfield_structure where authorised_value not in (select distinct(authorised_value) from authorised_value_categories) 15:16 Joubu It cannot add the constraint on marc_subfield_structure 15:15 Joubu drojf: ok don't get it, but I know what I think 15:12 drojf i have not tried a new install. but i got this on two different systems 15:12 Joubu let me test 15:12 drojf yes 15:12 Joubu So I should get it updating an old DB, right? 15:12 drojf Joubu: by upgrading a 16.05 package install to 16.11 15:11 Joubu drojf: how do you get this error? 15:05 LibraryClaire laters #koha 15:05 LibraryClaire gotta run - literally 15:04 drojf thanks Joubu and khall 15:04 khall thanks Joubu! 15:03 Joubu khall: ^ :) 15:03 Joubu drojf: I will be on it soon 15:03 khall Joubu: did you see what drojf posted? I can't get the error to happen : \ 15:03 khall drojf: ack! 15:01 AndrewIsh Joubu: yep, makes sense 15:01 drojf khall: got it on two upgrades from 16.05 :/ 15:01 Joubu AndrewIsh: it's preferable to whitelist it on a separate bug 15:00 AndrewIsh Joubu: huzzah! 15:00 Joubu nope, it's the way to go, you are just the first one to need it :) 15:00 AndrewIsh Joubu: yes, so i gather from @ashimema, i just wanted to check i wasn't missing something ;-) 14:59 khall drojf: I haven't been able to trigger that error you are getting : \ 14:59 barton oh, that happened to me 20 years ago. I was headed for St. Louis. 14:59 Joubu AndrewIsh: yes, so you need to provide tests 14:58 AndrewIsh Joubu: it's not a whitelisted method on Koha::Objects 14:58 oleonard Where you headed? 14:58 barton ... it's coincidence when it comes on the radio the day after your birthday when you're making a long distance drive for thanksgiving... 14:57 AndrewIsh Joubu: i wanting to call it on the Koha::Objects set, to get all values from a column, as in: my @barcodes = $results->get_column('barcode')->all; 14:57 oleonard Youtube knows. 14:57 barton which spookily was the first suggestion by youtube when I started looking up Paul Simon. 14:55 barton https://www.youtube.com/watch?v=GVwTbWmOsfw <= the 'Day after the birthday' song. 14:55 Joubu AndrewIsh: get_column should be called on a Koha::Object, not a set, right? 14:53 barton ah, thanks! 14:52 oleonard A belated Happy Birthday to you 14:52 oleonard Hi barton 14:45 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17216 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Add a new table to store authorized value categories 14:45 drojf i added it to bug 17216. i will not release a package before i get an answer :P 14:44 AndrewIsh anyone who's up to speed on Koha::Objects around? i'm trying to call ->get_column() on the return of a Koha::Items->search() call. i'm getting undef returned. looking at the AUTOLOAD sub for Koha/Object.pm, i can see that get_column is one of the whitelisted methods 14:41 rsantellan the best thing to do is separate the alter column and the fk creation 14:40 rsantellan it could mean that or that the default values of the field is incorrect 14:40 eythian I think it often means that making this change would break a foreign constraint, or something like that 14:39 eythian but, you may well see a fair bit of it. 14:39 eythian I've seen it a bit, with no real understanding of what was happening. 14:39 eythian error 150 is a very annoying one to diagnose 14:34 drojf there will be a few thousand people asking about it soon 14:34 drojf asking again, should i be concerned about this? ^ 14:34 pastebot "drojf" at 127.0.0.1 pasted "16.11 upgrade mysql error" (7 lines) at http://paste.koha-community.org/181 14:29 magnuse oh and bag++ khall++ 14:29 * magnuse calls it a day - have fun #koha! 13:08 Viktor_ Might go home early now before anything breaks again ;) 13:07 magnuse jätteskönt! 13:07 rsantellan jajaja :) 13:06 Viktor_ Best day at work for a long time - thanks a lot! 13:06 magnuse lol 13:05 Viktor_ I literally jumped and hit my hand on the roof just now :) 13:05 Viktor_ rsantellan magnuse YAY!!!! 13:04 magnuse sudo koha-plack --restart kohadev 13:03 rsantellan Viktor_: try with sudo koha-plack 13:03 Viktor_ Is there a way to restart plack in kohadevbox (if it’s active). I tried koha restart —plack as the Debian packages suggest but it’s an unknown command. 13:01 Viktor_ It’s there when I open it again, and the files lists as modified by â€git statusâ€. So I hope so :) 13:01 magnuse you're sure you saved your edit? ;-) 13:00 magnuse ah, interesting 12:54 Viktor_ magnuse Smart - and no I didn’t! 12:52 magnuse try "wget localhost" inside the devbox and see if you see the changes there? 12:51 Viktor_ I’m trying to break the intranet instead and we’ll se if something happens. 12:51 magnuse maybe things were changed 12:51 magnuse i do not have an uptodate kohadevbox 12:51 magnuse weird, then :-) 12:51 Viktor_ magnuse Thanks. I do get the opac at 8080 12:50 cait hm mine works on 8080 and 8081 12:50 magnuse and "8080 (guest) => 8081 (host) (adapter 1)" 12:50 magnuse Viktor_: the two interesting lines are "80 (guest) => 2201 (host) (adapter 1)" 12:49 pastebot "magnuse" at 127.0.0.1 pasted "vagrant up" (23 lines) at http://paste.koha-community.org/180 12:47 magnuse hm, let me check what mine sets up 12:44 Viktor_ But at least I’m not making any really obvious mistakes then. Ports seems to be correct (8080 opac, 8081 intra) 12:44 * druthb gives magnuse the evil eye, too 12:44 magnuse or, "the nominee", as we like to call her 12:44 * druthb gives wahanui the evil eye. 12:43 wahanui hmmm... druthb is an amazing person 12:43 magnuse druthb! 12:43 wahanui magnuse is afraid that we added another 10000 bugs while he was eating pizza. 12:43 druthb magnuse! 12:41 magnuse yeah, tcohen and others have really pushed it along 12:41 Viktor_ Saw that kohadevbox got a new version the other day so thought I’d give it a try. Very nice actually. 12:40 magnuse yeah, scroll back through the output from "vagrant up" 12:40 Viktor_ Not sure it’s the right one though :) Will have to look at the output. 12:40 Viktor_ Hm. It gives me some Opac on 8080 12:39 magnuse s/pr/or/ 12:39 magnuse pr opac on 2201, maybe 12:39 Viktor_ magnuse I tried â€sudo service memcached restartâ€. No output and no difference. 12:39 magnuse often opac on 2200 and intranet on 8081, i think 12:38 magnuse the output that you get from "vagrant up" will say how ports are set up 12:38 magnuse are you looking at koha from the right port? 12:37 magnuse try "sudo service memcached restart"? 12:37 magnuse ah, looking at the swedish templates was my first guess 12:37 Viktor_ cait It’s nice to be back! But also very nice to see swedish libraries taking charge and establishing a network that’s now very active. 12:36 cait we missed you 12:36 Viktor_ Don’t know actually - I’m using what’s default in kohadevbox :) But you are right - it feels like a caching problem (since there is only â€en†installed) 12:35 Viktor_ Hi cait Nice to see you too! 12:34 cait also: are you looking at the english templates? (one of my errors often...) 12:34 cait restating those might make it work 12:34 cait Viktor_: are you using plack or memcached? 12:32 cait nice to see you around :) 12:32 * cait waves at Viktor_ 12:31 Viktor_ Thanks for the help AndrewIsh - Have the feeling it’s something really obvious that will make me embarresed when I figure it out :) 12:31 siriom signing up to the mailing list then 1 sec 12:29 AndrewIsh Viktor_: Interesting. I'm not sure then, that's a weird one. Sorry! 12:27 Viktor_ AndrewIsh Then SSH and used pico to edit opac-main.tt (changed the â€Home†bredcrumb on a new branch just to see that it worked). 12:26 Viktor_ AndrewIsh Thanks! Actually I haven’t touched SUNC_REPO. Only configured my name, email and bz login. 12:25 AndrewIsh Viktor_: https://github.com/digibib/kohadevbox#user-content-sync_repo 12:25 Viktor_ siriom You have the general list and perhaps the devlist accessible from https://koha-community.org/support/koha-mailing-lists/ Just sign up and ask away. Then you’re not as dependent on catching the eye of someone at the right moment. Best of luck 12:23 AndrewIsh Viktor_: Your devbox problem is interesting. I've been using it for about a month and was immediately able to see changes when editing files in ~/kohaclone. Have you perhaps modified your SYNC_REPO env variable? 12:22 siriom morning 12:22 siriom ok , how do i sent it to the list ? im a first time user here chief. 12:22 rsantellan good morning #koha 12:22 siriom the database is fine , i just checked ... 12:22 Viktor_ siriom Well I’m not really qualified to answer that I’m afraid :( I guess sending a question to the list might give better results. But be prepared for the answer â€Use Debian like recommended and it’ll workâ€. 12:20 siriom great so what do i do to check / fix it ? 12:18 AndrewIsh Is there some magical incantation for calling dbic methods on Koha objects? 12:17 Viktor_ siriom Only search? That narrows it a tiny bit at least. If everything is the same otherwise I’d suspect some library that Zebra uses has changed in suse 12:17 pastebot "AndrewIsh" at 127.0.0.1 pasted "my $items = Koha::Items->searc" (6 lines) at http://paste.koha-community.org/179 12:17 AndrewIsh Hey all. Does anyone know if it's possible to call DBIx::Class::ResultSet methods on Koha::Items objects? As per the code below: 12:15 siriom utf 8 but where ? everything does seem to be utf8 12:15 siriom locale issue ? perl issue ? been banging my head on it and can t find the answer 12:15 Viktor_ Sounds like some character encoding problem that I’m not quilified to answer. I just configure it to UTF-8 wherever there is an option and hope for the best :) 12:14 siriom diamond with a question mark inside instead of say "ç" or "ã" 12:14 siriom had koha running on suse 12 , upgraded to suse 13 and now searchs return weird diamonds instead of special latin chars 12:13 Viktor_ What’s your problem? Maybe I know who knows what to do at least :) 12:13 siriom morning chief. 12:13 Viktor_ morning siriom 12:12 siriom anyone want to give a poor soul a hand with a koha problem ? 12:11 wahanui Ah, morning. The cat must be wanting breakfast. 12:11 siriom morning. 12:09 Viktor_ Any help appreciated - I haven’t got my sea legs with kohadevbox for sure :) 12:07 Viktor_ KohaDevbox - is it the files in the kohaclone dir I’m supposed to edit? I’m trying to learn to use kohadevbox instead of my old dev install. Got a new box up, SSH into it, cd kohaclone, new branch and edited kohaclone/koha-tmpl/opac-tmpl/bootstrap/modules/opac-main.tt. But when I update localhost:8080 I see no change even after clearing caches. What obvious thing am I missing?… 09:43 huginn eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 10.9°C (10:31 AM CET on November 23, 2016). Conditions: Mist. Humidity: 80%. Dew Point: 8.0°C. Pressure: 30.07 in 1018 hPa (Rising). 09:43 eythian @wunder jordaan, ams 09:15 alex_a bonjour again magnuse :D 09:15 Viktor_ Bonjour magnuse 09:14 magnuse bonjour alex_a and Viktor_ 08:57 AndrewIsh Joubu: indeed. i spent some time yesterday afternoon unpicking it but still couldn't figure out exactly how it worked. thanks for the pointers, i'll have a look at that table and sub, it'll be useful to know what's going on in the background :) 08:56 Joubu but you should not need that for basic/normal permission checks 08:55 Joubu Have a look at borrowers.flags and C4::Auth::haspermissions, if you want to go deeper 08:55 Joubu AndrewIsh: the tricky part is when you want to understand how things are going on behind the first trees you see 08:53 AndrewIsh cool, i think i understand now, i'll go and give it a try. thanks Joubu :) 08:53 AndrewIsh ahaaaaa, right, that makes sense. so that enables you to distinguish between permissionX on different areas of the application, makes sense 08:50 Joubu (what you said basically) 08:50 Joubu then a list of permissions for this "module": permissions.code (create_reports, delete_reports for instance) 08:49 Joubu there is a "module" which is the userflags.flag column (reports for instance) 08:48 Joubu AndrewIsh: have a look at the userflags and permissions table 08:46 AndrewIsh i've been looking at those, there appears to be multiple levels to it, just looking at biblio-view-menu.inc, it has "CAN_user_tools_view_system_logs", there's a permission called "view_system_logs", is the "user_tools" some sort of higher level? 08:45 Joubu (a 'add' was missing in one of my previous sentence) 08:45 AndrewIsh aha, that was going to be my next question 08:45 Joubu `git grep CAN_ **/*.tt` for the examples 08:45 AndrewIsh Joubu: ah, excellent, i will, thanks :) 08:45 Joubu then to know if the logged in user has the permission, from the template you can do something like CAN_module_permission 08:44 Joubu if it's what you want, take a look at db rev 3.23.00.052 08:43 Joubu you may want to this permission to existing users 08:42 Joubu that's all 08:42 Joubu add it to installer/data/mysql/userpermissions.sql 08:41 AndrewIsh but beyond that, i'm not sure what else to do 08:41 AndrewIsh and added appropriate lines to koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc 08:41 AndrewIsh we've created a db update script to add the permissions to the permissions table 08:40 AndrewIsh is anyone able to point me in the direction of any docs detailing the necessary steps for creating new permissions and binding to them in the templates? 08:40 huginn AndrewIsh: The current temperature in Machynlleth, Machynlleth, United Kingdom is 6.2°C (8:39 AM GMT on November 23, 2016). Conditions: . Humidity: 93%. Dew Point: 5.0°C. Windchill: 6.0°C. Pressure: 30.06 in 1017.8 hPa (Rising). 08:40 AndrewIsh @wunder machynlleth 08:39 AndrewIsh mornin' #koha 08:37 huginn Joubu: The operation succeeded. 08:37 Joubu @later tell khall I guess you are already aware of it but the release notes have not been attached to your email 08:33 huginn Joubu: The operation succeeded. 08:33 Joubu @later tell wizzyrea don't know if you can do someting but http://download.koha-community.org/koha-16.11.00.tar.gz returns 403 08:32 Joubu http://download.koha-community.org/koha-16.11.00.tar.gz returns 403 08:29 Joubu in a pdf format for instance 08:29 wahanui the release notes are in misc/release_notes 08:29 Joubu Does someone know where are the release notes? 08:29 Joubu https://github.com/Koha-Community/Koha/blob/master/misc/release_notes/release_notes_16_11_00.md 08:20 gaetan_B hello 08:13 huginn drojf: The current temperature in Berlin Schoenefeld, Germany is 5.0°C (8:50 AM CET on November 23, 2016). Conditions: Mist. Humidity: 100%. Dew Point: 5.0°C. Pressure: 30.09 in 1019 hPa (Steady). 08:13 drojf @wunder sxf 08:13 drojf mtj: looks like most were needed for debian squeeze, some for wheezy but only 1/3 is still needed for jessie. time for some cleaning 07:55 alex_a hello LibraryClaire and magnuse 07:54 sophie_m hi #koha 07:53 sophie_m hello magnuse 07:53 magnuse bonjour sophie_m 07:53 mtj heia magnuse, reiveune 07:52 reiveune salut magnuse 07:52 magnuse bonjour reiveune 07:51 reiveune hello 07:50 magnuse kia ora mtj 07:42 mtj drojf: awesome news re: packages... that sounds like progress hey? :0) 07:42 mtj hey #koha 07:41 LibraryClaire had a glowing yellow sunrise behind the mountains this morning. very nice. I need a better camera 07:41 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is 8.5°C (8:39 AM CET on November 23, 2016). Conditions: Clear. Humidity: 94%. Dew Point: 8.0°C. Windchill: 8.0°C. Pressure: 30.01 in 1016 hPa (Steady). 07:41 LibraryClaire @wunder Konstanz 07:40 * LibraryClaire waves 07:40 magnuse and that rain has frozen on the ground - very nice 07:40 huginn magnuse: The current temperature in Bodo, Norway is 2.0°C (8:20 AM CET on November 23, 2016). Conditions: Light Rain Showers. Humidity: 100%. Dew Point: 2.0°C. Windchill: -2.0°C. Pressure: 29.74 in 1007 hPa (Steady). 07:40 magnuse @wunder enbo 07:39 alex_a bonjour 07:12 LibraryClaire morning #koha 06:48 * magnuse waves 06:16 drojf nice, 2/3 of the dependency packages in the repository are not needed anymore 06:11 drojf morning #koha