Hola, 

Hay que cambiar el formato de las tablas de la base de datos, se hace con consultas como esta:

ALTER TABLE `article_requests` ROW_FORMAT=DYNAMIC;
ALTER TABLE `biblioitems` ROW_FORMAT=DYNAMIC;
ALTER TABLE `borrower_modifications` ROW_FORMAT=DYNAMIC;
ALTER TABLE `borrowers` ROW_FORMAT=DYNAMIC;
ALTER TABLE `branches` ROW_FORMAT=DYNAMIC;
ALTER TABLE `deletedbiblioitems` ROW_FORMAT=DYNAMIC;
ALTER TABLE `deletedborrowers` ROW_FORMAT=DYNAMIC;
ALTER TABLE `deleteditems` ROW_FORMAT=DYNAMIC;
ALTER TABLE `items` ROW_FORMAT=DYNAMIC;
ALTER TABLE `z3950servers` ROW_FORMAT=DYNAMIC;

Seguramente se tiene que aplicar a todas las tablas de Koha pero el ejemplo te puede servir.

Haces eso y luego haces la actualización de la base.

El mar, 8 ago 2023 a las 6:23, Natalia Carolina BELMONTE (<carolina.belmonte@uner.edu.ar>) escribió:

Estimados.

Tenemos la versiòn 20.05 instalada en el siguiente ambiente:

1. Debian GNU/Linux 9.13 (n/a)
2. Mysql 5.5
3. Zebra 

Se actualizo primero el sistema operativo sin problema.
Se fue llevando a las versiones 20.11, 21.05 sin problemas
Cuando se quizo actualizar a la version 21.11 salio el siguiente error:

Upgrading database schema for escsec
Upgrade to 21.06.00.007 [13:21:24]: Bug 11879 - Add a new field to patron record: main contact method
ERROR - {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 at /usr/share/koha/lib/C4/Installer.pm line 743

Upgrading database schema for fbro
Upgrade to 21.06.00.007 [13:21:26]: Bug 11879 - Add a new field to patron record: main contact method
ERROR - {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 at /usr/share/koha/lib/C4/Installer.pm line 743

Upgrading database schema for fcad
Upgrade to 21.06.00.007 [13:21:28]: Bug 11879 - Add a new field to patron record: main contact method
ERROR - {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 at /usr/share/koha/lib/C4/Installer.pm line 743

Upgrading database schema for fcag
Upgrade to 21.06.00.007 [13:21:29]: Bug 11879 - Add a new field to patron record: main contact method

ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size f 

El error es por el mysql? 

Se tiene que instalar mariadb, levantar las bases ahi y luego intentar migrar?

Espero sus comentarios al respecto.

Saludos.

--
Koha-es mailing list
Koha-es@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-es

--

Saludos...

Carlos Ricardo Vargas Medina Director de Proyectos BibliOrión ricvargasmed@bibliorion.com 5543384601 https://bibliorion.com