| 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) https://github.com/bugzilla/bu[…]d1d95fe44404a74c0 |
| 11:15 |
|
Nemo_bis |
(I got curious after https://gitlab.com/mailman/mai[…]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/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 |
|
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 |
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 :) |
| 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 |
