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

[Michael Kuhn]

Hi Ketan Kulkarni

You wrote:

 > There's a command to upgrade koha db schema. You need to run that
 > command.
 >
 > Following is an example. Here, 'library' is the name of the instance.
 > You will need to replace that with the name of your instance.
 > ===============================//
 >
 > Upgrade Database Schema
 > Database schema of old Koha should upgrade to new one. Apply following
 > commands in a terminal,
 >
 > sudo koha-upgrade-schema library
 >
 > Rebuild the Zebra Index.
 >
 > Apply following command in a terminal,
 >
 > sudo koha-rebuild-zebra -v -f library
 > ================================

I have already run these commands (upgrade and reindexing) - they both 
finished without an error. I do have a running Koha 23.11 instance and 
acn log in. But as written when I search for something and then click a 
single hit in the results list the error 500 appears...

Any other ideas?

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



> There's a command to upgrade koha db schema. You need to run that command.
> 
> Following is an example. Here, 'library' is the name of the instance. 
> You will need to replace that with the name of your instance.
> ===============================//
> 
> Upgrade Database Schema
> Database schema of old Koha should upgrade to new one. Apply following 
> commands in a terminal,
> 
> sudo koha-upgrade-schema library
> 
> Rebuild the Zebra Index.
> 
> Apply following command in a terminal,
> 
> sudo koha-rebuild-zebra -v -f library
> ================================
> 
> On Fri, 12 Apr 2024, 20:04 Michael Kuhn, <mik at adminkuhn.ch 
> <mailto:mik at adminkuhn.ch>> wrote:
> 
>     Hi Ketan Kulkarni
> 
>     Thanks for your answer! Youw rote:
> 
>       > Compare the database structure with the published schema of the
>       > version.
> 
>     How could I do that? There are hundreds of tables with many more
>     hundreds of fields.
> 
>     Is there a way how to extract the database structure from
>     https://schema.koha-community.org/23_11/
>     <https://schema.koha-community.org/23_11/> and also from a running
>     database?
> 
>       > My guess is that the db upgrade has not gone through cleanly.
> 
>     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
>     <mailto:mik at adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch>
> 
> 
> 
>      > On Fri, 12 Apr 2024, 17:42 Michael Kuhn, <mik at adminkuhn.ch
>     <mailto:mik at adminkuhn.ch>
>      > <mailto:mik at adminkuhn.ch <mailto:mik at adminkuhn.ch>>> wrote:
>      >
>      >     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
>     <https://schema.koha-community.org/23_11/tables/issues.html>
>      >     <https://schema.koha-community.org/23_11/tables/issues.html
>     <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
>     <https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152>
>      >   
>       <https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152 <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
>     <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275>
>      >   
>       <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275
>     <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
>     <mailto:mik at adminkuhn.ch>
>      >     <mailto:mik at adminkuhn.ch <mailto:mik at adminkuhn.ch>> · W
>     www.adminkuhn.ch <http://www.adminkuhn.ch> <http://www.adminkuhn.ch
>     <http://www.adminkuhn.ch>>
>      >     _______________________________________________
>      >
>      >     Koha mailing list http://koha-community.org
>     <http://koha-community.org> <http://koha-community.org
>     <http://koha-community.org>>
>      > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     <mailto:Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>>
>      >     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
>      >     <https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>>
>      >
> 
>