From: ivan <ivan>
Date: Wed, 17 Apr 2002 20:43:45 +0000 (+0000)
Subject: fix usergroup_delete DELETE syntax
X-Git-Tag: freeside_1_4_0_pre12~54
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=6866bdda26d1feb152af991388113e2e9309fafb;ds=sidebyside

fix usergroup_delete DELETE syntax
---

diff --git a/FS/FS/part_export/sqlradius.pm b/FS/FS/part_export/sqlradius.pm
index fa2153f31..7337b5aa9 100644
--- a/FS/FS/part_export/sqlradius.pm
+++ b/FS/FS/part_export/sqlradius.pm
@@ -143,10 +143,10 @@ sub sqlradius_usergroup_delete { #subroutine, not method
   my( $username, @groups ) = @_;
 
   my $sth = $dbh->prepare( 
-    "DELETE FROM usergroup ( id, UserName, GroupName ) VALUES ( ?, ?, ? )"
+    "DELETE FROM usergroup WHERE UserName = ? AND GroupName = ?"
   ) or die $dbh->errstr;
   foreach my $group ( @groups ) {
-    $sth->execute( '', $username, $group )
+    $sth->execute( $username, $group )
       or die "can't delete from groupname table: ". $sth->errstr;
   }
   $dbh->disconnect;