[zabbix-1.6.2pre] deleting template

[tekknokrat]

Using 1.6.2pre on ubuntu (updated from 1.6) with postgres-8.3
When I try to delete a template I get this errormessage:

2009-01-15 13:36:39 CET ERROR: operator does not exist: character varying = integer at character 78
2009-01-15 13:36:39 CET HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2009-01-15 13:36:39 CET STATEMENT: SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND (value IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: UPDATE actions SET status=1 WHERE (actionid IN (-1))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM conditions WHERE conditiontype=1 AND (value IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts_profiles WHERE (hostid IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts_profiles_ext WHERE (hostid IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: SELECT DISTINCT ht.* FROM httptest ht, applications ap WHERE (ap.hostid IN (10102)) AND ht.applicationid=ap.applicationid
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts WHERE (hostid IN (10102))


Someone a hint? As the dbscheme was created with origin sql file from 1.6.0 and I remember some changes meanwhile is there perhaps also some update of dbscheme neccessary?

[Aly]

No update is needed. This problem will be fixed in 1.6.2 release.

[tekknokrat]

thanks for fixing, that fast a fast one :)

[prote]

I use this thread for a similar problem: how can I delete templates? I searched the forum but can't find a way to do so.

I had exported the Template_Linux and made some changes (less items/triggers, bigger intervals, some graphs ...). After this I imported this new template - something is not right and I have to import it again. But how can I delete the old and not anymore needed templates?

Edit: I found it, sorry for my blindness :) Some options in Zabbix are tricky to find. Here is the solution to delete templates: under Configuration - > Hosts select Templates and as Group all and then you'll see all templates whit checkboxes and in the bottom two Delete-buttons ...