Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6831

upgrade zabbix from 1.8.8 to 2.0.6 failed with mysql errors

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.8rc1, 2.1.2
    • Component/s: None
    • Labels:

      Description

      Hi,

      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?

      Thanks
      Sugun

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            sugun123 sugun
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: