Cannot delete hosts "" because maintenance "exch" must contain at least one host...

[leon.vinther]

Upgrade from 5.0.25 to 6.2 and after my upgrade I decided to cleanup my maintenance jobs, so I deleted all of them to make new ones.

After I deleted the jobs I can no longer delete hosts from "Maintenance"->"Hosts"

All I get is the message in the topic.

I have check the tables below and they are empty.

"
select * from maintenances;
Empty set (0.000 sec)

select * from maintenances_groups;
Empty set (0.000 sec)
"

Anyone idea on how to correct this, so I can delete hosts again?

Best Regards,
Leon

[vladimir_lv]

After I deleted the jobs I can no longer delete hosts from "Maintenance"->"Hosts"

Did you mean Configuration->Hosts ?
Check these hosts using the query:

 select * from maintenances_hosts;

[leon.vinther]

I used phpMyAdmin to run the selection and it returned an empty result.

SELECT * FROM `maintenances_hosts`
"MySQL returnerede ingen data (fx ingen rækker). (Forespørgsel tog 0.0003 sekunder.)"

I looked through all of the maintenances tables and they are all empty.

[vladimir_lv]

Use debug features of the frontend and you will see the queries when you try to delete the host.

[vladimir_lv]

Check this:

select maintenanceid, maintenance_status, maintenance_type, maintenance_from from hosts where hostid= YOUR_HOST_ID;

and then clear these columns for discovered hosts.

[leon.vinther]

I get the following result: