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

Errors in zabbix-2.0.2/upgrades/dbpatches/2.0/mysql/patch.sql

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.0.3rc1, 2.1.0
    • 2.0.2
    • Server (S)
    • Suse Linux Enterprise Server 10 SP 4 with mysql 5.0.26

      During run of patch script I get the following error:
      ERROR 1064 (42000) at line 1535: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
      Failed to patch Zabbix database. Restore from backup
      I've fixed this as follows:
      fdl117:/home/zabbix/zabbix-2.0.2/upgrades/dbpatches/2.0/mysql # diff patch.sql patch.sql.wk
      1535c1535
      < CALL zbx_convert_operations();

      > CALL zbx_convert_operations;

      I've also noticed that this typo is not present in de v2.0.1 patch.sql script.

            Unassigned Unassigned
            gdhux Unix Beheer
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: