From 2d14b97eaf0f54ea05f75658745fc92a4925ce2e Mon Sep 17 00:00:00 2001 From: David Cook Date: Fri, 9 May 2025 02:34:19 +0000 Subject: [PATCH] Bug 38330: (QA follow-up) Fix WHERE clause in SQL update and re-word warning MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: David Cook Signed-off-by: Tomás Cohen Arazi --- installer/data/mysql/atomicupdate/bug_38330.pl | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_38330.pl b/installer/data/mysql/atomicupdate/bug_38330.pl index b751fb453e..b004c92312 100755 --- a/installer/data/mysql/atomicupdate/bug_38330.pl +++ b/installer/data/mysql/atomicupdate/bug_38330.pl @@ -27,7 +27,7 @@ return { WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 ELSE 0 END - WHERE m.metadata LIKE '%%'; + WHERE m.metadata LIKE '%%'; + WHERE m.metadata LIKE '% biblio.opac_suppressed mapping for all MARC frameworks"; - say_warning( $out, "You need to run the `maintenance/touch_all_biblios.pl` script" ); + say_warning( + $out, + "The biblio.opac_suppressed column should be updated, but you can run the `maintenance/touch_all_biblios.pl` script to be certain" + ); }, }; -- 2.51.0