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
