Re: [Koha] Koha Digest, Vol 184, Issue 5

[Raphael Meyer]

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  On Behalf Of 
koha-requ...@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.katipo.co.nz%2Fmailman%2Flistinfo%2Fkohadata=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=pUCyqCBZtZfC2q6kT7zrAK%2BqWFyJ%2FFkBNy8iWOr%2FR6Y%3Dreserved=0
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz

You can reach the person managing the list at
koha-ow...@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 (-) advanced search option not
  working in my Koha instance (Cindy Murdock Ames)


--

Message: 1
Date: Thu, 4 Feb 2021 12:30:49 +
From: Raphael Meyer 
To: "koha@lists.katipo.co.nz" 
Subject: [Koha] Hourly backup
Message-ID:



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
 for Windows 10



--

Message: 2
Date: Thu, 4 Feb 2021 16:00:52 +0100
From: Michael Kuhn 
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Framework ACQ causes mutilated special characters
Message-ID: <9bcde279-5682-4193-213f-137aedc8d...@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%3D23675data=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=gzNdEcgjpfRxm9NpbYyFp6mACLjb47I6k60NQ5Hktjs%3Dreserved=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 m...@adminkuhn.ch · W 
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.adminkuhn.ch%2Fdata=04%7C01%7C%7C7c8ff2187c834b4568d008d8c960bf04%7C84df9e7fe9f640afb435%7C1%7C0%7C637480764673134577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=4djvZvXcUJknyjJ5OLL%2FkMBQ%2FKDCrYJg%2Bwzym41KSqY%3Dreserved=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. 
> 

[Koha] Publication date (yyyy-yyyy) advanced search option not working in my Koha instance

[Cindy Murdock Ames]

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://meadvillelibrary.org | https://ccfls.org
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Hourly backup

[MJ Ray]

Raphael Meyer  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 http://mjr.towers.org.uk/
Member of http://www.software.coop/ (but this email is my personal view
only)

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Framework ACQ causes mutilated special characters

[Michael Kuhn]

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://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23675 
(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 m...@adminkuhn.ch · W www.adminkuhn.ch



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://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23675


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





___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Hourly backup

[Raphael Meyer]

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 for Windows 10

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha