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