Hi
I just tried to update my Koha demo installation from 23.11.00 to
24.05.00 but the process failed with the following message:
Upgrade to 23.12.00.044 [13:48:09]: Bug 36120 - Add pickup location
to bookings
ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Unknown
column 'item_id' in 'bookings' at /usr/share/koha/lib/C4/Installer.pm
line 741
How can this problem be solved?
In Koha 23.11 the new table "bookings" looks as follows:
MariaDB [koha_koha]> describe bookings;
+----------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------+------+-----+---------+----------------+
| bookingid | int(11) | NO | PRI | NULL | auto_increment |
| borrowernumber | int(11) | NO | MUL | NULL | |
| roomid | int(11) | NO | MUL | NULL | |
| start | datetime | NO | | NULL | |
| end | datetime | NO | | NULL | |
| blackedout | tinyint(1) | NO | | 0 | |
+----------------+------------+------+-----+---------+----------------+
But https://schema.koha-community.org/23_11/tables/bookings.html shows a
quite different configuration using some different column names.
There ist no
https://schema.koha-community.org/24_05/tables/bookings.html yet.
For now I have rolled back the snapshot I have taken before trying the
update.
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
