Re: [Koha] Session time outs in latest stable version?

[Jonathan Druart]

Hi,
What's the error? (look at the Koha log files)
Is the server's disk full?
See https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36034
It should be released soon.

Le jeu. 22 févr. 2024 à 13:26, Evan Stewart  a écrit :
>
> Hello,
>
> Does the latest version of Koha have a new session time our setting? One
> that limits users to 90 min sessions?
>
> Last week I ran an update on my server and saw that the latest stable
> branch of Koha was available. The other updates looked like normal Debian
> patches/updates. I'm using a Debian VM on AWS Lightsail.
>
> A few days later, my main user of Koha started reporting that the server
> started to crash. He was getting a generic "Internal server error".
>
> After a few times of this, I was able to check the issue when it actually
> occured, but I was able to access the application without error. I don't
> see any errors messages in server logs.
>
> The user is able to log in and work for about 90 minutes each time and then
> he gets kicked out with the vague error message.
>
> After a long wait time, or a server reboot, he can log back in.
>
> We've been running Koha on the server for nearly a year without any issues.
>
> -Evan Stewart
> Africa's Hope
> Springfield, MO
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Language instalation problem installing an adtional language

[Jonathan Druart]

Yes, it's a known bug, ignore the warning.
See https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22217

Le jeu. 22 févr. 2024 à 10:32, David Liddle  a écrit :
>
> Hello Paulo! I'm glad to hear that your installation is working
> normally now. In my experience, that error message is to be expected
> when installing or updating each translation. Someone more familiar
> with the process or with the underlying web server functions would be
> able to explain the momentary disruption in detail.
>
> On Wed, Feb 21, 2024 at 7:10 PM Paulo Neto  wrote:
> >
> > Hello David,
> >
> > Thnak you for your usefull email i compared to my directories and the prog 
> > doesnt make any sense probably something put there, i fallowed your advice 
> > and created our pics folder on the instance directory 
> > (/var/lib/koha/ourinstancename) i changed the pic references on the opac to 
> > /web/ourpics.jpg
> > And then deleted the prog directory on the /web/planonacionalleirura.png , 
> > then i was able to install the language withouth any errors, except for 
> > this one:
> >
> > Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are the 
> > unix socket permissions set properly? Is the host reachable? > > If you 
> > ignore this warning, you will face performance issues
> >
> > Did you have this same error when you instaled your languages? Is there a 
> > way to check the translation version of a certain langauge?
> >
> > The language ended up to be installed and i could remove it and install it 
> > again.
> >
> > Best regards,
> >
> > Paulo Neto
> >
> > DSIGA / DPGI
> > Tel. (+351) 21 844 2228
> > http://www.dgadr.gov.pt
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -Mensagem original-
> > De: David Liddle 
> > Enviada: 21 de fevereiro de 2024 14:58
> > Para: Paulo Neto 
> > Cc: koha 
> > Assunto: Re: [Koha] Language instalation problem installing an adtional 
> > language
> >
> > Hello Paulo, you can certainly put the folder 'pic_dgadr' in the 'htdocs'. 
> > However, that directory is not included in the normal Koha backup routine. 
> > For the system I manage, I created a 'web' directory (among others) in the 
> > following location, in which '{instance}' is not literal but a 
> > representation of the Koha instance's name:
> >
> > /var/lib/koha/{instance}/
> >
> > and added the following directive (exactly as shown) in
> > /etc/koha/apache-shared-opac.conf:
> >
> > # Add '/web' directory to the OPAC interface Alias /web 
> > "/var/lib/koha/${instance}/web"
> > 
> > Require all granted
> >   
> > Require all denied
> >   
> > 
> >
> > With respect to the language directories, this is what appears on our test 
> > system – which is also multilingual and runs Koha 22.11.14 – when I run the 
> > 'tree' command (must be installed):
> >
> > $ sudo tree -d -L 2 /usr/share/koha/opac/htdocs/opac-tmpl/
> > /usr/share/koha/opac/htdocs/opac-tmpl/
> > ├── bootstrap
> > │   ├── css
> > │   ├── de-DE
> > │   ├── en
> > │   ├── fr-FR
> > │   ├── id-ID
> > │   ├── images
> > │   ├── itemtypeimg
> > │   ├── js
> > │   ├── lib
> > │   ├── th-TH
> > │   ├── zh-Hans-CN
> > │   └── zh-Hant-TW
> > ├── lib
> > │   ├── Chocolat
> > │   ├── dayjs
> > │   ├── emoji-picker
> > │   ├── famfamfam
> > │   ├── flatpickr
> > │   ├── jquery
> > │   ├── js-cookie
> > │   ├── kjua
> > │   └── verovio
> > └── xslt
> >
> > $ sudo tree -d -L 2 /usr/share/koha/intranet/htdocs/intranet-tmpl/
> > /usr/share/koha/intranet/htdocs/intranet-tmpl/
> > ├── js
> > ├── lib
> > │   ├── bootstrap
> > │   ├── Chocolat
> > │   ├── codemirror
> > │   ├── d3c3
> > │   ├── datatables
> > │   ├── dayjs
> > │   ├── flatpickr
> > │   ├── font-awesome
> > │   ├── greybox
> > │   ├── jquery
> > │   ├── js-cookie
> > │   ├── jsdiff
> > │   ├── keyboard
> > │   ├── koha
> > │   ├── leaflet
> > │   ├── linters
> > │   ├── select2
> > │   ├── shortcut
> > │   └── tiny_mce
> > └── prog
> > ├── css
> > ├── de-DE
> > ├── en
> > ├── fr-FR
> > ├── id-ID
> > ├── img
> > ├── js
> > ├── pdf
> > ├── sound
> > ├── th-TH
> > ├── zh-Hans-CN
> > └── zh-Hant-TW
> >
> > You can see the directory's layout and contents quite clearly. The error 
> > you received appears to have a mixup, since the 'opac-tmpl'
> > directory does not contain one named 'prog'; that can be found under 
> > 'intranet-tmpl'. If my assessment is incorrect about something not being 
> > right in your installation, I hope that someone more knowledgeable will 
> > point that out. If your installation is truly a test, then I might be 
> > tempted to back up the data and reinstall Koha.
> >
> > Regards,
> >
> > David Liddle
> > System Administrator
> > david.lid...@wycliff.de (but not for this list)
> >
> > Wycliff e.V., https://wycliff.de
> > Seminar für Sprache und Kultur, https://spracheundkultur.org 
> > Internationales Tagungszentrum Karimu, https://karimu.de
> >
> > On Wed, Feb 21, 2024 at 2:02 PM Paulo Neto  wrote:
> > >
> > > Hello  David,
> > 

Re: [Koha] Koha translation site mailing function cannot work

[Jonathan Druart]

Hello,

Can you try again? It should be fixed now.

Regards,
Jonathan

Le jeu. 15 févr. 2024 à 04:50, SYDT - Frank Chou  a
écrit :

> Dear Sir/Madam,
>
> We have some people to translate English to Chinese.
> But the translation site's mailing function seems not working now.
> So, they cannot get the registration mail or forget password notification.
> Can someone help to fix this?
> Thanks very much
>
> Best regards,
>
> Frank Chou
>
> --
> 碩陽數位科技有限公司
> Shou Yang Digital Technology
> Tel: 02-82280288
> Fax: 02-82265022
> 10F. No. 166, Jianyi Rd., Chung Ho Dist., New Taipei City 23511, Taiwan,
> R.O.C.
> 23511新北市中和區建一路166號10F
> http://www.sydt.com.tw
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1

[Jonathan Druart]

Those _tmp tables should not exist, no idea where they are coming from.
If their structures are the same as the ones in kohastructure.sql I
guess you could simply rename them.

Le mar. 19 déc. 2023 à 14:32,  a écrit :
>
> So, my database is "library." Thus, my command line and results for all 
> "creator_*" tables are:
>
>  Screen snip 
>
> koha-mysql library
> ..
> MariaDB [koha_library]> show tables;
> 
> | creator_batches_tmp|
> | creator_images   |
> | creator_layouts_tmp |
> | creator_templates_tmp|
> 
>
> - End Screen Snip -
>
> As shown, creator_layouts_tmp exists, but not creator_layouts.
>
> I have not missed any upgrades as far as I can tell, so I'm not sure why a 
> table would suddenly be missing. Anyway, thanks for any further helps here.
>
> Scott
>
> -Original Message-
> From: Jonathan Druart 
> Sent: Tuesday, December 19, 2023 2:45 AM
> To: skaman...@gmail.com
> Cc: koha 
> Subject: Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1
>
> > ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
> > 'koha_library.creator_layouts' doesn't exist at
> > /usr/share/koha/lib/C4/Installer.pm line 741
>
> Do you have an instance 'koha_library'? Is the DB correctly created?
> Try: `koha-mysql koha_library` then run "SHOW TABLES". Do you see 
> "creator_layouts"?
>
> Le lun. 18 déc. 2023 à 17:48,  a écrit :
> >
> > Hi Thomas,
> >
> >
> >
> > So, I got a new koha-common install error when using “apt -f install.” See 
> > below.
> >
> >
> >
> > --- Screen Snip --
> >
> > …..
> >
> > Upgrade to 23.06.00.051  [10:44:04]: Bug 10762 - Make it possible to
> > adjust the barcode height and width on labels
> >
> > ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
> > 'koha_library.creator_layouts' doesn't exist at
> > /usr/share/koha/lib/C4/Installer.pm line 741
> >
> > dpkg: error processing package koha-common (--configure):
> >
> > installed koha-common package post-installation script subprocess
> > returned error exit status 1
> >
> > Processing triggers for man-db (2.9.4-2) ...
> >
> > Errors were encountered while processing:
> >
> > koha-common
> >
> > E: Sub-process /usr/bin/dpkg returned an error code (1)
> >
> >
> >
> > --- End Screen Snip ---
> >
> >
> >
> > Any ideas?
> >
> >
> >
> > Thank you ,
> >
> >
> >
> > Scott
> >
> >
> >
> > From: Tomas Cohen Arazi 
> > Sent: Friday, December 15, 2023 7:29 PM
> > To: Sebastian Krieg 
> > Cc: skaman...@gmail.com; koha 
> > Subject: Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1
> >
> >
> >
> > This should do the trick too:
> >
> >
> >
> > ```
> >
> > apt -f install
> >
> > ```
> >
> >
> >
> > El vie, 15 dic 2023 20:44, Sebastian Krieg  > <mailto:sebastian.kr...@tuz-eisenach.de> > escribió:
> >
> > Hello,
> >
> > I got the same error. The reason is that you installed your language in 
> > former versions by hand. Now there is the news package koha-l10n.
> >
> > Please empty '/usr/share/koha/misc/translator/po/' (before make a backup!) 
> > and try the installation again.
> >
> > This should work.
> >
> > Greetings
> >
> > Sebastian
> >
> >
> > ---
> > mailto: sebastian.kr...@tuz-eisenach.de
> > <mailto:sebastian.kr...@tuz-eisenach.de>
> >
> >
> >
> > 15. Dezember 2023 17:30, skaman...@gmail.com <mailto:skaman...@gmail.com>  
> > schrieb:
> >
> > > Attempting to update Koha installation on Debian Bullseye host from
> > > 23.02.04-2 to 23.11.00-1. The following is the output and error
> > > message. Any ideas on how to resolve?
> > >
> > > # apt upgrade
> > >
> > > Reading package lists... Done
> > >
> > > Building dependency tree... Done
> > >
> > > Reading state information... Done
> > >
> > > Calculating upgrade... Done
> > >
> > > The following NEW packages will be installed:
> > >
> > > koha-l10n
> > >
> > > The following packages will be upgraded:
> > >
> > > koha-common
> > >
> > > 1 upg

Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1

[Jonathan Druart]

> ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table 
> 'koha_library.creator_layouts' doesn't exist at 
> /usr/share/koha/lib/C4/Installer.pm line 741

Do you have an instance 'koha_library'? Is the DB correctly created?
Try: `koha-mysql koha_library` then run "SHOW TABLES". Do you see
"creator_layouts"?

Le lun. 18 déc. 2023 à 17:48,  a écrit :
>
> Hi Thomas,
>
>
>
> So, I got a new koha-common install error when using “apt -f install.” See 
> below.
>
>
>
> --- Screen Snip --
>
> …..
>
> Upgrade to 23.06.00.051  [10:44:04]: Bug 10762 - Make it possible to adjust 
> the barcode height and width on labels
>
> ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table 
> 'koha_library.creator_layouts' doesn't exist at 
> /usr/share/koha/lib/C4/Installer.pm line 741
>
> dpkg: error processing package koha-common (--configure):
>
> installed koha-common package post-installation script subprocess returned 
> error exit status 1
>
> Processing triggers for man-db (2.9.4-2) ...
>
> Errors were encountered while processing:
>
> koha-common
>
> E: Sub-process /usr/bin/dpkg returned an error code (1)
>
>
>
> --- End Screen Snip ---
>
>
>
> Any ideas?
>
>
>
> Thank you ,
>
>
>
> Scott
>
>
>
> From: Tomas Cohen Arazi 
> Sent: Friday, December 15, 2023 7:29 PM
> To: Sebastian Krieg 
> Cc: skaman...@gmail.com; koha 
> Subject: Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1
>
>
>
> This should do the trick too:
>
>
>
> ```
>
> apt -f install
>
> ```
>
>
>
> El vie, 15 dic 2023 20:44, Sebastian Krieg   > escribió:
>
> Hello,
>
> I got the same error. The reason is that you installed your language in 
> former versions by hand. Now there is the news package koha-l10n.
>
> Please empty '/usr/share/koha/misc/translator/po/' (before make a backup!) 
> and try the installation again.
>
> This should work.
>
> Greetings
>
> Sebastian
>
>
> ---
> mailto: sebastian.kr...@tuz-eisenach.de 
> 
>
>
>
> 15. Dezember 2023 17:30, skaman...@gmail.com   
> schrieb:
>
> > Attempting to update Koha installation on Debian Bullseye host from
> > 23.02.04-2 to 23.11.00-1. The following is the output and error message. Any
> > ideas on how to resolve?
> >
> > # apt upgrade
> >
> > Reading package lists... Done
> >
> > Building dependency tree... Done
> >
> > Reading state information... Done
> >
> > Calculating upgrade... Done
> >
> > The following NEW packages will be installed:
> >
> > koha-l10n
> >
> > The following packages will be upgraded:
> >
> > koha-common
> >
> > 1 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
> >
> > Need to get 49.9 MB of archives.
> >
> > After this operation, 31.0 MB of additional disk space will be used.
> >
> > Do you want to continue? [Y/n] y
> >
> > Get:1 http://debian.koha-community.org/koha stable/main amd64 koha-l10n all
> > 23.11.00-1 [32.4 MB]
> >
> > Get:2 http://debian.koha-community.org/koha stable/main amd64 koha-common
> > all 23.11.00-1 [17.5 MB]
> >
> > Fetched 49.9 MB in 14s (3,540 kB/s)
> >
> > Reading changelogs... Done
> >
> > Preconfiguring packages ...
> >
> > /tmp/koha-common.config.bbiGxu: 49: koha-list: not found
> >
> > Selecting previously unselected package koha-l10n.
> >
> > (Reading database ... 182866 files and directories currently installed.)
> >
> > Preparing to unpack .../koha-l10n_23.11.00-1_all.deb ...
> >
> > Unpacking koha-l10n (23.11.00-1) ...
> >
> > dpkg: error processing archive
> > /var/cache/apt/archives/koha-l10n_23.11.00-1_all.deb (--unpack):
> >
> > trying to overwrite
> > '/usr/share/koha/misc/translator/po/am-Ethi-installer-MARC21.po', which is
> > also in package koha-common 23.05.04-2
> >
> > dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
> >
> > Preparing to unpack .../koha-common_23.11.00-1_all.deb ...
> >
> > Unpacking koha-common (23.11.00-1) over (23.05.04-2) ...
> >
> > Errors were encountered while processing:
> >
> > /var/cache/apt/archives/koha-l10n_23.11.00-1_all.deb
> >
> > E: Sub-process /usr/bin/dpkg returned an error code (1)
> >
> > ___
> >
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz 
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz 
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] 500 error for News, HTML customizations, Pages

[Jonathan Druart]

Sorry, I misread. I thought the problem was the generation of a notice.

So, second guess, you have a value in the table
additional_contents.borrowernumber that does not point to a valid patron.
But this value should not be wrong, there is a foreign key on it.

What do you mean by you "have truncated tables"? What have you done
exactly? Can you restore from a backup?



Le mer. 15 nov. 2023 à 12:25, Aida Djikic  a écrit :

> I don't know what that means, and how to correct it.
>
> On Wed, Nov 15, 2023 at 12:20 PM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
>> > Template process failed: undef error - DBIC result _type  isn't of the
>> _type Category at
>> /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc
>> line 6.
>>
>> You are calling patron-title.inc incorrectly.
>> My guess is that you are doing [% patron-title.inc patron =>
>> your_variable %] and your_variable is not a Koha::Patron object.
>> If it's a hashref you should use [% patron-title.inc borrower =>
>> your_variable %]
>>
>> Yes, it's confusing..
>>
>> Le mer. 15 nov. 2023 à 12:09, Aida Djikic  a
>> écrit :
>>
>>> Hello Jonathan,
>>>
>>> thank you for the instructions. I tried that, and got the following:
>>>
>>>
>>> ==> /var/log/koha/librarym21/api-error.log <==
>>>
>>> ==> /var/log/koha/librarym21/indexer-error.log <==
>>> 20231113 22:31:12 librarym21-koha-indexer: client (pid 1121) killed by
>>> signal 15, stopping
>>>
>>> ==> /var/log/koha/librarym21/indexer-output.log <==
>>>
>>> ==> /var/log/koha/librarym21/intranet-error.log <==
>>>
>>> ==> /var/log/koha/librarym21/opac-error.log <==
>>> [Tue Nov 14 15:11:31.794489 2023] [cgi:error] [pid 44770] [client
>>> 10.1.1.203:55927] AH01215: Use of uninitialized value $hits in numeric
>>> eq (==) at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 612.:
>>> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
>>> http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15
>>> [Tue Nov 14 15:11:31.837702 2023] [cgi:error] [pid 44770] [client
>>> 10.1.1.203:55927] AH01215: Use of uninitialized value $times in
>>> subtraction (-) at /usr/share/koha/lib/C4/Search.pm line 1714.:
>>> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
>>> http://10.1.3.174:8081/cgi-bin/koha/opac-page.pl?page_id=15
>>>
>>> ==> /var/log/koha/librarym21/plack-api-error.log <==
>>>
>>> ==> /var/log/koha/librarym21/plack-error.log <==
>>> Template process failed: undef error - DBIC result _type  isn't of the
>>> _type Category at
>>> /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/patron-title.inc
>>> line 6.
>>> 2023/11/15-11:14:03 Received QUIT. Running a graceful shutdown
>>> Sending children hup signal
>>> 2023/11/15-11:14:04 Worker processes cleaned up
>>> 2023/11/15-11:14:04 Server closing!
>>> Process Backgrounded
>>> 2023/11/15-11:14:04 Starman::Server (type Net::Server::PreFork)
>>> starting! pid(98759)
>>> Binding to UNIX socket file "/var/run/koha/librarym21/plack.sock"
>>> Setting gid to "1003 1003"
>>> Setting uid to "1003"
>>>
>>> ==> /var/log/koha/librarym21/plack-intranet-error.log <==
>>> [2023/11/15 10:17:26] [WARN] Use of uninitialized value $interface in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 10:17:26] [WARN] Use of uninitialized value $theme in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 10:17:39] [WARN] Use of uninitialized value $interface in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 10:17:39] [WARN] Use of uninitialized value $theme in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 10:47:10] [WARN] Use of uninitialized value $interface in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 10:47:10] [WARN] Use of uninitialized value $theme in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 11:07:30] [WARN] Use of uninitialized value $interface in
>>> concatenation (.) or string at /usr/share/koha/lib/C4/Languages.pm line 122.
>>> [2023/11/15 11:07:30] [WARN]

Re: [Koha] 500 error for News, HTML customizations, Pages

[Jonathan Druart]

abase.pm
> line 91. at /usr/share/koha/lib/Koha/Objects.pm line 312
> Cannot connect to the message broker, the jobs will be processed anyway
> (Failed to connect: Error connecting to localhost:61613: Connection refused
> at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at
> /usr/share/perl5/Net/Stomp.pm line 27.
> ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90.
> Cannot connect to the message broker, the jobs will be processed anyway
> (Failed to connect: Error connecting to localhost:61613: Connection refused
> at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at
> /usr/share/perl5/Net/Stomp.pm line 27.
> ) at /usr/share/koha/bin/workers/background_jobs_worker.pl line 90.
>
> ==> /var/log/koha/librarym21/z3950-error.log <==
>
> ==> /var/log/koha/librarym21/zebra-error.log <==
>
> ==> /var/log/koha/librarym21/zebra-output.log <==
>
>
>
> What does this mean and how do I deal with it?
>
> On Wed, Nov 15, 2023 at 11:20 AM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
>> Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the
>> 500. You should then see the relevant error.
>>
>> Le mer. 15 nov. 2023 à 10:42, Aida Djikic  a
>> écrit :
>>
>>> Alright, restarting Plack and memcached didn't work, and neither did
>>> upgrading the schema. I haven't yet been able to find where to go to
>>> access
>>> the error logs; once I do I should post them here?
>>>
>>> On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic 
>>> wrote:
>>>
>>> > Thank you Anke,
>>> >
>>> > I will try those!
>>> >
>>> >
>>> > On Tue, Nov 14, 2023, 16:33 Bruns, Anke  wrote:
>>> >
>>> >> Hi,
>>> >>
>>> >> a quick shot would be to restart Plack (if you use Plack, of course)
>>> >> and/or memcached.
>>> >> Or perhaps a "koha-upgrade-schema " may help.
>>> >>
>>> >> You might also have a look into the Plack log or the MySQL error log.
>>> >>
>>> >> These are just some things that helped us in some cases.
>>> Unfortunately a
>>> >> 500 error is pretty unspecific so it might be necessary to look
>>> deeper into
>>> >> the matter.
>>> >>
>>> >> Regards,
>>> >> Anke
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >> Anke Bruns M.A. (LIS)
>>> >> Arbeitsgruppe "Anwendungs- und Informationssysteme"
>>> >> E-Mail: anke.br...@gwdg.de
>>> >> -
>>> >> Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen
>>> (GWDG)
>>> >> Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
>>> >>
>>> >> Support: Tel.: +49 551 39-3, URL: https://gwdg.de/support
>>> >> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@gwdg.de
>>> >>
>>> >> Geschäftsführer: Prof. Dr. Ramin Yahyapour
>>> >> Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger
>>> >> Sitz der Gesellschaft: Göttingen
>>> >> Registergericht: Göttingen, Handelsregister-Nr. B 598
>>> >> -
>>> >> Zertifiziert nach ISO 9001 und ISO 27001
>>> >> -
>>> >>
>>> >>
>>> >>
>>> >> > -Ursprüngliche Nachricht-
>>> >> > Von: Koha  Im Auftrag von Aida
>>> Djikic
>>> >> > Gesendet: Dienstag, 14. November 2023 15:14
>>> >> > An: koha@lists.katipo.co.nz
>>> >> > Betreff: [Koha] 500 error for News, HTML customizations, Pages
>>> >> >
>>> >> > Hello all,
>>> >> >
>>> >> > I have noticed that going to Tools, then to any of these: News, HTML
>>> >> > customizations, Pages - results in a 500 error. This did not happen
>>> >> until I
>>> >> > recently truncated tables in an effort to remove a faulty import and
>>> >> ended
>>> >> > up having to re-create the super librarian user via the terminal.
>>> The
>>> >> pages
>>> >> > exist in the OPAC but I cannot access them from the staff interface
>>> in
>>> >> > order to edit them. Does anyone know how to solve this problem?
>>> Thank
>>> >> > you
>>> >> > in advance!
>>> >> >
>>> >> > --
>>> >> > Regards,
>>> >> > Aida
>>> >> > ___
>>> >> >
>>> >> > Koha mailing list  http://koha-community.org
>>> >> > Koha@lists.katipo.co.nz
>>> >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>> >>
>>> >
>>>
>>> --
>>> Regards,
>>> Aida
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>
> --
> Regards,
> Aida
>
___

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

Re: [Koha] 500 error for News, HTML customizations, Pages

[Jonathan Druart]

Try `tail -f /var/log/koha/*/*.log` then hit the page that causes the 500.
You should then see the relevant error.

Le mer. 15 nov. 2023 à 10:42, Aida Djikic  a écrit :

> Alright, restarting Plack and memcached didn't work, and neither did
> upgrading the schema. I haven't yet been able to find where to go to access
> the error logs; once I do I should post them here?
>
> On Wed, Nov 15, 2023 at 9:03 AM Aida Djikic  wrote:
>
> > Thank you Anke,
> >
> > I will try those!
> >
> >
> > On Tue, Nov 14, 2023, 16:33 Bruns, Anke  wrote:
> >
> >> Hi,
> >>
> >> a quick shot would be to restart Plack (if you use Plack, of course)
> >> and/or memcached.
> >> Or perhaps a "koha-upgrade-schema " may help.
> >>
> >> You might also have a look into the Plack log or the MySQL error log.
> >>
> >> These are just some things that helped us in some cases. Unfortunately a
> >> 500 error is pretty unspecific so it might be necessary to look deeper
> into
> >> the matter.
> >>
> >> Regards,
> >> Anke
> >>
> >>
> >>
> >> --
> >> Anke Bruns M.A. (LIS)
> >> Arbeitsgruppe "Anwendungs- und Informationssysteme"
> >> E-Mail: anke.br...@gwdg.de
> >> -
> >> Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen
> (GWDG)
> >> Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
> >>
> >> Support: Tel.: +49 551 39-3, URL: https://gwdg.de/support
> >> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@gwdg.de
> >>
> >> Geschäftsführer: Prof. Dr. Ramin Yahyapour
> >> Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger
> >> Sitz der Gesellschaft: Göttingen
> >> Registergericht: Göttingen, Handelsregister-Nr. B 598
> >> -
> >> Zertifiziert nach ISO 9001 und ISO 27001
> >> -
> >>
> >>
> >>
> >> > -Ursprüngliche Nachricht-
> >> > Von: Koha  Im Auftrag von Aida
> Djikic
> >> > Gesendet: Dienstag, 14. November 2023 15:14
> >> > An: koha@lists.katipo.co.nz
> >> > Betreff: [Koha] 500 error for News, HTML customizations, Pages
> >> >
> >> > Hello all,
> >> >
> >> > I have noticed that going to Tools, then to any of these: News, HTML
> >> > customizations, Pages - results in a 500 error. This did not happen
> >> until I
> >> > recently truncated tables in an effort to remove a faulty import and
> >> ended
> >> > up having to re-create the super librarian user via the terminal. The
> >> pages
> >> > exist in the OPAC but I cannot access them from the staff interface in
> >> > order to edit them. Does anyone know how to solve this problem? Thank
> >> > you
> >> > in advance!
> >> >
> >> > --
> >> > Regards,
> >> > Aida
> >> > ___
> >> >
> >> > Koha mailing list  http://koha-community.org
> >> > Koha@lists.katipo.co.nz
> >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
>
> --
> Regards,
> Aida
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

[Koha] All projects are now disabled on Pootle

[Jonathan Druart]

Hello,

I have disabled the projects on Pootle as I am now migrating the strings to
the new server using Weblate.

More info on the dedicated wiki page
https://wiki.koha-community.org/wiki/Translation_server_migration_weblate

Cheers,
Jonathan
___

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

Re: [Koha] support newer Linux version

[Jonathan Druart]

Hello and welcome,

Where are you looking at exactly?
The official wiki page is showing correct information:
https://wiki.koha-community.org/wiki/System_requirements_and_recommendations#Koha_23.05

Regards,
Jonathan

Le ven. 3 nov. 2023 à 11:50, ReindeR Rustema
 a écrit :
>
> Hello,
>
> New to the list and not yet a user of Koha. The IT-person who will install it 
> says that it runs on old Linux-versions he does not have anymore.
>
> Indeed, when I check the specs and compare that with Wikipedia I see that 
> both the mentioned Debian and Ubuntu-versions are not new.
>
> It is an implicit compliment to the stability of those and I can understand 
> that you don't want to force an OS upgrade to the current user base.
>
> But for new users it is an extra hurdle.
>
> Can I expect to see this hurdle disappear soon or should I look for 
> alternatives for Koha?
>
>
>
>
> —
>
> met vriendelijke groet,
>
> ReindeR Rustema
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

[Koha] koha-manual switched to "main"

[Jonathan Druart]

Hello,

Most of you can ignore this email, but if you have the koha-manual git
repository cloned somewhere locally, you will need to switch to the "main"
branch (instead of "master").

You can simply run the following command (when at the root of koha-manual)
  % git config init.defaultBranch main

Regards,
Jonathan
___

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

Re: [Koha] [Koha-translate] Translators - Do not wrap strings in PO files

[Jonathan Druart]

It's also all on one line when you use Weblate UI.
The question is only for translators translating locally (pull, translate,
push).

For now I will assume we are going to switch to the "one line/no wrap"
option (unless there are strong opinions against it).

I have just noticed that 23.05's PO files are already using this method, I
was not aware of that.

Le mer. 11 oct. 2023 à 13:11, Fischer, Katrin  a
écrit :

> Hi Jonathan,
>
>
>
> I think it doesn’t present like that in Pootle. All the strings on
> multiple lines are amended:
>
>
>
>
> https://translate.koha-community.org/de/23.05/translate/#search=Summer=source,target
>
>
>
> It’s only visible if you edit the po files directly. I haven’t checked how
> Weblate handles them.
>
>
>
> Hope this helps,
>
>
>
> Katrin
>
>
>
> *Von:* Koha-translate  *Im
> Auftrag von *Jonathan Druart
> *Gesendet:* Mittwoch, 11. Oktober 2023 10:58
> *An:* koha-transl...@lists.koha-community.org; koha <
> koha@lists.katipo.co.nz>
> *Betreff:* Re: [Koha-translate] Translators - Do not wrap strings in PO
> files
>
>
>
> Well, of course it has been wrapped!
>
> It should read like: http://paste.debian.net/1294738/
>
>
>
> Le mer. 11 oct. 2023 à 10:50, Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> a écrit :
>
> Hello,
>
>
>
> I have a question for translators: do you like how strings are wrapped in
> PO files?
>
>
>
> In the context of moving our translations server to weblate we will have
> to reorder the PO files, and maybe we could take that opportunity for other
> changes.
>
>
>
> One of them could be to not wrap lines, and have a single long line
> instead.
>
>
>
> For instance:
>
> Now:
>
> msgid ""
> "%s %sSpring%s %s %sSummer%s %s %sFall%s %s %sWinter%s %s %sSpr%s %s
> %sSum%s "
> "%s %sFal%s %s %sWin%s %s %s %s "
> msgstr ""
> "%s %sPrintemps%s %s %sÉté%s %s %sAutomne%s %s %sHiver%s %s %sPrtps%s %s "
> "%sÉté%s %s %sAut%s %s %sHiv%s %s %s %s"
>
>
>
> After:
>
> msgid "%s %sSpring%s %s %sSummer%s %s %sFall%s %s %sWinter%s %s %sSpr%s %s
> %sSum%s %s %sFal%s %s %sWin%s %s %s %s "
> msgstr "%s %sPrintemps%s %s %sÉté%s %s %sAutomne%s %s %sHiver%s %s
> %sPrtps%s %s %sÉté%s %s %sAut%s %s %sHiv%s %s %s %s"
>
>
>
> For those who translate directly in the PO files, which version do you
> like more?
>
>
>
> Regards,
>
> Jonathan
>
>
>
> Context:
>
> https://wiki.koha-community.org/wiki/Translation_server_migration_weblate
>
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35024
>
>
___

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

Re: [Koha] Translators - Do not wrap strings in PO files

[Jonathan Druart]

Well, of course it has been wrapped!
It should read like: http://paste.debian.net/1294738/

Le mer. 11 oct. 2023 à 10:50, Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> a écrit :

> Hello,
>
> I have a question for translators: do you like how strings are wrapped in
> PO files?
>
> In the context of moving our translations server to weblate we will have
> to reorder the PO files, and maybe we could take that opportunity for other
> changes.
>
> One of them could be to not wrap lines, and have a single long line
> instead.
>
> For instance:
> Now:
> msgid ""
> "%s %sSpring%s %s %sSummer%s %s %sFall%s %s %sWinter%s %s %sSpr%s %s
> %sSum%s "
> "%s %sFal%s %s %sWin%s %s %s %s "
> msgstr ""
> "%s %sPrintemps%s %s %sÉté%s %s %sAutomne%s %s %sHiver%s %s %sPrtps%s %s "
> "%sÉté%s %s %sAut%s %s %sHiv%s %s %s %s"
>
> After:
> msgid "%s %sSpring%s %s %sSummer%s %s %sFall%s %s %sWinter%s %s %sSpr%s %s
> %sSum%s %s %sFal%s %s %sWin%s %s %s %s "
> msgstr "%s %sPrintemps%s %s %sÉté%s %s %sAutomne%s %s %sHiver%s %s
> %sPrtps%s %s %sÉté%s %s %sAut%s %s %sHiv%s %s %s %s"
>
> For those who translate directly in the PO files, which version do you
> like more?
>
> Regards,
> Jonathan
>
> Context:
> https://wiki.koha-community.org/wiki/Translation_server_migration_weblate
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35024
>
___

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

[Koha] Translators - Do not wrap strings in PO files

[Jonathan Druart]

Hello,

I have a question for translators: do you like how strings are wrapped in
PO files?

In the context of moving our translations server to weblate we will have to
reorder the PO files, and maybe we could take that opportunity for other
changes.

One of them could be to not wrap lines, and have a single long line instead.

For instance:
Now:
msgid ""
"%s %sSpring%s %s %sSummer%s %s %sFall%s %s %sWinter%s %s %sSpr%s %s
%sSum%s "
"%s %sFal%s %s %sWin%s %s %s %s "
msgstr ""
"%s %sPrintemps%s %s %sÉté%s %s %sAutomne%s %s %sHiver%s %s %sPrtps%s %s "
"%sÉté%s %s %sAut%s %s %sHiv%s %s %s %s"

After:
msgid "%s %sSpring%s %s %sSummer%s %s %sFall%s %s %sWinter%s %s %sSpr%s %s
%sSum%s %s %sFal%s %s %sWin%s %s %s %s "
msgstr "%s %sPrintemps%s %s %sÉté%s %s %sAutomne%s %s %sHiver%s %s
%sPrtps%s %s %sÉté%s %s %sAut%s %s %sHiv%s %s %s %s"

For those who translate directly in the PO files, which version do you like
more?

Regards,
Jonathan

Context:
https://wiki.koha-community.org/wiki/Translation_server_migration_weblate
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35024
___

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

Re: [Koha] Working with nginx and installing on URL prefixes

[Jonathan Druart]

I think that is bug 15045 (no patch!)
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15045

Le ven. 6 oct. 2023 à 16:39, Daniel Bünzli  a
écrit :

> Thanks for your answer Thomas.
>
> > This will take the output generated upstream (i.e. plack) and do actual
> > regex replaces on the HTML. So ... ugh…
>
> Ugh indeed :-)
>
> Do you think there would be consideration from the devs for this problem,
> that is the ability to serve koha on URL prefixes ?
>
> The current scheme makes it a bit inconvenient to integrate koha on
> existing infrastructures and I rather not get too much into the ugh
> workarounds, it’s annoying for everyone when we run into bugs.
>
> Should I perhaps open an issue about this ?
>
> > > b) Is there any strong problem I’m not seeing in trying to setup koha
> > > the way I outlined above and use nginx rather than apache to serve the
> > > app ?
> >
> > There might be some long-running scripts left that can only be run as
> > CGI (because they fork).
>
> If that’s the only problem one could still run these through fcgiwrap [1].
> We are actually already running it for other purposes.
>
> Best,
>
> Daniel
>
> [1]: https://www.nginx.com/resources/wiki/start/topics/examples/fcgiwrap/
>
>
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] search_for_data_inconsistencies.pl: Bibliographic records have invalid MARCXML

[Jonathan Druart]

Safe in what sense?

Koha won't work correctly with those records if there is no entry in
biblio_metadata for them, but maybe you should try and recover them, or at
least understand how it happened.

Le mar. 3 oct. 2023 à 17:13, Michael Kuhn  a écrit :

> Hi Jonathan
>
> In file "search_for_data_inconsistencies.pl" I found the line
>
> push @decoding_errors, $@ if $@;
>
> which I changed to
>
> push @decoding_errors, sprintf("ID=%s - %s", $biblio->biblionumber, $@);
>
> After running "search_for_data_inconsistencies.pl" again, I found three
> ID numbers saying:
>
> DBIC result _type  isn't of the _type BiblioMetadata at
> /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl line
> 124.
>
> I searched for these numbers in the staff client and I found them - but
> when trying to show the detail view Koha said:
>
> The record you requested does not exist (10).
>
> Also I found the content of these records in table "biblio" but not in
> table "biblio_metadata".
>
> Do you think it's safe to just delete these records in table "biblio"
> and then to reindex the database?
>
> 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 02.10.23 um 11:08 schrieb Jonathan Druart:
> > Hi,
> > This is a bug, there is a lack of information. Please report on bugzilla
> > and if possible provide a patch.
> >
> > You should be able to get more info (biblionumber) with the following
> > change:
> >
> > diff --git a/misc/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl>
> > b/misc/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl>
> > index ddc6b457dd1..92de2bd91b8 100755
> > --- a/misc/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl>
> > +++ b/misc/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl>
> > @@ -126,7 +126,7 @@ use C4::Biblio qw( GetMarcFromKohaField );
> >   while ( my $biblio = $biblios->next ) {
> >   my $record = eval{$biblio->metadata->record;};
> >   if ($@) {
> > -push @decoding_errors, $@;
> > +push @decoding_errors, sprintf("ID=%s - %s",
> > $biblio->biblionumber, $@);
> >   next;
> >   }
> >   my ( $biblionumber, $biblioitemnumber );
> >
> > Regards,
> > Jonathan
> >
> >
> > Le dim. 1 oct. 2023 à 18:13, Michael Kuhn  > <mailto:m...@adminkuhn.ch>> a écrit :
> >
> > Hi
> >
> > We are using Koha 21.11.09 with MariaDB 10.3.38, running on Debian
> > GNU/Linux 10.
> >
> > When running script "search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl>" we are getting
> > the following output:
> >
> >
> > == Bibliographic records have invalid MARCXML ==
> > * DBIC result _type  isn't of the _type BiblioMetadata at
> > /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl> line 124.
> > * DBIC result _type  isn't of the _type BiblioMetadata at
> > /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl> line 124.
> > * DBIC result _type  isn't of the _type BiblioMetadata at
> > /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl
> > <http://search_for_data_inconsistencies.pl> line 124.
> >
> > => The bibliographic records must have a valid MARCXML or you will
> face
> > encoding issues or wrong displays
> >
> >
> > Does anyone know how to obtain further information (biblionumbers?)
> for
> > these cases?
> >
> > 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
> > <mailto:m...@adminkuhn.ch> · W www.adminkuhn.ch <
> http://www.adminkuhn.ch>
> > ___
> >
> > Koha mailing list http://koha-community.org <
> http://koha-community.org>
> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > <https://lists.katipo.co.nz/mailman/listinfo/koha>
> >
>
>
>
___

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

Re: [Koha] search_for_data_inconsistencies.pl: Bibliographic records have invalid MARCXML

[Jonathan Druart]

Hi,
This is a bug, there is a lack of information. Please report on bugzilla
and if possible provide a patch.

You should be able to get more info (biblionumber) with the following
change:

diff --git a/misc/maintenance/search_for_data_inconsistencies.pl
b/misc/maintenance/search_for_data_inconsistencies.pl
index ddc6b457dd1..92de2bd91b8 100755
--- a/misc/maintenance/search_for_data_inconsistencies.pl
+++ b/misc/maintenance/search_for_data_inconsistencies.pl
@@ -126,7 +126,7 @@ use C4::Biblio qw( GetMarcFromKohaField );
 while ( my $biblio = $biblios->next ) {
 my $record = eval{$biblio->metadata->record;};
 if ($@) {
-push @decoding_errors, $@;
+push @decoding_errors, sprintf("ID=%s - %s",
$biblio->biblionumber, $@);
 next;
 }
 my ( $biblionumber, $biblioitemnumber );

Regards,
Jonathan


Le dim. 1 oct. 2023 à 18:13, Michael Kuhn  a écrit :

> Hi
>
> We are using Koha 21.11.09 with MariaDB 10.3.38, running on Debian
> GNU/Linux 10.
>
> When running script "search_for_data_inconsistencies.pl" we are getting
> the following output:
>
>
> == Bibliographic records have invalid MARCXML ==
> * DBIC result _type  isn't of the _type BiblioMetadata at
> /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl line
> 124.
> * DBIC result _type  isn't of the _type BiblioMetadata at
> /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl line
> 124.
> * DBIC result _type  isn't of the _type BiblioMetadata at
> /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl line
> 124.
>
> => The bibliographic records must have a valid MARCXML or you will face
> encoding issues or wrong displays
>
>
> Does anyone know how to obtain further information (biblionumbers?) for
> these cases?
>
> 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
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] search_for_data_inconsistencies.pl: Can't call method "get_column"

[Jonathan Druart]

Hi,

Line 157 on this version is about authorised values. My guess is that
you have a value in marc_subfield_structure.authorised_value that does
not have an entry in the authorised_values table (column category).

It can be considered as a bug for this script, and it seems (looking
at the code) that the bug still exists in master (so please report it
on bugzilla).

20.11.02? Did you typo the version? You should at least upgrade to the
latest 20.11.x!

Regards,
Jonathan

Le dim. 1 oct. 2023 à 20:02, Michael Kuhn  a écrit :
>
> Hi
>
> We are using Koha 20.11.02 with MariaDB 10.3.39, running on Debian
> GNU/Linux 10.
>
> When calling the script "search_for_data_inconsistencies.pl" the only
> output is the following:
>
> $ sudo koha-shell -c "perl
> /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl"
> instancename
> Can't call method "get_column" on an undefined value at
> /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl line 157.
>
> Does anyone know how to solve this problem?
>
> 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
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] [translate] Migrate Pootle to Weblate

[Jonathan Druart]

Hello everybody,

A quick update, I am back on this and I logged the progress on the wiki:
https://wiki.koha-community.org/wiki/Translation_server_migration_weblate
If you have worked with Weblate already and know it well, please let me
know, I have a couple of questions :)

Cheers,
Jonathan

Le jeu. 13 juil. 2023 à 17:12, Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> a écrit :

> Hello everybody,
>
> If you are a translator of Koha you should read this.
>
> Pootle is dead and we should move to Weblate, which is an active and
> well maintained project.
> We have been setting up a test server to let translators see how it goes.
> THIS IS A TEST SERVER: none of the changes will be saved!
>
> There are some changes in how the projects are structured.
> We will now have 2 projects: "koha" and "koha-manual". Each will
> contain several "components".
> One component in Pootle can only track on po file, which means we need
> one component per po file:
> https://translate.test.koha-community.org/projects/koha/ shows
> https://snipboard.io/rtKdTS.jpg
>
> It can be a bit disturbing at first, but there is this view:
> https://translate.test.koha-community.org/languages/es/koha/ that
> shows the progress per language: https://snipboard.io/UCJ1Ky.jpg
>
> The big win are:
> * We should no longer get "Critical errors: Python brace placeholders"
> (to be confirmed)
> * Translation changes will be propagated between the components of a
> given project, and so between versions: if you modify a string for
> 23.05 it will also modify it for the other branches! (to be confirmed
> as well!)
>
> guest user (not logged in) can only make suggestions:
> https://translate.test.koha-community.org/
>
> User reviewer/6Mx1$HU*1KNbzCZV can accept suggestions.
>
> You are welcome to test and provide feedback!
>
> There is still a lot of work before effectively doing the migration,
> but we need first to know if users/translators are happy with it!
>
> Let us know!
> Cheers,
> Jonathan
>
> PS: About the structure of the projects, I've contacted the author of
> Weblate: https://github.com/WeblateOrg/weblate/discussions/9556
> Next version will add a mecanism to structure components within a project!
>
___

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

Re: [Koha] Large number of action_logs records

[Jonathan Druart]

Hi Joel,

We could skip the logging when the biblio is modified by this cronjob,
please report this problem in a new bug report.

Regards,
Jonathan

Le mar. 29 août 2023 à 21:22, Coehoorn, Joel  a écrit :
>
> We're seeing a large quantity of records filling the action_logs table...
> nearly 18,000 in the last 24 hours. This in turn uses a LOT of disk
> space... it was briefly over 90GB until I intervened, and because MySQL is
> dumb about shrinking tables we were fortunate I caught it in time.
>
> It looks like the update_totalissues.pl script is running every night and
> putting the entire biblio record into the info column in the table for
> every record we have.
>
> What could be causing this, and how can I stop it (without disabling the
> job completely, which I assume is part of Koha and important)?
>
> *Joel Coehoorn*
> Director of Information Technology
> *York University*
> Office: 402-363-5603 | jcoeho...@york.edu | york.edu
>
> *Please contact helpd...@york.edu  for technical
> assistance.*
>
>
> The mission of York University is to transform lives through
> Christ-centered education and to equip students for lifelong service to
> God, family, and society
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] MARC bibliographic framework test

[Jonathan Druart]

You should open a bug report. This mailing list should not be used as
a bug tracker/enhancement request.

Le mer. 23 août 2023 à 12:11, Сычев Игорь Алексеевич  a écrit :
>
> Hello!
>
> New install Koha 23.05.02
> Please correct in the Unimarc Default framework.
>
> subfields not in same tabs
> Not all subfields for the following tags are in the same tab (or marked 
> 'ignored').
> CodeDescription Tag Tabs in use
> Default framework   410 3,4
> Default framework   411 3,4
> Default framework   412 3,4
> Default framework   413 3,4
> Default framework   421 3,4
> Default framework   422 3,4
> Default framework   423 3,4
> Default framework   424 3,4
> Default framework   425 3,4
> Default framework   430 3,4
> Default framework   431 3,4
> Default framework   432 3,4
> Default framework   433 3,4
> Default framework   434 3,4
> Default framework   435 3,4
> Default framework   436 3,4
> Default framework   437 3,4
> Default framework   440 3,4
> Default framework   441 3,4
> Default framework   442 3,4
> Default framework   443 3,4
> Default framework   444 3,4
> Default framework   445 3,4
> Default framework   446 3,4
> Default framework   447 3,4
> Default framework   448 3,4
> Default framework   451 3,4
> Default framework   452 3,4
> Default framework   453 3,4
> Default framework   454 3,4
> Default framework   455 3,4
> Default framework   456 3,4
> Default framework   461 3,4
> Default framework   462 3,4
> Default framework   463 3,4
> Default framework   464 3,4
> Default framework   470 3,4
> Default framework   481 3,4
> Default framework   482 3,4
> Default framework   488 3,4
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Slow Item Edit Routines

[Jonathan Druart]

Hi Rudy,

Do you have a lot of item types?

Do you have a lot of items for this bibliographic record?

Regards,
Jonathan

Le mar. 22 août 2023 à 15:39, Rudy Hinojosa
 a écrit :
>
> Using v23.05.02 release has been a great experience thus far, but I am
> noticing that the system is doing something CPU or process intrinsic
> when it comes to editing an item. I'm unable to edit any single field or
> trigger a drop down until at least 15 seconds have passed. I'm leaning
> that there is some process probably pre-loading  and populating the KOHA
> ITEM TYPE drop downs. The system becomes hog tied until this process is
> completed. After that, it's smooth sailing and fast saving as well.
> I've disabled catalog logging changes for now to see if that helps, but
> outside of that, does anyone have any suggestions. The server is beefy.
> The user loads are light. All systems are nominal including memcached,
> and no warning in the about us screens.
>
> Rudy Hinojosa
>
>
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Failing to edit MARC Frameworks in Koha 22.05.05.000

[Jonathan Druart]

What about this one?
SELECT frameworkcode, tagfield, tab, authorised_value FROM
marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR
kohafield = "items.holdingbranch" ) AND ( authorised_value !=
"branches" OR tab != 10 );

Le mer. 2 août 2023 à 14:53, Antony Kujenga  a écrit :
>
> Hi Jonathan,
>
> No, it does not return anything.
>
> Regards
>
>
> AK
>
>
> On Wed, 2 Aug 2023 at 13:56, Jonathan Druart 
>  wrote:
>>
>> Does this SQL query return something?
>>
>> SELECT frameworkcode, tagfield, tab, authorised_value FROM
>> marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR
>> kohafield = "items.holdingbranch" ) AND authorised_value !=
>> "branches";
>>
>> Le mer. 2 août 2023 à 11:25, Antony Kujenga  a écrit :
>> >
>> > Dear Community,
>> >
>> > I've been trying to edit some frameworks in our Koha 22.05.05.000 instance
>> > running on Ubuntu 22.04. Upon running the framework test, I'm getting this
>> > error report:
>> >
>> > homebranch NOT mapped the items.homebranch field MUST :
>> >
>> >- be mapped to a MARC subfield,
>> >- the corresponding subfield MUST have "Authorized value" set to
>> >"branches"
>> >
>> > holdingbranch NOT mapped the items.holdingbranch field MUST :
>> >
>> >- be mapped to a MARC subfield,
>> >- the corresponding subfield MUST have "Authorized value" set to
>> >"branches"
>> >
>> >
>> > I have tried changing the stated fields numerous times but the system will
>> > not effect the changes.
>> >
>> > I tried running
>> >
>> > $ sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c'
>> > your_koha_name
>> >
>> > with our instance name but it hasn't helped.
>> >
>> > Any urgent help would be most appreciated.
>> >
>> > Regards
>> >
>> >
>> > AK
>> > ___
>> >
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Failing to edit MARC Frameworks in Koha 22.05.05.000

[Jonathan Druart]

Does this SQL query return something?

SELECT frameworkcode, tagfield, tab, authorised_value FROM
marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR
kohafield = "items.holdingbranch" ) AND authorised_value !=
"branches";

Le mer. 2 août 2023 à 11:25, Antony Kujenga  a écrit :
>
> Dear Community,
>
> I've been trying to edit some frameworks in our Koha 22.05.05.000 instance
> running on Ubuntu 22.04. Upon running the framework test, I'm getting this
> error report:
>
> homebranch NOT mapped the items.homebranch field MUST :
>
>- be mapped to a MARC subfield,
>- the corresponding subfield MUST have "Authorized value" set to
>"branches"
>
> holdingbranch NOT mapped the items.holdingbranch field MUST :
>
>- be mapped to a MARC subfield,
>- the corresponding subfield MUST have "Authorized value" set to
>"branches"
>
>
> I have tried changing the stated fields numerous times but the system will
> not effect the changes.
>
> I tried running
>
> $ sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c'
> your_koha_name
>
> with our instance name but it hasn't helped.
>
> Any urgent help would be most appreciated.
>
> Regards
>
>
> AK
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] [Koha-devel] Where would I put the OpenLibrary ID in the MARC record

[Jonathan Druart]

No idea, I'm really just a programmer ;)

Le ven. 21 juil. 2023 à 14:06, Nigel Titley  a écrit :
>
> Thanks for the response... makes sense to use the ISBN and it explains
> the observed behaviour.
>
> I've had a look at the code. One of these days I'll blow the dust off my
> JS manuals and see if I can do something to extend the code (JS isn't my
> favourite language and I've probably not written any for about 15 years).
>
> Is my supposition about where it would go in the MARC record correct?
>
> Thanks
>
> Nigel
>
> On 21/07/2023 12:29, Jonathan Druart wrote:
> > Looks like it's only using the ISBN. The code is in
> > koha-tmpl/opac-tmpl/bootstrap/js/openlibrary.js
> >
> > https://gitlab.com/koha-community/Koha/-/blob/master/koha-tmpl/opac-tmpl/bootstrap/js/openlibrary.js#L19
> >
> > and opac-results:
> > 899 [% IF OpenLibraryCovers
> > %]KOHA.OpenLibrary.GetCoverFromIsbn();[% END %]
> >
> >
> > Le ven. 21 juil. 2023 à 13:03, Nigel Titley  a écrit :
> >>
> >> Furthur on this and reading a bit more into MARC it looks like the
> >> information would go into MARC Field 024 with a source of 8. If there
> >> was a defined Standard Identifier for Openlibrary then the source would
> >> be 7 with the defined Standard Identifier for Openlibrary, but there isn't.
> >>
> >> I'm straying into Real Librarian Territory here and I'm starting to feel
> >> a little lost (I'm really just a programmer). If the person who wrote
> >> the code for fetching covers from Openlibrary is around I'd be grateful
> >> if they could confirm/deny what their code does (or even point me to
> >> where I could look it up myself). To this end I've copied in the Koha
> >> Development community.
> >>
> >> Or I may be barking up an entirely wrong tree. In which case feel free
> >> to say "Down boy, down".
> >>
> >> Nigel
> >>
> >> On 20/07/2023 23:20, Nigel Titley wrote:
> >>> Just to give an example of an OpenLibrary record that I created earlier
> >>> today
> >>>
> >>> https://openlibrary.org/books/OL49198571M/Analogue_Men#details
> >>>
> >>> If at all possible I'd like to be able to display the cover using the
> >>> OLID (OL49198571M) but I'm not sure where to put it.
> >>>
> >>> Thanks
> >>>
> >>> Nigel
> >>>
> >>> On 20/07/2023 22:43, Nigel Titley wrote:
> >>>> Gentlefolk
> >>>>
> >>>> I'm using the Openlibrary cover facility to display covers in my OPAC
> >>>> and it generally works very well (in the case where the cover doesn't
> >>>> exist in Openlibrary I scan and upload it). However, if the Biblio
> >>>> record doesn't have an ISBN or LCCN the cover lookup fails
> >>>> (obviously). Is there any way of recording the Openlibrary ID (OLID)
> >>>> in a Biblio record so that the cover lookup will work, even if there
> >>>> is no ISBN or LCCN?
> >>>>
> >>>> I've done a (fairly cursory) scan of the documentation but can't find
> >>>> and reference to where I should put the OLID so that Koha will look up
> >>>> the cover even if there is no ISBN or LCCN. Of course the facility may
> >>>> not exist, in which case I'd be grateful for confirmation from Someone
> >>>> Who Knows.
> >>>>
> >>>> Many thanks
> >>>>
> >>>> Nigel Titley
> >>>>
> >>>> ___
> >>>>
> >>>> Koha mailing list  http://koha-community.org
> >>>> Koha@lists.katipo.co.nz
> >>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>> ___
> >>>
> >>> Koha mailing list  http://koha-community.org
> >>> Koha@lists.katipo.co.nz
> >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >> ___
> >> Koha-devel mailing list
> >> koha-de...@lists.koha-community.org
> >> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> >> website : https://www.koha-community.org/
> >> git : https://git.koha-community.org/
> >> bugs : https://bugs.koha-community.org/
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] [Koha-devel] Where would I put the OpenLibrary ID in the MARC record

[Jonathan Druart]

Looks like it's only using the ISBN. The code is in
koha-tmpl/opac-tmpl/bootstrap/js/openlibrary.js

https://gitlab.com/koha-community/Koha/-/blob/master/koha-tmpl/opac-tmpl/bootstrap/js/openlibrary.js#L19

and opac-results:
899 [% IF OpenLibraryCovers
%]KOHA.OpenLibrary.GetCoverFromIsbn();[% END %]


Le ven. 21 juil. 2023 à 13:03, Nigel Titley  a écrit :
>
> Furthur on this and reading a bit more into MARC it looks like the
> information would go into MARC Field 024 with a source of 8. If there
> was a defined Standard Identifier for Openlibrary then the source would
> be 7 with the defined Standard Identifier for Openlibrary, but there isn't.
>
> I'm straying into Real Librarian Territory here and I'm starting to feel
> a little lost (I'm really just a programmer). If the person who wrote
> the code for fetching covers from Openlibrary is around I'd be grateful
> if they could confirm/deny what their code does (or even point me to
> where I could look it up myself). To this end I've copied in the Koha
> Development community.
>
> Or I may be barking up an entirely wrong tree. In which case feel free
> to say "Down boy, down".
>
> Nigel
>
> On 20/07/2023 23:20, Nigel Titley wrote:
> > Just to give an example of an OpenLibrary record that I created earlier
> > today
> >
> > https://openlibrary.org/books/OL49198571M/Analogue_Men#details
> >
> > If at all possible I'd like to be able to display the cover using the
> > OLID (OL49198571M) but I'm not sure where to put it.
> >
> > Thanks
> >
> > Nigel
> >
> > On 20/07/2023 22:43, Nigel Titley wrote:
> >> Gentlefolk
> >>
> >> I'm using the Openlibrary cover facility to display covers in my OPAC
> >> and it generally works very well (in the case where the cover doesn't
> >> exist in Openlibrary I scan and upload it). However, if the Biblio
> >> record doesn't have an ISBN or LCCN the cover lookup fails
> >> (obviously). Is there any way of recording the Openlibrary ID (OLID)
> >> in a Biblio record so that the cover lookup will work, even if there
> >> is no ISBN or LCCN?
> >>
> >> I've done a (fairly cursory) scan of the documentation but can't find
> >> and reference to where I should put the OLID so that Koha will look up
> >> the cover even if there is no ISBN or LCCN. Of course the facility may
> >> not exist, in which case I'd be grateful for confirmation from Someone
> >> Who Knows.
> >>
> >> Many thanks
> >>
> >> Nigel Titley
> >>
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
___

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

Re: [Koha] [translate] Migrate Pootle to Weblate

[Jonathan Druart]

We are currently waiting for translators feedback on the UI and
possible errors they could catch on the current test server.
Then I am going to wait for weblate 5, which will include the feature
I have listed in the PS (to group components). It will be out in
August.
We have holidays and KohaCon that are coming, so not in the next 2 months.
Hopefully for 23.11?

Le ven. 21 juil. 2023 à 07:49,  a écrit :
>
> Hi Jonathan,
> congratulations on wise decision for moving to Weblate, which is much smarter 
> and easier on use.
> So when we can start "real" translation with Weblate?
> Any estimated dates?
> thanks,
> Tigran
>
> July 13, 2023 7:12 PM, "Jonathan Druart" 
>  wrote:
>
> > Hello everybody,
> >
> > If you are a translator of Koha you should read this.
> >
> > Pootle is dead and we should move to Weblate, which is an active and
> > well maintained project.
> > We have been setting up a test server to let translators see how it goes.
> > THIS IS A TEST SERVER: none of the changes will be saved!
> >
> > There are some changes in how the projects are structured.
> > We will now have 2 projects: "koha" and "koha-manual". Each will
> > contain several "components".
> > One component in Pootle can only track on po file, which means we need
> > one component per po file:
> > https://translate.test.koha-community.org/projects/koha shows
> > https://snipboard.io/rtKdTS.jpg
> >
> > It can be a bit disturbing at first, but there is this view:
> > https://translate.test.koha-community.org/languages/es/koha that
> > shows the progress per language: https://snipboard.io/UCJ1Ky.jpg
> >
> > The big win are:
> > * We should no longer get "Critical errors: Python brace placeholders"
> > (to be confirmed)
> > * Translation changes will be propagated between the components of a
> > given project, and so between versions: if you modify a string for
> > 23.05 it will also modify it for the other branches! (to be confirmed
> > as well!)
> >
> > guest user (not logged in) can only make suggestions:
> > https://translate.test.koha-community.org
> >
> > User reviewer/6Mx1$HU*1KNbzCZV can accept suggestions.
> >
> > You are welcome to test and provide feedback!
> >
> > There is still a lot of work before effectively doing the migration,
> > but we need first to know if users/translators are happy with it!
> >
> > Let us know!
> > Cheers,
> > Jonathan
> >
> > PS: About the structure of the projects, I've contacted the author of
> > Weblate: https://github.com/WeblateOrg/weblate/discussions/9556
> > Next version will add a mecanism to structure components within a project!
> > ___
> >
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> --
> Dr. Tigran Zargaryan
> Scientific Adviser,
> Fundamental Scientific Library
> National Academy of Sciences
> Republic of Armenia
> Yerevan, 0019
> 24/6, Marshal Baghramian Ave.
___

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

[Koha] [translate] Migrate Pootle to Weblate

[Jonathan Druart]

Hello everybody,

If you are a translator of Koha you should read this.

Pootle is dead and we should move to Weblate, which is an active and
well maintained project.
We have been setting up a test server to let translators see how it goes.
THIS IS A TEST SERVER: none of the changes will be saved!

There are some changes in how the projects are structured.
We will now have 2 projects: "koha" and "koha-manual". Each will
contain several "components".
One component in Pootle can only track on po file, which means we need
one component per po file:
https://translate.test.koha-community.org/projects/koha/ shows
https://snipboard.io/rtKdTS.jpg

It can be a bit disturbing at first, but there is this view:
https://translate.test.koha-community.org/languages/es/koha/ that
shows the progress per language: https://snipboard.io/UCJ1Ky.jpg

The big win are:
* We should no longer get "Critical errors: Python brace placeholders"
(to be confirmed)
* Translation changes will be propagated between the components of a
given project, and so between versions: if you modify a string for
23.05 it will also modify it for the other branches! (to be confirmed
as well!)

guest user (not logged in) can only make suggestions:
https://translate.test.koha-community.org/

User reviewer/6Mx1$HU*1KNbzCZV can accept suggestions.

You are welcome to test and provide feedback!

There is still a lot of work before effectively doing the migration,
but we need first to know if users/translators are happy with it!

Let us know!
Cheers,
Jonathan

PS: About the structure of the projects, I've contacted the author of
Weblate: https://github.com/WeblateOrg/weblate/discussions/9556
Next version will add a mecanism to structure components within a project!
___

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

Re: [Koha] record won't delete

[Jonathan Druart]

Hi Lauren, did you have a look at the wiki page?
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

Le mer. 5 juil. 2023 à 20:50, Lauren Denny  a écrit :
>
> Hi Jonathan,
>
> Thanks for the SQL.  We ran the report and got 6 biblionumbers including the 
> one we tried to delete.  I'm not sure what is wrong or how to fix these.  
> Could you elaborate on what needs to be corrected.
>
> Thanks,
> Lauren
>
> On Tue, Jul 4, 2023 at 5:37 AM Jonathan Druart 
>  wrote:
>>
>> Apparently the about page is not displaying the warning if the problem
>> is on the [deleted]biblioitems table.
>> You can catch the incorrect entries with the following SQL query:
>>   select b.biblionumber from biblioitems b join deletedbiblioitems db
>> on b.biblionumber=db.biblionumber;
>>
>> Le sam. 1 juil. 2023 à 10:49, David Liddle  a écrit :
>> >
>> > Hi Katrin, and thank you for the input and suggestion. Our system shows no
>> > warnings, however. Not being on the cataloging side of things, I can’t
>> > provide much more detail about the context of the items to be deleted.
>> >
>> > Regards from the Siegerland,
>> >
>> > David
>> >
>> >
>> > On Fri, Jun 30, 2023 at 8:13 PM Katrin Fischer 
>> > wrote:
>> >
>> > > Hi David,
>> > >
>> > > please check the About Koha > System information tab for any errors.
>> > >
>> > > I suspect you might see a warning about duplicated IDs. If that is the
>> > > case, you can find some more information in the wiki:
>> > >
>> > > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
>> > >
>> > > Hope this helps,
>> > >
>> > > Katrin
>> > >
>> > >
>> > > On 28.06.23 15:39, David Liddle wrote:
>> > > > Greetings all! To add a little more detail to this issue, I'll include
>> > > > that the server logs contain several instances of the following error:
>> > > >
>> > > >
>> > > /var/log/koha/library/worker-output.log.1:C4::Biblio::_koha_delete_biblioitems():
>> > > > DBI Exception: DBD::mysql::st execute failed: Duplicate entry '11857'
>> > > > for key 'PRIMARY' at /usr/share/koha/lib/C4/Biblio.pm line 535
>> > > >
>> > > > Surely that biblio entry is the blocking element, but we're uncertain
>> > > > about how it should be handled so that the deletion proceeds
>> > > > smoothly—and without harming related entries. Thank you for giving it
>> > > > your attention!
>> > > >
>> > > > David Liddle
>> > > > System Administrator
>> > > > david.lid...@wycliff.de (just not for this list)
>> > > >
>> > > > Wycliff e.V., https://wycliff.de
>> > > > Seminar für Sprache und Kultur, https://spracheundkultur.org
>> > > > Internationales Tagungszentrum Karimu, https://karimu.de
>> > > >
>> > > >
>> > > >
>> > > > On Fri, Jun 23, 2023 at 11:26 PM Lauren Denny 
>> > > wrote:
>> > > >> Hi everyone,
>> > > >>
>> > > >> I have a record that will not delete. When I try to delete the record 
>> > > >> or
>> > > >> merge it with another record I get this message:
>> > > >> An error has occurred!*Error 500*This message may have been caused by
>> > > any
>> > > >> of the following reasons:
>> > > >>
>> > > >> - You made use of an external link to an item that is no longer
>> > > available
>> > > >> - You followed an outdated link e.g. from a search engine or a
>> > > bookmark
>> > > >> - You tried to access a page that needs authentication
>> > > >> - An internal link in the client is broken and the page does not
>> > > exist
>> > > >>
>> > > >> What's next?
>> > > >>
>> > > >> - Use top menu bar to navigate to another part of Koha.
>> > > >> - To report a broken link or any other issue, please contact the
>> > > Koha
>> > > >> administrator. Send email 
>> > > >>
>> > > >> Does anyone have an idea of what is happening?
>> > > >>
>> > > >> Lauren
>> > > >> ___
>> > > >>
>> > > >> Koha mailing list  http://koha-community.org
>> > > >> Koha@lists.katipo.co.nz
>> > > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> > > > ___
>> > > >
>> > > > Koha mailing list  http://koha-community.org
>> > > > Koha@lists.katipo.co.nz
>> > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> > > ___
>> > >
>> > > Koha mailing list  http://koha-community.org
>> > > Koha@lists.katipo.co.nz
>> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> > >
>> > ___
>> >
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] import patrons

[Jonathan Druart]

-c is used for 2 options, it's a bug and you should not use it
-c|--confirm
-c|--matchpoint
Use the long version, --confirm instead.
Please open a new bug report.
Regards,
Jonathan

Le jeu. 6 juil. 2023 à 06:07, Сычев Игорь Алексеевич  a écrit :
>
> Hello!
>
> Koha 23.05
> Importing patrons on the command line. What does the following warning mean?
>
> root@koha:/usr/share/koha/bin# perl import_patrons.pl -f /home/ias/patron.csv 
> --matchpoint cardnumber -c -v
> Use of uninitialized value $borrower{"cardnumber"} in string eq at 
> /usr/share/koha/lib/Koha/Patrons/Import.pm line 146, <$handle> line 500.
> Use of uninitialized value $borrower{"auth_method"} in string eq at 
> /usr/share/koha/lib/Koha/Patrons/Import.pm line 147, <$handle> line 500.
>
> Option "-c" --confirm or --matchpoint?
>
> root@koha:/usr/share/koha/bin# perl import_patrons.pl --help
> Usage:
> import_patrons.pl --file /path/to/patrons.csv --matchpoint cardnumber
> --confirm [--default branchcode=MPL] [--overwrite] [--preserve-field
> ] [--preserve-extended-attributes] [--update-expiration]
> [--expiration-from-today] [--verbose]
>
> Options:
> -h|--help
> Prints a brief help message and exits
>
> -c|--confirm
> Confirms you really want to import these patrons, otherwise
> prints this help
>
> -f|--file
> Path to the CSV file of patrons to import
>
> -c|--matchpoint
> Field on which to match incoming patrons to existing patrons
>
> -d|--default
> Set defaults to patron fields, repeatable e.g. --default
> branchcode=MPL --default categorycode=PT
>
> -k|--preserve-field
> Prevent specified patron fields for existing patrons from being
> overwritten
>
> -o|--overwrite
> Overwrite existing patrons with new data if a match is found
>
> -p|--preserve-extended-attributes
> Retain extended patron attributes for existing patrons being
> overwritten
>
> -en|--email-new
> Send the WELCOME notice email to new users
>
> -ue|--update-expiration
> If a matching patron is found, extend the expiration date of
> their account using the patron's enrollment date as the base
>
> -et|--expiration-from-today
> If a matching patron is found, extend the expiration date of
> their account using the patron's enrollment date as the base
>
> -v|--verbose
> Be verbose
>
> Multiple -v options increase the verbosity
>
> 2 repetitions or above will report lines in error
>
> 3 repetitions or above will report feedback
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Koha won't import items when importing MARC records

[Jonathan Druart]

Or... "StoryCollection"? $bPRBHS$bStoryCollection

Le mar. 4 juil. 2023 à 12:16, Jonathan Druart
 a écrit :

>
> Hi,
>
> The error message (from the DBMS) is cut, please provide the full message.
> My guess is that the branchcode ("PRBHS") does not exist in the DB.
>
> Regards,
> Jonathan
>
> Le ven. 30 juin 2023 à 19:20, Furst, Kevin  a écrit :
> >
> > Hello,
> >
> > TL;DR = When importing MARC records, items don't import and fail.
> >
> > I am transitioning from Follett Destiny to Koha. After doing a MARC export
> > from Follett, I noticed that when staging records for import, Koha would
> > parse the biblio records fine but wouldn't find any item records. After
> > searching past messages in this list, I found that Follett has item records
> > as 852 instead of 952. I used MARCedit to change those to 952 and also
> > added a and b records to match the libraries listed in Koha. After doing
> > that and trying again, item records were then found during staging.
> >
> > However when I import the staged records, it just fails and gives me
> > nothing in the detailed messages in the UI. If I remove the 952 records, it
> > works fine and imports all the other records thus I know something is wrong
> > with my 952 entries. I have checked that there are p barcodes and a and b
> > home and current libraries.
> >
> > In the Koha logs on the server, this is the only error message I get when I
> > try to run an import and it fails.  To me it seems like a FK is missing on
> > import but I don't know what. Looking at the schema example, I'm wondering
> > if I'm supposed to be importing things to 942 and 999 along with 952. I do
> > not know if, when importing MARC records, Koha creates its own enumerated
> > ids for biblio, item number, etc. if that stuff isn't in the import file...
> > or if it isn't there, will it fail?
> >
> > BIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
> > execute failed: Cannot add or update a child row: a foreign key constraint
> > fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_>
> >
> > Broken FK constraint at
> > /usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 91.
> >
> > Here are a couple of 952 records from the Follett export to Koha import
> > file to see if something simple is wrong. I'm hoping it's something simple
> > on these lines.
> >
> >
> > =952  \\$p34517100010472$aPRBHS$bPRBHS$bStory
> > Collection$v10.00USD$x14441$eaRegular@c20060929@fTransfer from PRB Elem.@j
> > @j@j@i@i@i$hSC Otf$x1127380
> >
> > =952  \\$p37200O$aPRBHS$bPRBHS$v20.00USD$x17292$eaRegular@c20050604
> > @j@j@j@i@i@i$hR 639 Can pb$x527111
> >
> >
> > (Beyond that, I haven't really tinkered with anything in the default MARC
> > framework settings in admin.
> > Here is my version :
> > *Koha version:22.11.05.000 Rosalie*
> >
> > I would really appreciate any help, I've been working on this for over a
> > week now.
> >
> > *Kevin Furst*
> > Technology Director
> > Pine River-Backus Schools
> > o | 218.587.8030
> > @ | kfu...@prbschools.org
> >
> > Technology Office/Help Desk:  218-587-8510
> >
> > *Confidentiality Notice: This E-mail message, including any attachments, is
> > for the sole use of the intended recipient(s) and may contain confidential
> > and privileged information. Any unauthorized review, use, disclosure or
> > distribution is prohibited. If you are not the intended recipient, please
> > contact the sender by reply E-mail and destroy all copies of the original
> > message.*
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Koha won't import items when importing MARC records

[Jonathan Druart]

Hi,

The error message (from the DBMS) is cut, please provide the full message.
My guess is that the branchcode ("PRBHS") does not exist in the DB.

Regards,
Jonathan

Le ven. 30 juin 2023 à 19:20, Furst, Kevin  a écrit :
>
> Hello,
>
> TL;DR = When importing MARC records, items don't import and fail.
>
> I am transitioning from Follett Destiny to Koha. After doing a MARC export
> from Follett, I noticed that when staging records for import, Koha would
> parse the biblio records fine but wouldn't find any item records. After
> searching past messages in this list, I found that Follett has item records
> as 852 instead of 952. I used MARCedit to change those to 952 and also
> added a and b records to match the libraries listed in Koha. After doing
> that and trying again, item records were then found during staging.
>
> However when I import the staged records, it just fails and gives me
> nothing in the detailed messages in the UI. If I remove the 952 records, it
> works fine and imports all the other records thus I know something is wrong
> with my 952 entries. I have checked that there are p barcodes and a and b
> home and current libraries.
>
> In the Koha logs on the server, this is the only error message I get when I
> try to run an import and it fails.  To me it seems like a FK is missing on
> import but I don't know what. Looking at the schema example, I'm wondering
> if I'm supposed to be importing things to 942 and 999 along with 952. I do
> not know if, when importing MARC records, Koha creates its own enumerated
> ids for biblio, item number, etc. if that stuff isn't in the import file...
> or if it isn't there, will it fail?
>
> BIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
> execute failed: Cannot add or update a child row: a foreign key constraint
> fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_>
>
> Broken FK constraint at
> /usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 91.
>
> Here are a couple of 952 records from the Follett export to Koha import
> file to see if something simple is wrong. I'm hoping it's something simple
> on these lines.
>
>
> =952  \\$p34517100010472$aPRBHS$bPRBHS$bStory
> Collection$v10.00USD$x14441$eaRegular@c20060929@fTransfer from PRB Elem.@j
> @j@j@i@i@i$hSC Otf$x1127380
>
> =952  \\$p37200O$aPRBHS$bPRBHS$v20.00USD$x17292$eaRegular@c20050604
> @j@j@j@i@i@i$hR 639 Can pb$x527111
>
>
> (Beyond that, I haven't really tinkered with anything in the default MARC
> framework settings in admin.
> Here is my version :
> *Koha version:22.11.05.000 Rosalie*
>
> I would really appreciate any help, I've been working on this for over a
> week now.
>
> *Kevin Furst*
> Technology Director
> Pine River-Backus Schools
> o | 218.587.8030
> @ | kfu...@prbschools.org
>
> Technology Office/Help Desk:  218-587-8510
>
> *Confidentiality Notice: This E-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply E-mail and destroy all copies of the original
> message.*
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] record won't delete

[Jonathan Druart]

Apparently the about page is not displaying the warning if the problem
is on the [deleted]biblioitems table.
You can catch the incorrect entries with the following SQL query:
  select b.biblionumber from biblioitems b join deletedbiblioitems db
on b.biblionumber=db.biblionumber;

Le sam. 1 juil. 2023 à 10:49, David Liddle  a écrit :
>
> Hi Katrin, and thank you for the input and suggestion. Our system shows no
> warnings, however. Not being on the cataloging side of things, I can’t
> provide much more detail about the context of the items to be deleted.
>
> Regards from the Siegerland,
>
> David
>
>
> On Fri, Jun 30, 2023 at 8:13 PM Katrin Fischer 
> wrote:
>
> > Hi David,
> >
> > please check the About Koha > System information tab for any errors.
> >
> > I suspect you might see a warning about duplicated IDs. If that is the
> > case, you can find some more information in the wiki:
> >
> > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
> >
> > Hope this helps,
> >
> > Katrin
> >
> >
> > On 28.06.23 15:39, David Liddle wrote:
> > > Greetings all! To add a little more detail to this issue, I'll include
> > > that the server logs contain several instances of the following error:
> > >
> > >
> > /var/log/koha/library/worker-output.log.1:C4::Biblio::_koha_delete_biblioitems():
> > > DBI Exception: DBD::mysql::st execute failed: Duplicate entry '11857'
> > > for key 'PRIMARY' at /usr/share/koha/lib/C4/Biblio.pm line 535
> > >
> > > Surely that biblio entry is the blocking element, but we're uncertain
> > > about how it should be handled so that the deletion proceeds
> > > smoothly—and without harming related entries. Thank you for giving it
> > > your attention!
> > >
> > > David Liddle
> > > System Administrator
> > > david.lid...@wycliff.de (just not for this list)
> > >
> > > Wycliff e.V., https://wycliff.de
> > > Seminar für Sprache und Kultur, https://spracheundkultur.org
> > > Internationales Tagungszentrum Karimu, https://karimu.de
> > >
> > >
> > >
> > > On Fri, Jun 23, 2023 at 11:26 PM Lauren Denny 
> > wrote:
> > >> Hi everyone,
> > >>
> > >> I have a record that will not delete. When I try to delete the record or
> > >> merge it with another record I get this message:
> > >> An error has occurred!*Error 500*This message may have been caused by
> > any
> > >> of the following reasons:
> > >>
> > >> - You made use of an external link to an item that is no longer
> > available
> > >> - You followed an outdated link e.g. from a search engine or a
> > bookmark
> > >> - You tried to access a page that needs authentication
> > >> - An internal link in the client is broken and the page does not
> > exist
> > >>
> > >> What's next?
> > >>
> > >> - Use top menu bar to navigate to another part of Koha.
> > >> - To report a broken link or any other issue, please contact the
> > Koha
> > >> administrator. Send email 
> > >>
> > >> Does anyone have an idea of what is happening?
> > >>
> > >> Lauren
> > >> ___
> > >>
> > >> Koha mailing list  http://koha-community.org
> > >> Koha@lists.katipo.co.nz
> > >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > > ___
> > >
> > > Koha mailing list  http://koha-community.org
> > > Koha@lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Where are the release notes for Koha 22.05.13

[Jonathan Druart]

Looks like they have not been published on the website. You can still
find them in the source however:
https://gitlab.com/koha-community/Koha/-/blob/22.05.x/misc/release_notes/release_notes_22_05_13.md

Le sam. 1 juil. 2023 à 09:38, Michael Kuhn  a écrit :
>
> Hi
>
> Under https://download.koha-community.org/old_releases/ I see there was
> a version Koha 22.05.13 released on 25 May 2023.
>
> Unfortunately there was no release mail in mailing lists koha-devel or
> koha, also there is nothing under
> https://koha-community.org/koha-22-05-13-released/
>
> Can anyone please tell me where I can find the release notes for Koha
> 22.05.13?
>
> 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
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] updating database Structure Error

[Jonathan Druart]

I hope you replaced "__ENCRYPTION_KEY__" with a proper key.

Le mer. 21 juin 2023 à 09:43, Mr. Sitali C. S.  a écrit :
>
> Thanks a lot. It has worked like a charm. After adding the lines all I
> needed to do was to restart.
> Thank a lot for pointing me in the right direction. Much appreciated
>
> On Wed, 21 Jun 2023 at 07:38, MASTeR Library 
> wrote:
>
> > Hi!
> >
> > I added the lines:
> >  
> >  __ENCRYPTION_KEY__
> >
> > The update went through without a problem.
> >
> > https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml
> >
> > Good Luck!
> >
> > On Wed, 21 Jun 2023, 1:04 am Mr. Sitali C. S., 
> > wrote:
> >
> >> Greetings,
> >>
> >> I need help with the following error;
> >>
> >>- Upgrade to 22.12.00.041 [21:28:28]: Bug 30649 - Increase the vendor
> >>EDI account password field to 256 characters
> >>ERROR: Exception 'Koha::Exceptions::MissingParameter' thrown 'No
> >>encryption_key in koha-conf.xml'
> >>
> >> I installed Koha using the following;
> >>
> >> https://wiki.koha-community.org/wiki/Koha_on_Debian
> >> using ubuntu 22.04
> >>
> >> Thank you
> >> --
> >> Sitali Chrispin Simasiku,
> >> P. O. Box 660193,
> >> Monze,
> >> ZAMBIA.
> >>
> >> Mobile: +26 0979 869471
> >> +26 0966 869471
> >> SKYPE: Libsitali
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
>
> --
> Sitali Chrispin Simasiku,
> P. O. Box 660193,
> Monze,
> ZAMBIA.
>
> Mobile: +26 0979 869471
> +26 0966 869471
> SKYPE: Libsitali
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Install Koha 23.05

[Jonathan Druart]

Hi

Le mer. 7 juin 2023 à 09:29, Сычев Игорь Алексеевич  a écrit :

> Hello!
>
> Clean installation of Koha 23.05
>
> sample_libraries_holidays.yml
> DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
> constraint fails (`koha_lib`.`repeatable_holidays`, CONSTRAINT
> `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES
> `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE) at
> /usr/share/koha/lib/C4/Installer.pm line 579.
>

See bug 33581


> account_credit_types.sql
> Something went wrong loading file
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/mandatory/account_credit_types.sql
> (Couldn't read
> '/usr/share/koha/intranet/cgi-bin/installer/data/mysql/mandatory/account_credit_types.sql'
> : No such file or directory at /usr/share/perl5/DBIx/RunSQL.pm line 180. )
> at /usr/share/koha/lib/C4/Installer.pm line 587.
>
> account_debit_types.sql
> Something went wrong loading file
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/mandatory/account_debit_types.sql
> (Couldn't read
> '/usr/share/koha/intranet/cgi-bin/installer/data/mysql/mandatory/account_debit_types.sql'
> : No such file or directory at /usr/share/perl5/DBIx/RunSQL.pm line 180. )
> at /usr/share/koha/lib/C4/Installer.pm line 587.
>

Related to bug 26403. See bug 33935.


> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

[Jonathan Druart]

Hey, put a proper key there! Not "__ENCRYPTION_KEY__"!
It can be generated using the following command `pwgen 32`

Le mer. 7 juin 2023 à 07:41, Сычев Игорь Алексеевич  a écrit :

> Hi!
>
> I added the lines:
>  
>  __ENCRYPTION_KEY__
>
> The update went through without a problem.
>
> https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] re customizing the self-registration form page

[Jonathan Druart]

Hi Thomas,

This CSS rule should work:
#opac-patron-registration #OpacCustomSearch {
  display: none;
}
It will hide #OpacCustomSearch when it's inside #opac-patron-registration,
which is the id of the body on the self registration page.

Regards,
Jonathan

Le mar. 6 juin 2023 à 17:58, Thomas Vealehse  a
écrit :

> Hi
> Does anyone know if we can have a custom header just for one page ( the
> self registration page) on koha ?
> Or how to hide the opacheader and OpacCustomSearch on that page ( via css?)
>
> Thanks
> Thomas Veale
> Librarian
> HSE libraries
> Ireland
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] upgrade error running koha-upgrade-schema

[Jonathan Druart]

Hi Paulo,
You have values in illrequests.illrequests_safk that are not defined in the
authorised_values values.
Regards,
Jonathan

Le mar. 6 juin 2023 à 11:20, Paulo Neto  a écrit :

> Hello all,
>
> I've been trying to upgrade my koha 18.11 to version 22.11.
>
> When i run the comand koha-upgrade-schema to upgrade the database schema i
> am getting this error:
>
> " UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Can't create table
> `koha_dgadr`.`illrequests` (errno: 150 "Foreign key constraint is
> incorrectly formed")  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118 "
>
> This is happening on 18.12.00.016 step list in da script updatedatabase.pl
> (line17406) Corresponding to this line of code, in my case the
> illrequests_safk doesnt existe before running the script:
>
> if ( !foreign_key_exists( 'illrequests', 'illrequests_safk' ) ) {
> $dbh->do( "ALTER TABLE illrequests ADD CONSTRAINT illrequests_safk
> FOREIGN KEY (status_alias) REFERENCES authorised_values(authorised_value)
> ON UPDATE CASCADE ON DELETE SET NULL" );
> }
>
> I do have some equal values for the column authorised_value on the table
> authorised_value and i think its probably the reason it cant create the
> foreign key on the table illrequests,
>
> Is there a way to correct this?
>
> Yours sincerely,
>
> Paulo Neto
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] koha-upgrade-schema

[Jonathan Druart]

Hi,
I've reported the problem on bug 30649.
You should edit the $KOHA_CONF file and add a new encryption_key entry with
a key (that can be generated with `pwgen 32`).

Le lun. 5 juin 2023 à 05:47, Сычев Игорь Алексеевич  a écrit :

> Hello!
>
> Koha 23.05
> After the update.
> How to fix the error?
>
> root@koha2:~# koha-upgrade-schema lib
> Upgrading database schema for lib
> Upgrade to 22.12.00.041  [09:37:28]: Bug 30649 - Increase the vendor EDI
> account password field to 256 characters
> ERROR - Exception 'Koha::Exceptions::MissingParameter' thrown 'No
> encryption_key in koha-conf.xml'
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] auto_increment problem with holds in Koha 21.11

[Jonathan Druart]

Do you have the init-file trick setup correctly?

https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solution

Le jeu. 27 avr. 2023 à 10:06, Michael Kuhn  a écrit :
>
> Hi
>
> We are working on Debian GNU/Linux 10 with MariaDB 10.3.38 and Koha
> 21.11.09.
>
> Since about September 2022 after the update from Koha 18.11 to 21.11 we
> see auto_increment problems with tables "reserves" and "old_reserves"
> (but NOT with any of the other tables):
>
>   The following ids exist in both tables reserves and old_reserves:
>
>   372
>
> In fact every single hold evokes the problem. Deleting the id manually
> from table "old_reserves" does always solve the problem:
>
>   DELETE FROM old_reserves WHERE reserve_id IN (372);
>
> According to
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix the
> auto_increment problem should not occur at all after Koha 17.05.
>
> What could be the reason for this behavior?
>
> 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
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] KOHA upgrade from V20.05 to V22.11 (Browse by last name error)

[Jonathan Druart]

This has been raised on IRC yesterday, please have a look at the log:
https://irc.koha-community.org/koha/2023-04-26#i_2483964
The problem is some borrowers.date_renewed that would be -00-00

Le mer. 26 avr. 2023 à 06:09, zen zenitram  a écrit :
>
> Hello
>
> I finished upgrading koha version 20.05 to version 22.11, but when i tried
> to search for patron  by clicking the letter of the last name this message
> shows ( Something went wrong when loading table . 500 Internal server
> error. then lots of " Month out of range message".
>
> How do i fix this kind of error?
>
> I tried to overwrite the patron by uploading new list of patrons but
> nothing change.
>
> Thank you!
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Help needed with zombie background_jobs processes

[Jonathan Druart]

It would be interesting to revert the changes from 32558 that have
been backported into 22.11.04 and see if it helps.

Le mer. 19 avr. 2023 à 18:01, Cindy Murdock Ames  a écrit :
>
> Hi Jonathan,
>
> I just tried sending SHGCHLD to the parent processes, it didn't have any 
> effect.  The parents are "/usr/bin/perl 
> /usr/share/koha/bin/background_jobs_worker.pl --queue default" and 
> "/usr/bin/perl /usr/share/koha/bin/background_jobs_worker.pl --queue 
> long_tasks".
>
> worker-error.log has a few entries like these three from today:
> 20230419 08:44:53 ccfls-koha-worker-long_tasks: client (pid 12169) killed by 
> signal 13, respawning
> 20230419 09:36:06 ccfls-koha-worker: client (pid 14398) killed by signal 13, 
> respawning
> 20230419 09:59:35 ccfls-koha-worker: client (pid 29935) killed by signal 13, 
> respawning
>
> Those timestamps correspond to three jobs in the jobs queue that didn't 
> complete and have a "null/n" (n being numbers that I think correspond to the 
> number of things in the batch).  The first is a batch item record 
> modification and the other two are holds queue updates.
>
> I cancelled these three jobs and the zombies remained.
>
> worker-output.log has a number of entries like these, but unfortunately there 
> are no timestamps so I can't link it to anything, although the timestamp on 
> the file itself is from yesterday at 13:08, which I think corresponded to a 
> successful staging and import of records.
>
> Use of uninitialized value $subfield_value in pattern match (m//) at 
> /usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
> Use of uninitialized value $subfield_value in string eq at 
> /usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
>
> I did try something else.  The parent process for the long queue had 
> apparently already respawned, but the one for the default one hadn't, so I 
> killed it with -9.  The two zombies that had been there went away and the 
> default queue restarted.  Before I did that I tried a MARC upload, it was 
> stuck at 0%.  I cancelled the job and retried it after killing the default 
> queue and it worked, but it spawned a new zombie which was a child of the 
> long_tasks queue.  Yesterday it seemed to work if there was only one zombie, 
> but not two.  No new entries in either of the worker- files.
>
> Thanks for your help.
>
> c.
> ---
> Cindy Murdock Ames
> IT Services Director
> Meadville Public Library | CCFLS
> https://meadvillelibrary.org | https://ccfls.org
>
> Please report tech support issues in Mantis:  https://mantis.ccfls.org
>
>
> On Wed, Apr 19, 2023 at 2:44 AM Jonathan Druart 
>  wrote:
>>
>> Did you have a look at worker-*.log? Nothing useful there?
>>
>> You can try to send SIGCHLD to the parent to kill the zombie.
>>
>> Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames  a 
>> écrit :
>> >
>> > A few other things I've noticed:
>> >
>> > - Sometimes the zombie processes will go away on their own, sometimes it 
>> > seems when you retry the MARC import or whatever it was that failed.  This 
>> > one is really weird to me as in all my years as a sysadmin I thought it 
>> > was not possible for zombie processes to go away without a reboot.  But 
>> > maybe that's changed and now zombies can rise from the dead.  Lol.
>> >
>> > - In looking at the jobs list in Koha, it seems that Holds queue updates 
>> > are especially prone to getting stuck at a progress of null/1.
>> >
>> > - If you reattempt a job that is stuck (ie, reattempting a MARC file 
>> > upload or what not) it will often succeed.  The original failed job 
>> > remains with a progress of null.
>> >
>> > c.
>> > ---
>> > Cindy Murdock Ames
>> > IT Services Director
>> > Meadville Public Library | CCFLS
>> > https://meadvillelibrary.org | https://ccfls.org
>> >
>> > Please report tech support issues in Mantis:  https://mantis.ccfls.org
>> >
>> >
>> > On Tue, Apr 18, 2023 at 3:55 PM Cindy Murdock Ames  
>> > wrote:
>> >>
>> >> Yes, it's 22.11.04, package version.
>> >>
>> >> ---
>> >> Cindy Murdock Ames
>> >> IT Services Director
>> >> Meadville Public Library | CCFLS
>> >> https://meadvillelibrary.org | https://ccfls.org
>> >>
>> >>
>> >>
>> >>
>> >> On Tu

Re: [Koha] Help needed with zombie background_jobs processes

[Jonathan Druart]

Did you have a look at worker-*.log? Nothing useful there?

You can try to send SIGCHLD to the parent to kill the zombie.

Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames  a écrit :
>
> A few other things I've noticed:
>
> - Sometimes the zombie processes will go away on their own, sometimes it 
> seems when you retry the MARC import or whatever it was that failed.  This 
> one is really weird to me as in all my years as a sysadmin I thought it was 
> not possible for zombie processes to go away without a reboot.  But maybe 
> that's changed and now zombies can rise from the dead.  Lol.
>
> - In looking at the jobs list in Koha, it seems that Holds queue updates are 
> especially prone to getting stuck at a progress of null/1.
>
> - If you reattempt a job that is stuck (ie, reattempting a MARC file upload 
> or what not) it will often succeed.  The original failed job remains with a 
> progress of null.
>
> c.
> ---
> Cindy Murdock Ames
> IT Services Director
> Meadville Public Library | CCFLS
> https://meadvillelibrary.org | https://ccfls.org
>
> Please report tech support issues in Mantis:  https://mantis.ccfls.org
>
>
> On Tue, Apr 18, 2023 at 3:55 PM Cindy Murdock Ames  wrote:
>>
>> Yes, it's 22.11.04, package version.
>>
>> ---
>> Cindy Murdock Ames
>> IT Services Director
>> Meadville Public Library | CCFLS
>> https://meadvillelibrary.org | https://ccfls.org
>>
>>
>>
>>
>> On Tue, Apr 18, 2023 at 2:59 PM Jonathan Druart 
>>  wrote:
>>>
>>> Hi Cindy,
>>> Which exact version of Koha 22.11.xx? It should be the latest one.
>>> Regards,
>>> Jonathan
>>>
>>> Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames  a 
>>> écrit :
>>> >
>>> > Hi all,
>>> >
>>> > A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, 
>>> > and
>>> > I'm having trouble with the background_jobs processes becoming zombies
>>> > after a very short amount of time, necessitating a reboot.  I suspect it's
>>> > a misconfiguration on my part, so if someone can shed some light I'd 
>>> > really
>>> > appreciate it!
>>> >
>>> > The first symptom was our MARC imports getting stuck at "import queued",
>>> > and after some digging (and thanks to the thread in this list with the
>>> > subject of "Background job / Staging MARC import stuck at 0%" I found I 
>>> > was
>>> > entirely missing the  section in our config, so I added
>>> > this:
>>> >
>>> >  
>>> >localhost
>>> >61613
>>> >guest
>>> >guest
>>> >
>>> >  
>>> >
>>> > Which seemed to resolve it, but now I find that the background_jobs
>>> > processes are going zombie after processing only a few jobs.  Here's some
>>> > info from the rabbitmq log after restarting the server:
>>> >
>>> > =INFO REPORT 18-Apr-2023::12:23:46 ===
>>> > node   : rabbit@ccflskoha
>>> > home dir   : /var/lib/rabbitmq
>>> > config file(s) : /etc/rabbitmq/rabbitmq.config (not found)
>>> > cookie hash: ojvkUE6eUtku7kHlx3uiFg==
>>> > log: /var/log/rabbitmq/rab...@ccflskoha.log
>>> > sasl log   : /var/log/rabbitmq/rab...@ccflskoha-sasl.log
>>> > database dir   : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha
>>> >
>>> > Is it problematic that /etc/rabbitmq/rabbitmq.config is missing?  Anything
>>> > else I should be looking at?  We're running on Ubuntu SE 18.04 if that is
>>> > helpful.
>>> >
>>> > Thanks much!
>>> > 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
___

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

Re: [Koha] Help needed with zombie background_jobs processes

[Jonathan Druart]

Hi Cindy,
Which exact version of Koha 22.11.xx? It should be the latest one.
Regards,
Jonathan

Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames  a écrit :
>
> Hi all,
>
> A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, and
> I'm having trouble with the background_jobs processes becoming zombies
> after a very short amount of time, necessitating a reboot.  I suspect it's
> a misconfiguration on my part, so if someone can shed some light I'd really
> appreciate it!
>
> The first symptom was our MARC imports getting stuck at "import queued",
> and after some digging (and thanks to the thread in this list with the
> subject of "Background job / Staging MARC import stuck at 0%" I found I was
> entirely missing the  section in our config, so I added
> this:
>
>  
>localhost
>61613
>guest
>guest
>
>  
>
> Which seemed to resolve it, but now I find that the background_jobs
> processes are going zombie after processing only a few jobs.  Here's some
> info from the rabbitmq log after restarting the server:
>
> =INFO REPORT 18-Apr-2023::12:23:46 ===
> node   : rabbit@ccflskoha
> home dir   : /var/lib/rabbitmq
> config file(s) : /etc/rabbitmq/rabbitmq.config (not found)
> cookie hash: ojvkUE6eUtku7kHlx3uiFg==
> log: /var/log/rabbitmq/rab...@ccflskoha.log
> sasl log   : /var/log/rabbitmq/rab...@ccflskoha-sasl.log
> database dir   : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha
>
> Is it problematic that /etc/rabbitmq/rabbitmq.config is missing?  Anything
> else I should be looking at?  We're running on Ubuntu SE 18.04 if that is
> helpful.
>
> Thanks much!
> 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
___

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

Re: [Koha] Internal server error with ISBD detail and making a hold on OPAC

[Jonathan Druart]

Hi Paul, did you run misc/maintenance/search_for_data_inconsistencies.pl to
catch potential problems with your data?

Le jeu. 2 mars 2023 à 18:03, Paul  a écrit :

> I’m recently started to get internal server errors when looking at ISBD
> detail and making a hold when in the OPAC.
>
> We’re using Koha 19.11.22.000 on Debian 9.
>
> I’ve seen a similar problem reported as bug 22735: Resolve internal server
> error on missing item type but that was on 18.05 and presumably fixed back
> then.
>
> Can anyone offer any fixes please?
>
> Paul Leman
>
> --
> Paul Leman
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Background job / Staging MARC import stuck at 0%

[Jonathan Druart]

Hello Michael,
I have just tried on 22.11.03 and it seems to work for me.
Can you try to open a console, watch the logs: tail -f
/var/log/koha/$KOHA_INSTANCE/*.log
Import a file.
Do you see something in the logs?

Otherwise look at the background_jobs.data JSON, you may see an error in
it. But if the status is still "new" I am not expecting an error there.


Le jeu. 2 mars 2023 à 14:50, Michael Brown  a
écrit :

> Greetings:
>
> My name is Michael Brown and I am a professional cataloger and SirsiDynix
> System Admin at the Texas State Library & Archives in Austin (20+ years
> now). I have been using Koha on Arch Linux in my home library for about a
> year now. I am migrating my home server to AlmaLinux and I'm having a
> problem.
>
> I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a MARC
> file for import gets stuck at 0%. On screen, I am able to select the file
> for import (bib.mrc), review the profile options (but I don't change any
> defaults), and then click on "Stage for import" at the bottom. Next screen
> reads:
>
> The job has been enqueued! It will be processed as soon as possible.
> 0%
> View detail of the enqueued job
>
> After a few seconds, it changes to (and then hangs at):
>
> The job has been enqueued! It will be processed as soon as possible.
> 0% Not started
> View detail of the enqueued job
>
> Clicking on "View detail of the enqueued job" I see:
>
> Details of job #22
>
> Job ID: 22
> Status:New
> Progress:0 / 0
> Type:Staged MARC records for import
> Queued:03/02/2023 05:42
> Started:
> Ended:
>
> Report
> Detailed messages
> Return to the job list
>
> The corresponding entry in mariadb is:
>
> id 22
> status new
> progress NULL
> size 0
> borrowernumber 1
> type stage_marc_for_import
> queue Name of the queue the job is sent to long_tasks
> data {"encoding":"UTF-8","comments":"","basket_id":null...
> context JSON-serialized context information for the job
> {"flags":1,"branch":"ALMA","interface":"intranet",...
> enqueued_on 2023-03-02 05:42:33
> started_on NULL
> ended_on NULL
>
> (If you need to see the full entries for "data" and "context", please let
> me know.)
>
> tmp, koha_upload, and lock directories have been tweaked and fine tuned. I
> was getting early warnings about them not being set in koha-conf.xml so I
> created them (and set correct permissions) and I can see the uploaded file
> (for job 22 the name is 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the
> actual upload function appears to be working.
>
> I am getting no apache errors and no other on-screen diagnostics.
>
> I have Koha 22.05.02.000 running on Arch Linux that imports this file just
> fine. Similarly, I have Koha latest running on a Debian VM that can import
> this file just fine, too.
>
> What am I missing?
>
> Details of my system:
>
> Koha version: 22.11.03.000 Rosalie
> OS version ('uname -a'): Linux alma 5.14.0-162.12.1.el9_1.x86_64 #1 SMP
> PREEMPT_DYNAMIC Mon Jan 23 14:51:52 EST 2023 x86_64
> Perl interpreter: /usr/bin/perl
> Perl version: 5.032001
> Perl @INC: /usr/share/koha/lib
> /usr/local/lib64/perl5/5.32
> /usr/local/share/perl5/5.32
> /usr/lib64/perl5/vendor_perl
> /usr/share/perl5/vendor_perl
> /usr/lib64/perl5
> /usr/share/perl5
> /var/lib/koha/plugins
> MySQL version: mysql Ver 15.1 Distrib 10.5.16-MariaDB, for Linux (x86_64)
> using EditLine wrapper
> Apache version: Server version: Apache/2.4.53 (AlmaLinux) Server built: Jul
> 20 2022 00:00:00
> Memcached: Servers: 127.0.0.1:11211 | Namespace: KOHA | Status: running. |
> Config read from: koha-conf.xml
> Zebra version: Zebra 2.2.7 (C) 1994-2023, 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:
> ac40f289672405a299436d73c1532f9906774cc6 Using ICU
> Zebra status: Running
> Message broker: Using RabbitMQ
> Date and time: 03/01/2023 16:20
> Time zone: Used: America/Chicago | Config: Undefined | Environment (TZ):
> Undefined
>
> Thanks,
> Michael
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha Export Data Options

[Jonathan Druart]

Please reply to the list.

Which exact version of Koha? 22.05.XX? It is missing the last part.

Le jeu. 2 mars 2023 à 09:01, Ms. Naveen Ali  a écrit :

> Hi.
> Sorry for the incomplete information I am using Koha 22.05
>
> Error log shows
>
> [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client
> 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in
> string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.:
> /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer:
> http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl
>
> Thanks.
>
> *With best regards,*
>
> *Naveen Ali*
>
> **
> *ITM-JE (EAKL)*
> *Inst Representative for *
> *HEC Digital Library Resources.*
> *NEDUET, Karachi.*
>
>
>
> --
> *From: *"Jonathan Druart" 
> *To: *"Ms. Naveen Ali" 
> *Cc: *"Koha" 
> *Sent: *Thursday, 2 March, 2023 12:43:55 PM
> *Subject: *Re: [Koha] Koha Export Data Options
>
> Hi,
>
> Which version of Koha?
>
> Do you see an error in the Koha log files?
>
> Regards,
> Jonathan
>
> Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali  a
> écrit :
>
>> Dear All,
>>
>> I use Koha Tools-> Export Data->Export Database Option to download dump
>> of Koha database.
>>
>> I have a large database with over 15 books and 8,000 patron records.
>> The dump was a large file around 400MB.
>>
>> Suddenly the dump file now generated is just 1KB.
>>
>> Sharing contents of file
>> 
>>
>> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
>> --
>> -- Host: localhost Database: koha_library
>> -- --
>> -- Server version 8.0.32-0ubuntu0.20.04.2
>>
>> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
>> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
>> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
>> /*!50503 SET NAMES utf8mb4 */;
>> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
>> /*!40103 SET TIME_ZONE='+00:00' */;
>> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
>> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
>> FOREIGN_KEY_CHECKS=0 */;
>> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
>> */;
>> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
>>
>> -
>>
>>
>> No data in the file. I can't understand the reason for this. Can you
>> please help.
>>
>> With best regards,
>>
>> Naveen Ali
>>
>> ITM-JE (EAKL)
>> Inst Representative for
>> HEC Digital Library Resources.
>> NEDUET, Karachi.
>>
>>
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
___

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

Re: [Koha] Koha Export Data Options

[Jonathan Druart]

Hi,

Which version of Koha?

Do you see an error in the Koha log files?

Regards,
Jonathan

Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali  a écrit :

> Dear All,
>
> I use Koha Tools-> Export Data->Export Database Option to download dump of
> Koha database.
>
> I have a large database with over 15 books and 8,000 patron records.
> The dump was a large file around 400MB.
>
> Suddenly the dump file now generated is just 1KB.
>
> Sharing contents of file
> 
>
> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
> --
> -- Host: localhost Database: koha_library
> -- --
> -- Server version 8.0.32-0ubuntu0.20.04.2
>
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!50503 SET NAMES utf8mb4 */;
> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
> /*!40103 SET TIME_ZONE='+00:00' */;
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
> */;
> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
>
> -
>
>
> No data in the file. I can't understand the reason for this. Can you
> please help.
>
> With best regards,
>
> Naveen Ali
>
> ITM-JE (EAKL)
> Inst Representative for
> HEC Digital Library Resources.
> NEDUET, Karachi.
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] How to resolve bug Bug 28267? What must I do in mysql?

[Jonathan Druart]

Did you see comment 20?
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267#c20

Le jeu. 2 mars 2023 à 06:30, Δημήτρης Δαλαγιώργος <
dimitrios.dalagior...@gmail.com> a écrit :

> Dear all,
>
> I'm not a developer, and as I mentioned before, I'm stuck with an
> inoperable library catalogue due to the fact that I can't update to
> the latest version because "Older databases fail to upgrade due to
> having a row format other than "DYNAMIC"".
>
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
>
> I've read the comments on this bug but I fail to understand what I
> should do to fix this. Obviously I must login to mysql and perform
> some actions. What actions are those? Can someone point me to detailed
> instructions?
>
> Kind regards,
>
> Dimitrios Dalagiorgos
> 3rd high school of Kozani
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] cron problem with automatic_checkin after update to 22.05

[Jonathan Druart]

Make sure you have an item type for all your items. There is a script that
can help you to catch them: misc/maintenance/
search_for_data_inconsistencies.pl

Le mar. 28 févr. 2023 à 22:36, Hector Gonzalez Jaime  a
écrit :

> Hi, we recently updated our system to 22.05 and since then we receive this
> error from cron:
>
> /etc/cron.hourly/koha-common:
> Can't call method "automatic_checkin" on an undefined value at
> /usr/share/koha/lib/Koha/Checkouts.pm line 85.
> kamoxtin: 11 status returned by "/usr/share/koha/bin/cronjobs/
> automatic_checkin.pl"
>
> both files seem to be up to date.  Is this a known issue?  I can't find
> any reference to it or reported bugs.
>
> --
> Hector Gonzalez
> ca...@genac.org
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Wrong CSRF token: Patron Image upload problem in Koha 22.05

[Jonathan Druart]

For your information I don't recreate the problem on master.

Le lun. 13 févr. 2023 à 22:35, Tim McMahon  a écrit :

> We've been having this problem and I was hoping there would be a reply
> to this.  We usually use it in the 'Check out' tab, but found out if we
> click on the 'Details' tab before we try to upload, it will work.  Maybe
> it will work in other tabs, but we haven't tried it.
>
> On 12/28/22 3:31 AM, Dr. Sambhunath Sahoo wrote:
> > Hello Friends,
> > I am facing a problem while uploading patron images in Koha 22.05 only
> > after upgrading from Koha 21.05. The error message showing is " *The form
> > submission failed (Wrong CSRF token). Try to come back, refresh the page,
> > then try again*" and also redirects to the URL .../cgi-bin/koha/tools/
> > picture-upload.pl. I tried, but the same problem persists. Please
> *suggest
> > any solution* to resolve the said issue.
> >
> > Thanks
> >
> > 
> > Regards,
> > Dr. Sambhunath Sahoo / डॉ सम्भुनाथ साहु
> > Assistant Librarian / सहायक पुस्तकालयाध्यक्ष,
> > Central Library / केन्द्रीय पुस्तकालय,
> > 4th Floor, Administrative Building / चौथा मंजिल, प्रशासनिक भवन
> > Indian Institute of Technology Bhubaneswar / भारतीय प्रौद्योगिकी संस्थान
> > भुवनेश्वर
> > Argul, Khurda, Odisha /  आरगुल, खुर्दा, ओड़िशा,
> > 752050 (India)
> > E-Mail:sambhum...@gmail.com
> > *ORCID ID:* -0001-9162-879X
> > *Researcher ID:* K-4446-2018
> > *Scopus ID:* 57222542160
> > 
> > ___
> >
> > Koha mailing listhttp://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> --
> *Tim McMahon*
> West Liberty Public Library
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Upgrade to 21.11 Fails

[Jonathan Druart]

Yes, definitely, it must be owned by the  $INSTANCE-koha user

Le lun. 28 nov. 2022 à 21:38, Bruce A. Metcalf 
a écrit :

> On 11/28/22 16:52, Jonathan Druart wrote:
>
> > Did you upgrade using the debian packages?
>
>
> Yes; always.
>
>
> > The error is saying you don't have the log4perl config file, which
> > needs to be at /etc/koha/sites/$INSTANCE/log4perl.conf
>
>
> This file exists, but I note that it's owned by "root", and not
> "instance-koha". Could this be the issue?
>
> Regards,
> / Bruce /
> Bruce A. Metcalf
> Augustan Library
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Upgrade to 21.11 Fails

[Jonathan Druart]

Did you upgrade using the debian packages?

The error is saying you don't have the log4perl config file, which
needs to be at /etc/koha/sites/$INSTANCE/log4perl.conf

Le lun. 28 nov. 2022 à 15:34, Bruce A. Metcalf
 a écrit :
>
> On 11/28/22 15:07, Jonathan Druart wrote:
>
> > Did you restart koha-common?
>
>
> Yes, I rebooted the whole virtual machine. No change.
>
>
> > Do you have an error in the Koha logs?
>
>
> intranet-error.log
>
> [Mon Nov 28 09:30:06.112562 2022] [cgi:error] [pid 13388] [client ... ]
> AH01215: Configuration not defined at
> /usr/share/perl5/Log/Log4perl/Config.pm line 579.:
> /usr/share/koha/opac/cgi-bin/opac/errors/500.pl
> [Mon Nov 28 09:30:06.148729 2022] [cgi:error] [pid 13388] [client ... ]
> End of script output before headers: 500.pl
>
> Doesen't give me a clue. Anyone else?
>
> Thanks,
> / Bruce /
> Bruce A. Metcalf
> Augustan Library
>
>
> >> Yes, I'm slow on the uptake, I've been running oldoldstable for some
> >> time now. With the release of 22.11, it's time for me to move up.
> >>
> >> My system was installed from deb packages under Debian 10, and has been
> >> updating fine.
> >>
> >> After an update (with no error messages), I find I am unable to access
> >> either the OPAC or the admin interfaces. Both give an "Internal Server
> >> Error" message, with a note that a 500 error was thrown by the
> >> ErrorDocument handler as well.
> >>
> >> Probably something simple, but not something I can see or find in the
> >> release notes. Help!
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Upgrade to 21.11 Fails

[Jonathan Druart]

Hello,

Did you restart koha-common? Do you have an error in the Koha logs?
Run the following command for watch the logs: tail -f /var/log/koha/*/*.log

Regards,
Jonathan

Le lun. 28 nov. 2022 à 13:19, Bruce A. Metcalf
 a écrit :
>
> Greetings,
>
> Yes, I'm slow on the uptake, I've been running oldoldstable for some
> time now. With the release of 22.11, it's time for me to move up.
>
> My system was installed from deb packages under Debian 10, and has been
> updating fine.
>
> After an update (with no error messages), I find I am unable to access
> either the OPAC or the admin interfaces. Both give an "Internal Server
> Error" message, with a note that a 500 error was thrown by the
> ErrorDocument handler as well.
>
> Probably something simple, but not something I can see or find in the
> release notes. Help!
>
> Regards,
> / Bruce /
> Bruce A. Metcalf
> Augustan Library
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] how to add additional attributes in patron CSV file

[Jonathan Druart]

Hello,

Read the "Notes" on the right of the import patrons screen.
"""
If loading patron attributes, the 'patron_attributes' field should
contain a comma-separated list of attribute types and values. The
attribute type code and a colon should precede each value. For
example: INSTID:12345,LANG:fr or STARTDATE:January 1 2010,TRACK:Day.
If an input record has more than one attribute, the fields should
either be entered as an unquoted string (previous examples), or with
each field wrapped in separate double quotes and delimited by a comma:
"STARTDATE:January 1, 2010","TRACK:Day". The second syntax would be
required if the data might have a comma in it, like a date string.
"""

And please send your question to only one mailing list.

Regards,
Jonathan

Le ven. 25 nov. 2022 à 07:51, takan bhatt  a écrit :
>
> Dear Sir,
> We are using additional attributes for patrons like student branch, course,
> etc. We want to upload these through patron.csv file in koha.
>
> Pls guide me
>
> Rajesh Bhatt
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] KOHA not getting install old or new version

[Jonathan Druart]

What's the point of providing different ressources, pointing to
personal blog posts, when I already sent the official wiki page that
is up-to-date and maintained by the community?
Better to contribute to the community wiki if you think it can be improved.
Both of your documents have either obsolete or incorrect steps by the way.

Le mar. 8 nov. 2022 à 09:51, MASTeR Library
 a écrit :
>
> koha install latest  stable version
> https://libpowertech.blogspot.com/2021/03/how-to-install-koha-on-ubuntu-mate-2004.html
>
> On Tue, Nov 8, 2022 at 12:43 PM Laxmi Lal Menaria  
> wrote:
>>
>> Look these basic cleanup steps too here
>> http://cloud-computing.solutions/how-to-install-koha-a-library-software-on-ubuntu/
>>
>>
>> On Tue, Nov 8, 2022 at 12:37 PM Jonathan Druart <
>> jonathan.dru...@bugs.koha-community.org> wrote:
>>
>> > Hello,
>> >
>> > > and followed all the process
>> > What did you follow exactly?
>> > If you are trying to install Koha on debian you should follow this
>> > documentation: https://wiki.koha-community.org/wiki/Koha_on_Debian
>> >
>> > Regards,
>> > Jonathan
>> >
>> > Le mar. 8 nov. 2022 à 01:28, shailendra arora
>> >  a écrit :
>> > >
>> > > I have formatted the pc and installed ubuntu  and followed all the
>> > process
>> > > but koha is not getting installed, not even creating a koha directory.
>> > >
>> > > I somehow installed koha on vm on laptop after lots of trying but now I
>> > am
>> > > trying to install a fully formatted system PC but it is not happening.
>> > >
>> > > some perl file showing  issue but perl is installed and updated too.
>> > >
>> > > Thank's & Regards
>> > >
>> > > Shailendra Arora
>> > >  *( 3D Artist ,Modeler, 3D Animator , Designer,Instructor, PhotoGrapher
>> > )*
>> > >
>> > > e-mail:-  *shailendraaror...@gmail.com *
>> > > Mobile :- *9887503892*
>> > > ___
>> > >
>> > > Koha mailing list  http://koha-community.org
>> > > Koha@lists.katipo.co.nz
>> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> > ___
>> >
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>>
>>
>> --
>>
>> Thanks,
>> Laxmilal Menaria | +91 982 955 3793 | http://cloud-computing.solutions/
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
> --
>  Thanking you..
>
> Librarian,
> MAMCET
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
___

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

Re: [Koha] KOHA not getting install old or new version

[Jonathan Druart]

Hello,

> and followed all the process
What did you follow exactly?
If you are trying to install Koha on debian you should follow this
documentation: https://wiki.koha-community.org/wiki/Koha_on_Debian

Regards,
Jonathan

Le mar. 8 nov. 2022 à 01:28, shailendra arora
 a écrit :
>
> I have formatted the pc and installed ubuntu  and followed all the process
> but koha is not getting installed, not even creating a koha directory.
>
> I somehow installed koha on vm on laptop after lots of trying but now I am
> trying to install a fully formatted system PC but it is not happening.
>
> some perl file showing  issue but perl is installed and updated too.
>
> Thank's & Regards
>
> Shailendra Arora
>  *( 3D Artist ,Modeler, 3D Animator , Designer,Instructor, PhotoGrapher )*
>
> e-mail:-  *shailendraaror...@gmail.com *
> Mobile :- *9887503892*
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Error with installing koha with docker

[Jonathan Druart]

SYNC_REPO must point to Koha src.
Have a look at ktd's readme if you haven't yet

Le lun. 7 nov. 2022 à 17:34, Mathieu Saby  a écrit :

> Hi Jonathan
>
> $PROJECTS_DIR/koha = /home/msaby/projets/koha
> The directory exists, but is empty
>
> Mathieu
>
>
> Le lun. 7 nov. 2022 à 08:00, Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> a écrit :
>
>> Hi Matthieu,
>> List the content of $SYNC_REPO. Do you see Koha root directory content?
>>
>> Le dim. 6 nov. 2022 à 16:55, Mathieu Saby  a
>> écrit :
>>
>>> Hi
>>> I am trying to install Koha with docker on a Ubuntu 22.04 machine
>>> I have followed the instructions at
>>> https://gitlab.com/koha-community/koha-testing-docker/-/tree/master but
>>> the
>>> "ktd up" command gives me an error, and Koha fails to run.
>>> Could someone please give me some advice ?
>>>
>>> The error :
>>> koha-koha-1   | Cannnot open file No such file or directory at
>>> /kohadevbox/misc4dev/cp_debian_files.pl line 35.
>>> koha-koha-1 exited with code 2
>>>
>>>
>>> The git repo for koha testing docker is downloaded in a
>>> /home/msaby/projets/koha-testing-docker
>>>
>>> my ~/.bashrc contains :
>>>
>>> export PROJECTS_DIR=/home/msaby/projets
>>> export SYNC_REPO=$PROJECTS_DIR/koha
>>> export KTD_HOME=$PROJECTS_DIR/koha-testing-docker
>>> export PATH=$PATH:$KTD_HOME/bin
>>> export LOCAL_USER_ID=$(id -u)
>>>
>>> Regards,
>>>
>>> --
>>> Mathieu Saby
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>
> --
> Mathieu Saby
>
>
___

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

Re: [Koha] Error with installing koha with docker

[Jonathan Druart]

Hi Matthieu,
List the content of $SYNC_REPO. Do you see Koha root directory content?

Le dim. 6 nov. 2022 à 16:55, Mathieu Saby  a écrit :

> Hi
> I am trying to install Koha with docker on a Ubuntu 22.04 machine
> I have followed the instructions at
> https://gitlab.com/koha-community/koha-testing-docker/-/tree/master but
> the
> "ktd up" command gives me an error, and Koha fails to run.
> Could someone please give me some advice ?
>
> The error :
> koha-koha-1   | Cannnot open file No such file or directory at
> /kohadevbox/misc4dev/cp_debian_files.pl line 35.
> koha-koha-1 exited with code 2
>
>
> The git repo for koha testing docker is downloaded in a
> /home/msaby/projets/koha-testing-docker
>
> my ~/.bashrc contains :
>
> export PROJECTS_DIR=/home/msaby/projets
> export SYNC_REPO=$PROJECTS_DIR/koha
> export KTD_HOME=$PROJECTS_DIR/koha-testing-docker
> export PATH=$PATH:$KTD_HOME/bin
> export LOCAL_USER_ID=$(id -u)
>
> Regards,
>
> --
> Mathieu Saby
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] OPACSuggestionAutoFill - must be set to 1 or 0

[Jonathan Druart]

It's a bug.
See https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31274

Le lun. 1 août 2022 à 14:42, Fairlamb, Christina  a écrit :
>
> Hello all,
>
> Koha 22.05
>
> I've been adjusting settings for purchase suggestions and tested out the
> Google Books API, after adjusting this setting in System preferences I now
> get a warning on the system information page:
>
> Warning : System preference 'OPACSuggestionAutoFill' must be '0' or '1',
> but is 'yes'.
>
> when set to enable or:
>
> Warning : System preference 'OPACSuggestionAutoFill' must be '0' or '1',
> but is 'no'.
>
> when set to disable.
>
> No message was there before adjusting this preference.
>
> Kind regards
>
> Christina
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

[Koha] Electronic resource management module (ERM) in Koha - quick update

[Jonathan Druart]

Hi,

I have been working during the last months on implementing a first
version of what could be an ERM module in Koha.

To help getting feedback from end-users we have created a sandbox that
has the latest version of the code:
https://staff-erm.sandboxes.biblibre.eu/cgi-bin/koha/erm/erm.pl

For developers who would like to read the code and help get them
onboard, an entry point page has been written with some details about
the implementation:
https://tree.taiga.io/project/joubu-koha-erm/wiki/home

The code is available at https://gitlab.com/joubu/Koha/-/commits/erm

An overview of the current state of the development can be found on
this kanban board: https://tree.taiga.io/project/joubu-koha-erm/kanban

Any feedback, ideas, contributions are greatly welcomed!

Regards,
Jonathan
___

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

Re: [Koha] Koha 22.05: Where has the columns setting for the patrons list gone?

[Jonathan Druart]

I've opened bug 31229 - column visibility broken on patron search view
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31229
I am about to submit a patch


Le dim. 24 juil. 2022 à 14:26, Katrin Fischer
 a écrit :
>
> Hi Anke,
>
> sorry for the late reply. I see the same on current master: the patron
> search table doesn't have a 'Columns' link. I don't know if this was
> intentional with moving the search to the API or if it was an oversight.
>
> Katrin
>
> On 07.07.22 17:30, Bruns, Anke wrote:
> > Hi Katrin,
> >
> > thank you! I meanwhile found out that in some list views in 22.05 the 
> > Columns button is present, in others not. I don't know if this was on 
> > purpose.
> >
> > The difference between 22.05 and 20.11 I stumbled upon is the following:
> >
> > - Home -> Patrons -> (Search for a list of patrons, or just all patrons) -> 
> > in V20.11 just above the table with the patrons list, there is a "Columns" 
> > link (it's not actually a "button") permitting to choose which columns of 
> > the patron record I want to display. In V22.11 this link is missing.
> >
> > Whereas:
> >
> > - Home -> Tools -> Patron lists -> (Choose one of the patron lists, if 
> > existent) -> in the table appearing here, the Columns link is there in 
> > 20.11 and in 22.05.
> >
> > Regards,
> > Anke
> >
> >> -Ursprüngliche Nachricht-
> >> Von: Koha  Im Auftrag von Katrin Fischer
> >> Gesendet: Mittwoch, 6. Juli 2022 19:18
> >> An: koha@lists.katipo.co.nz
> >> Betreff: Re: [Koha] Koha 22.05: Where has the columns setting for the 
> >> patrons
> >> list gone?
> >>
> >> Hi Anke,
> >>
> >> in 22.05 the normal patron search is also used for the circulation
> >> patron search. Maybe you meant that list?
> >>
> >> The settings are in Administration > Table settings > Patrons >
> >> memberresultst
> >>
> >> Hope this helps,
> >>
> >> Katrin
> >>
> >> On 06.07.22 17:02, Bruns, Anke wrote:
> >>> Hi,
> >>>
> >>> a minor problem but nonetheless...: In version 20.11 we had the 
> >>> possibility
> >>> to choose in the staff client which columns from the patron record we 
> >>> wanted
> >>> to display in the patrons short list. There was a "Columns" button next to
> >>> the "Export" one. This option seems to have gone with one of the more 
> >>> recent
> >>> versions (we upgraded directly from 20.11 to 22.05, so no idea when 
> >>> exactly
> >>> this was the case). Instead there is a "Clear filter" button now.
> >>>
> >>> Is there any chance to get the choice of columns option back? E.g. we do 
> >>> not
> >>> need or want to display the Date of Birth column which isn't populated in
> >>> our case.
> >>>
> >>> Thank you for any advice and best regards,
> >>> Anke
> >>>
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] What Happened to Expired News

[Jonathan Druart]

Helle Charles,
There is a checkbox "Show expired" on the left, tick it :)
Regards,
Jonathan

Le ven. 8 juil. 2022 à 00:38, Charles Kelley  a écrit :
>
> Hello, all!
>
> My library is currently upgrading to v. 22.05 from v. 20.05. We can't
> find the expired news.
>
> We keep a lot of our news especially the announcements that are
> recyclable, e.g., "The catalog is down for maintenance" and "The library
> will be closed January 1, 2023, for New Year's."
>
> All we have to do to recycle is to change the display date range, maybe
> adjust the text as demonstrated in the holiday sample above, and voila! The
> edited announcement appears when it's supposed to and vanishes when it's
> supposed to. Right now, it seems we have to recompose the same announcement
> time and time again.
>
> We have sought a system preference, but alas! If it's there, it doesn't
> contain the keyword "news" or "announcement" and we cannot find it or guess
> what it might be called. In v. 22.05, we see a checkbox next to the
> surviving listings with a count of the entire list; and we see a count of
> the listings.
>
> So does anyone know how to revive an expired news listing?
>
> Many thanks for your kind consideration.
>
> --
> よろしくお願いします。
>
> -- Charles.
>
> Until 2022-07-15:
> Charles Kelley, MLS
> PSC 704 Box 1029
> APO AP 96338
> +81-80-4356-2178 [JPN cell]
>
> From 2022-07-18:
> Charles Kelley
> c/o Bob and Ronni DiGioia
> 147 Mitchel Drive
> Oakland, MD 21550 USA
> +1-301-741-7122 [US cell]
>
> mnogoja...@aol.com [h]
> cmkelley...@gmail.com [p]
>
> linkedin.com/in/cmkelleymls
> Meeting Your Information Needs. Virtually.
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Moving Curbside Pickup plugin to Koha core

[Jonathan Druart]

The patches are now ready for QA :)

Le ven. 29 avr. 2022 à 09:39, Jonathan Druart
 a écrit :
>
> Hello,
>
> I have been sponsored to move the Curbside Pickup plugin to Koha core.
>
> If you are using this plugin and have enhancement requests or want to 
> highlight some existing bugs, let us know on the bug report. 
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30650
>
> I am aware of the different issues opened on the github repository of the 
> project and will take them into account as much as I can.
>
> Regards,
> Jonathan
___

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

Re: [Koha] Adding an encryption_key to koha-conf.xml

[Jonathan Druart]

Hello Mike,

I opened bug 31059.
You can use a string that is considered a strong password.
Out of the box Koha does not provide a script to edit this file, but
you could write a script for that (open the xml, generate a key, add
the missing entry, write the xml) then use koha-foreach to run it for
each koha site.

Regards,
Jonathan

Le sam. 25 juin 2022 à 12:21, Mike Lake  a écrit :
>
> Hi All
>
> Just upgraded tonight from Koha 21.11.05.000 to 22.05.00-1
> That all went fine.
>
> The About Koha page now says:
> "Warning: You are missing the  entry in your
> koha-conf.xml file. Please generate a key."
>
> I can see a place for this is the koha-conf-site.xml.in file (and a
> suggestion to use pwgen 32) but how do you process this to the
> koha-conf.xml files for each site?
>
> The "pwgen 32" suggests this should be 32 characters and is itself just
> something that no one should be able to guess. So I can can just put
> anything in there that is long and complex?
>
> I could not find anything about this is the docs or wiki or recent
> emails, just the patch for it in the github repo via Google.
>
> Thanks
> Mike
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Delete patron via REST API - Missing property - Status 500

[Jonathan Druart]

Hi Stephan,

It works as expected for me on master, which version of Koha are you using?

I noticed something similar last week:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31022

Regards,
Jonathan

Le jeu. 30 juin 2022 à 04:25, zefanja  a écrit :
>
> Hello,
>
> I want to delete patrons with the REST API. If the patron has no
> checkouts, everything works fine. But when the patron has checkouts, I
> get this as response from my HTTP DELETE request:
>
> {"errors":[{"message":"Missing property.","path":"\/errors"}],"status":500}
>
> The API docs say that it should return a 409 status with errors →
> has_checkouts
>
> https://api.koha-community.org/#operation/deletePatron
>
> Any ideas? I send the requests to this url:
> https://our-library-intra.com/api/v1/patrons/23
>
> Regards,
> Stephan
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] After Koha update and auto_increment_fix database won't start

[Jonathan Druart]

Hi Isabel,

Search for a more precise error in the mysql/mariadb log files. Maybe
you have an error in the path?
Double check the path you entered in /etc/mysql/my.cnf and the path of
the file you created.

Regards,
Jonathan

Le mar. 28 juin 2022 à 15:51, Isabel Pineda  a écrit :
>
> Hi.
>
> I have just updated Koha from 21.11.06 to 21.11.09. After that I got a 
> warning on the "About Koha" page that some tables have problems with 
> auto_increment, there was a link to this page: 
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
> I followed the instructions on this page, but when I tried to restart mysql, 
> MariaDB wouldn't start. The error message says: job for mariadb.service 
> failed because the control process exited with error code
>
> I looked for solutions, but the only ones that I found included to remove all 
> data from the database directory, and I don't want to do this.
>
> Is there any other solution?
>
> Thank you very much
> Isabel Pineda
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Arrangement of Fields on Items Form

[Jonathan Druart]

Or, better, use the built-in feature :)
You can edit the 952 subfields for your framework, and reorder (drag and
drop) the tabs. Then the order will be kept on the edit item form.
I cannot remember since when it's available however.
Regards,
Jonathan

Le jeu. 2 juin 2022 à 18:00, Eric Phetteplace  a
écrit :

> Hi Naveen,
>
> You could do this with JavaScript added to the IntranetUserJS system
> preference, but as far as I know there's no other way. This line of
> JavaScript, for instance, moves the "non-public note" field from the bottom
> of the add/edit items form to the top:
>
> $('#subfield952x').parent('li').prependTo('#cataloguing_additem_newitem
> ol')
>
> If you want to change the order of many of these fields, it would be quite
> a bit of customization.
>
> Best,
>
> ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
>
> ephettepl...@cca.edu | o 510.594.3660 (cca)
>
> 5212 Broadway | Oakland, CA | 94618
>
> CCA is situated on the traditional unceded lands of the Ohlone peoples.
>
> Black-owned bookstores in Oakland: Ashay by the Bay
> , Marcus Books
> 
>
> :(){ :|: & };:
>
>
> On Wed, Jun 1, 2022 at 11:36 PM Ms. Naveen Ali 
> wrote:
>
> > Dear All,
> >
> > How is it possible to control arrangement of fields on Items form.
> > Which field will appear first and so on.
> >
> > With best regards,
> >
> > Naveen Ali
> >
> > ITM-JE (EAKL)
> > Inst Representative for
> > HEC Digital Library Resources.
> > NEDUET, Karachi.
> >
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Question about creating libraries in Koha -- possible bug

[Jonathan Druart]

You should not ignore this problem. It's not specific to the library admin
page.
The Koha REST API endpoints don't work, and you will face other problems.

Le mer. 1 juin 2022 à 17:59, Andy Boze  a écrit :

> Thanks, Jonathan and Fridolin.
>
> We're not using a standard Debian environment. We use Amazon Linux and
> install Koha from the download page.
>
> The JSON::Validator module we have installed is 4.13.
>
> I think we can work around the problem. We can still create new branch
> libraries, even if we can't see the list, and they do show up elsewhere.
> If we need to edit the library info, we can just enter the URL for the
> form < .../cgi-bin/koha/admin/branches.pl?op=add_form=CODE >
> so this doesn't appear to be a big problem.
>
> Andy
>
> On 6/1/2022 3:00 AM, Jonathan Druart wrote:
> > Hi,
> >
> > Have a look at bug 28800
> > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28800
> > Short version: confirm that you are using JSON::Validator provided by
> > our deb repo
> >
> > Regards,
> > Jonathan
> >
> > Le mer. 1 juin 2022 à 01:19, Andy Boze  > <mailto:boz...@nd.edu>> a écrit :
> >
> > Thanks, Caroline. There's no indication on the Perl modules tab that
> > any
> > of them need to be updated, and it only shows that two are missing,
> > PDF::FromHTML and Time::Fake, which don't seem likely to be causing
> the
> > problem. I'm baffled at this point.
> >
> > Andy
> >
> > On 5/31/2022 3:56 PM, Caroline Cyr La Rose wrote:
> >  > Hi Andy,
> >  >
> >  > I had this problem recently with my development installation and
> it
> >  > turned out I was missing some perl modules or mine were an older
> > version.
> >  >
> >  > Unfortunately, I can't remember exactly which one was the
> > problem. You
> >  > can see the list of necessary modules in the Perl modules tab of
> the
> >  > About page and it will also tell you which ones are missing.
> >  >
> >  > I hope this helps...
> >  >
> >  > Caroline
> >  >
> >  > On 2022-05-31 15:12, Andy Boze wrote:
> >  >> I have three separate instances of Koha 20.11.04. In one of them
> I
> >  >> want to create a new library. When I go to
> >  >>
> >  >>  Home › Administration › Libraries
> >  >>
> >  >> I see no existing libraries listed in any of the three
> > instances. If I
> >  >> click the "+New library" button, I get the form to fill out, and
> > when
> >  >> I submit the form, I get an alert that the library has been
> > created.
> >  >> The Libraries page still doesn't list any libraries. I can see
> that
> >  >> the new library has been added, since it is now an option when I
> >  >> create or edit a patron or if I set circulation and fines rules.
> >  >>
> >  >> I've tried a couple of the demo Koha systems at <
> >  >> https://koha-community.org/demo/ > and they show multiple
> > libraries.
> >  >> Is there a setting that would prevent libraries from displaying
> or
> >  >> does this seem to be a bug?
> >  >>
> >  >> TIA,
> >  >>
> >  >> Andy
> >  >>
> >  > Caroline Cyr La Rose, M.L.I.S.
> >  > Librarian | Product Manager
> >  >
> >  > Phone: 1-833-465-4276, ext. 221
> >  > caroline.cyr-la-r...@inlibro.com
> > <mailto:caroline.cyr-la-r...@inlibro.com
> > <mailto:caroline.cyr-la-r...@inlibro.com>>
> >  >
> >  > INLiBRO | Document Technologies Specialists | www.inLibro.com
> > <http://www.inLibro.com>
> >  > <http://www.inLibro.com>
> >  > ___
> >  >
> >  > Koha mailing list http://koha-community.org
> >  > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
> >  > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> > --
> > Andy Boze, Associate Librarian
> > University of Notre Dame
> > 271H Hesburgh Library
> > (574) 631-8708
> >
> > ___
> >
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> --
> Andy Boze, Associate Librarian
> University of Notre Dame
> 271H Hesburgh Library
> (574) 631-8708
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Question about creating libraries in Koha -- possible bug

[Jonathan Druart]

Hi,

Have a look at bug 28800
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28800
Short version: confirm that you are using JSON::Validator provided by our
deb repo

Regards,
Jonathan

Le mer. 1 juin 2022 à 01:19, Andy Boze  a écrit :

> Thanks, Caroline. There's no indication on the Perl modules tab that any
> of them need to be updated, and it only shows that two are missing,
> PDF::FromHTML and Time::Fake, which don't seem likely to be causing the
> problem. I'm baffled at this point.
>
> Andy
>
> On 5/31/2022 3:56 PM, Caroline Cyr La Rose wrote:
> > Hi Andy,
> >
> > I had this problem recently with my development installation and it
> > turned out I was missing some perl modules or mine were an older version.
> >
> > Unfortunately, I can't remember exactly which one was the problem. You
> > can see the list of necessary modules in the Perl modules tab of the
> > About page and it will also tell you which ones are missing.
> >
> > I hope this helps...
> >
> > Caroline
> >
> > On 2022-05-31 15:12, Andy Boze wrote:
> >> I have three separate instances of Koha 20.11.04. In one of them I
> >> want to create a new library. When I go to
> >>
> >>  Home › Administration › Libraries
> >>
> >> I see no existing libraries listed in any of the three instances. If I
> >> click the "+New library" button, I get the form to fill out, and when
> >> I submit the form, I get an alert that the library has been created.
> >> The Libraries page still doesn't list any libraries. I can see that
> >> the new library has been added, since it is now an option when I
> >> create or edit a patron or if I set circulation and fines rules.
> >>
> >> I've tried a couple of the demo Koha systems at <
> >> https://koha-community.org/demo/ > and they show multiple libraries.
> >> Is there a setting that would prevent libraries from displaying or
> >> does this seem to be a bug?
> >>
> >> TIA,
> >>
> >> Andy
> >>
> > Caroline Cyr La Rose, M.L.I.S.
> > Librarian | Product Manager
> >
> > Phone: 1-833-465-4276, ext. 221
> > caroline.cyr-la-r...@inlibro.com  caroline.cyr-la-r...@inlibro.com>
> >
> > INLiBRO | Document Technologies Specialists | www.inLibro.com
> > 
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> --
> Andy Boze, Associate Librarian
> University of Notre Dame
> 271H Hesburgh Library
> (574) 631-8708
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] OPACnavright in additional contents tool

[Jonathan Druart]

Hi Elaine,

Sorry for the delay.
What you are describing looks like bug 29828
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29828

Regards,
Jonathan

Le mar. 17 mai 2022 à 18:48, Elaine Bradtke  a écrit :

> We still don't know why it happened, but our IT guru managed to fix it by
> manually deleting it from the database.
> Elaine
> VWML 
>
>
>
> On Mon, May 16, 2022 at 12:00 PM Elaine Bradtke  wrote:
>
> > I've tried again in the test site, and I think the problem may have to do
> > with not having text in the default tab? I only entered text in the
> > English United Kingdom tab when I broke it. If I add the text in all
> three
> > tabs (default, English and English GB), it works.  However, the editing
> > window does not open, I have to force it to open by inserting a line.
> Still
> > need help in deleting the item that doesn't show up in the list. (No,
> it's
> > not expired).
> >
> > Elaine
> > VWML 
> >
> >
> >
> > On Mon, May 16, 2022 at 10:55 AM Elaine Bradtke  wrote:
> >
> >> 21.11.05.
> >> I encountered a few problems in adding a new item to the right column in
> >> the OPAC. First, I noticed there were no options to edit the HTML, just
> >> plain text. Then when I saved it, the text repeated itself on the OPAC
> >> see https://catalogue.efdss.org/
> >> When I look at the /koha/tools/additional-contents the item is not there
> >> at all.  I can't find it to edit or delete it.  But it still displays on
> >> the OPAC
> >> This may be complicated by the fact that we use the English United
> >> Kingdom translation (en-GB).
> >> Are there some settings I should look at or is this a bug?
> >> And if it's a bug, how can I delete the problem text?
> >> Thanks!
> >> Elaine Bradtke
> >> VWML 
> >> English Folk Dance and Song Society 
> >> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> >> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
> >> and Song Society in London, England. If you wish to phone me personally,
> >> send an e-mail first. I work off site)
> >>
> --
> >> Registered Company No. 297142
> >> Charity Registered in England and Wales No. 305999
> >>
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

[Koha] Moving Curbside Pickup plugin to Koha core

[Jonathan Druart]

Hello,

I have been sponsored to move the Curbside Pickup plugin to Koha core.

If you are using this plugin and have enhancement requests or want to
highlight some existing bugs, let us know on the bug report.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30650

I am aware of the different issues opened on the github repository of the
project and will take them into account as much as I can.

Regards,
Jonathan
___

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

Re: [Koha] Error when putting book on hold

[Jonathan Druart]

I do recreate the problem with the Spanish template.

A quick fix:
replace line 216 of es-ES/includes/holds_table.inc
from
216  
to
216  

I will provide a fix on
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30583

Regards,
Jonathan


Le jeu. 21 avr. 2022 à 16:11, Katrin Fischer  a
écrit :

> Hi Isabel,
>
> trying to see what could cause this. Are you using translations and does
> this happen with the English templates as well?
>
> There is nothing obviously wrong with the template as far as I could tell:
>
>
> https://git.koha-community.org/Koha-community/Koha/src/branch/21.11.x/koha-tmpl/intranet-tmpl/prog/en/includes/holds_table.inc#L209
>
> Katrin
>
> On 08.04.22 17:51, Isabel Pineda wrote:
> > Hi.
> >
> > Since the latest update (from 21.11.03 to 21.11.04) I get a 500 error
> message when I try to put a book on hold. The hold gets placed though and I
> receive the confirmation e-mail. But I cannot view the reservation in the
> system in the reservations tab.
> >
> > There is no warning message in the About page, but there is an error
> message in my intranet-error.log file: AH01215 Template process failed:
> file error - parse error - holds_table.inc line 209-210: unexpected token
> (hold): /usr/share/koha/intranet/cgi-bin/reserve/request.pl, referer:
> https://biblioteca-intra.ds.edu.sv/cgi-bin/koha/reserve/request.pl?biblionumbers=
> >
> > The reservations used to work always before this update.
> >
> > Btw: I am a little worried about the great mass of messages in my
> intranet-error.log. Every minute there are appearing errors of "Use of
> uninitialized value in string eq at usr/share/koha/lib/C4/Context.pm line
> 784."
> > Is this a bug or is this only my problem?
> >
> > Thank you very much
> > Isabel Pineda
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Equals sign in a macro?

[Jonathan Druart]

Hello,
It's definitely a bug, please open a bug report.

This patch may fix the problem but I am not familiar enough with macros

diff --git a/koha-tmpl/intranet-tmpl/lib/koha/cateditor/macros/rancor.js
b/koha-tmpl/intranet-tmpl/lib/koha/cateditor/macros/rancor.js
index e9b484ef600..f25e7273aaf 100644
--- a/koha-tmpl/intranet-tmpl/lib/koha/cateditor/macros/rancor.js
+++ b/koha-tmpl/intranet-tmpl/lib/koha/cateditor/macros/rancor.js
@@ -149,7 +149,7 @@ define( [ 'marc-editor' ], function( MARCEditor ) {
 target.delete();
 }
 } ],
-[ /^([^=]+)=([^=]*)$/, function( lhs_desc, rhs_desc ) {
+[ /^([^=]+)=(.*)$/, function( lhs_desc, rhs_desc ) {
 var lhs_closure = _generate( _lhsGenerators, lhs_desc );
 if ( !lhs_closure ) return null;

Regards,
Jonathan

Le mar. 22 févr. 2022 à 05:02, Bales (US), Tasha R 
a écrit :

> I would like to create a Macro that enters the base of a URL.  However, I
> find that I cannot execute the macro due to errors caused by the use of an
> equals sign.  Curly braces also seem to cause a problem.  I played around
> trying to see if I could escape the problem characters, but didn't get
> anywhere.  I also tried substituting in "" and "" , which I
> think are HTML codes for "=", just in case, but both seem to be ignored and
> don't make it into the 856 that is created.
>
> Anyone know of a way around this?  Thanks!
>
>
> Tasha Bales
> Enterprise Services
> http://isesi.web.boeing.com/
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] New BibLibre's sandbox server

[Jonathan Druart]

There were too many (timeout) problems with ES configured by default, so I
switched the default search engine to Zebra.
Biblibre's sandboxes should be working again now (no more 503 errors).


Le ven. 9 juil. 2021 à 16:30, Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> a écrit :

> Hi all,
>
> I think I haven't announced it here yet. BibLibre offered the
> community a new server for the sandboxes. It's a replacement to the
> old BibLibre one.
>
> Note that PTFS-E and Bywater's are still around :)
> The only difference is that this one is using elastic search as the
> search engine by default.
>
> https://sandboxes.biblibre.eu/
>
> More info about sandboxes can be found on the wiki:
> https://wiki.koha-community.org/wiki/Sandboxes
>
> Issues or enhancement requests can be done at
> https://gitlab.com/koha-community/koha-sandboxes-docker
>
> Regards,
> Jonathan
>
___

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

Re: [Koha] [Koha-devel] Can't locate object method "output_with_http_headers" via package "CGI"

[Jonathan Druart]

use C4::Output qw( output_with_http_headers )

will fix it. See also the "Other" section of the tech release note from
21.11 (related to bug 17600)
https://koha-community.org/koha-21-11-released/

Le mer. 12 janv. 2022 à 17:17, Michael Kuhn  a écrit :

> Hi
>
> Our library uses a non-Koha Perl script to authenticate with Divibib
> Onleihe (a digital distributor like Overdrive). The script worked with
> Koha 18.05 but after the update to Debian 11 with Perl 5.032001 und Koha
> 21.11.01 the following error appears:
>
>   Can't locate object method "output_with_http_headers" via package
> "CGI" at /usr/share/koha/opac/cgi-bin/opac/onleihe_auth.pl line 91.
>
> The script file actually contains these lines (among others):
>
>   use CGI;
>   use XML::Simple;
>   use Koha::Patrons;
>   use Koha::AuthUtils qw(hash_password);
>   use Digest::MD5 qw(md5_base64);
>   use C4::Output;
>   use C4::Context;
>   my $query = new CGI;
>   ...
>   output_with_http_headers $query, undef, $xml, 'xml';
>
> Can anyone please give me a hint how to solve this problem?
>
> 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
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
___

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

Re: [Koha] Where to place RSS xml output?

[Jonathan Druart]

Hello Tasha,

Some months ago I had a look at those files and I didn't manage to
make them work
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28893#c7
I think we should remove them from the codebase to avoid confusion.

Regards,
Jonathan

Le dim. 2 janv. 2022 à 03:43, Bales (US), Tasha R
 a écrit :
>
> Good evening,
>
> I've been reviewing the sample templates and configuration files for custom 
> RSS.  On my system, these are installed here:  
> /usr/share/koha/bin/cronjobs/rss.  I'm stuck on where to place the XML that 
> is produced in order to make the output accessible/subscribable via the OPAC.
>
> I've tried placing the XML files into koha/opac/cgi-bin/opac and into 
> koha/opac/cgi-bin/opac/rss.  Then, I tried accessing the files (with 
> permissions set to 755) using the following guesses at URL scheme:
>
> http://mycatalog.com/cgi-bin/koha/lastAcquired.xml (results in a blank page 
> that has only the words "not found" in the upper left)
> http://mycatalog.com/cgi-bin/koha/rss/lastAcquired.xml (results in 500 
> internal server error)
> http://mycatalog.com/lastAcquired.xml (results in an Error 404 in the OPAC, 
> "Sorry, the requested page is not available")
>
> I'm sure the issue is a matter of ignorance on my part as to what the best 
> and acceptable locations are for placing "local" files.  I apologize for 
> that, but please know I invested a couple hours before asking.  Thanks in 
> advance if anyone has tips as to where to place the files, and then, how to 
> access them.
>
> Excerpt from lastAcquired.conf:
>
> title=Recent Koha Acquisitions
> link=http://www.koha-community.org (<-- I assume this is supposed to be my 
> catalog URL, and I updated accordingly)
> desc=The 15 most recent acquisitions
> ...
> title=Koha, the worlds best Open Source Library System
> url=http://www.koha-community.org/images/foo.jpg
> link=http://www.koha-community.org
> config
> template=lastAcquired.tt
> output=[here I inserted path to destination folder]/lastAcquired.xml
>
>
> Tasha Bales
> Enterprise Services
> http://isesi.web.boeing.com/
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Issue with "Additional contents (HTML customizations)"

[Jonathan Druart]

I have attached a patch on bug 29778 that should fix the problem.

Le dim. 2 janv. 2022 à 15:57, Katrin Fischer
 a écrit :
>
> Hi Michael,
>
> thx for pointing this out! I later realized I had only looked at the
> English templates and that is where the issue was. I have found the
> steps to make it happen on master and filed a bug:
>
> *Bug 29778*
>  -
> Deleting additional_contents is incomplete and leaves entries for
> additional languages
>
> Katrin
>
> On 01.01.22 19:48, Michael Kuhn wrote:
> > Hi Katrin
> >
> > You wrote:
> >
> > > I have tried adding OpacNavRight and OpacMainUserBlock entries on your
> > > demo installation, but deleting the entries always makes the content
> > > go away.
> >
> > No, it doesn't - it seems like your last entry in "OpacMainUserBlock"
> > was "test". Is that correct? It still can be seen at
> > https://koha.adminkuhn.ch/ - together with my own test entry from
> > earlier this day (but only until the next reset tomorrow at 5 AM):
> >
> > Test Kuhn 1.1.2022
> > test
> >
> > It is just below the "news" entry when choosing language "Deutsch
> > Deutschland (de_DE)".
> >
> > The menu entry in "Additional contents (HTML customizations)" is gone,
> > but as said the original entry in the OPAC is still
> > there.https://koha.adminkuhn.ch/
> >
> > Of course it is also still in the database (along with more stuff that
> > shouldn't be there anymore! Since the menu entries are gone the table
> > shouldn't contain any entries of category "html_customizations", as
> > far as I see it):
> >
> > | 4 | html_customizations | OpacMainUserBlock_3 |
> > OpacMainUserBlock | NULL   | Test Kuhn 1.1.2022| Test Kuhn
> > 1.1.2022
> >
> >
> >   | de-DE   |
> > 2022-01-01   | 2022-01-01 14:41:45 | NULL   | NULL | 1 |
> > | 7 | html_customizations | OpacNavRight_6  | OpacNavRight |
> > NULL   | kkk   | kkk
> >
> >
> >   | de-CH   |
> > 2022-01-01   | 2022-01-01 16:25:41 | NULL   | NULL | 1 |
> > | 8 | html_customizations | OpacNavRight_6  | OpacNavRight |
> > NULL   | iii   | iii
> >
> >
> >   | it-IT   |
> > 2022-01-01   | 2022-01-01 16:25:41 | NULL   | NULL | 1 |
> > |10 | html_customizations | OpacNavRight_9  |
> > OpacMainUserBlock | NULL   | test  | test
> >
> >
> >   | de-DE   |
> > 2022-01-01   | 2022-01-01 16:28:36 | NULL   | NULL | 1 |
> >
> > As I see now, there is more weirs stuff going on: "test" (which you
> > included for language "it-IT") can still be seen when choosing the
> > main language (de-DE) while Italian is not even one of the possible
> > choices!
> >
> > I believe there is some problem with the "standard" and the different
> > languages of menu "Additional contents (HTML customizations)".
> >
> > > Could you provide a step by step guide so we can see where the
> > > difference is?
> > >
> > > I believe it would be save to delete these entries.
> >
> > Thanks, for now I'll do that! But of course this isn't really the
> > solution.
> >
> > 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] OPACXSLDetailsDisplay - No display at all in OPAC

[Jonathan Druart]

Bonjour Rémi,

Can you confirm that you are using UNIMARC? Does it work if you use
"default" instead of the full path to the xsl files?
From which version of Koha did you upgrade?

Regards,
Jonathan

Le mar. 7 déc. 2021 à 18:32, Bibliothèque Lyon
 a écrit :
>
> Hi everybody,
>
> It's my first message on this list. I hope that I'm using it properly.
>
> Since the upgrade of my installation of Koha to version 20.11.11.000, I
> have the following issue.
>
> If I change the settings of OPACXSLTDetailsDisplay system property to
> /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt/UNIMARCslim2OPACDetail.xsl
> and
> of OPACXSLTResultsDisplay to
> /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt/UNIMARCslim2OPACDetail.xsl,
> I get an *empty display without any data*, as if Koha ignores completely
> the xsl transformation and returns *nothing to display*. Koha ignores
> completely the directives in this XSL file.
>
> There is probably something I've completely forgotten.
> Any help would be appreciated!
>
> Rémi
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067

[Jonathan Druart]

I have opened bug
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29631

Le jeu. 2 déc. 2021 à 20:11, David L. Whelchel
 a écrit :

>
> Hi all,
>
> I have received this error when upgrading from 21.06.00.012  to 21.11. I do 
> not see any information in the bug list or lists.
>
> ---
> Updating database structure
> Update errors :
>
> Upgrade to 21.06.00.012 [10:59:41]: Bug 15067 - Add missing languages
> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 
> 'IN-region' for key 'uniq_lang' at /usr/share/koha/lib/C4/Installer.pm line 
> 738
> 
>
> Any help would be appreciated.
>
> --Dave
> ---
> David L. Whelchel
> 725 SE Derby Street
> Pullman, WA 99163
> whelc...@pullman.com
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067

[Jonathan Druart]

Hello David, George,

Did you keep track of the problematic entries?

Regards,
Jonathan

Le ven. 3 déc. 2021 à 09:53,  a écrit :
>
> Hi Dave,
>
> I had similar problem and I found that on the table  "language_descriptions" 
> was the problem , because on bug 15607 is trying to generate unique indexes 
> and if you have a double value there you have a problem like that you 
> described. You should remove the duplicate value and re-run your upgrade 
> though web installer.
> Also I suggest you to check for double values other language_* tables.
>
> Regards,
> George Veranis
> Dataly Tech
> https://dataly.gr
>
> -Original Message-
> From: Koha  On Behalf Of David L. Whelchel
> Sent: Thursday, December 2, 2021 9:12 PM
> To: koha (koha@lists.katipo.co.nz) 
> Subject: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067
>
> Hi all,
>
> I have received this error when upgrading from 21.06.00.012  to 21.11. I do 
> not see any information in the bug list or lists.
>
> ---
> Updating database structure
> Update errors :
>
> Upgrade to 21.06.00.012 [10:59:41]: Bug 15067 - Add missing languages
> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 
> 'IN-region' for key 'uniq_lang' at /usr/share/koha/lib/C4/Installer.pm line 
> 738
> 
>
> Any help would be appreciated.
>
> --Dave
> ---
> David L. Whelchel
> 725 SE Derby Street
> Pullman, WA 99163
> whelc...@pullman.com
>
> ___
>
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] translating authorized values

[Jonathan Druart]

Hello Lauren,

There are several bug reports related to authorised values translatability:

Bug 24977 - Enable translations for authorised values (POC)
Bug 24975 - Refactor database translations
Bug 20307 - Language overlay for authorized values

However they are stuck for a year and developers lack interest in the topic.
You could eventually show your interest by leaving a comment.

Regards,
Jonathan

Le ven. 3 déc. 2021 à 02:11, Lauren Denny  a écrit :
>
> Hi everyone,
>
> I work for a consortium that serves several languages.  I'm trying to find
> a way to translate our authorized values for shelving locations and
> collection codes so that everyone can understand the terms.  I was
> wondering if it is possible to translate the values created for authorized
> values of it I have to create new values in each language. I know that item
> types can be translated and was wondering if there is an option to do the
> same thing for different authorized values.
>
> Thank you for your help.
>
> Lauren
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] translate Koha

[Jonathan Druart]

Hello Igor,

Your translation looks correct!
The "Python brace placeholders" error/warning must be ignored.

Have a look at this thread we had on koha-translate last year:
https://lists.koha-community.org/pipermail/koha-translate/2020-December/002819.html

Regards,
Jonathan

Le mer. 1 déc. 2021 à 06:01, Сычев Игорь Алексеевич  a écrit :
>
> Hello Koha Community!
> Please tell me how to fix the error?
> https://translate.koha-community.org/ru/21.11/translate/ru-RU-messages.po - 
> filter=checks=critical
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Koha 21.11.00 released

[Jonathan Druart]

I let you catch the missing 'o'! :-)

Le ven. 26 nov. 2021 à 14:34, Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> a écrit :

> Hell everybody,
>
> Today is the day everybody is talking about: Koha 21.11.00 is out!
>
> It is with great pleasure that the Koha community announces the
> release of Koha 21.11, a major release of the Koha open source
> integrated library system.
>
> Read the full release notes here:
> https://koha-community.org/koha-21-11-released/
>
> The Debian packages for this new version will be available soon. Stay
> tuned!
>
> Note that I have built some statistics about the Koha development
> community, using git.
> I have published the charts on the wiki:
> https://wiki.koha-community.org/wiki/Development_Community_Statistics
>
> Cheers,
> Jonathan
>
___

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

[Koha] Koha 21.11.00 released

[Jonathan Druart]

Hell everybody,

Today is the day everybody is talking about: Koha 21.11.00 is out!

It is with great pleasure that the Koha community announces the
release of Koha 21.11, a major release of the Koha open source
integrated library system.

Read the full release notes here:
https://koha-community.org/koha-21-11-released/

The Debian packages for this new version will be available soon. Stay tuned!

Note that I have built some statistics about the Koha development
community, using git.
I have published the charts on the wiki:
https://wiki.koha-community.org/wiki/Development_Community_Statistics

Cheers,
Jonathan
___

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

Re: [Koha] [Koha-devel] KohaAdvent - Call for idea's

[Jonathan Druart]

Hey, the Koha deveppers core team is willing to show and explain anything
you want.
Don't you have some specific needs or questions? :)


Le ven. 15 oct. 2021 à 09:01, Renvoize, Martin <
martin.renvo...@ptfs-europe.com> a écrit :

> Hi all,
>
> We're looking to organise another Koha advent calendar series this year
> and I'm trying to be a bit more organised than last year. (
> https://koha-community.gitlab.io/KohaAdvent/)
>
> Last years calendar was themed around building a plugin. This year I'd
> like to suggest a broader community theme with best practice guides and how
> to's including all the way's people can contribute to the project and get
> the most out of the community.
>
> With that in mind, are there any area's anyone would like us to focus on
> in particular, any how-to guides you would be keen to see?  Let us know and
> I'll try and find the appropriate person to write something up.
>
> Many thanks in advance for your idea's
>
> *Martin Renvoize, MPhys (Hons)*
>
> 
>
> Head of Development and Community Engagement
>
>
>
> *Phone:* +44 (0) 1483 378728
>
> *Mobile:* +44 (0) 7725 985 636
>
> *Email:* martin.renvo...@ptfs-europe.com
>
> www.ptfs-europe.com
>
>
> *Sign up for our newsletters here  or by
> scanning the QR code*
>
>
>
> Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30
>
> The information contained in this email message may be privileged,
> confidential and protected from disclosure. If you are not the intended
> recipient, any dissemination, distribution or copying is strictly
> prohibited. If you think that you have received this email message in
> error, please email the sender at i...@ptfs-europe.com
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
___

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

Re: [Koha] Koha 20.05.17 released

[Jonathan Druart]

Fixed, it was still in draft mode.

Le sam. 30 oct. 2021 à 15:44, Michael Kuhn  a écrit :
>
> Hallo Victor
>
> You wrote:
>
>  > The Koha Community is happy to announce the release of Koha 20.05.17
>  >
>  > The full release notes can be found at:
>  > https://koha-community.org/koha-20-05-17-released/
>
> Unfortunately there are no release notes to be found under that URL...
>
> 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
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Error "500" on Opac

[Jonathan Druart]

Hum, the about page will only tell you if you have a syntax error actually.

Le mer. 20 oct. 2021 à 22:06, Jonathan Druart
 a écrit :
>
> Check OpacHiddenItems, you have 'Location' there (that's wrong, must
> be 'location')
> Errors should also be on the about page.
> Always have a look at the about page when something goes wrong :)
>
> Le mer. 20 oct. 2021 à 21:56, Bruce Yelen  a écrit :
> >
> > Hi Jonathan,
> >
> > I was not receiving any errors.  However, after disabling Plack (which was 
> > apparently masking the error) I received this in opac-error.log:
> >
> > [Wed Oct 20 13:46:48.822441 2021] [cgi:error] [pid 3947] [client 
> > 73.153.28.4:20161] AH01215: The method Koha::Item->Location is not covered 
> > by tests!: /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> > https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> > [Wed Oct 20 13:46:48.822517 2021] [cgi:error] [pid 3947] [client 
> > 73.153.28.4:20161] AH01215: : 
> > /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> > https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> > [Wed Oct 20 13:46:48.822626 2021] [cgi:error] [pid 3947] [client 
> > 73.153.28.4:20161] AH01215: Trace begun at 
> > /usr/share/koha/lib/Koha/Object.pm line 827: 
> > /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> > https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> > [Wed Oct 20 13:46:48.822819 2021] [cgi:error] [pid 3947] [client 
> > 73.153.28.4:20161] AH01215: 
> > Koha::Object::AUTOLOAD('Koha::Item=HASH(0x5645384f3d40)') called at 
> > /usr/share/koha/lib/Koha/Item.pm line 622: 
> > /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> > https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> > [Wed Oct 20 13:46:48.822941 2021] [cgi:error] [pid 3947] [client 
> > 73.153.28.4:20161] AH01215: Koha::Item::__ANON__ at 
> > /usr/share/koha/lib/Koha/Item.pm line 622: 
> > /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> > https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> > "opac-error.log" 27L, 9324C
> >
> > So, at least I got a starting point to go "dumpster diving" into the code 
> >
> > - Bruce
> >
> > -Original Message-
> > From: Jonathan Druart 
> > Sent: Wednesday, October 20, 2021 1:26 AM
> > To: Bruce Yelen 
> > Cc: koha 
> > Subject: Re: [Koha] Error "500" on Opac
> >
> > Hello Bruce,
> >
> > Is there something in the Koha log files? `tail -f 
> > /var/log/koha/$INSTANCE/*.log` then refresh the page that generates the 500.
> >
> > Regards,
> > Jonathan
> >
> > Le dim. 17 oct. 2021 à 00:44, Bruce Yelen  a 
> > écrit :
> > >
> > > Being rather new to this list, I will apologize in advance if I'm
> > > mis-framing this question.
> > >
> > >
> > >
> > > After upgrading from Koha 20.05 to 21.05, I started receiving an HTTP
> > > 500 error when an OPAC user clicks on a specific title in the list
> > > returned by a catalog search.  This does not occur when doing a
> > > catalog search on the staff pages.  I have looked through the various
> > > Koha logs, but cannot find any errors pointing to a script, or
> > > anything.  Any ideas and suggestions of where to look for the cause and 
> > > resolution of this would be helpful.
> > >
> > >
> > >
> > > Many Thanks!
> > >
> > >
> > >
> > > Bruce Yelen
> > >
> > > ___
> > >
> > > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Error "500" on Opac

[Jonathan Druart]

Check OpacHiddenItems, you have 'Location' there (that's wrong, must
be 'location')
Errors should also be on the about page.
Always have a look at the about page when something goes wrong :)

Le mer. 20 oct. 2021 à 21:56, Bruce Yelen  a écrit :
>
> Hi Jonathan,
>
> I was not receiving any errors.  However, after disabling Plack (which was 
> apparently masking the error) I received this in opac-error.log:
>
> [Wed Oct 20 13:46:48.822441 2021] [cgi:error] [pid 3947] [client 
> 73.153.28.4:20161] AH01215: The method Koha::Item->Location is not covered by 
> tests!: /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> [Wed Oct 20 13:46:48.822517 2021] [cgi:error] [pid 3947] [client 
> 73.153.28.4:20161] AH01215: : 
> /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> [Wed Oct 20 13:46:48.822626 2021] [cgi:error] [pid 3947] [client 
> 73.153.28.4:20161] AH01215: Trace begun at /usr/share/koha/lib/Koha/Object.pm 
> line 827: /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> [Wed Oct 20 13:46:48.822819 2021] [cgi:error] [pid 3947] [client 
> 73.153.28.4:20161] AH01215: 
> Koha::Object::AUTOLOAD('Koha::Item=HASH(0x5645384f3d40)') called at 
> /usr/share/koha/lib/Koha/Item.pm line 622: 
> /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> [Wed Oct 20 13:46:48.822941 2021] [cgi:error] [pid 3947] [client 
> 73.153.28.4:20161] AH01215: Koha::Item::__ANON__ at 
> /usr/share/koha/lib/Koha/Item.pm line 622: 
> /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl, referer: 
> https://library.bouldermasons.org/cgi-bin/koha/opac-search.pl?idx==pike_group_limit=_search=1
> "opac-error.log" 27L, 9324C
>
> So, at least I got a starting point to go "dumpster diving" into the code 
>
> - Bruce
>
> -Original Message-
> From: Jonathan Druart 
> Sent: Wednesday, October 20, 2021 1:26 AM
> To: Bruce Yelen 
> Cc: koha 
> Subject: Re: [Koha] Error "500" on Opac
>
> Hello Bruce,
>
> Is there something in the Koha log files? `tail -f 
> /var/log/koha/$INSTANCE/*.log` then refresh the page that generates the 500.
>
> Regards,
> Jonathan
>
> Le dim. 17 oct. 2021 à 00:44, Bruce Yelen  a écrit :
> >
> > Being rather new to this list, I will apologize in advance if I'm
> > mis-framing this question.
> >
> >
> >
> > After upgrading from Koha 20.05 to 21.05, I started receiving an HTTP
> > 500 error when an OPAC user clicks on a specific title in the list
> > returned by a catalog search.  This does not occur when doing a
> > catalog search on the staff pages.  I have looked through the various
> > Koha logs, but cannot find any errors pointing to a script, or
> > anything.  Any ideas and suggestions of where to look for the cause and 
> > resolution of this would be helpful.
> >
> >
> >
> > Many Thanks!
> >
> >
> >
> > Bruce Yelen
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Error "500" on Opac

[Jonathan Druart]

Hello Bruce,

Is there something in the Koha log files? `tail -f
/var/log/koha/$INSTANCE/*.log` then refresh the page that generates
the 500.

Regards,
Jonathan

Le dim. 17 oct. 2021 à 00:44, Bruce Yelen  a écrit :
>
> Being rather new to this list, I will apologize in advance if I'm
> mis-framing this question.
>
>
>
> After upgrading from Koha 20.05 to 21.05, I started receiving an HTTP 500
> error when an OPAC user clicks on a specific title in the list returned by a
> catalog search.  This does not occur when doing a catalog search on the
> staff pages.  I have looked through the various Koha logs, but cannot find
> any errors pointing to a script, or anything.  Any ideas and suggestions of
> where to look for the cause and resolution of this would be helpful.
>
>
>
> Many Thanks!
>
>
>
> Bruce Yelen
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

[Koha] Koha 21.11 release dates

[Jonathan Druart]

Hello everybody,

Here is the timeline for the 21.11 major release:

* Oct 29th - "Soft" feature freeze, nothing big or with high risk of
side-effects will be included into the final release if not marked as
Passed QA
* Nov 3-5 - "Hard" feature freeze, nothing considered as an
improvement will be pushed if not marked as Passed QA
* Nov 10th - String freeze, draft of release notes published
* Nov 17th - Only bug fixes considered major, critical or blocker
will be pushed
* Nov 26th - Final release

Let me know if you have any comments or modification requests!

Regards,
Jonathan
___

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

Re: [Koha] Roles for 22.05 open

[Jonathan Druart]

The election of the 22.05 team will take place during the next general
IRC meeting, on Wednesday October 20th 2021, 14:00 UTC.
https://wiki.koha-community.org/wiki/General_IRC_meeting_20_October_2021

There is still plenty of room available!


Le mer. 29 sept. 2021 à 17:12, Jonathan Druart
 a écrit :
>
> Hello everybody,
>
> The roles for the 22.05 release cycle are now opened.
> The vote will take place during one of the dev meetings in October.
>
> https://wiki.koha-community.org/wiki/Roles_for_22.05
>
> The description of the roles can be found at this wiki page
> https://wiki.koha-community.org/wiki/Project_roles
>
> Regards,
> Jonathan
___

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

Re: [Koha] LDAP changes from 19.xx to 21.05 ?

[Jonathan Druart]

Looks like you hit bug 28385, but it's supposed to be fixed on 21.05.
Are you using the debian package? How did you upgrade?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28385

Le mar. 12 oct. 2021 à 02:17, Hector Gonzalez Jaime  a écrit :
>
> Hello, we recently tried to update our development server to 21.05, and
> it mostly works, but it does not like our LDAP setup, which is unchanged.
>
> plack-error.log is filled with errors from this one:
>
> Error while loading /etc/koha/plack.psgi: No ldapserver "hostname"
> defined in KOHA_CONF: /etc/koha/sites/clavius/koha-conf.xml at
> /usr/share/koha/lib/C4/Auth_with_ldap.pm line 58,  line 755.
>
> Now, we did not touch our LDAP configuration, which was correct and
> working with 19.11.  Can somebody help find out what changed? Our ldap
> configuration is like this now:
>
>
>   
>  ip.address.for.server
>  ou=users,dc=domain,dc=example,dc=org
>  1
>  1   
>  1
> uid=%s,ou=users,dc=domain,dc=example,dc=org
>   
>
>
>
>Tijuana, BCN
>
>TJNA
>
>
>
>
>STUDENT
>1
>  
>
>
> Thanks.
>
> --
> Hector Gonzalez
> ca...@genac.org
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] linked item subfield to unlinked item subfield (items.more_subfields_xml)

[Jonathan Druart]

Salut Julien,
'Easily' I don't know. But quite easily with a small script.
0. Have 2 frameworks, FwA with your subfield linked to paidfor and FwB
with no DB link
1. loop over the items
2. Retrieve the item and save it using FwB (C4::Items::ModItemFromMarc)

Haven't tried, but it should work. If you write it, I can review it if you want.
Cheers,
Jonathan

Le jeu. 30 sept. 2021 à 09:00, Julien Sicot
 a écrit :
>
> Hi everyone,
>
> Do you know if there is a method, a script or a tool to easily migrate a 
> linked (koha db) item subfield to an unlinked item subfield (ie : 
> items.more_subfields_xml).
> We will soon upgrade koha from 18.11 to 20.11and we are trying to find a 
> solution to the removal of items.paidfor subfield. We have used paidfor to 
> store some item values so that can be easily searched using the item search 
> functionality…
>
> Sadly, in 20.11 we have not determined any other column in the database that 
> are not already in use or linked to another marc subfield…
>
> Thanks for any help,
> Best,
>
> Julien Sicot
> Applications documentaires
> DSI - Pôle Applications
> Université Rennes 2
> 02 22 51 44 41
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

[Koha] Roles for 22.05 open

[Jonathan Druart]

Hello everybody,

The roles for the 22.05 release cycle are now opened.
The vote will take place during one of the dev meetings in October.

https://wiki.koha-community.org/wiki/Roles_for_22.05

The description of the roles can be found at this wiki page
https://wiki.koha-community.org/wiki/Project_roles

Regards,
Jonathan
___

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

[Koha] New Koha minor versions released - security fixes included, UPGRADE!

[Jonathan Druart]

Hello everybody,

I am announcing, on behalf of the whole Koha release team,
synchronised releases for the four release versions we are currently
supporting.

The release notes are available below:
21.05.04 - 
https://koha-community.org/koha-21-05-04-released-%e2%9a%a0-security-release/
20.11.10 - 
https://koha-community.org/koha-20-11-10-released-%e2%9a%a0-security-release/
20.05.16 - 
https://koha-community.org/koha-20-05-16-released-%e2%9a%a0-security-release/
19.11.22 - 
https://koha-community.org/koha-19-11-22-released-%e2%9a%a0-security-release/

As they contain security bug fixes we suggest you upgrade all the Koha
instances you are in charge of as soon as possible.

Let us know if you have any questions.

Regards,
Jonathan
___

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

Re: [Koha] How to Update and Upgrade Koha

[Jonathan Druart]

Hi Hector, Well detailed instructions, it would help to have them on
the wiki page :)
Would you mind updating the existing section?
https://wiki.koha-community.org/wiki/Koha_on_Debian#Upgrade

Le jeu. 16 sept. 2021 à 01:44, Hector Gonzalez Jaime  a écrit :
>
> I forgot something, if koha requires additional software to be
> installed, when you run apt-get upgrade it will say something like this:
>
> The following packages have been kept back:
>koha-common
>
> In this case, you will need to do:
>
> apt-get dist-upgrade
>
> which will install the needed packages and then it will upgrade koha.
>
>
> On 9/15/21 6:25 PM, Hector Gonzalez Jaime wrote:
> > Hi, as with anything else, you should first have a good (tested)
> > backup of everything.  Koha, server software, and database.
> >
> > Then, if you used the debian packages, you should check which version
> > you are "tracking", something like:
> >
> > grep -Ri koha /etc/apt/*
> >
> > would return something like:
> >
> > /etc/apt/sources.list.d/koha.list:deb
> > http://debian.koha-community.org/koha 19.11 main
> >
> > That means there is a file /etc/apt/sources.list.d/koha.list which you
> > should edit and change to the version you want to track now. The
> > content of the file would be:
> >
> > deb http://debian.koha-community.org/koha 21.05 main
> >
> > if you want to track koha 21.05
> >
> > Then you would:
> >
> > apt-get update
> > apt-get upgrade
> >
> > and it should do the upgrade.  With the following exception, if
> > apt-get upgrade says it would need to update mariadb-server or
> > mysql-server, then you should upgrade that first and separately, like
> > this:
> >
> > apt-get update
> > apt-get install mariadb-server-10.3
> > apt-get upgrade
> >
> > If you don't upgrade mariadb first, it will be DOWN when koha wants to
> > upgrade the database, leaving you with a half upgraded system.  (And
> > using that backup).
> >
> > Hope this helps.
> >
> > On 9/15/21 6:04 PM, Charles Kelley wrote:
> >> Hi, all!
> >>
> >>  I think I have asked about this before, but I don't recall
> >> getting a
> >> definitive answer. But it's awhile, so here goes.
> >>
> >>  I have seen announcements about updates and upgrades to Koha.
> >> ("Come
> >> and get it!") Alas, I don't find instructions for installing updates and
> >> upgrades. There are initial installation instructions aplenty, but
> >> alas, if
> >> there are ones for updates and upgrades, I don't see them. So I ask:
> >>
> >>  How does one update or upgrades Koha?
> >>
> >>  Thanks for your help, everyone.
> >>
> --
> Hector Gonzalez
> ca...@genac.org
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Unable to login in Web Installer 21.5

[Jonathan Druart]

Please link to the official Koha community documentation page when
it's available.
https://wiki.koha-community.org/wiki/Koha_on_Debian

Le mar. 14 sept. 2021 à 16:58, MASTeR Library
 a écrit :
>
> Koha installation
> https://libpowertech.blogspot.com/2021/03/how-to-install-koha-on-ubuntu-mate-2004.html?m=1
>
> On Tue, 14 Sep 2021, 12:52 pm Sebastian Krieg, <
> sebastian.kr...@tuz-eisenach.de> wrote:
>
> > Hello Sanjay,
> >
> > there are two ways:
> >
> > 1. Please login in a shell at your koha server, change to the superuser
> > 'root' and execute 'koha-passwd [libraryname]' where [libraryname] is the
> > given instance name during the installation. You will get the database
> > password for the instance user. Note, that the command will make a 'clear'
> > with next click.
> >
> > 2. Look into the file '/etc/koha/sites/[libraryname]/koha-conf.xml'. You
> > will get the informations about the instance user in line 270 and the
> > password in line 271.
> >
> > These are the login informations.
> >
> > Greets
> >
> > Sebastian
> >
> >
> >
> > ---
> > mailto: sebastian.kr...@tuz-eisenach.de
> >
> > 13. September 2021 19:06, "Sanjay Uchcharia" 
> > schrieb:
> >
> > > Sir,
> > >
> > > I've installed Koha on Ubuntu 20.04 but I'm unable to login in Web
> > > Installer 21.5 with the username & password.
> > > ___
> > >
> > > Koha mailing list http://koha-community.org
> > > Koha@lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

[Koha] Security releases for all stable branches - UPGRADE!

[Jonathan Druart]

Hello everybody,

Don't ignore this email!

Last week a critical security bug was reported on our bug tracker. We
fixed it and built debian packages for the four stable releases we
currently support.

The security flaw can cause a privilege escalation from OPAC users. It
can be highly damaging, especially if your staff interface is
accessible via login from everywhere without further security measures
like IP restrictions in place.


How to fix the problem?
If you are using a debian-based system you should upgrade using the
debian packages:
% apt update
% apt install koha-common

If you are using an older version of Koha (<19.11) you should either
upgrade to a newer version, or apply those two patches (they should
apply on older versions as well):
https://paste.debian.net/hidden/885fb5ec/
https://paste.debian.net/hidden/1184f523/
https://paste.debian.net/plainh/ae9f9f25

You can apply them using the following command:
% wget "https://paste.debian.net/plainh/885fb5ec; -O 28929_1.patch
% wget "https://paste.debian.net/plainh/1184f523; -O 28929_2.patch
% wget "https://paste.debian.net/plainh/ae9f9f25; -O 28947.patch
% patch -p1 -d /usr/share/koha/intranet/cgi-bin/ <
/kohadevbox/koha/28929_1.patch
% patch -p1 -d /usr/share/koha/opac/cgi-bin/ < /kohadevbox/koha/28929_2.patch
% patch -d /usr/share/koha/opac/cgi-bin/opac/ < /kohadevbox/koha/28947.patch

The two bugs are 28929 and 28947. As they contain information about
how to recreate the vulnerability they will stay hidden two more days to let
you upgrade your systems.

Let us know if you have any questions!

Regards,
Jonathan
___

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