Time Nick Message 02:12 tcohen night all 02:12 kathryn night tcohen :) 02:12 tcohen should be awake some day soon 02:12 tcohen to share smoe hours with you all 02:13 kathryn :) 02:14 tcohen not tonight, maybe tomorrow 06:41 reiveune hello 06:54 alex_a Bonjour 08:31 ashimema Good morning #koha 08:56 nlegrand salut 08:56 wahanui kia ora, nlegrand 08:56 nlegrand bonjour wahanui 08:56 wahanui hey, nlegrand 09:19 nlegrand Ok, so if Bug 25951 is a good idea and if it's a performance improvement, I'm ready to work on similar cases. 09:19 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25951 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Koha::Objects using the DBIx::Class relationships in Koha::Hold and Koha::Item 09:20 nlegrand It seems with the test I have a few tens of seconds less with the prefetch way. 09:20 Joubu Hi nlegrand 09:20 nlegrand Hey Joubu! 09:20 Joubu I would not create a separate test file 09:20 Joubu RelatedObjects.t code can be moved to a subtest of Koha/Items.t 09:21 nlegrand Ok, I'll do that! (but later as I soon have to play hide and seek...) 09:21 Joubu On your way, you could create a Koha::Hold->library and ->patron 09:21 Joubu ->branch and ->borrower will call ->library and ->patron 09:22 Joubu branch and borrower could be marked as deprecated 09:24 Joubu nlegrand: I am gonna let you a comment 09:25 nlegrand thanks! 10:23 ashimema :) 10:23 huginn News from kohagit: Bug 8338: (QA follow-up) Fix test for backdated return <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=56ee42082f0382d2b5e5a8cef081bef886664d7d> 10:23 huginn News from kohagit: Bug 23820: Fix Koha/Club/Hold.t <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4f5f5d88b98c2d1f6cc20bc6be6f5b41fb7d3c48> 10:23 ashimema nlegrand__ 10:23 huginn News from kohagit: Bug 24151: Use fully qualified names for UpdateStats <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4aa93f04f406b010cd26ea121332133f2599f800> 10:23 huginn News from kohagit: Bug 22844: Fix yaml_valid.t - don't pick .json files <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1326fa076b2311ffd9a1df4b995309670bf55cdd> 10:23 ashimema nlegrand++ even.. 10:23 ashimema Love your updated version of the session level desks bug :) 10:24 * ashimema is using a very similar approach for bug 24786 now 10:24 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24786 enhancement, P5 - low, ---, martin.renvoize, NEW , Allow setting a cash register for a login session 11:03 koha-jenkins Yippee, build fixed! 11:03 wahanui Congratulations! 11:03 koha-jenkins Project Koha_Master_D9 build #1386: FIXED in 39 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1386/ 11:08 koha-jenkins Yippee, build fixed! 11:08 wahanui Congratulations! 11:08 koha-jenkins Project Koha_Master_D10_Deps build #26: FIXED in 43 min: https://jenkins.koha-community.org/job/Koha_Master_D10_Deps/26/ 11:08 tcohen morning 11:17 koha-jenkins Project Koha_Master_D10 build #299: STILL UNSTABLE in 52 min: https://jenkins.koha-community.org/job/Koha_Master_D10/299/ 11:25 Joubu Hola Tomas, are you still on bug 25826? 11:25 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25826 critical, P3, ---, tomascohen, NEW , Hiding biblionumber in the frameworks breaks links in result list 11:27 koha-jenkins Yippee, build fixed! 11:27 wahanui Congratulations! 11:27 koha-jenkins Project Koha_Master_U20 build #40: FIXED in 1 hr 3 min: https://jenkins.koha-community.org/job/Koha_Master_U20/40/ 11:32 nlegrand ashimema: thank ^^ 11:42 koha-jenkins Yippee, build fixed! 11:42 wahanui Congratulations! 11:42 koha-jenkins Project Koha_Master_U18 build #840: FIXED in 39 min: https://jenkins.koha-community.org/job/Koha_Master_U18/840/ 11:47 cait2 hm is https://lists.koha-community.org/ down again? 11:47 cait2 no bug mail and the site doesn't come up 11:53 koha-jenkins Yippee, build fixed! 11:53 wahanui Congratulations! 11:53 koha-jenkins Project Koha_Master_U16 build #21: FIXED in 45 min: https://jenkins.koha-community.org/job/Koha_Master_U16/21/ 12:09 koha-jenkins Project Koha_Master_D11 build #37: STILL UNSTABLE in 52 min: https://jenkins.koha-community.org/job/Koha_Master_D11/37/ 12:24 koha-jenkins Project Koha_Master_D9_My8 build #368: STILL UNSTABLE in 41 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/368/ 12:38 huginn News from kohagit: Bug 25792: Rename 'ttf-dejavu' package to 'fonts-dejavu' for Debian 11 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=14932ae7d3bf864f64bffc9b1b015a07e11c8e2e> 12:39 koha-jenkins Project Koha_Master_D9_MDB_Latest build #345: STILL UNSTABLE in 46 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/345/ 12:54 tcohen @later tell mtj your node is down 12:54 huginn tcohen: The operation succeeded. 13:18 koha-jenkins Project Koha_Master_D9 build #1387: SUCCESS in 39 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1387/ 13:25 koha-jenkins Project Koha_Master_D9_MDB_Latest build #346: STILL UNSTABLE in 45 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/346/ 13:38 koha-jenkins Project Koha_Master_U18 build #841: SUCCESS in 58 min: https://jenkins.koha-community.org/job/Koha_Master_U18/841/ 13:44 koha-jenkins Project Koha_Master_U20 build #41: UNSTABLE in 1 hr 5 min: https://jenkins.koha-community.org/job/Koha_Master_U20/41/ 13:54 koha-jenkins Yippee, build fixed! 13:54 wahanui Congratulations! 13:54 koha-jenkins Project Koha_Master_D10 build #300: FIXED in 36 min: https://jenkins.koha-community.org/job/Koha_Master_D10/300/ 14:08 koha-jenkins Project Koha_Master_D10_Deps build #27: SUCCESS in 43 min: https://jenkins.koha-community.org/job/Koha_Master_D10_Deps/27/ 14:32 koha-jenkins Project Koha_Master_D11 build #38: STILL UNSTABLE in 54 min: https://jenkins.koha-community.org/job/Koha_Master_D11/38/ 14:33 koha-jenkins Project Koha_Master_U16 build #22: SUCCESS in 38 min: https://jenkins.koha-community.org/job/Koha_Master_U16/22/ 14:44 bigbrovar Hi guys. I am currently trying to recover a server which hard drive crashed. Luckily I was able to recover the files at /var/spool/koha intact. If I want to restore the file to a new instance of KOHA. How can I go about it. The koha instance before the crash was installed 5 years ago and I doubt if it was ever updated or maintained. Please what would you suggest as the best approach to restoring to a new instance. 14:58 koha-jenkins Yippee, build fixed! 14:58 wahanui Congratulations! 14:58 koha-jenkins Project Koha_Master_D9_My8 build #369: FIXED in 49 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/369/ 15:00 Joubu bigbrovar: Did you find a recent backup there? 15:12 bigbrovar Joubu: yes I did, I found some *.sql and some *.tar.gz files dated December 2019 or there about 15:14 bigbrovar So what I want to do is setup a koha instance on virtual box and see if I can restore the files and have a working system some worth... But I don't even know how to go about this and if restoring dB from a 5 year old version of KOHA would break things if restored to the latest stable version 15:25 koha-jenkins Project Koha_Master_D10_Deps build #28: UNSTABLE in 52 min: https://jenkins.koha-community.org/job/Koha_Master_D10_Deps/28/ 15:25 Joubu bigbrovar: it won't break. You can install a new fresh Koha instance on a new server, then restore the dump (command koha-restore), and execute the update DB process 15:26 bigbrovar Joubu: will do that thanks 15:48 bigbrovar By the way is there an arm port of KOHA? I live in Nigeria I have been working on replacing traditional servers with low power low cost computing devices (like the Pi 4, Odroids and Rockpro64 single board computers) it would really help lower cost of ownership and make it possible to run a data center of a small offgrid Solar setup with zero need for air conditioning. 15:51 bigbrovar Found this https://wiki.koha-community.org/wiki/Koha_on_a_Raspberry_Pi_3_B%2B :D 15:56 koha-jenkins Yippee, build fixed! 15:56 wahanui Congratulations! 15:56 koha-jenkins Project Koha_20.05_D9 build #35: FIXED in 39 min: https://jenkins.koha-community.org/job/Koha_20.05_D9/35/ 16:06 koha-jenkins Project Koha_20.05_D9_My8 build #27: SUCCESS in 49 min: https://jenkins.koha-community.org/job/Koha_20.05_D9_My8/27/ 16:11 Joubu bigbrovar: Also http://avengingchicken.online/misc/installing_koha_on_raspberry-pi-4.pdf 16:19 koha-jenkins Project Koha_20.05_D11 build #30: STILL UNSTABLE in 54 min: https://jenkins.koha-community.org/job/Koha_20.05_D11/30/ 16:26 koha-jenkins Project Koha_20.05_U20 build #24: SUCCESS in 1 hr 8 min: https://jenkins.koha-community.org/job/Koha_20.05_U20/24/ 16:35 koha-jenkins Yippee, build fixed! 16:35 wahanui Congratulations! 16:35 koha-jenkins Project Koha_20.05_U18 build #30: FIXED in 38 min: https://jenkins.koha-community.org/job/Koha_20.05_U18/30/ 16:44 reiveune bye 16:50 koha-jenkins Project Koha_20.05_U16 build #25: STILL UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_20.05_U16/25/ 17:03 tcohen @seen mtj 17:03 huginn tcohen: mtj was last seen in #koha 1 week, 0 days, 4 hours, 30 minutes, and 47 seconds ago: <mtj> yes, that too :) 17:11 koha-jenkins Project Koha_20.05_D10 build #33: SUCCESS in 52 min: https://jenkins.koha-community.org/job/Koha_20.05_D10/33/ 20:56 caroline I can totally tell when screenshots in the manual were made by me, because there is (almost) always a cat reference https://koha-community.org/manual/18.11/en/html/_images/editbatch.png 20:57 rangi lol 21:26 bigbrovar Hi guys. I am trying to recover drives from a koha server that crashed. Fortunately the files in /var/spool/koha seem to be fine and we're recovered. I am currently trying to restore them to a new instance of KOHA. I can't seem to find documentation on how best to approach this. 21:26 bigbrovar I tried to do koha-restore sqldump configdump but that gave an error 21:26 hayley what error did you get bigbrovar? 21:28 bigbrovar No such file or directory which then lead to other errors. I am on my phone now so I can't copy. Let me trying get it to pastebin on the computer 21:30 bigbrovar hayley: https://pastebin.ubuntu.com/p/nDWqTxmHwq/ 21:30 mtj hey #koha 21:30 hayley hey mtj 21:31 hayley bigbrovar are you running that in the directory that has those two files? I haven't used koha-restore before 21:31 mtj bigbrovar: i think there are problems with your koha-restore method 21:31 bigbrovar I felt running restore on a fresh instance of KOHA won't work. I tried to move the recovered files and directory to /var/spool/koha before running koha-restore but that also didn't work. 21:31 mtj hay hayley 21:32 bigbrovar mtj: i feel so too just don't know what the right way is 21:32 bigbrovar Haven't been able to find anything online. 21:32 hayley bigbrovar to get the db back in I would normally run sudo koha-mysql instance < file.sql 21:32 hayley where file.sql is your db dump unzipped 21:32 bigbrovar Cool 21:33 hayley not sure about the configs though 21:33 mtj bigbrovar: koha-restore assumes that you are restoring to a system with the *same* koha version as the koha backup 21:33 bigbrovar hayley: in the case of a fresh install. Do I create the instance first or running koha-myswl instance does that 21:34 hayley bigbrovar you'd need to create the instance and its db first 21:34 bigbrovar mtj: oh wow.. And this is so far from being the case. Infact the system was installed and last updated 5 years ago. The new instance is the latest koha stable. 21:35 mtj bigbrovar: hayley has the best advice ^ 21:36 mtj bigbrovar:... its a bit like applying a windows 7 backup.. to windows 10 :) 21:39 bigbrovar mtj: it won't work right? I was told earlier today that it is fine as long as I run dB updates. 21:40 bigbrovar Given my situation.. Is it better to install the dated version of KOHA (5 years ago) and work my way up from there 21:44 mtj bigbrovar: follow hayley's advice 21:45 mtj create a new koha instance and load the old sql file into the database 21:46 bigbrovar OK running koha-mysql went well. 21:46 bigbrovar Well no errors 21:48 mtj $ sudo koha-upgrade-schema mykoha1 21:49 mtj ..that updates the db ^ 21:50 mtj or you can do it via the web-installer too 21:51 bigbrovar mtj: doing that now. Thanks 21:51 mtj command-line is a bit more reliable for looooong updates :0) 21:52 bigbrovar Yeah. It is done. 21:53 mtj congrats 21:54 mtj $ sudo koha-rebuild-zebra -f mykoha1 21:54 mtj ...rebuilds zebra db ^ 21:55 bigbrovar Running now 21:56 bigbrovar CPU is burning.. 21:56 bigbrovar Done 21:57 bigbrovar mtj: thanks alot. 21:57 bigbrovar mtj: can the config backup also been restored 22:00 mtj bigbrovar: hmm, you'll have to manually restore the koha-conf.xml file 22:01 bigbrovar OK. I can extract and copy and replace? 22:01 bigbrovar The config file is a tar.gz 22:01 mtj compare the old/new files and add the important parts that are missing 22:01 mtj yeah, extract config.tgz 22:02 bigbrovar Okk.. 22:02 bigbrovar Would find to find a comandline fu that allows me to compare and add missing parts 22:03 mtj i find the best way is just a text editor and eyes 22:04 bigbrovar Lol 22:05 bigbrovar Just extracted the config and most of the stuff there can really be done without. It seems to pack everything about the previous install including error logs and bash history 22:06 mtj yeah, its really just the koha-conf.xml file and apache files that are tricky for a restore 22:07 bigbrovar How important is the koha-conf.xml 22:08 bigbrovar Just loaded the server now and it runs file 22:08 bigbrovar Opac loads fine 22:09 mtj hmm, sometimes important authentication info is added the koha-conf file, like ldap 22:10 bigbrovar No ldap authentication here. That I am sure. 22:10 bigbrovar I will go through it just to be sure 22:11 bigbrovar I will run a vimdiff between the backup and current file and see if any fancy thing comes up 22:11 mtj yep, good idea 22:13 mtj "How important is the koha-conf.xml"... its the main config file 22:14 mtj so... very important :) 23:55 tuxayo Anyone are with admin rights on the translation platform? I need to mark 5 strings (x3 versions) as "needworks" 23:56 tuxayo And only an admin on the language or the whole translation platform can do that 23:56 tuxayo The languages are Arabic, Polish, Urdu and Welsh. 23:56 tuxayo Even better would be to have speakers here to fix the translations directly.