Time Nick Message 06:47 drojf bonjour 06:47 wahanui hello, drojf 07:02 gaetan_B hello 07:04 LibraryClaire hi gaetan_B 07:09 oleonard Hello all 07:13 * oleonard seems to be able to connect to irc and nothing else... 07:17 LibraryClaire o/ oleonard 07:17 oleonard Ahoj! 07:25 nlegrand Hello ! 07:46 tcohen hi dcook 07:47 tcohen @seen dcook 07:47 huginn tcohen: dcook was last seen in #koha 8 hours, 56 minutes, and 58 seconds ago: <dcook> One of these days I'll go to Marseille for the hackfest.. 07:49 * cait waves 07:57 drojf @later tell dcook you should set bug 17411 to signed off 07:57 huginn drojf: The operation succeeded. 07:59 tcohen bug 17411 07:59 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17411 minor, P5 - low, ---, veron, Needs Signoff , Change exit 1 to exit 0 in acqui/basket.pl to prevent Internal Server Error 08:07 Joubu query tcohen https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=56121 08:07 Joubu it looks like a / is missing... 08:17 Joubu matts: do you remember why 9a3950f673 adds the psgi:exit stuff? 08:21 alex_a drojf: Are you the one who ask me for a test plan on Bug 17047 ? 08:21 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047 new feature, P5 - low, ---, morgane.alonso, ASSIGNED , Mana webservice : share and use common information between Kohas 08:23 matts Joubu, can you be more specific ? 08:23 alex_a i don't remenber the nick of nick (the Britney Spears singer) 08:23 alex_a remember 08:23 drojf alex_a: i don't think so 08:24 alex_a sorry 08:24 drojf alex_a: kidclamp 08:24 wahanui hmmm... kidclamp is rockin the stache 08:24 alex_a yes! 08:24 matts :) 08:24 alex_a @seen kidclamp 08:24 huginn alex_a: kidclamp was last seen in #koha 1 day, 17 hours, 27 minutes, and 27 seconds ago: <kidclamp> thanks drojf 08:25 Joubu matts: no 08:26 Joubu matts: so you don't I guess? 08:26 matts Joubu, I don't know which lines you're talking about 08:27 Joubu matts: git show 9a3950f673; /psgi 08:40 marcelr hi #koha 08:40 marcelr hi marseille 08:43 cait hi marcelr :) 08:43 marcelr :) 08:44 cait quiet hacking this morning 08:44 eythian hi marcelr, cait 08:44 eythian @wunder ams 08:44 huginn eythian: The current temperature in Schiphol, Badhoevedorp, Netherlands is 9.2°C (10:37 AM CEST on October 13, 2016). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 6.0°C. Windchill: 8.0°C. Pressure: 30.09 in 1019 hPa (Steady). 08:44 marcelr hi eythian 08:44 eythian @wunder marseille 08:44 huginn eythian: The current temperature in Lotissement le Pitalugue, Vitrolles, France is 15.8°C (10:43 AM CEST on October 13, 2016). Conditions: Overcast. Humidity: 69%. Dew Point: 10.0°C. Pressure: 29.68 in 1005 hPa (Steady). 08:45 eythian seems a bit unfair 08:45 marcelr 15 ? 08:45 wahanui 15 is fine by me 08:45 marcelr should be 20+ 08:46 cait yeah 08:46 cait the weather report lied to us :( 08:46 cait it said like 20 for all week when I checked on Sunday 08:47 marcelr no beach sessions this week ? 08:51 kidclamp Joubu bug 15438 when you have a moment 08:51 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15438 critical, P3, ---, colin.campbell, Needs Signoff , Checking out an on-hold item sends holder's borrowernumber in AF (screen message) field. 08:52 cait doesn't look like it 08:56 alex_a kidclamp: Test plan available => Bug 17047 08:56 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047 new feature, P5 - low, ---, morgane.alonso, ASSIGNED , Mana webservice : share and use common information between Kohas 09:11 cait OPL is live now! :) *plays with new opac* 09:12 nlegrand cait: for France you can use the Meteo Agricole http://www.lameteoagricole.net/ farmers really need to know when it will rain and at what hour precisely :) 09:12 cait bit late now - better to know when you pack :) 09:12 magnuse cait: they have been for 27 hours :-) 09:12 cait it's still good news :) 09:18 magnuse cait: yes! 09:19 magnuse cait: it super duper absolutely awesome 09:21 nlegrand What's OPL ? :) 09:23 eythian oleonard public library 09:23 oleonard :P 09:23 eythian sorry, oleopard public library 09:23 oleonard That's better 09:36 LibraryClaire :D 09:42 cait hehe 10:12 bag morning 10:12 marcelr hi bag 10:15 bag matts: http://enchroma.com 10:31 magnuse OPL is Oslo Public Library, a.k.a. Deichman 10:31 eythian I preferred my version. 10:35 oleonard @wunder 45701 10:35 huginn oleonard: The current temperature in Heatherstone, Athens, Ohio is 13.8°C (6:35 AM EDT on October 13, 2016). Conditions: Rain. Humidity: 96%. Dew Point: 13.0°C. Pressure: 30.10 in 1019 hPa (Steady). 10:36 cait tcohen++ :) 11:43 nlegrand magnuse: thanks :) 11:44 magnuse nlegrand: no problem 11:54 nlegrand What's terrible about OPL is that my library want the same thing now. I can't tell them anymore is something form the futuristic future that no one has ever seen or done. 12:15 nlegrand if you change something in the db, should you provide the changes to Koha::Schema::Result::* in the patch ? 12:18 bag no the RM will run that when he pushes the patch 12:18 bag if i understand correctly 12:18 nlegrand bag: ok thanks! 12:19 petter hi koha! 12:19 oleonard Hi petter 12:19 cait nlegrand: if you want to make it easier for testes, you can do it in a separate patch, easy to throw that out if it no longer applies and redo 12:20 cait hi petter! 12:20 cait how is it going? 12:20 petter it's going better than feared! 12:20 petter some troubles of course, but all in all I'm releaved 12:21 Joubu LibraryClaire: 16966 16852 12:21 tcohen khall: http://formatjs.io/ 12:23 Joubu LibraryClaire: I am rebasing 16966 12:25 magnuse nlegrand: it's all on github :-) 12:26 magnuse petter: awesome! 12:26 wahanui That'll be €1 for the awesome jar, magnuse 12:26 magnuse don't be afraid to ask if there are koha problems :-) 12:32 petter Operations are running as normal, with 10-20 thousand transactions a day 12:33 petter Our biggest problem is the datatables patrons search 12:33 magnuse uh huh? 12:33 petter It generates som insane SQL queries which almost kill or MysQL 12:33 petter like this https://gist.githubusercontent.com/boutros/db14414591ea77638b2a3a183a18ec00/raw/d59f7ef33890b7a034f24a0d350b5af3b6257e4e/bigquery.sql 12:34 petter (only a small part of the query) 12:34 magnuse why on earth would it do that? 12:35 petter Because it has pagination, and needs a count of all hits 12:35 petter enumaring all possible hits 12:35 petter if you search with wildcard 12:35 magnuse ah, wow 12:35 petter that means several hundred thousand in our case 12:35 petter sorry my spelling! 12:36 magnuse speling s phine 12:36 petter :) 12:36 magnuse maybe something khall can fix with react? :-) 12:37 oleonard petter: Not that this excuses your problem, but is it necessary to search using wildcards? I thought it didn't search for an exact match 12:41 Joubu petter: I put it in my todo list 12:42 petter oleonard: sure we're trying to instruct our staff now 12:42 petter Joubu: thanks! 12:42 petter Anyone else with a lot of patrons - haven't you had problems with slow queries in patron search? 12:42 Joubu petter: the thing is that, if the extended patron attributes pref is set, we first search on the attributes 12:42 eythian should migrate the patron search to ES :) 12:43 Joubu we retrieve the borrowernumber which match this first search 12:43 petter but the pagination is insane 12:43 petter wy return more that 10 hits? 12:43 Joubu then search for the patterns in all other patron fields 12:43 petter If I got 100,000 hits I should refine my search, not browse to page 75,00 12:43 Joubu that's why you get this crazing query 12:44 petter oh, thanks for the info Joubu, I'll try turn of that syspref! 12:45 petter wow! 12:45 petter That solved our problem in an istance! 12:45 petter Kisses to #koha :) 12:46 Joubu petter: not sure it is what you want 12:46 Joubu if the extended attr are set, I guess you need them :) 12:46 petter We need them, but its more important not to crash MySQL 12:47 Joubu I don't really know how to fix it correctly 12:47 petter Give me some time to dig into the code 12:47 petter I will put a LIMIT somewhere :) 12:47 petter for us at least, we never care about more that 10 hits 12:47 Joubu if we limit the search on ext attr to 10* results, the results won't be accurate 12:48 petter hm, ok you probably know more here. But for now we just need a stable system, so for now I'll leave the syspref off 12:49 petter we have over 500,000 in borrower_attributes table, so it's too risky to allow generate those queries 12:49 pastebot "Joubu" at 127.0.0.1 pasted "diff --git a/C4/Members/Attrib" (13 lines) at http://paste.koha-community.org/135 12:49 Joubu petter: that should solve your problem ^ 12:49 Joubu Disclaimer: I did not test it! 12:49 petter Joubu: much appreciated! Will investigate and test it in our staging server 12:59 kidclamp bug 16520 rebased Joubu 12:59 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16520 minor, P5 - low, ---, jweaver, Signed Off , Per-virtualhost SetEnvs don't work with Plack 13:04 cait petter: maybe just mark the extended attributes as not searchable 13:04 cait instead of turning it off? 13:05 petter right 13:06 petter maybe better 13:09 tcohen <memcached_servers>127.0.0.1:11211</memcached_servers> 13:09 tcohen <memcached_namespace>koha_kohadev</memcached_namespace> 13:11 rsantellan good morning, I'm needing a little help with creating the debian packages. Do I need to run Makefile.PL before attempting the procedure of the wiki? 13:14 drojf rsantellan: which instructions are you following? 13:14 rsantellan drojf: https://wiki.koha-community.org/wiki/Building_Debian_Packages_-_The_Easy_Way 13:16 drojf rsantellan: you only need the git clone of koha and follow the instructions. if i understand the question correctly 13:17 rsantellan drojf: this is the error. make[1]: *** No rule to make target '/usr/lib/x86_64-linux-gnu/perl/5.22/Config.pm', needed by 'Makefile'. Stop. 13:22 drojf rsantellan: when doing what? 13:22 rsantellan drojf: sudo ./debian/build-git-snapshot -r ~/debian -v 16.05.04git -d 13:24 pastebot "rsantellan" at 127.0.0.1 pasted "Create deb error" (29 lines) at http://paste.koha-community.org/136 13:35 huginn New commit(s) kohagit: UPdating the DBREv for Bug 17216 - Add a new table to store authorized <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3fe925ee1900d607eca6eb8952430e02a85c4d24> / Bug 17216: Move the AV cat list file to the top level <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=493d7c30a194e78d0474f9db4824004fa410c879> / Bug 17216: Internal AV should be correctly handled when creating a new category <htt 13:57 magnuse Joubu++ for helping petter 15:02 bag NateC? 15:02 wahanui I LIKE SPACE AND MY WIFE 15:02 bag heh 15:05 oleonard If NatC's wife became an astronaut his brain would probably explode 15:06 pastebot "Joubu" at 127.0.0.1 pasted "diff --git a/t/db_dependent/Le" (26 lines) at http://paste.koha-community.org/137 15:06 huginn New commit(s) kohagit: Bug 16520: Allow per-VirtualHost environment variables with Plack <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1e6df24d6cbf44c865805712e6a15ecc601273aa> / Bug 7143 NEW added Kyle Hall as release manager. <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8cb65b367b47ffd9a1a362e7261199fefc3628bb> 15:06 Joubu cait: see paste ^ caused by 92bfc28eb0fd15aefccaef300943de9e7b161c40 15:12 cait Joubu: on it 15:13 cait Joubu: writing bug... then submitting patch 15:13 cait not going to wrap it in my patch, because i expect that to make a few circles before you take pity on me :) 15:18 huginn New commit(s) kohagit: Bug 16520 (Follow up) Rebase fixes <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=174769e382dfd5205595a5b9ae7b58c8ebf5d850> / Bug 16520: Add new Plack-SetEnv syntax to Apache configuration files <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e40f61bc3087727db75d07b02c34545300d153b1> / Bug 16520: Initialize the sysprefs Koha::Caches on demand <http://git.koha-community.org/gitweb/?p=koha.g 15:28 huginn New commit(s) kohagit: Bug 17094: Make Koha::Virtualshelf methods return Koha::Objects-based objects <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ef0b0f13fcba4605f99386d4c2bdd87e82234493> / Bug 17248 - Koha::AuthorisedValues - Remove GetKohaAuthorisedValueLib <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bb1e9c500c810402c64436c53bcc00ffb9a0b857> 15:38 huginn New commit(s) kohagit: Bug 15388 - Show Syndetics covers by UPC in search results <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=dbf2f7d6d97686179a1e794e0c74ad8be441a177> / Bug 16850: Remove C4::Members::IsMemberBlocked <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ee719cf10cf2f1c81de485228a98fc33e0f0c81b> / Bug 16850: Add test coverage for CanBookBeIssued <http://git.koha-community.org/gitweb/?p=koha.git;a=co 15:39 near2ton Hey, I notice in the newer versions of Koha there is an 'api' directory under /usr/share/koha - is this still in dev as I don't see any documentation about it. 16:00 oleonard Bye #koha 21:47 rangi morning 23:47 Lance Hello