Bugzilla – Attachment 158667 Details for
Bug 23798
Convert OpacMaintenanceNotice system preference to additional contents
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23798: (follow-up) Revise database update following Bug 31383
Bug-23798-follow-up-Revise-database-update-followi.patch (text/plain), 2.06 KB, created by
Owen Leonard
on 2023-11-08 16:59:05 UTC
(
hide
)
Description:
Bug 23798: (follow-up) Revise database update following Bug 31383
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2023-11-08 16:59:05 UTC
Size:
2.06 KB
patch
obsolete
>From a16a0dc78167159bb0ab43b472aa0e2caebfbdba Mon Sep 17 00:00:00 2001 >From: Owen Leonard <oleonard@myacpl.org> >Date: Wed, 8 Nov 2023 16:56:09 +0000 >Subject: [PATCH] Bug 23798: (follow-up) Revise database update following Bug > 31383 > >--- > ...-OpacMaintenanceNotice-to-additional-contents.pl | 13 +++++++++++-- > 1 file changed, 11 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug-23798-move-OpacMaintenanceNotice-to-additional-contents.pl b/installer/data/mysql/atomicupdate/bug-23798-move-OpacMaintenanceNotice-to-additional-contents.pl >index 3b3a151f0f..d964eba681 100755 >--- a/installer/data/mysql/atomicupdate/bug-23798-move-OpacMaintenanceNotice-to-additional-contents.pl >+++ b/installer/data/mysql/atomicupdate/bug-23798-move-OpacMaintenanceNotice-to-additional-contents.pl >@@ -17,8 +17,17 @@ return { > > # Insert any values found from system preference into additional_contents > $dbh->do( >- "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'OpacMaintenanceNotice', 'OpacMaintenanceNotice', NULL, 'OpacMaintenanceNotice default', ?, 'default', CAST(NOW() AS date) )", >- undef, $opacmaintenancenotice >+ "INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'OpacMaintenanceNotice', 'OpacMaintenanceNotice', NULL, CAST(NOW() AS date) )" >+ ); >+ >+ my ($insert_id) = $dbh->selectrow_array( >+ "SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'OpacMaintenanceNotice' AND location = 'OpacMaintenanceNotice' LIMIT 1", >+ {} >+ ); >+ >+ $dbh->do( >+ "INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, 'OpacMaintenanceNotice default', ?, 'default' )", >+ undef, $insert_id, $opacmaintenancenotice > ); > > # Remove old system preference >-- >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 23798
:
157205
|
157472
|
157584
|
157822
|
157905
|
157906
|
158308
|
158309
| 158667 |
158669