Time Nick Message 23:57 tcohen night everyone, just showed to say hi :-D 23:53 rangi :) 23:52 * tcohen loves 2020 idea 23:51 tcohen hey rangi 23:51 rangi hi tcohen 23:50 tcohen hi 23:47 wizzyrea hi 21:00 CrispyBran Cool! I didn't know I could view everyone's web cams in here! 19:18 huginn 04Bug 17507: enhancement, P5 - low, ---, koha-bugs, NEW , Preference to limit how old an offline circ file can be when uploaded 19:18 CrispyBran https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17507 19:15 huginn 04Bug 17506: enhancement, P5 - low, ---, koha-bugs, NEW , Offline circ needs to be logged 19:15 CrispyBran https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17506 18:52 rangi and that is why we always used to rotate them 18:51 rangi heh exactly what I new would happen with the voting happened 18:50 rangi morning 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:00 bag @seen tcohen 16:12 jajm bye 16:12 jajm you too :) 16:12 cait have a nice evening :) 16:12 cait i am sure there are more bugs hiding 16:12 jajm i have to go 16:12 cait the script is... not the nicest part of koha 16:12 jajm cait, thanks 16:12 cait i will write anothr follow-up 16:11 cait jajm: sounds good for me :) 16:07 jajm cait, but we can apply this solution now, and i'll open a new bug if i remember the reason 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:00 cait would you be ok with that solution? 15:59 oleonard Bye #koha 15:59 cait it works if i remove all the collate statements 15:57 cait people should fix their data 15:57 cait it appears a data problem 15:57 cait i think i wouldn#t go to lengths to achieve that 15:56 cait hm i have read the comments 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 it doesn't seem to be used anywhere else 15:55 cait what is the collate for? 15:55 jajm collate without extract() seems to work too 15:55 cait it appears to be the only script in koha that uses collate? 15:53 cait ORDER BY EXTRACT(HOUR FROM datetime) works too 15:53 cait GROUP BY EXTRACT(HOUR FROM datetime) 15:53 cait hm ok, i changed a bit more 15:53 cait ORDER BY EXTRACT(HOUR FROM datetime) 15:53 cait GROUP BY HOUR(datetime) 15:52 cait i just tested in workbench 15:52 cait it works without the ocllate 15:52 jajm ok... maybe mysql doesn't like the 'extract() collate' stuff 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:51 cait eyp 15:51 jajm cait, you should have another DBD error just before that 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:50 cait jajm: 15:49 cait i have at least 2 issues from today and more older ones 15:49 cait that's the result 15:49 cait [off] http://librarygeekgirl.de/pics/pic_003.jpg 15:48 cait i have removed the limit on the libraries and just picked by hour, period, and patron library 15:48 cait [off] http://librarygeekgirl.de/pics/pic_002.jpg my search 15:47 cait but do yout hink it's related? 15:47 cait hm let me check 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:44 jajm ah thanks 15:44 cait no conflicts - no matter in which sequence you apply them 15:44 cait i have noted it as new dependency and PQA on it a few minutes ago 15:44 cait apply 17495 on top or before 15:44 cait yes 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:41 cait i only see a total, not the hours 15:40 cait type checout 15:40 cait jajm: so say i choose period and by hour 15:39 cait andreashm: was wondering about the kohadevbox repo 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 bug 7679 15:39 cait i am still failing to do an hourly report 15:39 cait jajm: plying with the circ wizard 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:38 jajm cait, yes, but not for long :) 15:30 cait jajm: around by chance? 14:58 cait andreashm: did you try updating your kohadevbox repository? maybe it's older 14:31 andreashm joubu: tried --provision as well. I can ssh into vagrant, but not much seems to work there. 14:30 andreashm cait: tried that. no luck. 14:30 CrispyBran Anyone know how to reach nengard via e-mail? 14:30 CrispyBran that's a bit morbid. 14:30 wahanui the only good morning is a dead one 14:30 CrispyBran Good morning. 14:21 Joubu or vagrant ssh, then install the missing package 14:21 Joubu try vagrant up --provision 14:21 cait hm did you 'vagrant destroy' and 'vagrant up' again? 14:17 andreashm Anyone got any idea of how to solve? magnuse? 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:15 andreashm =) 14:15 andreashm yay 14:14 cait we will make magnuse seasick again 14:14 * cait waves 14:14 * andreashm waves 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 13:26 Joubu see bug 17500 if you are interested in ES 13:17 * LibraryClaire_away waves 13:04 Joubu and IMO the interface is much clearer 13:04 Joubu but I may be wrong 13:03 Joubu doodle seems only made to schedule events 13:03 Joubu do you prefer blue, green or yellow? 13:03 Joubu you can only select a date, not different values of "things" 13:02 Joubu drojf: first it's a free software, then it seems you cannot do what I did with doodle 13:01 oleonard free_software++ 13:01 drojf Joubu: what is better about it? 12:59 Joubu framadate++ this tool is much more better than doodle :) 12:59 drojf daylight saving makes the time zone stuff even worse 12:58 drojf Joubu++ 12:58 Joubu I will certainly send a reminder in a few days on koha-devel 12:57 drojf sorry 12:57 * drojf voted 12:56 * oleonard is interested! 12:56 oleonard Oops, didn't go in and vote after clarifying the time zone question! 12:53 Joubu Nobody's interested in dev meetings? Still waiting for votes: https://framadate.org/3dAEB8zqQLzzTptD 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:30 rsantellan good morning #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: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:22 wahanui http://xkcd.com/1172/ 12:22 oleonard @quote get 123 12:21 oleonard ...but you asked for opinions :) 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:20 sophie_m why oleonard ? Some library with multiple branches want that each branch takes car of its own notifications. 12:19 oleonard It doesn't make sense to me that it would generate separate notices for each library. That sounds wrong. 12:18 sophie_m where are the librarian ? :) 12:18 Joubu no idea, I am not a librarian :) 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:15 Joubu I guess it has never been implemented 12:15 Joubu but there is nothing in the code to do that 12:15 Joubu looking at the pod, it says "select overdues for one specific library" for the -library option 12:15 Joubu sophie_m: I don't think it's the expected behavior, but... 12:09 khall cait++! 12:08 oleonard Ah, sorry, no. 12:08 sophie_m but do you proceed with -library parameter for overdues oleonard ? 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: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:05 sophie_m Is https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17470 a bug or the intended behaviour ? 12:01 sophie_m hello #koha 11:53 oleonard Hi all 11:45 cait ok, time to vacation for a bit :) bbl 11:45 magnuse \o/ cait++ khall++ 11:43 cait khall: done! 11:32 khall will do! 11:32 cait should be there in 5 mins 11:32 cait khall: just check it please :) 11:32 khall cait: afk, bbiab! 11:31 khall cool 11:31 cait i am adding another follow-up to article request 11:30 khall cait: what's up? 11:30 cait khall: around? 11:06 * magnuse gets seasick 11:02 * LibraryClaire waves 10:58 * magnuse waves 10:50 * cait waves 10:16 * andreashm waves 09:41 lds hello 08:39 andreashm deleted - now re-cloning. Thanks for the help joubu and eythian, anyways! 08:37 andreashm anyways, guess I'll just try to delete .git and re-clone. 08:34 andreashm such =) 08:34 andreashm humm, no suck file/dir for .git/gc.log 08:33 andreashm joubu: ok, thanks. I'll try that! 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:30 andreashm git show gives the error "fatal: bad object" 08:30 andreashm I think I might have to delete and reclone... but I ws hoping to avoid that. 08:29 andreashm eythian: I would think the problem is here. since noone else is reporting it. 08:29 eythian (this is assuming that it's not a server-side problem.) 08:29 andreashm joubu: git remote update gives the same error 08:29 Joubu Are you able to checkout v16.05.05? 08:29 eythian delete the git dir and re-clone it? 08:28 andreashm sigh... 08:28 andreashm I tried moving the pack.temp file from objects too, didn't work either 08:27 andreashm joubu: tried that, didn't work. same problem. 08:27 Joubu first stackoverflow answer says git fsck; git gc 08:27 andreashm hi cait 08:27 * cait waves 08:26 andreashm joubu: thanks, I'll check 08:26 Joubu I see it 08:26 Joubu andreashm: git remote update; git show 7395b536de74725a62c7aa7212f5226d9070b0c2 ? 08:26 andreashm I try to do a git fetch/pull 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 eythian what are you doing that causes that error? 08:19 andreashm Anyone has an idea of how to solve this? 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:18 * andreashm waves 07:58 magnuse ok, i can live with that 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 @wunder enbo 07:58 huginn magnuse: Error: No such location could be found. 07:58 magnuse @wunder boo 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 oslo, norway 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:51 eythian @wunder jordaan, amsterdam 07:36 AndrewIsh hi magnuse :) 07:35 magnuse hiya AndrewIsh 07:33 AndrewIsh g'morn #koha 06:53 reiveune salut magnuse 06:53 wahanui que tal, fridolin 06:53 fridolin bonjour 06:53 magnuse bonjour fridolin & reiveune 06:53 fridolin hie there 06:51 reiveune hello 06:43 magnuse we will get there! 06:43 magnuse including a full weekend 06:43 magnuse but we still have 6 days left 06:43 magnuse LibraryClaire: nope 06:18 LibraryClaire magnuse: finished packing yet? ;) 06:18 LibraryClaire and #koha 06:18 LibraryClaire morning magnuse :) 06:09 magnuse let's rewrite koha in javascript while cait is away 06:08 magnuse guten morgen, BüchereiKlara! 05:21 * magnuse waves