Failed update to Koha 24.05.00: Unknown column 'item_id' in 'bookings'
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@adminkuhn.ch · W www.adminkuhn.ch
Hi, Strange I see bookings.item_id in 23.11.00 sources both DBRev : /installer/data/mysql/db_revs/230600061.pl kohastructure.sql Le 30/05/2024 à 14:09, Michael Kuhn via Koha-devel a écrit :
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
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
Hi Fridolin I saw that in the past probably someone installed the https://github.com/ldjamison/koha-plugin-room-reservations which includes a table named "bookings" and the plugin installer seems to have dropped the original table "bookings" from Koha 23.11 and then created a new one. I don't know how it happened but of course such plugin behaviour is absolutely unwanted. 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 Am 30.05.24 um 14:47 schrieb Fridolin SOMERS via Koha-devel:
Hi,
Strange I see bookings.item_id in 23.11.00 sources both DBRev : /installer/data/mysql/db_revs/230600061.pl kohastructure.sql
Le 30/05/2024 à 14:09, Michael Kuhn via Koha-devel a écrit :
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
participants (2)
-
Fridolin SOMERS -
Michael Kuhn