From c898e476638ca897aea3ede37174c2096914c17f Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 25 Oct 2018 13:32:17 -0300 Subject: [PATCH] Bug 21656: Reduce the risk of possible side-effects Content-Type: text/plain; charset=utf-8 Signed-off-by: Jonathan Druart Signed-off-by: Martin Renvoize Signed-off-by: Marcel de Rooy --- installer/data/mysql/atomicupdate/bug_21656.perl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_21656.perl b/installer/data/mysql/atomicupdate/bug_21656.perl index 1b72856..40f1982 100644 --- a/installer/data/mysql/atomicupdate/bug_21656.perl +++ b/installer/data/mysql/atomicupdate/bug_21656.perl @@ -1,7 +1,8 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { $dbh->do(q{ - UPDATE letter SET content = REPLACE(content,"item.reason ne \'in-demand\'","item.reason != \'in-demand\'"); + UPDATE letter SET content = REPLACE(content,"item.reason ne \'in-demand\'","item.reason != \'in-demand\'") + WHERE code="SR_SLIP"; }); print "Upgrade to $DBversion done (Bug 21656 - Stock Rotation Notice, Template Toolkit Syntax Correction)\n"; SetVersion( $DBversion ); -- 2.1.4