I used this command: */60 * * * * mysqldump -ukoha_library -pkoha123 Koha_library | xz > /home/koha/backup/koha_library.sql.xz Last it worked was on Sunday March 31 at 6 am my time. Has not worked since. -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of koha-request@lists.katipo.co.nz Sent: Thursday, February 4, 2021 3:00 PM To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 184, Issue 5 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katip... or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Hourly backup (Raphael Meyer) 2. Re: Framework ACQ causes mutilated special characters (Michael Kuhn) 3. Re: Hourly backup (MJ Ray) 4. Publication date (yyyy-yyyy) advanced search option not working in my Koha instance (Cindy Murdock Ames) ---------------------------------------------------------------------- Message: 1 Date: Thu, 4 Feb 2021 12:30:49 +0000 From: Raphael Meyer <rpm143@live.com> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: [Koha] Hourly backup Message-ID: <BYAPR05MB495142F58F020154FD37F473FAB39@BYAPR05MB4951.namprd05.prod.outlook.com> Content-Type: text/plain; charset="us-ascii" The hourly back up has stopped working on my machine. Have Ubuntu 20 and Koha 20. I tried the Crontab -e but it did not work either. I have no idea how I lost it but would like to put it back. Br Raphael Sent from Mail<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D550986&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=eGgAdaGT2ZVdqXMKJYr6T79BRAzE14eYP%2Bpl%2BpITivs%3D&reserved=0> for Windows 10 ------------------------------ Message: 2 Date: Thu, 4 Feb 2021 16:00:52 +0100 From: Michael Kuhn <mik@adminkuhn.ch> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Framework ACQ causes mutilated special characters Message-ID: <9bcde279-5682-4193-213f-137aedc8d2d2@adminkuhn.ch> Content-Type: text/plain; charset=utf-8; format=flowed Hi Caroline Unfortunately it doesn't help just adding MARC 000, or adding MARC 000 and setting a default value of " nam a22 7a 4500". Still special characters are mutilated. I have now tested this with Koha 18.11.03, 19.11.05 and 20.11.00. I have commented the bug report accordingly: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-c... (UseACQFrameworkForBiblioRecords default framework is missing LDR breaking encoding) One library uses the following workaround: Instead of going to menu "Acquisitions" and adding an order to the basket "From a new (empty) record", they first create the title data record and then add the order to the basket "From an existing record" by giving the number of the created title data record. Many thanks for giving me hints and creating the original bug report! Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.adminkuh... Am 03.02.21 um 23:07 schrieb Caroline Cyr-La-Rose:
Hi Michael,
Unfortunately, I don't remember which library had this problem (I work for a company that supports over 40 libraries), so I'm not sure I could find the framework again to export it.
However, I did find the bug report that I filled way back when I had this problem. https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-c...
You can read what I did (I mention a default value, maybe that's the crux of the problem).
Regards,
Caroline
On 21-02-03 16 h 30, Michael Kuhn wrote:
Hi Caroline
When I had this problem, had to do with the leader (field 000) the the ACQ framework. The leader (position 9) indicates the character encoding. If it's not there, Koha freaks out and mangles the special characters.
So to solve your problem, add field 000 in your ACQ framework.
This was my first idea as well but unfortunately it didn't change the behavior. Also field 000 isn't shown in the section "Catalog details" when creating a new order. But it is shown when opening Koha menu "Administration > MARC frameworks > ACQ".
When opening the record with framework ACQ no field 000 is shown.
When opening the record with standard framework (what happens when showing the cataloging view directly after creating an order) field 000 is there with correct value "a" in position 9.
But in both cases special characters in MARC 245 $a are mutilated.
May I ask you to export and send me the CSV file of framework ACQ you have created? Maybe there is some difference in our frameworks.
Best wishes: Michael
------------------------------ Message: 3 Date: Thu, 4 Feb 2021 16:10:32 +0000 From: MJ Ray <mjr@phonecoop.coop> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Hourly backup Message-ID: <20210204161032.7dc5312e@bletchley.towers.org.uk> Content-Type: text/plain; charset=US-ASCII Raphael Meyer <rpm143@live.com> wrote:
The hourly back up has stopped working on my machine. Have Ubuntu 20 and Koha 20. I tried the Crontab -e but it did not work either. I have no idea how I lost it but would like to put it back.
Br Raphael Which instructions did you use to set it up? When did you last know it worked and can you find any messages in any logs from that time? Do you still have some package called something like "cron" installed on there? Maybe systemd-cron? Hope that helps, -- MJR https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmjr.towers.o... Member of https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.software... (but this email is my personal view only) ------------------------------ Message: 4 Date: Thu, 4 Feb 2021 11:29:04 -0500 From: Cindy Murdock Ames <cmurdock@ccfls.org> To: Koha <koha@lists.katipo.co.nz> Subject: [Koha] Publication date (yyyy-yyyy) advanced search option not working in my Koha instance Message-ID: <CAMF9J8++qzzW8i9uPio55wwE7hMDuW=XjApSysNxOpTx22vcvA@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hi all, We recently upgraded to 20.05.08 from 19.11, and we've found that the advanced search option in the staff interface for publication date by year range isn't producing any results for us if we use it. Specifying it with y,st-year in the keyword search instead *does* produce results though. Does anyone have any ideas what might cause this? I've tested it on Bywater's demo, which is running 20.05.04, and it does work there, so I'm guessing it's some quirk specific to our system rather than an actual bug (unless it happened to be introduced between the .04 and .08 releases). Here's our server specs: Koha version: 20.05.08.000 OS version ('uname -a'): Linux ccflskoha.ccfls.org 4.15.0-135-generic #139-Ubuntu SMP Mon Jan 18 17:38:24 UTC 2021 x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.026001 Perl @INC: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.26.1 /usr/local/share/perl/5.26.1 /usr/lib/x86_64-linux-gnu/perl5/5.26 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.26 /usr/share/perl/5.26 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base /var/lib/koha/ccfls/plugins MySQL version: mysql Ver 15.1 Distrib 10.4.17-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Apache version: Server version: Apache/2.4.29 (Ubuntu) PSGI: Plack (deployment) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_ccfls | Status: running. | Config read from: koha-conf.xml Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU Date and time: 02/04/2021 11:16 Time zone: Used: America/New_York | Config: Undefined | Environment (TZ): Undefined Many thanks, Cindy ----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmeadvilleli... | https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fccfls.org%2... ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katip... ------------------------------ End of Koha Digest, Vol 184, Issue 5 ************************************