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 <http://www.usm.cl/>* [image: imagen barra] <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
