From 17a51b0772e8c6ccd43e46cb78a84122c6364d5f Mon Sep 17 00:00:00 2001 From: =?utf8?q?Fr=C3=A9d=C3=A9ric=20Buclin?= Date: Mon, 19 Dec 2011 19:54:21 +0100 Subject: [PATCH] Bug 711925: Update from 4.0 or older to 4.2 or trunk fails when bug_see_also field is populated r=wicked a=LpSolit --- Bugzilla/DB/Schema.pm | 2 +- Bugzilla/Install/DB.pm | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index adbbf7b38d..7b7e4ffb61 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -502,7 +502,7 @@ use constant ABSTRACT_SCHEMA => { COLUMN => 'bug_id', DELETE => 'CASCADE'}}, value => {TYPE => 'varchar(255)', NOTNULL => 1}, - class => {TYPE => 'varchar(255)', NOTNULL => 1}, + class => {TYPE => 'varchar(255)', NOTNULL => 1, DEFAULT => "''"}, ], INDEXES => [ bug_see_also_bug_id_idx => {FIELDS => [qw(bug_id value)], diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index dff3c6d2e9..b98b880770 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -3568,7 +3568,7 @@ sub _populate_bug_see_also_class { } $dbh->bz_add_column('bug_see_also', 'class', - {TYPE => 'varchar(255)', NOTNULL => 1}, ''); + {TYPE => 'varchar(255)', NOTNULL => 1, DEFAULT => "''"}, ''); my $result = $dbh->selectall_arrayref( "SELECT id, value FROM bug_see_also"); -- 2.47.2