I was trying to upgrade zabbix from 1.8.8 to 2.0.6.
File name : /opt/zabbix-2.0.6/upgrades/dbpatches/2.0/mysql/patch.sql
I applied the mysql patch(patch.sql) to the existing mysql db and it failed with below error:
ERROR 1364 (HY000) at line 907: Field 'params' doesn't have a default value
I attached the same file with this request.
Could some one help me out?