[Koha] Update to Koha 23.11.04 fails

[Michael Kuhn]

Hi Aleisha

You wrote:

 > The sneaky thing about the installer is that when it fails on a
 > database update, it's often referring to the NEXT one, not the printed
 > one you can see.
 >
 > So I think that error is actually about Bug 34869:
 > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34869 you'll
 > see that database update is trying to select a column id from the
 > additional_contents table.
 >
 > Did a previous update adding the additional_contents table fail?
 >
 > Hope that gives you somewhere to start.

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.11 again. 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



> On 12/04/24 09:12, Michael Kuhn wrote:
>> 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