[LON-CAPA-cvs] cvs: loncom /metadata_database/LONCAPA lonmetadata.pm

[raeburn]

raeburn		Fri Dec  7 17:31:09 2007 EDT

  Modified files:              
    /loncom/metadata_database/LONCAPA	lonmetadata.pm 
  Log:
  Fix bug 5457
  - make delete actions in the MySQL allusers table case sensitive, so changes to a user with username userX do not eliminate the record for user with username userx.
  
  
Index: loncom/metadata_database/LONCAPA/lonmetadata.pm
diff -u loncom/metadata_database/LONCAPA/lonmetadata.pm:1.24 loncom/metadata_database/LONCAPA/lonmetadata.pm:1.25
--- loncom/metadata_database/LONCAPA/lonmetadata.pm:1.24	Fri Aug 17 20:32:05 2007
+++ loncom/metadata_database/LONCAPA/lonmetadata.pm	Fri Dec  7 17:31:08 2007
@@ -1,6 +1,6 @@
 # The LearningOnline Network with CAPA
 #
-# $Id: lonmetadata.pm,v 1.24 2007/08/18 00:32:05 albertel Exp $
+# $Id: lonmetadata.pm,v 1.25 2007/12/07 22:31:08 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -1183,8 +1183,8 @@
         if ($udom eq '' || $uname eq '' ) {
             $error = 'No domain and/or username specified';
         } else {
-            $delitem = 'domain = '.$dbh->quote($udom).' AND username = '.
-                       $dbh->quote($uname);
+            $delitem = 'domain = '.$dbh->quote($udom).' AND username '.
+                       'COLLATE latin1_general_cs = '.$dbh->quote($uname);
             $error=&delete_metadata($dbh,$newnames->{'allusers'},$delitem);
         }
         if (defined($error)) {