Can't delete Host from Group

[Polii123]

Hi

I just noticed that i can’t delete a host from a group. If i edit the group an go to Membership and click on remove selected Hosts nothing happens.

[Wolfbane8653]

Need version to see if this is already fixed in newest upgrade.

[Polii123]

Sorry tottaly forgot, 3797.

[Wolfbane8653]

Confirmed in r3795 also…

Thanks for reporting. Tom should get to it soon.

[Wayne Workman]

@Polii123 If you’re desperate and can’t wait: https://forums.fogproject.org/topic/5479/invalid-host-id-0-has-name-and-imageid-no-mac-address

[cml]

This ran in mysql will remove the hosts from the group. All you have to do is swap in your host and group names (leave the quotes).

I also advise always backing up before you make any mysql changes.

DELETE FROM groupMembers WHERE gmHostID = (SELECT hostId FROM hosts WHERE hostName="HOSTNAME") AND gmGroupID = (SELECT groupID FROM groups WHERE groupName="GROUPNAME");