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 <mishravk79@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