Bugzilla – Attachment 174725 Details for
Bug 38436
Adjust code for column visibility (after DataTables upgrade)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 38436: Rename columns_settings.columnname in DB
Bug-38436-Rename-columnssettingscolumnname-in-DB.patch (text/plain), 1.33 KB, created by
Owen Leonard
on 2024-11-18 15:40:58 UTC
(
hide
)
Description:
Bug 38436: Rename columns_settings.columnname in DB
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2024-11-18 15:40:58 UTC
Size:
1.33 KB
patch
obsolete
>From 37dd625d84b40934d3d5e71c1bfb49107fbc167b Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 15 Nov 2024 15:28:08 +0100 >Subject: [PATCH] Bug 38436: Rename columns_settings.columnname in DB > >Signed-off-by: Owen Leonard <oleonard@myacpl.org> >--- > installer/data/mysql/atomicupdate/bug_38436.pl | 18 ++++++++++++++++++ > 1 file changed, 18 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_38436.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_38436.pl b/installer/data/mysql/atomicupdate/bug_38436.pl >new file mode 100755 >index 0000000000..428bf53fa9 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_38436.pl >@@ -0,0 +1,18 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "38436", >+ description => "Adjust column names for holdings tables", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ say $dbh->do(q{ >+ UPDATE columns_settings >+ SET columnname = REGEXP_REPLACE(columnname, '.*holdings_', '') >+ WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table") >+ }); >+ say_success( $out, "Column names renamed" ); >+ }, >+}; >-- >2.39.5
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 38436
:
174587
|
174588
|
174589
|
174590
|
174591
|
174592
|
174593
|
174594
|
174595
|
174634
|
174641
|
174642
|
174688
|
174689
|
174690
|
174691
|
174692
|
174693
|
174694
|
174695
|
174696
|
174697
|
174698
|
174699
|
174700
|
174701
|
174702
|
174721
|
174722
|
174723
|
174724
|
174725
|
174726
|
174727
|
174728
|
174729
|
174730
|
174731
|
174732
|
174733
|
174734
|
174735
|
174736
|
174740
|
174741
|
174742
|
174743
|
174744
|
174745
|
174746
|
174747
|
174748
|
174749
|
174750
|
174751
|
174752
|
174753
|
174754
|
174755
|
174756
|
174766
|
174767
|
174768
|
174769
|
174770
|
174771
|
174772
|
174773
|
174774
|
174775
|
174776
|
174777
|
174778
|
174779
|
174780
|
174781
|
174782
|
174821
|
174967