https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33982
Oleg Vasylenko <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from Oleg Vasylenko <[email protected]> --- Our library had same problem after upgrading to Koha 23.05. Thank you for pointing the reason for such a problem. -- Diagnosing the problem -- Run SQL queries: SELECT holdingbranch, count(*) FROM items GROUP BY holdingbranch; SELECT homebranch, count(*) FROM items GROUP BY homebranch; — there should be no NULL records -- Solving the problem -- If you have just one library it is easy to solve the problem with the following SQL queries (change LIBCODE with your library code): UPDATE items SET homebranch = "LIBCODE" WHERE homebranch IS NULL; UPDATE items SET holdingbranch = "LIBCODE" WHERE holdingbranch IS NULL; -- Securing from future problems -- Edit MARC frameworks and make subfields with Koha connection items.homebranch, items.holdingbranch, items.itype mandatory. Subfields for MARC21 are provided above. For UNIMARC these are probably 995$b, 995$c, 995$r (at least in our case) Similar queries could be added to Koha health check to show possible problems in DB -- 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] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
