From 94c2df0e830ea7070436f8ade182645893ac3373 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Fri, 25 Feb 2005 11:16:47 +0000 Subject: Bug 279910: Query crashed with Software Error: "Unknown column 'bugs.assignee_accessible' " Patch By Frederic Buclin r=myk, a=myk --- checksetup.pl | 25 +++++++++++++++++++------ 1 file changed, 19 insertions(+), 6 deletions(-) (limited to 'checksetup.pl') diff --git a/checksetup.pl b/checksetup.pl index 36c11c5dd..b42907495 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3353,14 +3353,12 @@ if (GetFieldDef('bugs_activity', 'oldvalue')) { # http://bugzilla.mozilla.org/show_bug.cgi?id=90933 ChangeFieldType("profiles", "disabledtext", "mediumtext not null"); -# 2001-07-26 myk@mozilla.org bug39816: -# Add fields to the bugs table that record whether or not the reporter, -# assignee, QA contact, and users on the cc: list can see bugs even when +# 2001-07-26 myk@mozilla.org bug 39816 (original) +# 2002-02-06 bbaetz@student.usyd.edu.au bug 97471 (revision) +# Add fields to the bugs table that record whether or not the reporter +# and users on the cc: list can see bugs even when # they are not members of groups to which the bugs are restricted. -# 2002-02-06 bbaetz@student.usyd.edu.au - assignee/qa can always see the bug AddField("bugs", "reporter_accessible", "tinyint not null default 1"); -#AddField("bugs", "assignee_accessible", "tinyint not null default 1"); -#AddField("bugs", "qacontact_accessible", "tinyint not null default 1"); AddField("bugs", "cclist_accessible", "tinyint not null default 1"); # 2001-08-21 myk@mozilla.org bug84338: @@ -4343,6 +4341,21 @@ if (!GetFieldDef('quips', 'userid')->[2]) { $dbh->do('UPDATE quips SET userid = NULL WHERE userid = 0'); } +# 2005-02-21 - LpSolit@gmail.com - Bug 279910 +# qacontact_accessible and assignee_accessible field names no longer exist +# in the 'bugs' table. Their corresponding entries in the 'bugs_activity' +# table should therefore be marked as obsolete, meaning that they cannot +# be used anymore when querying the database - they are not deleted in +# order to keep track of these fields in the activity table. +if (!GetFieldDef('fielddefs', 'obsolete')) { + AddField('fielddefs', 'obsolete', 'tinyint not null default 0'); + print "Marking qacontact_accessible and assignee_accessible as obsolete fields...\n"; + $dbh->do("UPDATE fielddefs SET obsolete = 1 + WHERE name = 'qacontact_accessible' + OR name = 'assignee_accessible'"); +} + + # If you had to change the --TABLE-- definition in any way, then add your # differential change code *** A B O V E *** this comment. # -- cgit v1.2.3-24-g4f1b