Bugzilla – Attachment 163160 Details for
Bug 35473
Core bookings and room reservations plugin tables clash
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35473: Also disable the plugin
Bug-35473-Also-disable-the-plugin.patch (text/plain), 2.53 KB, created by
Marcel de Rooy
on 2024-03-15 07:27:32 UTC
(
hide
)
Description:
Bug 35473: Also disable the plugin
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2024-03-15 07:27:32 UTC
Size:
2.53 KB
patch
obsolete
>From dfbbc26cf4845bf0aea801861f775491bb238db5 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Mon, 15 Jan 2024 15:33:40 +0000 >Subject: [PATCH] Bug 35473: Also disable the plugin >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/db_revs/230600061.pl | 21 ++++++++++----------- > 1 file changed, 10 insertions(+), 11 deletions(-) > >diff --git a/installer/data/mysql/db_revs/230600061.pl b/installer/data/mysql/db_revs/230600061.pl >index b32763dbce..3defd4a34d 100755 >--- a/installer/data/mysql/db_revs/230600061.pl >+++ b/installer/data/mysql/db_revs/230600061.pl >@@ -6,6 +6,7 @@ return { > up => sub { > my ($args) = @_; > my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ > # Handle cases of roombookings plugin existing > if ( TableExists('bookings') ) { > if ( column_exists( 'bookings', 'bookingid' ) ) { >@@ -37,21 +38,19 @@ return { > $old_roomequipment_table TO $roomequipment_table, > } > ); >+ $dbh->do("ALTER TABLE $rooms_table RENAME INDEX $old_rooms_index TO $rooms_index"); >+ $dbh->do("ALTER TABLE $bookings_table RENAME INDEX $old_bookings_index TO $bookings_index"); >+ $dbh->do("ALTER TABLE $equipment_table RENAME INDEX $old_equipment_index TO $equipment_index"); > $dbh->do( >-"ALTER TABLE $rooms_table RENAME INDEX $old_rooms_index TO $rooms_index" >- ); >- $dbh->do( >-"ALTER TABLE $bookings_table RENAME INDEX $old_bookings_index TO $bookings_index" >- ); >- $dbh->do( >-"ALTER TABLE $equipment_table RENAME INDEX $old_equipment_index TO $equipment_index" >- ); >- $dbh->do( >-"ALTER TABLE $roomequipment_table RENAME INDEX $old_roomequipment_index TO $roomequipment_index" >- ); >+ "ALTER TABLE $roomequipment_table RENAME INDEX $old_roomequipment_index TO $roomequipment_index"); > > say "Migrated room reservations plugin to it's own namespace"; > say "You MUST upgrade to the latest room reservation plugin to continue using it"; >+ $dbh->do( >+ "UPDATE plugin_data SET plugin_value = 0 WHERE plugin_class = 'Koha::Plugin::Com::MarywoodUniversity::RoomReservations' AND plugin_key = '__ENABLED__'" >+ ); >+ >+ say "Plugin disabled, please re-enable once you have upgraded it"; > } > } > >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 35473
:
160827
|
160879
|
161043
|
161742
|
161743
|
163159
| 163160