zabbix-1.8.3 with mysql-4.1

[saenara]

Yes now you can start charging me with necrophilism, but really don't you think there are a lot of much more exotical cases within the unix world? ;-)

--- api/classes/class.chostgroup.php.orig       2011-01-21 14:52:03.000000000 +0300
+++ api/classes/class.chostgroup.php    2011-01-21 14:52:21.000000000 +0300
@@ -228,7 +228,7 @@
                        $sql_parts['from']['hosts'] = 'hosts h';
                        $sql_parts['where']['hgg'] = 'hg.groupid=g.groupid';
                        $sql_parts['where'][] = 'h.hostid=hg.hostid';
-                       $sql_parts['where'][] = 'NOT h.status IN ('.HOST_STATUS_PROXY_ACTIVE.','.HOST_STATUS_PROXY_PASSIVE.')';
+                       $sql_parts['where'][] = 'NOT (h.status IN ('.HOST_STATUS_PROXY_ACTIVE.','.HOST_STATUS_PROXY_PASSIVE.'))';
                }

 // with_items, with_monitored_items, with_historical_items