IRC log for #koha, 2016-10-26

All times shown according to UTC.

Time S Nick Message
00:06 mario joined #koha
00:20 jzairo joined #koha
00:28 NateC joined #koha
01:10 Mike-CSPL joined #koha
01:29 Francesca joined #koha
03:30 Mike-CSPL joined #koha
04:14 Francesca joined #koha
04:19 narayana joined #koha
04:34 Francesca joined #koha
05:21 * magnuse waves
06:02 LibraryClaire joined #koha
06:08 magnuse guten morgen, BüchereiKlara!
06:09 magnuse let's rewrite koha in javascript while cait is away
06:18 LibraryClaire morning magnuse :)
06:18 LibraryClaire and #koha
06:18 LibraryClaire magnuse: finished packing yet? ;)
06:36 Francesca joined #koha
06:43 magnuse LibraryClaire: nope
06:43 magnuse but we still have 6 days left
06:43 magnuse including a full weekend
06:43 magnuse we will get there!
06:44 laurence joined #koha
06:50 reiveune joined #koha
06:51 reiveune hello
06:52 fridolin joined #koha
06:53 fridolin hie there
06:53 magnuse bonjour fridolin & reiveune
06:53 fridolin bonjour
06:53 wahanui que tal, fridolin
06:53 reiveune salut magnuse
06:57 alex_a joined #koha
06:57 sophie_m joined #koha
07:33 AndrewIsh joined #koha
07:33 AndrewIsh g'morn #koha
07:35 magnuse hiya AndrewIsh
07:36 AndrewIsh hi magnuse :)
07:51 eythian @wunder jordaan, amsterdam
07:51 huginn eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 10.6°C (9:44 AM CEST on October 26, 2016). Conditions: Mist. Humidity: 80%. Dew Point: 7.0°C. Pressure: 30.36 in 1028 hPa (Steady).
07:58 magnuse @wunder oslo, norway
07:58 huginn magnuse: The current temperature in Oslo Airport, Norway is 0.0°C (9:50 AM CEST on October 26, 2016). Conditions: Fog. Humidity: 100%. Dew Point: 0.0°C. Pressure: 30.18 in 1022 hPa (Steady).
07:58 magnuse @wunder boo
07:58 huginn magnuse: Error: No such location could be found.
07:58 magnuse @wunder enbo
07:58 huginn magnuse: The current temperature in Bodo, Norway is 6.0°C (9:50 AM CEST on October 26, 2016). Conditions: Light Rain. Humidity: 66%. Dew Point: 0.0°C. Windchill: 1.0°C. Pressure: 29.98 in 1015 hPa (Steady).
07:58 magnuse ok, i can live with that
08:09 alex_a joined #koha
08:18 andreashm joined #koha
08:18 * andreashm waves
08:19 andreashm Humm. I seem to have trouble with git after a failed git fetch yesterday. I get the error: error: Unable to find 7395b536de74725a62c7aa7212f5226d9070b0c2 under Cannot obtain needed object.
08:19 andreashm Anyone has an idea of how to solve this?
08:25 cait joined #koha
08:26 eythian what are you doing that causes that error?
08:26 andreashm I tried some stuff yesterday (after googling the problem) but with no luck. I even tried to re-provision kohadevbox but no luck there either
08:26 andreashm I try to do a git fetch/pull
08:26 Joubu andreashm: git remote update; git show 7395b536de74725a62c7aa7212f5226d9070b0c2 ?
08:26 Joubu I see it
08:26 andreashm joubu: thanks, I'll check
08:27 * cait waves
08:27 andreashm hi cait
08:27 Joubu first stackoverflow answer says git fsck; git gc
08:27 andreashm joubu: tried that, didn't work. same problem.
08:28 andreashm I tried moving the pack.temp file from objects too, didn't work either
08:28 andreashm sigh...
08:29 eythian delete the git dir and re-clone it?
08:29 Joubu Are you able to checkout v16.05.05?
08:29 andreashm joubu: git remote update gives the same error
08:29 eythian (this is assuming that it's not a server-side problem.)
08:29 andreashm eythian: I would think the problem is here. since noone else is reporting it.
08:30 andreashm I think I might have to delete and reclone... but I ws hoping to avoid that.
08:30 andreashm git show gives the error "fatal: bad object"
08:32 Joubu andreashm: I got weird git error (don't remember which one exactly...) last month and I solved it with: rm .git/gc.log; git prune; git gc
08:33 andreashm joubu: ok, thanks. I'll try that!
08:34 andreashm humm, no suck file/dir for .git/gc.log
08:34 andreashm such =)
08:37 andreashm anyways, guess I'll just try to delete .git and re-clone.
08:39 andreashm deleted - now re-cloning. Thanks for the help joubu and eythian, anyways!
08:43 wilfrid joined #koha
09:04 Francesca joined #koha
09:35 kidclamp joined #koha
09:41 lds joined #koha
09:41 lds hello
10:00 drojf joined #koha
10:14 andreashm joined #koha
10:16 * andreashm waves
10:24 irma joined #koha
10:42 cait joined #koha
10:50 * cait waves
10:58 AndrewIsh joined #koha
10:58 * magnuse waves
11:02 * LibraryClaire waves
11:06 * magnuse gets seasick
11:30 cait khall: around?
11:30 khall cait: what's up?
11:31 cait i am adding another follow-up to article request
11:31 khall cool
11:32 khall cait: afk, bbiab!
11:32 cait khall: just check it please :)
11:32 cait should be there in 5 mins
11:32 khall will do!
11:43 cait khall: done!
11:45 meliss joined #koha
11:45 magnuse \o/ cait++ khall++
11:45 cait ok, time to vacation for a bit :) bbl
11:48 JesseM joined #koha
11:53 oleonard joined #koha
11:53 oleonard Hi all
11:54 ashimema_ joined #koha
12:01 sophie_m hello #koha
12:05 sophie_m Is https://bugs.koha-community.or[…]_bug.cgi?id=17470 a bug or the intended behaviour ?
12:05 huginn Bug 17470: normal, P3, ---, koha-bugs, NEW , produces X emails with the SAME list of ALL overdue items if a patron has overdue items from X branches
12:07 oleonard That sounds like a bug to me sophie_m. We've been on 3.22.x for a couple of months now and I haven't heard of it happening.
12:08 sophie_m but do you proceed with -library parameter for overdues oleonard ?
12:08 oleonard Ah, sorry, no.
12:09 khall cait++!
12:10 alex_a joined #koha
12:15 Joubu sophie_m: I don't think it's the expected behavior, but...
12:15 Joubu looking at the pod, it says "select overdues for one specific library" for the -library option
12:15 Joubu but there is nothing in the code to do that
12:15 Joubu I guess it has never been implemented
12:16 NateC joined #koha
12:17 sophie_m Joubu, oleonard : the question is when we trigger a notification for overdue, we list all the overdues of a patron (not only the one corresponding of the delay ), should this be different for library ?
12:18 Joubu no idea, I am not a librarian :)
12:18 sophie_m where are the librarian ? :)
12:19 oleonard It doesn't make sense to me that it would generate separate notices for each library. That sounds wrong.
12:20 sophie_m why oleonard ? Some library with multiple branches want that each branch takes car of its own notifications.
12:21 oleonard My opinion on this issue only reflects my library's needs, which are probably irrelevant since we don't use the library flag
12:21 oleonard ...but you asked for opinions :)
12:22 oleonard @quote get 123
12:22 wahanui
12:22 huginn oleonard: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011)
12:25 rsantellan joined #koha
12:25 sophie_m oleonard: mayby I misunderstand, but the opportunity to generate separate notices for each library is already in use in koha (and some of our customuers are using it). The pb is the list of late items to display in it.
12:30 rsantellan good morning #koha
12:33 huginn New commit(s) kohagit: Bug 14610 - DBRev <[…]7742128991a656290> / Bug 14610: Follow-up 2 <[…]f3164fac1656c95b8> / Bug 14610 - Follow-up <[…]fcb25f0c9dd6b2fa6> / Bug 14610 - Update Sch
12:40 drojf joined #koha
12:50 NateC joined #koha
12:53 Joubu Nobody's interested in dev meetings? Still waiting for votes:
12:56 oleonard Oops, didn't go in and vote after clarifying the time zone question!
12:56 * oleonard is interested!
12:57 * drojf voted
12:57 drojf sorry
12:58 Joubu I will certainly send a reminder in a few days on koha-devel
12:58 drojf Joubu++
12:59 drojf daylight saving makes the time zone stuff even worse
12:59 Joubu framadate++ this tool is much more better than doodle :)
13:00 Dyrcona joined #koha
13:01 drojf Joubu: what is better about it?
13:01 oleonard free_software++
13:02 Joubu drojf: first it's a free software, then it seems you cannot do what I did with doodle
13:03 Joubu you can only select a date, not different values of "things"
13:03 Joubu do you prefer blue, green or yellow?
13:03 Joubu doodle seems only made to schedule events
13:04 Joubu but I may be wrong
13:04 Joubu and IMO the interface is much clearer
13:10 JoshB joined #koha
13:17 * LibraryClaire_away waves
13:26 Joubu see bug 17500 if you are interested in ES
13:26 huginn Bug[…]_bug.cgi?id=17500 enhancement, P5 - low, ---, jonathan.druart, In Discussion , Use Elasticsearch to search for patrons
13:26 talljoy joined #koha
13:34 kmlussier joined #koha
13:35 cait joined #koha
14:14 andreashm joined #koha
14:14 * andreashm waves
14:14 * cait waves
14:14 cait we will make magnuse seasick again
14:15 andreashm yay
14:15 andreashm =)
14:15 barbara joined #koha
14:16 andreashm my troubles with kohadevbox continues. I ended up deleting the whole box, and tried to reinstall. But now I have gotten into trouble with apache during the install process. I get this: Error executing /usr/sbin/apache2ctl: AH00534: apache2: Configuration error: No MPM loaded.
14:17 andreashm Anyone got any idea of how to solve? magnuse?
14:21 cait hm did you 'vagrant destroy' and 'vagrant up' again?
14:21 Joubu try vagrant up --provision
14:21 Joubu or vagrant ssh, then install the missing package
14:29 CrispyBran joined #koha
14:30 CrispyBran Good morning.
14:30 wahanui the only good morning is a dead one
14:30 CrispyBran that's a bit morbid.
14:30 CrispyBran Anyone know how to reach nengard via e-mail?
14:30 andreashm cait: tried that. no luck.
14:31 andreashm joubu: tried --provision as well. I can ssh into vagrant, but not much seems to work there.
14:57 fridolin left #koha
14:58 cait andreashm: did you try updating your kohadevbox repository? maybe it's older
14:59 TGoat joined #koha
15:11 LibraryClaire left #koha
15:14 misilot_ joined #koha
15:30 cait jajm: around by chance?
15:38 jajm cait, yes, but not for long :)
15:38 andreashm cait: the problem isn't with the repo per se, I can't vagrant up since the apache error aborts it.
15:39 cait jajm: plying with the circ wizard
15:39 cait i am still failing to do an hourly report
15:39 cait bug 7679
15:39 huginn Bug[…]w_bug.cgi?id=7679 enhancement, P5 - low, ---, julian.maurice, Signed Off , Statistics wizard: circulation (new filters)
15:39 cait andreashm: was wondering about the kohadevbox repo
15:40 cait jajm: so say i choose period and by hour
15:40 cait type checout
15:41 cait i only see a total, not the hours
15:44 jajm cait, i have a weird error when trying to use the wizard: "Template process failed: undef error - The method selected is not covered by tests! at /home/koha/koha/C4/ line 121"
15:44 cait yes
15:44 cait apply 17495 on top or before
15:44 cait i have noted it as new dependency and PQA on it a few minutes ago
15:44 cait no conflicts - no matter in which sequence you apply them
15:44 jajm ah thanks
15:46 jajm cait, i see this in logfile : "DBD::mysql::st execute failed: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'latin1'" do you have the same ?
15:47 cait hm let me check
15:47 cait but do yout hink it's related?
15:48 cait i have removed the limit on the libraries and just picked by hour, period, and patron library
15:49 cait that's the result
15:49 cait i have at least 2 issues from today and more older ones
15:50 cait jajm:
15:50 cait DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement "SELECT distinctrow extract(hour from datetime) FROM statistics  LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber)  WHERE datetime is not null AND datetime != ''  AND type ='issue'  group by extract(hour from datetime) collate utf8_bin order by extract(hour from datetime) "] at /home/vagrant/kohaclone/reports/ line 355., referer: http
15:51 jajm cait, you should have another DBD error just before that
15:51 cait eyp
15:51 cait DBD::mysql::st execute failed: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'latin1' [for Statement "SELECT distinctrow extract(hour from datetime) FROM statistics  LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber)  WHERE datetime is not null AND datetime != ''  AND type ='issue'  group by extract(hour from datetime) collate utf8_bin order by extract(hour from datetime) "] at /home/vagrant/kohaclone/reports/issues
15:52 jajm ok... maybe mysql doesn't like the 'extract() collate' stuff
15:52 cait it works without the ocllate
15:52 cait i just tested in workbench
15:53 cait GROUP BY HOUR(datetime)
15:53 cait ORDER BY EXTRACT(HOUR FROM datetime)
15:53 cait hm ok, i changed a bit more
15:53 cait GROUP BY EXTRACT(HOUR FROM datetime)
15:53 cait ORDER BY EXTRACT(HOUR FROM datetime) works too
15:55 cait it appears to be the only script in koha that uses collate?
15:55 jajm collate without extract() seems to work too
15:55 cait what is the collate for?
15:56 cait it doesn't seem to be used anywhere else
15:56 jajm it's because the default collation is case-insensitive and there were cases where we wanted to have case-sensitive comparisons (but i don't remember why)
15:56 cait hm i have read the comments
15:57 cait i think i wouldn#t go to lengths to achieve that
15:57 cait it appears a data problem
15:57 cait people should fix their data
15:59 cait it works if i remove all the collate statements
15:59 oleonard Bye #koha
16:00 cait would you be ok with that solution?
16:02 mario joined #koha
16:03 jajm cait, I don't like the 'collate' stuff, but I added it for a reason (which i don't remember :)) i'll have to think about it...
16:05 LibraryClaire joined #koha
16:07 jajm cait, but we can apply this solution now, and i'll open a new bug if i remember the reason
16:11 cait jajm: sounds good for me :)
16:12 cait i will write anothr follow-up
16:12 jajm cait, thanks
16:12 cait the script is... not the nicest part of koha
16:12 jajm i have to go
16:12 cait i am sure there are more bugs hiding
16:12 cait have a nice evening :)
16:12 jajm you too :)
16:12 jajm bye
17:00 bag @seen tcohen
17:00 huginn bag: tcohen was last seen in #koha 1 day, 3 hours, 2 minutes, and 58 seconds ago: <tcohen> the exceptionname should be MethodNotFound
17:24 laurence left #koha
17:48 cdickinson_ joined #koha
17:54 nengard joined #koha
18:36 edveal joined #koha
18:50 rangi morning
18:51 rangi heh exactly what I new would happen with the voting happened
18:51 talljoy joined #koha
18:52 rangi and that is why we always used to rotate them
18:56 kathryn joined #koha
19:15 CrispyBran https://bugs.koha-community.or[…]_bug.cgi?id=17506
19:15 huginn Bug 17506: enhancement, P5 - low, ---, koha-bugs, NEW , Offline circ needs to be logged
19:18 CrispyBran https://bugs.koha-community.or[…]_bug.cgi?id=17507
19:18 huginn Bug 17507: enhancement, P5 - low, ---, koha-bugs, NEW , Preference to limit how old an offline circ file can be when uploaded
20:40 nengard joined #koha
20:50 Francesca joined #koha
20:57 JesseM joined #koha
21:00 CrispyBran Cool!  I didn't know I could view everyone's web cams in here!
21:08 edveal joined #koha
21:10 JoshB left #koha
21:23 magnuse joined #koha
23:00 irma joined #koha
23:00 jamesb joined #koha
23:45 papa joined #koha
23:47 wizzyrea hi
23:49 tcohen joined #koha
23:50 tcohen hi
23:51 rangi hi tcohen
23:51 tcohen hey rangi
23:52 * tcohen loves 2020 idea
23:53 rangi :)
23:57 tcohen night everyone, just showed to say hi :-D

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