Time Nick Message 23:11 dcook Busy 16 hours there eh 18:35 huginn oleonard: The operation succeeded. 18:35 oleonard @later tell Joubu I will probably end up creating 7 or 8 bugs to finish the Flatpickr move. Should I create a new omnibus bug or just make them all depend on 28376? 18:31 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28376 enhancement, P5 - low, ---, oleonard, Pushed to master , Replace obsolete jquery-ui-timepicker-addon 18:31 oleonard Wrong bug before... it's a follow-up to Bug 28376 18:30 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28938 normal, P5 - low, ---, oleonard, Needs Signoff , Correct Flatpickr's default 12hr time formatting 18:30 oleonard Bug 28938 18:30 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28937 enhancement, P5 - low, ---, oleonard, ASSIGNED , Use Flatpickr on circulation and patron pages 18:30 oleonard Anyone around who can sign off on a trivial followup to Bug 28937? 18:05 Guest5996 Thank you for confirming. 18:04 oleonard Guest5996: Yes, the user will have to at least have elevated privileges to do the export. 17:32 Guest5996 Thank you both for your assistance! It is greatly appreciated. 17:18 Guest5996 And the user will need to have the root pwd for the database to do so? 17:16 ashimema That should work 17:16 ashimema Yup 17:12 Guest5996 So export the old db, do a separate 21 install, import and run the update script? 17:05 oleonard I'm not an expert, but I believe you can import a version 3 database dump into a fresh 21 installation and it will be correctly updated when you run the database update script. 17:01 Guest5996 That's my assumption, since they are non-technical it's difficult to get at some answers. 16:59 oleonard They have Koha installed in some kind of virtual machine on Windows? 16:58 Guest5996 I am advising a tiny library on upgrading to version 21 from version 3. They have it installed on a Windows platform, and are non-technical. Is there good guidance for such a large leap to be found online? 16:56 oleonard What is your question? 16:56 oleonard Oh, that's odd. 16:55 Guest5996 I attempted to subscribe and that subscription was never approved. 16:55 oleonard What question did you ask on the list that didn't get an answer? 16:54 Guest5996 No, I am new to this channel. I was hoping someone more fluent in Koha could answer a couple questions, since the listserv isn't panning out for me. 16:51 oleonard jcamins? 16:48 huginn ashimema: I have not seen Jared. 16:48 ashimema @seen Jared 16:48 ashimema Jared... 16:40 wahanui somebody said Which Cait was around now? 16:40 ashimema Which Cait 16:04 ashimema :) 15:42 tcohen I'm happily back to Linux, but suffering some glitches 15:39 huginn oleonard: I have not seen linuuuux. 15:39 oleonard @seen linuuuux 15:38 tcohen linuuuux 14:59 ashimema funny you should say that.. I'd love such a thing 14:58 ashimema hahaha.. 14:58 Joubu ashimema: ideally we would like a SQL::Abstract-like syntax to build a query 14:55 ashimema so we should probably rename to drop the _ 14:55 ashimema ok 14:55 ashimema but that is currently only used internally in build_query_compat really 14:55 Joubu yes I think _clean_search_term must be available from everywhere 14:55 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28316 normal, P5 - low, ---, stalkernoid, Signed Off , Fix ES crashes related to various punctuation characters 14:55 ashimema bug 28316 improves the filtering in _clean_search_term 14:54 ashimema ES crashes etc 14:54 ashimema we have a bunch of messy bugs around here 14:54 ashimema my code affects the same sort of area 14:53 ashimema where he starts using the private method in a controller 14:53 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28484 normal, P5 - low, ---, koha-bugs, Signed Off , Elasticsearch fails to parse query if colon or exclamation point is in 245$a 14:53 * ashimema is looking at bug 28484 14:53 ashimema so would you suggest _clean_search_term should/could be made public? 14:53 ashimema fair enough 14:53 ashimema lol 14:53 Joubu this sub is meant to generate the query from the HTML elements 14:52 Joubu because you have the query already 14:52 ashimema why not? 14:52 ashimema hmm 14:52 Joubu I wouldn't try to convert it 14:52 ashimema but... 14:52 ashimema indeed 14:51 Joubu if you have the query already you don't need to build it 14:50 ashimema aha, thanks 14:50 Joubu lol 14:50 ashimema `((rcn:$biblionumber AND cni:OSt) OR rcn:OSt $biblionumber) NOT (bib-level:a OR bib-level:b)` 14:50 Joubu and the bottom contain the filters/limits 14:50 Joubu open the adv search page, you have the 'indexes, operands, operators' at the top 14:49 Joubu no, the itemtype, branchcode, year, etc. 14:49 ashimema I think I understand 14:48 ashimema like ;opac only' for example? 14:48 Joubu the 'limits' contains the filters 14:48 ashimema so I can take advantage of the work going on to clean up search terms 14:48 Joubu idx1:foo AND idx2:bar will bee { indexes => ['idx1', 'idx2'], operands => ['foo', 'bar'], operators => 'AND' } 14:47 ashimema to instead use build_query_compat 14:47 * ashimema is trying to wrap his head around converting get_volumes_query here https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=26314&attachment=124367 14:46 ashimema is operands an array of search terms, operands the 'AND', 'OR', 'NOT' and indexes the array of indexes to search for each operand 14:46 Joubu it gets the inputs and send them to the 'compat' sub 14:46 Joubu it's what is on the adv search page 14:45 ashimema so.. 14:45 ashimema so 14:45 ashimema opertors, operands, indexes, limits etc 14:45 Joubu (which was a bad idea) 14:45 Joubu the one from ES has been written to take the same param as the existing zebra one 14:45 * ashimema is confused by all the inputs 14:45 Joubu more precisely? 14:43 ashimema how does build_query_compat work 14:43 ashimema my brain hurts 14:38 oleonard :) 14:38 Joubu share the link! 14:37 * oleonard starts a Twitch channel where he stares blankly at the screen thinking about datepickers for 7 hours a day 14:37 Joubu the communication, I mean, not the low number of meeting attendees 14:36 Joubu maybe that will help a bit as well 14:36 Joubu I am still hoping to come with a 'ML => discourse move' proposition in the next months 14:36 * ashimema needs a walk 14:35 ashimema anywho... 14:35 ashimema there's still loads of scope for improvements in Koha at the wider level I feel... be great to somehow get more people on board with that. 14:35 ashimema Which is fine.. though I would love to see some of those feed back up.. 14:34 ashimema indeed 14:34 oleonard Joubu++ 14:34 oleonard ashimema++ 14:34 oleonard I wonder if general community interactions are moving more to regional meetings e.g. Koha-US. 14:31 ashimema no point wasting everyone's time with empty agenda's 14:31 ashimema I just sent an email to the lists mooting the idea of switching to biannual general meetings 14:23 tuxayo *thanks 14:22 tuxayo thank ashimema for chairing :) 14:22 tuxayo good idea 14:22 huginn Log: https://meetings.koha-community.org/2021/general_irc_meeting_1_september_2021.2021-09-01-14.02.log.html 14:22 huginn Minutes (text): https://meetings.koha-community.org/2021/general_irc_meeting_1_september_2021.2021-09-01-14.02.txt 14:22 huginn Minutes: https://meetings.koha-community.org/2021/general_irc_meeting_1_september_2021.2021-09-01-14.02.html 14:22 huginn Meeting ended Wed Sep 1 14:22:25 2021 UTC. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4) 14:22 ashimema #endmeeting 14:22 ashimema #info Next meeting: 13 Oct 2021, 14 UTC 14:21 ashimema and maybe moot that we have one or two a year as more of an AGM instead from then on.? 14:21 tuxayo ok 14:21 ashimema lets slip it to 6 as they're so badly attended 14:21 ashimema indeed 14:20 Joubu and 1 "general" for kohacon vote 14:20 Joubu which could be done by email 14:20 Joubu and kohacon updates 14:19 oleonard I'm not sure what General meetings are for anymore since they're only attended by devs 14:18 Joubu every quarter 14:18 ashimema not sure which would actually get more attendance though. 14:18 ashimema we could do a 6 week.. or 2 week to reset it to the middle 14:17 ashimema exactly 14:17 ashimema yeah.. but I don't remember it being this close before 14:17 tuxayo 4w != 1mo so it moves a little by little 14:17 thd It was the middle somewhat recently. 14:17 ashimema we must have missed one/rescheduled one at some point 14:17 ashimema I'm not sure how it's ended up at the beggining/end of the month.. I thought it tended to be in the middle 14:16 ashimema indeed 14:16 Joubu every 4 weeks 14:16 thd ? 14:16 thd Should it not be next month 14:16 ashimema #info Next meeting: 29 Sept 2021, 14 UTC 14:16 thd 29? 14:15 Joubu yes 14:15 ashimema my brain isn't working this afternoon 14:15 ashimema does that make it the 29th? 14:15 tuxayo works for me 14:14 ashimema same cadence? 14:14 ashimema #topic Date and time for next meeting 14:13 ashimema There were no actions 14:13 ashimema #topic Actions from last meeting 14:13 ashimema moving on 14:13 ashimema [off] those were what I was looking at just prior to this meeting Joubu ;) 14:13 tuxayo or else be DoSed! 14:13 ashimema #info If you've not already updated, please do! 14:12 Joubu [off] want more? :D 14:12 ashimema #info Security releases went out as planned, well done team. 14:12 tuxayo People should update ^^ 14:12 tuxayo Security release went ok 14:11 wahanui well, rmaints is fridolin, khall, kidclamp, wainui and tuxayo 14:11 ashimema rmaints? 14:11 ashimema #info Only two months left for this cycle.. lots still to do. Please refer to previous minutes for the lists 14:10 ashimema ta 14:10 Joubu check what I said at the last meetings if you want to know more 14:10 Joubu and still the same things I need 14:10 ashimema yowsers! 14:10 Joubu less than 2 months left 14:09 ashimema anything you wish to say Joubu 14:09 ashimema #topic Update on releases 14:09 ashimema shall we move on.. 14:09 ashimema #info kohaputti is hopefully returning to Koha for a little while after winning a grant for such... :) 14:07 tuxayo kohaputti got a grant to continue working on Koha :) 14:07 ashimema anyone have any announcements? 14:06 ashimema is anyone from the wider community actually attending? 14:06 Joubu they are reactive by email 14:06 thd #info Thomas Dukleth, Agogme, New York City 14:06 ashimema has anyone heard anything from them regards the date changes etc.. 14:06 ashimema I bet we don't have anyone from the KohaCon hosts here... 14:05 ashimema #topic Announcements 14:03 tuxayo :D 14:03 huginn Current chairs: ashimema tuxayo 14:03 ashimema #chair tuxayo 14:03 ashimema #info Martin Renvoize, PTFS Europe, UK 14:03 nugged #info Andrew Nugged, National Library of Finland, HELSINKI 14:03 petrova #info Peter (Petro) Vashchuk, National Library of Finland, HELSINKI 14:03 oleonard #info Owen Leonard, Athens County Public Libraries, Ohio, USA 14:03 tuxayo #info Victor Grousset, Tuxayo International Ltd. ,France 14:03 ashimema #topic Introductions 14:02 ashimema #link https://wiki.koha-community.org/wiki/General_IRC_meeting_1_September_2021 Today's agenda 14:02 huginn The meeting name has been set to 'general_irc_meeting_1_september_2021' 14:02 huginn Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. 14:02 huginn Meeting started Wed Sep 1 14:02:27 2021 UTC. The chair is ashimema. Information about MeetBot at http://wiki.debian.org/MeetBot. 14:02 ashimema #startmeeting General IRC meeting 1 September 2021 13:58 Joubu cannot attend this meeting, sorry 13:56 ashimema dang I'm so bad at this 13:56 ashimema another meeting.. 13:56 wahanui hey, ashimema 13:56 ashimema hello 13:56 ashimema ho 13:56 wahanui rmaints is fridolin, khall, kidclamp, wainui and tuxayo 13:56 tuxayo rmaints? 13:56 wahanui qa_team is, like, cait, dcook, amoyano, ashimema, marcelr, kohaputti, jajm, tcohen, kidclamp, khall, tuxayo, petrova, nugged 13:56 tuxayo qa_team? 13:56 tuxayo Meeting in 5 min! 13:43 tuxayo Hi #koha :) 13:14 oleonard Meeting in 45 minutes? 12:38 nlegrand Joubu: Thanks!! 12:36 Joubu nlegrand: installer/data/mysql/mandatory/sample_notices_message_transports.sql 12:34 nlegrand ha! It seems my message_transports table is missing the information. From where should it be filled? 12:22 marcelr The InvalidField sub is minor importance 12:22 Joubu marcelr: agreed 12:07 marcelr Joubu: I would be all for pushing the simple flags patch first 12:07 marcelr hi #koha 12:07 nlegrand There is no transport value pass nowhere when it is asking for message preferences. 12:06 nlegrand Fun fact: it worked well in 18.05 with the same problem but now in 20.11, it works for item_due, but not advance_notice. 12:05 nlegrand oleonard: there are! 12:05 oleonard (I don't even know if that is connected) 12:05 nlegrand And it says “messages => none†on the default page. 12:05 oleonard nlegrand: Are there notices defined for those messages? 12:04 nlegrand Even in categories.pl for default message preferencies, I have “-†and no checkbox. 12:03 user_ ok 12:03 nlegrand user_: he has. 12:02 user_ nlegrand, maybe you need to add email to the patron? 12:01 nlegrand So, if anyone has an idea on how to get email checkboxes back in Messaging Preferences, I'm interested :D. 12:01 nlegrand In all email columns of Messaging Preferences I've got a “ - †and no check box. I read code through and through until C4::Form::MessagingPreferences baffled me... 11:58 nlegrand I restarted to work this week and I stumbled on a weird one. 11:57 nlegrand Hey #koha! 11:27 oleonard Why do we even have the option for users to choose their own library card number? 11:23 vfernandes should we use another dir instead of /tmp/koha ? 11:16 vfernandes the template cache dir /tmp/koha needs specific permissions? 11:15 vfernandes hummm my problem happens with all scripts not running on plack: manage-marc-import.pl, stage-marc-import.pl, upload-cover-image.pl... 11:04 huginn ashimema: The operation succeeded. 11:03 ashimema @later tell jajm I took bug 24023 as inspiration but re-wrote allot of it using modern practice and to match our customer requirements. Hopefully it will also cover your customers requirements but i'd love your feedback if you have a moment some time.. My work is on bug 28854 11:02 ashimema jajm around? 10:48 vfernandes the script upload-cover-image.pl runs outside plack 10:48 vfernandes can someone help me debugging this error? 10:47 pastebot "vfernandes" at 127.0.0.1 pasted "Upload cover images" (1 line) at http://paste.koha-community.org/2567 10:43 vfernandes hi #koha 10:16 oleonard o/ 08:42 fridolin sse u 08:24 fridolin ammar: from HTTP interface, some proxy are protecting from posting SQL queries. This may block sql report edition in Koha 08:17 janPasi ammar: with underscore obviously :D 08:17 janPasi ammar: not sure if that's the problem, but you seem to have a typo in your mysql username, kohalibray instaead of kohalibrary 08:06 ammar actually the real issue is I cannot create a new query directly on KOHA, as page crashed on the save query page. So, as a workaround I need to run query directly on mysql 08:04 ammar ERROR 1045 (28000): Access denied for user 'koha_libray'@'localhost' (using password: YES) 08:04 ammar ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 08:04 ammar but when I export the result in CSV it gives mei access denied error 08:04 ammar when I ran the query in mysql directly on linux terminal it went good 08:03 ammar my SFTP user is root and mysql user is koha_library 08:03 wahanui hi, ammar 08:03 ammar Hi 06:53 * dcook waves 06:52 fridolin dcook: le bonjour 06:45 alex_a Bonjour 06:44 dcook And hi ^_^ 06:44 * dcook also collapses into a heap 06:44 * dcook apologizes for the Bugzilla spam but hopes the patches help 06:28 magnuse \o/ 06:17 fridolin hi 02:31 koha-jenkins Project Koha_20.11_D10 build #142: FIXED in 2 hr 4 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/142/ 02:31 wahanui Congratulations! 02:31 koha-jenkins Yippee, build fixed! 01:26 koha-jenkins Project Koha_20.11_U18 build #121: SUCCESS in 58 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/121/ 01:10 koha-jenkins Project Koha_19.11_D10 build #188: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_19.11_D10/188/ 01:03 koha-jenkins Project Koha_20.05_D11 build #709: STILL UNSTABLE in 36 min: https://jenkins.koha-community.org/job/Koha_20.05_D11/709/ 01:01 koha-jenkins Project Koha_20.11_U20 build #129: SUCCESS in 33 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/129/