https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43502 Bug ID: 43502 Summary: Invalid foreign key warnings with upgrade to MySQL 8.4.10 Initiative type: --- Sponsorship --- status: Product: Koha Version: 25.11 Hardware: All OS: All Status: NEW Severity: performance Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: rschet@sandia.gov QA Contact: testopia@bugs.koha-community.org Target Milestone: --- Created attachment 205389 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=205389&action=edit Screenshot of 'About Koha' page in the Admin area of our deployment With the upgrade of MySQL to 8.5.10 for our external Koha database, we have encountered the following warnings regarding invalid foreign keys. Please advise on how to update the database to remove these warnings. Below is the list of warnings for our instance of the Koha database: koha.aqorders_ibfk_2 - invalid foreign key defined as 'aqorders(biblionumber)' references a non unique key at table 'biblio'. koha.article_requests_ibfk_2 - invalid foreign key defined as 'article_requests(biblionumber)' references a non unique key at table 'biblio'. koha.bibliocoverimage_fk1 - invalid foreign key defined as 'cover_images(biblionumber)' references a non unique key at table 'biblio'. koha.biblioitems_ibfk_1 - invalid foreign key defined as 'biblioitems(biblionumber)' references a non unique key at table 'biblio'. koha.bookings_ibfk_2 - invalid foreign key defined as 'bookings(biblio_id)' references a non unique key at table 'biblio'. koha.clubs_holds_ibfk_2 - invalid foreign key defined as 'club_holds(biblio_id)' references a non unique key at table 'biblio'. koha.deletedrecord_metadata_fk_1 - invalid foreign key defined as 'deletedbiblio_metadata(biblionumber)' references a non unique key at table 'deletedbiblio'. koha.erm_eholdings_titles_ibfk_2 - invalid foreign key defined as 'erm_eholdings_titles(biblio_id)' references a non unique key at table 'biblio'. koha.fk_course_items_biblionumber - invalid foreign key defined as 'course_items(biblionumber)' references a non unique key at table 'biblio'. koha.FK_import_oai_biblios_1 - invalid foreign key defined as 'import_oai_biblios(biblionumber)' references a non unique key at table 'biblio'. koha.hold_fill_targets_ibfk_2 - invalid foreign key defined as 'hold_fill_targets(biblionumber)' references a non unique key at table 'biblio'. koha.item_groups_ibfk_1 - invalid foreign key defined as 'item_groups(biblio_id)' references a non unique key at table 'biblio'. koha.items_ibfk_1 - invalid foreign key defined as 'items(biblioitemnumber)' references a non unique key at table 'biblioitems'. koha.items_ibfk_4 - invalid foreign key defined as 'items(biblionumber)' references a non unique key at table 'biblio'. koha.linktracker_biblio_ibfk - invalid foreign key defined as 'linktracker(biblionumber)' references a non unique key at table 'biblio'. koha.old_reserves_ibfk_2 - invalid foreign key defined as 'old_reserves(biblionumber)' references a non unique key at table 'biblio'. koha.ratings_ibfk_2 - invalid foreign key defined as 'ratings(biblionumber)' references a non unique key at table 'biblio'. koha.recalls_ibfk_2 - invalid foreign key defined as 'recalls(biblio_id)' references a non unique key at table 'biblio'. koha.record_metadata_fk_1 - invalid foreign key defined as 'biblio_metadata(biblionumber)' references a non unique key at table 'biblio'. koha.reserves_ibfk_2 - invalid foreign key defined as 'reserves(biblionumber)' references a non unique key at table 'biblio'. koha.reviews_ibfk_2 - invalid foreign key defined as 'reviews(biblionumber)' references a non unique key at table 'biblio'. koha.serial_ibfk_1 - invalid foreign key defined as 'serial(biblionumber)' references a non unique key at table 'biblio'. koha.shelfcontents_ibfk_2 - invalid foreign key defined as 'virtualshelfcontents(biblionumber)' references a non unique key at table 'biblio'. koha.subscription_history_ibfk_1 - invalid foreign key defined as 'subscriptionhistory(biblionumber)' references a non unique key at table 'biblio'. koha.subscription_ibfk_3 - invalid foreign key defined as 'subscription(biblionumber)' references a non unique key at table 'biblio'. koha.suggestions_ibfk_biblionumber - invalid foreign key defined as 'suggestions(biblionumber)' references a non unique key at table 'biblio'. koha.tags_biblionumber_fk_1 - invalid foreign key defined as 'tags_all(biblionumber)' references a non unique key at table 'biblio'. koha.tags_index_biblionumber_fk_1 - invalid foreign key defined as 'tags_index(biblionumber)' references a non unique key at table 'biblio'. koha.tickets_ibfk_3 - invalid foreign key defined as 'tickets(biblio_id)' references a non unique key at table 'biblio'. koha.tmp_holdsqueue_ibfk_2 - invalid foreign key defined as 'tmp_holdsqueue(biblionumber)' references a non unique key at table 'biblio'. koha_dev.aqorders_ibfk_2 - invalid foreign key defined as 'aqorders(biblionumber)' references a non unique key at table 'biblio'. koha_dev.article_requests_ibfk_2 - invalid foreign key defined as 'article_requests(biblionumber)' references a non unique key at table 'biblio'. koha_dev.bibliocoverimage_fk1 - invalid foreign key defined as 'cover_images(biblionumber)' references a non unique key at table 'biblio'. koha_dev.biblioitems_ibfk_1 - invalid foreign key defined as 'biblioitems(biblionumber)' references a non unique key at table 'biblio'. koha_dev.bookings_ibfk_2 - invalid foreign key defined as 'bookings(biblio_id)' references a non unique key at table 'biblio'. koha_dev.clubs_holds_ibfk_2 - invalid foreign key defined as 'club_holds(biblio_id)' references a non unique key at table 'biblio'. koha_dev.deletedrecord_metadata_fk_1 - invalid foreign key defined as 'deletedbiblio_metadata(biblionumber)' references a non unique key at table 'deletedbiblio'. koha_dev.erm_eholdings_titles_ibfk_2 - invalid foreign key defined as 'erm_eholdings_titles(biblio_id)' references a non unique key at table 'biblio'. koha_dev.fk_course_items_biblionumber - invalid foreign key defined as 'course_items(biblionumber)' references a non unique key at table 'biblio'. koha_dev.FK_import_oai_biblios_1 - invalid foreign key defined as 'import_oai_biblios(biblionumber)' references a non unique key at table 'biblio'. koha_dev.hold_fill_targets_ibfk_2 - invalid foreign key defined as 'hold_fill_targets(biblionumber)' references a non unique key at table 'biblio'. koha_dev.item_groups_ibfk_1 - invalid foreign key defined as 'item_groups(biblio_id)' references a non unique key at table 'biblio'. koha_dev.items_ibfk_1 - invalid foreign key defined as 'items(biblioitemnumber)' references a non unique key at table 'biblioitems'. koha_dev.items_ibfk_4 - invalid foreign key defined as 'items(biblionumber)' references a non unique key at table 'biblio'. koha_dev.linktracker_biblio_ibfk - invalid foreign key defined as 'linktracker(biblionumber)' references a non unique key at table 'biblio'. koha_dev.old_reserves_ibfk_2 - invalid foreign key defined as 'old_reserves(biblionumber)' references a non unique key at table 'biblio'. koha_dev.ratings_ibfk_2 - invalid foreign key defined as 'ratings(biblionumber)' references a non unique key at table 'biblio'. koha_dev.recalls_ibfk_2 - invalid foreign key defined as 'recalls(biblio_id)' references a non unique key at table 'biblio'. koha_dev.record_metadata_fk_1 - invalid foreign key defined as 'biblio_metadata(biblionumber)' references a non unique key at table 'biblio'. koha_dev.reserves_ibfk_2 - invalid foreign key defined as 'reserves(biblionumber)' references a non unique key at table 'biblio'. koha_dev.reviews_ibfk_2 - invalid foreign key defined as 'reviews(biblionumber)' references a non unique key at table 'biblio'. koha_dev.serial_ibfk_1 - invalid foreign key defined as 'serial(biblionumber)' references a non unique key at table 'biblio'. koha_dev.shelfcontents_ibfk_2 - invalid foreign key defined as 'virtualshelfcontents(biblionumber)' references a non unique key at table 'biblio'. koha_dev.subscription_history_ibfk_1 - invalid foreign key defined as 'subscriptionhistory(biblionumber)' references a non unique key at table 'biblio'. koha_dev.subscription_ibfk_3 - invalid foreign key defined as 'subscription(biblionumber)' references a non unique key at table 'biblio'. koha_dev.suggestions_ibfk_biblionumber - invalid foreign key defined as 'suggestions(biblionumber)' references a non unique key at table 'biblio'. koha_dev.tags_biblionumber_fk_1 - invalid foreign key defined as 'tags_all(biblionumber)' references a non unique key at table 'biblio'. koha_dev.tags_index_biblionumber_fk_1 - invalid foreign key defined as 'tags_index(biblionumber)' references a non unique key at table 'biblio'. koha_dev.tickets_ibfk_3 - invalid foreign key defined as 'tickets(biblio_id)' references a non unique key at table 'biblio'. koha_dev.tmp_holdsqueue_ibfk_2 - invalid foreign key defined as 'tmp_holdsqueue(biblionumber)' references a non unique key at table 'biblio'. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.