Bug 107718 pt 2 - use subtraction instead of the ~ operator, which older

mysql versions don't support. Remove the checksetup.pl restriction, too.

r=jake x2

1 files changed, 5 insertions, 2 deletions

diff --git a/process_bug.cgi b/process_bug.cgi
index 7f3d32098..9e90827f1 100755
--- a/process_bug.cgi
+++ b/process_bug.cgi
@@ -43,7 +43,8 @@ use vars %::versions,
     %::legal_platform,
     %::legal_priority,
     %::target_milestone,
-    %::legal_severity;
+    %::legal_severity,
+    %::superusergroupset;
 
 my $whoid = confirm_login();
 
@@ -563,7 +564,9 @@ if($::usergroupset ne '0') {
     }
     if ($groupAdd ne "0" || $groupDel ne "0") {
         DoComma();
-        $::query .= "groupset = ((groupset & ~($groupDel)) | ($groupAdd))";
+        # mysql < 3.23.5 doesn't support the ~ operator, even though
+        # the docs say that it does
+        $::query .= "groupset = ((groupset & ($::superusergroupset - ($groupDel))) | ($groupAdd))";
     }
 }