Attachment 158448 Details for Bug 34889 – Bug 34889: (follow-up) Revise database update following Bug 31383

[patch] Bug 34889: (follow-up) Revise database update following Bug 31383

Bug-34889-follow-up-Revise-database-update-followi.patch (text/plain), 2.78 KB, created by Katrin Fischer on 2023-11-05 11:01:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2023-11-05 11:01:25 UTC

Size: 2.78 KB

patch

obsolete

>From a898caa6c9a8a80d27444ad707d15a47ac6d1d4d Mon Sep 17 00:00:00 2001
>From: Owen Leonard <oleonard@myacpl.org>
>Date: Wed, 25 Oct 2023 14:53:25 +0000
>Subject: [PATCH] Bug 34889: (follow-up) Revise database update following Bug
> 31383
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> ...onalInstructions-to-additional-contents.pl | 20 ++++++++++++-------
> 1 file changed, 13 insertions(+), 7 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug-34889-move-PatronSelfRegistrationAdditionalInstructions-to-additional-contents.pl b/installer/data/mysql/atomicupdate/bug-34889-move-PatronSelfRegistrationAdditionalInstructions-to-additional-contents.pl
>index 442092df37..a85eff87b7 100755
>--- a/installer/data/mysql/atomicupdate/bug-34889-move-PatronSelfRegistrationAdditionalInstructions-to-additional-contents.pl
>+++ b/installer/data/mysql/atomicupdate/bug-34889-move-PatronSelfRegistrationAdditionalInstructions-to-additional-contents.pl
>@@ -16,13 +16,19 @@ return {
>         if ($patronselfregistrationadditionalinstructions) {
> 
>             # Insert any values found from system preference into additional_contents
>-            foreach my $lang ('default') {
>-                $dbh->do(
>-                    "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'PatronSelfRegistrationAdditionalInstructions', 'PatronSelfRegistrationAdditionalInstructions', NULL, ?, ?, ?, CAST(NOW() AS date) )",
>-                    undef,                                         "PatronSelfRegistrationAdditionalInstructions $lang",
>-                    $patronselfregistrationadditionalinstructions, $lang
>-                );
>-            }
>+            $dbh->do(
>+                "INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'PatronSelfRegistrationAdditionalInstructions', 'PatronSelfRegistrationAdditionalInstructions', NULL, CAST(NOW() AS date) )"
>+            );
>+
>+            my ($insert_id) = $dbh->selectrow_array(
>+                "SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'PatronSelfRegistrationAdditionalInstructions' AND location = 'PatronSelfRegistrationAdditionalInstructions' LIMIT 1",
>+                {}
>+            );
>+
>+            $dbh->do(
>+                "INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, 'PatronSelfRegistrationAdditionalInstructions default', ?, 'default' )",
>+                undef, $insert_id, $patronselfregistrationadditionalinstructions
>+            );
> 
>             # Remove old system preference
>             $dbh->do("DELETE FROM systempreferences WHERE variable='PatronSelfRegistrationAdditionalInstructions'");
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 34889: 156111 | 156136 | 156680 | 157563 | 157808 | 157809 | 157826 | 157827 | 157828 | 157910 | 157911 | 157912 | 158447 | 158448 | 158449