[Koha-devel] Update to Koha 23.11.04 fails

[David Cook]

Hi Michael,

I've noticed that a bunch of the database changes for the additional_contents table can half-complete and not fatally fail in very ungraceful ways. 

In this case, I'd say an earlier update probably failed to rename "idnew" to "id".

Hopefully this was a test upgrade, because otherwise you're going to have pain trying to fix it...

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: Friday, 12 April 2024 7:14 AM
To: Koha-devel <koha-devel at lists.koha-community.org>
Subject: [Koha-devel] Update to Koha 23.11.04 fails

Hi

Today I tried to update a Koha 21.11.10 database to Koha 23.11.04 but the update process failed at the following point:

Upgrade to 23.06.00.068  [22:55:59]: Bug 23798 - Convert OpacMaintenanceNotice system preference to additional contents ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db selectrow_array failed: 
Unknown column 'id' in 'field list' at
/usr/share/koha/lib/C4/Installer.pm line 741

I couldn't find anything regarding this error in Bugzilla, but maybe it is related to
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23798#c12
which shows a similar error regarding an "Unknown column 'title'".

How should I proceed?

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/