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 m...@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, <m...@adminkuhn.ch
<mailto:m...@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 m...@adminkuhn.ch
<mailto:m...@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch>
> On Fri, 12 Apr 2024, 17:42 Michael Kuhn, <m...@adminkuhn.ch
<mailto:m...@adminkuhn.ch>
> <mailto:m...@adminkuhn.ch <mailto:m...@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 m...@adminkuhn.ch
<mailto:m...@adminkuhn.ch>
> <mailto:m...@adminkuhn.ch <mailto:m...@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>>
> k...@lists.katipo.co.nz <mailto:k...@lists.katipo.co.nz>
<mailto:k...@lists.katipo.co.nz <mailto:k...@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>>
>
_______________________________________________
Koha-devel mailing list
Koha-devel@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/
