Zabbix 1.1.2 crashing on startup

[neilmiller]

Greetings,

I'm using Ubuntu 6.06. On my machine, Zabbix is crashing right on startup:

/usr/bin/zabbix_server --version
ZABBIX Server (daemon) v1.1.2 (19 July 2006)
Compilation time: Oct 16 2006 11:25:33

cat /var/log/zabbix/server.log
...
029492:20061016:115047 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where i.nextcheck<=1160992247 and i.status in (0,3) and i.type not in (2,7) and h.status=0 and h.disable_until<=1160992247 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,6)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
029492:20061016:115047 Query failed:Unknown column 'h.errors_from' in 'field list' [1054]
029505:20061016:115047 server #11 started [Trapper]
029478:20061016:115047 One server process died. Shutting down...
029478:20061016:115047 ZABBIX server is down.

mysqlcheck -uroot -p zabbix
Enter password:
zabbix.acknowledges OK
zabbix.actions OK
zabbix.alarms OK
zabbix.alerts OK
zabbix.applications OK
zabbix.auditlog OK
zabbix.autoreg OK
zabbix.conditions OK
zabbix.config OK
zabbix.functions OK
zabbix.graphs OK
zabbix.graphs_items OK
zabbix.groups OK
zabbix.help_items OK
zabbix.history OK
zabbix.history_log OK
zabbix.history_str OK
zabbix.history_text OK
zabbix.history_uint OK
zabbix.hosts OK
zabbix.hosts_groups OK
zabbix.hosts_profiles OK
zabbix.hosts_templates OK
zabbix.housekeeper OK
zabbix.images OK
zabbix.items OK
zabbix.items_applications OK
zabbix.mappings OK
zabbix.media OK
zabbix.media_type OK
zabbix.profiles OK
zabbix.rights OK
zabbix.screens OK
zabbix.screens_items OK
zabbix.service_alarms OK
zabbix.services OK
zabbix.services_links OK
zabbix.sessions OK
zabbix.sysmaps OK
zabbix.sysmaps_elements OK
zabbix.sysmaps_links OK
zabbix.trends OK
zabbix.trigger_depends OK
zabbix.triggers OK
zabbix.users OK
zabbix.users_groups OK
zabbix.usrgrp OK
zabbix.valuemaps OK

I'm out of ideas. Anyone got a suggestion?

[cadbury]

seems to be mysql error, verify that the colomn "errors_from" exists in the table "hosts" ?

no other clue sorry

[rootlinux]

try myisamchk