← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 | 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 | 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 | bonjour | |
| 10:53 | 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 | No idea how to name this | |
| 10:58 | hi tcohen , kohaputti :) | |
| 10:59 | kohaputti: already deployed 21.05 in production ? | |
| 10:59 | cait | hola tcohen | 
| 10:59 | tuxayo: that's a lot :) | |
| 10:59 | vegan? | |
| 11:00 | tuxayo | cait: 99.9% ^_^ | 
| 11:00 | cait | right, I remmber you are mostly :) | 
| 11:00 | 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 | 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 | 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 | :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 | the mysql/cgi session driver seems to strip utf8 flag from the perl string | |
| 11:06 | so the string goes as latin or something to db | |
| 11:06 | I'm still on the hunt... | |
| 11:08 | I also noticed our perl strings from Koha objects are not utf8! | |
| 11:08 | 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) https://github.com/bugzilla/bu[…]d1d95fe44404a74c0 | 
| 11:15 | (I got curious after https://gitlab.com/mailman/mai[…]9f043ef1981615bd3 ) | |
| 11:30 | cait | brb | 
| 11:56 | kohaputti: don't we store uer name and such in the sessions table? | |
| 11:56 | just wondering reading your last comments | |
| 11:57 | 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 | not sure about those usernames | |
| 12:02 | cait | i think branchcodes are less likely to have special chars... but they could | 
| 12:03 | i imagine a russian library would put them in cyrillig and already throw us out of latin-1 | |
| 12:03 | 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 joined #koha | |
| 12:05 | TimothyAlexis | Any ideas why this isn't being translated? | 
| 12:05 | msgid "Your search returned %s results." | |
| 12:05 | 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 | what did you do when addin git? | |
| 12:06 | did you run the gulp update scripts? | |
| 12:07 | 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 | 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 | i always let the tools pick up any strings from the templates | |
| 12:09 | and then translate them from the updated po files | |
| 12:09 | 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 | Maybe http://schema.koha-community.o[…]ables/issues.html | |
| 13:26 | it contains the item and it's due date which allows to get the those that are overdue | |
| 13:26 | cait | :) | 
| 13:26 | for statistics you could also use old_issues | |
| 13:26 | with date_due and returndate | |
| 13:28 | TimothyVass | What is the issues table used for? | 
| 13:28 | cait | all checkouts | 
| 13:28 | issues = checkouts | |
| 13:29 | once an item is returned, the information moves to old_issues | |
| 13:29 | 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 | returndate is only set in old_issues | |
| 13:30 | it will always be empty in issues | |
| 13:30 | 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 | https://wiki.koha-community.org/wiki/Terminology | |
| 13:33 | TimothyVass | So that book has been overdue for 20+ years? :D | 
| 13:37 | tuxayo++ | |
| 13:37 | 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 | don't let me distract you :) | |
| 19:13 | 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 | 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 | 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 | and not worked as expected | |
| 21:09 | cait | i am not sure if mysql/mariadb frees up th espace without additional action | 
| 21:09 | 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 | when can I soft delete records from table need_merge_authorities ? when done is 1 ? | |
| 21:15 | 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 | caroline: it IS a bit of a nightmare | |
| 22:26 | 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 | 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 | 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 | and really carefully | |
| 22:37 | hm maybe you can do witout the FK... but step by step | |
| 22:37 | still not easy and reindex? | |
| 22:51 | nugged joined #koha | |
| 23:46 | alexbuckley joined #koha | 
← Previous day | Today | Next day → | Search | Index