Problems after switching to 1.6.1

[stalker]

Now in logs on master node i see this errors for every node:

 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010042
 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010043
 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010044
 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010045
 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010046
 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010047
 22175:20081110:183204 Query failed:Unknown column 'hosts_groups' in 'field list' [1054]
 22175:20081110:183204 Query::select hosts_groups,length(hosts_groups),hostid,length(hostid),groupid,length(groupid),hosts_profiles,length(hosts_profiles) from hosts where hostid=200200000010048

In database schema in table hosts column hosts_groups does not present. What wrong?

[fast.ryder]

Database needs patching

Hello!

You have to patch your database since you must have upgraded to a much more recent version of Zabbix.

Or maybe you, like me, compiled the wrong source code (trunk, wich is 1.7 and not 1.6) and are trying to run on an unsupported database schema (happens to the best... and the most distracted! )

Cheers,

Ivo Pereira
IT COnsultant
Portugal

[fcmt]

Hi,

I've same error message after upgarded from 1.6 to 1.6.1
Do I need to run the db patch again for 1.6 to 1.6.1?

Anyone can help?

Thanks
Frankie

[Tenzer]

Do I need to run the db patch again for 1.6 to 1.6.1?

No, please see the "Upgrading" section of the release notes: http://www.zabbix.com/forum/showthread.php?t=11018

[fcmt]

Thanks for ur reply.
But how can I solve that error message?

Thanks