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
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.
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@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
participants (2)
-
Aleisha Amohia -
Michael Kuhn