Error 500 when searching in Koha 23.11.0
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@adminkuhn.ch · W www.adminkuhn.ch
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 mik@adminkuhn.ch · W www.adminkuhn.ch
participants (1)
-
Michael Kuhn