Estimados:

Tengo debian 9 como SO y le pase una BD de un Koha 19.11 a un servidor con Koha 20.11

Y me salieron estos errores

[Thu Jul 1 23:40:53 2021] updatedatabase.pl: Warning - Cannot remove column items.paidfor. At least one value exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 22841.
[Thu Jul 1 23:40:59 2021] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'message_transport_type_fk'; check that column/key exists [for Statement "
[Thu Jul 1 23:40:59 2021] updatedatabase.pl: ALTER TABLE letter DROP FOREIGN KEY message_transport_type_fk
[Thu Jul 1 23:40:59 2021] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23190.

busque y me di cuenta que la columna de items "paidfor" tenia solo 2 registros asi q los volví null

y a la tabla le hice message_transport un truncate para que estuviera vacía.

Hecho esto volví a cargar la BD, pero ahora me salieron más errores, ¿procedo de manera similar?

El sistema parece funcionar bien, pero no lo he revisado en detalle.

Gracias

[Mon Jul 5 22:00:26 2021] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'title'; check that column/key exists [for Statement "DROP INDEX title ON import_biblios"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23161.
[Mon Jul 5 22:00:27 2021] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'isbn'; check that column/key exists [for Statement "DROP INDEX isbn ON import_biblios"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23162.
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'title' [for Statement "CREATE INDEX title ON import_biblios (title(191));"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23167.
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'isbn' [for Statement "CREATE INDEX isbn ON import_biblios (isbn(191));"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23168.
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'desk_id' [for Statement "
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: ALTER TABLE reserves ADD COLUMN desk_id INT(11) DEFAULT NULL AFTER branchcode,
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: ADD KEY desk_id (`desk_id`),
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: ADD CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE ;
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23245.
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'desk_id' [for Statement "
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: ALTER TABLE old_reserves ADD COLUMN desk_id INT(11) DEFAULT NULL AFTER branchcode,
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: ADD KEY `old_desk_id` (`desk_id`);
[Mon Jul 5 22:00:29 2021] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23250.
[Mon Jul 5 22:01:12 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'profile_id' [for Statement "
[Mon Jul 5 22:01:12 2021] updatedatabase.pl: ALTER TABLE import_batches ADD COLUMN `profile_id` int(11) default NULL AFTER comments
[Mon Jul 5 22:01:12 2021] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23381.
[Mon Jul 5 22:01:12 2021] updatedatabase.pl: DBD::mysql::db do failed: Can't create table `koha_koha2020_05`.`#sql-54a_15` (errno: 121 "Duplicate key on write or update") [for Statement "
[Mon Jul 5 22:01:12 2021] updatedatabase.pl: ALTER TABLE import_batches ADD CONSTRAINT `import_batches_ibfk_1` FOREIGN KEY (`profile_id`) REFERENCES `import_batch_profiles` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
[Mon Jul 5 22:01:12 2021] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23385.
[Mon Jul 5 22:01:13 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'unseen_renewals' [for Statement " ALTER TABLE issues ADD unseen_renewals TINYINT(4) DEFAULT 0 NOT NULL AFTER renewals "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23410.
[Mon Jul 5 22:01:34 2021] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'unseen_renewals' [for Statement " ALTER TABLE old_issues ADD unseen_renewals TINYINT(4) DEFAULT 0 NOT NULL AFTER renewals "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 23413.

Jorge Spuler
Ingeniero en Automatización y Procesos
Dirección de Información y Documentación Bibliográfica Institucional,
Edificio Edificio U/Piso2 Anexo: 56 32 2654514
Universidad Técnica Federico Santa María - Casa Central - www.usm.cl