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


Reply via email to