- Koha - lists.katipo.co.nz

More problems with Google security upgrade
by Tim McMahon 14 Jun '22

14 Jun '22

We're using our Koha server as the SMTP server, so we're not having the same problems as I've been reading from others. Our problem is we started having trouble sending to Gmail accounts. This started around the time people started posting about their problems sending from Gmail accounts. Does anyone know of any changes we'd need to make to our settings to get Gmail to accept notices from Koha? -- *Tim McMahon* West Liberty Public Library

4 3

Plack error after update to Koha 21.11.06
by Michael Kuhn 14 Jun '22

14 Jun '22

Hi We were updating from Debian GNU/Linux 9 to 10, then from Koha 20.11.03 to Koha 21.11.06. This is a Debian package installation. Now Plack throws many error messages like the following in file "/var/log/koha/plack-error.log": Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can't locate JSON/Validator/OpenAPI/Mojolicious.pm in @INC (you may need to install the JSON::Validator::OpenAPI::Mojolicious module) (@INC contains: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.28.1 /usr/local/share/perl/5.28.1 /usr/lib/x86_64-linux-gnu/perl5/5.28 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.28 /usr/share/perl/5.28 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base /var/lib/koha/whu/plugins) at /usr/share/koha/lib/Koha/REST/V1.pm line 25. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/REST/V1.pm line 25. Compilation failed in require at (eval 507) line 1. Compilation failed in require at (eval 506) line 1. Child process 21538 exited with status 255 I see there is bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi concerning this problem but there doesn't seem to be a solution for our case. On our Debian GNU/Linux 10 system package "libjson-validator-perl" is the newest version (3.06+dfsg-1). 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 mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 4

Duplicate entry 'ar' for key 'PRIMARY'
by Victor Barroso Oliveira 14 Jun '22

14 Jun '22

Hello, Has any colleague in the group already had this problem when trying to update the database? Upgrade to 21.12.00.013 [19:25:20]: Bug 29605 - Resync DB structure for existing installations ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 Grateful if you can share with me the solution of the error.

2 1

Request to list in paid support provider
by koha＠ourlib.in 14 Jun '22

14 Jun '22

Hello Community, Please add Ourlib.in under paid service provider list on community website. We are Mumbai,India based and providing services for koha installation,support and training in Asia region. Following are the details : Company Name:Ourlib Contact Person: Dev Contact email: koha(a)ourlib.in Website: www.ourlib.in Telephone:+91 9405334767 With Regards, Dev

2 2

SMTP configuration error
by Ms. Naveen Ali 13 Jun '22

13 Jun '22

Dear All, I am trying to setup SMTP to send email notices; Using KOHA 21.11 and have configured the SMTP servers using the option in the Administration Module I have configured Gmail SMTP with the following information Host: smtp.gmail.com Port: 587 Timeout:120s SSL: SSL Authentication: Yes (My gmail email address and password) I am receiving failed email status with "Unhandled email failure, check the logs for further details" Looking into mailing list threads, i tried running the process_message_queue.pl manually and got the following error library@KOHA:/usr/share/koha/bin/cronjobs$ ./process_message_queue.pl unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 170. Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Templates.pm line 153. Use of uninitialized value $file in exists at /usr/share/koha/lib/Koha/Config.pm line 78. Use of uninitialized value $file in hash element at /usr/share/koha/lib/Koha/Config.pm line 79. Use of uninitialized value $file in hash element at /usr/share/koha/lib/Koha/Config.pm line 82. Use of uninitialized value $file in exists at /usr/share/koha/lib/Koha/Config.pm line 78. Use of uninitialized value $file in hash element at /usr/share/koha/lib/Koha/Config.pm line 82. Use of uninitialized value $INC[-1] in string eq at /usr/share/koha/lib/Koha/Plugins.pm line 40. Use of uninitialized value $INC[-1] in string eq at /usr/share/perl/5.30/Net/Config.pm line 27. Use of uninitialized value in require at /usr/share/perl/5.30/Net/Config.pm line 29. Use of uninitialized value $file in exists at /usr/share/koha/lib/Koha/Config.pm line 78. Use of uninitialized value $file in hash element at /usr/share/koha/lib/Koha/Config.pm line 82. Use of uninitialized value $file in exists at /usr/share/koha/lib/Koha/Config.pm line 78. Use of uninitialized value $file in hash element at /usr/share/koha/lib/Koha/Config.pm line 82. DBIx::Class::Storage: BI::catch {...} (): DBI Connection failed: Can't call method "get" on an undefined value at /usr/share/koha/lib/Koha/Database.pm line 61. at /usr/share/koha/lib/Koha/Database.pm line 139 I tried updating the the /usr/share/koha/lib/C4/Context.pm file with the path /etc/koha/sites/library/koha-conf.xml but no success. How do I resolve this issue?? With thanks and best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi.

5 4

Call for news - Newsletter June 2022
by Koha Newsletter 13 Jun '22

13 Jun '22

Hi I'm collecting news for the June 2022 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * News items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter

1 0

Re: [Koha] Edit OPACBLOCK after upgrading to 21.11
by Victor Barroso Oliveira 13 Jun '22

13 Jun '22

Hello, With your support I was able to reset the database of most instances. As per the routine below. Thanks. However, one of the instances presented a different error when restarting the database. Upgrade to 21.12.00.013 [19:25:20]: Bug 29605 - Resync DB structure for existing installations ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 What would be the instruction to make the above error? -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- After updating to version 22.05 all bases present the installation screen on koha. When I update the database, I get the following error. Upgrade to 21.12.00.048 [21:43:30]: Bug 30291 - Renaming recalls table columns ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot drop index 'borrowernumber': needed in a foreign key constraint at /usr/share/koha/lib/C4/Installer.pm line 739 Solution mysql >USE database; mysql >SET foreign_key_checks = 0; mysql > ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id int(11) NOT NULL DEFAULT 0; koha-upgrade-schema library Upgrade to 21.12.00.048 [18:55:35]: Bug 30291 - Renaming recalls table columns Upgrade to 21.12.00.049 [18:55:35]: Bug 30563 - Add system preference RequireCashRegister Upgrade to 21.12.00.050 [18:55:35]: Bug 29924 - Add password expiration Added password_expiry_days to categories Added password_expiration_date field to borrowers Added password_expiration_date field to borrowers Upgrade to 21.12.00.051 [18:55:35]: Bug 29925 - Add password reset option Upgrade to 21.12.00.052 [18:55:35]: Bug 30290 - Modify AR notices, include TOC line WARNING: If you have translated AR notices, please add TOC lines yourself. Upgrade to 21.12.00.053 [18:55:35]: Bug 30611 - Add STAFF_PASSWORD_RESET notice Upgrade to 21.12.00.054 [18:55:35]: Bug 23352 - Adding new column 'subscription.ccode' Upgrade to 21.12.00.055 [18:55:35]: Bug 13412 - Add GenerateAuthorityField667 and GenerateAuthorityField670 system preferences Upgrade to 21.12.00.056 [18:55:35]: Bug 30728 - Allow opting out of real-time holds queue updating possible Upgrade to 21.12.00.057 [18:55:35]: Bug 30852 - Add index to article_requests.debit_id Upgrade to 22.05.00.000 [18:55:35]: Koha 22.05.00 release Em sáb., 11 de jun. de 2022 às 14:15, Victor Barroso Oliveira < vbovictor(a)gmail.com> escreveu: > after running > the following message appears > ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id int(11) NOT > NULL DEFAULT 0; > ERROR 1553 (HY000): Cannot drop index 'borrowernumber': needed in a > foreign key constraint > > > Em sex., 10 de jun. de 2022 às 17:56, Fridolin SOMERS < > fridolin.somers(a)biblibre.com> escreveu: > >> Hi, >> >> Sorry I cant see where the problem is. >> >> Please onpen a report on >> https://bugs.koha-community.org/bugzilla3/enter_bug.cgi?product=Koha >> >> Best regards, >> >> Le 10/06/2022 à 00:31, Victor Barroso Oliveira a écrit : >> > Ubuntu 20.04.4 LTS >> > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) >> > using readline 5.2 >> > >> > This command did not work in Mariadb >> > $dbh->do(q{ ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id >> > int(11) NOT NULL DEFAULT 0 }); >> > >> > Em sex., 10 de jun. de 2022 às 04:01, Fridolin SOMERS >> > <fridolin.somers(a)biblibre.com <mailto:fridolin.somers@biblibre.com>> >> > escreveu: >> > >> > Strange, the DBRev SQL looks OK : >> > >> > $dbh->do(q{ ALTER TABLE recalls CHANGE COLUMN borrowernumber >> patron_id >> > int(11) NOT NULL DEFAULT 0 }); >> > >> > What version of MySQL/MariaDB and OS ? >> > >> > Le 09/06/2022 à 20:55, Fridolin SOMERS a écrit : >> > > Hi Victor, please always reply to the list ;) >> > > >> > > Le 09/06/2022 à 14:51, Victor Barroso Oliveira a écrit : >> > >> >> > >> After updating to version 22.05 all bases present the >> installation >> > >> screen on koha. >> > >> When I update the database, I get the following error. >> > >> Upgrade to 21.12.00.048 [21:43:30]: Bug 30291 - Renaming >> recalls >> > >> table columns >> > >> ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: >> Cannot >> > >> drop index 'borrowernumber': needed in a foreign key constraint >> at >> > >> /usr/share/koha/lib/C4/Installer.pm line 739 >> > >> >> > >> how can i solve this? >> > >> >> > >> Em qui., 9 de jun. de 2022 às 18:02, Fridolin SOMERS >> > >> <fridolin.somers(a)biblibre.com >> > <mailto:fridolin.somers@biblibre.com> >> > <mailto:fridolin.somers@biblibre.com >> > <mailto:fridolin.somers@biblibre.com>>> >> > >> escreveu: >> > >> >> > >> Hi, >> > >> >> > >> You mean OpacMainUserBlock, changed by : >> > >> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794 >> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794> >> > >> >> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794 >> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794>> >> > >> Convert OpacMainUserBlock system preference to news block >> > >> >> > >> See the manual : >> > >> >> > >> >> > >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizati… >> > < >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizati… >> > >> > >> > >> >> > >> >> > >> >> > < >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizati… >> > < >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizati… >> >> >> > >> > >> >> > >> >> > >> Best regards, >> > >> >> > >> Le 09/06/2022 à 02:09, Victor Barroso Oliveira a écrit : >> > >> > Good Morning, >> > >> > I'm not able to edit OPACBLOCK after upgrading to 21.11 >> > >> > What would be the procedure to edit the block again? >> > >> > Thanks, >> > >> > _______________________________________________ >> > >> > >> > >> > Koha mailing list http://koha-community.org >> > <http://koha-community.org> >> > >> <http://koha-community.org <http://koha-community.org>> >> > >> > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> >> > <mailto: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> >> > >> <https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha>> >> > >> >> > >> -- Fridolin SOMERS <fridolin.somers(a)biblibre.com >> > <mailto:fridolin.somers@biblibre.com> >> > >> <mailto:fridolin.somers@biblibre.com >> > <mailto:fridolin.somers@biblibre.com>>> >> > >> Software and system maintainer 🦄 >> > >> BibLibre, France >> > >> _______________________________________________ >> > >> >> > >> Koha mailing list http://koha-community.org >> > <http://koha-community.org> >> > >> <http://koha-community.org <http://koha-community.org>> >> > >> Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> >> > <mailto: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> >> > >> <https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha>> >> > >> >> > > >> > >> > -- >> > Fridolin SOMERS <fridolin.somers(a)biblibre.com >> > <mailto:fridolin.somers@biblibre.com>> >> > Software and system maintainer 🦄 >> > BibLibre, France >> > _______________________________________________ >> > >> > Koha mailing list http://koha-community.org < >> http://koha-community.org> >> > Koha(a)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> >> > >> >> -- >> Fridolin SOMERS <fridolin.somers(a)biblibre.com> >> Software and system maintainer 🦄 >> BibLibre, France >> >

1 0

Re: [Koha] How to edit and update JS in KOHA?
by David Tan 11 Jun '22

11 Jun '22

Hi all, I am having some difficulty in understanding how KOHA update JS file. Example I edited a function in a JS file located in "/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/js" directory and when I refresh the page nothing happen to the page that contain call to the JS file. It seems KOHA page does not recognise the changes I make to the JS file. Is there additional steps I need to do to get JS file changes to be updated correctly in KOHA? Appreciate anyone that can point me to the right path. David

2 1

Error update 22.05
by Victor Barroso Oliveira 10 Jun '22

10 Jun '22

After updating to version 22.05 all bases present the installation screen on koha. When I update the database, I get the following error. *Upgrade to 21.12.00.048 [21:43:30]: Bug 30291 - Renaming recalls table columnsERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot drop index 'borrowernumber': needed in a foreign key constraint at /usr/share/koha/lib/C4/**Installer.pm line 739* In Ubuntu 20.04.4 LTS mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 How can I solve this problem?

1 0

ERROR Upgrading Database to 21.12.00.016
by Keith Sorbo 10 Jun '22

10 Jun '22

HELP! While running an automated upgrade I am getting the following error Updating database structure Update errors : - Upgrade to 21.12.00.016 [04:05:32]: Bug 30060 - Update user_permissions to add primary key and remove null option from code column ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `PRIMARY`' at line 1 at /usr/share/koha/lib/C4/Installer.pm line 739

3 3