[Koha] Schema upgrade issue 16.11 to 20.05

[vinod mishra]

Hello Jonathan

Thanks, Bug has been filed at
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26025

Seems if i need these deleted data in future then only needed else can be
ignored.

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*


On Mon, Jul 20, 2020 at 12:46 PM Jonathan Druart <
jonathan.druart at bugs.koha-community.org> wrote:

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