Genial. Muchas gracias. El mar, 8 de ago. de 2023 11:06, Ricardo Vargas <ricvargasmed@gmail.com> escribió:
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 <https://www.hubspot.es/email-signature-generator>