Time  Nick          Message
03:02 koha-jenkins  Project koha_21.05_D10 build #1: FAILURE in 1 min 9 sec: https://jenkins.koha-community.org/job/koha_21.05_D10/1/
03:28 koha-jenkins  Project Koha_21.05_D11 build #1: FAILURE in 1 min 39 sec: https://jenkins.koha-community.org/job/Koha_21.05_D11/1/
06:06 reiveune      hello
06:41 alex_a        Bonjour
07:44 fridolin      yey
08:21 magnuse       \o/
09:15 tuxayo        Hi #koha o/
09:41 cait          ... how not to ask questions on a mailing list :(
09:44 cait          anyone around today or all on post-relase vacation?
10:04 * tuxayo      cooks but will soon finish ^^
10:37 cait          tuxayo: what are you making?
10:41 tcohen        morning
10:42 tcohen        bonjour
10:53 tcohen        hola cait
10:56 kohaputti     cait, lovely bugs found out today :P
10:57 tuxayo        cait: lentils, rice, chickpeas, oats, spinach, chard, garlic, onion, broccoli, fennel bulb, potatos, beet, black radish, salt, olive oil
10:57 tuxayo        No idea how to name this
10:58 tuxayo        hi tcohen , kohaputti  :)
10:59 tuxayo        kohaputti: already deployed 21.05 in production ?
10:59 cait          hola tcohen
10:59 cait          tuxayo: that's a lot :)
10:59 cait          vegan?
11:00 tuxayo        cait: 99.9% ^_^
11:00 cait          right, I remmber you are mostly :)
11:00 cait          I am trying to be mostly vegetarian right now, small steps
11:01 tuxayo        ^o^
11:01 kohaputti     tuxayo, yeah (with some patches on top)
11:02 cait          just about to finish writing up my qa email
11:02 cait          will ad hte bad bugs
11:02 tuxayo        kohaputti: any disruptions found?
11:02 kohaputti     cait, thx
11:02 cait          I am also worried about an overdues one reported
11:02 cait          bug 28487
11:02 huginn        Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28487 major, P5 - low, ---, koha-bugs, NEW , Overdue_notices does not fall back to default language
11:03 kohaputti     tuxayo, not too bad actually, only two criticals
11:03 cait          kohaputti: what is the other critical, spotted the category edit one already
11:03 kohaputti     cait, the other one is bug 28489
11:04 huginn        Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28489 critical, P5 - low, ---, koha-bugs, NEW , CGI::Session is incorrectly serialized to DB in production env / when strict_sql_modes = 0
11:04 kohaputti     that's the real "bomb" if someone happens to have non-ascii characters
11:04 kohaputti     :D
11:04 cait          hm and sql mode strikes again
11:05 kohaputti     It's actually not about that, it just hid the bug on test environment (because the config is different from production)
11:06 kohaputti     the mysql/cgi session driver seems to strip utf8 flag from the perl string
11:06 kohaputti     so the string goes as latin or something to db
11:06 kohaputti     I'm still on the hunt...
11:08 kohaputti     I also noticed our perl strings from Koha objects are not utf8!
11:08 kohaputti     it seems strange to me but I'm not sure it is an issue
11:11 cait          keep hunting... you know... German. I got a personal interest in diacritics and such :)
11:14 est84328      ah great. just testing.
11:14 Nemo_bis      just yesterday I was looking at bugzilla moving to utf8mb4 (I thought that had happened ages ago but no) https://github.com/bugzilla/bugzilla/commit/6eafd6a807ede6f2ca9e397d1d95fe44404a74c0
11:15 Nemo_bis      (I got curious after https://gitlab.com/mailman/mailman/-/commit/4ea9094d274f8dd2d1fb6d59f043ef1981615bd3 )
11:30 cait          brb
11:56 cait          kohaputti: don't we store uer name and such in the sessions table?
11:56 cait          just wondering reading your last comments
11:57 cait          i put that on the bug, better there :)
11:58 kohaputti     cait, we do, lovely :D
11:59 cait          not sure how and where this is used, just remmer because I did a write up of it sometime
12:00 did           hi,
12:02 kohaputti     cait, the branchcodes are used at least in the code directly and it will break many pages so quite bad bug
12:02 kohaputti     not sure about those usernames
12:02 cait          i think branchcodes are less likely to have special chars... but they could
12:03 cait          i imagine a russian library would put them in cyrillig and already throw us out of latin-1
12:03 cait          cyrillic
12:05 did           is it my setup ? But with master and docker koha I can't update patron record I get : something went wrong ... and  'Patron modification failed! - No property relationship for Koha::Patron at /kohadevbox/koha/members/memberentry.pl line 542.' in plack intranet log ?
12:05 TimothyAlexis Any ideas why this isn't being translated?
12:05 TimothyAlexis msgid "Your search returned %s results."
12:05 TimothyAlexis msgstr "Din sökning gav %s resultat."
12:05 cait          TimothyAlexis: can you share which file?
12:06 TimothyAlexis This is a custom translation that we're adding.
12:06 cait          hm ok
12:06 cait          what did you do when addin git?
12:06 cait          did you run the gulp update scripts?
12:07 cait          we have some changes that require i run them, not quite update scripts, but i noticed that my files won't pick up already existing installations when I skip those steps
12:08 cait          not quite custom tranlsations I was going to say... can't write today
12:08 TimothyAlexis We have some custom translations that we add at the end of the file "sv-SE-opac-bootstrap.po"
12:09 cait          hm have never done it manually
12:09 cait          i always let the tools pick up any strings from the templates
12:09 cait          and then translate them from the updated po files
12:09 cait          that way i know hte tools are picking them up correctly
12:12 TimothyAlexis OK
12:20 kohaputti     did, it is bug 28490
12:20 huginn        Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28490 critical, P5 - low, ---, koha-bugs, NEW , Cannot modify patrons in some categories (e.g. Child category)
12:32 tcohen        we've got better
12:33 TimothyAlexis There needed to be a space character after the . like this: msgid "Your search returned %s results. "
12:34 did           kohaputti: thanks
13:22 TimothyVass   Which table contains data about items that have been overdue?
13:25 tuxayo        TimothyVass: hi :)
13:25 tuxayo        Maybe http://schema.koha-community.org/master/tables/issues.html
13:26 tuxayo        it contains the item and it's due date which allows to get the those that are overdue
13:26 cait          :)
13:26 cait          for statistics you could also use old_issues
13:26 cait          with date_due and returndate
13:28 TimothyVass   What is the issues table used for?
13:28 cait          all checkouts
13:28 cait          issues = checkouts
13:29 cait          once an item is returned, the information moves to old_issues
13:29 cait          issue is the NZ term for a checkout, or maybe UK too
13:30 TimothyVass   So if we have a book which has due_date 2000-09-13 08:09:00 and return_date = [NULL], it's checked out?
13:30 cait          if it's in issues, it's always checked out
13:30 cait          returndate is only set in old_issues
13:30 cait          it will always be empty in issues
13:30 cait          if you union the tables, looking for return_date is null will work for all checkout out
13:32 tuxayo        As a side note, these obsolete terms (in Koha) that are still in the code and DB can be found in the terminology page where the current preferred term is listed.
13:32 tuxayo        https://wiki.koha-community.org/wiki/Terminology
13:33 TimothyVass   So that book has been overdue for 20+ years? :D
13:37 TimothyVass   tuxayo++
13:37 TimothyVass   cait++
13:39 tuxayo        TimothyVass: 20 years! :o so it was likely migrated over several ILS's!
13:39 cait          likely :)
14:07 domm          what is the purpose of auth_header.origincode? It is not really used in the Koha repo..
15:39 reiveune      bye
18:48 cait          tuxayo++
18:54 tuxayo        cait: what happened? ^^"
18:59 cait          you are testing bad bugs
18:59 cait          don't let me distract you :)
19:13 cait          does bug 27403 still work for you people?
19:13 huginn        Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27403 enhancement, P5 - low, ---, jonathan.druart+koha, Pushed to master , Enable fixedHeader for Datatables
19:13 cait          sticky header
19:14 cait          ok, I am looking at the wrong koh aversion :) that certainly explains
19:34 tuxayo        ^^
20:11 gveranis      hi all
20:36 tuxayo        hi gveranis :)
20:39 cait          btw - it does work in the new Koha version :)
20:56 gveranis      if you have a very large table of action_log > 100GB and want to delete the last days from it not all table there is a best solution ?
20:56 gveranis      or it is better to delete all the table ? :p
20:56 caroline      I think cleanup_database can delete a chunk for you
20:57 gveranis      I try it but the table is quite big
20:57 gveranis      and not worked as expected
21:09 cait          i am not sure if mysql/mariadb frees up th espace without additional action
21:09 cait          caroline: hi! just commented on your bug 28492
21:09 huginn        Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28492 enhancement, P5 - low, ---, koha-bugs, NEW , Hyphen in branchcode gives wrong search results
21:11 caroline      thanks, I can't imagine telling them to change the branchcode though... then they have to change the items, the users, the circ rule, it's a nightmare
21:12 gveranis      cait no it doesn't . Thanks I will try something
21:14 gveranis      when can I soft delete records from table need_merge_authorities ? when done is 1 ?
21:15 gveranis      because from there is the problem with huge table actions_log
22:25 cait          caroline: i understand, I once had to remove an additional space :(
22:25 cait          caroline: it IS a bit of a nightmare
22:26 cait          caroline: it actually caused issues because sql ignored the trailing space but Perl wouldn't, but branchcode is in a lot of tables
22:28 cait          maybe you could try changing some of the searches to use ,ext... or try that?
22:28 caroline      yup, many mnay spaghetti http://schema.koha-community.org/20_11/tables/branches.html
22:29 cait          oi
22:31 caroline      I think it would be easier still to change it in the database rather than trhough the intranet
22:31 caroline      even with all the spaghetti :)
22:37 cait          i did cheat too, but you can only do it if you turn FK keys off
22:37 cait          and really carefully
22:37 cait          hm maybe you can do witout the FK... but step by step
22:37 cait          still not easy and reindex?