<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 16976 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 188, Issue 7<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. German language (de-DE) no more shown after update to Koha<br> 21.05.01 (Michael Kuhn)<br> 2. Update from Koha 19.11 to 21.05 terminating because "Row size<br> too large" (Michael Kuhn)<br> 3. Re: German language (de-DE) no more shown after update to<br> Koha 21.05.01 (Michael Kuhn)<br> 4. Call for news - Newsletter July 2021 (Michael Kuhn)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 12 Jul 2021 20:38:12 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: Koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] German language (de-DE) no more shown after<br> update to Koha 21.05.01<br>Message-ID: <40ffdcae-aa3a-a619-bee2-3f3cafe57d61@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi<br><br>We were on Debian GNU/Linux 9 with Koha 19.11.00, our configured <br>language was german (de-DE). Today we updated first to Debian GNU/Linux <br>10, then to Koha 21.05.01. At the end of the update it said:<br><br>Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release<br>Error: the selected language is already installed. Try --update if you <br>want to re-install it.<br>ERROR: an error was found when updating 'de-DE' translations. Please <br>manually<br>run 'koha-translate --update de-DE'. Run man koha-translate for more <br>options.<br><br>Now our language German (de-DE) is gone, instead only English (en) is <br>there. The Koha system preferences "language" und "OPACLanguages" just <br>show "English" but these checkboxes are not even checked. German is not <br>there anymore.<br><br>I tried to run "koha-translate" with various options but it didn't help:<br><br># koha-translate --list<br>de-DE<br># koha-translate --update de-DE<br>Error: the selected language is already installed. Try --update if you <br>want to re-install it.<br><br># koha-translate --remove de-DE<br># koha-translate --list<br>de-DE<br><br># koha-translate --install de-DE<br>Error: the selected language is already installed. Try --update if you <br>want to re-install it.<br><br>When trying to use option "--dev" the program tries to access a <br>non-existing directory called "koha-tmpl".<br><br># koha-translate --list de-DE --dev ndz<br>ls: cannot access '/usr/share/koha/koha-tmpl/opac-tmpl/bootstrap/': No <br>such file or directory<br><br>How can we regain the German language?<br><br>Best wishes: Michael<br>--<br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 12 Jul 2021 21:29:44 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: Koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] Update from Koha 19.11 to 21.05 terminating<br> because "Row size too large"<br>Message-ID: <f3d534b1-2f4e-cd27-54fc-8c0c39608f1e@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi<br><br>Today I updated our host from Debian GNU/Linux 9 with Koha 19.11.00 <br>first to Debian GNU/Linux 10, then to Koha 21.05.01. When running <br>"apt-get install koha-common" the process terminated showing the <br>following messages:<br><br>### BEGIN #########################<br><br>Upgrade to 19.12.00.052 done [18:30:04]: Bug 21443 - Add ability to <br>exclude holidays when calculating rentals fees by time period<br>{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. <br>The maximum row size for the used table type, not counting BLOBs, is <br>8126. This includes storage overhead, check the manual. You have to <br>change some columns to TEXT or BLOBs [for Statement "ALTER TABLE <br>borrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL DEFAULT 1 <br>AFTER anonymized"] at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.<br> DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x30abec0), "DBI <br>Exception: DBD::mysql::db do failed: Row size too large. "...) called at <br>/usr/share/perl5/DBIx/Class/Storage.pm line 113<br> 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<br> DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Row size <br>too large. The maximum row"..., DBI::db=HASH(0x3ee6314), undef) called <br>at <br>/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl <br>line 21313<br><br>dpkg: error processing package koha-common (--configure):<br> installed koha-common package post-installation script subprocess <br>returned error exit status 11<br>Processing triggers for systemd (241-7~deb10u7) ...<br>Errors were encountered while processing:<br> koha-common<br>E: Sub-process /usr/bin/dpkg returned an error code (1)<br>Script done, file is /tmp/apt-get_install_koha-common_20210712.txt<br><br>### END #########################<br><br>This looks a lot like <br>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986 (Maximum <br>row size reached soon for borrowers and deletedborrowers) or <br>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 <br>(Koha-common package upgrade problem from 20.05.xx to 20.11.04-1) but <br>it's not exactly the same.<br><br>According to <br>https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/ <br>I ran the described script "rowsize.sh" which showed me the following 7 <br>tables with row size too large.<br><br> aqbooksellers<br> biblioitems<br> borrower_modifications<br> borrowers<br> deletedbiblioitems<br> deletedborrowers<br> z3950servers<br><br>One solution seems to be to alter the row format of these tables from <br>"Compact" to "Dynamic" so I did that for all seven tables.<br><br> ALTER TABLE aqbooksellers ROW_FORMAT=DYNAMIC;<br> etc<br><br>After running "apt-get install koha-common" again, the process continued <br>with<br><br> Upgrade to 19.12.00.053 done [19:19:28]: Bug 24476 - Allow patrons to <br>opt-out of autorenewal<br><br>and ran to the end.<br><br> Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release<br> Error: the selected language is already installed. Try --update if you <br>want to re-install it.<br> ERROR: an error was found when updating 'de-DE' translations. Please <br>manually<br> run 'koha-translate --update de-DE'. Run man koha-translate for more <br>options.<br><br>Except of the error regarding the "selected language" which I have <br>described in another e-mail to koha-devel, everything seems to work fine.<br><br>Still I'm asking myself if I should open another bug report about "Row <br>size too large" since the problem does not to be solved by Bug 24986 <br>("Pushed to master for 20.11") or the pending Bug 28267.<br><br>Also I'm not sure what consequences the changed row format "Dynamic" for <br>these 7 tables might have.<br><br>Best wishes: Michael<br>--<br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 12 Jul 2021 23:42:09 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] German language (de-DE) no more shown after<br> update to Koha 21.05.01<br>Message-ID: <8ea94e89-7ad6-0512-a5f6-a3bcb9d96782@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi<br><br>Regarding my last e-mail (see below) I found out "koha-translate" <br>thought German (de-DE) was still installed because there was an empty <br>directory named "/usr/share/koha/opac/htdocs/opac-tmpl/prog/de-DE". I <br>deleted that directory and then was able to (seemlingly) successfully <br>install German, even if the output looked somewhat disturbing::<br><br># koha-translate --install de-DE<br>/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.<br>(Symbolic links are not supported at the moment)<br>Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more <br>information.<br>/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.<br>(Symbolic links are not supported at the moment)<br>Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more <br>information.<br>/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.<br>(Symbolic links are not supported at the moment)<br>Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more <br>information.<br>/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/: Input must be a directory.<br>(Symbolic links are not supported at the moment)<br>Try `/usr/share/koha/misc/translator/tmpl_process3.pl --help for more <br>information.<br><br>But then again - why was German (except said directory "de-DE") deleted <br>in the first place? Is this a bug or did I do something wrong?<br><br>Best wishes: Michael<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br><br>Am 12.07.21 um 20:38 schrieb Michael Kuhn:<br>> Hi<br>> <br>> We were on Debian GNU/Linux 9 with Koha 19.11.00, our configured <br>> language was german (de-DE). Today we updated first to Debian GNU/Linux <br>> 10, then to Koha 21.05.01. At the end of the update it said:<br>> <br>> Upgrade to 21.05.01.003 done [19:19:38]: Koha 21.05.01 release<br>> Error: the selected language is already installed. Try --update if you <br>> want to re-install it.<br>> ERROR: an error was found when updating 'de-DE' translations. Please <br>> manually<br>> run 'koha-translate --update de-DE'. Run man koha-translate for more <br>> options.<br>> <br>> Now our language German (de-DE) is gone, instead only English (en) is <br>> there. The Koha system preferences "language" und "OPACLanguages" just <br>> show "English" but these checkboxes are not even checked. German is not <br>> there anymore.<br>> <br>> I tried to run "koha-translate" with various options but it didn't help:<br>> <br>> # koha-translate --list<br>> de-DE<br>> # koha-translate --update de-DE<br>> Error: the selected language is already installed. Try --update if you <br>> want to re-install it.<br>> <br>> # koha-translate --remove de-DE<br>> # koha-translate --list<br>> de-DE<br>> <br>> # koha-translate --install de-DE<br>> Error: the selected language is already installed. Try --update if you <br>> want to re-install it.<br>> <br>> When trying to use option "--dev" the program tries to access a <br>> non-existing directory called "koha-tmpl".<br>> <br>> # koha-translate --list de-DE --dev ndz<br>> ls: cannot access '/usr/share/koha/koha-tmpl/opac-tmpl/bootstrap/': No <br>> such file or directory<br>> <br>> How can we regain the German language?<br>> <br>> Best wishes: Michael<br>> -- <br>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br><br><br><br><br>------------------------------<br><br>Message: 4<br>Date: Tue, 13 Jul 2021 08:36:32 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: koha <koha@lists.katipo.co.nz>, koha-devel<br> <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] Call for news - Newsletter July 2021<br>Message-ID: <04486943-6dbf-5295-6a5c-f2cbab10d2da@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi<br><br>I'm collecting news for the July 2021 Koha Community Newsletter. Please <br>send anything noteworthy to:<br><br>kohanews (at) gmail (dot) com<br><br>News criteria:<br>* News items can be of any length.<br>* Images are fine.<br>* Anything and everything Koha.<br>* Submit by the 26th of the month.<br><br>Text format criteria:<br>* Just structured plain text, or<br>* HTML text to include tables or similar<br><br>For events:<br>* Consider adding your event to the Koha Community calendar at <br>https://koha-community.org/calendar/<br><br>Thank you!<br><br>Michael Kuhn<br>Editor, Koha Community Newsletter<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 188, Issue 7<br>******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>