Bug 31037 - 'borrower_attribute_types' table contains references to invalid category codes
Summary: 'borrower_attribute_types' table contains references to invalid category codes
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: 22.05
Hardware: All Linux
: P4 normal with 10 votes (vote)
Assignee: Bugs List
QA Contact: Testopia
Depends on: 30449
  Show dependency treegraph
Reported: 2022-06-24 09:12 UTC by justanothermate
Modified: 2023-06-08 22:26 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:

webinterface and putty screenshot (96.69 KB, image/png)
2022-06-24 09:12 UTC, justanothermate

Note You need to log in before you can comment on or make changes to this bug.
Description justanothermate 2022-06-24 09:12:53 UTC
Created attachment 136483 [details]
webinterface and putty screenshot

While updating getting the error

Upgrade to [17:46:08]: Bug 30449 - Check borrower_attribute_types FK constraint
ERROR: {UNKNOWN}: The 'borrower_attribute_types' table contains references to invalid category codes: at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/211200041.pl line 40. at /usr/share/koha/lib/C4/Installer.pm line 739

result from borrower_attribute_types; see in the attachments

no other patron attributes present besides show_bcode
Comment 1 justanothermate 2022-06-28 08:05:22 UTC
assigned a value to show_bcode category code (previously empty)
upgrade worked after that. resolved for me so far.