From a7bda731f349bdb22893442e32c9576aadc4305c 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 Signed-off-by: Jonathan Druart --- 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 1b7285625f..40f1982545 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.11.0