Database error - The frontend does not match Zabbix database

[sk3pp3r]

Hey,

I`m try to backup and restore Zabbix 2.4.7 to Zabbix 3.0.1.

after backup zabbix DB, and restore DB to new server i got error:

Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 2050001/2050001. Required mandatory version: 3000000. Contact your system administrator.

In Log file i see:
current database version (mandatory/optional): 02050001/02050001
required mandatory version: 03000000
starting automatic database upgrade
[Z3005] query failed: [1060] Duplicate column name 'lastlogsize' [alter table proxy_history add lastlogsize bigint unsigned default '0' not null]
database upgrade failed

restart MYSQL,ZABBIX and server not help ,

can anyone know how to solve this ?

[cvee.it]

I got the same issue on one of my Zabbix proxies.

My frontend database upgrade was successful, but that was going from centos 6 to centos 7 and then importing the database.

This proxy scenario, I am attempting to get a Centos 6.x to run Zabbix 3.0.3.

Mysql - 5.1.73.

I might just purge the DB since its a proxy..