Zabbix doesnt recognize SQL tables

[chaky]

Zabbix 1.8 installed from source.
According to install instructions, I imported data.sql and mysql.sql.

When trying to start zabbix_server, i get the following in log:

30458:20100114:103245 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,i.delay_flex,h.dns from hosts h, items i where i.nextcheck<=1263457965 and i.status in (0) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1263457965 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=3 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*1 and h.hostid<=(100000000000000*1+99999999999999) order by i.nextcheck
30458:20100114:103245 Query failed:Unknown column 'i.nextcheck' in 'field list' [1054]
30458:20100114:103245 Query::select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1263457965 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0) and i.type not in (2,7,9) and mod(i.itemid,5)=3 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*1 and h.hostid<=(100000000000000*1+99999999999999)
30458:20100114:103245 Query failed:Unknown column 'nextcheck' in 'field list' [1054]

I tried to look up the tables mentioned in logs - and they really don't have such column 'nextcheck'

Did I miss something or did something wrong?

[ewnort]

Missing i.nextcheck

I am having a similar issue after upgrading to 1.8 from 1.6.5. I am connected to the database and can see my hosts, alerts, etc. I'm not getting information from my hosts and the "i.nextcheck" appears repeatedly in the server log.

I had a great deal of difficulty upgrading the database and had to run the scripts manually line-by-line. I don't think I missed any of the additional fields and didn't find any significant reference to this field in the scripts (either 1.6 or 1.8).

[ewnort]

SQL Errors After Upgrade

Just wanted to bump this issue. I'm faced with rebuilding my server if I can't get this resolved. Does anyone have any insight?

Thanks in advance.

[ewnort]

New install - same results

I exported my settings from the current version and downloaded and compiled version 1.8.1. I then blew away the old MySQL db and created a new one using the load scripts under ./create.

The same error detailed originally still exists! While I can see my configuration, I am not getting any poll information.

The error appears to be with a temp table given the syntax. That much I can decipher. As for the rest, I'm at a loss. Can anyone take a stab at it?

Thanks

[Alexei]

It looks like you are still running Zabbix Server 1.6.x! Please double-check that the binary is new, execute ./zabbix_server --help in order to retrieve binary version.

[ewnort]

Alexei,

Thanks for the reply and assistance. That was indeed the problem. The "make" function places the executables in /usr/local/sbin (on Ubuntu anyway) and they were being called from /usr/sbin. I made the change to the path and the error went away.

I don't see it enough in the forums, but I wanted to thank you for your work and support on this application. It really is fantastic.

Eric

[Alexei]

It's good to know the problem was resolved!

[ahahum]

Still stuck -

I had the same issue and verified that I was running the old 1.6.x binary still. Once this was corrected, I still get the errors in the log file.

zabbix@ubuntu:~/zabbix-1.8.1/misc/conf$ zabbix_server --v
Zabbix Server (daemon) v1.8.1 (revision 9702) (27 January 2010)
Compilation time: Mar 11 2010 09:19:39
zabbix@ubuntu:~/zabbix-1.8.1/misc/conf$


Are there any other suggestions for me to attempt to resolve this issue?

Thank you for your help!

Adam