[Koha] Schema upgrade issue 16.11 to 20.05

[Jonathan Druart]

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 at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha