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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
