Author: jfthomps Date: Wed Oct 26 17:01:17 2011 New Revision: 1189312 URL: http://svn.apache.org/viewvc?rev=1189312&view=rev Log: VCL-507 Deleted VMs appear in the list of unassigned VMs
modified vmhostdata - added 'c.deleted = 0' to where clause of query Modified: incubator/vcl/trunk/web/.ht-inc/vm.php Modified: incubator/vcl/trunk/web/.ht-inc/vm.php URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/web/.ht-inc/vm.php?rev=1189312&r1=1189311&r2=1189312&view=diff ============================================================================== --- incubator/vcl/trunk/web/.ht-inc/vm.php (original) +++ incubator/vcl/trunk/web/.ht-inc/vm.php Wed Oct 26 17:01:17 2011 @@ -325,7 +325,8 @@ function vmhostdata() { . "c.stateid = s.id AND " . "(vmhostid IS NULL OR " . "vmhostid NOT IN (SELECT id FROM vmhost) OR " - . "c.vmhostid = $vmhostid) " + . "c.vmhostid = $vmhostid) AND " + . "c.deleted = 0 " . "ORDER BY c.hostname"; $qh = doQuery($query, 101); $ids = array();