[Koha] Schema upgrade issue 16.11 to 20.05

vinod mishra mishravk79 at gmail.com
Sun Jul 5 08:24:02 NZST 2020


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*


More information about the Koha mailing list