Hi David You wrote:
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...
Thanks for the hint! As I saw in table "additional_contents" there was a column "idnew" in Koha 21.11 and Koha 23.05 - but this was renamed to "id" in Koha 23.11. So, no earlier update failed, seemingly just the update from Koha 23.05 to 23.11. However, in my Koha 21.11 dump I just changed to name of the column "idnew" to "id" (also for the primary key), then loaded the dump into MariaDB und retried the upgrade to Koha 23.1. This time it worked and showed the following output: Upgrade to 23.06.00.068 [09:42:00]: Bug 23798 - Convert OpacMaintenanceNotice system preference to additional contents Added 'OpacMaintenanceNotice' HTML customization Removed system preference 'OpacMaintenanceNotice' 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
-----Original Message----- From: Koha-devel <koha-devel-bounces@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@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@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________ 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/