From 6182dc3b48167cd0d2c8ab1022bcbfc2ddaf7f86 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 23 Mar 2015 17:01:53 +0100 Subject: [PATCH] Bug 13380: 3.18.x Fix previous DB entry The DB entry from bug 13379 should have been executed before bug 13380. The AV category now contain truncated values. This patch restores the correct category values. The DB entry from bug 13379 should have been pushed before. Signed-off-by: Chris Cormack --- installer/data/mysql/updatedatabase.pl | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index f7e8dffb9b..04e40936b5 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9746,6 +9746,13 @@ if(CheckVersion($DBversion)) { } +$DBversion = "3.18.05.002"; +if(CheckVersion($DBversion)) { + $dbh->do(q{UPDATE authorised_values SET category='ORDER_CANCELLATION_REASON' WHERE category='ORDER_CANCELLATI'}); + print "Upgrade to $DBversion done (Bug 13380: Fix the authorised value categories if truncated with previous DB update (3.18.04.002))\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 2.39.5