[Koha] Update to Koha 23.11.04 fails

[Aleisha Amohia]

Hi Michael

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.

Aleisha

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
-- 
*Aleisha Amohia (she/her)*
Technical Lead | Rōpū kohinga
*Catalyst.Net Limited - Expert Open Source Solutions*

*Catalyst.Net Ltd - a Catalyst IT group company*
Tel: +64 4 803 2259 or +61 3 9116 2642 | www.catalyst.net.nz 
<http://www.catalyst.net.nz>

Follow Catalyst Koha on Twitter <https://twitter.com/catalystkoha> | 
Subscribe to the Catalyst Koha newsletter 
<https://catalyst.us4.list-manage.com/subscribe?u=62457ff5060d15ee3c07d3fc4&id=b73fbdcac8>

Catalyst Logo

CONFIDENTIALITY NOTICE: This email is intended for the named recipients 
only. It may contain privileged, confidential or copyright information. 
If you are not the named recipient, any use, reliance upon, disclosure 
or copying of this email or its attachments is unauthorised. If you have 
received this email in error, please reply via email or call +64 4 499 2267.