Re: [Koha] Update to Koha 23.11.04 fails
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 m...@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
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Update to Koha 23.11.04 fails
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
Follow Catalyst Koha on Twitter |
Subscribe to the Catalyst Koha newsletter
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.
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] 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 m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
