IRC log for #koha, 2021-09-01

All times shown according to UTC.

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

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