Time Nick Message 22:37 cait still not easy and reindex? 22:37 cait hm maybe you can do witout the FK... but step by step 22:37 cait and really carefully 22:37 cait i did cheat too, but you can only do it if you turn FK keys off 22:31 caroline even with all the spaghetti :) 22:31 caroline I think it would be easier still to change it in the database rather than trhough the intranet 22:29 cait oi 22:28 caroline yup, many mnay spaghetti http://schema.koha-community.org/20_11/tables/branches.html 22:28 cait maybe you could try changing some of the searches to use ,ext... or try that? 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:25 cait caroline: it IS a bit of a nightmare 22:25 cait caroline: i understand, I once had to remove an additional space :( 21:15 gveranis because from there is the problem with huge table actions_log 21:14 gveranis when can I soft delete records from table need_merge_authorities ? when done is 1 ? 21:12 gveranis cait no it doesn't . Thanks I will try something 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: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:09 cait caroline: hi! just commented on your bug 28492 21:09 cait i am not sure if mysql/mariadb frees up th espace without additional action 20:57 gveranis and not worked as expected 20:57 gveranis I try it but the table is quite big 20:56 caroline I think cleanup_database can delete a chunk for you 20:56 gveranis or it is better to delete all the table ? :p 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:39 cait btw - it does work in the new Koha version :) 20:36 tuxayo hi gveranis :) 20:11 gveranis hi all 19:34 tuxayo ^^ 19:14 cait ok, I am looking at the wrong koh aversion :) that certainly explains 19:13 cait sticky header 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 does bug 27403 still work for you people? 18:59 cait don't let me distract you :) 18:59 cait you are testing bad bugs 18:54 tuxayo cait: what happened? ^^" 18:48 cait tuxayo++ 15:39 reiveune bye 14:07 domm what is the purpose of auth_header.origincode? It is not really used in the Koha repo.. 13:39 cait likely :) 13:39 tuxayo TimothyVass: 20 years! :o so it was likely migrated over several ILS's! 13:37 TimothyVass cait++ 13:37 TimothyVass tuxayo++ 13:33 TimothyVass So that book has been overdue for 20+ years? :D 13:32 tuxayo https://wiki.koha-community.org/wiki/Terminology 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:30 cait if you union the tables, looking for return_date is null will work for all checkout out 13:30 cait it will always be empty in issues 13:30 cait returndate is only set in old_issues 13:30 cait if it's in issues, it's always checked out 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:29 cait issue is the NZ term for a checkout, or maybe UK too 13:29 cait once an item is returned, the information moves to old_issues 13:28 cait issues = checkouts 13:28 cait all checkouts 13:28 TimothyVass What is the issues table used for? 13:26 cait with date_due and returndate 13:26 cait for statistics you could also use old_issues 13:26 cait :) 13:26 tuxayo it contains the item and it's due date which allows to get the those that are overdue 13:25 tuxayo Maybe http://schema.koha-community.org/master/tables/issues.html 13:25 tuxayo TimothyVass: hi :) 13:22 TimothyVass Which table contains data about items that have been overdue? 12:34 did kohaputti: thanks 12:33 TimothyAlexis There needed to be a space character after the . like this: msgid "Your search returned %s results. " 12:32 tcohen we've got better 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:20 kohaputti did, it is bug 28490 12:12 TimothyAlexis OK 12:09 cait that way i know hte tools are picking them up correctly 12:09 cait and then translate them from the updated po files 12:09 cait i always let the tools pick up any strings from the templates 12:09 cait hm have never done it manually 12:08 TimothyAlexis We have some custom translations that we add at the end of the file "sv-SE-opac-bootstrap.po" 12:08 cait not quite custom tranlsations I was going to say... can't write today 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:06 cait did you run the gulp update scripts? 12:06 cait what did you do when addin git? 12:06 cait hm ok 12:06 TimothyAlexis This is a custom translation that we're adding. 12:05 cait TimothyAlexis: can you share which file? 12:05 TimothyAlexis msgstr "Din sökning gav %s resultat." 12:05 TimothyAlexis msgid "Your search returned %s results." 12:05 TimothyAlexis Any ideas why this isn't being translated? 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:03 cait cyrillic 12:03 cait i imagine a russian library would put them in cyrillig and already throw us out of latin-1 12:02 cait i think branchcodes are less likely to have special chars... but they could 12:02 kohaputti not sure about those usernames 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:00 did hi, 11:59 cait not sure how and where this is used, just remmer because I did a write up of it sometime 11:58 kohaputti cait, we do, lovely :D 11:57 cait i put that on the bug, better there :) 11:56 cait just wondering reading your last comments 11:56 cait kohaputti: don't we store uer name and such in the sessions table? 11:30 cait brb 11:15 Nemo_bis (I got curious after https://gitlab.com/mailman/mailman/-/commit/4ea9094d274f8dd2d1fb6d59f043ef1981615bd3 ) 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:14 est84328 ah great. just testing. 11:11 cait keep hunting... you know... German. I got a personal interest in diacritics and such :) 11:08 kohaputti it seems strange to me but I'm not sure it is an issue 11:08 kohaputti I also noticed our perl strings from Koha objects are not utf8! 11:06 kohaputti I'm still on the hunt... 11:06 kohaputti so the string goes as latin or something to db 11:06 kohaputti the mysql/cgi session driver seems to strip utf8 flag from the perl string 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:04 cait hm and sql mode strikes again 11:04 kohaputti :D 11:04 kohaputti that's the real "bomb" if someone happens to have non-ascii characters 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:03 kohaputti cait, the other one is bug 28489 11:03 cait kohaputti: what is the other critical, spotted the category edit one already 11:03 kohaputti tuxayo, not too bad actually, only two criticals 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:02 cait bug 28487 11:02 cait I am also worried about an overdues one reported 11:02 kohaputti cait, thx 11:02 tuxayo kohaputti: any disruptions found? 11:02 cait will ad hte bad bugs 11:02 cait just about to finish writing up my qa email 11:01 kohaputti tuxayo, yeah (with some patches on top) 11:01 tuxayo ^o^ 11:00 cait I am trying to be mostly vegetarian right now, small steps 11:00 cait right, I remmber you are mostly :) 11:00 tuxayo cait: 99.9% ^_^ 10:59 cait vegan? 10:59 cait tuxayo: that's a lot :) 10:59 cait hola tcohen 10:59 tuxayo kohaputti: already deployed 21.05 in production ? 10:58 tuxayo hi tcohen , kohaputti :) 10:57 tuxayo No idea how to name this 10:57 tuxayo cait: lentils, rice, chickpeas, oats, spinach, chard, garlic, onion, broccoli, fennel bulb, potatos, beet, black radish, salt, olive oil 10:56 kohaputti cait, lovely bugs found out today :P 10:53 tcohen hola cait 10:42 tcohen bonjour 10:41 tcohen morning 10:37 cait tuxayo: what are you making? 10:04 * tuxayo cooks but will soon finish ^^ 09:44 cait anyone around today or all on post-relase vacation? 09:41 cait ... how not to ask questions on a mailing list :( 09:15 tuxayo Hi #koha o/ 08:21 magnuse \o/ 07:44 fridolin yey 06:41 alex_a Bonjour 06:06 reiveune hello 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/ 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/