Unknown column 'i.lastvalue' in 'where clause'

[costyn]

Hello everyone,

We recently upgraded from 2.0.x to 2.2.3, but now we get the following error message on Latest Data (see attachment).

I have searched with Google and here on the forums but the only thing I could find was that apparently the lastvalue column has moved from one table to another?

Can anyone help me out?

Thanks!

Costyn.

[aib]

Did you do your Upgrade procedure correctly?

https://www.zabbix.com/documentation/2.2/manual/installation/upgrade

[costyn]

Hi Aleksey,

Thanks for the reply. Yes, we followed the update procedure. We had an issue where during the database upgrade it failed, I got the message

Can't DROP 'value_changed'; check that column/key exists [alter table events drop column value_changed]"

which is documented in this bug: https://support.zabbix.com/browse/ZBX-7722

Another post I found suggested creating this column in the table so the database update script could delete it. That worked:

alter table events add value_changed int;

After this the upgrade progress messages showed:
16966:20140516:152356.456 completed 100% of database upgrade
16966:20140516:152356.456 database upgrade fully completed

Unfortunately it looks like there's still some issues.

Any pointers are appreciated.

Kind regards

Costyn.