upgrade 1.8 to 2.0 corrupt table

[lupick]

Dear All

I'm upgrading my zabbix 1.8.13 to 2.0

the upgrade script hang as follow:
sh ./upgrade -uroot -p -Dzabbix
WARNING: backup your database before performing upgrade

This is an UNSUPPORTED Zabbix upgrade script from 1.8 to 2.0 for MySQL
It does the following things:
1. Updates indexes that might require changes;
2. Patches the database from 1.8 schema to 2.0 schema;
3. Adds 'Disabled' and 'Debug' usergroup if any missing;
4. Checks for hosts not belonging to any group and adds them to one if any found.

Usage: pass required MySQL parameters to this script (like database, user, password etc).

Continue ? (y/n) y
Patching the database
Enter password:
ERROR 1547 (HY000) at line 825: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted
Failed to patch Zabbix database. Restore from backup


can you help me??

thank you

L.

[coudy]

try this

https://support.zabbix.com/browse/ZBX-4729

[lupick]

I've solved using the following command:

mysql_upgrade -u <mysqluser> -p <pass>

thank you

L.