[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 ...