Groups adding unselected hosts

[Tom Elliott]

Please run in mysql:

DELETE FROM groupMembers WHERE gmHostID IN ('', '0', 0, null) OR gmGroupID IN ('', '0', 0, null);

[ITCC]

This post is deleted!

[ITCC]

This post is deleted!

[ITCC]

This post is deleted!

[ITCC]

ALL seems to be working now! even new groups so i don’t know what that was !
Thanks for the SQL to resolve the issue in the 1st place.

[ITCC]

OK - Got it.

If you have no groups existing then you can’t create a new one from the hosts search view. once you have 1 group, then you can.

[Tom Elliott]

@ITCC Not sure I follow what you mean here.

[ITCC]

@Tom-Elliott
If you don’t have any groups created then you can’t create one from the Host Management screen.

Selecting hosts and putting a name in the bottom then click “Process Group Changes”

[ITCC]

This has happened again.
Please advise to what is causing this.

[ITCC]

Can you advise on why this is happening and how i can resolve it forever?

[Tom Elliott]

@ITCC Please update to RC’s if you can?

I don’t know what’s causing it to create “false” entries in the database, though I cannot get it to replicate the problem in the current code I’m working with.