[Koha] Koha Digest, Vol 184, Issue 5

Fri Feb 5 12:53:00 NZDT 2021

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 at lists.katipo.co.nz> On Behalf Of koha-request at lists.katipo.co.nz
Sent: Thursday, February 4, 2021 3:00 PM
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 184, Issue 5

Send Koha mailing list submissions to
	koha at 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.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=pUCyqCBZtZfC2q6kT7zrAK%2BqWFyJ%2FFkBNy8iWOr%2FR6Y%3D&reserved=0
or, via email, send a message with subject or body 'help' to
	koha-request at lists.katipo.co.nz

You can reach the person managing the list at
	koha-owner at 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 at live.com>
To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: [Koha] Hourly backup
Message-ID:
	<BYAPR05MB495142F58F020154FD37F473FAB39 at 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 at adminkuhn.ch>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Framework ACQ causes mutilated special characters
Message-ID: <9bcde279-5682-4193-213f-137aedc8d2d2 at 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-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D23675&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=gzNdEcgjpfRxm9NpbYyFp6mACLjb47I6k60NQ5Hktjs%3D&reserved=0
(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 at adminkuhn.ch · W https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.adminkuhn.ch%2F&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=4djvZvXcUJknyjJ5OLL%2FkMBQ%2FKDCrYJg%2Bwzym41KSqY%3D&reserved=0

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-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D23675&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673144571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Z06JMYtzDM%2B%2BYQWFUCQ8b%2FJ7udywuYnxCfGctfCN%2FgY%3D&reserved=0
> 
> 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 at phonecoop.coop>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Hourly backup
Message-ID: <20210204161032.7dc5312e at bletchley.towers.org.uk>
Content-Type: text/plain; charset=US-ASCII

Raphael Meyer <rpm143 at 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.org.uk%2F&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673144571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=LCaaR1hAO04SDfXozAitZMkTwWfq7lEk7PLTRrPhZHI%3D&reserved=0
Member of https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.software.coop%2F&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673144571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=eTjYW%2FZ9L3H7GkbXzrDdA6CGJ3DK7N6u9TBtOQWgiFU%3D&reserved=0 (but this email is my personal view
only)

------------------------------

Message: 4
Date: Thu, 4 Feb 2021 11:29:04 -0500
From: Cindy Murdock Ames <cmurdock at ccfls.org>
To: Koha <koha at lists.katipo.co.nz>
Subject: [Koha] Publication date (yyyy-yyyy) advanced search option
	not working in my Koha instance
Message-ID:
	<CAMF9J8++qzzW8i9uPio55wwE7hMDuW=XjApSysNxOpTx22vcvA at 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%2Fmeadvillelibrary.org%2F&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673144571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hB73niMkJwXlQIbEsplh%2F8xzu6003sax16S5BKzB%2Fmw%3D&reserved=0 | https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fccfls.org%2F&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673144571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=324zmX7tNbxDFtV475WvxKjMO6g0Rk5xc1OKk6Fko6I%3D&reserved=0

------------------------------

Subject: Digest Footer

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637480764673144571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=01OPtvYfTsOIaICGAMobzvDO7CJwOErMgy%2FiOlQWloI%3D&reserved=0

------------------------------

End of Koha Digest, Vol 184, Issue 5
************************************