Time Nick Message 05:30 Joubu mtj: around? 05:30 Joubu koha-staging no longer have nightly build for master? 05:31 Joubu mtj: last notif on koha-bots was on 2023-07-30 - "Koha 04'master' packages pushed to 08'koha-staging' repo 03(2fd6625a)" 07:56 fridolin yellouw 08:03 cait1 Joubu: Weblate is not coming up for me this morning - browser is loading endlessly 08:03 cait1 and good moring all 08:04 fridolin weblate means "web is late" XD 08:06 cait1 lol 08:07 Joubu same for me 08:08 Joubu weblate's maintainer submitted a possible fix 08:08 Joubu the dev docker image does not contain it yet 08:09 cait ok 08:09 Joubu there is nothing I can do, postgres is not processing some speficic SELECTs fast enough 08:09 Joubu there are 5 in the queue, and they take ~30s-2min each 08:09 cait I am trying to load the page for the manual and it's not coming up 08:10 cait let's hope we can get the fix soon 08:10 cait it's strange because the test system was so super fast 08:10 cait maybe becuase it didn#t havee all the data? 08:10 Joubu yes 08:11 Joubu there are 15M entries in a table, and the query is not good 08:11 Joubu https://github.com/WeblateOrg/weblate/discussions/10723 08:20 Joubu the docker image has been updated, I will upgrade weblate 08:23 Joubu done 08:25 Joubu did-g[m]: yop 08:36 krimsonkharne[m] morning all 08:59 cait Joubu: I'll give it another go 08:59 cait currently, it's super fast again 08:59 cait keepig fingers crossed! 08:59 cait Joubu++ 08:59 cait weblate_community++ 09:10 cait Joubu: it's a dream compared to before 09:11 cait Annelisterman[m]: try Weblate again :) 09:11 ashimema nice one 09:12 Joubu the problem is that (I think) the problematic queries come from background tasks 09:13 Joubu so it could happen again randomly 09:14 Joubu https://snipboard.io/NEQSh7.jpg - peaks are way lower however! 09:38 alexted[m] hi 09:38 alexted[m] I need to import several Marc records into a new (empty) installation of Koha (Stage MARC records for import>Manage staged MARC records). 09:38 alexted[m] Is there a way to keep the same biblionumber, biblioitemnumber and itemnumber as the imported records? From an import test I saw that Koha starts numbering everything from 1. Thanks! 09:38 cait1 not really 09:39 cait1 well ther eis no configuration switch or similar 09:39 cait1 you could set the counter in the database manually, but if your improt contains a record that has been deleted since, it won't work and get out of sync 09:39 cait1 hm and it would also only work if we can assume that the records sequence is by biblionumber and they are also imported in that sequence 09:40 alexted[m] cait1: hi, thanks! 09:44 alexted[m] I have this need (of keeping the same biblionumber) because I also have numerous record Marc Serials with related Subscriptions connected 09:45 alexted[m] and other internal links between records 10:04 magnuse alexted[m]: are the records in Koha already? if so you could perhaps export all the relevant db tables from the old koha and import them into the new koha. not something i have ever done, though 10:12 alexted[m] magnuse no, the new installation is empty. The problem is that the source tables are from an old version of Koha and have changed a lot compared to the new version I'm using 10:13 magnuse ah, ok 10:13 magnuse oh, i meant "are the records in an old version of koha or in some other system" :-) 10:14 ashimema so the records are coming from an old koha.. 10:14 magnuse how old is the old koha? you could still try to copy over the whole database and do an upgrade 10:14 ashimema do you still have that koha around.. know what version it is.. 10:14 ashimema I'd just upgrade 10:16 alexted[m] hi, thanks for your suggestions! The records and the table come from the 17.11.02.000 version, and the new version that i have installed is the 22.11.12 version 10:17 Annelisterman[m] <cait> "Anneli Österman: try Weblate..." <- Much better now. Earlier today it just loaded and loaded and loaded. :) 10:19 alexted[m] <magnuse> "oh, i meant "are the records..." <- yes, the records are in an old version of koha :) 10:24 magnuse alexted[m]: 17.11 to 22.11 should not be an impossible upgrade, worth a try i'd say 10:25 PedroAmorim[m] o/ 10:25 PedroAmorim[m] davidnind++ 10:26 ashimema that should be a trivial upgrade 10:27 ashimema I'd run the db update from the command line 10:27 ashimema and watch the output 10:27 ashimema Koha stops on errors so you can usually spot and fix them manually in the db.. then re-run the db update sript and it'll pick up where it left off. 10:28 alexted[m] the problem is that koha 17.11 is running on an old server (Centos) that will be discontinued, while the 22.11 version is on a new server (Ubunt/Debiann): updating koha without the Debian package, on Centos, is a nightmare 10:29 ashimema so perhaps install a 17.11 on the new server 10:29 ashimema dump the old database and load it into the new server 10:29 ashimema then run the upgrade on the new server 10:30 ashimema https://debian.koha-community.org/koha/dists/17.11/ 10:30 ashimema packages should exist for it still 10:32 Joubu install 22.11, drop the db, inject your dump, restart_all, run the update DB script 10:33 ashimema doh.. of course.. that would work 10:34 ashimema headache 10:34 alexted[m] ashimema: thanks for the suggestion! the problem is that I just installed Koha 22.11 (https://wiki.koha-community.org/wiki/Koha_on_Debian) on the new server, I should uninstall everything and reinstall 10:34 ashimema do what Joubu just said 10:34 ashimema drop the existing database 10:34 alexted[m] Joubu: ah, ok! great! 10:34 ashimema and throw your old one in instead 10:36 alexted[m] thanks all for the suggesions! only one question: is there any reference guide for update DB script? 10:43 cait1 alexted[m]: trust the process :) 10:44 cait1 it#s all automated 10:44 cait it will have the old structure, Koha detects the mismatch of application version and database version and starts the update, this here describes it a bit: kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html 10:45 alexted[m] cait: thanks! I will try :) 10:46 cait struggling with dicsonnects/bad network today, sorry for the constant renumbering of caits... 10:48 cait you can run the database update on command line as described there, or you could restart and it will also come up in the browser 10:48 cait for a big update teh cli is maybe a bit easier to work with 10:49 alexted[m] cait: perfect! I'm downloading the old database right now 10:59 cait alexted[m]: out of interest - where are you from? 10:59 alexted[m] cait: italy :) 10:59 cait ah nice :) 10:59 cait Germany 11:00 alexted[m] :) 11:17 oleonard o/ 12:30 cait oh wow, from all green to totally broken? 12:37 magnuse "Error while executing command: no such element: Unable to locate element: //*[@id="password"] at /usr/share/perl5/Selenium/Remote/Driver.pm line 411." ? 12:38 cait yeah, right now I am not sure waht caused this 12:39 cait I was hoping to push some more today, but not so sure now 12:40 cait ashimema, PedroAmorim[m] around? 12:40 PedroAmorim[m] + 12:40 cait do we have abug for the fail of the erm sushi tests? 12:40 cait https://jenkins.koha-community.org/job/Koha_Master_D10/lastCompletedBuild/testReport/ 12:41 PedroAmorim[m] I'm not entirely sure, had a chat with Matt yesterday about it I think he's on it 12:41 cait any ETA for the patches? :) 12:42 cait https://paste.koha-community.org/34536 12:43 PedroAmorim[m] I don't know, there are at least 2 things happening, I believe there's a new 'audited' field coming from the sushi response that needs to be added to our REST API, and there's the 'migrations' thing Joubu mentioned, possibly others. Long story short, it seems the SUSHI response is now different and causing issues. 12:44 PedroAmorim[m] I'm not actively looking into it after my chat with Matt yesterday, more than one person looking at this would be counter productive 12:44 PedroAmorim[m] unless advised otherwise 12:45 cait yeah, I am trying not to push things while tests are failing - trying to figure out what to do 12:46 cait maybe you can tell him that this shoudl have some priority 12:46 cait and we should have a bug filed 12:47 cait also D11 is not even tellin gme waht is failing... that doesn't look great 12:52 Joubu selenium failure is coming from bug 35070 - I let a note this morning with the "additional_work_needed" flag, and jajm added a patch there 12:52 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35070 normal, P5 - low, ---, julian.maurice, Pushed to master , Koha plugins implementing "background_jobs" hook can't provide view template 12:53 cait oh thanks, i had missed the note 12:54 cait so let's see if we can fix D11 a bit 12:59 cait jajm++ Joubu++ # taking care of that one quickly 13:03 cait at least passing locally now, going to push 13:04 ashimema Matt is off ill today 13:04 ashimema so it won't happen today 13:04 cait thanks 13:04 cait I'll push a few bugs and the fix for the D11 one, hoping we will get to a bit of a better state with that already 13:05 ashimema the sushi stuff is very contained.. I wouldn't let it stop you pushing unrelated stuff. 13:05 cait trying to get D11 back from failed first 13:07 cait but I think you are right and knowing the response has changes is also good info 13:08 Joubu ashimema: the E2E tests (selenium and cypress) are not run when the other tests are failing 13:09 cait pushed 13:19 cait Joubu: what is E2E? 13:19 cait or what does it stand for? 13:30 Joubu end-to-end 13:30 cait ah, ok, that was kind of obvious 13:37 cait I am testing some patches, but will wait with pushing 13:58 oleonard cait++ 14:14 cait1 D11 is still failing, but not exploding anymore, the erm tests and the known recurring selenium tests failing 14:38 magnuse is https://git.koha-community.org/Koha-community/Koha/src/branch/master/debian/docs/LEEME.Debian still relevant and up to date? pushed 12 years ago, not changed since 14:40 cait1 possibly not? 14:47 cait1 ashimema: still around? 14:51 oleonard Hi lukeg 14:54 cait1 time to call it a day - have a nice weekend all! 14:58 alexted[m] <Joubu> "install 22.11, drop the db..." <- I just finished the suggested procedure: everything seems to have gone well, I'll do a few more checks, but everything seems ok! Thanks again to everyone for the valuable suggestions 14:59 ashimema hi 14:59 magnuse ashimema: hi 14:59 cait1 alexted[m]: thanks for the feedback :) 15:01 magnuse ashimema: i get this problem when i try to build packages with https://gitlab.com/ptfs-europe/koha-dpkg-docker too: https://gitlab.com/koha-community/koha-dpkg-docker/-/issues/4 15:01 magnuse you don't happen to know if you have found a workaround for it? 15:01 ashimema erm.. afraid I'm none the wiser 15:02 magnuse i tried le googles, but haven't figured it out yet. one suggestion was to skip dpkg-source, but i can't even figure out where i would do that, it's all a bit too magical yet... 15:03 ashimema I've asked Jake here 15:03 ashimema hopefully he'll have some clues 15:03 magnuse coolios! 15:05 lukeg good morning/afternoon/evening! 15:06 magnuse hiya lukeg 15:06 ashimema hmm, I think he might be in a meeting 15:06 ashimema I'll keep an eye and get back to you magnuse 15:07 magnuse awesome! 15:12 fridolin nice weekend folks, next week in Marseille whooo 15:20 Joubu aude_c[m], caroline: https://www.sphinx-doc.org/en/master/usage/configuration.html#confval-figure_language_filename 15:22 Joubu in my understanding there is then nothing to do 15:23 caroline just change it in the conf? 15:23 aude_c[m] Nice. Thank you 15:23 aude_c[m] So the French manual will know to pick images from the fr file directory? 15:24 Joubu caroline: if we suffix with .$LANG.png there is nothing to do 15:24 caroline +1 15:24 Joubu from image.fr.png 15:24 aude_c[m] 👍️ 15:24 Joubu but we could split into different dir (1 per lang) and modify figure_language_filename in the config 15:25 ashimema we lean on community for the translations stuff I'm afraid magnuse 15:25 ashimema so we don't do that bit outselves in the container 15:26 magnuse ashimema: the problem here seems to be also with css files that are generated somewhere along the line, and then everything stops because there are uncomitted files in the repo. or so i think. 15:27 Joubu @later tell tcohen Docker_4 has disk space issues 15:27 huginn` Joubu: The operation succeeded. 16:00 alexted[m] <alexted[m]> "I just finished the suggested..." <- I only notice a problem on the database tables. I give an example, but there could be others: the "biblio" table in Koha 17.11 did not have the "subtitle" column and therefore now I find myself having a table with the "subtitle" column empty, even for all the records that in MARC21 have the 245b compiled. Could this be a significant problem? 16:02 caroline Is there a character limit for emails sent to the koha mailing list? I sent a message twice and it still doesn't appear in the archive... https://lists.katipo.co.nz/public/koha/2024-January/date.html 16:02 caroline ah there it is... I had to complain ;) 16:11 aude_c[m] Exciting :) 16:20 alexted[m] <alexted[m]> "I only notice a problem on the..." <- However, I noticed that: if from the Cataloging module I open and Edit a record with the 245b and then save it (without making any changes), the "subtitle" column of the "biblio" table for that record is filled in correctly with the 245b already present in the record . Is there a way to do this batch operation on all records? Thank you! 16:21 caroline alexted[m], you can use the BatchRebuildBiblioTables script 16:21 caroline misc/batchRebuildBiblioTables.pl 16:24 alexted[m] caroline: thanks caroline! :) 16:24 alexted[m] do I have to run it from the command line correct? 16:24 caroline yes 16:27 alexted[m] caroline: thanks! :) 16:27 alexted[m] do you suggest running batchRebuildItemsTables.pl as well? 16:27 caroline If you made changes in the mapping of item fields, then yes. Otherwise it's not necessary 16:28 caroline One thing I'm not sure about is the effect of running this in production while operations are ongoing. I always run it at night on production systems just in case 16:30 alexted[m] caroline: Thanks for the warning :) 16:30 alexted[m] caroline: ok! 16:30 caroline np :) 16:30 alexted[m] just one more question: is there a script for authority tables too? 16:31 caroline the auth_header table doesn't have mappings to marc afaik 16:34 alexted[m] ok! Thanks again for the valuable advice! Have a nice day! :) 16:34 caroline you too! good luck! 16:34 alexted[m] thanks! :) 16:50 cait caroline: just saw the email \o/ 16:52 cait caroline: the newsletter one - so the subscription worked :) 16:52 caroline yay!