Send Koha-devel mailing list submissions to
    koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
    koha-devel-request@lists.koha-community.org

You can reach the person managing the list at
    koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."


Today's Topics:

1. German language (de-DE) no more shown after update to Koha
21.05.01 (Michael Kuhn)
2. Update from Koha 19.11 to 21.05 terminating because "Row size
too large" (Michael Kuhn)
3. Re: German language (de-DE) no more shown after update to
Koha 21.05.01 (Michael Kuhn)
4. Call for news - Newsletter July 2021 (Michael Kuhn)


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

Message: 1
Date: Mon, 12 Jul 2021 20:38:12 +0200
From: Michael Kuhn <mik@adminkuhn.ch>
To: Koha-devel <koha-devel@lists.koha-community.org>
Subject: [Koha-devel] German language (de-DE) no more shown after
    update to Koha 21.05.01
Message-ID: <40ffdcae-aa3a-a619-bee2-3f3cafe57d61@adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi

We were on Debian GNU/Linux 9 with Koha 19.11.00, our configured
language was german (de-DE). Today we updated first to Debian GNU/Linux
10, then to Koha 21.05.01. At the end of the update it said:

Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release
Error: the selected language is already installed. Try --update if you
want to re-install it.
ERROR: an error was found when updating 'de-DE' translations. Please
manually
run 'koha-translate --update de-DE'. Run man koha-translate for more
options.

Now our language German (de-DE) is gone, instead only English (en) is
there. The Koha system preferences "language" und "OPACLanguages" just
show "English" but these checkboxes are not even checked. German is not
there anymore.

I tried to run "koha-translate" with various options but it didn't help:

# koha-translate --list
de-DE
# koha-translate --update de-DE
Error: the selected language is already installed. Try --update if you
want to re-install it.

# koha-translate --remove de-DE
# koha-translate --list
de-DE

# koha-translate --install de-DE
Error: the selected language is already installed. Try --update if you
want to re-install it.

When trying to use option "--dev" the program tries to access a
non-existing directory called "koha-tmpl".

# koha-translate --list de-DE --dev ndz
ls: cannot access '/usr/share/koha/koha-tmpl/opac-tmpl/bootstrap/': No
such file or directory

How can we regain the German language?

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch


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

Message: 2
Date: Mon, 12 Jul 2021 21:29:44 +0200
From: Michael Kuhn <mik@adminkuhn.ch>
To: Koha-devel <koha-devel@lists.koha-community.org>
Subject: [Koha-devel] Update from Koha 19.11 to 21.05 terminating
    because "Row size too large"
Message-ID: <f3d534b1-2f4e-cd27-54fc-8c0c39608f1e@adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi

Today I updated our host from Debian GNU/Linux 9 with Koha 19.11.00
first to Debian GNU/Linux 10, then to Koha 21.05.01. When running
"apt-get install koha-common" the process terminated showing the
following messages:

### BEGIN #########################

Upgrade to 19.12.00.052 done [18:30:04]: Bug 21443 - Add ability to
exclude holidays when calculating rentals fees by time period
{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large.
The maximum row size for the used table type, not counting BLOBs, is
8126. This includes storage overhead, check the manual. You have to
change some columns to TEXT or BLOBs [for Statement "ALTER TABLE
borrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL DEFAULT 1
AFTER anonymized"] at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
    DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x30abec0), "DBI
Exception: DBD::mysql::db do failed: Row size too large. "...) called at
/usr/share/perl5/DBIx/Class/Storage.pm line 113
    DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x3aa549c), "DBI Exception: DBD::mysql::db do failed: Row size too large. "...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501
    DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Row size
too large. The maximum row"..., DBI::db=HASH(0x3ee6314), undef) called
at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 21313

dpkg: error processing package koha-common (--configure):
installed koha-common package post-installation script subprocess
returned error exit status 11
Processing triggers for systemd (241-7~deb10u7) ...
Errors were encountered while processing:
koha-common
E: Sub-process /usr/bin/dpkg returned an error code (1)
Script done, file is /tmp/apt-get_install_koha-common_20210712.txt

### END #########################

This looks a lot like
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986 (Maximum
row size reached soon for borrowers and deletedborrowers) or
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
(Koha-common package upgrade problem from 20.05.xx to 20.11.04-1) but
it's not exactly the same.

According to
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/
I ran the described script "rowsize.sh" which showed me the following 7
tables with row size too large.

aqbooksellers
biblioitems
borrower_modifications
borrowers
deletedbiblioitems
deletedborrowers
z3950servers

One solution seems to be to alter the row format of these tables from
"Compact" to "Dynamic" so I did that for all seven tables.

ALTER TABLE aqbooksellers ROW_FORMAT=DYNAMIC;
etc

After running "apt-get install koha-common" again, the process continued
with

Upgrade to 19.12.00.053 done [19:19:28]: Bug 24476 - Allow patrons to
opt-out of autorenewal

and ran to the end.

Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release
Error: the selected language is already installed. Try --update if you
want to re-install it.
ERROR: an error was found when updating 'de-DE' translations. Please
manually
run 'koha-translate --update de-DE'. Run man koha-translate for more
options.

Except of the error regarding the "selected language" which I have
described in another e-mail to koha-devel, everything seems to work fine.

Still I'm asking myself if I should open another bug report about "Row
size too large" since the problem does not to be solved by Bug 24986
("Pushed to master for 20.11") or the pending Bug 28267.

Also I'm not sure what consequences the changed row format "Dynamic" for
these 7 tables might have.

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch


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

Message: 3
Date: Mon, 12 Jul 2021 23:42:09 +0200
From: Michael Kuhn <mik@adminkuhn.ch>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] German language (de-DE) no more shown after
    update to Koha 21.05.01
Message-ID: <8ea94e89-7ad6-0512-a5f6-a3bcb9d96782@adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi

Regarding my last e-mail (see below) I found out "koha-translate"
thought German (de-DE) was still installed because there was an empty
directory named "/usr/share/koha/opac/htdocs/opac-tmpl/prog/de-DE". I
deleted that directory and then was able to (seemlingly) successfully
install German, even if the output looked somewhat disturbing::

# koha-translate --install de-DE
/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.
(Symbolic links are not supported at the moment)
Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more
information.
/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.
(Symbolic links are not supported at the moment)
Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more
information.
/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.
(Symbolic links are not supported at the moment)
Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more
information.
/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.
(Symbolic links are not supported at the moment)
Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more
information.

But then again - why was German (except said directory "de-DE") deleted
in the first place? Is this a bug or did I do something wrong?

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch



Am 12.07.21 um 20:38 schrieb Michael Kuhn:
> Hi
>
> We were on Debian GNU/Linux 9 with Koha 19.11.00, our configured
> language was german (de-DE). Today we updated first to Debian GNU/Linux
> 10, then to Koha 21.05.01. At the end of the update it said:
>
> Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release
> Error: the selected language is already installed. Try --update if you
> want to re-install it.
> ERROR: an error was found when updating 'de-DE' translations. Please
> manually
> run 'koha-translate --update de-DE'. Run man koha-translate for more
> options.
>
> Now our language German (de-DE) is gone, instead only English (en) is
> there. The Koha system preferences "language" und "OPACLanguages" just
> show "English" but these checkboxes are not even checked. German is not
> there anymore.
>
> I tried to run "koha-translate" with various options but it didn't help:
>
> # koha-translate --list
> de-DE
> # koha-translate --update de-DE
> Error: the selected language is already installed. Try --update if you
> want to re-install it.
>
> # koha-translate --remove de-DE
> # koha-translate --list
> de-DE
>
> # koha-translate --install de-DE
> Error: the selected language is already installed. Try --update if you
> want to re-install it.
>
> When trying to use option "--dev" the program tries to access a
> non-existing directory called "koha-tmpl".
>
> # koha-translate --list de-DE --dev ndz
> ls: cannot access '/usr/share/koha/koha-tmpl/opac-tmpl/bootstrap/': No
> such file or directory
>
> How can we regain the German language?
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@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/




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

Message: 4
Date: Tue, 13 Jul 2021 08:36:32 +0200
From: Michael Kuhn <mik@adminkuhn.ch>
To: koha <koha@lists.katipo.co.nz>, koha-devel
    <koha-devel@lists.koha-community.org>
Subject: [Koha-devel] Call for news - Newsletter July 2021
Message-ID: <04486943-6dbf-5295-6a5c-f2cbab10d2da@adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi

I'm collecting news for the July 2021 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
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch


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

Subject: Digest Footer

_______________________________________________
Koha-devel mailing list
Koha-devel@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/


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

End of Koha-devel Digest, Vol 188, Issue 7
******************************************