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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: 2.0.3rc1, 2.1.0
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Suse Linux Enterprise Server 10 SP 4 with mysql 5.0.26

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: