IRC log for #koha, 2021-05-31

All times shown according to UTC.

Time S Nick Message
03:02 koha-jenkins Project koha_21.05_D10 build #1: FAILURE in 1 min 9 sec: https://jenkins.koha-community[…]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[…]Koha_21.05_D11/1/
03:57 alexbuckley joined #koha
05:57 reiveune joined #koha
06:06 reiveune hello
06:11 kohaputti joined #koha
06:27 sophie_m joined #koha
06:30 sophie_m joined #koha
06:30 did joined #koha
06:41 alex_a joined #koha
06:41 alex_a Bonjour
06:41 did joined #koha
06:58 lds joined #koha
07:07 paul_p joined #koha
07:26 MarkHofstetter joined #koha
07:44 fridolin joined #koha
07:44 fridolin yey
07:46 fridolin joined #koha
07:50 magnuse joined #koha
08:04 did joined #koha
08:09 alexbuckley joined #koha
08:16 kohaputti joined #koha
08:21 magnuse \o/
08:27 alex_a joined #koha
08:30 alex_a_ joined #koha
08:55 janPasi joined #koha
09:15 tuxayo Hi #koha o/
09:16 alex_a joined #koha
09:18 alex_a joined #koha
09:18 alex_a joined #koha
09:29 cait joined #koha
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:07 davidnind joined #koha
10:13 oleonard joined #koha
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.or[…]_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.or[…]_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 joined #koha
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)[…]d1d95fe44404a74c0
11:15 Nemo_bis (I got curious after[…]9f043ef1981615bd3 )
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/ line 542.' in plack intranet log ?
12:05 TimothyAlexis joined #koha
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:13 lds joined #koha
12:20 kohaputti did, it is bug 28490
12:20 huginn Bug https://bugs.koha-community.or[…]_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
12:52 fridolin joined #koha
12:55 fridolin left #koha
12:57 fridolin joined #koha
13:01 davidnind left #koha
13:20 TimothyVass joined #koha
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.o[…]ables/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
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 :)
13:48 marie-luce joined #koha
14:07 domm what is the purpose of auth_header.origincode? It is not really used in the Koha repo..
14:23 ivandz joined #koha
15:15 fridolin left #koha
15:20 cait joined #koha
15:39 reiveune bye
15:39 reiveune left #koha
16:09 caroline joined #koha
17:35 cait joined #koha
18:33 did joined #koha
18:48 cait tuxayo++
18:50 magnuse joined #koha
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.or[…]_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:01 dpk joined #koha
20:11 gveranis joined #koha
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.or[…]_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
21:21 alexbuckley joined #koha
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.o[…]les/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?
22:51 nugged joined #koha
23:46 alexbuckley joined #koha

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