From ae5e2f0d1b041828593505cc8aa93aee53665975 Mon Sep 17 00:00:00 2001 From: "jocuri%softhome.net" <> Date: Tue, 14 Dec 2004 09:40:22 +0000 Subject: Patch for bug 244756: checksetup.pl shouldn't fail to remove product index from milestones table in upgrade from 2.14.x; patch by Max K-A , r=vladd, a=justdave. --- checksetup.pl | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/checksetup.pl b/checksetup.pl index 681d9bde3..35e7f2d39 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3443,6 +3443,15 @@ if (GetFieldDef("products", "product")) { } print "Fixing Indexes and Uniqueness.\n"; $dbh->do("ALTER TABLE milestones DROP INDEX product"); + + # mkanat@kerio.com - bug 244756 + # Silently drop the PRIMARY key if a buggy mysqldump has put it there. + # Don't print any error messages if the index isn't there. + my $originalprintwarn = $dbh->{'PrintWarn'}; + $dbh->{'PrintWarn'} = 0; + $dbh->do("ALTER TABLE milestones DROP INDEX PRIMARY"); + $dbh->{'PrintWarn'} = $originalprintwarn; + $dbh->do("ALTER TABLE milestones ADD UNIQUE (product_id, value)"); $dbh->do("ALTER TABLE bugs DROP INDEX product"); $dbh->do("ALTER TABLE bugs ADD INDEX (product_id)"); -- cgit v1.2.3-24-g4f1b