IRC log for #koha, 2016-10-13

All times shown according to UTC.

Time S Nick Message
00:36 irma joined #koha
01:04 rocio left #koha
01:18 chris_n joined #koha
03:02 irma joined #koha
03:27 Francesca joined #koha
04:55 sophie_m joined #koha
05:01 Francesca joined #koha
05:45 Francesca joined #koha
05:58 sophie_m joined #koha
06:36 laurence joined #koha
06:44 mario joined #koha
06:45 alex_a joined #koha
06:47 drojf joined #koha
06:47 drojf bonjour
06:47 wahanui hello, drojf
06:48 sameeenz joined #koha
06:49 ashimema_ joined #koha
06:57 LibraryClaire joined #koha
07:01 gaetan_B joined #koha
07:02 gaetan_B hello
07:03 reiveune joined #koha
07:04 LibraryClaire hi gaetan_B
07:04 cait joined #koha
07:08 oleonard joined #koha
07:08 tcohen joined #koha
07:09 oleonard Hello all
07:12 laurence left #koha
07:13 * oleonard seems to be able to connect to irc and nothing else...
07:15 JesseM joined #koha
07:16 oleonard joined #koha
07:16 atheia joined #koha
07:17 LibraryClaire o/ oleonard
07:17 oleonard Ahoj!
07:23 mario joined #koha
07:24 mario joined #koha
07:24 mario joined #koha
07:25 nlegrand Hello !
07:27 tcohen joined #koha
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:47 sophie_m joined #koha
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 Bug[…]_bug.cgi?id=17411 minor, P5 - low, ---, veron, Needs Signoff , Change exit 1 to exit 0 in acqui/ to prevent Internal Server Error
08:07 Joubu query tcohen https://bugs.koha-community.or[…]ment.cgi?id=56121
08:07 Joubu it looks like a / is missing...
08:13 oleonard joined #koha
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 Bug[…]_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 cait joined #koha
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:35 josef_moravec joined #koha
08:40 josef_moravec left #koha
08:40 josef_moravec joined #koha
08:40 marcelr joined #koha
08:40 marcelr hi #koha
08:40 marcelr hi marseille
08:43 sophie_m joined #koha
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 AndrewIsh joined #koha
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:49 kidclamp joined #koha
08:51 kidclamp Joubu bug 15438 when you have a moment
08:51 huginn Bug[…]_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:54 magnuse joined #koha
08:56 alex_a kidclamp: Test plan available => Bug 17047
08:56 huginn Bug[…]_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 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:14 kidclamp joined #koha
09:16 wmnickc joined #koha
09:18 magnuse cait: yes!
09:19 Francesca joined #koha
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:25 tcohen joined #koha
09:36 LibraryClaire :D
09:42 cait hehe
09:57 gaetan_B joined #koha
09:57 drojf joined #koha
10:03 sophie_m joined #koha
10:09 wmnickc joined #koha
10:12 bag morning
10:12 marcelr hi bag
10:15 bag matts:
10:23 drojf joined #koha
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:01 tcohen1 joined #koha
11:06 cait joined #koha
11:19 wmnickc joined #koha
11:23 drojf joined #koha
11:36 irma joined #koha
11:36 jzairo joined #koha
11:43 nlegrand magnuse: thanks :)
11:44 Dyrcona joined #koha
11:44 magnuse nlegrand: no problem
11:51 meliss joined #koha
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.
11:57 cait joined #koha
12:03 chris_n joined #koha
12:13 laurence joined #koha
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 tcohen joined #koha
12:18 nlegrand bag: ok thanks!
12:19 petter joined #koha
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:
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:27 rsantellan joined #koha
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[…]7e4e/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 wmnickc joined #koha
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 pasted "diff --git a/C4/Members/Attrib" (13 lines) at
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:53 edveal joined #koha
12:59 kidclamp bug 16520 rebased Joubu
12:59 huginn Bug[…]_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_ko​hadev</memcached_namespace>
13:10 atheia joined #koha
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 JoshB joined #koha
13:14 drojf rsantellan: which instructions are you following?
13:14 rsantellan drojf: https://wiki.koha-community.or[…]es_-_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/', 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 talljoy joined #koha
13:24 meliss joined #koha
13:24 pastebot "rsantellan" at pasted "Create deb error" (29 lines) at
13:27 cait joined #koha
13:35 huginn New commit(s) kohagit: UPdating the DBREv for Bug 17216 - Add a new table to store authorized <[…]952430e02a85c4d24> / Bug 17216: Move the AV cat list file to the top level <[…]b4824004fa410c879> / Bug 17216: Internal AV should be correctly handled when creating a new category <htt
13:37 kmlussier joined #koha
13:52 magnuse joined #koha
13:52 drojf joined #koha
13:57 magnuse Joubu++ for helping petter
14:12 magnuse joined #koha
14:17 barton joined #koha
14:20 Scott-CSPL joined #koha
14:43 mario joined #koha
14:43 drojf joined #koha
14:50 tcohen joined #koha
14:52 z0k joined #koha
14:53 laurence left #koha
14:53 kidclamp joined #koha
15:00 reiveune left #koha
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 pasted "diff --git a/t/db_dependent/Le" (26 lines) at
15:06 huginn New commit(s) kohagit: Bug 16520: Allow per-VirtualHost environment variables with Plack <[…]2e6a15ecc601273aa> / Bug 7143 NEW added Kyle Hall as release manager. <[…]7261199fefc3628bb>
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:14 atheia joined #koha
15:16 gaetan_B joined #koha
15:18 huginn New commit(s) kohagit: Bug 16520 (Follow up) Rebase fixes <[…]9ae7b58c8ebf5d850> / Bug 16520: Add new Plack-SetEnv syntax to Apache configuration files <[…]02c34545300d153b1> / Bug 16520: Initialize the sysprefs Koha::Caches on demand <
15:21 JesseM joined #koha
15:27 rocio joined #koha
15:28 huginn New commit(s) kohagit: Bug 17094: Make Koha::Virtualshelf methods return Koha::Objects-based objects <[…]4c2bdd87e82234493> / Bug 17248 - Koha::AuthorisedValues - Remove GetKohaAuthorisedValueLib <[…]53bcc00ffb9a0b857>
15:37 near2ton joined #koha
15:38 tcohen1 joined #koha
15:38 huginn New commit(s) kohagit: Bug 15388 - Show Syndetics covers by UPC in search results <[…]e0c74ad8be441a177> / Bug 16850: Remove C4::Members::IsMemberBlocked <[…]28a98fc33e0f0c81b> / Bug 16850: Add test coverage for CanBookBeIssued <[…]/?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.
15:47 tcohen joined #koha
16:00 tcohen joined #koha
16:00 oleonard Bye #koha
16:33 cait joined #koha
16:55 JesseM joined #koha
17:04 barton|lunch joined #koha
17:14 petter joined #koha
17:21 JesseM joined #koha
17:40 atheia joined #koha
17:54 atheia left #koha
18:14 cdickinson_ joined #koha
19:06 edveal joined #koha
19:38 JesseM joined #koha
19:52 kmlussier joined #koha
19:53 irma joined #koha
19:54 CrispyBran joined #koha
20:09 JesseM joined #koha
20:30 JesseM joined #koha
20:51 Francesca joined #koha
20:52 mario joined #koha
21:06 JesseM joined #koha
21:36 JoshB left #koha
21:41 talljoy joined #koha
21:47 rangi morning
22:13 cait joined #koha
22:28 JesseM joined #koha
22:48 sophie_m joined #koha
22:49 chrisvella__ joined #koha
23:17 JesseM joined #koha
23:19 irma joined #koha
23:26 Francesca joined #koha
23:38 papa joined #koha
23:47 Lance joined #koha
23:47 Lance Hello

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