[Koha] Failed update to Koha 24.05.00: Unknown column 'item_id' in 'bookings'

[Michael Kuhn]

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 mik at adminkuhn.ch · W www.adminkuhn.ch