Zabbix 2.0 don't start after upgrade from 1.8

[Tusha]

Zabbix server don't want to start after upgrade
He can't find some tables in PGSQL.
In upgrade sql file i can't find this tables

 
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column i.snmp_port does not exist
LINE 1: ...e,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.snmp_por...
                                                             ^
 [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.snmp_port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.status,i.authtype,i.username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999]
 26811:20120607:210659.266 server #4 started [poller #2]
 26808:20120607:210659.281 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "useip" does not exist
LINE 1: select hostid,proxy_hostid,host,useip,ip,dns,port,useipmi,ip...
                                        ^
 [select hostid,proxy_hostid,host,useip,ip,dns,port,useipmi,ipmi_ip,ipmi_port,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until,status from hosts where status in (0,5,6) and hostid between 000000000000000 and 099999999999999]

[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "unique_dcheckid" does not exist
LINE 1: select druleid,iprange,name,unique_dcheckid from drules wher...
                                    ^
 [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1339088819 or nextcheck>1339088819+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]

and 1 question in log:

26801:20120607:210655.982 Starting Zabbix Server. Zabbix 1.8.9 (revision 23398).
 26801:20120607:210655.982 ****** Enabled features ******
 26801:20120607:210655.982 SNMP monitoring:           YES
 26801:20120607:210655.982 IPMI monitoring:           YES
 26801:20120607:210655.982 WEB monitoring:            YES
 26801:20120607:210655.982 Jabber notifications:      YES
 26801:20120607:210655.982 Ez Texting notifications:  YES
 26801:20120607:210655.983 ODBC:                       NO
 26801:20120607:210655.983 SSH2 support:              YES
 26801:20120607:210655.983 IPv6 support:              YES
 26801:20120607:210655.983 ******************************

But

# zabbix_server -V
Zabbix server v2.0.0 (revision 27675) (21 May 2012)
Compilation time: Jun  7 2012 21:05:36

[MartinJanda]

I mean, you still run a binary file zabbix_server version 1.8.9. Look at the first line of the log file.