[Koha-bugs] [Bug 33982] Error 500 on OPAC on recently edited records

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33982

Oleg Vasylenko <synapse.ova at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |synapse.ova at gmail.com

--- Comment #6 from Oleg Vasylenko <synapse.ova at gmail.com> ---
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.