From 230810cb9ea57fa332d26cbdab7bdf92c5c2fb51 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. --- installer/data/mysql/updatedatabase.pl | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 0523139..8218bab 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9731,6 +9731,16 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +# IMPORTANT +# Here should be DB entry from 13379 + +$DBversion = "3.18.05.001"; +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.1.0