From dac2f59798ada0a77717d4a6f455901c8bf1c10a Mon Sep 17 00:00:00 2001 From: "justdave%syndicomm.com" <> Date: Fri, 7 Sep 2001 08:32:13 +0000 Subject: refix for bug 91808: previous patch for this bug used an INNER JOIN construct in the SQL, which is not supported by the minimum version of MySQL that we require. Patch by Matthew Tuck r= justdave x2 --- sanitycheck.cgi | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sanitycheck.cgi') diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 72a2d3818..89861b4ed 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -399,8 +399,9 @@ if (@badbugs) { Status("Checking duplicates table"); SendSQL("SELECT bugs.bug_id " . - "FROM bugs INNER JOIN duplicates ON bugs.bug_id = duplicates.dupe " . + "FROM bugs, duplicates " . "WHERE bugs.resolution != 'DUPLICATE' " . + " AND bugs.bug_id = duplicates.dupe " . "ORDER BY bugs.bug_id"); @badbugs = (); -- cgit v1.2.3-24-g4f1b