Time Nick Message 05:21 * magnuse waves 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: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:51 reiveune hello 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 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: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 http://git.koha-community.org/koha.git Cannot obtain needed object. 08:19 andreashm Anyone has an idea of how to solve this? 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! 09:41 lds hello 10:16 * andreashm waves 10:50 * cait waves 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 magnuse \o/ cait++ khall++ 11:45 cait ok, time to vacation for a bit :) bbl 11:53 oleonard Hi all 12:01 sophie_m hello #koha 12:05 sophie_m Is https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17470 a bug or the intended behaviour ? 12:05 huginn 04Bug 17470: normal, P3, ---, koha-bugs, NEW , overdue_notices.pl 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: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: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 http://xkcd.com/1172/ 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 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 16.06.00.037 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=33ff59173151dae282a3c787742128991a656290> / Bug 14610: Follow-up 2 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d64de2bd0d4807700993727f3164fac1656c95b8> / Bug 14610 - Follow-up <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2ae9f783534e7b0410869aafcb25f0c9dd6b2fa6> / Bug 14610 - Update Sch 12:53 Joubu Nobody's interested in dev meetings? Still waiting for votes: https://framadate.org/3dAEB8zqQLzzTptD 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: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:17 * LibraryClaire_away waves 13:26 Joubu see bug 17500 if you are interested in ES 13:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17500 enhancement, P5 - low, ---, jonathan.druart, In Discussion , Use Elasticsearch to search for patrons 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: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: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:58 cait andreashm: did you try updating your kohadevbox repository? maybe it's older 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 04Bug http://bugs.koha-community.org/bugzilla3/show_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/Templates.pm 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 [off] http://librarygeekgirl.de/pics/pic_002.jpg my search 15:48 cait i have removed the limit on the libraries and just picked by hour, period, and patron library 15:49 cait [off] http://librarygeekgirl.de/pics/pic_003.jpg 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 issues_stats.pl: 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/issues_stats.pl line 355., referer: http 15:51 jajm cait, you should have another DBD error just before that 15:51 cait eyp 15:51 cait issues_stats.pl: 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: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: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 18:50 rangi morning 18:51 rangi heh exactly what I new would happen with the voting happened 18:52 rangi and that is why we always used to rotate them 19:15 CrispyBran https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17506 19:15 huginn 04Bug 17506: enhancement, P5 - low, ---, koha-bugs, NEW , Offline circ needs to be logged 19:18 CrispyBran https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17507 19:18 huginn 04Bug 17507: enhancement, P5 - low, ---, koha-bugs, NEW , Preference to limit how old an offline circ file can be when uploaded 21:00 CrispyBran Cool! I didn't know I could view everyone's web cams in here! 23:47 wizzyrea hi 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