Hi
Just for the record: I updated from Koha 21.11.10 to 23.11.04.
When searching the catalogue I got a result list, but when clicking a
single hit I got an error 500. In file "plack-error.log" I found this:
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 Koha 21.11 this column was called "issues.renewals" and in Koha 23.11
it should be called "issues.renewals_count" - but for whatever reason
the upgrade did not rename it properly. I have done that myself:
ALTER TABLE issues RENAME COLUMN renewals TO renewals_count;
Now single hits show up.
PS1: The error message says the column is "issue.renewals_count" but
actually it is "issues.renewals_count".
PS2: https://schema.koha-community.org/23_11/tables/issues.html says the
type of this column is tinyint(3) while it actually is tinyint(4).
Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
