Hello Vinod, You lost all the "metadata"/marcxml for the deleted bibliographic records. If you want to recover them you will have to use a backup and rerun the update database process. Before you do it, make sure you don't have several times the same biblionumber in the deletedbiblioitems table.
We could deal with that problem during the update process, you can report it on bugzilla. Regards, Jonathan Le sam. 4 juil. 2020 à 22:24, vinod mishra <mishrav...@gmail.com> a écrit : > > Hello > > While restoring Koha 16.11 from Mysql database to 20.05 Mariadb 10.03 > database found below warning during database schema upgrade. Please suggest > the possible problem or it can be ignored? > > Upgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an > authentication method) > DBD::mysql::db do failed: Cannot add or update a child row: a foreign key > constraint fails (`koha_library`.`deletedbiblio_metadata`, CONSTRAINT > `deletedbiblio_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES > `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for > Statement " > INSERT INTO deletedbiblio_metadata ( biblionumber, format, > marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml > FROM deletedbiblioitems; > "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ > updatedatabase.pl line 13816. > > With Regards, > > Vinod Kumar Mishra, > Assistant Librarian, > Biju Patnaik Central Library (BPCL), > NIT Rourkela, > Sundergadh-769008, > Odisha, > India. > Mob:91+9439420860 > ORCID ID: http://orcid.org/0000-0003-4666-7874 > > *"Spiritual relationship is far more precious than physical. Physical > relationship divorced from spiritual is body without soul" -- Mahatma > Gandhi* > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha