Bug 31037

Summary: 'borrower_attribute_types' table contains references to invalid category codes
Product: Koha Reporter: justanothermate
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P4 CC: gmcharlt, m.de.rooy
Version: 22.05   
Hardware: All   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 30449    
Bug Blocks:    
Attachments: webinterface and putty screenshot

Description justanothermate 2022-06-24 09:12:53 UTC
Created attachment 136483 [details]
webinterface and putty screenshot

While updating getting the error

Upgrade to 21.12.00.041 [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.