[Koha] Error 500 when searching in Koha 23.11.0

[Michael Kuhn]

Hi

I have updated our database from koha 21.11.10 to the current Koha 23.11.04.

When searching the catalogue I get a result list, but when clicking a 
single hit I get an error 500. In file "plack-error.log" I have found 
the following line which could be the reason:

DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st 
execute failed: Unknown column 'issue.renewals_count' in 'field list' at 
/usr/share/koha/lib/Koha/Objects.pm line 317

In fact there is no table "issue" in Koha 23.11, the correct name of 
this table is "issues" (see 
https://schema.koha-community.org/23_11/tables/issues.html).

I have searched in Bugzilla but couldn't find a respective bug. But I 
found the sequence "issue.renewals_count" in 
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152 so 
there may be some relation to 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275

Does anyone know how I can solve this problem with the 500 error?

Best wishes: Michael Kuhn
-- 
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch