cannot delete a host via gui or mysql

[TASSA]

Hello guys im newbie
and i cannot delete some hosts from my zabbix Gui
no matter what i do like removing the host from the template or changgng ip.. nothings hels , stop start service and ext.....
i finnly tried via the sql database but it also fails
And gives error

please help
Tia
Tal

SQL
this is the host
mysql> SELECT host FROM hosts where host ='1.1.1.1';
+---------+
| host |
+---------+
| 1.1.1.1 |
+---------+
1 row in set (0.00 sec)


this is the unsusscful deletion

mysql> delete host FROM hosts where host ='1.1.1.1';
ERROR 1109 (42S02): Unknown table 'host' in MULTI DELETE
mysql>

[gleepwurp]

Hello!


Never, ever, delete something directly from the database...

Removing a host from a template does not delete the host, simply removes the hosts' association to a monitoring template.

If you want to delete a host, go to Configuration --> Hosts, then use the checkmark to the right of the host you want to delete, and go down to the Dropdown box at the bottom-left of your screen, select "Delete Selected" and click "Go".


You could also search for your host by using the search box at the right of the screen, and clicking on the hostname will take you to the host configuration screen. At the bottom of that screen, there is a "Delete" button.

You can find the Zabbix Documentation here: https://www.zabbix.com/documentation/2.4/

G.