[Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

[David Cook]

Hi Michael,

I don't think your database was properly upgraded, and doing these manual corrections isn't really going to be enough unless you go line by line through the upgrade scripts and figure out all the things that were missed.

If you're able to, I would go back and try the upgrade again. If you can't... then I would carefully look through every database revision. 

You might also want to consider looking at ./misc/maintenance/audit_database.pl as that could save you time. (Just don't blindly run the suggestions made by the script. They're just hints.)

David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia

Office: 02 9212 0899
Online: 02 8005 0595

-----Original Message-----
From: Koha-devel <koha-devel-bounces at lists.koha-community.org> On Behalf Of Michael Kuhn via Koha-devel
Sent: Saturday, 13 April 2024 9:28 AM
To: koha at lists.katipo.co.nz; Koha-devel <koha-devel at lists.koha-community.org>
Subject: Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

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 at adminkuhn.ch · W www.adminkuhn.ch

_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/