[Koha-devel] Update to Koha 23.11.04 fails

[Michael Kuhn]

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 at adminkuhn.ch · W www.adminkuhn.ch



> -----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/
>