vm guest relation to host

[Frank]

The source for this problem relies in an sql-statement and code which expects only one result with a hostname, in my situation an empty one or an old esx-host. So I modified

[code]plugins/main_sections/ms_computer/ms_computer.php[/code] in line 205 from

[code]$sqlVM = "select vm.hardware_id,vm.vmtype, h.name from virtualmachines vm left join hardware h on vm.hardware_id=h.id where vm.uuid='%s'";[/code]

to

[code]$sqlVM = "select vm.hardware_id,vm.vmtype, h.name from virtualmachines vm left join hardware h on vm.hardware_id=h.id where
 vm.uuid='%s'order by h.name DESC";[/code]

Hope this helps.