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();
